Archive for December, 2011

SQL Server A to Z – CPU-Z

How fitting that I should close out the A to Z series while I close out the year.В  We’ve finally arrived at letter Z and that stands for the CPU-Z utility.В  Yes, technically that isn’t a part of SQL Server, but if you hadn’t already noticed by Monday’s ‘Y’ post, it’s slim pickins’ at this [...]

December 29, 2011  Tags: , , ,   Posted in: General  No Comments

SQL Server A to Z – YEAR

Welcome to the penultimate installment of SQL Server A to Z (it’s not often I get to use “penultimate”). Officially, Y stands for Year, but that would be kinda boring, and quite short, so let’s run with it and talk about all sorts of date-parts-related stuff. Functions that get parts of dates Since this is, [...]

December 26, 2011  Tags: , , ,   Posted in: T-SQL  No Comments

A SQL Server Christmas Card

Merry Christmas everyone!

December 22, 2011  Tags: ,   Posted in: T-SQL  One Comment

Pitching Pebbles – Using Certificates to Grant Privileges

I’m sure you’ve heard the story by Stephen Covey about the professor that fills a jar with rocks, pebbles, and sand as a metaphor for time management and prioritization. I’d relate it here, but I think this video is much more fun. Obviously this metaphor applies to all aspects of our lives, but we can [...]

December 19, 2011  Tags: , ,   Posted in: Security, T-SQL, Uncategorized  No Comments

#meme15 – Why Do You Blog?

Jason Strate (blog|@StrateSQL) is starting a new blog meme: #meme15.В  The overall topic of #meme15 will be social networking, obviously something that’s getting a lot of attention these days, so there should be plenty to write about.В  For the inaugural #meme15 post, the subject is blogging, specifically: why do you blog and why did you [...]

December 15, 2011  Tags: , ,   Posted in: Professional Development  No Comments