Introduction This article will help you install the Docker Desktop for Mac. Before we show that, let us start by understanding what the Docker Desktop software can do for you. To understand Docker, we need to understand what a container is. If you remember a few years ago, the only way of deploying application code […]
In this article we look at the steps to recover a deleted TDE key that is being used by Azure SQL Database for database encryption.
In this article, Shel Burkow uses the SQL execution plan from the previous article to write a program in Scala.
Using data scraped from the web might be convenient, but is it legal. Perhaps more importantly, is it moral? Steve has a few thoughts.
Introduction This article shows how common table expressions (CTE) in SQL Server are naturally suited for navigating trees, such as finding its longest path, or diameter. Recall that a tree is an undirected graph where unique paths exist between any two nodes (i.e. vertices). Any node may be selected as its top node, with its […]
In this article we look at using Window Functions in SQL Server, Oracle and PostgreSQL to see the differences and similarities of the syntax.
The 2021 State of Database Monitoring survey is now open, and we want to know how you’re currently tackling your server, instance, and database monitoring. By taking part, you’ll contribute to the sole industry-wide report on database monitoring, and provide insights into how SQL Server professionals manage their estates and what challenges they face. Plus, you’ll receive an advanced copy of the report and entry to a prize draw to win a $500 Amazon voucher.
A while back I wrote an editorial about how I believed the data community would easily continue after the PASS organization was no more. I'm pleased as punch to be able to report that I was right. Not because I enjoy being right (I do, who doesn't), but because I care very much for the […]
I read this great little blog post called "Trying to Notice What's Missing." It's not real long and it's worth your time. If you'd like a TLDR, the author points out how in-person meetings at conferences resulted in enhancements to open source software due to superior, in-person, communication. Strictly on a personal level, I miss […]
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
I’ve been doing storage load tests for SQL Server for a long time, both...
By Steve Jones
I had a few random questions from my Running a Local LLM on Your...
I have an app that has an address field on the customer and the...
Good Afternoon, I have a Job which "fires" off an SSIS package (that is...
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
How do I easily get the next 12 sequence values from a sequence object?
See possible answers