Semantic Search in SQL Server 2025
Learn how we can search text values in SQL Server 2025 using the new AI capabilities.
2026-01-12
1,349 reads
Articles
Common SQL Server Problems: Invalid Object Name
Learn why SQL Server shows ‘Invalid object name’ errors and how to fix them.
2026-01-12
T-SQL in SQL Server 2025: Encoding Functions
Learn about these new binary encoding and decoding functions in SQL Server 2025.
2026-01-09
1,932 reads
Generating Shape Bound Random Points in SQL Server
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.
2026-01-09
PowerShell Day By Day: The Pipeline
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 […]
2026-01-07 (first published: 2020-12-31)
5,926 reads
Using Python notebooks to save money in Fabric: The Fabric Modern Data Platform
In this next article, we look at how notebooks using Python can be cheaper than Spark notebooks.
2026-01-07
1,872 reads
Let’s Build a Better KILL. What Do We Need to Consider?
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.
2026-01-07
Loading a Database for USD$5
See how Claude Code helped load a lot of messy data into a database for less than $5.
2026-01-05
2,208 reads
Optimize SQL Server Query without Changing the Query
Sometimes we cannot improve query performance because we don’t have control over the code. Consider a query that is generated by Entity Framework (EF) from the application and you do not have access to the source code. The main question is how you can improve SQL Server query optimization for a poorly performing query?
2026-01-05
The OUTPUT Clause for INSERT and DELETE Statements
In this article, I will provide a set of examples to show case the use of OUTPUT clause for INSERT and DELETE statements.
2026-01-02 (first published: 2017-05-25)
306,135 reads
Blogs
Setting PK Names in Redgate Data Modeler
By Steve Jones
A customer was testing Redgate Data Modeler and complained that it auto-generated PK names....
Flyway Tips: AI Deployment Script Descriptions
By Steve Jones
With the AI push being everywhere, Redgate is no exception. We’ve been getting requests,...
A New Word: Fawtle
By Steve Jones
fawtle – n. a weird little flaw built into your partner that somehow only...
Forums
High Availability setup - has anyone seen this method?
Hi all, I recently moved to a new employer who have their HA setup...
Semantic Search in SQL Server 2025
Comments posted to this topic are about the item Semantic Search in SQL Server...
Encoding URLs
Comments posted to this topic are about the item Encoding URLs
Question of the Day
Encoding URLs
I have this data in a table:
CREATE TABLE Response ( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY , ResponseVal VARBINARY(5000) ) GOIf I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use? See possible answers