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

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

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

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

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

The secondaries can run in the cloud, adding disaster recovery capabilities to a premises-based SQL Server implementation. Before this general availability release, the SQL Server AlwaysOn ...

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

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