24 Hours of PASS videos online

All the videos for the sessions at 24 Hours of PASS (Spring 2014) are available for free.  Check the session schedule for...

Second Year Presenting at SQL Saturday Orlando

Coming up on my schedule is another appearance at SQL Saturday Orlando.   Orlando is quite special to me as it...

Stairway to SQL Server Virtualization – Level 1

I’m proud to announce that yesterday the first installment of my new Stairway series at SQL Server Central has been...

The clustered index columns are in all of the non clustered indexes.

Did you know that whatever columns you pick as your clustered index will be included in any non clustered indexes...

Apply Now for the PASS Board of Directors

One of the better graphics I’ve seen in a Connector that shows the timeline:
 

 
My thoughts:
Should You Run for the...

How to Edit Read-Only Non-clustered Columnstore Data

As I've discussed in some of my previous posts, creating a non-clustered Columnstore index will make the index as well...

Linchpin by Seth Godin

I am not sure how many books by Seth Godin I do own, I guess that it is somewhere around...

SchemaBinding – What & Why

What
When you use the SchemaBinding keyword while creating a view or function you bind the structure of any underlying tables...

So What the Heck is Power BI?

The other day a secondary family member said “we’re still on Microsoft 2010”. Another said “My friend is using Windows...

Batch Mode – part 1 (“The Beginning”)

This is the very first blog post in a new series on the Batch Mode, welcome & enjoy!
I will be going...