Now that it has been a
good five years I have been blogging away here and on SSC, the editors recently thanked
us...
2014-05-12
1,040 reads
TweetG’day,
Well, it seems like even if you’ve worked with SQL SERVER for a while, you’re always lightly to learn something...
2014-05-12
1,818 reads
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-05-12
872 reads
When I started with the SQL Community I was first encourage to start blogging which I started in Sept of...
2014-05-12
1,212 reads
The trip didn’t start smoothly for this one. Wed night I was really sick with some kind of stomach flu....
2014-05-12
427 reads
Thanks to everyone who attended my two sessions at SQLSaturday in Houston (more info). Here are the abstracts and PowerPoint links:
Best...
2014-05-12
922 reads
I spoke for my first time at a SQL Saturday in Houston this past week. I had a lot of...
2014-05-12
733 reads
How does MongoDB Store Data?
What is MongoDB? MongoDB is a document oriented database. This means it stores its data in...
2014-05-12 (first published: 2014-05-04)
3,869 reads
The most recent one I wrote was a “question from error message” pattern. An experienced DBA should get it easily,...
2014-05-12
355 reads
Problem : As a DBA, one of your primary job description is to handle management and administration of 1 or 100+...
2014-05-11
868 reads
By Vinay Thakur
it has been a year since i have not written much on the blog...
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
By DataOnWheels
I have been active in the data community throughout my career. I have met...
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