Two Words For Faster Scalar Functions

Watch this week's video on YouTube
WITH SCHEMABINDING optimizations were added all the way back in SQL Server 2005.  So why bother talking about them in 2018?
Because no one is...

Journaling

Most of the work I’ve done for the past couple years doesn’t require taking much in the way of notes....

Azure SQL Database – Firewall Rules

If you decide to use IP addresses to control what services have access to your Azure SQL Database, then understanding...

Indexing In Memory OLTP Tables

Indexing on In Memory OLTP tables is a little different from your traditional on-disk rowstore tables…
In Memory Differences…
There is no...

Overview of DML Operations – SQL Delete

This article on the SQL Delete is a part of the SQL essential series on key statements, functions and operations...

Advent of Code 2018 – Day 1 (Chronal Calibration)

Advent of Code
This guy by the name of Eric Wastl (t) created this neat web site called “Advent of Code“....

Updating SSMS to 17.9.1

I went to download the SSMS v17.9.1 package the other day and saw this:

I remember some issues with a C++...

Database Fundamentals #20: Using the JOIN Operator, Inner Join

It is entirely possible to try to JOIN two tables on almost any field, as long as the two data...

Where do data breaches come from?

I recently did a bit of research on the source of data breaches. In this post, I’ll talk a bit about my current favorite source for breach information, and...

SQL Homework – December 2018 – Configure SSMS

I’ve committed to posting a piece of homework for you to do each month. I post at the beginning of...