Step by Step Guide to SQL Server AlwaysOn

AlwaysOn technology in MS SQL Server is designed to increase the availability of your database, it is another step toward...

SQL Saturday Speaker Marketing – With Powershell

If you follow the Twitter account for SQL PASS, you probably noticed that they are actively promoting individual Summit 2015 speakers....

Loading XML Data–CONVERT Option 2

I was playing around with some XML lately, and had to load a file that looked like this::

I ran a...

Analytics Platform System (APS) AU4 released

The Analytics Platform System (APS), which is a renaming of the Parallel Data Warehouse (PDW), has just released an appliance update (AU4),...

Connecting, Saving, Discarding, Branching, and Merging in the Big Apple

We’ve got another DLM workshop on Database Source Control taking place in New York City on August 27. It’s in...

Reading Your Execution Plans

I’m putting the finishing touches on the all day seminar on execution plans that I’ll be putting on at DevConnections this...

Professional Development – A Recipe for Success

Originally appearing at ForITPros.com. Joe Webb’s father-in-law spent most of his adult life as a cardiologist. That’s a highly specialized and highly technical area in the field of medicine that...

Reblog: The OLE DB Source and the Oracle Date Literal

SQLKover update:when of the stranger Oracle issues I encountered over the years. Some time after I published the original blog...

Running very large scripts is not a strong area for SSMS

out of memory, argggh!
Am I the only one that has experienced the various out of memory issues with SSMS? Not...

PASS Needs You!

It’s time.
No more procrastinating. No more complaining about the process from the outside. No more excuses.
You have to run for...