SQLServerCentral.com Community Update for {date}

Problems displaying this newsletter? View online.

Featured Contents

SQL Art: I Made a Christmas Card In SSMS

tedo from SQLServerCentral

A little Christmas fun for you using the spatial features in SQL Server and SSMS.

Steps for Installing AlwaysOn Availability Groups - SQL 2019

Ginger Daniel from SQLServerCentral

With SQL Server 2012 Microsoft introduced the AlwaysOn Availability Group feature, and since then many changes and improvements have been made. This article is an update to another article, and will cover the prerequisites and steps for installing AlwaysOn in your SQL Server 2019 environment. Prerequisites Before implementing your AlwaysOn Availability Group (AG), make sure […]

SQL Server Change Tracking to Optimize Data Refreshes for Reporting

Additional Articles from MSSQLTips.com

You’re a developer responsible for maintaining a SQL Server database used to feed data to Power BI. You realize that some tables don’t have a modifiedDate column and some do. Also, you know the data is updated by the application as well as other processes which makes the modifiedDate unreliable. This is because it may not always be updated when data changes. You need a way to track data changes to ensure only changed rows are updated on reports in Power BI.

From the SQL Server Central Blogs - T-SQL Tuesday #193 – Notes to my past self and from my future self

DataOnWheels from DataOnWheels

It has been a while since my last T-SQL Tuesday blog. When I saw Mike Walsh’s topic for T-SQL Tuesday #193, I was intrigued and inspired – “Notes to...

From the SQL Server Central Blogs - T-SQL Tuesday #193 – Notes to past and future me

Diligentdba 46159 from Mala's Data Blog

The last T-SQL Tuesday of the year is hosted by my good friend Mike Walsh. Mike’s call for us is to end the year on a poignant note –...

Refactoring Databases: Evolutionary Database Design

Site Owners from SQLServerCentral

Refactoring has proven its value in a wide range of development projects–helping software professionals improve system designs, maintainability, extensibility, and performance.

Question of the Day

Today's question (by Steve Jones - SSC Editor):
	Celebrating Tomorrow
Which of these is more appropriate for tomorrow?
Think you know the answer? Click here, and find out if you are right.

Yesterday's Question of the Day (by Steve Jones - SSC Editor)

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?

Answer: 900 bytes

Explanation: 900 bytes is the limit. Ref: Primary Keys - https://learn.microsoft.com/en-us/sql/relational-databases/tables/primary-and-foreign-key-constraints?view=sql-server-ver17

Discuss this question and answer on the forums

Database Pros Who Need Your Help

Here's a few of the new posts today on the forums. To see more, visit the forums.

SQL Server 2019 - Administration

Intermittent Service Freezes and "State 23" Authentication Failure - Environment: SQL Server: 2019 Enterprise (15.0.4430.1) OS: Windows Server 2022 Standard (Build 20348) Virtualization: QEMU/KVM (Standard PC Q35 + ICH9) Security: Bitdefender GravityZone Authentication: Active Directory Domain Account The Problem: I am experiencing a recurring issue where SQL Server intermittently stops responding to queries. The service remains in a "Running" state, but all new and […]

i noticed the sqlhealth extende event is on by default , so can i reduce - hi, i noticed the sqlhealth extended event is on by default , and it logs many thing, Q1) can i reduce few thing so that file size and recording that is wirting from buffer to file can be reduced, thus i will save some resources. q2) and can i add few events which are required […]

SQL Server 2019 - Development

data type gets lost in data flow - Hi, in a simple oledb source->derived column->oledb destination data flow, 2 of my date columns that are converted to varchar, format 101, in the source view, ultimately seem to end up as unicode in the oledb destination. And that seems to bring down the pkg. everywhere else they are dt_str length of 30 . […]

SQL Azure - Administration

New-AzSqlInstanceServerTrustCertificate - Failed and no clues - Using New-AzSqlInstanceServerTrustCertificate to import a certificate and get the message New-AzSqlInstanceServerTrustCertificate: Long running operation failed with status 'Failed'. Additional Info:'An unexpected error occured while processing the request. Tracking ID: 'd21c42cd-515c-40b4-b8b6-60b851c66a39' I've confirmed that the parameters are correct and most articles I've looked at suggest just waiting and trying again. Needless to say, that hasn't worked. […]

Editorials

Your Value from a Conference - Comments posted to this topic are about the item Your Value from a Conference

The Challenge of AI - Comments posted to this topic are about the item The Challenge of AI, which is is not currently available on the site.

The AI Bubble and the Weak Foundation Beam - Comments posted to this topic are about the item The AI Bubble and the Weak Foundation Beam

Article Discussions by Author

T-SQL in SQL Server 2025: The || Operator - Comments posted to this topic are about the item T-SQL in SQL Server 2025: The || Operator

UNISTR Basics - Comments posted to this topic are about the item UNISTR Basics

Stairway to Azure SQL Hyperscale Level 6: Backup and Restore Internals - Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale Level 6: Backup and Restore Internals

Deprecated Feature Tracking - Comments posted to this topic are about the item Deprecated Feature Tracking

Think LSNs Are Unique? Think Again - Preventing Data Loss in CDC ETL - Comments posted to this topic are about the item Think LSNs Are Unique? Think Again - Preventing Data Loss in CDC ETL

A Big PK - Comments posted to this topic are about the item A Big PK

SQL Server 2022 - Administration

SQL Server audit with windows ad group - I am trying to create a filter on a SQL Server audit to capture actions of the members of a Windows AD group. The audit filter allows you to include a filter such as where server_principal_name = 'domain\user_name' Using this filter I included a Windows AD group name, but the audit captures nothing. The audit […]

Deadlock graph anomaly - I've come across what appears to be a strange deadlock anomaly. As seen in the attached image/XML, a typical deadlock is shown (bottom), but then a completely isolated process graph is also shown (top). The top section has appeared in multiple deadlocks on different unrelated databases/app processes. It doesn't appear to be involved in the […]

This email has been sent to {email}. To be removed from this list, please click here. If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. This newsletter was sent to you because you signed up at SQLServerCentral.com.