There are multiple ways by which we can find a list of SQL Server instances name instances on a machine. In this blog, I would show a few ways to do it.
PowerShell – Script to Listing all Backups Taken with SQL Server
A handy PowerShell script for listing all backups taken for each database on your SQL Server, one I keep on my USB drive for customer visits.
PowerShell – Tip: How to Format PowerShell Script Output?
Raw PowerShell output is hard to read. Here are three common ways to format PowerShell script output, starting with Format-Table, so results make sense.
PowerShell Scripts – get-process with SQL Server process
I was playing with the get-process cmdlet in PowerShell. Here is how to use get-process with SQL Server to find the sqlservr process and its details.
PowerShell – Create a User with Read Rights on a Database
A DBA kept creating database users by hand. Here is a simple PowerShell and SMO script to create a user with read rights on a database.
PowerShell – Reading Tables Data Using Script
Read-SqlTableData is a PowerShell cmdlet for reading tables data from SQL Server without writing a query. Here is how I tried it on my box.
SQL SERVER – GetRegKeyAccessMask : Could Not Get Registry Access Mask For Registry Key – SQL Server Cluster
In a two-node SQL Server Cluster, SQL would not come online on one node and wrote no ERRORLOG. The cluster log showed GetRegKeyAccessMask. Here is the fix.