Join us on May 2nd, as we discuss preparing for DDoS attacks, building resiliency, overcoming obstacles and key preparations to make now before ransomware attacks.
One of the biggest benefits of using the file and filegroup backup strategy is the ability to recover quickly from isolated disk failures. If only one file or filegroup is damaged, you can easily recover by restoring only the damaged files or fil...
During the past year, I've run across many useful free tools. Here are my seven favorite free SQL Server utilities. Although vendors sometimes change the availability of free tools, when I wrote this column, all the utilities listed were freeware...
I'm trying to recover a database that has one master data file (.mdf) and one log data file (.ldf). I got the .mdf file from a standard OS backup tape. But sp_detach_db wasn't run on the database before the .mdf backup, so I don't have the ...
SQL Server might not be the top database in terms of new license revenue, but neither is Oracle. According to Gartner Dataquest, a shake-up in the database market has yielded a new database champ: IBM. IBM's acquisition of Informix boosted Big Bl...
I'm using snapshot replication in SQL Server 7.0, and I discovered that the referential integrity defined on the source table is lost on the destination tables at the subscriber. I've selected the Include declared referential integrity on the...