You may or may not have heard of a new diagnostic technology in SQL Server 2008 called Extended Events (XEvent). I thought I would post an example of why this technology can do things nothing else we have can when you deploy SQL Server 2008. Someone internally...

I made an announcement today while speaking at Europe PASS 2009 that we will be providing a method for customers using standard SKU for SQL Server 2005 and 2008 to use the ‘Locked Pages in Memory’ privilege to allow the server to use the AWE APIs. This...

From time to time I encounter an issue where the physical CPU is the source of the problem.   I hope you never encounter such and issue but I wanted to provide an example to help those that will. Customer started getting frequent dumps from...

I’m leaving this weekend to travel to Europe to speak at the European PASS 2009 Conference in Neuss, Germany. I spoke at this conference last year and was very impressed on how it was organized and run. From a speaker perspective, the setup of the conference...

NOTE: I've made a change to this blog post to account for the fact that actually 6 fixes in CU4 for 2008 RTM fixes DID made it into 2008 SP1. One of our readers sent me the following questions I think you will find valuable when understanding our recently...

Today I was walking a counterpart through installing SQL Server 2005 cluster on a Windows Server 2008 cluster and realized there are three specific key things you need to know when installing SQL 2005 on Windows 2008 cluster.  I also saw that it...

I was attempting to establish the command shell proxy on my local machine and ran into a series of errors.   As I looked at them more I decided to file some work items with the SQL dev team to provide better context in the message text.  ...

The Microsoft SQL Server Analysis Services support team has seen an increasing number of issues involving errors when attempting to execute queries against or deploy databases to instances of Analysis Services 2005 and Analysis Services 2008 that are...