When Do You Ask for Help?

Reading Time: 3 minutesBeing on the edge of a cliff is a common feeling when running a small business

Stepping Back
I...

Changing File Associations in Windows 8

A quick post, and a good reminder of something that can be a pain. I had to do a quick...

Difference of Index Partition and Creating Service application in partitioned Mode

Hi All,
I am sharing the response and question which I received on my mail based on past post : “Configure search...

Exam Prep 70-463: Data Flow Transformations

This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...

Installing multiple default instances on a single server

As you probably know, SQL Server allows only one default instance per server. The reason is not actually something special to...

Minion Reindex 1.1 Release (and re-release)

We released Minion Reindex version 1.1 last week. The changes are fairly small: Made sure Minion Reindex handles all nonstandard naming...

Power BI Workshop Videos

I’ve created a series of five tutorial videos for a set of workshops I’ll be doing at several events this...

Power BI Workshop Videos

I’ve created a series of five tutorial videos for a set of workshops I’ll be doing at several events this...

SQL Judo’s Monthly Challenge – February 2014 – KILL with the DAC

Every month SQL Judo (Russ Thomas) (b/t) challenges us to do his Monthly DBA Challenge. I’ve decided it would be...

SQL- Querying XML attributes from XML Column

Read XML column attributes in to two columns DimType and Dimvalue  from the below example also retrieve the data matching...