Creating a Linked Server to an Azure SQL Database

Why would you create a Linked Server to an Azure SQL Database?

If you work in a hybrid environment with some...

Do Not Pass GO!

What is the GO statement and why is it so important to use? When do I have to use it?...

How To Enlarge Your Columns With No Downtime

Let’s face it: column enlargement is a very sensitive topic. I get thousands of emails every month on this particular...

Installing the MDS add-in for Excel 2016

For some reason I attract all kinds of misery when working with Master Data Services. Today I was trying to...

Learning to Give Presentations Well (Part 2)

Presentation Zen cover
In Part 1, I gave some advice from Toastmasters. We’ll return to the Toastmasters advice in Part 3....

Microsoft Connect(); announcements

Microsoft Connect(); is a developer event from Nov 15-17, where plenty of announcements are made.  Here is a summary of the data...

Microsoft Connect(); announcements

Microsoft Connect(); is a developer event from Nov 15-17, where plenty of announcements are made.  Here is a summary of the data...

Over-Indexing can hurt your SQL Server performance

Indexes are a vast subject and well documented elsewhere on the web. But, it is still a very commonly asked...

PowerShell for fun (and profit?)

Let's have a liltle fun with PowerShell. Along with, I suppose, a couple of useful things and links.
The post PowerShell...

Presenting Azure Vs. Working With Azure

I have a real infatuation with Azure. I’m especially interested in the Platform as a Service (PaaS) offerings in and...