SQL Homework – December 2021 – Changing collation
I can only speak for the locations I’ve worked at of course, but in all of the places I’ve worked ... Continue reading
2021-12-10 (first published: 2021-12-02)
321 reads
Times Like These with SQL Server
I was doing some conversion of Oracle code (PL/SQL) to SQL Server code (T-SQL) – which had some quirks. I just thought that I’d share a quick tip that...
2021-12-02
30 reads
Configure SQL Server on Linux for Active Directory Authentication
In this post, we’re going to walk through configuring Active Directory authentication for SQL Server on Linux. We will start by joining the Linux server to the domain, configuring...
2021-12-13 (first published: 2021-12-01)
329 reads
Be careful with table updates
The dire warning in the subject line is not meant to scare you. Rather, it is advice that is going to be useful to those of us who need...
2021-12-01
154 reads
Daily Coping 1 Dec 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-12-01
28 reads
Building a pacemaker cluster to deploy a SQL Server availability group in Azure
There are new Ubuntu Pro 20.04 images available in the Azure marketplace with SQL Server 2019 pre-installed so I thought I’d run through how to create a three node...
2021-12-08 (first published: 2021-12-01)
290 reads
Daily Coping 30 Nov 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-11-30
28 reads
Fail activity in Azure Data Factory and Why would I want to Fail
(2021-Nov-30) I heard a story about a young person who was asked why she was always cutting a small piece of meat and putting it aside before cooking a larger...
2021-12-10 (first published: 2021-11-30)
498 reads
Hiding Email with a Dynamic Data Masking Function–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Dynamic Data Masking is a feature that provides...
2021-12-08 (first published: 2021-11-29)
342 reads
Get SQL Server 2022 Now: It’s Called Azure
If you’re like me, your palms went into a cold sweat to get your grubby fingers on the bits for SQL Server 2022 a few nanoseconds after you heard...
2021-11-29
73 reads
Blogs
It’s 2026 and I’m retired, so lets get Visual Basic 6.0 to run on Windows 11
In 1999 I released my first commercial software product. ShutOff 2000 was a Windows...
Car Update October 2026
By Steve Jones
This month I want to look at a few of the things I’ve seen...
SQL Server 2016 Has Reached End of Support. Now What?
By SQLPals
SQL Server 2016 Has Reached End of Support. Now What? On...
Forums
PostgreSQL 19 Is Late
Comments posted to this topic are about the item PostgreSQL 19 Is Late
Hyperscale Replicas V
Comments posted to this topic are about the item Hyperscale Replicas V
A Heavy Heart
Comments posted to this topic are about the item A Heavy Heart
Question of the Day
Hyperscale Replicas V
I have an Azure SQL Database Hyperscale Edition system running with a geo-replica enabled. Can I create a new geo-replica based on the current secondary geo-replica?
See possible answers