Infrastructure at your Service

All posts by Stéphane Haby

Stéphane Haby
Delivery Manager
Senior Consultant
Stéphane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. Stéphane Haby is Microsoft Most Valuable Professional (MVP) as well as Microsoft Certified Solutions Associate (MCSA) and Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals & Pharmaceuticals, Banking / Financial Services, and many other industries.
Stéphane Haby

SP2 for SQL Server 2016 is available with new helpful DMVs

By | Database Administration & Monitoring, Development & Performance, SQL Server, Technology Survey | No Comments

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. In this article, I will just write few words about 2 DMVs (sys.dm_db_log_stats & sys.dm_db_log_info) and a new column (modified_extent_page_count) in the DMV sys.dm_db_file_space_usage that I presented during our last event about SQL Server 2017. I think they are really helpful for DBA. It’s also…

 
Read More
Stéphane Haby

SQL Server Security: Are your databases ready for the GDPR?

By | Database Administration & Monitoring, SQL Server, Technology Survey | No Comments

The GDRP (General Data Protection Regulation), voted in 2016, will be applied in the European Union soon (May 25, 2018). We heard a lot of this new directive. The goal is to improve the protection and confidentiality of personally identifiable information for every European citizen. Quid of Switzerland? Read the article of Gregory here. A personal data is information that identifies a natural person, directly or indirectly. It can be a name, a photograph, an…

 
Read More
Stéphane Haby

SQL Server 2017: Can I run a “standard” rebuild on the index after a Resumable Online Index Rebuild is suspended?

By | Database Administration & Monitoring, Development & Performance, SQL Server, Technology Survey | No Comments

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?” The goal is to see after I suspend the rebuild, if I can run a traditional rebuild without the option RESUME.   I start an index rebuild with the option Resumable: ALTER INDEX [NCI_dbo_Transaction] ON [dbo].[Transaction] REBUILD WITH (RESUMABLE = ON, ONLINE = ON) GO   In a new query window,…

 
Read More
Stéphane Haby

SQL Server 2017: What’s happens with an interruption during a Resumable Online Index Rebuild?

By | Database Administration & Monitoring, Development & Performance, SQL Server, Technology Survey | No Comments

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 Online Index Rebuild? I was not able to answer because I forgot to do this test. The new enhancement for an index rebuild provides the capability to suspend, resume or abort an online index operation (msdn reference). I always use…

 
Read More
Stéphane Haby

SQL Server 2017: TRIM not only a replacement of RTRIM and LTRIM

By | Database Administration & Monitoring, Development & Performance, Technology Survey | 4 Comments

Last month, I present in the IT-Tage 2017 in Frankfurt am Main, a session about SQL Server 2017 overview. During my session I made a demo on one of the new string T-SQL Commands: TRIM. My demo was very simple but I have also 2 very good questions. Before, I write about these question, I will show you what is TRIM. This function is a replacement of RTRIM and LTRIM to delete all space character…

 
Read More
Stéphane Haby

SQL Server Tips: an orphan user owns a database role

By | Database Administration & Monitoring, SQL Server | No Comments

A few days ago, I conduct an audit to detect all orphan’s windows accounts in a database and I was surprise to have an error during the drop user query.   The first step is to find all orphan’s windows accounts in a database USE [dbi_database] GO /*Step1: Search the orphan user */ SELECT * FROM sys.database_principals a LEFT OUTER JOIN sys.server_principals b ON a.sid = b.sid WHERE b.sid IS NULL AND a.type In (‘U’,…

 
Read More
Stéphane Haby

SQL Server Tips: Deactivate the Customer Experience Improvement Program (CEIP)

By | Database Administration & Monitoring, Database management, SQL Server | No Comments

Before SQL Server 2016, you had the possibility to check the case “Send Windows and SQL Server Error Reports….” during the installation if you want to be a part of the Customer Experience Improvement Program (CEIP). In SQL Server 2016, after the installation, all of the CEIP are automatically turned on. Why? SQL Server and SQL Azure share the same code now. On Azure, this service existed since a long time. It collects a large…

 
Read More
Stéphane Haby

SQL Server 2017 RTM is available: time to try!

By | Database Administration & Monitoring, Database management, SQL Server | No Comments

Now SQL Server 2017 RTM  is available. The first step is to go to the Evaluation Center here After completing the registration with your contact information, you download the file “SQL Server 2017-SSEI-Eval.exe” Run SQL Server 2017-SSEI-Eval.exe and now it begins! A first screen gives me 3 choices to install SQL Server Basic: easy and fast to download and install SQL Server 2017 Custom: Download the setup package and launch the SQL Installation Center Download…

 
Read More
Stéphane Haby

SQL Server 2016: New Dynamic Management Views (DMVs)

By | Database Administration & Monitoring, Database management | No Comments

In SQL Server 2016, you will discover a lot of new Dynamic Management Views(DMVs). In this article, I will just give you a little overview of these useful views for us as DBA. SQL Server 2012 has 145 DMVs and SQL Server 2014 has 166 DMVs. Now, SQL Server 2016 has 185 DMVs. How to see it? It is very easy to have a look using the sys.all_objects view: SELECT * FROM sys.all_objects WHERE TYPE=’V’…

 
Read More
Stéphane Haby

One-day workshop with Slava Oks for SQL Server on Linux

By | Technology Survey | No Comments

Few weeks ago, David Barbarin and I went to the Tugar IT  in Lisbon to follow the workshop from Slava Oks: Bringing SQL Server to Linux: Experience It was a deep dive into the code of SQL Server and Slava shows us how they achieve a universal platform regardless the operating system. On my mind, the challenge was how to deal with the Windows operating system dependencies that include all Win32/ NT Kernel calls and…

 
Read More