Skip to content Skip to sidebar Skip to footer
Showing posts with the label Powershell
Adding Servers To Sql Management Studio

Adding Servers To Sql Management Studio

Post a Comment
I would like to add a bunch of SQL (mixture of 2000-2005) server instances on different servers to … Read more Adding Servers To Sql Management Studio
Storing Results From Powershell To Sql Table

Storing Results From Powershell To Sql Table

Post a Comment
I have an .ps1 script grabbing applications under each app pool as follows param([string]$appPool) … Read more Storing Results From Powershell To Sql Table
Create A Sql Server User Using Powershell

Create A Sql Server User Using Powershell

Post a Comment
I've written a powershell script that creates a new sql server database and login, and then set… Read more Create A Sql Server User Using Powershell
Azure Automation Runbook Adal Sql Support

Azure Automation Runbook Adal Sql Support

Post a Comment
I am attempting to use an Azure Automation Runbook to run a query against an Azure SQL database usi… Read more Azure Automation Runbook Adal Sql Support
Sql: Query To Set Value Based On Group Parameter

Sql: Query To Set Value Based On Group Parameter

Post a Comment
I need help writing a query to do the following on a table in my DB: Select all rows where the val… Read more Sql: Query To Set Value Based On Group Parameter
Powershell Refresh Excel Without Opening Excel File (package Scheduled Execution Issue With Sql Agent)

Powershell Refresh Excel Without Opening Excel File (package Scheduled Execution Issue With Sql Agent)

Post a Comment
I have an SSIS Package I have developed with an 'Execute Process Task' and 'Data Flow T… Read more Powershell Refresh Excel Without Opening Excel File (package Scheduled Execution Issue With Sql Agent)