Looking Back at 2010
I was “inspired” to write this post after I read some comments on my last post, Reviewing My 2010 Goals, and I read Brent Ozar’s post, Goals? Where we’re...
2011-01-03
6 reads
Blog Posts
Lots of Intel Sandy Bridge News Today
Intel has lifted the embargo today on 32nm Intel Sandy Bridge benchmarking, so there is a lot of good information...
2011-01-03
849 reads
Most Popular SQL Server Events
I recently held a poll on my blog, asking people if they had attended any SQL Server events in the...
2011-01-03
752 reads
MVP 2011
I was awarded the MVP status from Microsoft for 2011 on Jan 1, 2011. This is my fourth consecutive award...
2011-01-03
1,276 reads
RTFM365, Week 4
The days are just flying. I have to admit: I may have missed a day or two in the rush...
2011-01-03
491 reads
31 Days of SSIS – Using Breakpoints (2/31)
31 Days of SSIS
As I mentioned in the introductory post, I’m writing 31 Days of SSIS. Today’s post is going...
2011-01-02
567 reads
31 Days of SSIS – Raw Files Are Awesome (1/31)
As I mentioned in the introductory post, I’m writing 31 Days of SSIS. Let’s start off this series with a...
2011-01-01
12,393 reads
31 Days of SSIS – The Introduction
31 Days of SSIS
Last year, Glenn Berry (Blog | @GlennAlanBerry) wrote a series of posts that he called A DMV A...
2011-01-01
2,300 reads
Easy CDC part 2: Automating a Quick Initial Load, and Some Gotchas
Introduction
A couple of weeks ago I made this post about quickly building a CDC system against a vendor ERP database....
2011-01-01
1,326 reads
January Question: As a DBA, how do you manage your disk space?
Managing disk space is an important responsibility of the DBA, and there are many ways to perform this task. In...
2011-01-01
2,514 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