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,937 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
2,056 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,945 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,934 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,237 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,241 reads
Blogs
Learn Better: Pause to Review More
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Azure SQL Managed Instance Next-Gen: Bring on the IOPS
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
SQL, MDX, DAX – the languages of data
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Forums
Two foreign keys to the same table. Can't cascade deletes.
Not sure if this is really a relational theory question but it seems about...
Connecting Power BI to SSAS and effective user not working
Hi everyone, Below is a consolidated summary of what we validated Architecture & data...
High Availability setup - has anyone seen this method?
Hi all, I recently moved to a new employer who have their HA setup...
Question of the Day
Encoding URLs
I have this data in a SQL Server 2025 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