Configuring the In-Memory OLTP File Group for High Performance

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the...

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

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

Reflections On Fathers Day

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

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

What I Love About SQL Server

Well, there are many things I love about SQL Server. Otherwise, I wouldn’t spend my whole career around it, would...

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

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

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