Monday, November 30, 2009

Deleting a Windows Service

›
While I typically stick with Microsoft products there are times that I must drift. I'm currently working with a client that is using Cog...
Sunday, November 29, 2009

SSRS Rendering Extension - Pipe Delimited

›
It's very easy to leverage the existing Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRende...
Friday, October 16, 2009

SSAS Deployment Error: No mapping between account names and security IDs was done. .

›
Check to make sure all the Active Directory ids in your role objects are valid. Most likely this error is being caused by a user or group th...
Thursday, October 8, 2009

SQL Server Management Studio Default Isolation Level Can Cause Locking/Blocking

›
Many unsofisticated and/or underfunded organizations have people executing ad hoc queries against production SQL Server instances with littl...
Wednesday, October 7, 2009

Linked Server NT AUTHORITY\ANONYMOUS LOGON Error - SPN Issue

›
I was recently struggling with a couple of linked servers. Every time I tried testing them or running a query that referenced the linked ser...
Thursday, September 3, 2009

Column Headers in Matrix

›
In SSRS for SQL Server 2005, the matrix component does not allow for out of the box row group column headers. The default behavior is for ...
1 comment:
Tuesday, August 25, 2009

Top Clause - Using Dynamic Values

›
Prior to SQL Server 2005, the value in the TOP clause was limited to literal values which meant that variables could not be used. Hence, the...