Discover SQL Server TCP Port
Learn how to discover the TCP port for a SQL Server instance from the registry using Windows Powershell.
2008-08-27
4,303 reads
Learn how to discover the TCP port for a SQL Server instance from the registry using Windows Powershell.
2008-08-27
4,303 reads
Earlier installments of this series illustrated how to ping the host, how to check all of the windows services related to SQL Server and how to check the hardware and operating system information. Part 4 of this series demonstrates how to get hard disk and network adapter information from the host machine.
2008-08-18
2,906 reads
This new series examines methods and procedures to check the status of the Operating system, SQL Server instances and databases, using Windows PowerShell. Part One illustrates how to create a PowerShell script to ping the host machine and how to source the PowerShell function and call the function.
2008-06-26
4,215 reads
PSH script to unload table schema, dri, permissions and data to file(s).
2008-06-10 (first published: 2008-05-07)
1,087 reads
Exports and imports SQL Server 2000 Enterprise Manager groups and server registrations using Powershell.
2008-08-27 (first published: 2008-02-15)
2,565 reads
Learn how to perform administrative tasks by accessing the SQL Server 2005 WMI Providers using Window PowerShell.
2007-11-29
2,575 reads
This installment of the series illustrates how to use PowerShell scripts in conjunction with SMO and parameters to Generate an SQL Server Script.
2007-10-31
2,702 reads
Learn how to use PowerShell in conjunction with SMO to Generate an SQL Server Script.
2007-10-26
2,873 reads
You can find the slides for my session at Future Data Driven summit at...
By Steve Jones
I saw someone limit the databases they see in SSMS, which isn’t something I...
Since witnessing a rather nasty cyber attack around a year ago, I’ve been thinking...
Hi all, I have an SQL database table with events, and within it a...
Hi All, I have been trying to download a csv file which is produced...
Hi We have an stored procedure which runs frequently and it contain logic in...