Database uplevel Restores Follow On
Today's post is a follow on from one earlier this month Database uplevel Restores. I got round to testing restoring...
2012-01-20
1,144 reads
Blog Posts
DBAs and the Career-Life Balance
Reprinted from my editorial in Database Weekly.
I know a lot of DBAs who make SQL Server the focus of their...
2012-01-20
880 reads
Local Community Events & User Groups from Around Town....
Staying true to the meaning of SQL Community with respect to local chapters and user groups, I wanted to bring you...
2012-01-20
1,568 reads
Nooner Viewing Summary
Over the last few weeks, I’ve been watching SQL Server videos and webcasts. My primary motivator in doing this is...
2012-01-20
591 reads
PASS Summit session videos online
If you are interested in viewing the recorded sessions for the PASS Summit 2011, you can order the DVD. You...
2012-01-20
894 reads
Re-blog – January 13 – January 19
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may...
2012-01-20
572 reads
Rename an Analysis Services Instance
This is just a short post for Friday. I have been working a fair amount with SSAS and the rest...
2012-01-20
5,555 reads
S3OLV – Jan 2012 Meeting Recap
Last week (Jan 12, 2012), we held the user group meeting for the SQL Server Society of Las Vegas (a.k.a...
2012-01-20
633 reads
S3OLV – Jan 2012 Meeting Recap
Last week (Jan 12, 2012), we held the user group meeting for the SQL Server Society of Las Vegas (a.k.a S3OLV or SSSOLV). Presenting at that meeting was Josh...
2012-01-20
5 reads
SQL Cachestore flush
For each cleared cachestore in the plan cache SQL Server reports a message in the error logs , such as :
SQL...
2012-01-20
1,170 reads
Blogs
Blog a Day – Day 1: History of AI
By Vinay Thakur
it has been a year since i have not written much on the blog...
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
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