Finding Groups - Consecutive Months

A step by step explanation on one way to get a consecutive period of months, which could easily be adapted to days, years, or other values.

I'll continue on this track and post a tutorial on eliminating overlapping dates soon.

/*******************************************************
identifying gaps on a month  
*******************************************************/
if object_id('tempdb..#accounts'

Renaming all references inside stored procedures and functions can be migraine worthy without a little help...

If you run across migrating or copying a database structure for some purpose, yet need to change the database references or some other string value inside all the procedures and functions to point to the newly named object, you are in for a lot of work!

I built this procedure

SSMS 2012 Extender for the times you want some organization to the random pile of objects gathering in the dusty confines of that database

When dealing with large amounts of objects in a database, navigation can be tedious with SSMS object explorer. This extender organizes the objects into groups based on schema, helping a developer easily navigate to the appropriate object. The current version didn't work for views, but the other objects were grouped