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

SHUTDOWN SQL Server

I explore the question of if it is possible to reboot the server from within SQL Server or even simply shut down the entire server. Well, you can certainly...

SHUTDOWN SQL Server

Recently a friend by the name of Chris Bell (blog | twitter) wrote about an easy way to disrupt SQL Server....

Deadlocks in a SQL Server Database

Deadlocks in SQL Server happen when 2 (maybe more) processes are fighting over a resource in the database and are...