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

Day 2: Introduction to MySQL

Story of MySQL is very interesting and involved emotions in it. This is my understanding and my though on Journey...

Digitally Signing a Stored Procedure To Allow It To Run With Elevated Permissions

Have you ever had the need to give elevated permissions via a stored procedure above that what the user calling...

Dates and Times in SQL Server: What about TIMESTAMP?

It occurred to me that we haven’t covered the TIMESTAMP data type in this series about dates and times. TIMESTAMP...

Azure SQL Data Warehouse Gen2 announced

Monday was announced the general availability of the Compute Optimized Gen2 tier of Azure SQL Data Warehouse.  With this performance optimized tier, Microsoft...