SQL Server

Moving tables ONLINE on filegroup with constraints and LOB data

Let’s start this new week by going back to a discussion with one of my customers a couple of days ago about moving several tables into different filegroups. Let’s say that some of them contained LOB data. Let’s add to the game another customer requirement: moving all of them ONLINE(…)

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

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:(…)

Experiencing update statistics on a big table with circuitous ways

This is my first blog of this new year and since a while by the way. Indeed, last year, I put all my energy to realign my Linux skills with the new Microsoft’s strategy that opens SQL Server to Open(…)

SQL Server Tips: an orphan user owns a database role

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(…)

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

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(…)

Pass Summit 2017: how to bypass SQL Server security

Last Friday I saw a very interesting session in Pass Summit 2017 about how to Bypass, or Ensure, SQL Server security by Matt Martin. Matt explained us how to bypass SQL Server security with the complicity of your SQL(…)

Pass Summit 2017

Today starts the Pass Summit 2017 taking place in Seattle. After a small fly over the Ocean, more than 10 hours… yesterday, and a nice jet lag which avoid me to sleep later than 4AM this morning, I arrived(…)

PASS SUMMIT 2017 – SQL Server Security

Today is the first day of the PASS SUMMIT 2017 in Seattle (WA). The weather is cloudy and we have only 11°C… but where is the problem? Everything happens inside! (at the Convention(…)

SQL Server 2017 RTM is available: time to try!

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(…)

SQL Server 2016: New Dynamic Management Views (DMVs)

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(…)