Databases made for Ops, not 'Oops!'
Just as you write a unit test before writing the code, so you must devise the means to monitor a database, to ensure its smooth operation, before creating the database.
2019-06-01
218 reads
Editorials
Mastery – Repetition, Variations, and Depth
Today we have a guest editorial from Andy Warren. Andy look sat the ways in which we might solve problems and become better over time.
2019-05-31 (first published: 2015-03-25)
290 reads
High Prices for High Security
I was excited to see the new Secure Enclave technology come to Always Encrypted (AE) in SQL Server 2019. I've thought that the way Microsoft implemented the AE technology in SQL Server 2016 was a start and a good step forward, but it had too many restrictions. Kind of like Availability Groups in 2012 and […]
2019-05-30
470 reads
Long Live All Passwords
Steve talks about passwords and new guidance from Microsoft that short expiration periods are unnecessary and unhelpful.
2019-05-29
325 reads
2019-05-28 (first published: 2015-01-30)
412 reads
Debugging SQL Server
This week we have a more technical poll as Steve Jones wonders how you best debug your T-SQL code.
2019-05-27 (first published: 2015-01-16)
465 reads
2019-05-25
368 reads
Burning Out
Burning out in an IT job is easier to do than it should be. Steve has a little advice today.
2019-05-23
447 reads
2019-05-22 (first published: 2015-03-17)
338 reads
No State Based Deployments
Today Steve Jones talks about deploying your database changes, and how you can't ever really depend on a state based approach.
2019-05-21 (first published: 2015-03-02)
298 reads
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