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

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

What’s Your Vision for PASS?

The PASS election slate was released for 2020. The candidates and their statements are:: Hamish Watson (@thehybriddba) Joey D’Antoni (@jdanton) – Community Matters–Why I’m Running for the PASS Board...

[Solved] SQL Backup Detected Corruption in the Database Log

Summary: In this article, we will discuss about the ‘SQL Backup Detected Corruption in the Database Log’ error. It will also describe the reason behind the error and manual...

Azure DevOps–Using Variable Groups

I was in a webinar recently and saw a note about variable groups. That looked interesting, as I’ve started to find that I may have lots of variables in...