You know how every product that has an underlying database has documentation that says not to modify the schema?  Do you always pay attention to that warning? If your product is Reporting Services, I just ran into a case today which I hope convinces...

In 2002 the SQLOS team added specific checks for non-yielding scheduler issues. You may be familiar with the 178** series of errors like 17883 scheduler non-yield. Since 2002 the test matrix for SQL Server has flagged these errors and corrected them....

I am still working to resolve the customers problem but during my investigation I briefly looked a the SQLAgent logging format and thought you all might like some of these details. From: Robert Dorr Sent: Monday, May 24, 2010 9:47 AM Subject: RE: SPID...

Every once in a while, I get asked the question about deploying Reporting Services on a Cluster. Usually it is tied to a scale out deployment, sometimes it is not. I just was asked the question again by an engineer in our group. So, I figured I should...

Our blog won’t have any posts next week due to an internal migration of the MSDN blog servers to a new system. You can track the progress of this migration at this site: http://blogs.msdn.com/seanjenkin/archive/2010/05/12/during-the-upgrade-of-the-blogging...

When creating a new document library within SharePoint you have a few options.  You can just create a new Document Library, or you can go to More Options and choose Report Library.     When you choose Report Library, by default, it will...

I thought i would post some answers to questions I received during my pre-conference seminar at Europe PASS 2010: Q: You said that trace flag 2528 disables parallelism for DBCC CHECKDB. Is there any way to force CHECKDB to use a parallel threads? A: No...

I saw a lot of hits on the web when I searched for the Error message 18056 with State 29. I even saw two Microsoft Connect items for this issue filed for SQL Server 2008 instances: http://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID...