Pro SQL Server Administration, 1st Edition

Pro SQL Server Administration, 1st Edition

AUTHOR: Peter Carter

PUBLISHER: Apress

PAGES: 1004

ISBN-10: 1484207114; ISBN-13: 978-1484207116

Pro SQL Server Administration brings SQL Server administration into the modern era with strong coverage of hybrid cloud environments, In-Memory OLTP, 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 the In-Memory OLTP 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 SQL Server features 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 Azure SQL Database
* Detailed discussions on all new, key features, including AlwaysOn and in-memory support
* Comprehensive coverage of key skills, such as monitoring, maintenance and indexing

About the Author
Peter Carter is a SQL Server expert with over a decade of experience in developing, administering, and architecting SQL Server platforms and data-tier applications. Peter was awarded an MCC by Microsoft in 2011, to sit alongside his array of MCTS, MCITP, MCSA and MCSE certifications in SQL Server from version 2005, onward. His passion for SQL Server shows through in everything he does, and his goal is that his passion for the technology will inspire others.

Book Category

Android Developer / Asp.Net / Asp.Net MVC / Blockchain / C# / C++ / Computer Science / Database / Game Developer / Java / JavaScript / jQuery / Linux / Maven / MS Sql / MySQL / Networking / Oracle / PHP / Python / Spring / VB.Net / Visual Studio / Web Developer

HRMS & Payroll Web Application

Employee Designation & Year-To-Date Headcount

Employee designation count is the total number of active job in the company organization while year-to-date monthly employee headcount is a year running total in every month, measures the percentage of a company's workforce that has been retired, terminated, end contract or newly hired. read more »

Employee Time Tracking Software

A time tracking app is an essential time management tool that can help you and your team become more organized, efficient, and automates tracking of billable hours for those who work from home. read more »

Time and Attendance Software

Time & attendance software is used by companies and HR departments to simplify time tracking using Biometric fingerprint authentication. The system give businesses everything they need to track and manage all aspects of their employees' time logs. Daily Time Records (DTR) Time and Attendance Software which is designed to captures the time-in / time-out logs. read more »

Work From Home Application

Working remotely are encouraging their employees to work from home to prioritize the health and safety of their workforce due to covid-19 pandemic. read more »

Pay rules for Computing Work Hours and Overtime Rates

Lookup table used for computing timesheet distribution work hours to get their salary on every pay period based on labor law percentage rates. read more »