Stéphane Haby

SQL Server 2016: R Services

I was during a long time captivated by the R programming language. I’m happy to see that SQL Server 2016 provides now a SQL Server R Services. This service enables SQL Server to execute R scripts. The first(…)

SQL Server 2016: CREATE TABLE for Stretch Database is available

This month, the Release Candidate 1 (RC1) for SQL Server is available. With this new version, you can now use the “CREATE TABLE” command for Stretch Databases. If you read the msdn page(…)

SQL Server 2016: new upgrade advisor

I write this article because it is very interesting to see that the upgrade advisor has evolved… Recently (February 11, 2016), a new version is available: Microsoft® SQL Server 2016® Upgrade Advisor Preview 1.4 The msi package(…)

SQL Server Tips: Find sql logins when “windows authentication only” is enabled

A customer asks me to find all sql logins enabled on servers where windows authentication only is enabled. The goal is to clean sql logins on all servers through the CMS (central management server). In some cases, sql logins are(…)

SQL Server Tips: Default trace enabled but no file is active…

I discover a strange error with a customer about the default trace. As you know, SQL Server has a default trace with a lot of events like the data and log file growth. This trace is enabled by default and(…)

SQL Server 2016: temporal table with In-Memory

In SQL Server 2016 CTP 3.0, temporal tables with In-Memory OLTP is supported. 🙂 At the JSS2015 (Journée SQL Server 2015), I have presented a little demo about temporal table with a table(…)

Journées SQL Server 2015: Retrouvez nos sessions sur SlideShare et Youtube!

Avant de partir pour des vacances bien méritées et une année pleine d’aventures sur SQL Server, je fais un dernier petit article pour vous informer que nos sessions des Journées SQL Server 2015 sont disponible sur SlideShare et(…)

Delete an orphan user-database under SSISDB

I post a little tips for orphan database-users that we cannot drop so easily in the SSISDB… I discovered this by a customer and it was very tricky to find the explanation and the solution. This is the reason why(…)

SQL Server 2016: new T-SQL commands COMPRESS and DECOMPRESS

In live from the JSS2015 (Journée SQL Server 2015) in Paris, we saw that the CTP3.1 has been available in the night of these 2 days. One new feature available for this release in the T-SQL(…)

SQL Server Extended Event: Eine Deadlock-Event aus der “system_health” Überwachung

Wie Sie vielleicht wissen, gibt es eine Überwachung über Extended Events: system_health. Kürzlich fragt mich ein Kunde an, um ein zufälliges Deadlock-Problem zu analysieren...