Category Archives for "Beginner"

Aug 18

AlwaysOn 2016 – New and Improved

By Ginger Daniel | Beginner , Miscellaneous , SQL Administration , SQL Server

–by Ginger Keys   AlwaysOn Availability Groups made its debut in SQL Server 2012 as a new feature that enhanced the existing technologies of database mirroring and failover clustering to provide an option for high availability and disaster recovery. AlwaysOn gives you the ability to scale out several secondary Servers (replicas) for high availability or […]

Continue reading
Jun 16

SQL 2016 COMPRESS and DECOMPRESS Functions

By Lori Brown | Beginner , Performance Tuning , SQL Administration , SQL Development , SQL Server

–By Lori Brown @SQLSupahStah SQL Server 2016 has introduced a couple of new functions that can be very useful and save storage space to boot. COMPRESS and DECOMPRESS offers the benefit of compressing column data thereby saving storage space. COMPRESS uses the GZIP compression algorithm and actually compresses data before it is stored in a […]

Continue reading
>