Nice script. I did something similar for SSAS databases using powershell. One thing I added eventually was a simple windows app front end. You can populate drop downs with instances/databases...

Gary Varga (9/23/2014)

---

Andrew..Peterson (9/23/2014)

---

I don't like the safari browser (Ok, IMHO - it sucks).

Thought about getting a windows phone, but it will not sync with my local Outlook. I can...

I'm going to make a guess and say they tested extensively and probably estimated they could handle X amount of traffic with only an X number of issues. Their engineers...

I haven't worked with triggers in a while and wondered why someone would create a trigger without utilizing the inserted and deleted virtual tables. I guess someone needs that functionality?

Adding to what Davos mentioned. I've run into several issues where I can't reproduce issues from production on dev when dealing in virtual server environment. It gets quite frustrating when...

Explains my love for AutoIt! I've used it so many times in the past and it's saved me and the company countless hours by eliminating remedial tasks.

A personal major hurdle for myself is knowing something could be better and leaving it alone. OCD? Maybe. It keeps me up at night if I let...

With our CR process it takes me a week to get a procedure change pushed. A full version upgrade on a production DB would take about 1 year and an...

Thank goodness for Top Gear teaching me what a lorry is, or I never would have gotten this right. 😎

I mostly use Redgate and home grown solutions for DDL audits. Fortunately, I work mostly with OLAP databases and DML is not as big an issue. That auditing is handled...

I feel so illuminated now.

The best developers that I have worked with use ORMs against a set of views in an application schema and also utilize procedures for all DML. They were also good...

Timely Manner is definitely a subjective term. I've worked in shops where it's a nightmare to upgrade systems because they risk no longer being supported by MS. I've also worked...

"A synonym is used to create a short name for an object, replacing the four part naming of an object with a shorter name."

Not entirely accurate as Four-part names for...

I guess I'm too cynical. The world is going to end soon, so why bother changing.