Moving On After a Technology Fail
After his watch broke, Steve had to get a new tool and isn't sure it was a good move.
2025-02-21
77 reads
Technology
Where's the Printer Friendly Option?
Steve reminisces about the older technology of putting words on paper, often from the web.
2024-10-04
66 reads
2024-09-27
668 reads
AI Is Great and Tech is Failing
Steve is a little disappointed in technology that didn't work well after a security incident.
2024-09-25
183 reads
2024-09-21
139 reads
It's Time to Play
Writing editorials every few weeks for a technical mailing list has been one of the more challenging responsibilities in my (nearly) two years with Redgate as an advocate working with Steve, Grant, and Louis. Each week, it’s interesting for me to see the mix of technical insights and everyday life stuff that each of us […]
2024-08-31
395 reads
Continuity Across Restarts
A cloud version of Aurora MySQL has added support for the buffer pool to survive restarts of the database engine. Steve thinks that's an interesting technology, which could be helpful.
2024-01-12
134 reads
2023-11-24
158 reads
Using Technology for Health
I've been fairly healthy and fit for most of my life. While I've always had a few extra pounds, I do try to eat better than average and I exercise regularly. That didn't stop age and some pandemic laxity from catching up with me. My annual checkup last December had my doctor (and me) slightly […]
2022-03-05
103 reads
Digitizing Construction
One of the more analog industries is embracing digital change faster and faster./
2021-08-11
284 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,...
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