Agreed on all counts.

We typically don't upgrade SQL Server in place because we take the opportunity to also upgrade to a new Windows server version as well.

• This reply was modified 11 months, 1 week ago by  daniel bliss.

Well, I answered my own question, which I will share here in case it is of use to anyone else.

My situation is that I had a very long list of...

Keith Dunn (4/21/2009)

---

We solved this using a generic function in the Code area that converts a multi-value parameter list to XML, passing the XML to the sproc and then using...

I use OVER all of the time in order to find duplicate rows based on columns partitioned and ordered using OVER(). In fact, I learned this technique from Itzik...

Hi Michael,

I'm sorry to report that version 2.5.2 still has bugs for case sensitive servers. Namely, there are a couple of "Enabled" columns (from sysjobs) that need to read...

FYI: the uninstall script worked perfectly on the old version, simply by replacing dbWarden with DBA.

Thanks again!

Thanks, Michael. I will test the script as well and let you know how I fare. I'm not concerned with historical data, and so can also drop the...

Thank you so much for this superb monitoring tool.

I assume that if I search and replace 'DBA' for 'dbWarden' in the latest uninstall script, I can remove the early version...

To answer my own challenge, I used two separate tsql queries: one to list all users who have sysadmin rights at the server level, and the second to list per-database...

Geoff A (4/2/2012)

---

i know, in know.... i will eventually get to it. i promise. should be pretty simple since this is still the method i use for my alerting... thanks...

Ditto.

I'd love to see what other tricks Geoff has up his sleeve.