Using PowerShell to Manage SQLServer
This article provides a practical example of how Powershell can be used by DBAs.
2011-04-06
4,478 reads
This article provides a practical example of how Powershell can be used by DBAs.
2011-04-06
4,478 reads
Use Powershell to create a single script that checks over your server and every SQL instance on it to help pinpoint problems.
2014-04-11 (first published: 2011-04-04)
12,478 reads
I was recently asked a question on restoring a database using PowerShell with the following requirements
Take a database backup file...
2011-03-16
2,581 reads
Phil Fator, the self-confessed wild man of T-SQL, finally comes clean: he's a secret PowerShell user. But for the DBA, what is PowerShell without SMO? Is Microsoft giving the latter the care and attention it needs?
2011-03-07
499 reads
I was referred to someone on twitter today who wants to email query results without setting up database mail. I...
2011-02-28
1,959 reads
SQL Server PowerShell Extensions (SQLPSX) includes a set of function for working with SSIS which among other things allow you...
2011-02-07
3,226 reads
A question came up on the SQL Server Central Forums, how could you use Red Gate SQL Compare to automate...
2011-02-02
2,381 reads
Powershell. I have seen the word but what is it? This article gives you a basic introduction to what PowerShell is and how you might use it.
2013-02-22 (first published: 2011-01-24)
24,839 reads
Howdy all…as is so often the case, I’m studying something – Powershell – and I’m in need of a reference to help...
2011-01-06
3,404 reads
Learn how to write a script for regular database backups using Powershell and SMO.
2013-05-17 (first published: 2011-01-05)
21,828 reads
By Steve Jones
Today’s coping tip is to focus on what’s good, even if today feels tough....
Introduction Purity is the operating environment that runs Pure Storage products like FlashArray and...
By Steve Jones
SQL Data Compare (SDC) is a great way to sync data among tables. It’s...
Microsoft is warning of a "BREAKING CHANGE" and indeed this little update took my...
Hi everyone, In below code I am creating a table and inserting some english...