How To Quickly Test A Remote MSSQL Database Connection With PowerShell

YOUR LINK HERE:

http://youtube.com/watch?v=r_g8W17Bvas

If you enjoyed this video, be sure to head over to http://techsnips.io to get free access to our entire library of content! • There are a lot of times when troubleshooting, writing a custom script to deplay a new Microsoft SQL database, or simply creating a SQL Server monitor that you need to ensure your SQL database is always responding to connection attempts. Like PowerShell often does, it can make this process very easy! We'll create a simple function to test our connections in PowerShell and call it Test-SqlConnection. • In this snip, we'll cover how we can build this Test-SqlConnection function by using a few simple techniques which will allow you to quickly determine if your SQL server can be connected to remotely. • Prerequisites include: • An MS-SQL database to test. • Head over to adamtheautomator.com now for hundreds of in-depth, informative how-to articles just like this!

#############################

New on site