The Invoke-Sqlcmd cmdlet is a SQL Server cmdlet that runs scripts that contain statements from the languages (Transact-SQL and XQuery) and commands that are supported by the sqlcmd utility.
Great! Let’s use it.
But…
The term ‘invoke-sqlcmd’ is not recognized as the name of a cmdlet, function, script file, or operable program.
Database mirroring is a solution for increasing the availability of a SQL Server database. Mirroring is implemented on a per-database basis and works only with databases that use the full recovery model.
Database mirroring setup is a pretty easy thing. The point here is not really to make a complicated process easier but to standadize the way we can set this up.
SQL Server PowerShell | Use the Database Engine cmdlets | Mirror-Database
The best way of checking SQL Server backups is to restore them and run DBCC CHECKDB on the restored database. To do this regularly means that you need to automate the task. Allen White
That’s right. But it’s also a great example on how to work with MS SQL databases (connect, backup, restore, remote, SQLPS Module and more!)
Test Your SQL Server Backups with PowerShell | SQL Server Databases Backup | Challenge your Database – MS SQL (part. 1)
How-to check how many SQL queries can be runned during a defined time on your MS SQL server? Let’s see
Challenge your Database – MS SQL (part. 1) | Challenge your Database – Oracle (part. 2)
Based on Olaf Helper‘s work (http://social.technet.microsoft.com/wiki/contents/articles/900.how-to-sql-server-databases-backup-with-powershell-en-us.aspx), here’s the script to back up all non-system databases for SQL Server, with error handling and logging function.
