SQL Server

New T-SQL features in SQL Server 2012

Recently, I spoke at SQL Saturday #141 South Florida. Words can’t express how much I love the SQL Server community. Every time I’m able to speak at a SQL Server event I’m deeply honored. For almost the past year I’ve been traveling around Florida speaking at events like SQL Saturday talking about Project Management. But(…)

The A, B, C’s of Table Aliases

Dear Developers, DBA’s and Power Users, There is something that I’ve been seeing in your SQL that it annoys me so much that it’s forcing me to bring it to your attention. Developers, DBA’s and power users hear my plea. Table aliases are wonderful things. They make SQL easier to read and more compact. I’m(…)

Quick and Dirty Data Dictionary

Recently, I’ve been working on databases that I’ve never touched before. Of course, when dealing with a “new to you” database there some are challenges. What’s the schema of the database? What’s the “cleanliness” of the data? Is there any useful metadata? When I look at a database for the first time I want to(…)

Free SQL Server 2008 Courses From Microsoft

Microsoft is offering free SQL Server 2008 online courses. The offered titles are: What’s New in SQL Server 2008 for Enterprise Data Platform What’s New in SQL Server 2008 for Business Intelligence What’s New in SQL Server 2008 for Database Development We’ve been keeping our ear pretty close to the ground on SQL Server 2008(…)