Month: March 2016

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.

SQL Server – Cluster Queries

Writer #1, 2016-03-24

Get some clustered facts about your server.

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.

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

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…

PowerShell – Making Arrays

Writer #1, 2016-03-23

The basics of creating a PowerShell array and working with it.

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.

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…

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…

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….