Connect to SQL database server from Powershell

Connect to SQL database server from Powershell, when there is a need to use Powershell script to connect the database and validate something or run any other script then here is the simple Powershell code. If you want to test or connect and run a database query by using a Powershell script, yes, it is simple with the below code, you just need to pass your query using a variable. The database administrators interact with many servers every day, database validation after the change or deployment is really important to make sure DB servers are available and working as expected.

#simple script demonstrates the DB interaction
$SQLServer = "Yourdbserver" # provide your database server hostname
$SQLDBName = "YourDBName"
$SqlConnection = New-Object System.Data.SqlClient.SqlConnection
$SqlConnection.ConnectionString = "Server = $SQLServer; Database = $SQLDBName; 
User ID= YourUserID; Password= YourPassword" 
$SqlCmd = New-Object System.Data.SqlClient.SqlCommand
$SqlCmd.CommandText = 'yourquery'
$SqlCmd.Connection = $SqlConnection 
$SqlAdapter = New-Object System.Data.SqlClient.SqlDataAdapter
$SqlAdapter.SelectCommand = $SqlCmd 
$DataSet = New-Object System.Data.DataSet
$SqlAdapter.Fill($DataSet) 
$SqlConnection.Close() 

#End :database Intraction
clear

Note: Whenever you open a DB connection with Powershell script or any other scripting language make sure you have closed the connection if not it would create some odd issues, one may run into null values in database records, so please close the connection when you done with interaction with DB. Another important thing is you must have all privileges to run the query before you run the script make sure you have opened it with an elevated account. Thank you for reading this article, if you have any questions please let us know. Thank you for visiting my site, for any scripts in these articles you are testing please make sure you have tested this script in our lower environment before you run in production.

Top 5 Notepad++ Tricks that you should know in 2020

Best Minecraft mods in 2021

Windows Minecraft

Pokemon Sword and Shield: Post Game 2021

5 Best Free Youtube Video to MP3 Converters in 2021

Best beat making softwares List

DaVinci Resolve Plugins you Should have in 2021

.