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
17 reads
Blog Posts
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)
399 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)
240 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
137 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
19 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
19 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
16 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
64 reads
Log Analytics with Dedicated SQL Pools (Formerly SQL DW)
There are a lot of services in Azure. Way more than a few. What is something you want to do with all your services and applications? You want to...
2021-11-29 (first published: 2021-11-01)
844 reads
Measuring SQL Server File Latency
This post is a reference post for retrieving IO statistics for data and log files in SQL Server. We’ll look at where we can find IO statistics in SQL...
2021-11-29 (first published: 2021-10-06)
577 reads
Blogs
Visualising Vectors in High Dimensional Space
Following on from my previous post on building The Burrito Bot, I want to...
The Intersection Between DevOps and FinOps
By HeyMo0sh
DevOps is about shortening the system development lifecycle. Plan faster, build faster, test faster,...
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
Forums
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Working Better Under Pressure
Comments posted to this topic are about the item Working Better Under Pressure
Identities and Sequences V
Comments posted to this topic are about the item Identities and Sequences V
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers