Stéphane Haby

SQL Server Tips: Logical names don’t match with physical files names

During a copy of a database from an environment to another (from Production to pre-production for instance), people usually don’t changed the logical name of the data or log files when they rename the database and the physical file names.

SQL Server 2016: native support for JSON

A lot of discussions and most important, a feature requests in the Microsoft connect site here with more than 1000 votes is the origin of this new feature in SQL Server 2016. A lot of NoSQL have already this function(…)

SQL Server Tips: How to know if In-Memory Feature is supported by your server?

A customer asks me, how to know if In-Memory Feature is supported by my SQL Server server? An easy way is to check the edition, version etc. but now, you have directly a property for that. On msdn(…)

Azure DocumentD8: Microsoft goes to NoSQL

Azure DocumentDB is a documentary database service and as like its name suggests, it is aMicrosoft Azure Cloud service. Since the last summer, developers have access to this new service, and now it is available(…)

SQL Server – Change Management: list all updates

I am looking to have all SQL Server updates on a server including Service Packs, Cumulative Updates and other fixes like we can see in the uninstall panel from Windows. I take the opportunity of this(…)

Security via policies

Few weeks ago, I presented the session on security via Policies for “Les journées SQL Server 2014”, organized by the French SQL Server User Group (GUSS) in Paris. I promised to post our policies script(…)

SQL Server tips: how to list orphaned logins

I read a lot of about orphaned database users in SQL Server, but I have almost never read about orphaned logins. Many of my customers migrate or remove databases in SQL Server. They forget – not every time but(…)

SQL Server tips: Executing a query with the EXECUTE command

This short SQL Server blog post is meant to help people who have experienced the error messages 2812 and 203 with the EXECUTE command. The goal is to execute a simple query from a variable in a string(…)

Windows 10: The new features

First, it should have been Windows 9, but finally the new Microsoft operating system is named Windows 10! In the same way as for my blog post on Windows 8, I have decided to write a few words(…)

SQL Server 2014 Tips: Create indexes directly via CREATE TABLE

This week, I discovered a new enhancement which is not hidden but not really visible in SQL Server 2014. Among Hekaton and other new features in SQL Server 2014, a little option appears in table creation.8-O On the(…)