This editorial was originally published on Jul 13, 2019. It is being re-run as Steve is out of town. I recently had the pleasure of catching Paul McCartney in concert, and he was amazing. I have been a fan forever and have heard him tell the same stories he over and over with great delight. […]
This section gets into detailed SQL Server configuration details. This is less relevant in a cloud environment, but there are still items to confirm.
Today Steve talks about how we end up with software systems that don't appear to be well engineered.
Lean how to implement linear regression in SQL Server by running Python code on your data in SQL Server using Machine Learning Services.
This article explores how enabling READ_COMMITTED_SNAPSHOT on your SQL Server database might ease excessive blocking.
After a recent data breach, Steve read about an analysis of the data. He has a few thoughts on the process that Troy Hunt went through to dig into the data.
Learn how you can recover a database that is in suspect mode.
Time is a valuable resource in your lives, and when you decide to tackle something, something else gets dropped.
What are the challenges to implementing a successful test data management strategy? In our recent webinar ‘Harnessing the Power of Test Data Management: Strategies for Success’, Redgate’s Steve Jones was joined by Hamish Watson (DevOps Consultant) and Daniel Watkins (Director/Principal Consultant) to talk all things TDM and how to implement it efficiently and effectively. Here are 10 key tips and takeaways from their conversation in a short blog post.
I’m not the first person to write about cleaning up unused or redundant indexes.
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Hello, I think I need a recursive cte query but unsure of the logic....
Comments posted to this topic are about the item The Security of Old Tech
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers