Database administration
Automate critical tasks for database administration

Auditing and compliance
Database backup
Disaster recovery
Forensic auditing

Index defragmentation
Inventory management
Load testing
Object level restore

Server compare
SQL job automation
SQL Server monitoring

Transaction log reading
Transactional replication

Database development
Integrate database changes and automate deployments

Continuous delivery
Continuous integration
Data compare
Data import/export
Data masking
Database DevOps
Database documentation
Database modeling
Dependency analysis
Developer productivity

Development best practices
Documentation
Multi-DB script execution
MySQL data compare
MySQL documentation
MySQL schema compare
Object decryption
Object refactoring
Packaging and deployment

Schema and data scripting
Schema compare
Script comparison
SharePoint documentation
SQL formatting
SQL Server documentation
SQL source control
SQL unit testing

SSAS documentation
SSIS documentation
SSIS package compare
SSRS documentation
Statement auto complete
Static code analysis
Test data generation
Text and object search

Solution center

How to recover SQL Server data from accidental UPDATE and DELETE operations

The SQL DBA’s worst nightmare is the loss of data due to their own mistake. It’s not uncommon for someone to improperly execute or even forget a WHERE clause entirely when executing DELETE or UPDATE queries, resulting in potentially millions of rows of compromised data

So, which SQL Server data recovery options are available?

April 4, 2013

How to recover SQL Server data from accidental updates without backups

Ooops! Say you’ve performed an UPDATE statement without a WHERE condition against the database and overwritten a bunch of rows with bad data. How can you bring the right values back?

April 4, 2013