Implementing Temporal Tables Where You Have Existing Data

In my post about auditing tools in SQL Server I mentioned a few tools we have at our disposal for...

Redgate at Summit 2017

I’ll be heading out to the PASS Summit next week, spending Halloween in a conference center with a lot of...

Query Store – SQL Server 2017 vs Azure SQL Database

I love the query store, it is powerful (can be dangerous) , easy to use and packed full of information. I...

10 Questions To Spark Conversation At Your Next SQL Event

Photo by rawpixel.com on UnsplashHere’s a word for word transcription of a conversation I’ve had a hundred times over:
“Hi I’m Bert.  What do...

10 Questions To Spark Conversation At Your Next SQL Event

Photo by rawpixel.com on Unsplash
Here's a word for word transcription of a conversation I've had a hundred times over:

"Hi I'm Bert.  What do you do?"
"I'm ____ and I'm a SQL developer."
"That's cool,...

UNDERCOVER TOOLBOX: Find Untrusted Foreign Keys and Orphaned Key data

SQL Server tracks untrusted Foreign keys in sys.Foreign keys with a column called is_not_trusted, there may be a number of...

Power BI Custom Visuals Class (Module 74 – Cylindrical Gauge MAQ Software)

In this module you will learn how to use the Cylindrical Gauge Custom Visual by MAQ Software.  The Cylindrical Gauge...

Webcast: Troubleshooting SQL Server Connection Issues

I will be doing a live webcast on Thursday, November 9th 2017 at 3 PM Eastern Time (8 PM UTC...

But I Don't *Want* To "Restore from a backup of the database or repair the database!"

Do you like Log Shipping?
Before my time at Ntirety I had done quite a bit of work with failover clustering...

SQL Clone Server Service Permissions

SQL Clone is amazing, and it can really save time and disk space for many organizations. I’ve got a series...