Have you ever needed to order by a calculated column? You might have written it something like this: SELECT LoginID, YEAR(HireDate)...  Read more...

Today was a rehearsal day. Actually the last 2-3 days of work have been split between rehearsing talks that I’m...  Read more...

Inventory is a vital information,whether you’re a consultant or an in-house DBA, you need to have a reliable inventory of...  Read more...

There is nothing more annoying to me in my profession than getting calls and emails from recruiters who are looking...  Read more...

Capturing information is useless unless you know how to use it. Here’s what I use to get the most out...  Read more...

Often we may need to update a column in a table based of another column in another table. In SQL Server...  Read more...

Sometimes we get data in some bad forms. For example look at the below table: The names and the amounts are...  Read more...

Microsoft has released two new Cumulative Updates for SQL Server 2008 R2. One is for SQL Server 2008 R2 Service...  Read more...

Since I bought a Nexus 7 (two of them, I broke the first one) I’ve been interested to see if...  Read more...

Recently I was in a small coffee/sandwich shop for early morning coffee and while waiting watched one of the employees...  Read more...

Recently I ordered a Paolini Pocket Rule from Woodpecker. It is one of a series of OneTime Tools they’ve produced...  Read more...

For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...  Read more...

This week is the kickoff of the third year of SQL in the City from Red Gate. As we have...  Read more...

To those that don’t know me “Natural Born Killers (The Series)” sounds like a very strange choice for a SQL...  Read more...

Yes, its true. Microsoft vice president has announce  that new version of sql server 2014, will release on 2014… do...  Read more...

  I'm surprised there isn't an option in the Report Manager for allowing you to include on the print out of...  Read more...

Steve Simon will join us on Thursday June 20th at noon central to help us understand some challenges with designing...  Read more...

SQL Server tracing is essential for troubleshooting performance issues, yet it can put loads on your server that would cause...  Read more...

Welcome to this Friday’s reblog summary post.  The aim of these posts is to bring some old posts that newer...  Read more...

Thanks to everyone who attended my session “Building an Effective Data Warehouse Architecture” for Pragmatic Works.  There were over 500 attendees!  The abstract...  Read more...