Currently browsing tag

database

Invoke-Sqlcmd

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.

Mirror-Database

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

Run-MySQLQuery

I’ve found this great function written by Thomas Maurer on his blog. It’s really usefull to automate MySQL queries. Function Run-MySQLQuery { …

Scroll to Top