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...
2016-03-19
Finding Active Node in SQL Server Cluster
The T-SQL method to find the active node that a SQL service is running on: SELECT...
2016-03-19
SQL Jobs – Daylight Savings Risks
For those of us not lucky enough to live in Arizona (where daylight savings is ignored...
2016-03-19
Validate SQL Code Without Running It
Validate SQL Code Without Running It In a nutshell: SET NOEXEC ON; — The script now...
2016-03-19
SSMS Scripting Partition Scheme With Correct Filegroup
I almost found a bug… but it’s a feature after all. If you are scripting out...
2016-03-19
AdventureWorksDW Databases – 2012, 2008R2 and 2008
AdventureWorks sample databases seem to be so hard to find when you want them. Here’s a...