Technet and MSDN coming to Baton Rouge
On March 4th Microsoft will be hosting two half-day events in Baton Rouge, LA.These free live learning sessions will explore...
2010-02-15
724 reads
On March 4th Microsoft will be hosting two half-day events in Baton Rouge, LA.These free live learning sessions will explore...
2010-02-15
724 reads
A couple of weeks ago, it was announced that the SQL Saturday franchise was voluntarily transferred to PASS . This change...
2010-02-15
1,174 reads
After seeing Brent Ozar's Top 10 Reasons Why Access Doesn't Rock, and seeing all the comments it generated, I figured...
2010-02-15
4,292 reads
Recently I was just killing a few minutes and was looking for some tips for Windows 7. I get along...
2010-02-15
611 reads
I recently blogged about a solution I had decided to use in order to solve a problem related to PayPeriod...
2010-02-14
794 reads
I wrote about data types recently, referencing Michelle Ufford’s presentation at the PASS 2009 Summit. In that post I talked...
2010-02-14
1,531 reads
Microsoft has recently announced the planned release dates for the next round of SQL Server service packs. SQL Server 2008...
2010-02-14
695 reads
This is a short post for a Sunday afternoon, I thought I’d share some useful reading from the week gone...
2010-02-14
866 reads
Microsoft has announced that Service Pack 2 for SQL Server 2008 will be released in the third quarter of 2010,...
2010-02-13
807 reads
Microsoft Group Program Manager Matthias Berndt has a post up on the Microsoft SQL Server Release Services blog (which is...
2010-02-13
591 reads
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
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