Sniffing out bogus data
/* Imagine that you have some names and addresses. You are anxious to look at the addresses that may be spurious....
2008-11-03
673 reads
/* Imagine that you have some names and addresses. You are anxious to look at the addresses that may be spurious....
2008-11-03
673 reads
In my previous posts The Wise Old Man Part 1 and The Wise Old Man Part 2 I wrote about...
2008-11-03
712 reads
I always feel it is harder to be a DBA than to be a doctor while we are doing almost...
2008-11-02
1,315 reads
This question came up during lunch this past week, and it's a good question. I'll start with my stock 'It...
2008-11-02
555 reads
I got up this morning, wanting to go through the forums, check on Database Weekly, etc. as a Sunday morning...
2008-11-02
573 reads
Auditing blank passwords in SQL Server 2005 and 2008 proves a bit more challenging than in SQL Server 2000. In...
2008-11-01
1,229 reads
I was experimenting with the effects of row and page compression in SQL Server 2008 Enterprise Edition.
First, I identified...
2008-10-31
4,291 reads
A month or so ago I posted Blog Review - Yours & Mine to see what I might get for feedback about...
2008-10-30
1,499 reads
Since the release of SQL Server 2008, a slew of new books have been released, or are about to be...
2008-10-30
1,725 reads
Do we have an energy crisis or not? Is global warming real? Are we being affected by burning fossil fuels?
I...
2008-10-30
1,457 reads
By HeyMo0sh
As someone who’s worked with data for over 20 years and with many cloud...
By HeyMo0sh
2025 belongs to the AI startups. If you peek into the tech headlines, you’ll...
By Vinay Thakur
it has been a year since i have not written much on the blog...
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