This is normally not a place where we advertise for events held by our friends, but today I’ll make an exception to that rule. Our friends at Orangeman has made a scoop, two that is actually . In October, Orangeman is hosting two interesting courses he...

The Nordic SQL Server event of the year is getting closer and closer. YES it is SQL Rally Nordic that I’m talking about. If you haven’t booked your ticket yet, then it is about time. SQLRally Nordic 2012 is taking place Monday, October 1st –...

Quite often when I see a new SQL Server setup, a CHECKDB has never been run on the databases. It’s pretty simple to do, and it _could_ save you some big trouble later on. What is it? The command “DBCC CHECKDB()” checks the logical and physical integrit...

If you are using SQL Server 2008 enterprise/datacenter edition, or SQL Server 2008 R2 standard or above, you are in the lucky possition to be able to compress your SQL Server backups. Often I see installations of these versions, where compression is not...

Last week we blogged about “How to configure Database mail” – this week we’ll have a closer look at what to do when everything looks fine, but no mail is flying through the system – what is wrong?. After testing, if you are unable to receive notificatio...

In my daily job as a SQL Server consultant I go to a lot of places, many days on the road, and many nights at different hotels. All these things are a part of the job, so of course I am not complaining. What some times can be a challenge is to have acce...

Now and then my colleagues and I find our selves in the middle of a discussion about SQL Server Mirroring versus the more traditional Failover Clustering. Both are features provided by SQL Server for achieving high availability, buth they both have pro’...

In our blog post last week: Instance Wide Wait Stats we promised to show You how to visualize the collected wait stats with Microsoft Excel, so this is what this blog post will be about. The blog post from last week will be the basic setup for this one...

Over the last many weeks we have written quite a few blog post about query debugging, using Extended Events, Blocking sampling and other techniques. Today we are taking a few steps back, and demonstrate how you could start looking at performance problem...

(The complete usable code is in the very bottom of this blog post) Some of you may have seen this “numbers table” technique in use before, but I thought I would share a few simpel examples to those of you that haven’t seen the light yet Lets start with...