If you’ve ever had to implement Change Data Capture (CDC) for a database in an Availability Group, then you know that the CDC jobs don’t really consider the Availability...
2022-02-03
142 reads
This is part of a series on my preparation for the DP-900 exam. This is the Microsoft Azure Data Fundamentals, part of a number of certification paths. You can...
2022-02-02
78 reads
Checkpoints are essential in SQL Server to help with the durability and reliability of data persisted in the database. When done right, you barely even notice them and performance...
2022-02-02 (first published: 2022-01-14)
528 reads
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...
2022-02-02
11 reads
(This post was co-authored by Erik Darling.) The more things stay the same, the more they change… No, that’s not a mistake. In fact, it’s a reference to long-held...
2022-02-02
59 reads
Well, it’s a new year and a new start, even if I am a bit behind the start of the ... Continue reading
2022-02-02
2 reads
Well back at the end of 2019 I finished writing most of the checks related to the CIS Center for Internet Security requirements. I have yet to write a...
2022-02-02 (first published: 2022-01-21)
2,322 reads
Kerberos delegation is not a new concept in Active Directory; however, setting it up for Group Managed Service Accounts (gMSA) can be a bit confusing. Unlike normal domain accounts,...
2022-02-01
757 reads
Execute the sys.dm_exec_requests DMV in SQL Server Management Studio to get the status of the backup or restore operations.
2022-02-01
183 reads
It is time for T-SQL Tuesday #147 and this month I get to be the host. Since I’m in charge, I usually try to ensure I remember what this...
2022-02-01
24 reads
By Steve Jones
AI is a big deal in 2026, and at Redgate, we’re experimenting with how...
By Steve Jones
Another of our values: The facing page has this quote: “We admire people who...
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Comments posted to this topic are about the item No Defaults Passwords Ever
Hi, We have low latency high volume system. I have a table having 3...
Comments posted to this topic are about the item The Long Name
I run this code to create a table:
When I check the length, I get these results:
A table name is limited to 128 characters. How does this work?