What is a Non-Clustered Columnstore Index?

First introduced in SQL Server 2012, the Columnstore index is a new in-memory feature that allows for the creation of...

[SQL Snacks Video] SQL Server Table Partitioning 103

Welcome back for part 3 of my SQL Snack Pack on Table Partitioning! If you have not watched the first two...

Central Management Studio CMS

By David Postlethwaite

At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some...

How to add node to SQL Server Failover Cluster from SQL Server 2008 onwards ?

Steps : How to add node to SQL Server Failover Cluster from SQL Server 2008 onwards ?
1) Open SQL Server Installation...

Last Weeks Top “Reading” Links #81

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

PowerShell-Input-Validation Scripts

Input values are validated using various mechanisms.  let’s start by examining how you would validate input parameters in Windows PowerShell...

PowerShell-Input-Validation Scripts

Input values are validated using various mechanisms.  let’s start by examining how you would validate input parameters in Windows PowerShell...

Resume Generating Event (RGE)

No, I haven't lost my job. This is just one of those topics that's good to get out there. There...

Sorkin On Writing

I saw this write up about Aaron Sorkin and the writing on Newsroom just after posting Blogging-Write More and found...

The default autogrowth settings do NOT come from the Model database.

I recently saw a question about How to inherit autogrowth settings. They commented that while the new database GUI seemed...