Who Truncated That Table and What Do I Do Now?
This article describes a way to identify the user who truncated the table & how you can recover the data.
2015-02-20 (first published: 2014-06-05)
31,969 reads
This article describes a way to identify the user who truncated the table & how you can recover the data.
2015-02-20 (first published: 2014-06-05)
31,969 reads
This article describes a way to speed up various file operations performed by SQL Server.
2014-07-10
4,358 reads
This article describes a way to automatically restore multiple database backups from a directory.
2014-04-21
5,988 reads
2012-09-17
2,706 reads
By Steve Jones
Today’s coping tip is to focus on what’s good, even if today feels tough....
Introduction Purity is the operating environment that runs Pure Storage products like FlashArray and...
By Steve Jones
SQL Data Compare (SDC) is a great way to sync data among tables. It’s...
I have a two-replica SQL Server Availability Group running on Windows VMs in the...
I have a SQL agent job which starts the trace (for audit purpose) everyday...
I have a number of databases on a sql server 2017 instance. For most...