FileTables–Inserting Directories from T-SQL

Creating a directory in a Filetable share is easy. It looks like this:

It’s hard to see, but this was a...

How to install SQL Server Failover Cluster from SQL Server 2008 onwards ?

Steps to install SQL Server Failover Cluster from SQL Server 2008 onwards :-
1) Open SQL Server Installation Center > Go to...

Installing and Configuring Active Directory in Window Server 2012

Hello Friends,
Sometimes life is so uneasy that you didn’t get time for the work which you like the most. Now...

Most important feature of SQL 2014

There are a whole raft of cool new features in 2014 including things like In-Memory OLTP, increased Azure integration/options and...

Speaking At the Pinellas SQL Group on August 18, 2014

I’ve committed to presenting but haven’t decided on the presentation yet. It will probably be a remote presentation because it’s...

SQL Server Quickie #13 – Hash Join Operator

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

Team-based Database Development: Playing Nice With Others

Here are the slides and links to awesome resources for my presentation, “Team-based Database Development: Playing Nice With Others”
If you...

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