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

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