You are here

Home » Monthly archive

Monthly archive

SQL Server - Database Stuck In Single User Mode

ben himself's picture
published by ben himself on Tue, 03/29/2016 - 04:23

If you've painted yourself into the single_user corner, here is how you can get out.

Tags: 
single_user
sql server
multi_user

SQL Server - Cluster Queries

ben himself's picture
published by ben himself on Thu, 03/24/2016 - 03:24
Get some clustered facts about your server.
Tags: 
sql server
tsql
failover clustering
nodes

Favorite Computer Environment Tools

ben himself's picture
published by ben himself on Thu, 03/24/2016 - 00:36

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.

Tags: 
ditto
sharex
keepass
onenote

SQL Server - Getting All SQL Services Running On System

ben himself's picture
published by ben himself on Wed, 03/23/2016 - 23:11

Getting all services running SQL Server using T-SQL:

Tags: 
sql services
sql server

PowerShell - Getting All Running SQL Services

ben himself's picture
published by ben himself on Wed, 03/23/2016 - 05:02

Getting all SQL Server services running on a server using PowerShell:

Tags: 
powershell
sql services
sql server

PowerShell - Making Arrays

ben himself's picture
published by ben himself on Wed, 03/23/2016 - 04:25

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

Tags: 
powershell
arrays

PowerShell - Find Active Node On Cluster

ben himself's picture
published by ben himself on Sun, 03/20/2016 - 05:54
PowerShell script that prints out the state of the node you are on - Active or Passive.
Tags: 
powershell
failover clustering

SQL Server - All Objects On Instance Sorted By Date

ben himself's picture
published by ben himself on Sun, 03/20/2016 - 05:48

One common question I hear whenever something begins to go wrong is, "Has anything been changed recently?" Finding recent changes can be a good place to search, depending on the issue, so here is a script to do just that.

Tags: 
tsql
objects
sql server

Moving Database Files to Another Location

ben himself's picture
published by ben himself on Sat, 03/19/2016 - 17:18

Although moving database files around is simple, it is a still big deal.  When you do this, you are moving the entire database contents to another location.  If you have the space, a backup beforehand wouldn’t be a bad idea.  This is the script that I use to make this happen.

Tags: 
sql server
database files
migration

SQL Server Compare Users Script

ben himself's picture
published by ben himself on Sat, 03/19/2016 - 17:15

If you need to compare two users in SQL Server, here is a handy script. The output is simply a script to make the “UserToChange” sync up with the “ModelUser”. So this script generates a script.

Tags: 
sql server
users

Pages

CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.
8 + 2 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.

Theme by Danetsoft and Danang Probo Sayekti inspired by Maksimer