Error Creating Remote Distributor When Creating a Local Distributor

Recently, I was working on a Peer-to-peer replication automation project. When I switched from my local test servers to some...

April Blogger Challenge 3 – Filtered Indexes

The April Blogger Challenge is from Ed Leighton-Dick and aimed at new bloggers, but anyone is welcome. I’m trying to...

SQL Server 2014 SP1 released, and revoked

Just a brief note today to point to an article by Time Ford on SQLMag.com announcing that SQL Server 2014 SP1 has...

Azure SQL Database v12 and SQL Magazine

I spend many of my evenings researching and writing. Sometimes it’s writing new books. Sometimes it’s fixing and rewriting old...

Exam Prep 70-463: Master Data Services Models

This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...

2015 Program Committee

Last year, I was very much honored to be selected to deliver a pre-con with my friend brother Chris Shaw (B|T).   I...

Received 2nd MVP Award for SQL Server - Zum 2. Mal ausgezeichnet mit dem MVP-Award für SQL Server

Adding, altering or removing multiple columns from a table

I was recently asked to do some fairly heavy modifications to a table. It involved adding 6 new columns, removing...

Stupid T-SQL Tricks – Part 3: A Zodiacal SQL

Today we’ll learn how you can use T-SQL to calculate your zodiac sign from your birthdate.
“Heeeeeere’s Johnny!” – Ed McMahon introducing...

Script Corner - Date format

Every now and then we will need to convert datetime to string for display, and would you remember all the...