436 reputation
4920
bio website trycatchfinally.net
location Phoenix, AZ
age 33
visits member for 5 years, 2 months
seen Jul 23 at 16:48

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!


Jul
22
comment Non-invasive way for our network team to run ping/tracert/etc from various servers
Thanks for the detail - it's a mix of Windows and Linux. I do trust them with basic access and that's less of an issue than the perceived "you're asking us to do your job for you and we won't" response I'd expect to get if I just give them shell access directly the server. They'd prefer not to ever connect to our servers and to leave verification up to the server admins, but I'm trying to suggest a way that we can shorten troubleshooting time by improving access, but without shifting a perceptible amount of responsibility.
Jul
22
comment Non-invasive way for our network team to run ping/tracert/etc from various servers
@mfinni I've updated the question - it's mostly Windows 2008/2012 and Red Hat Enterprise Linux.
Jul
22
revised Non-invasive way for our network team to run ping/tracert/etc from various servers
added 19 characters in body
Jul
22
asked Non-invasive way for our network team to run ping/tracert/etc from various servers
Jul
2
awarded  Curious
May
13
awarded  Famous Question
Apr
29
awarded  Popular Question
Jan
16
awarded  Famous Question
Dec
16
comment Team Foundation Server in our development lab vs. production
This might work - I'll try it tomorrow. I can definitely set it up to use NTLM, so I've got just a little bit of hope :)
Dec
16
awarded  Yearling
Dec
11
comment Team Foundation Server in our development lab vs. production
I agree with you that it's not an ideal setup and I would love to see something different, but I don't make the decisions, I just work with them. I was really hoping for a potential solution to my problem rather than reasons why I shouldn't have my problem in the first place.
Dec
10
comment Team Foundation Server in our development lab vs. production
The problem is that the TFS server is in production, not the lab - when we stood it up 6 years ago, we didn't have a lab. Now, we're being encouraged to do all development in the lab, and we don't have any source code access there (hence this request). We do have the option of checking code out in production and copying it into the lab, working on it, copying it back and checking it into the server in production, but that's a terrible processes. We could stand up a new TFS server in the lab and export/import all the code, but since dev still happens in both places, we're still stuck.
Dec
10
asked Team Foundation Server in our development lab vs. production
Jun
10
awarded  Popular Question
May
14
comment SQL Server 2012 with account NT Service\MSSQLSERVER access is denied in domain
You're saying it was set to use the service account previously, and it worked without issue? As I understand it, that's not possible - the service account is local to the machine, and won't authenticate on any other servers/workstations (unless maybe as the guest account, which is usually disabled). Switching to a proxy domain account is the way to go in any case, and the recommended method when your sql service needs to communicate with other machines on the domain.
May
14
answered SQL Server 2012 with account NT Service\MSSQLSERVER access is denied in domain
May
13
answered Remote Desktop Access + IIS Manager
May
13
comment Remote Desktop Access + IIS Manager
What are you trying to accomplish? If you're asking them to manage IIS sets (or allowing them to manage all IIS sites, including application pools), what kind of users are they if not administrators? Depending on what other needs they have on the server, you might consider revoking remote desktop rights, but allowing them to use the remote IIS Management tool instead: iis.net/learn/manage/remote-administration/…. Would that work, or do to have to use the desktop?
Mar
25
awarded  Notable Question
Feb
11
awarded  Notable Question