Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

What do you use for creating admin utilities Expand / Collapse
Posted Wednesday, August 29, 2012 5:48 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, March 16, 2015 5:41 AM
Points: 7, Visits: 32
I moving in to more SQL Server support coming from UNIX based Sybase. When coding administartive utility code ouside of provided interfaces, I generally use a cobination of shell scripts,isql and and some Perl. What tends to be the most popular methods for supporting SQL Server. Scripting/Programming/Other tools?

Post #1351531
Posted Wednesday, August 29, 2012 6:12 AM



Group: General Forum Members
Last Login: Today @ 12:16 PM
Points: 17,064, Visits: 31,952
The vast majority is done through the provided interfaces and T-SQL. But if you're really interesting in automating administration of the servers and instances, PowerShell is your bestest friend in the world.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of:
SQL Server Query Performance Tuning
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1351548
Posted Friday, August 31, 2012 6:41 PM



Group: General Forum Members
Last Login: Today @ 3:44 PM
Points: 2,109, Visits: 7,063
I concur 100% with grant. You can do a ton with TSQL, use Powershell for stuff you cant do with TSQL.

Redgate tools are awesome too: The comparison utilities (schema and data compare) have helped a ton lately.

-- Alan Burstein

Best practices for getting help on SQLServerCentral
Need to split a string? Try DelimitedSplit8K or DelimitedSplit8K_LEAD (SQL 2012+)
Need a pattern-based splitter? Try PatternSplitCM
Need to remove or replace those unwanted characters? Try PatExclude8K and PatReplace8K.

"I can't stress enough the importance of switching from a 'sequential files' mindset to 'set-based' thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code. " -- Itzek Ben-Gan 2001
Post #1353116
Posted Saturday, September 1, 2012 11:39 AM



Group: General Forum Members
Last Login: Today @ 7:41 PM
Points: 41,604, Visits: 38,955
To wit, I use xp_CmdShell to call Powershell.

--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

Helpful Links:
How to post code problems
How to post performance problems
Post #1353155
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse