Detect Worst Performing SQL Queries

Detect Worst Performing SQL Queries

This series of Videos will walk through how to detect worst performing sql queries which is slowing down Microsoft SQL...

Rebuild System Databases

Yesterday night one of FB Friend have ping me, he has issue with his local SQL Server instance. Our conversation...

Find failed SQL jobs with powershell

This weekend I went to SQL Saturday in Auckland. It was nice to interact with other DBAs again.  Kent Chenery...

Find Login in Active Directory

Find Login in AD

Many times we require to know if particular login is a part of ad user group. Or...

Creating merge replication conflict alerts

One of the challenges in working with Merge Replication is handling conflicts since writes can occur at any node in...

Petitions on Change.org and Thoughts on Changing PASS

I tried this out – Change.org that is – recently as part of a post about PASS and wanted to post a...

January #Meme15 Round-Up

The second round of #meme15 finished up last week and it’s time to see who participated.  In total, there were...

Microsoft Data Appliances Help Simplify MSBI Projects

As some of you know, I am really excited about the data appliances Microsoft and HP have released this year. ...

SSAS fact table dilemma

Here is a situation I ran into recently concerning using a fact table in SSAS.  This experience may help you out if...