Introduction What is AWS EC2 I3? Amazon Web Services Elastic Cloud Computing is a service that let’s anyone with a credit card to rent a...

I am very grateful for the career I have passionately pursued these last 20 years, working for small, medium, large, and enterprise...

We now have a finished T-SQL framework, and this is the last post of the series. We start with the complete Template (with the error...

In this fourth installment of the framework series, we will add a T-SQL batching feature to our existing framework we have developed in...

Introduction Recently I had to work with a client that moved its infrastructure between the servers (side-by-side upgrade). Always...

This segment of the framework builds onto what we have already created in Part 2 of the T-SQL Framework. That post showed you how to...

Building the SQL Error Engine In this second post focused on a T-SQL framework (find part one here), we will build the plumbing to...

As a consultant, you experience different environments, with different architectures, different skill sets, and different processes....

We can define a framework in two simple ways: An environment with tools to work with. A scaffold around which we can build an...

Depending on the objective, building a framework allows the architect to imbed the fundamental segments of a structure so that the...

Data Governance made easy – your ultimate stored procedure to get a record count from any table on any server and compare Introduction...

The main idea is to flood most media channels with some quasi-fresh content in little to no time. We use the following freemium services...

Thanks for joining my blog! This is my 1st post. After my first ever visit to both 2018 SQL Saturday in Oregon and 2018 PASS Summit...

How does one enforce referential integrity across separate databases, or servers for that matter? The answer is simple—there is nothing...

There is a great feature in SQL Server Management Studio that I do not see used very often, and that feature is the SQL Server Solution...

In Part I of Check for Errors First, we discovered how to query the error logs, and filter out the noise to find meaningful errors that...

In Part I of Check for Errors First, we discovered how to query the error logs, and filter out the noise to find meaningful errors that...

I have seen a number of environments concerned with performance issues, and jump to looking at performance metrics when these performance...