Over the years I've had no shortage of licensing questions for SQL Server. At times it's felt a little crazy. Look at the licensing guide. Choose EE or SE and the number of cores. Then check if you're using VMs. Oh, and consider the cloud, and which cloud you're running a workload on. It's simple […]
In this level, we learn about the database file size growth in Hyperscale.
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.
Create your own test lab on Hyper-V to evaluate SQL Server 2025 and Windows Server 2025
When we design a database or system, we often do so with corner cases in mind. We don't have to do this.
Learn about the critical 823 and 824 errors in SQL Server and how to deal with them in this article.
How can we build a random number generator using Marsaglia Polar method in SQL Server without the use of external tools?
This year I have been speaking with an increasing number of people about FinOps and what it means. Fundamentally, it is all about getting a handle on the cost for our technology spend. When we step back and look at the bigger picture it also has ramifications on corporate Environmental, Social, and Governance (ESG) programs […]
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 […]
Following on from my last post about Getting Started With KubeVirt & SQL Server,...
By DesertDBA
I haven’t posted in a while (well, not here at least since I’ve been...
By Steve Jones
One of the things that I like about the SQL Server docs (MS Learn...
I have change tracking configured in several databases, in QA and production environments, and...
is there a no code way to limit an ssis extract from excel to...
Hello Need help in pivoting this data set, the Pivot takes MIN/MAX on a...
In SQL Server 2025, what does this return?
CREATE TABLE Numbers ( n INT) GO INSERT dbo.Numbers ( n ) VALUES (1), (2), (3) GO SELECT PRODUCT(n) FROM dbo.NumbersSee possible answers