New Cartoons at SQLServerCentral
SQLServerCentral has commissioned a new cartoon that will be coming later this week.
Five Tips to Get Your Organisation Releasing Software Frequently
The frequency of releasing software varies widely in the industry. If the test and release process is made as reliable and predictable as possible, then everyone gains. But how do you get started?
Adding to SQL Server
This week Steve Jones wonders what you might want to add to SQL Server. With SQL Server 2016 likely in the early planning stages, where would you want to see the development effort focused.
Database Mirroring Setup
This great tutorial shows how to set up database mirroring across two instances in a virtual environment.
Reduce Time for SQL Server Index Rebuilds and Update Statistics
This tip will explore two features to speed up SQL Server index and statistics maintenance in the SQL Server Enterprise, Standard and Express editions.
Finding “Active” Rows for the Previous Month (SQL Spackle)
SQL Server MVP Jeff Moden walks us through the classic problem of finding all the "Active" rows for the previous month using start and end dates. This is excellent for those new to T-SQL.
Backup to the right location, by default
How do you configure where your database backups are created? Do you have problems updating all of your backup jobs if the backup location needs to change? See how you can make use of Windows settings and a few lines of simple TSQL to have total control over where you database backups are created.
SQL Saturday #273 Tampa. FL
SQL Saturday is coming to Tampa, Florida on February 22, 2014. SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This is a free event, so register early to secure your place.
The DBA is Dead
Is the DBA Dead? Steve Jones scoffs at the notion put forth in an article and says we'll be using DBAs for a long time. He does, however, admit the role is changing.
Getting Starting with Change Data Capture (CDC) in SQL Server – Part 1
Starting with SQL Server 2008, two different in-built mechanisms identify DML changes at the source table so that only changed data sets can be considered for data pulled from the source table to load into the data warehouse. These two in-built mechanisms are Change Data Capture (CDC) and Change Tracking (CT).
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
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...
String Similarity II
Comments posted to this topic are about the item String Similarity II
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