ITPROceed – Slide Deck and demo materials

ITPROceed 2014 is now a thing of the past, but is has been an awesome – and free! – event. A very...

Kerberos Configuration Manager’s Nasty Bug

The Kerberos Configuration Manager is a really handy tool that can make configuring Kerberos a much easier task, but it’s...

Natively Compiled Procedures and Bad Execution Plans

I’ve been exploring how natively compiled procedures are portrayed within execution plans. There have been two previous posts on the...

Script, store and transfer data using XML, XQuery and clipboard

When surfing SQL Server forums you might notice a lot of questions like "How do I script my data and...

SSC Editorial: Kitchen Duty

I try to find good stories for editorials at SQLServerCentral and the one this week about Kitchen Duty seems to...

Baton Rouge SharePoint Saturday

I'm thrilled to be joining many of my colleagues at Baton Rouge SharePoint Saturday this weekend at the Louisiana Technology...

ColumnStore Indexe with SQL Server 2012 & 2014

ColumnStore Indexes (Run By Microsoft’s VertiPaq technology) as described by BOL (http://msdn.microsoft.com/en-IN/library/gg492088(v=sql.110).aspx) :
“An xVelocity memory optimized ColumnStore index, groups and...

Come see me in Baton Rouge Aug 2nd!

I've been accepted for SQL Saturday Baton Rouge!

Yes, I am a little excited. I've wanted to become a speaker for...

I don’t want to grant permission to all the tables in the database at once.

A couple of weeks ago I did a post on granting or denying permissions to all the tables within a...

I Gotta See the Code–Question of the Day

I Gotta See the Code is a security question about viewing the code to a stored procedure. Two points if...