Monitoring SQL Server Agent job run times

Introduction

A few months back, I was asked how long a particular nightly process took to run. It was a super...

Non-Tech Books On My Desk

This post is inspired by Andy Warren’s ( b | t ) “Books On The Desk” post.
I’ve got plenty of SQL Server books...

Reblog: May 3 to May 9

Welcome to this Friday’s reblog summary post.  The aim of these posts is to bring some old posts that newer...

Schizophrenic Windows 8

I’ve been using Windows 8 almost exclusively for about 3 weeks. I got a new desktop a couple months back,...

Speaking in Columbia and Charlotte Next Week

I'm speaking at two user groups next week.
 
Tuesday - Midlands PASS - May 14
I'll be giving a presentation on PowerShell to help...

A Rickety Stairway to SQL Server Data Mining, Part 12: Accessing SSDM with AMO, ADOMD, SSIS, XMLA and RS

by Steve Bolton
                It may set a SQLServerCentral record for the thickest alphabet soup of acronyms ever crammed into a...

Book Review: Business in the Trenches

I’m trying to improve.
That’s at just about everything too. I know I don’t know enough or have enough skills to...

Bring Offline File Online — Modify SQL Server Metadata

In my last post, I demonstrated how to mount a database with missing NDF files. In the end, we still have issues removing tables created over missing files, the...

Bring Offline File Online — Modify SQL Server Metadata

In my last post, I demonstrated how to mount a database with missing NDF files. In the end, we still...

Data cleansing in SSIS, DQS, and MDS

Data cleansing can be done via SSIS as well as Data Quality Services (DQS) and Master Data Services (MDS).  The...