A Flock of SQL Servers
Do you want to integrate Twitter with your database server? Steve Jones asks the question this week.
SQL Server Restore Tutorial
What good is a backup if you do not know to restore the backup? In this tutorial you will look at what restore options are available and which options are only accessible using T-SQL commands.
PASS Data Architecture Virtual Chapter presents Data Warehouse Architecture
On Thursday August 18th, John Racer will discuss some common architects and practices for Data Warehouses.
The Pencil Analogy
Today we have a guest editorial from Brad Wallace that is an attempt to answer the question 'Why is database engineering so expensive?'
When Did Merge Replication Subscribers Last Sync?
The article presents an automated process to see when remote servers last synced to publisher and send notification reminders.
SQL Server Index Maintenance Performance Tuning for Large Tables
If you think about it carefully, you’ll realise, that index maintenance is necessary and that it makes sense, and that SQL Server is not doing this task automatically according to the book.
Benefits
Benefits for workers seem to be on the decline. Steve Jones talks about the issue, which might be something you give more weight to when choosing your next job.
My Experiences at SQL Saturday 64
A commentary of the experiences of James Dimauro at SQL Saturday #64 in Baton Rouge, LA in August 2011.
Using SQL Monitor in the Real World Webinar
On Tuesday August 23rd, Brad McGehee will take you through real-world examples to show what Red Gate SQL Monitor can do for you.
Blogs
Breaking Rules in Rome
By Steve Jones
Last week I was honored with a trip to Rome for the Redgate President’s...
Databases and AI Agents
By Arun Sirpal
As part of my wider work exploring Claude Code and AI-assisted database engineering, I...
Creating a Pulsing Conducting Baton - Part 1
By Bert Wagner
Train Wreck The last time I watched a high school band nearly fall apart mid-performance...
Forums
Why Your Index Isn't Being Used? - Reading Execution Plans to Find the Real Culprit
Comments posted to this topic are about the item Why Your Index Isn't Being...
Distance Metric Algorithms
Comments posted to this topic are about the item Distance Metric Algorithms
What Can AI Really Do?
Comments posted to this topic are about the item What Can AI Really Do?
Question of the Day
Distance Metric Algorithms
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers