Speaking at SQLSaturday Omaha

In just one week, I’ll be traveling west to Omaha to speak at SQLSaturday there.  It’s been a while since...

SET NOEXEC is my new friend

Have never really played around with the option: SET NOEXEC ON
Turns out this can be a helpful way to validate...

#PowerBI and #SSAS Tabular: A Natural Fit with the Power BI SSAS Connector

In late June last month, the Microsoft Power BI team released the Microsoft Power BI Analysis Services Connector. The Power...

Hekaton - Creating a Database :- 2

With a Gentle intro done on Hekaton - In Memory tables, let us continue exploring further. Today, we will quickly create a database...

Maturing Your Database Development Process–Version Control

At Redgate Software, we have a progression of the stages of a database development pipeline. These are the various ways...

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