Lab Sql

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

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

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

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

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

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)

I have an excel sheet with list of columns mentioned in it. I would now like to know what all colum… Read more How To Check If Columns Are Being Used By Views?

Hoping someone may be able to advise what might be happening here. I am attempting to run an SSDT d… Read more Deploying Ssdt Project Through Powershell Script: Version Store Out Of Memory Error