Welcome to MSDN Blogs Sign in | Join | Help

April 2009 - Posts

Thursday, April 30, 2009 4:44 PM

Why Should I Use Extended Events in SQL Server 2008?…

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
Posted by psssql | 2 Comments
Friday, April 24, 2009 12:14 PM

SQL Server, Locked Pages, and Standard SKU…

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
Posted by psssql | 10 Comments
Tuesday, April 21, 2009 3:20 PM

SQL Server and the Bad CPU

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
Posted by psssql | 1 Comments
Tuesday, April 14, 2009 10:04 PM

Speaking at European PASS 2009….

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
Posted by psssql | 2 Comments
Filed under:
Thursday, April 09, 2009 5:50 PM

SQL Server 2008 SP1 and Cumulative Updates Explained.....

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
Posted by psssql | 11 Comments
Wednesday, April 08, 2009 9:47 PM

The 3 Things you Need to Know to Install SQL 2005 on Windows 2008 Cluster

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
Posted by psssql | 1 Comments
Filed under: , ,
Tuesday, April 07, 2009 8:16 PM

Troubleshooting sp_xp_cmdshell_proxy_account Errors

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.  
Posted by psssql | 1 Comments
Friday, April 03, 2009 3:26 PM

Updated Errors may occur after configuring Analysis Services to use Kerberos authentication on Advanced Encryption Standard Aware Operating Systems

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
Posted by psssql | 5 Comments
 
Page view tracker