The Importance of Verifying Database Backups Regularly
Yesterday, as I was pulling into my driveway, my front left tire gave. Thankfully, I was going really slow and...
2008-01-31
1,665 reads
Blog Posts
A Long Overdue Database Security Rant
I've been dealing with a security product from a security company in recent days that breaks best practices with respect...
2008-01-30
2,302 reads
First Heroes Happen Here (HHH) Comic
Microsoft and Seagate have partnered togethered to put together an IT Heroes comic (daily even). The first one is here:
...
2008-01-29
1,562 reads
Hello Secure World - MS Site Worth Looking At
Saw this in the MSDN flash yesterday, MS has a new Silverlight site up (newest toy and all!) that focuses...
2008-01-29
1,396 reads
IT Transparency Posted on SSC
As I mentioned yesterday the article I wrote on IT Transparency is finally live today and now the wait to...
2008-01-29
1,304 reads
Ken Henderson has passed away
I know I'm not the first in the SQL Server community to post this, but Ken Henderson has passed away...
2008-01-29
1,909 reads
Part II of Troubleshooting Memory Issues
The Windows Server Performance Team has published part 2 of troubleshooting memory issues.
This one covers excessive paging and memory...
2008-01-29
1,669 reads
The Long Tail
Another book I read recently, The Long Tail by Chris Anderson of Wired Magazine goes into detail talking about some of the changes...
2008-01-29
1,482 reads
Thoughts and Prayers
Ken Henderson passed away this past week. I found out about it from the MVP forums as well as from...
2008-01-29
1,450 reads
Agenda Posted for South Florida Code Camp
I'll be there doing a presentation on Transactional Replication, and my friend Chris Rock will be doing on on LINQ to...
2008-01-28
1,384 reads
Blogs
How to Parameterize Fabric Linked Services in Azure Data Factory for Azure Devops Deployment
Quite the title, so let me set the stage first. You have an Azure...
Deployment Pipelines in Fabric – What Are They?
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
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