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

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

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

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 […]

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

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

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

Strange T-SQL Operator Syntax

I can’t remember where I saw this, but it made an interesting Question of the Day: select * from Sales where Profit !< 10000; I had never seen anything...

Configure Windows Server 2019 Multi-Subnet Cluster - Part 11

Monitoring and Tracking SQL Server Blocking & Deadlocks process

Introduction SQL Server deadlock one of the issues that can be happened in any SQL Server, today in this article I will not explain what is Deadlock and How...