Audit All Select Statements

Legislation and regulation sometimes dictates that certain activities must be tracked within a database. On occasion, it will be required...

Top 5 books on Enterprise Architecture

My post the top 3 books for becoming TOGAF certified punlished   last week looked at books on preparing for the...

Current Running Queries

Following script is perhaps the most executed script in my 10 year Database Administration career. The script has been my...

Create a Date Dimension in Azure SQL Data Warehouse

Most data warehouses and data marts require a date dimension or calendar table. Those of us that have been building...

AlwaysON database NOT SYNCHRONIZED and RECOVERY PENDING

AdvertisementsAlwaysON database NOT SYNCHRONIZED and RECOVERY PENDING
 
I have recently come across an issue that, one of my alwaysON secondary replica...

BIT9 PathNames

We live in a day and age when security (data, network, server, etc) is seemingly at the forefront of the daily news.
Related Posts:

Cannot Open Backup Device January 1, 2020...

BIT9 PathNames

We live in a day and age when security (data, network, server, etc) is seemingly at the forefront of the...

What is the Lambda Architecture?

Lambda architecture is a data-processing architecture designed to handle massive quantities of data (i.e. “Big Data”) by using both batch-processing and...

Visual Studio Live!–Washington DC–Save with me

I’m going to be speaking this fall at Visual Studio Live, Washington D.C. edition on Oct 3-6. This is my...

Fix that page

I am in a fix-it mood so for this blog I am going to corrupt a page and then show...