Welcome to this new series -- in this column, I hope to impart some quick, short tips that will help you make quick work of managing and administering your SQL Server databases. First up is an ...
Microsoft SQL Server 2000 comes with its own backup and recovery utilities. Though they work, there are a number of annoying limitations. For instance, you can't back up directly to a UNC path, and ...
Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Cory Benfield discusses the evolution of ...
OK, I’ll admit it. I’m not a DBA, but that doesn’t mean I haven’t overseen databases and their performance. I was (and probably still am) the guy who installed a Microsoft SQL database by hitting Next ...
Embarcadero Technologies on Monday is unveiling its DBArtisan Workbench 8.0 database administration tool, featuring enhanced backup capabilities for Microsoft SQL Server databases and support for ...
DBAs have many options for how to ensure high availability (HA) for SQL Server. Some of these options are available in the different versions and editions of SQL Server itself. Some are available in ...