More SQL Server Updates
Updates this week for SQL 2014, 2016, 2017 and SSMS have Steve thinking about the pace of patching.
2018-03-22
65 reads
Editorial
2018-03-21
116 reads
Are You a Traffic Cop?
A traffic cop isn't a great analogy for a DBA, but all too often it is an accurate one.
2022-09-19 (first published: 2018-03-20)
289 reads
If only the US would follow ...
Governments are requiring better security, and Steve wishes the US would follow.
2018-03-19
90 reads
2018-03-19
96 reads
2022-09-26 (first published: 2018-03-16)
361 reads
Great Developers Use Source Control
The title says it all. The great developers will use source control. This habit might not make you great, but it will help you improve.
2018-03-15
77 reads
2018-03-14
105 reads
The Reliable DBA
One of the important qualities for a database is being reliable. However, as your organization grows, you might need to ensure that your account for your people as well.
2023-06-23 (first published: 2018-03-13)
252 reads
2018-03-12
296 reads
Blogs
Deployment Pipelines in Fabric – What Are They?
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
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...
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