Symmetric Keys

One of the encryption options in SQL Server is symmetric key encryption. This is the type of encryption most people...

Last Weeks Top “Reading” Links #62

Monday afternoon and it’s time for weekly round-up.  If you follow me on twitter (@StrateSQL), you’ll know that throughout most days I tweet...

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...