Protecting Code
We not only need to protect our systems, but the source code as well. Not for IP reasons, but for security.
Stairway to Database Source Control Level 1: Setting Up For Database Source Control
The first level of this stairway introduces the basics of source control, some common technologies and technologies, and demonstrates how to start versioning a SQL Server database.
Proactively monitor your SQL Server estate with SQL Monitor 9
Learn how you can gain estate-wide views of disk space usage, backups and other jobs, and application of recent SQL Server updates and patches, with SQL Monitor 9’s Estate pages. Using this feature, teams can review the overall health of all their servers and databases, identify potential issues before they escalate into real problems, and assign priorities, proactively.
SQL Server Database Activity Based on Transaction Log Backup Size
In this tip we look at some scripts you can use to monitor your database activity and usage based on the size of the SQL Server transaction log backups.
A Self-Tuning Fill Factor Technique for SQL Server – Part 2
Introduction Fill Factor is a parameter most of us have ignored because there is no definitive way to calculate what the correct value should be. Part 1 of this series describes a new technique to dynamically determine index fill factors for all indexes within a database. Part 2 covers an analysis of the data collection […]
Should Salary Information Be Confidential?
Today we have a guest editorial from Andy Warren as Steve is away from the office. Salary is a difficult topic for many, but Andy shares some thoughts.
Fast and Reliable Development with Redgate Solutions for SQL Server
Thursday August 29 18.00-19.00 BST / 10.00-11.00 Pacific - Register for this Microsoft hosted webinar to learn how Redgate tools for SQL Server help deliver software quickly.
Graphical Tools for Accessing Azure Cosmos DB
While the most common methods of interacting with Azure Cosmos DB involve programmatic access, there are times when you might want to perform a quick change or take a peek at some of documents in a collection. In such instances, it is typically more convenient to rely on the graphical interface. Fortunately, there are several options you can use to accomplish.
Azure Stretch Database, Part I: Getting Going
With most innovative new technologies, Azure Stretch Database demos make it look completely easy. Here is a step by step to get going, with examples. Part One of a Two-Part series.
Growing and Changing
It can be hard to let go of old knowledge and try something new, but we need to find a balance.
Blogs
AI: Blog a Day – Day 6: Embeddings – How AI Understands
By Vinay Thakur
Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...
The Book of Redgate: Mistakes
By Steve Jones
This is kind of a funny page to look at. The next page has...
ADF Pipeline Debugging Fails with BadRequest – The Sequel
A while ago I blogged about a use case where a pipeline fails during...
Forums
Why End-User Testing Is Even More Important with AI
Comments posted to this topic are about the item Why End-User Testing Is Even...
Dynamic Unpivot
I have a table I didn't design that has tons of repeating groups in...
Writing as an Art and a Job
Comments posted to this topic are about the item Writing as an Art and...
Question of the Day
String Similarity II
What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?
See possible answers