DBCC CLONEDATABASE and sensitive data

Just over 2 months ago Service Pack 2 for SQL server 2014 was released. Included in this Service Pack is a new DBCC command, DBCC CLONEDATABASE. As the name suggest this command can be used to make a clone of your user database without the table data. Instead it creates a schema and statistics only […]

SQL Server Management Studio Preview

You may have heard that SQL Server Management Studio (SSMS) is now available as a stand-alone installation package outside of the SQL Server setup (as a preview version). With the release of SQL Server 2016 RC0, Microsoft decided to cut the cords with SQL Server Management Studio as it has been removed from the SQL […]

Your presentation matters! Do it right!

This weekend I was invited over at SQLSaturday Oslo to speak about SQL Server Indexing. I ran into Boris Hristov there and we ended up in a discussion about presentation design, and how it plays a huge role in getting your message across to your audience. As a speaker myself, I couldn’t agree more. The […]

SQL Server 2016 Live Query Statistics

So now that SQL Server 2016 CTP2 is released to the public we can all finally play with all the new features inside SQL Server 2016. You can download SQL Server 2016 CTP2 here: //www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2016 While I was playing around with all the new features inside SQL Server 2016 (especially Query Store, and some new […]

Announcing Pro SQL Server Wait Statistics

I am very proud to officially announce my first ever SQL Server related book, Pro SQL Server Wait Statistics! As the title suggests, it is a book dedicated to one of my favorite SQL Server topics, Wait Statistics. Inside the book I will go into great detail on how Wait Statistics are generated, how to […]

Hangout with Boris Hristov

A couple of days ago I had the great pleasure to join Boris Hristov in one of his awesome SQL Hangouts! This was hangout number 30 (!!) he recorded and it is now available to watch over at his blog: //t.co/wNwiA6t0QP. We talked about how life is for DBA’s working in the healthcare industry and […]

Looking back on 2014

When a new year comes around it is always a great time to reflect on the previous year. 2014 was a very special year for me, a lot of great stuff happened and I had some great chances to meet new people and travel! First of all, 2014 was the year when I received my […]

Video articles

While thinking of ways to improve the way I can get SQL Server information across to those who follow my blog or read my articles, I came up with a new feature: video articles! Reading an article on the internet is a great way to learn, but viewing or listening to that article in video/audio […]

SQL Server column encryption

We use databases to store a lot of information. This can also include sensitive information we don’t want to give everyone access to. While we can use permission or views to ‘hide’ our sensitive information it will still be stored as plain text in our table. We can use column encryption to encrypt that sensitive […]