Poor Name Choice
Steve has a few thoughts on the names we choose for tables, columns, files, and more.
2025-11-07
140 reads
Editorials
Data > Hype
Most of us believe in the importance of data. Steve has a few thoughts on using data to determine if AI is helpful.
2025-11-05
84 reads
Practice Until You Don't Get It Wrong
We will all make mistakes, but practice can help reduce the errors we cause.
2025-11-03 (first published: 2017-11-27)
294 reads
The Selfish Case for Learning AI
Steve has a good reason to spend time working with and learning about AI technology.
2025-10-31
142 reads
Reducing Cloud Cost
Cloud costs are high and growing. Some orgs think they're out of control and are trying to limit spend. Some orgs are looking to leave the cloud. A lot of IT spend over the years has been seen as a cost center, with many executives trying to limit the growth or spend, even while they […]
2025-10-29
179 reads
DevOps is DevOps
DevOps includes a lot of practices, but no matter which technology that you use, the ideas are the same.
2025-10-27
120 reads
Why Data Modelling Still Matters - More Than Ever
In today’s fast-paced landscape, where agile development and cloud-native platforms dominate, data modelling might seem like a relic of the past.
2025-10-25
240 reads
2025-10-24
104 reads
2025-10-22
135 reads
Limiting the Ability to Concentrate and Collaborate
Open offices have an interesting side effect: less collaboration.
2025-10-20 (first published: 2018-08-27)
172 reads
Blogs
TempDB Internals – What’s New (SQL Server 2016 to 2022)
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
AI: Blog a Day – Day 2: Generative AI, Multimodal Systems, and Agent AI
By Vinay Thakur
continuing from Day 1 where we covered the history of AI and GPT family,...
A Wellbeing Day at Redgate
By Steve Jones
It’s a day off for Redgate today. This is our annual wellbeing day, where...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers