T-SQL Tuesday #132: How Are You Coping with Pandemic?
T-SQL Tuesday is a monthly blog party in the SQL Community and this month is hosted by Taiob Ali (b | t) and it’s about a topic I could...
2020-11-10
2 reads
Blog Posts
T-SQL Tuesday #132: How Are You Coping with Pandemic?
T-SQL Tuesday is a monthly blog party in the SQL Community and this month is hosted by Taiob Ali (b | t) and it’s about a topic I could...
2020-11-10
3 reads
T-SQL Tuesday #132: How Are You Coping with Pandemic?
T-SQL Tuesday is a monthly blog party in the SQL Community and this month is hosted by Taiob Ali (b | t) and it’s about a topic I could...
2020-11-10
1 reads
T-SQL Tuesday 132: Coping with a pandemic
This month’s T-SQL Tuesday is hosted by my good friend and data platform MVP Taiob Ali. Taiob’s challenge is very relevant to current season – he asks to blog...
2020-11-10
23 reads
Azure Defender for SQL
If you have been following me or generally topics around Azure SQL Database and security you would know that it is important to leverage Advanced Data Security (ADS) for...
2020-11-09
60 reads
Daily Coping 9 Nov 2020
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...
2020-11-09
7 reads
Daily Coping 9 Nov 2020
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 adding my responses for each day here. Today's tip is to plan a new activity or idea you want to try out this week. At least a […]
2020-11-09
10 reads
Database Fundamentals #29: Create Foreign Keys With Table Designer
The purpose of a foreign key is to ensure data integrity by making sure that data added to a child table actually exists in the parent table and preventing...
2020-11-09 (first published: 2020-11-02)
262 reads
Notes on the 2020 PASS Virtual Summit – Part 1
I’m in learning mode this week, scheduled for two full day pre-cons plus the Summit. I’ve been to a couple of virtual events already this year, but they were...
2020-11-09
83 reads
Protect your SQL Server from Ransomware: Backup Your Service Master Key and More
Not many disaster recovery or SQL migration/upgrade scenarios require the SQL Server instance service master key to be restored.
Some do.
Recently, by far the most frequent and common disaster recovery...
2020-11-09 (first published: 2020-11-03)
726 reads
Blogs
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
Forums
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Can You Let Go of Determinism
Comments posted to this topic are about the item Can You Let Go of...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers