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.
BISM: value of the 'EffectiveUserName' XML for Analysis property is not valid
I’ve been working with Power View reports and one of the items I was setting up was using a BISM...
Author: Adam W. Saxton Date: 04/25/2012
Behavior Change When Handling Character Conversions SQL Server’s ODBC Driver (SQL 2012 – Version 11.xx)
Summary The SQL Server 2012 ODBC Driver (SQLNCLI11.dll) updated handling of SQL_WCHAR*...
Author: psssql Date: 04/24/2012
Working with Power View: Some controls on this presentation can't be activated
When one of our Managers opened up the PowerPoint slide deck that Power View generated, he got the...
Author: Adam W. Saxton Date: 04/24/2012
Working with Power View: Click to Interact is not available
I was working on a Power View report for our internal business numbers and we are making use of the...
Author: Adam W. Saxton Date: 04/24/2012
How It Works: HealthCheckTimeout Interval Activities
As I wrote my recent blog posts and did more research I found that is would be helpful to highlight...
Author: psssql Date: 04/11/2012
SQL Server 2012: RML, XEvent Viewer and Distributed Replay
Bob Ward, Keith Elmore and I establish goals for every release of SQL Server. A primary...
Author: psssql Date: 04/06/2012
How It Works: XEvent Action vs Field data values.
I have seen several traces and questions relating to the output of the XEvent so I thought I would...
Author: psssql Date: 03/22/2012
AlwaysON - HADRON Learning Series: Automated Failover Behaviors (Denali - Logging History Information, FCI and Default Health Capture, sp_server_diagnostics)
Quite an encompassing title I will agree but the features all work together to build a really nice...
Author: psssql Date: 03/22/2012
SetFileIoOverlappedRange Can Lead to Unexpected Behavior for SQL Server 2008 R2 or SQL Server 2012 (Denali)
You should be aware the Windows bug with API = SetFileIoOverlappedRange. This is used by SQL Server...
Author: psssql Date: 03/20/2012
SQL Server 2012 - True Black Box Recorder
This would be a perfect time to post a blog talking about the new SQL Server 2012 features. ...
Author: psssql Date: 03/08/2012
A faster CHECKDB – Part II
Note: Validation for this post was performed in the SQL Server Customer Advisory Team (SQL CAT)...
Author: psssql Date: 02/23/2012
Analysis Services Thread Pool Changes in SQL Server 2012
As part of the SQL Server 2012 release several changes were made to Analysis Services that should...
Author: psssql Date: 01/31/2012
Management Studio tricks you may or may not know about
I was sitting through SQL Server 2012 training, and Ajay Jagannathan was showing us Management...
Author: Adam W. Saxton Date: 01/31/2012
The case of the incorrect page numbers
As you may or may not know, SSRS 2008 R2 added the ability to automatically create page breaks on...
Author: Evan Basalik Date: 01/29/2012
How It Works: sys.dm_tran_session_transactions
For some reason I have been looking at DMV output closely the last couple of weeks. I just blogged...
Author: psssql Date: 01/24/2012
How It Works: sys.dm_io_pending_io_requests
I have been working an issue where the DMV was returning io_pending_ms_ticks incorrectly. The...
Author: psssql Date: 01/23/2012
A faster CHECKDB – Part I
Earlier this year I travelled to Japan having the opportunity to visit some of our customers and...
Author: psssql Date: 12/20/2011
Exporting via HTML instead of MHTML
There was a question on Twitter about how to display a report in HTML instead of MHTML due to some...
Author: Adam W. Saxton Date: 12/09/2011
Distributed Replay for SQL Server 2012
I recently had a lengthy exchange on DReplay with Jonathan Kehayias (SQL MVP). From this exchange I...
Author: psssql Date: 11/15/2011
SQL Server: Clarifying The NUMA Configuration Information
The increased number of cores per socket is driving NUMA designs and in SQL Server support we are...
Author: psssql Date: 11/11/2011
Error 1803 and model size change in SQL Server 2012
Recently I encountered error 1803 when working on SQL Server 2012. The script I ran against a SQL...
Author: psssql Date: 10/29/2011
The week that was PASS 2011 & Moving on…
This is to recap my week at PASS Summit 2011. This was my 4th US PASS, and every year it is amazing....
Author: Adam W. Saxton Date: 10/17/2011
Easy JDBC Logging
I have been supporting Microsoft’s JDBC driver for almost six years now and the one thing with which...
Author: Evan Basalik Date: 10/16/2011
A Better solution for the Windows 7 SP1 ADO GUID changes
UPDATE: This fix was published in mid-February as https://support.microsoft.com/kb/2640696. We are...
Author: Evan Basalik Date: 10/02/2011
After Applying SQL Server 2008 R2 SP1 Error 9013 is logged (The tail of the log for database %ls is being rewritten to match the new sector size of %d bytes …)
In SQL Server 2008 R2 SP1 we made updates to dynamically accommodate disk drives that present...
Author: psssql Date: 09/27/2011
RML Questions
The following questions have surfaced several times recently so I decided to post the answers to...
Author: psssql Date: 09/26/2011
Inside the SQL Server Clinic…
In my last post, I reviewed the Microsoft CSS involvement at the upcoming 2011 SQL Server PASS...
Author: psssql Date: 09/19/2011
The SQL PASS Summit comes again to Seattle and CSS will be there…
For the 9th year, the Microsoft CSS team will speak and meet customers at the SQL PASS Summit, being...
Author: psssql Date: 09/11/2011
The DMV sys.dm_os_memory_clerks May Show What Appears To Be Duplicate Entries
In SQL Server 2008 some of the memory based DMVs show memory node id 0 when you might not expect...
Author: psssql Date: 09/08/2011
SQL Server 2008/2008 R2 on Newer Machines with More Than 8 CPUs Presented per NUMA Node May Need Trace Flag 8048
Applies To: SQL 2008, 2008 R2 and Denail builds The SQL Server developer can elect to...
Author: psssql Date: 09/01/2011
How compressed is your backup?…
While working recently with a customer, it was brought to my attention that while SQL Server has a...
Author: psssql Date: 08/11/2011
Stored procedure recompile caused by alter table on temp table
Lately we got a customer who called in and reported that a particular statement involving a...
Author: JackLi Date: 07/15/2011
How It Works: Return codes from SQLIOSim
I have been asked how to automate SQLIOSim on several occasions. SQLIOSim is a utility to test SQL...
Author: psssql Date: 07/01/2011
Trace shows the incorrect Session Login Name
The is more of an FYI blog post but I have read several blog and forum posts on this subject and I...
Author: psssql Date: 07/01/2011
SQL Server 2008 R2 does not start when applying certain hotfix updates
We have noticed that when you install certain hotfixes (this includes Cumulative Update 1 and...
Author: psssql Date: 06/28/2011
Inappropriate usage of high isolation level isn’t just about blocking when it comes to performance
Normally when you see high isolation level such as SERIALIZABLE is used, your natural instinct tells...
Author: JackLi Date: 06/23/2011
How It Works: FileStream (RsFx) Garbage Collection
In a previous blog I outlined how file stream transactions work and retain the before and after...
Author: psssql Date: 06/23/2011
Tracking Down Missing Indexes in SQL Azure
One of the challenges of SQL Azure is that not all of the TSQL that you are used to using is...
Author: Evan Basalik Date: 06/16/2011
Dipping My Toes Into SQL Azure – Part 2 – Protection Mechanisms
I left off my previous post stating that I was going to start looking at performance and reliability...
Author: psssql Date: 06/15/2011
JDBC 1.x: “She sure was a good ship”…
OK, OK – the title is a complete rip-off of Bob Ward’s post about SQL Server 7.0, but...
Author: Evan Basalik Date: 06/05/2011
Dipping My Toes Into SQL Azure
My high school English teacher once told me that I should always have a spell checker on my...
Author: psssql Date: 05/27/2011
Pssdiag/Sqldiag Configuration Manager released to codeplex
A lot of you are probably familiar with pssdiag tool released for SQL Server 7.0 and 2000 and...
Author: JackLi Date: 05/24/2011
Slow performance and out of memory issues caused by large batch
Recently, I worked with a customer who reported out of memory errors from his SQL Server 2008 R2...
Author: JackLi Date: 05/18/2011
SharePoint Adventures : ADFS Setup – Part 2
In Part 1, we looked at getting ADFS actually installed, for Part 2, we will see what we need to do...
Author: Adam W. Saxton Date: 05/17/2011
SharePoint Adventures : ADFS Setup – Part 1
I've had a few cases that involved customers using ADFS, SharePoint and Reporting Services. When...
Author: Adam W. Saxton Date: 05/16/2011