2016-03-29
SQL Server – Database Stuck In Single User Mode
If you've painted yourself into the single_user corner, here is how you can get out.
March 2016
2016-03-24
2016-03-24
Favorite Computer Environment Tools
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.
2016-03-23
SQL Server – Getting All SQL Services Running On System
Getting all services running SQL Server using T-SQL: SELECT * FROM sys.dm_server_services
2016-03-23
PowerShell – Getting All Running SQL Services
Getting all SQL Server services running on a server using PowerShell: Get-WmiObject -Class sqlservice -Namespace “ROOT\Microsoft\SqlServer\ComputerManagement11″...
2016-03-23
2016-03-20
PowerShell – Find Active Node On Cluster
PowerShell script that prints out the state of the node you are on – Active or Passive.
2016-03-20
SQL Server – All Objects On Instance Sorted By Date
One common question I hear whenever something begins to go wrong is, “Has anything been changed...
2016-03-19
Moving Database Files to Another Location
Although moving database files around is simple, it is a still big deal. When you do...
2016-03-19
SQL Server Compare Users Script
If you need to compare two users in SQL Server, here is a handy script. The...