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

PASS SQL Saturday Events : May 2013

 
PASS SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server.  Please note that in...

PowerSQL - List SQL Server instance configuration details and sending an automated email

Reblogged from Prashanth Jayaram :
This article walks through how to list SQL Server configurable and non-configurable  instance settings using PowerShell...

SQL Server Events in the UK – May 2013

Things are really ramping up in May and June this year, it’s a great time to be an IT Professional with so...

Well I finally passed the 70-451

So I am now an MCITP Database Developer for SQL 2008. This is a big milestone for me. A few...

Enhance your career by blogging!

When I started my blog two years ago, I never would have thought how much it would help my career.  I...

Getting the lowdown on 18456 errors

If you can establish a connection to a SQL Server, but are having problems logging in to it, you will...

Looking Forward

For the past couple months I’ve been looking forward to a 5 week break, a chance to think about what...

My First White Paper – Top 10 Tips for Optimizing SQL Server Performance

Earlier this year I had the chance to collaborate on my first ever white paper “Top 10 Tips for Optimizing...

PowerSQL – Find Size, Name, LastAccess and Last Modified time of all bak files across ALL Servers.

We came across a scenario where database bak files being created from long time which are no more in use...