Search for a Value Throughout Your Database
Learn how to search for a value throughout all database tables.
The Gambler
If you are the type of person that doesn't run DBCC checks, Steve Jones thinks you're a gambler. And you might think about attending SQL Intersection next month in Vegas.
An Incremental Database Development and Deployment Framework
Often, an existing database application must evolve rapidly by incremental steps. Alex describes a tried and tested system to provide an automated approach to deploying both new and existing database systems, whilst dealing with common security and configuration issues.
An Orders of Magnitude Problem (T-SQL Tuning)
When a query suddenly starts taking much longer, what do you do? This story from Jerry
Resetting DMVs
Steve Jones asks the question why so much data in SQL Server is cleared when we restart an instance.
Getting Started with Extended Events in SQL Server 2012
Extended Events provide a way of unintrusively monitoring what's going on in a SQL Server instance. Unlike SQL Server Profiler and SQL Trace, it has little performance impact. Now, in SQL Server 2012 SSMS, it is relatively easy to use, as Robert Sheldon shows.
Help Guide the Future of SQL Compare
How changes are applied to databases differs from person to person and from organization to organization. Here at Red Gate we’re writing the next chapter for SQL Compare and we need your feedback to validate some of our ideas. To help us in this endeavour, and to enter a prize draw for one of five $50 Amazon vouchers, please complete the following survey.
Data Mining Introduction Part 3: The Cluster Algorithm
This is the part 3 of the Data Mining Series from Daniel Calbimonte. This article examines the cluster algorithm.
Data Mining Introduction Part 3: The Cluster Algorithm
This is the part 3 of the Data Mining Series from Daniel Calbimonte. This article examines the cluster algorithm.
Self Describing Databases
Today Steve Jones gives his vision of the database in the future. He hopes that databases contain more information about not only their objects, but their needs, like backups and maintenance.
Blogs
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Forums
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Changing the AG Listener
Comments posted to this topic are about the item Changing the AG Listener
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers