Where's that Snippet?
Phil Factor has tried many different ways to remember code and archive old code for reuse, but has yet to find the perfect solution. Does it exist?
2019-01-14
111 reads
Editorial
Do you have a security to-do list?
Security is important, and Steve wonders if any of us have a list of things we do that improve security.
2019-01-11
81 reads
2019-01-10
107 reads
Is Failure Allowed?
Failure is one of the ways we get better as software developers. Does that apply to DBAs?
2019-01-09
57 reads
2019-01-07
138 reads
The Giving Back Workload
Volunteering is a good thing for us to do, but it can be overwhelming at times.
2019-01-04
74 reads
Lack of Memory
It seems that many SQL Servers can be lacking memory. Adding more is one way to improve performance, but Steve has other ideas.
2019-01-03
127 reads
2019-01-02
168 reads
2019-01-01
77 reads
2018-12-31
78 reads
Blogs
A Wellbeing Day at Redgate
By Steve Jones
It’s a day off for Redgate today. This is our annual wellbeing day, where...
Don’t Miss Out – SQL Server 2025 Unleashed Training Starts Next Monday!
Next Monday, March 9, 2026, my one-day live online training SQL Server 2025 Unleashed:...
What is ALM in Fabric?
By HeyMo0sh
As someone who’s worked with data for over 20 years and with many cloud...
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