SQL New Blogger Digest - Week 3

Here are the posts collected from week three of the SQL New Blogger Challenge. It’s been compiled the same way previous weeks’ posts were. Everyone’s doing a great job keeping up...

Availability Group WSFC Failovers During VM Movement

If you experience a WSFC failover during a VMware vMotion / Hyper-V Live Migration with your virtualized SQL Servers when using Availability...

PASS Board Update: April 2015

It’s been a pretty interesting month on the board.
First, we did have a little problem. I’m sure one or two...

Quick Script: Finding Database Owners & Security Admins

Security Is Everybody’s Responsibility
Recently, while diagnosing a permissions issue on a Production database, I realized that I didn’t really have...

Ruminations on Writing Great T-SQL

Today we’re going to try to extend some advice that I once heard from SQL MVP Jeff Moden, which I...

SQL Sentry Pro Explorer is worth it...

UPDATE: 2015-04-28 15:49

- I created a few autohotkey scripts and solved the problem of collapsing panes and a few other...

Instances and Ports with PowerShell

Just a quick post and a day late for #SQLNewBlogger There are some excellent posts on that hashtag and I...

Find blocking using sp_who in SQL Server

Hi friends, in this blog I will tell you how can we find blocking using sp_who system stored procedure. Also,...

SQL Sentry Pro Explorer is worth it…

UPDATE: 2015-04-28 15:49 – I created a few autohotkey scripts and solved the problem of collapsing panes and a few other...

How Many SQL Log Files Do You Keep? - WaterOx Consulting

Reading Time: 2 minutesEver have this happen? You (on vacation): I’ll have another piña colada...
The post How Many SQL Log...