Tribal Awards: Vote Now!

The #tribalawards voting is now online. Get over there and get it done.
I honestly don’t care who you vote for...

Android is better than iOS

Not in many ways, and certainly not in enough for me to stick with Android over iOS, but here are...

Assign SQL Service Account with Group Policy

How do I assign and enforce a service account for the SQL Server Services with Active Directory Group Policy?
The answer...

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

Friday Followup For December 20, 2013

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...

Reblog: December 13 to December 19

I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...

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

How to Set Up Managed Backups in SQL Server 2014

Earlier this week I introduced the concept of Managed Backups (and caused less of a turmoil than I thought I...

I’m presenting at the PASS Business Analytics Conference

I am fortunate enough to have been selected to give a presentation at the PASS Business Analytics Conference in San Jose, CA...

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