SQL Server 2008 R2 Best Practices Analyzer
A big part of my DBA career has centered around identifying and sharing SQL Server DBA best practices. There are...
2010-11-27
2,645 reads
A big part of my DBA career has centered around identifying and sharing SQL Server DBA best practices. There are...
2010-11-27
2,645 reads
Whenever I speak about database maintenance, I always recommend that DBAs backup up their production database transaction logs at least...
2010-11-16
1,867 reads
Tracy Hamlin, selected as the 2010 DBA of the Year, will be awarded her trophy at this year’s SQLServerCentral.com PASS...
2010-11-06
873 reads
This past week, November 3-4, the SQLServerCentral.com track at SQL Server Connections has a record 431 attendees. Below are some...
2010-11-06
663 reads
Database maintenance is a critical task for every DBA. For this month’s question, list the typical steps that you use...
2010-11-03
1,706 reads
Database maintenance is a critical task for every DBA. For this month’s question, list the typical steps that you use...
2010-11-01
1,436 reads
If you are attending SQL Server Connections this week in Las Vegas, be sure to attend some of the sessions...
2010-11-01
626 reads
I recently ran a poll, asking DBAs how often they ran DBCC CHECKDB against their databases. Compared to some of...
2010-10-21
3,075 reads
Life isn't fair, and things don't always go your way. In fact, most people hit a tough patch sooner or later. When that happens to you, how do you respond?
2010-10-18
262 reads
This is a reprint of my editorial in Database Weekly.
Scenario One: The new third-party application, purchased by your company without...
2010-10-17
389 reads
Quite the title, so let me set the stage first. You have an Azure...
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
Comments posted to this topic are about the item A Quick Restore
Comments posted to this topic are about the item Guarding Against SQL Injection at...
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
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