Window Server 2008 Failover Clustering Logs

In Windows 2003 failover clustering, Cluster nodes continuously putting details in log file on each node. This log is in readable plain text format & located in %SystemRoot%Cluster folder...

Window Server 2008 Failover Clustering Logs

In Windows 2003 failover clustering, Cluster nodes continuously putting details in log file on each node. This log is in...

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