SQL Server is at the heart of your company; if it goes down, the results could be catastrophic. However, despite its importance, many IT admins don’t have a solid backup and restore plan in place.

Elaborate backups might seem like a good idea at first, but they add unnecessary complexity to your recovery process. Here are some things to keep in mind to make backup and recovery as smooth as ...

In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do not need to worry too much about files and filegroups. But if you have a ...

Microsoft on Monday announced that Azure Backup for SQL Server had reached "general availability" status, meaning it's deemed ready for production-environment use. This service is used to backup SQL ...

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Dany Lepage discusses the architectural ...

You probably have a backup strategy for the local files on your computer, but for a business operating a website, protecting the data on your website is just as -- if not more -- important. In cases ...

Microsoft is having a re-think about its SQL Server strategy and in particular about what it wants to do with SQL Data Services. Part of the company’s Azure services platform, SQL Data Services, it ...

Microsoft today announced the availability of SQL Server 2014 CTP2, a near-final version highlighted by new in-memory capabilities formerly called Project Hekaton. The in-memory enhancements include ...