Modern Hardware with 64 CPUs

In today’s world, more often then not you might run into systems that have large beefy hardware.  Hundreds of gigabytes...

SQL Server 2017 Reporting Services: The Basics Part 2

Note: I’ve been meaning to start a series on the basics of SQL Server Reporting Services (SSRS). The last time...

Financial Advice for Techies

I’m not writing a post here on how to manage your money, but I will point you to Troy Hunt’s...

How many plans are in the plan cache for a stored procedure?

It depends on where you’re looking and how many statements are in the stored procedure.
Let’s take a look at some...

How Does DBCC CHECKIDENT Really Work When Resetting the Identity Seed (RESEED)?

(last updated: 2019-01-31 @ 22:45 EST / 2019-02-01 @ 03:45 UTC )
Today’s “Question of the Day” on SQL Server Central, Cleaning up the...

Azure Notebooks – a nice little tool.

Gday,
I’ve been playing with Azure notebooks lately and have found them invaluable as
A teaching aidA test sandboxI’ve been using Python...

How To Check How Far Behind Your SQL Server Log Shipping Secondary Is

Log shipping is one of the simplest and most bulletproof methods to get SQL Server to replicate data to a...

Index maintenance freebies

I didn’t expect anything for free in index maintenance. After all, it takes a lot of CPU and transaction log...

Understanding and working with NULL in SQL Server

Graphic representation of the difference between 0 and NULLImage taken from 9gag.com

According to database theory, a good RDBMS must implement a marker to indicate "Missing or inapplicable information".SQL Server...

Webinar next week on Database DevOps

Next week is my webinar on why the database is the heart of DevOps. You can still register today to...