Automated Script-generation with Powershell and SMO
Phil Factor demonstrates how to generate T-SQL scripts for databases, selected database objects, or table contents from PowerShell and SMO.
2012-02-28
3,400 reads
PowerShell
2014-09-12 (first published: 2011-12-22)
3,327 reads
Automating Daily Checks with Powershell
Using Powershell to create color coded backup reports for all servers in your environment.
2011-12-19
14,183 reads
Me, myself and Powershell
Why should any SQLserver administrator, DBA, or Developer be interested in Powershell? Johan Bijens presents a few reasons today.
2011-12-06
7,764 reads
Create a Monitoring Server for SQL Server with PowerShell
At some point you are going to need a notification system for a range of events that occur in your servers. Laerte Junior shows how you can even set up temporary or permanent alerts for any WMI events to give you a system that fits your server environment perfectly.
2011-11-09
3,399 reads
Using PowerShell for SQL Server Transaction Log Backups
How can I use PowerShell to do a Transaction Log backup for SQL Server databases? In this tip we look at an alternative way of creating transaction log backups using a PowerShell script.
2011-10-25
2,854 reads
Using PowerShell for SQL Server Database Backups
If you're starting to learn PowerShell and want to see how you can use it for common DBA tasks, this tip will show you how to create a basic PowerShell script to backup all your user databases.
2011-09-30
3,589 reads
Storing Windows Event Viewer Output in a SQL Server table with PowerShell
Laerte Junior was asked for a quick and easy way to save the output from the Get-EventLog cmdlet in a SQL Server table. Luckily, he already knew about Chad Miller's excellent Out-DataTable and Write-DataTable functions, and has laid out everything we need to use them like pros.
2011-09-19
2,003 reads
Introducing PowerShell V2 Remoting for SQL Server
owerShell can be used to for many SQL administrative tasks; this tip walks through how to run T-SQL code and admin tasks on remote servers.
2011-09-13
3,153 reads
Disk Space Monitoring and Early Warning with PowerShell
Sean Duffy recently had an unwelcome encounter with Exchange Server Back Pressure, which cut off his message flow due to a lack of space on the server. To make sure it didn’t happen again, he found a way to automatically monitor all his servers from afar, with a little PowerShell magic.
2011-09-12
5,092 reads
Blogs
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers