PowerShell – List All Directories With Users Who Can Access Writer #1, 2016-04-08 Maybe this is a one-off type of thing, but if you need to see every… Continue Reading
SQL Server – Database Stuck In Single User Mode Writer #1, 2016-03-29 If you've painted yourself into the single_user corner, here is how you can get out. Continue Reading
SQL Server – Cluster Queries Writer #1, 2016-03-24 Get some clustered facts about your server. Continue Reading
Favorite Computer Environment Tools Writer #1, 2016-03-24 The Deep Secrets of My Computing Environment! In my computing environment, I have a set of tools that I rely on because they just make life easier. Here they are in order of (perceived) actual usage. Continue Reading
SQL Server – Getting All SQL Services Running On System Writer #1, 2016-03-23 Getting all services running SQL Server using T-SQL: SELECT * FROM sys.dm_server_services Continue Reading
PowerShell – Getting All Running SQL Services Writer #1, 2016-03-23 Getting all SQL Server services running on a server using PowerShell: Get-WmiObject -Class sqlservice -Namespace… Continue Reading
PowerShell – Making Arrays Writer #1, 2016-03-23 The basics of creating a PowerShell array and working with it. Continue Reading
PowerShell – Find Active Node On Cluster Writer #1, 2016-03-20 PowerShell script that prints out the state of the node you are on – Active or Passive. Continue Reading
SQL Server – All Objects On Instance Sorted By Date Writer #1, 2016-03-20 One common question I hear whenever something begins to go wrong is, “Has anything been… Continue Reading
Moving Database Files to Another Location Writer #1, 2016-03-19 Although moving database files around is simple, it is a still big deal. When you… Continue Reading