Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

DotNine SQL Server and more

I am a database specialist from the Netherland with my main focus on Microsoft SQL Server. My IT career began 14 years ago as a System Administrator. I have been working with SQL Server for more then 10 years now and a full time DBA for 5 years.

Pro SQL Server Wait Statistics available now!

Remember that blog post from April this year that I announced working on my first ever SQL Server related book “Pro SQL Server Wait Statistics”? Well good news, it is available now!

Pro SQL Server Wait Statistics is available in a variety of different formats, including ePub, Kindle and paperback… Read more

0 comments, 122 reads

Posted in DotNine SQL Server and more on 2 September 2015

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,… Read more

0 comments, 92 reads

Posted in DotNine SQL Server and more on 31 August 2015

Speaking engagements for August and September

August and September are going to be some busy weeks!
In those two months I will be speaking on three SQLSaturday events:

Read more

0 comments, 154 reads

Posted in DotNine SQL Server and more on 3 July 2015

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: 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

1 comments, 920 reads

Posted in DotNine SQL Server and more on 28 May 2015

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… Read more

0 comments, 187 reads

Posted in DotNine SQL Server and more on 14 April 2015

Speaking at SQLSaturday 376 Budapest

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

0 comments, 144 reads

Posted in DotNine SQL Server and more on 23 March 2015

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: http://t.co/wNwiA6t0QP.

We talked about how life is for DBA’s… Read more

0 comments, 175 reads

Posted in DotNine SQL Server and more on 17 January 2015

In-Memory OLTP Part 2 : Memory-Optimized tables

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

0 comments, 614 reads

Posted in DotNine SQL Server and more on 11 January 2015

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… Read more

0 comments, 149 reads

Posted in DotNine SQL Server and more on 6 January 2015

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… Read more

0 comments, 240 reads

Posted in DotNine SQL Server and more on 30 November 2014

In-memory OLTP Part 1: Introduction to In-memory OLTP

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

3 comments, 6,525 reads

Posted in DotNine SQL Server and more on 21 November 2014

Busy times

It has been a pretty long time since my last blog post but with good reason!

The last month and a half I have been spending time on some great SQL Server events like SQLSaturday Holland and SQLSaturday Bulgaria.
It was great to see so many people willing to… Read more

0 comments, 170 reads

Posted in DotNine SQL Server and more on 12 November 2014

Wait Statistics #4 LCK_M_xx

In the 4th article of the Wait Statistics series we will dive into LCK_M_xx waits. This is another wait type you are sure to see in your environment!

LCK_M_xx waits

As you can guess the LCK_M_xx waits have a relation with locking, they are generated when a query wants… Read more

0 comments, 248 reads

Posted in DotNine SQL Server and more on 26 September 2014

Speaking at SQLSaturday #311 Bulgaria

More good news! I will be speaking on SQLSaturday #311 Bulgaria.

If you read this blog and will attend the event, come and say hi!

Read more

0 comments, 209 reads

Posted in DotNine SQL Server and more on 16 September 2014

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… Read more

0 comments, 1,061 reads

Posted in DotNine SQL Server and more on 2 September 2014

Speaking at SQLSaturday #336 Holland

I received some great news this week, my session about wait statistics is selected for SQLSaturday #336 in Utrecht, Holland!

This will be my first SQLSaturday as a speaker and I am really looking forward to it!

There are more than 160 sessions submitted by great SQL Server experts around… Read more

0 comments, 290 reads

Posted in DotNine SQL Server and more on 23 August 2014

New website

As you can see the webpage has changed!

New features are:
– Syntax highlighting on code snippets (and easy copy/paste)
– Better readability
– Faster
– Less spam in comments

All articles can be viewed again. I tried to update all the internal links, if, however, you find a link… Read more

0 comments, 222 reads

Posted in DotNine SQL Server and more on 11 August 2014

Examining OLEDB waits

On our adventure through the various types of wait statistics we end up at another popular wait type: OLEDB.
In this article we will take a closer look at OLEDB waits to help you understand where they come from.

OLEDB

OLEDB or, Object Linking and Embedding DataBase, is a Microsoft… Read more

0 comments, 209 reads

Posted in DotNine SQL Server and more on 11 July 2014

Examining OLEDB waits

On our adventure through the various types of wait statistics we end up at another popular wait type: OLEDB.
In this article we will take a closer look at OLEDB waits to help you understand where they come from.

OLEDB

OLEDB or, Object Linking and Embedding DataBase, is a Microsoft…

Read more

0 comments, 450 reads

Posted in DotNine SQL Server and more on 11 July 2014

Finding the last successful CHECKDB

One very important part of your SQL Server maintenance procedure should be running consistency checks on a regular basis using CHECKDB. Not only does CHECKDB check the health of important internal pages of your database like PFS, GAM, IAM and many more, it also check for errors in your data…

Read more

0 comments, 1,289 reads

Posted in DotNine SQL Server and more on 26 June 2014

Older posts