SQL Server – Cluster Queries Writer #1, 2016-03-24 Get some clustered facts about your server. 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
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
SQL Server Compare Users Script Writer #1, 2016-03-19 If you need to compare two users in SQL Server, here is a handy script…. Continue Reading
Finding Active Node in SQL Server Cluster Writer #1, 2016-03-19 The T-SQL method to find the active node that a SQL service is running on:… Continue Reading
SQL Jobs – Daylight Savings Risks Writer #1, 2016-03-19 For those of us not lucky enough to live in Arizona (where daylight savings is… Continue Reading
Validate SQL Code Without Running It Writer #1, 2016-03-19 Validate SQL Code Without Running It In a nutshell: SET NOEXEC ON; — The script… Continue Reading
SSMS Scripting Partition Scheme With Correct Filegroup Writer #1, 2016-03-19 I almost found a bug… but it’s a feature after all. If you are scripting… Continue Reading