Crossing Borders
I’m about to cross a country border for the first time in almost two years. I last left the United States in December 2019. Today I’m flying to Belgium...
2021-10-07
48 reads
Blog Posts
Daily Coping 7 Oct 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-10-07
45 reads
Dealing with foreign keys when deleting rows.
Deleting rows from a table is a pretty simple task right? Not always. Foreign keys, while providing a ton of ... Continue reading
2021-10-07
90 reads
Restore to SQL Managed Instance
Now that we have a Managed Instance built, the next question is how do we get data across? I will break this up into separate posts but the lesson...
2021-10-07
131 reads
Daily Coping 6 Oct 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-10-06
11 reads
How to Design Backups in SQL Server?
The Recovery Point Objective (RPO) and Recovery Time Objective (RTO) are basic concepts related to the information to be recovered and the time that it will take to recover....
2021-10-06 (first published: 2021-09-24)
731 reads
Join me at SQL Trail 2021 to hear the next thing about Temporal Tables
I’ve had the privilege of presenting all over the world about temporal tables in SQL Server including the United Kingdom, Canada, and the United States. The theme of the...
2021-10-06
23 reads
Login Timeouts
I was recently approached at work about a company that was seeing tons of timeouts in SQL Server. I was asked how to troubleshoot this. There are lots of...
2021-10-06 (first published: 2021-09-27)
576 reads
Using NULLIF–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I ran across the NULLIF() function recently, and...
2021-10-06
26 reads
Azure Purview is generally available
After a very long public preview (9 months), Azure Purview is finally generally available (GA). I described Purview in a previous blog (New Microsoft data governance product: Azure Purview)....
2021-10-05
10 reads
Blogs
Resetting on the AI hype train
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
A New Word: Etherness
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
Vibe Coding a Login Tracking System
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
Forums
The Max PK Length
Comments posted to this topic are about the item The Max PK Length
My experience using the GitHub Copilot in SSMS 22
Comments posted to this topic are about the item My experience using the GitHub...
The Microsoft SQL Year in Review
Comments posted to this topic are about the item The Microsoft SQL Year in...
Question of the Day
The Max PK Length
If I create a multiple column Primary Key constraint, what is the most number of bytes I can include in the constraint?
See possible answers