The Activity Monitor is unable to execute queries against the server !

I’m generally not a great fan of Activity Monitor which is built in with SSMS,however today I wanted to check...

Want me to do a presentation?

I greatly enjoy doing presentations on a variety of topics, such as Business Intelligence, SQL Server, and personal development.  If you...

Calculating the next beginning of month and the current end of month

Handling dates is always a fun challenge in T-SQL! Finding the current end of month and next months beginning of...

Colorado SQL Events : May 2013

All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...

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