316 reputation
2615
bio website trycatchfinally.net
location Phoenix, AZ
age 33
visits member for 4 years, 11 months
seen Jul 1 at 17:02

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!


Apr
24
accepted Does the “Cancel Server Request” option in Outlook actually do anything?
Apr
24
comment Does the “Cancel Server Request” option in Outlook actually do anything?
I realize that this command wouldn't necessarily kill whatever Outlook is doing that's locked up the main UI thread - of which "server request" is only one thing - but it seems like bad practice to lock up the UI anyways. I gave this a bit more thought - if the UI thread is locked, this command won't do anything, because the message pump is locked too. If the GUI is responsive, but waiting on server response, this command likely works. However, in cases like mine when the interface is physically unresponsive, this command likely won't have any impact at all.
Apr
24
asked Does the “Cancel Server Request” option in Outlook actually do anything?
Apr
15
comment microsoft mouse and keyboard center doesn't show my mouse
FWIW, my mouse is supported but switching the software to a left-handed configuration (which involves reprogramming the two buttons, not just checking an "I'm left handed" or "Swap buttons" checkbox) doesn't actually seem to do anything - my mouse still acts right handed. It's not even bloatware that works, which is even more irritating...
Mar
13
comment Can I play Blu-ray movies from an external drive?
Okay - given that, I found another conversation (avsforum.com/t/1232083/…) where the person is saying that the data is encrypted at rest and that the encrypted stream is sent the player, so HDCP isn't a factor until the player, which decrypts the signal - once it's decrypted, then the whole path has to be HDCP compliant. That seems to support that a USB drive (or eSATA, for that matter) would be fine.
Mar
13
comment Can I play Blu-ray movies from an external drive?
I read through the thread you attached, and through informative, it doesn't make any specific mention of a connection via USB, but I take your answer to mean that if a drive works directly in my PC, it would work in a USB enclosure? Or are you saying that the USB enclosure has to specifically support HDCP by having an internal chip (which I'm sure it doesn't)? I'd like to say the issue is clarified, but it's not - or maybe I should interpret that as "it won't work".
Mar
13
asked Can I play Blu-ray movies from an external drive?
Feb
23
comment Proper Outlook Free/Busy status when working from home
The irony isn't lost on me, BTW, that I asked this question a year ago, though there seems to be no less ambiguity about how I'm supposed to be scheduling this :)
Feb
23
comment Proper Outlook Free/Busy status when working from home
I'll still find it useful :) So it sounds like, in an office where telecommuting is common, there's no need to denote remote work days on your calendar at all. However, in my case, I'm at a workplace where telecommuting is still pretty uncommon - everybody in my group does it once day/week, but that's far more than average, and it's still not common practice to include a conference bridge in meeting invites (though that's changing). In my case, I'm not able to attend in-person on these days, but I'm still fully available. Should I signify these days in any way on the calendar?
Feb
10
comment Downsides to Microsoft Excel 2007 XLSB binary format?
Just for reference here, I've been using XLSB almost exclusively since posting this question a year ago, will no ill effects - no corrupted data or files, and in addition to be smaller, they load in about half the time.
Feb
10
comment Downsides to Microsoft Excel 2007 XLSB binary format?
Thanks for letting me know - I suppose if third-party software is going to allow the import of Excel files, they won't implement two different formats, and will likely only support XLSX, as that's the more "Standards-based" one.
Feb
8
awarded  Notable Question
Feb
5
accepted Change CTRL-X, -C, and -V hotkeys in Windows to different keys
Feb
4
awarded  Popular Question
Nov
29
awarded  Taxonomist
Nov
20
comment Way to automatically compress images pasted into Outlook emails?
@Hennes: The answer is generally "no", and I delete where I can, but the mail server size restrictions mean I have to be extra-vigilant about it. Also, there are cases where I want to keep an email chain but not the screenshot, and I can't delete an inline screenshot - I can remove an attachment (from an HTML email, for example), but if the user sends the email as "Rich Text" then the image is pasted directly in the email and can't be removed.
Nov
20
asked Way to automatically compress images pasted into Outlook emails?
Oct
24
comment Change CTRL-X, -C, and -V hotkeys in Windows to different keys
Hmm - those hotkeys seem to work (I had no idea), though they're not really what I'm after, as they're awkward to reach with my right hand. Good to know, though!
Oct
17
awarded  Popular Question
Sep
6
comment How can I merge duplicate contacts in Outlook?
I think this is a method for removing duplicate contacts - ie you accidentally selected all your contacts and copied them into the same folder, creating two of everything. It won't remove duplicates of individual contacts.