Tag: Database
Epsilon security breach: we’re all targets to spear phishing now!
You’ve been told time and again to be careful about who you give your email address to, and to NOT give any personal information to businesses you don’t know or trust. But what about the BIG guys you do trust? Epsilon just experienced a security breach resulting in a major data theft. (Apr 04, 2011)
Quick and dirty database replication with MS-SQL
Microsoft SQL and SQL Express both provide a T-SQL (Transact SQL) command-line interpreter that you can use to automate backup and restore processes. It enables you to utilize publisher/publishee configurations for real-time or near real-time replication. Sometimes, though, all you may want to do is run a daily backup of the database on one SQL Server and restore it to a second SQL Server to keep a "warm standby" available. This can be done easily with a pair of simple batch files. Here’s how you do it: (Oct 18, 2010)





