Just like advances in artificial intelligence, I have heard that quantum computing is going to be a disruptive technology for our future. For instance, there’s the concern that it’s going to break/crack a lot of network encryption and potentially data encryption. What’s going to be affected, how long do we have, and what do I (and my organization) need to do to prepare for it?
2025-12-31
Learn about the new ZSTD compression algorithm in SQL Server 2025.
2025-12-29
1,416 reads
Beneath the surface though, AI is just a tool that learns certain patterns and draws conclusions from information on the Web to answer questions, make decisions, or craft a code sample or two. Those that have used AI in the past will know that just as it’s capable of providing valuable information, AI tools can also generate inaccurate responses, and that’s why it’s important to use it wisely.
2025-12-29
In this article, I wanted to discuss the PowerShell (PoSh) pipeline, which was confusing to me at first and took some time to get used to working with. I had used one in Linux before, but the PoSh one is more powerful, but also slightly different. Hopefully I can demystify some of the concepts for […]
2025-12-26 (first published: 2020-12-31)
5,585 reads
I’ve used SQL window functions for years, but I’ve never fully understood framing. To truly master window functions, you need at least a basic grasp of framing and how to apply it to your queries. Framing is especially helpful when working with aggregate functions. How can you overcome this hesitation to try framing?
2025-12-26
A little Christmas fun for you using the spatial features in SQL Server and SSMS.
2025-12-24
3,445 reads
With SQL Server 2012 Microsoft introduced the AlwaysOn Availability Group feature, and since then many changes and improvements have been made. This article is an update to another article, and will cover the prerequisites and steps for installing AlwaysOn in your SQL Server 2019 environment. Prerequisites Before implementing your AlwaysOn Availability Group (AG), make sure […]
2025-12-24 (first published: 2025-11-25)
543 reads
You’re a developer responsible for maintaining a SQL Server database used to feed data to Power BI. You realize that some tables don’t have a modifiedDate column and some do. Also, you know the data is updated by the application as well as other processes which makes the modifiedDate unreliable. This is because it may not always be updated when data changes. You need a way to track data changes to ensure only changed rows are updated on reports in Power BI.
2025-12-24
2025-12-22
8,155 reads
First off, I understand if you read the headline and you have a knee-jerk reaction. I totally understand that there are a lot of people out there who hate AI, and believe me, I hate most uses of it. Lots of its advice can be misleading at best, and absolute garbage at worst.
2025-12-22
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
Comments posted to this topic are about the item Finding Motivation
Comments posted to this topic are about the item The Last Binary Value of...
Comments posted to this topic are about the item SQL Art, Part 2: New...
What does this code return?
SELECT cast(0x2025 AS NVARCHAR(20))Image 1:
Image 2: 
Image 3: 
Image 4: 
See possible answers