SQL Server 2017 introduced the concept of graph data tables as part of the SQL Server database engine. With SQL Server 2019, there were some enhancements like ‘shortest path’ function and constraints on edge tables that make this feature more usable – although it is far from a full-fledged graph database. Graph tables are essentially […]
In this tip we look at how to restore a missing or corrupt SQL Server model database.
Phil Factor shares a handy keyboard shortcut diagram that reveals some of the most useful of Prompt's keyboard shortcuts, and a wallchart showing every piece of Prompt functionality, what it does, where to find it in the various menus, and of course its keyboard shortcut.
This week Grant talks about the need for change and growth to adapt to the changing world.
Identifying Performance Tuning Opportunities Using Extended Events: Part 3 Aggregate Report
Today Steve Jones looks at the relative cost of hardware and how we sometimes cause ourselves issues by not spending enough.
Phil Factor explores and discusses the current state of the art in SQL Formatting, as done automatically by SQL Prompt.
Learn about the range of connectivity options available for Azure SQL Database deployments.
A short article to help you quickly find a CU that isn't the latest one.
In this article we look at a new feature in SQL Server 2019 that can help improve TempDB performance.
By Vinay Thakur
Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...
By Steve Jones
This is kind of a funny page to look at. The next page has...
A while ago I blogged about a use case where a pipeline fails during...
I have a table I didn't design that has tons of repeating groups in...
Comments posted to this topic are about the item Writing as an Art and...
Comments posted to this topic are about the item String Similarity II
What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?
See possible answers