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

vCenter Server fails to start, Purge and Shrink Vcenter SQL Database

One of my client vCenter Server fails to start as below shown error in event logs.Could not allocate space for...

Gartner Magic Quadrant for BI 2017 Top 3 Rankings

This is a different spin on the top three vendor rankings visualized in Power BI.  According to the placement of...

The Costs of Hiring Cheaper Consultants

From time to time, I see posts in forums from people complaining about how much some consultants charge. A really...