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

Nominated for the Tribal Awards

I’ve been notified I am a finalist for the category Best New Voice at the Tribal Awards. These awards are...

Nominated for the Tribal Awards

I’ve been notified I am a finalist for the category Best New Voice at the Tribal Awards. These awards are...

To All Recruiters - Canned Emails Kill Kittens: Day 9

Small disclaimer

I'm going to file this one under rant. Let me first say that there are some wonderful recruiting agencies...

Transactions: Rolling back part of a transaction.

In my previous post I mentioned the fact that the ROLLBACK command rolls back the entire transaction all the way...

Data Architecture VC hosts Nigel Sammy: TSQL Tips and Tricks

Please join the Data Architecture Virtual Chapter as they host SQL Server MVP Nigel Sammy his take for T-SQL Tips...