Setting up SQL Server to SQL Database (Azure) Replication

I had a need to setup transactional replication from my SQL Server to SQL Database (Azure) where I only needed...

AlwaysOn Availability Groups: Step by Step Setup

An availability group supports a failover environment for a discrete set of user databases, known as availability databases, that fail over together. An availability group supports a set of...

AlwaysOn Availability Groups: Step by Step Setup

An availability group supports a failover environment for a discrete set of user databases, known as availability databases, that fail...

Adding a T-SQL Job Step to a SQL Agent Job with PowerShell

In my last post, I explained how to alter an existing job step across many servers. I also had cause...

DevOps Webinar Tomorrow

A quick reminder that tomorrow, Feb 21 at 12pm EST, I’ll be hosting another DevOps, Database Lifecycle Management (DLM) webinar....

Monday Coffee 2017-02-20

No rugby on last weekend so I didn’t have anything to distract me from working. On another note, my flat...

SQL Server Tips and Tricks

In this article I will be listing the tips and tricks to work like
a Pro. 

So let's get started –

Important keyboard...

Out of memory error because of the very low virtual address space – Error 701 – Trace Flag 8075

If you are dealing with a SQL Server which got a lot of memory, you may encounter the out of...

SQL Cruise 2017 – Western Carribean – my experience

As some readers may know, I am a regular attendee on SQL Cruise s for 8 years now. SQLCruise is...

I’m a VMware vExpert

To add to an already amazing year, recently I was named a VMware vExpert for 2017. I’m honored, humbled, and...