Conquer SQL Server 2019 administration–from the inside out Dive into SQL Server 2019 administration–and really put your SQL Server DBA expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds–all you need to plan, implement, manage, and secure SQL Server 2019 in any production environment: on-premises, cloud, or hybrid. Six experts thoroughly tour DBA capabilities available in SQL Server 2019 Database Engine, SQL Server Data Tools, SQL Server Management Studio, PowerShell, and Azure Portal. You’ll find extensive new coverage of Azure SQL, big data clusters, PolyBase, data protection, automation, and more. Discover how experts tackle today’s essential tasks–and challenge yourself to new levels of mastery. <ul>
<li>Explore SQL Server 2019’s toolset, including the improved SQL Server Management Studio, Azure Data Studio, and Configuration Manager</li> <li>Design, implement, manage, and govern on-premises, hybrid, or Azure database infrastructures</li> <li>Install and configure SQL Server on Windows and Linux</li> <li>Master modern maintenance and monitoring with extended events, Resource Governor, and the SQL Assessment API</li> <li>Automate tasks with maintenance plans, PowerShell, Policy-Based Management, and more</li> <li>Plan and manage data recovery, including hybrid backup/restore, Azure SQL Database recovery, and geo-replication</li> <li>Use availability groups for high availability and disaster recovery</li> <li>Protect data with Transparent Data Encryption, Always Encrypted, new Certificate Management capabilities, and other advances</li> <li>Optimize databases with SQL Server 2019’s advanced performance and indexing features</li> <li>Provision and operate Azure SQL Database and its managed instances</li> <li> Move SQL Server workloads to Azure: planning, testing, migration, and post-migration</li> </ul>

SQL Server 2019 Administration Inside Out

Computers & Technology

Davidson, Louis

D'Antoni, Joseph

Assaf, William

West, Randolph

Aelterman, Sven

Zacharias, Melody

Networking & Cloud Computing

Microsoft Press

Storing large object data in the database offers a number of benefits, but introduces performance challenges. Conversely, storing large object data in the file system has overriding performance advantages, but fails to offer some of the basic data integrity, security and manageability features that are required for business data, and which SQL Server provides. Up to now, most people have adopted file system storage by necessity, and often struggled to overcome the associated shortcomings. This is exactly where SQL Server's new FILESTREAM feature fits in. Introduced in SQL Server 2008, it is implemented as an extension to the VARBINARY(MAX) data type and allows large object data to be stored in a special folder on the NTFS file system, while bringing that data under the transactional control of SQL Server. This book guides you step-by-step through every phase of FILESTREAM implementation, from enabling the feature, to creating FILESTREAM tables, to manipulating FILESTREAM data through the streaming APIs. We also cover, in detail, administration and troubleshooting of FILESTREAM databases and tables. No feature is used in isolation, so we devote several chapters to explaining how this new feature can be integrated into ASP.NET and Silverlight web applications, and into applications using Entity Framework. We also take a look at how well FILESTREAM plays with other SQL Server features such as SSIS and SSRS, pointing out various issues and pain-points along the way. We also devote a full chapter to the FileTable feature, a long-awaited new addition to FILESTREAM, with SQL Server 2012, which allows Windows applications to access FILESTREAM data exactly as is it were stored directly on the file system. We hope this book will get you started, quickly, with FILESTREAM, and then help you master all essential aspects of programming and administering FILESTREAM-enabled databases.

The Art of SQL Server FILESTREAM

Sebastian, Jacob

Programming Languages

Red gate books

See the best price to sell, buy, or rent books by Aelterman, Sven. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

Books by Aelterman, Sven