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

Why the stored output of SQLCMD has only Length property instead of column names?. Is it not possib… Read more Powershell - Sql Query Result To Variable With Properties

Not sure if this belongs on serverfault or not... I am following the instructions on this site for … Read more How Do You Send In Multiple Commands To Sql Powershell From The Windows Command Line?

Hi I am trying to do this Import-Csv C:\sl.csv |$pass = convertto-securestring 'abc123'-as… Read more Powershell Secure String Conversion

I have looked around online for a while now and found many similar problems but for some reason I c… Read more Connect To Sql Server Database From Powershell

I want to do this by executing PS Script from my local machine.. where DB server is remote machine.… Read more How To Insert Data Of A Csv File Into Sql Server Db Table Using Powershell

I'm perverted in the sense that I hate exploring code and database structures in a tree view an… Read more How Do I Get The Content Of A Sql Stored Procedure In Powershell?

When I run powershell using invoke-webrequest on a URL without an ampersand everything works. But m… Read more Stubborn Ampersand With Invoke-webrequest Sql & Powershell

I'm trying to write a powershell script which will execute sqlcmd.exe to run a sql script. The … Read more Passing Path To Sqlcmd Within Powershell Script

I have a powershell script that writes every file and its attributes recursively starting from a sp… Read more Building Batch Insert Statement Powershell To Sql

I have made the following PowerShell script: Set-Location D:\folder1\folder2\folder3\folder4; Get-C… Read more Powershell Returns Negative Exit Code While Script Results Are Correct

I know SQL Server 2008 has exposed some features to PowerShell as snapins. Now I want to know wheth… Read more Can I Use Powershell With Sql Server 2005?

I'm not able to insert into an always encrypted table using PowerShell, the code I'm using … Read more Unable To Insert Into An Always Encrypted Table Using Powershell