A powershell script to run sql queries and return the output in JSON format suitable to run as a Sumologic script check. This script is designed to execute as a sql script check and the output will be ...

This script simply creates an array, which holds all of the SQL Server related assemblies, and then uses that array to run a foreach loop, loading each assembly.

This script uses runspaces in an attempt to stop the GUI freezing when a long running SQL query is being executed. It can take up to minute to read the AXLAPI.wsdl file and then execute your query. It ...

Lets say I'm going to have 50 various PowerShell scripts to do "stuff".<BR><BR>All of this work is being done for a single application and that application uses 3 different SQL Server 05 (soon to ...

Figure 6. We have really just dipped our toe into the water that is using SMO with PowerShell to explore and report on various portions of SQL server and its database and tables. We can also do things ...

SQL Advisor PowerShell vs. SQL Server Management Studio While PowerShell doesn't duplicate the complete functionality of SSMS, it can duplicate a lot of it. By David Ramel 06/24/2011 When I (along ...

Even now, a full workstation backup seems like overkill. As I have recently discovered though, you can use a PowerShell script to back up a SQL Server Express database.

PowerShell vs. SQL Server Management Studio When I (along with many other people) had a lot of trouble trying to install SQL Server Management Studio in an attempt to switch from the SQL Server 2008 ...