Guest Columnist: Adam Aspin

Of all the technical solutions to the problem of slowly changing dimensions, the T-SQL MERGE statement is one of the most elegant.   Read more...

To finish this short series on extended properties a look at documenting sets of database objects  Read more...

Continuing the short series on extended properties, this article explains how to turbocharge the creation of extended properties  Read more...

In this second article of a short series we look at using the Extended Properties which you have added to a database  Read more...

Part one of a four part series intent on demystifying and making more accessible SQL Server extended properties  Read more...

When you are obliged to create a dimensional database for an SSAS cube, how can you do it as fast as possible?  Read more...

A cursor-free way of normalizing data from a denormalized data source into a database which uses "surrogate" IDs.  Read more...

This article shows ways of getting feedback to your users when running a SQL Server agent job from an ASP.NET page  Read more...

Tired of the truncated error history that is available for SQL Server Agent jobs in SSMS, here is a way to get deeper information - easily!  Read more...

In another article on the presentation layer aspects of reporting Services, Adam Aspin explains how to add conditional formatting to your reports  Read more...

In the third article in his series on styling reports, Aaron Akin takes a look at using templates to ease and speed development.  Read more...

Continuing on with his series on Reporting Services, Adam Aspin takes another look at stylesheets in your reports. This time with custom assemblies and the CLR to enhance the capabilities of your SSRS system.  Read more...

Reporting Services provides a robust reporting platform that rivals many other products. New author Adam Aspin stars a series on how you can dress up your reports and maintain good development practices.  Read more...