Collation: Confusion

I started reading about collations after I had a recent run in with them. As I read I started to...

FileTable–Adding a file to a folder

At my Filestream/Filetable talk yesterday at SQL Intersection, someone asked me about programmatically adding a file to a Filetable. Easy...

Learn High Availability and Disaster Recovery with SQL Server in a Day!

If you are near Pittsburgh, PA on May 22, 2014 catch the following all-day training session from 8:30 AM to 4:00...

MDX # 39 – Find Default Measure using MDX Query

In Chapter 1 of our book, MDX with SSAS 2012, we’ve devoted a section “Setting a default member of a...

Practical Data Migration Strategies

Practical Data Migration Strategies
As organizations mature their IT infrastructure must change to keep up with new applications and technologies. Many...

SQL Server Partitioning 101

I’ve worked with partitioning for quite some time now, and though it has been around for quite some time and lots has been written about the concept I recently...

SQLSaturday #305 Dallas Business Analytics Edition

I am excited about being selected to speak and attend the May 3rd SQLSaturday BA Edition in Dallas, TX. There...

SSMS Queries on Function Keys

By David Postlethwaite

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

2014 SQL Server Editions – Overview

2014 is the latest edition of SQL Server available[/caption]
SQL Server 2014 was officially released in April 1st, 2014. You can...

Come see me present SQL Saturday Atlanta

Have you seen the schedule for SQL Saturday #285 – Atlanta?   Holy cow they have jam packed too many hard decisions...