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

How to default SSRS date parameters to the first and last day of the the previous month

Populating default dates in SSRS can be helpful to save the user from having to constantly input the date range...

PowerSQL – Find and Replace string on multiple file of local or remote machine

Copy and Paste the below content in Set-FindandReplaceString.PS1. Please read the instructions carefully. Try to do a dry run on some...

A Replacement for DBCC IND in SQL Server 2012

Each release of SQL Server is chalk full of new features and an assorted amount of bells and whistles.  Some...

SQL Saturday #211 Chicago Wrap Up

This past Saturday I had the pleasure of speaking at one of the largest SQL Saturdays I have ever attended...

SQLSaturday#235 in NYC Announced!

{Start Circus bumper music here}  LADIES and GENTLEMEN; SQL SERVER
PROFESSIONALS of ALL AGES, Come one, come all! 
Get ready for a...

Cool Tool – SQL Space Map

I came across a cool open source tool called “SQL Space Map“.
The tool, written by Ryan McCauley, presents a visual representation...

Cumulative Update – 12 for SQL Server 2008 R2 Service Pack 1 Is Now Available !

The 12th cumulative update release for SQL Server 2008 R2 Service Pack 1 is now available for download at the...

Featured on ITCentralStation this week

WOW! This week I was featured on the ITCentralStation.com home page as their Reviewer of the Week with my review of...

Necromancing the Chicken

First off, I’m sorry this space has been dead for so long. I’m sure I’ve dropped off many an RSS...