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

Re-blog – January 20 – January 26

Welcome to the Friday Re-Blog summary post.  The aim of these posts is to bring some old posts that newer readers may...

Link: How USB Charging Works

Good discussion of how USB charging works.

SQL Server - Generate SQL INSERT from Excel

Generate SQL Server INSERT statements with Excel Concatenate.
A developer requested  access to a Production database. The details were to COPY...