Big Data, Business Intelligence, Cloud, Database Administration & Monitoring, Development & Performance Pass summit – day 4 09.11.2018 by Christophe Cosme Optimizing Multi-Billion Row Tables in Tabular in 2018 I wanted to attend the session moderated by Marco Russo to see his approach of optimizing performance in Tabular model The first thing to understand is how the data is(…)
Development & Performance, Enterprise content management A SQLite extension for gawk (part II) 28.09.2018 by Oracle Team Welcome to part II of a three-part article on extending gawk with a SQLite binding. Part I is here. Part II is followed by(…)
Development & Performance, Enterprise content management An SQLite extension for gawk (part I) 28.09.2018 by Oracle Team Quick: what is the most used database management system on our planet ? Oracle ? Wrong. SQL server ? Wrong again ! MySQL ? You’re almost there. It’s SQLite. Surprised ? I must confess that I was too. Actually, SQLite(…)
Database management, Development & Performance, SQL Server SQL Server Tips: How many different datetime are in my column and what the delta? 31.08.2018 by Stéphane Haby Few months ago, a customer asks me for finding in a column, how many rows exist with the same date & time and the delta between them. The column default value is based on the function(…)
Database management, Development & Performance, SQL Server SQL Server on Linux – I/O internal thoughts 24.07.2018 by Microsoft Team Let’s start the story from the beginning with some funny testing I tried to perform with SQL Server on Linux a couple of months ago. At that time, I wanted to get some pictures of syscalls from SQL Server as(…)
Database Administration & Monitoring, Database management, Development & Performance How to fix your own SQL plan in Oracle ? 18.06.2018 by Oracle Team Method to build and fix your own SQL plans in Oracle and then you want to fix it for all next executions of the SQL by your application (thanks to SPM). In this post I show how fix a plan(…)
Database Administration & Monitoring, Development & Performance, SQL Server, Technology Survey SP2 for SQL Server 2016 is available with new helpful DMVs 11.05.2018 by Stéphane Haby Last month (April 24, 2018), the Service Pack 2 for SQL Server 2016 was released and distributed. This Service Pack has new DMVs, already available in SQL Server 2017 RTM.
Big Data, Cloud, Development & Performance Deploy a Cloudera cluster with Terraform and Ansible in Azure – part 2 02.05.2018 by DevOps In this part of the blog posts series, we will show how ansible helps us to configure our cluster and install all pre-requisite needed for Cloudera Manager. Ansible is one of the most important automation tools currently. Ansible will help(…)
Database Administration & Monitoring, Development & Performance, SQL Server, Technology Survey SQL Server 2017: Can I run a “standard” rebuild on the index after a Resumable Online Index Rebuild is suspended? 20.03.2018 by Stéphane Haby This article is an additional article to my precedent about “SQL Server 2017: What’s happens with an interruption during a Resumable Online Index Rebuild?”(…)
Database Administration & Monitoring, Development & Performance, SQL Server, Technology Survey SQL Server 2017: What’s happens with an interruption during a Resumable Online Index Rebuild? 20.03.2018 by Stéphane Haby Last week, I presented this option in our internal event, the dbi xChange. My colleague David Barbarin asked me this question, what’s append if an interruption occurs (reboot, SQL Server service stopped,…) during a Resumable(…)