Building the SQLSaturday Orlando Marketing Plan–Part 2

Our attendance number for last year was 285, so we’re going to aim for increasing that by 20% to 342....

Colorado SQL Events for May 2014

SQL Meetings are training events for SQL Server professionals and those wanting to learn about SQL Server. Please note that...

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