SQL, Sandy, Backup & Recovery - Have a Restore Plan
Reporting
from NY, East Coast, USA: In the wake of
hurricane Sandy, or as re-classified, post-tropical cyclone Sandy (whatever
that is), we slowly...
2012-11-06
1,605 reads
Robert Pearl
When SQLCommunity disappoints....
Everyone who is involved in, and follows me in the SQL Server Community, and my blog, knows, that I am one...
2012-07-20 (first published: 2012-05-08)
3,162 reads
Finding Your Dream Job - sharing some thoughts of the day...
Everyone at some time or another thinks about finding or landing their dream job. It could be in the form...
2012-07-16
2,074 reads
SQL MVP Available for Database Needs....
Recently, I wrote about and introduced us to, SQLBif, a
caricature of a SQL DBA who was down on his luck,...
2012-07-16
1,381 reads
2012-07-15
1,144 reads
SQLSaturday #158 Event Update & Hotels - Where are you staying?
Well, we're just a few weeks away from the return of SQLSaturday to NYC as SQLSaturday#158, and it is sure...
2012-07-12
1,687 reads
Super SQLSaturday #158 Summer Spectacular Event Update & Speaker Schedule!
When we first announced the return of SQLSaturday to NYC (after 2 long years), we knew we'd get a decent...
2012-06-27 (first published: 2012-06-24)
2,243 reads
SQLBif Gets A Job - SQLCommunity Redeemed...
Back in May, I had a conversation with a sql friend in the community, and well, my friend (who I...
2012-06-26
1,443 reads
The Database Recovery Advisor in SQL Server 2012
The Database Recovery Advisor in SQL Server 2012 will aid the ability of DBAs to recover their databases to a point in time in a crisis. Read about this new feature and how it can speed the process of recovery.
2012-06-11
3,557 reads
SQL Server Professionals: NYC Summer Spectacular! Training & Events
This is a very exciting summer to be in New York City! We’re not just talking Central Park, the Theatre...
2012-06-04
1,610 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