Recently I worked with a customer who reported a slow running query.  Let me simplify this to illustrate the problem.   There are two tables  t1 (pk int identity primary key, c1 int, c2 int, c3 int, c4 varchar(50)) and  t2 (pk...

I can't take the credit for all this content as much of the investigation was done by Curt Mathews (SQL Server Escalation Engineer). We are finding that folks want to test the failover abilities of AlwaysON but after a single failover it no longer seems...

I am happy to announce that CSS SQL Azure Diagnostics (CSAD) has been released. Since you cannot use PSSDiag/SQLDiag against SQL Azure, I decided to develop this tool to shorten the data collection process when troubleshooting SQL Azure issues. ...

A .NET Security Update (MS11-028) may end up causing issues with applications that make use of the .NET Framework, mostly resulting in applications being unable to launch, or loss of functionality within Native Applications that make use of .NET. In some...

I was asked to look at a case yesterday where the customer was hitting the following error after converting a VS 2005 Project to VS 2008. Error 3 Custom tool error: Failed to generate code. Failed to generate code. Exception of type 'System.Data.Design...

When I last told you my story of installing System Center Advisor, I had seen some new alerts for a database I had created on this server called mavstothefinals (hey Lakers and Spurs lose in the first round and Mavs are up 2-0. It could happen…). I had...

Cumulative Update 7 for SQL 2008 R2 was just released.  Within that CU, there are two fixes for Reporting Services that people should be aware of that related to report performance. Large HTML This issue is related to reports that have a large amount...

I just wrapped up a case for an issue I see every once and a while.  The scenario is the following: Browse to site Get Prompted for credentials and enter username and password Web site will come up normally I’ve seen where some people go into Kerberos...

The last time I left you with my adventures with System Center Advisor I was at the SeaTac airport checking out my alert dashboard before I jumped on to my plane back to Texas. And now that I’m back in the sunny skies of the Lone Star State (sorry Seattle...

The behavior of a synchronous commit in AlwaysON is to commit the transaction on the local replica as well as the secondary replica before the transaction is considered complete.    If you   have used database mirroring you may be...

I’ve been in Seattle this week at an internal Microsoft conference so haven’t had time to check back on what other things System Center Advisor found out about my server from last week. I've got a few minutes before I catch a plan back to Texas so while...