Louis Davidson Reihenfolge der Bücher (Chronologisch)

Master SQL Server 2019 administration with this comprehensive guide that empowers you to leverage your DBA expertise effectively. This well-structured reference is filled with hundreds of time-saving solutions, tips, and workarounds essential for planning, implementing, managing, and securing SQL Server 2019 across various environments—on-premises, cloud, or hybrid. SQL Server specialists provide an in-depth exploration of DBA capabilities within SQL Server 2019 Database Engine, SQL Server Data Tools, SQL Server Management Studio, and PowerShell. Learn to install, customize, and utilize key administration and development tools while managing memory, storage, clustering, and virtualization. Architect and implement database infrastructures, including IaaS, Azure SQL, and hybrid configurations. Secure your SQL Server with encryption, row-level security, and data masking, and protect Azure SQL databases with platform threat protection and auditing. Establish IaaS network security groups, administer user security and permissions, and design efficient tables using keys, data types, and partitioning. Master optimization techniques involving concurrency, indexing, and execution plans, and plan for disaster recovery in traditional, cloud, and hybrid settings. This resource is tailored for intermediate-to-advanced SQL Server database administrators, architects, and developers seeking to elevate their skills.

This study guide helps readers prepare for Microsoft Exam 70-762, required for Microsoft Certified Solutions Associate certification for SQL 2016 Database Development.

* First book to provide comprehensive, deeply practical coverage on all major new SS2005 features. • Lead author (Tom Rizzo) is a key member of the SQL Server team at Microsoft and a respected author and blogger. • Gets the DBA and developer up and running with SS2005 in the fastest possible time. • The facts, not the evangelism.