Baltimore Crime Report Using Power BI

As part of my quest for using data to find answers to everyday questions using Power BI – after analyzing baby names...

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

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

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

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

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

SQL Server Audit: Getting Started

SQL Server has the ability to monitor both server and database level events via the SQL Server Audit feature.  Audited...

A pattern to match correctly on a value or a NULL

As you may have noticed if you read my blog I learn a lot from trolling various forums. In this...

Architecture VC AlwaysOn Questions Answered

On July 15th, 2015 I spoke to the PASS Architecture Virtual Chapter about AlwaysOn Failover Cluster Instances and AlwaysOn Availability...

DBTA – StretchDB, a Cool New Feature in vNext SQL Server

Originally appearing in my monthly column at Database Trends & Applications magazine. When it comes to cloud-based database management, there are really only two players: Amazon, the value leader,...