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

Last Weeks Top “Reading” Links #88

It’s Monday time for this week’s weekly link round-up.  If you want to catch these links “live” (so exciting), follow...

Notes From SQLSaturday South Florida

Notes from the trip:
Four hour drive between traffic and rain, about an hour longer than I would have liked. The...

Reflections On Fathers Day

Fathers Day coincided with the family vacation this year and maybe more than some years I had the time to...