# Back up multiple SQL Server VMs from the Recovery Services vault SQL Server databases are critical workloads that require a low recovery-point objective (RPO) and long-term retention. You can back ...

Recently I have backed up the MSSQL database from a production server and tried to restore it in a different environment, Initial production database was in MSSQL 2008 and restored in the SQL 2014, ...

Recently, a sudden power outage at our work caused an unclean shutdown of the SQL Server databases. Restarting the server started the recovery of each database. We were able to restore most of the ...

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 ...

Microsoft broke new ground in scalability when it launched Azure SQL Database Hyperscale. Here's what it took to make Microsoft's hyperscale vision work with the existing Azure infrastructure. When ...

One area where a lot of development work went into SQL Server 2014 is the area of query optimization where a crucial component got re-written in order to improve query access and predictability. To ...

However, the Compatibility Level property for that database remains at the release it was upgraded from. For instance, if you copy a SQL 2000 database to SQL Server 2008, the new copy is an upgrade to ...

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Andres Almiray, a serial open-source ...

The SQL team in Redmond has made good on its promise to deliver more timely releases of SQL Server. Now that SQL Server 2008 is being released this month, it's time for you to do your homework and ...

SQL Server 2008 introduces the ability to pass a table data type into stored procedures and functions. The table parameter feature can greatly ease the development process because you no longer need ...