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

Prior to SQL Server 2016, currently in CTP, your main method for encrypting a SQL Server application was to use a feature called Transparent Data Encryption. TDE provides strong encryption, but with ...

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

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

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

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

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