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

Book Review: Why You Should Read Expert Cube Development With SSAS 2012 Cover to Cover

Expert Cube Development with SSAS 2012 Multidimensional Models was published earlier this year by Packt Publishing. It’s the second edition...

How to remove CardinalityEstimate in query plan on computed columns…

Hello,
I have come across a really good tip if you’re using computed columns that involve a concatenation of columns and...

PASS SQLSaturday Events: July 2014

 
DateEventJuly 12 SQLSaturday #312 – Sacramento 2014July 26 SQLSaturday #302 – Albany 2014July 26 SQLSaturday #322 – Guatemala 2014The post PASS SQLSaturday Events:...

Reblog: June 6 to June 12

Photo credit – Mike Lynch
A good cure to a creepy doll is a good old post that is still useful. In...

SQL Saturday South Florida And Then Vacation

I’m leaving early afternoon for the longish drive to South Florida for SQLSaturday tomorrow. The schedule looks impressive! I missed...

Query backup history

As a quick script tip for today I’ll show you a script I use regularly for reporting purposes.

It shows you the...