Often when designing reports you are required to apply the same formatting to multiple columns in one table or matrix. Since SSRS 2008 does not allow the developer to change the format of a column using Textbox Properties when multiple columns are selected, the developer must either:

· Change the… Read more

Yesterday was the first day of the SQL Server 2008 R2 airlift.  I attended a great session on Implementing a Fast Track Data Warehouse.   Lots of really interesting information was discussed during the meeting. However, an offline discussion about switching partitioned data in from a stage table provided a good… Read more

During a T-SQL class that I was recently teaching I was asked if a PIVOT could be performed using a Common Table Expression (CTE).  In other words, instead of using the method outlined in SQL Server Books Online that uses a derived table, replace the derived table with a CTE. Read more

If you are near Charlotte, NC, I will be speaking at their SQL Saturday on March 6th, 2010.  My session, SQL Server Compression 101 is at 1:30 PM.  This is the first SQL Saturday under PASS management.  If you have not registered for this event do so, seats are… Read more

Read more