Production Scripts
Many of us have scripts that we run in SQL Agent jobs, but Steve wonders if we really treat them like production code.
2018-02-12
99 reads
Editorials
What to Read in 2018
Steve loves to read all sorts of books and is asking what books you'd read professionally or for fun in 2018.
2018-02-09
84 reads
2018-02-07
288 reads
Influence the Program
You have the opportunity to influence the makeup of the conference agenda for the PASS Summit
2018-02-06
40 reads
Finding the Right Data
Big Data hasn't been in the news, perhaps because more organizations are realizing they need the right data.
2018-02-05
67 reads
2018-02-05
51 reads
Bad Days
This Friday Steve Jones wants you to look back and cringe a bit. Share with the rest of the community what a bad day was for you and see if it was really as bad as you think.
2018-02-02 (first published: 2014-03-21)
248 reads
2018-02-01
81 reads
2018-01-31
322 reads
Lowering the Noise
We are busy as administrators, and it can be very useful to ensure our systems avoid adding to our workload.
2018-01-30
60 reads
Blogs
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...
The Most Successful Startups in 2025 — And What They Have in Common
By HeyMo0sh
2025 belongs to the AI startups. If you peek into the tech headlines, you’ll...
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