SQL Saturday Minnesota Precon – The Complete Primer to Infrastructure Tuning

I’m pleased to announce that I’m launching my next round of all-day precon training session at the upcoming SQL Saturday in Minnesota on...

Slash star, dash dash: Be obsessive about comments

I’m working on a new session* that I’ve named “T-SQL’s Hidden Support Feature”. It’s about comments. I’ll get to the...

SQL Saturday and the Alamo

I’ll be traveling this week to SQL Saturday #550 in San Antonio. This is my first time traveling to this...

Audit All Select Statements

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

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