Best Additions to MSSQL
Best Additions to MSSQL (since 2005) 1. High Availability & Disaster Recovery Always On Availability Groups (2012) : Replaced database mirroring, allowing admins to group multiple DBs and fail them over together to multiple readable secondary replicas. Contained Databases (2012) : Logins are contained in the DB. The old way was a Master system DB with Logins and a specific DB with its Users, you lose the Logins that go with the Users. This broke on backup and restores of the DB from DEV to QA or to PROD. Link for Azure SQL Managed Instance (2022) : Introduced near real-time, bi-directional disaster recovery linking on-premises servers directly to the Azure cloud. 2. Quantum Leaps in Performance Columnstore Indexes (2012 / 2016) : Built highly compressed, column-based data storage natively tailored for data warehousing, accelerating analytical query speeds by 10x to 100x. In-Memory OLTP / "Hekaton" (2014) : Added memory-optimized tables and natively...