An SSIS Upgrade
SSIS is still in use by many customers. Steve discusses a few changes to SSIS in SQL Server 2025.
SSIS is still in use by many customers. Steve discusses a few changes to SSIS in SQL Server 2025.
Learn how we can search text values in SQL Server 2025 using the new AI capabilities.
Learn why SQL Server shows ‘Invalid object name’ errors and how to fix them.
Learn about these new binary encoding and decoding functions in SQL Server 2025.
Many of us aspire to be senior level professionals at some point in our careers, but what separates us from others? Steve has a few thoughts today.
Random number generation is vital in computer science, supporting fields like optimization, simulation, robotics, and gaming. The quality, speed, and sometimes security of the generator can directly affect an algorithm’s correctness, performance, and competitiveness. In Python, random number generation is well-supported and widely used. In this article, we will look how to we can use SQL to do this.
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 […]
In this next article, we look at how notebooks using Python can be cheaper than Spark notebooks.
When there’s a performance emergency, a lot of us perform the same manual tasks over and over. We run sp_BlitzWho or sp_WhoIsActive, look for blocking, long-running or out-of-control queries, and kill them.
Forgive me for the title. Mentally I’m 12. When I started my current day...
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Comments posted to this topic are about the item Expanding into Print
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Comments posted to this topic are about the item The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers