321 reputation
2615
bio website trycatchfinally.net
location Phoenix, AZ
age 33
visits member for 5 years, 1 month
seen Aug 19 at 16:13

My name is Ryan McCauley, and I'm a database/reporting manager for a mid-size cable company. I spent a number of years as a .NET developer (mostly of the VB.NET variety), but now largely focus on T-SQL and the reporting with the Microsoft BI stack.

On my own time, I build small apps to help get things done a little better, and have a couple posted at Codeplex:

  • SQL Space Map - if you have some large SQL Server databases and you'd like a visual picture of which tables and indexes are taking up that space, it's the tool for you.
  • SQL Server Contention Monitor - watches as may SQL Servers as you want and alerts you to blocked SPIDs, showing you the block tree (which process is blocking which, an what others are affected). It's still in a pretty alpha-ish phase, but it despite some instability at times, it gets the job done.

Check them out and let me know what feedback you have!


321 Reputation

5 Aug 27
3 Jul 1
10 May 9
-2 Jan 26
5 Nov 12 '13
0 Oct 18 '13
10 Sep 14 '13
5 Sep 2 '13
5 Aug 26 '13
2 Aug 7 '13
5 Jul 31 '13
5 Jul 18 '13
10 Jul 9 '13
7 Jul 5 '13
2 Apr 24 '13
5 Apr 10 '13
5 Apr 1 '13
5 Mar 13 '13
5 Feb 22 '13
2 Feb 5 '13
10 Oct 11 '12
5 Aug 9 '12
10 Jul 22 '12
15 May 24 '12
10 Mar 16 '12
5 Feb 21 '12
2 Feb 16 '12
5 Feb 2 '12
10 Jan 7 '12
5 Mar 1 '11