Automatically upload SQL Server Database Backups to Azure with Integration Services
Daniel Calbimonte shows how the Feature pack in SQL Server Integration Services can connect to Azure to automatically copy your SQL Server database backups.
Developing Redgate’s SQL Toolbelt
Take a look behind the scenes to learn more about Redgate’s development challenges, what role the SQL Toolbelt plays, and which releases are coming up.
Using OVER() to Fix Bad Version Numbers
See how the OVER() clause was used in a live system to fix overlapping field version numbers.
Free-Con Pre-Con at the Pass Summit 2016
A free day of training on Monday, October 24 in Seattle this year. Join MCMs, MVPs, and Friends of Redgate for a free day of training.
In-Memory OLTP: Row Visibility in SQL Server’s MVCC
SQL Server's In-memory OLTP is fast, due to its multi-valued concurrency control (MVCC). MVCC avoids the need for locks by arranging for each user connected to the database to see a snapshot of the rows of the tables at a point in time, No changes made by the user will be seen by other users of the database until the changes have been completed and committed. It is conceptually simple but does the user always see the correct version of a row under all circumstances? Shel Burkow explains.
DELETE Operation in SQL Server HEAPs
You should stick to using tables in SQL Server, rather than heaps that have no clustered index, unless you have well-considered reasons to choose heaps. However, there are uses for heaps in special circumstances, and it is useful to know what these uses are, and when you should avoid heaps. Uwe Ricken explains, and demonstrates why you'd be unwise to use heaps rather than tables when the data is liable to change.
Blogs
Houston AI-Lytics 2026–Powerpoint Slides
By Steve Jones
Thanks to everyone for attending my session on running a Local LLM. If you...
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
GenAI vs Dashboards: Not the Same (And Never Will Be)
By James Serra
There’s a question I’ve been hearing more and more lately, especially as Copilot, Fabric,...
Forums
T-SQL in SQL Server 2025: JSON_ARRAYAGG
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Spring Connections and Learning at PASS On Tour
Comments posted to this topic are about the item Spring Connections and Learning at...
Multiple Sequence Values
Comments posted to this topic are about the item Multiple Sequence Values
Question of the Day
Multiple Sequence Values
How do I easily get the next 12 sequence values from a sequence object?
See possible answers