First, I'm using directions based on SQL Server 2012 Enterprise, and Windows Server 2008 R2 Standard. I'm going to be using SQL Server 2012 Enterprise, and Windows Server 2012 R2 Standard. So my ...

SQL Server 2012 introduces a lot of new features which, like the columnstore indexes I discussed last month, are inspiring a lot of excitement in the user community. However, there's been a bit of ...

Perhaps, the most notable improvement in the mix is the integration of SQL Server AlwaysOn availability groups in Windows Azure Infrastructure Services for disaster recovery and high availability ...

Microsoft announced five Windows Azure improvements yesterday, including SQL Server AlwaysOn support.

SQL Server 2017 introduced several availability features to support disaster recovery and extended SQL Server installations to Linux. These features can help you recover SQL databases in vast ...

Second, use the SQL Server Always On recovery solution, if possible. This solution maintains not only the SQL databases but also the entire instance. Third, use disk mirroring with hardware or ...

A step-by-step guide to deploying, configuring, and testing a multi-AZ, multi-region SQL Server FCI in the Azure cloud, complete with a PowerShell script that handles the networking configuration.

SQL Server’s other HA/DR feature, Always On Availability Groups, is a more robust solution capable of providing rapid recoveries with no data loss. Among its other advantages are inclusion in SQL ...

The Always Encrypted feature for Microsoft’s Azure SQL Database and SQL Server 2016 is now generally available, the company said. It keeps data encrypted at all times, showing it in plaintext ...