Transcript
Why DBAs [database administrators] should learn PowerShell
A more efficient way to manage and automate repetitive tasks on your SQL Server.
Create useful tools: Create useful tools that provide functionality you would normally have to purchase. Build your own SQL object dependency viewer or make database and table graphs.
Automate repetitive tasks: Harness those repetitive tasks with PowerShell automation such as backups and restores.
Save time: Save time with executing common SQL Server database administration tasks in parallel, such as regular index maintenance jobs.
Multiple-server automation: Discover and collect information from one-to-many SQL Server engines on your network. Execute a query, retrieve properties or even update configurations automatically.
Monitoring: Use PowerShell to monitor and respond to events on all of your SQL Servers: Monitor disk space or check failed SQL Server jobs.
Import and export files: Use PowerShell for importing and exporting structured data such as CVS or XML [extended meta language]
Creating PowerShell SMO [SQL Server management objects] scripts: Create scripts to document and manage all of your SQL Server instances by retrieving information automatically from multiple instances.
Compliance: Perform automated security and compliance audits on multiple SQL Server instances with PowerShell scripts.
For more information, please refer to Whitepaper: The Guide to Learning PowerShell .
See Also:
- Webcast: 10 Tips and Tricks to Become a PowerShell Ninja
- Whitepaper: The Guide to Learning PowerShell
- Webcast: Creating a SQL Server Database Report with PowerShell
- Webcast: Learn the PowerShell Essentials on Error Trapping
- Webcast: PowerShell Essentials using SQL Server SMO
- Webcast: The Essential PowerShell Tools for the Database Administrator
- Webcast: The Essentials to Tackling Basic PowerShell Functions
- Webcast: The Essentials in Building Basic PowerShell Modules
- Webcast: Using PowerShell with Python and SQL Server
- Webcast: New Features of SQL PowerShell
- Video: How to Integrate PowerShell with SQL Diagnostic Manager for SQL Server
Topics : APIs, CLIs & DevOps,Database Administration,Powershell,
Products :
Why DBAs Should Learn PowerShell?
Idera PowerShell Plus is the most efficient way for database administrators to manage and automate repetitive tasks on their SQL servers. It helps DBAs to save time with executing common tasks in parallel such as regular index maintenance jobs or monitoring events on their SQL servers such as checking failed SQL server jobs.
DBAs can create PowerShell SMO scripts to perform automated tasks such as documenting and managing all SQL server instances or automating security and compliance audits on multiple SQL server instances. PowerShell also allows DBAs to discover and collect information from one-to-many SQL server engines on their network and to import or export structured data such as CVS or XML. Learn More →
