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.
This month, I'm going to pitch a nice slow one right down the middle, and I expect everyone to hit it over the center field fence. Using the FoodMart 2000 Sales cube, write an MDX query that displays each product category and its average month-to...
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...