Tuesday, August 23, 2011

Script all SQL Server jobs and more with SSMS: Object Explorer Details

For years I promptly closed Object Explorer Details when SSMS was launched. Seems this default-launch was changed with SQL 2008, probably due to other DBA’s like me who just wanted it out of the way. Real estate across the horizontal query tabs is in high demand as it is, and especially so if you have anything pinned vertically.

Then one fateful day, while on the hook to script out an epic quantity of jobs, I did some searching. Much to my surprise, Object Explorer Details has a purpose!

To open it in SSMS 2008, click on View \ Object Explorer Details (2005 you seemingly can’t escape it). For an example of how to use it, navigate to your jobs list in Object Explorer and see what you see:

Note that while you can’t select multiple jobs in Object Explorer, you can in the Object Explorer Details window. Select all the jobs you want to script, Right-click \ Script Job As, and you’ve saved yourself a bunch of time. Also you didn’t have to buy a third party tool to get it done. Win!

Thursday, July 14, 2011

My Bio

I started (officially) in IT in ‘95. My 1st job was to run a help desk ($6 / hr) for a start-up ISP, who was offering blazing fast 28k/56k dial up internet access. It was difficult walking people through configuring Windows 95 dial up networking, over the phone, so they could connect to the internet, while they weren’t quite sure what the internet was… So that’s one way to learn how to be patient with users!

Site Purpose

DBAs walk a line between Administrator and Developer. As an Administrator, a DBA makes decisions regarding I/O distribution and is often also a SAN Admin, installs software, manages permissions, and often acts as Server Admin as well. As a Developer, the DBA writes complex SQL code, does application design in the form of stored procedures, SSIS, SSRS, SSAS Development, performs unit & QA testing (which is often times the only testing for this sort of development), assesses application usage and performance characteristics, tunes applications, and so on.