Office Upgrade – A Secret Lab Chair
Last year I wandered over to Glenn Berry’s house for some lunch and a chat. While I got to see his home brewing setup and the latest in computer...
2020-07-31
62 reads
Blog Posts
The Ironic DBA—My First Year as a DBA [Part 4]
My Favorite and Recommended Training Resources As I’ve been in intense, focused SQL Server training for the last year, I thought it would be a great time to share...
2020-07-31 (first published: 2020-07-21)
652 reads
Thoughts on the PASS Virtual Summit
Some thoughts on the PASS Virtual Summit this year: Clearly the in-person option wasn’t doable. Just too hard to know infection rate, local rules, employer travel guidelines, attendee and...
2020-07-31 (first published: 2020-07-17)
219 reads
Understanding how to enable SQL Server Optimizer Hotfixes
There are a number of knobs and switches that are available to database administrators that can be used to enable better performance. There are three options in particular that...
2020-07-31
7 reads
Announcing: AWS Community Builders
I’m excited to be able to announce that the AWS Community Builders, a new program for those who help out with AWS technologies, has been launched. You can read...
2020-07-30
14 reads
Assume a role with AWS PowerShell Tools
Assume A Role
I’ve had some issues in the past working with AWS.Tools PowerShell SDK and correctly assuming credentials.
By default, most of the time it was easier to use a...
2020-07-30 (first published: 2020-07-22)
271 reads
Azure DevOps Changing Build Notifications
I don’t do a lot of team builds in Azure DevOps, but I constantly use it for demos. However, I’m often experimenting with things and I break builds regularly....
2020-07-30 (first published: 2020-07-20)
316 reads
Daily Coping 30 Jul 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-07-30
12 reads
Reusing a Recordset in an SSIS Object Variable
A few years back, I wrote a blog post about using an SSIS object variable as a data flow source. In that post, I described how you could load...
2020-07-30
258 reads
Daily Coping 29 Jul 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-07-29
20 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