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 ...

RunSQLCommand Command line SQL query tool for SQL Server written in Powershell This designed to be a basic tool for quick lookups. Its primary audience sroduction application support admins. It only ...

SQL Advisor Query SQL Server with PowerShell Get the right information on your SQL Servers via the Get-Service cmdlet. By Joshua Jones 03/10/2011 Last time, I discussed how to get PowerShell and SQLPS ...

To wrap up this series of PowerShell articles, let's take a look at a few tips and tricks for working with PowerShell in SQL Server on a regular basis.

To query any SQL database from PowerShell, you need to have the SQLPS module installed along with a few supporting packages. I am going to be focusing on the SQL Server 2012 packages in this article.

Microsoft's premade templates allows for the deployment of SQL databases without having to use complex PowerShell commands.

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 ...

Yep! Any T-SQL query; execute stored procedures, insert, update, drop, etc., but you can't use GO. If you have a query with GO in it, you can just run each section independently: Code: ...