Daily Coping 2 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-02
18 reads
Blog Posts
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-02
6 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
12 reads
3 Important Queries for Testing Your Availability Group Endpoints
In this article, I have shown the importance of performing three different validation tests against your Availability Group Endpoints. Each test also demonstrates what can be run in the...
2021-12-01 (first published: 2021-10-12)
396 reads
Azure Synapse Analytics database templates
One of the biggest announcements at Microsoft Ignite that seemed to be overlooked by a lot of people was Azure Synapse Analytics database templates, now in public preview. I...
2021-12-01 (first published: 2021-11-22)
236 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
136 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
18 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
18 reads
Daily Coping 29 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-29
15 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
63 reads
Blogs
Enterprise AI Operating Rhythm – Top 5 practices for 2026
2025 exposed a growing gap between AI ambition and operational reality. As budgets tightened...
Stop Being Surprised by Your Azure Bill: Use Budgets
By John
When organizations migrate workloads to Azure, the focus is usually on architecture, performance, and...
Resetting on the AI hype train
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
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