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)
1,739 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,116 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
7,642 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
In this next article on the Fabric Modern Data Platform, we examine setting up an on-premises gateway.
2025-11-26
1,363 reads
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,191 reads
This tutorial will discuss using variables with SQL DECLARE along with various examples.
2025-11-26
In this article, I am going to explain fixing a problem related login failure error with SQL Server. The Problem One of the common error in the SQL Server error log is "Login failed for user 'DomainName\ServerName$'. Reason: Could not find a login matching the name provided. [CLIENT: <local machine>]". Even though it says that […]
2025-11-25 (first published: 2020-11-24)
51,397 reads
Day 2 kicked off with Matt Garman’s keynote, and he opened with a quote...
By Brian Kelley
In parallel with the presentation I gave at the PASS Data Community Summit on...
SQL Server – What To Do When Disaster Strikes (5-Point Survival Guide)Chill, coffee first.When...
Hi all, Has anyone encountered an issue whereby using a distributed availability group...
hi, i have seen in my server sometimes some SPIDs get stuck. so we...
Recently I was asked to investigate the update statistics process on a particular database....
When does this code work and when does it fail?
DECLARE @BaseDate DATETIME = '1900-01-01'; SELECT DATEADD(SECOND, 2147483648, @BaseDate) AS [MaxIntSecondsAdded];See possible answers