SQL Server 2016 SP1: DBCC CLONEDATABASE now with Query Store data!

SQL Server 20016 SP1 is released today and it introduces a truck load of new features and options. Even better,...

SQL Server 2016 SP1 is Now Available

In the Business Intelligence and reporting space, SQL Server 2016 was a big step forward.  Aside from significant relational engine...

SQL Server 2016 SP1 removes the editions’ programming feature limits! Everything from Always Encrypted to XTP/In-memory for everybody!

SQL Server 2016 SP1 entfernt Programmier-Feature-Limits der Editionen! Alles von Always Encrypted bis XTP: In-Memory für Alle!

Unglaubliche Neuigkeiten, anders kann man es gar nicht sagen:
Mit dem heute erschienenen Service...

SQL Server 2016 SP1 removes the editions’ programming feature limits! Everything from Always Encrypted to XTP/In-memory for everybody!

SQL Server 2016 SP1 entfernt Programmier-Feature-Limits der Editionen! Alles von Always Encrypted bis XTP: In-Memory für Alle!
Unglaubliche Neuigkeiten, anders kann...

SQL Server 2016 Service Pack 1 Changes Everything

Earlier today, Microsoft announced the release of Service Pack 1 (SP1) for SQL Server 2016. Pay close attention to this...

Persisting DBCC output data

Most of the DBCC commands return their results as textual output, even if you have SSMS configured to return result...

This Week in Data – Episode 13 (Building Your Personal Brand)

Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them...

SQL Server 2016 Service Pack 1 – What’s New

With the release of the most epic Service Pack 1 for SQL Server 2016, the biggest attention of everyone should...

SQL Server 2016 SP1 – Programmability Surface for everyone!

This is the most important blog post about SQL Server that I have ever written. As far as I am...

DLM Automation–Making a Database Connection

One of the things I’ve been wanting to do is dig more into the command line automation cmdlets from the...