CSS SQL Server Engineers
This is the official team Web Log for Microsoft Customer Service and Support (CSS) SQL Support. Posts are provided by the CSS SQL Escalation Services team.
New extended event to track writes to the snapshot sparse file
You might have seen our earlier blogs around different snapshot related errors and the techniques...
Author: psssql Date: 05/13/2011
Why the Query Designer Table Listing could be empty
I just worked a case that took a little bit to figure out and involved some pretty deep debugging,...
Author: Adam W. Saxton Date: 05/12/2011
NOT (LinkedServertoSQLAzure) where Provider=’MSDASQL’ and DSN=’SQL Server Native Client’
I recently had two different people suggest the same (unfortunately unsupported) solution to the...
Author: Evan Basalik Date: 05/03/2011
Why does this query consumes so much CPU?
Recently I worked with a customer who reported a slow running query. Let me simplify this to...
Author: JackLi Date: 04/29/2011
AlwaysON - HADRON Learning Series: Maximum Failovers Within Specified Period
I can't take the credit for all this content as much of the investigation was done by Curt Mathews...
Author: psssql Date: 04/26/2011
MS11-028 may cause issues with SQL, Exchange and PowerShell
A .NET Security Update (MS11-028) may end up causing issues with applications that make use of the...
Author: Adam W. Saxton Date: 04/21/2011
Conversion issues moving from VS 2005 to VS 2008
I was asked to look at a case yesterday where the customer was hitting the following error after...
Author: Adam W. Saxton Date: 04/21/2011
System Center Advisor: Finishing off my first list of advice….
When I last told you my story of installing System Center Advisor, I had seen some new alerts for a...
Author: psssql Date: 04/20/2011
RS Report Performance Relief in CU7
Cumulative Update 7 for SQL 2008 R2 was just released. Within that CU, there are two fixes for...
Author: Adam W. Saxton Date: 04/19/2011
Why am I getting prompted for Credentials?
I just wrapped up a case for an issue I see every once and a while. The scenario is the...
Author: Adam W. Saxton Date: 04/18/2011
System Center Advisor: What is the email all about?…
The last time I left you with my adventures with System Center Advisor I was at the SeaTac airport...
Author: psssql Date: 04/06/2011
System Center Advisor: Anything interesting before I catch a plane…
I’ve been in Seattle this week at an internal Microsoft conference so haven’t had time to check back...
Author: psssql Date: 04/01/2011
System Center Advisor Day 3: What happened to my alerts?
Yesterday I posted that System Center Advisor had found several alerts for me to look at the day...
Author: psssql Date: 03/24/2011
System Center Advisor: The Next Day….
Yesterday I created a blog post on the Release Candidate launch of System Center Advisor:...
Author: psssql Date: 03/23/2011
Atlanta becomes a product….System Center Advisor
Last November I was part of an exciting launch at the SQL PASS conference of the beta of a project...
Author: psssql Date: 03/22/2011
To 1433 or not to 1433...that is the question
I recently ran into a problem with one of my own internal applications and it re-raised a...
Author: Evan Basalik Date: 03/17/2011
Think Negative (with RS Visibility)
I was helping Bob Dorr out with a report he was creating. He was trying to get some images and...
Author: Adam W. Saxton Date: 03/08/2011
SharePoint Adventures : Why isn't Claims working with SSRS?
SharePoint 2010 introduced a new authentication architecture called Claims Based Authentication...
Author: Adam W. Saxton Date: 02/24/2011
What URL to use for Azure Reporting
WARNING: This is based on pre-release software so things could change! I got started playing...
Author: Adam W. Saxton Date: 02/22/2011
SharePoint Adventures : How to identify if you are using Claims Authentication
When integrating Reporting Services with SharePoint, the authentication scheme for the SharePoint...
Author: Adam W. Saxton Date: 02/22/2011
SharePoint Adventures : Using Kerberos with the Report Server
Previous Post: SharePoint Adventures : Setting up Reporting Services with SharePoint Integration In...
Author: Adam W. Saxton Date: 02/21/2011
Did your backup program/utility leave your SQL Server running in an squirrely scenario? (Version 2)
My colleges asked me if 'squirrely' is a technical term and for this post the answer is yes. CSS is...
Author: psssql Date: 02/21/2011
SharePoint Adventures : Setting up Reporting Services with SharePoint Integration
I've had some questions in the past regarding Reporting Services Integration with SharePoint. For...
Author: Adam W. Saxton Date: 02/18/2011
AlwaysOn - HADRON Learning Series - Automatic Page Repair Increases SQL Server High Availability (HA) Capabilities
WARNING: The series is based on pre-release software so things could change but I will attempt...
Author: psssql Date: 02/17/2011
Why can’t I open SQL Server Management Studio
Recently we worked with a customer who could not launch SSMS from a specific computer. We heard...
Author: psssql Date: 02/04/2011
Resource Governor and MAXDOP, Parallel plan generation
I had an interesting conversation with some other support engineers and a customer as it relates to...
Author: psssql Date: 02/03/2011
RML How Are Comparison Diffs Calculated
A short but good discussion about the RML comparison DIFF calculations. From: Robert Dorr Sent:...
Author: psssql Date: 01/26/2011
Deploying CLR Assembly hangs with Visual Studio 2010
following upgrading Visual Studio 2010 from 2008, the customer started to experience problems when...
Author: JackLi Date: 01/24/2011
SQL Server - New Drives Use 4K Sector Size
In a lengthy discussion this past week I was reminded that Jan 2011 is when the hard drive...
Author: psssql Date: 01/13/2011
Profiler Shows Negative (Strange) EventSequence Values
I ran into an issue yesterday where the EventSequence column appears negative (or could be truncated...
Author: psssql Date: 01/13/2011
SQL Denali - DReplay/XEProfiler or RML Utilities
Many of you have used the RML utilities that Keith Elmore and I built and provided to the community...
Author: psssql Date: 01/12/2011
SQL Server 7.0: “She sure was a good ship”….
In December of 1997, I was asked by my manager whether I would like to visit Seattle to spend time...
Author: psssql Date: 01/10/2011
Discussion About SQL Server I/O
I received a request today for help on how SQL Server I/O behaves. As I was writing up my e-mail...
Author: psssql Date: 01/07/2011
Tracking database recovery progress using information from DMV
Technorati Tags: Engine,SQL Server 2008 You must be very familiar with the database recovery related...
Author: psssql Date: 12/29/2010
How It Works: Error 18056 - The client was unable to reuse a session - Part 2
I have had several questions on my blog post:...
Author: psssql Date: 12/29/2010
AlwaysON - HADRON Learning Series - Running DBCC On A Secondary
HADRON allows DBCC to be executed directly against a secondary replica. The DBCC can be run online,...
Author: psssql Date: 12/16/2010
AlwaysON - HADRON Learning Series - New DMVs
As I have been reviewing and learning about HADRON I have found a great wealth of information...
Author: psssql Date: 12/14/2010
AlwaysON - HADRON Learning Series - What Is HADRON?
I have been reviewing and working on supportability aspects of HADRON (High Availability Disaster...
Author: psssql Date: 12/07/2010
HOW IT WORKS: IO Affinity Mask - Should I Use It?
The IO Affinity mask question has come across my desk several times in the last week so it is time...
Author: psssql Date: 11/19/2010
Microsoft Atlanta Begins….
There is an incredible level of satisfaction in being able to turn an idea into something real....
Author: psssql Date: 11/12/2010
The week that was PASS…
I’m sitting in SEATAC Airport waiting for my flight, so I thought now would be a great time to write...
Author: Adam W. Saxton Date: 11/12/2010
CSS once again comes to the SQL PASS Summit
I’m proud once again to be a part of our CSS team coming to the US SQL PASS Summit next week...
Author: psssql Date: 11/04/2010
How It Works: SQL Parsing of Number(s), Numeric and Float Conversions
SQL Server and other documentation have always indicated...
Author: psssql Date: 11/01/2010
Query Performance and multi-statement table valued functions
Lately I worked with a customer to help tune his query involving multi-statement table valued...
Author: JackLi Date: 10/28/2010
How It Works: Extended Event (sqlos.wait_info*)
I was posed a good question today about how the wait_info* event works in SQL Server 2008. The...
Author: psssql Date: 10/20/2010
Numbers are better than letters…
Back in a post from May...
Author: psssql Date: 10/10/2010
Query performance and plan cache issues when parameter length not specified correctly
We recently worked with a customer who reported his update to a linked server table runs very slow....
Author: JackLi Date: 10/05/2010
Case of using filtered statistics
Technorati Tags: Performance SQL Server 2008 introduces a new feature called filtered statistics....
Author: JackLi Date: 09/28/2010