Get All SESSIONPROPERTY Values for Your Session

As a follow-up to my SERVERPROPERTY() post, this is a quick script to grab all the SESSIONPROPERTY() values from your current session in a table. Useful when you forget...

Dallas Tech Fest – Demo Files for SQL Server CLR: An Introduction

Demo files from my presentation at Dallas Tech Fest 2011.
 
SQL Server CLR – An Introduction – Dallas Tech Fest 2011

Prevent SQL Logins from using SSMS … or any other app

In a continuation of my previous LOGON TRIGGER post.
A downside to SQL logins is that anyone with the username / password...

Locking While Dropping or Altering an Index

Yesterday I was trying to drop some hypothetical indexes in production against a fairly active table. I started causing blocking...

Disable SQL Agent Jobs with PowerShell

I had a need today to disable all of our admin jobs while I moved our admin database to another...

Get all SERVERPROPERTY values for SQL Server

A quick script to grab all the SERVERPROPERTY() values from a SQL instance in a table. Useful when you forget...

Notes for Moving BizTalk’s Databases

Yesterday, I was tasked with helping a team move their BizTalk databases to another server. These are my notes for...

Meme Monday: 11 Words or Less

Thomas LaRock (Blog | Twitter) has started a community blog series call Meme Monday.
Here’s my entry:

Community is nice, but displaces work if...

SQL Saturday #63 – Dallas: Wrap-up

SQL Saturday #63 – Dallas was a great event. The venue was great, although parking was a little unclear (I had...

SQL Saturday #63 – Dallas: Resources

I had the opportunity to present my “What Can You Do With PowerShell?” session in Dallas at SQL Saturday #63....