I am not much for working in languages other than English. That's my native language and I know little about others. However, the last few years I find myself using emojis more and more in quick communications as they seem to add some fun to the interaction. And those interactions need to be stored in […]
2025-12-05
201 reads
SQL Server 2025 and .NET 10 bring several new improvements to storing JSON natively in the database and querying it quickly.
2025-12-05
Security in cloud environments is both challenging and fascinating, particularly for Database-as-a-Service (DBaaS) offerings like Amazon RDS, GCP CloudSQL and Alibaba ApsaraDB RDS. The cloud vendor acts as the system administrator, managing the operating system, patching, and backups, while the user manages their data and databases.
2025-12-03
Create your own test lab on Hyper-V to evaluate SQL Server 2025 and Windows Server 2025
2025-12-01 (first published: 2025-09-19)
2,043 reads
Learn about the critical 823 and 824 errors in SQL Server and how to deal with them in this article.
2025-12-01
1,270 reads
How can we build a random number generator using Marsaglia Polar method in SQL Server without the use of external tools?
2025-12-01
Earlier this year at SQL Saturday Austin 2025, Conor Cunningham gave a keynote that discussed the engineering efforts in the Austin office around SQL Server. One of the things he mentioned was PRODUCT(), which was written there and added to SQL Server 2025 to help with the GDP calculation for the US government. Yep, that's […]
2025-11-28
8,048 reads
Before SQL Server 2025, if you want to store JSON data in Microsoft SQL Server or Azure SQL DB, and you want fast queries, the easiest way is to:
2025-11-28
This article presents a way to discover those tables that are unused over a period of time, along with suggestions on how to get rid of these tables.
2025-11-26 (first published: 2025-10-15)
14,348 reads
This tutorial will discuss using variables with SQL DECLARE along with various examples.
2025-11-26
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
By Brian Kelley
Every year, the South Carolina State Internal Auditors Association and the South Carolina Midlands...
Data Céilí 2026 Call for Speakers is now live! Data Céilí (pronounced kay-lee), is...
I've come across what appears to be a strange deadlock anomaly. As seen in...
Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...
Comments posted to this topic are about the item The Challenge of AI, which...
From T-SQL, without requiring an XEvent session, can I tell which deprecated features are being used on my instance?
See possible answers