Infrastructure at your Service

Category Archives: SQL Server

David Barbarin

SQL Saturday Paris 2018 – Pré-conférence SQL Server Linux, Docker et Azure

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

The next SQL Saturday in Paris is coming soon and the agenda has been published by the @GUSS on twitter. Le prochain SQL Saturday Paris arrive bientôt et l’agenda a été publié sur Twitter par le @GUSS Cette année, un savant mélange de speakers francophones et internationaux, un plus pour les participants … Un rapide coup d’œil à l’agenda – si on se focalise sur la partie moteur SQL Server – montre également qu’une bonne…

 
Read More
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 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
David Barbarin

SQL Server on Linux: Introduction to DBFS experimental tool

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

A couple of months ago, Microsoft announced two additional command line tools for SQL Server that are mssql-scripter and DBFS. The latter has drawn my attention because it exposes live data from SQL Server DMVs as virtual files in a virtual directory on Linux operating system. Microsoft has probably taken another positive step in the SQL Server’s adoption on Linux. Indeed, in a Linux world, we may get Kernel’s performance and configuration data either directly…

 
Read More
David Barbarin

24 HOP French edition 2017 – Session videos are available

By | SQL Server, Technology Survey | No Comments

The 2nd edition of 24HOP French Edition 2017 is over and we had great sessions about SQL Server and various topics ( SQL Server 2017 new features, Azure, PowerBI, High Availability , Linux, Hyper-convergence , Modeling …) If you did not attend to this event, you now have the opportunity to watch the videos of the different sessions. From my side, I had the chance to present SQL Server and High Availability on Linux. Hope to…

 
Read More