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

SQLPort in Coimbra

One more project can be finally revealed – on the 5th of May of 2015, SQLPort is invading the home base...

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

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

How to restore Master database – SQL Server System Database?

Steps to restore SQL Server Master Database :-
1) Stop SQL Server Services

2) Add [-m] startup parameter in SQL Services from...

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

Remotely shutting down an instance

This month for T-SQL Tuesday Mike Donnelly (b/t) decided to pick a topic to fit in with Ed Leighton-Dick’s (b/t)...

Backup before you restore

You should always be recoverable. If you haven’t heard that before, take note of it. It’s important.
A while back...