Scalzi’s Law of Cleverness, as applied to resumes

John Scalzi (blog, Twitter) – science fiction writer, Hugo award winner, philosopher, and blogger extraordinaire – has an adage that I wish...

Forty Things You Didn’t Know About SQL Server

Last week I delivered a seminar at the Expert Days 2013 event by the name of 40 Things You Didn’t...

NFC Tags-Fun, And Maybe Useful at SQLSaturday

Last week I had one of those days when I read something and then heard someone talking about the same...

SQL Server 2012 AlwaysOn Presentation Given at Vermont PASS SQL Server User Group Last Week

This past Wednesday evening, 11th Dec, I braved the snowy roads down from Montreal to Winooski (Burlington area) to join...

Setting up Security on sub sites in SharePoint 2010

A lot of companies have several departments and want to limit the sub sites users can view. For example, the...

Nine T-SQL best practices

SQL Server databases are the backbone of many enterprise applications, and good Transact-SQL (T-SQL) code is the best way to...

Case-Sensitive Updates in a Case-Insensitive World

Assuming you're in a case-insensitive ("CI" in the collation name) column, this UPDATE statement:

UPDATE tablefoo
set foo = 'Z'
where foo = 'z'

will just...

Talk Your Boss Into A Free Lunch and Giveaways!: Day 6

Monday Giveaway!

It's Monday again! I know we all hate Mondays, but let's have a Fun Monday!It's another week to give...

Recent events wrapup

The last two weeks were just incredible! I gave my first SQL Saturday PreCon training session in Washington DC and...

MDX Implementing Logical OR On Members of Different Hierarchies

Reference: MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook  by Tomislav Piasevoli In MDX, when two or more members of the same set are placed on a...