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...
Monday, August 24, 2009

Great Book for Building a SQL Server BI Solution

›
While written for SQL Server 2005 and a little out of date for SQL Server 2008, The Microsoft Data Warehouse Toolkit: With SQL Server200...

Interview Questions

›
I recently conducted technical interviews for one of my clients to help find a mid-level SQL Server BI developer. Below are the questions I ...