Career Progression

Deciding to change jobs can be one of the most difficult decisions you can make. At Dell I was part...

SSDT-BI and Visual Studio Online

Recently I had to create a new business intelligence project at a client. However, there was no source control present....

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