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… Read more
In the previous article in this blog series I told you my plans of expending my horizons towards the Data Science field. As I noted in that article my first steps towards Data Science consists of getting my math knowledge up-to-date again on math areas like linear algebra and matrices. Read more
As an IT professional we are used to spending a lot of time learning about new technologies or how we can improve our knowledge on the products we work with. For more than 10 years now I have been working with SQL Server and still continue to learn new things… Read more
In March the CSS SQL Server Engineers started to blog about various new enhancements made to the SQL Server Engine in SQL Server 2016. Even though these performance enhancements don’t get as much attention as the big new features introduced in SQL Server 2016 (like Query Store), they can play… Read more
With the February release of the SQL Server Management Studio (SSMS) Preview Microsoft introduced a nice new tool inside SSMS, the Plan Comparison Tool.
Like the name suggests, the tool makes it possible for you to compare different plans inside SSMS, but it doesn’t stop there. Microsoft also managed to… Read more
From the 4th till the 7th of May 2016 one of the biggest SQL Server conference in the world will be in Liverpool promising four days of great SQL Server sessions and training. Just take a look at the agenda to be blown away by the amount of… Read more
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… Read more
As you probably know I am very fond of SQL Server Wait Statistics (shameless book link) and the options they provide for analyzing SQL Server performance. During SQL Server version releases new options became available to monitor and/or analyze Wait Statistics but one option for Wait Statistics analysis… Read more
Pro SQL Server Wait Statistics is available in a variety of different formats, including ePub, Kindle and paperback… Read more
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,… Read more
August and September are going to be some busy weeks!
In those two months I will be speaking on three SQLSaturday events:
- SQLSaturday #414 Oslo – 29th of August
Efficient Indexing Strategies (level 100)
- SQLSaturday #411 Cambridge – 12th of September
Efficient Indexing Strategies (level 100)
- SQLSaturday #434 Holland –…
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: https://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… Read more
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… Read more
On April 18 2015 I will be speaking at SQLSaturday #376 in Budapest!
I will be speaking about one of my favorite SQL Server topics, Wait Statistics.
If you plan on attending SQLSaturday Budest and want to learn more about SQL Server Scheduling and resource waits, come visit my session! Read more
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: http://t.co/wNwiA6t0QP.
We talked about how life is for DBA’s… Read more
In part 1 of the In-memory OLTP articles we gave you an introduction into In-memory OLTP, showing what the requirements are, the limitations and a quick look at the Advisors.
In this article we are going to dive a little deeper into a large portion of In-memory OLTP: Memory-Optimized (or… Read more
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… Read more
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… Read more
SQL Server 2014 introduced probably one of the biggest changes to the SQL Server engine since years, “In-memory OLTP” (or Hekaton). In-memory OLTP lets you move tables from your traditional, disk based, storage and moves them directly into the memory (RAM) of your SQL Server instance. Traditional storage throughput and… Read more
It has been a pretty long time since my last blog post but with good reason!