Avoid Errors With using SNAPSHOT Isolation From Transactions Under Different Isolation Levels

For older systems where the move to READ COMMITTED SNAPSHOT (RCSI) might not be an option or you’re running a...

SQL Server: Database snapshots vs Database backups

In the article, we’ll walk through the concepts to understand database snapshots, and their benefits and limitations. This article will...

Day 4: MySQL Architecture Continue…

MySQL is an open source and configuration of MySQL is very simple and can be customized per the requirement. MySQL...

Moving Birthdays with Data Masker

Data Masker for SQL Server is a fantastic product, and one that can reduce your attack surface area and exposure...

Friday Reading 2018-05-04

Phew, busy week. In the middle of updating presentations and making sure demos work!
Here’s a few of the articles...

Day 3: MySQL Architecture

Like other RDBMS MySQL also has similar architecture: Connection Layer/Application Layer Logical Layer (Processing) Storage Engine Layer (Physical) – special Connection...

Defining FKs in CREATE TABLE–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...

Setting Windows To Prefer IPv4 Over IPv6

This post is a bit different from my usual SQL Serer posts, I recently hit a problem where a legacy...

Developer, speaker, blogger – how did all of this happen?

It’s been exactly two years today, that I stood on an international “stage” as a speaker for the first time,...

SQL Server Dedicated Admin Connection and Why You NEED It!

DAC or Dedicated Admin Connection is one of those things you don’t know you need until it’s too late.

What is...