Busy times

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

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

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,...

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

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

New website

As you can see the webpage has changed!
New features are:

– Syntax highlighting on code snippets (and easy copy/paste)

– Better readability

–...

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

Examining OLEDB waits

On our adventure through the various types of wait statistics we end up at another popular wait type: OLEDB.
In this...

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

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