PowerShell Scripts for SQL 3.0
Eighty-nine example scripts for managing SQL Server objects. Initialize PowerShell SQLPS module and work with databases. Scripts for Analysis, Integration, and Reporting services. Experimental support for SQL Server 2016.
item has less then 1 vote
|FileCart Rating||Not yet Rated|
|OS Support||Windows Install and Uninstall|
|File Size||0.19 MB ( 197 KB )|
|Published||Apr 04, 2014 (3 years ago)|
|Updated||Feb 24, 2017 (2 months ago)|
Convert video files between 300+ formats and gadgets. Convert online videos to MP4,...
Get 24/7 foolproof server monitoring and reporting.Try free Servers Alive.
Create advanced database web sites fast. Powerful code generator with events.
Motorbike Simulator 3D Reload 6 minutes ago
Kill And Be Saved 7 minutes ago
Exchange BKF Recovery 13 minutes ago
Passport Photo Tool 14 minutes ago
Skater Obfuscator 14 minutes ago
Office Timeline 15 minutes ago
Batch 18 minutes ago
Acronis True Image 23 minutes ago
Power Spy Software 32 minutes ago
Antamedia HotSpot Software 17 times
winrar 16 times
OST to PST 16 times
OST to PST Converter 16 times
GlassWire 16 times
AV Voice Changer Software Diamond 15 times
Time and attendance 15 times
norton 14 times
Dynamic Applications 13 times
Database engine: Connect to a server instance, manage databases, and publish scripts. Work with policies and SQL Server logs. Maintain security and backups. Create and manage SQL Server jobs. Get extended event information.
Analysis Services: Connect to an Analysis Services instance. Get connection information. Get a list of databases. Backup databases and remove old backups. Restore a database.
Integration Services: Start and stop services. Get package information. Provision a catalog. Publish a project. Modify catalog settings.
Reporting Services: Start or stop services. Get instance information. Backup and restore encryption keys. Get configuration information. Get event log information.
In-Memory Databases (SQL Server 2014 and SQL Server 2016): Get overall utilization. Get size on disk. Get detailed utilization by table. Get checkpoint size.
Query Plan (SQL Server 2016): Set Query Plan desired state. Set Query Plan data retention maximum size. Get Query Plan information. Get Query Store status.
|Requirements:||PowerShell 2.0 and above|
|Release Info:||Major Update on Feb 12, 2012|
|Release Notes:||This is a major product update|
|Related Tags:||PowerShell Srictps SQL database management database administration Microsoft Windows PowerShell|
Review PowerShell Scripts for SQL 3.0
Reviews of PowerShell Scripts for SQL 3.0You can be the first to write a review of PowerShell Scripts for SQL!
Monitor 20 key performance metrics. See throughput of varying types. See 'heartbeat' statistics at different intervals. Up and running in minutes with the easy installation wizard. No agents required. Connect to and run in the cloud (provisional)SQL Integrity Check
Find potentially sensitive data. Search an entire instance or a particular table. Includes 45 pre-configured sensitive data search strings. Export results to CSV format for easy analysis and reporting.SQL Job Manager
Management console to view easily past and current jobs. Identify and correct job contention. Drag and drop jobs across servers to level workloads. At a glance view to see failed or runaway jobs. Customizable calendar view.