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.
Database Administration & Monitoring, SQL Server, Technology Survey SQL Server Security: Are your databases ready for the GDPR? 04.05.2018 by Stéphane Haby 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(…)
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(…)
Database Administration & Monitoring, Development & Performance, Technology Survey SQL Server 2017: TRIM not only a replacement of RTRIM and LTRIM 04.01.2018 by Stéphane Haby 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:(…)
Database Administration & Monitoring, SQL Server SQL Server Tips: an orphan user owns a database role 08.12.2017 by Stéphane Haby 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(…)
Database Administration & Monitoring, Database management, SQL Server SQL Server Tips: Deactivate the Customer Experience Improvement Program (CEIP) 07.11.2017 by Stéphane Haby 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(…)
Database Administration & Monitoring, Database management, SQL Server SQL Server 2017 RTM is available: time to try! 03.10.2017 by Stéphane Haby 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(…)
Database Administration & Monitoring, Database management SQL Server 2016: New Dynamic Management Views (DMVs) 29.09.2017 by Stéphane Haby 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(…)
Technology Survey One-day workshop with Slava Oks for SQL Server on Linux 13.07.2017 by Stéphane Haby 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(…)