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.

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

2 comments, 2,159 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, 90 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, 107 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, 139 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, 385 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, 199 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, 150 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, 55 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, 208 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,011 reads

Posted in DotNine SQL Server and more on 26 June 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, 35 reads

Posted in DotNine SQL Server and more on 26 June 2014

Query backup history

As a quick script tip for today I’ll show you a script I use regularly for reporting purposes.
It shows you the backup history on your instance for successful backups ordered by the most recent first:

1
2
3
4
5
6
7
8
9
10
11
12
13
14…

Read more

0 comments, 35 reads

Posted in DotNine SQL Server and more on 13 June 2014

Query backup history

As a quick script tip for today I'll show you a script I use regularly for reporting purposes.
It shows you the backup history on your instance for successful backups ordered by the most recent first:

-- Get the latest successful backups
-- Shows databasename, backup start & end time,…

Read more

0 comments, 345 reads

Posted in DotNine SQL Server and more on 13 June 2014

Examining PAGEIOLATCH waits

In a previous article we looked at CXPACKET waits, a wait type that is can be on the top of your server’s list if you enabled parallelism using the MDOP setting.

Another wait type that you probably will be seeing in your top 10 of waits (unless you have… Read more

0 comments, 45 reads

Posted in DotNine SQL Server and more on 6 June 2014

Examining PAGEIOLATCH waits

In a previous article we looked at CXPACKET waits, a wait type that is can be on the top of your server’s list if you enabled parallelism using the MDOP setting.

Another wait type that you probably will be seeing in your top 10 of waits (unless you have…

Read more

0 comments, 307 reads

Posted in DotNine SQL Server and more on 6 June 2014

How SQL Server statistics are generated and updated

One of the easiest ways to increase query performance on your database is making sure your statistics are up-to-date. Statistics are – if you enabled the options in your database properties – automatically created and updated by the SQL Server Engine. This does not however mean that the statistics are… Read more

0 comments, 32 reads

Posted in DotNine SQL Server and more on 16 May 2014

How SQL Server statistics are generated and updated

One of the easiest ways to increase query performance on your database is making sure your statistics are up-to-date. Statistics are – if you enabled the options in your database properties – automatically created and updated by the SQL Server Engine. This does not however mean that the statistics are…

Read more

0 comments, 2,776 reads

Posted in DotNine SQL Server and more on 16 May 2014

Analyzing CXPACKET waits

One of the most common wait types you will see on a SQL Server is the CXPACKET wait type.

This wait type is usually at the top of the list when you query the sys.dm_os_wait_stats on servers where you configured the MDOP setting to be anything but ‘1’. CXPACKET waits… Read more

0 comments, 42 reads

Posted in DotNine SQL Server and more on 4 April 2014

Analyzing CXPACKET waits

One of the most common wait types you will see on a SQL Server is the CXPACKET wait type.

This wait type is usually at the top of the list when you query the sys.dm_os_wait_stats on servers where you configured the MDOP setting to be anything but ‘1’. CXPACKET waits…

Read more

0 comments, 2,148 reads

Posted in DotNine SQL Server and more on 4 April 2014

The power of the baseline

There is one thing we all have in common, and a lot of us probably don’t even realize it, baselines!
While this is a blog about SQL Server, baseline monitoring isn’t something only DBA’s do. Actually everyone uses baselines in one way or the other. For instance, when you receive… Read more

0 comments, 85 reads

Posted in DotNine SQL Server and more on 21 March 2014

Older posts