Migrating SQL Server logins

Once upon a migration I would use sp_help_revlogin to migrate logins and remap the SQL server logins using sp_change_users_login. During...

Missing Indexes Script v2

As is the case for many DB professionals, I am always tweaking (not twerking) and refining the missing indexes script to try and make it more robust and a...

PASS SQLSaturday Events: June 2014

PASS SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Please...

Password Cracking–Part 1

I’ve run into the not uncommon situation where there is a SQL login and no one seems to have the...

Peace Officers Memorial Day and Half Staff

Today is Peace Officers Memorial Day and that’s why the flag is at half staff (Had to search, I didn’t...

Powershell Tips–PSEdit

I got this from watching a session from Jeffrey Snover at TechEd. It was a neat trick, and it’s worked...

Teamwork Keeps The Ship Afloat

I’m back from my

on the

with a big on

my face.
Like a good

I took lots (over 1400) pictures of

and

and

I also swam with...

Another Shot from The DBA Team photo shoot

Filed under: Blog Tagged: Humor, syndicated, TheDBATeam

Building the SQLSaturday Orlando Marketing Plan-Part 7

Just spent some time re-reading my notes far and my ideas from before – glad I wrote them down, lots and...

Drop Me? No, I Don’t Think So–Question of the Day

Drop Me? No, I Don’t Think So is my latest question of the day and has to do with dropping...