Pro SQL Server Administration

Pro SQL Server Administration brings SQL Server administration into the modern era with strong coverage of hybrid cloud environments, in-memory support, and installation on Server Core. This comprehensive guide to SQL Server Administration for today’s DBA helps you to administer the new and key areas of SQL Server, including columnstore indexes and non-relational indexes that form an important part of the in-memory feature set introduced in 2014.You will also be guided through the administration of traditional areas of SQL Server, including how to secure your instance, monitor and maintain your instance, and to use features such as AlwaysOn to make your instance highly available. Also covered is the use of AlwaysOn to scale out read-only workloads. Pro SQL Server Administration is an all-new book taking up-to-date and modern approach that you’ll want and need to further your career as a SQL Server database administrator.Extensive coverage of hybrid cloud environments involving SQL Database on AzureDetailed discussions on all new, key features, including AlwaysOn and in-memory supportComprehensive coverage of key skills, such as monitoring, maintenance and indexing