Angebote zu "Dbas" (92 Treffer)

Kategorien

Shops

Expert Scripting and Automation for SQL Server ...
28,99 € *
ggf. zzgl. Versand

Automate your workload and manage more databases and instances with greater ease and efficiency by combining metadata-driven automation with powerful tools like PowerShell and SQL Server Agent. Automate your new instance-builds and use monitoring to drive ongoing automation, with the help of an inventory database and a management data warehouse. The market has seen a trend towards there being a much smaller ratio of DBAs to SQL Server instances. Automation is the key to responding to this challenge and continuing to run a reliable database platform service. Expert Scripting and Automation for SQL Server DBAs guides you through the process of automating the maintenance of your SQL Server enterprise. Expert Scripting and Automation for SQL Server DBAs shows how to automate the SQL Server build processes, monitor multiple instances from a single location, and automate routine maintenance tasks throughout your environment. You will also learn how to create automated responses to common or time consuming break/fix scenarios. The book helps you become faster and better at what you do for a living, and thus more valuable in the job market. Extensive coverage of automation using PowerShell and T-SQL Detailed discussion and examples on metadata-driven automation Comprehensive coverage of automated responses to break/fix scenarios What You Will Learn Automate the SQL Server build process Create intelligent, metadata-drive routines Automate common maintenance tasks Create automated responses to common break/fix scenarios Monitor multiple instance from a central location Utilize T-SQL and PowerShell for administrative purposes Who This Book Is For Expert Scripting and Automation for SQL Server DBAs is a book for SQL Server database administrators responsible for managing increasingly large numbers of databases across their business enterprise. The book is also useful for any database administrator looking to ease their workload through automation. The book addresses the needs of these audiences by showing how to get more done through less effort by implementing an intelligent, automated-processes service model using tools such as T-SQL, PowerShell, Server Agent, and the Management Data Warehouse.

Anbieter: buecher
Stand: 18.02.2020
Zum Angebot
Expert Scripting and Automation for SQL Server ...
40,49 € *
ggf. zzgl. Versand

Expert Scripting and Automation for SQL Server DBAs ab 40.49 € als Taschenbuch: Amplifying your personal productivity and impact as a Database administrator The Expert's Voice in SQL Server. 1st ed.. Aus dem Bereich: Bücher, English, International, Gebundene Ausgaben,

Anbieter: hugendubel
Stand: 18.02.2020
Zum Angebot
Expert Scripting and Automation for SQL Server ...
39,99 € *
ggf. zzgl. Versand

Expert Scripting and Automation for SQL Server DBAs ab 39.99 € als pdf eBook: . Aus dem Bereich: eBooks, Sachthemen & Ratgeber, Computer & Internet,

Anbieter: hugendubel
Stand: 18.02.2020
Zum Angebot
Pro SQL Server 2019 Administration
32,99 € *
ggf. zzgl. Versand

Use this comprehensive guide for the SQL Server DBA, covering all that practicing database administrators need to know to get their daily work done. Updated for SQL Server 2019, this edition includes coverage of new features such as Memory-optimized TempDB Metadata, and Always Encrypted with Secure Enclaves. Other new content includes coverage of Query Store, resumable index operations, installation on Linux, and containerized SQL. Pro SQL Server 2019 Administration takes DBAs on a journey that begins with planning their SQL Server deployment and runs through installing and configuring the instance, administering and optimizing database objects, and ensuring that data is secure and highly available. Finally, readers will learn how to perform advanced maintenance and tuning techniques. This book teaches you to make the most of new SQL Server 2019 functionality, including Data Discovery and Classification. The book promotes best-practice installation, shows how to configure for scalability and high workloads, and demonstrates the gamut of database-level maintenance tasks such as index maintenance, database consistency checks, and table optimizations. What You Will Learn Install and configure SQL Server on Windows through the GUI and with PowerShell Install and configure SQL Server on Linux and in Containers Optimize tables through in-memory OLTP, table partitioning, and the creation of indexes Secure and encrypt data to protect against embarrassing data breaches Ensure 24x7x365 access through high-availability and disaster recovery features Back up your data to ensure against loss, and recover data when needed Perform routine maintenance tasks such as database consistency checks Troubleshoot and solve performance problems in SQL queries and in the database engine Who This Book Is For SQL Server DBAs who manage on-premise installations of SQL Server. This book is also useful for DBAs who wish to learn advanced features such as Query Store, Extended Events, Distributed Replay, and Policy-Based Management, or those who need to install SQL Server in a variety of environments.

Anbieter: buecher
Stand: 18.02.2020
Zum Angebot
Pro SQL Server 2019 Administration
32,99 € *
ggf. zzgl. Versand

Use this comprehensive guide for the SQL Server DBA, covering all that practicing database administrators need to know to get their daily work done. Updated for SQL Server 2019, this edition includes coverage of new features such as Memory-optimized TempDB Metadata, and Always Encrypted with Secure Enclaves. Other new content includes coverage of Query Store, resumable index operations, installation on Linux, and containerized SQL. Pro SQL Server 2019 Administration takes DBAs on a journey that begins with planning their SQL Server deployment and runs through installing and configuring the instance, administering and optimizing database objects, and ensuring that data is secure and highly available. Finally, readers will learn how to perform advanced maintenance and tuning techniques. This book teaches you to make the most of new SQL Server 2019 functionality, including Data Discovery and Classification. The book promotes best-practice installation, shows how to configure for scalability and high workloads, and demonstrates the gamut of database-level maintenance tasks such as index maintenance, database consistency checks, and table optimizations. What You Will Learn Install and configure SQL Server on Windows through the GUI and with PowerShell Install and configure SQL Server on Linux and in Containers Optimize tables through in-memory OLTP, table partitioning, and the creation of indexes Secure and encrypt data to protect against embarrassing data breaches Ensure 24x7x365 access through high-availability and disaster recovery features Back up your data to ensure against loss, and recover data when needed Perform routine maintenance tasks such as database consistency checks Troubleshoot and solve performance problems in SQL queries and in the database engine Who This Book Is For SQL Server DBAs who manage on-premise installations of SQL Server. This book is also useful for DBAs who wish to learn advanced features such as Query Store, Extended Events, Distributed Replay, and Policy-Based Management, or those who need to install SQL Server in a variety of environments.

Anbieter: buecher
Stand: 18.02.2020
Zum Angebot
Pro Entity Framework 4.0
36,99 € *
ggf. zzgl. Versand

The introduction of SQL Server 2005 began the process which has seen .NET become an integral part of the SQL Server database technology. SQL Server 2008 is the next evolutionary step in that story. Alongside the more traditional database enhancements in the new release, there is an increasing focus upon a greater and more challenging integration with .NET 3.5. This book shows how to take advantage of this tight integration and how developers and DBAs can manipulate data more easily than ever before.

Anbieter: buecher
Stand: 18.02.2020
Zum Angebot
Pro Entity Framework 4.0
36,99 € *
ggf. zzgl. Versand

The introduction of SQL Server 2005 began the process which has seen .NET become an integral part of the SQL Server database technology. SQL Server 2008 is the next evolutionary step in that story. Alongside the more traditional database enhancements in the new release, there is an increasing focus upon a greater and more challenging integration with .NET 3.5. This book shows how to take advantage of this tight integration and how developers and DBAs can manipulate data more easily than ever before.

Anbieter: buecher
Stand: 18.02.2020
Zum Angebot
SECURING SQL SERVER
26,49 € *
ggf. zzgl. Versand

SECURING SQL SERVER ab 26.49 € als Taschenbuch: DBAs Defending the Database. Aus dem Bereich: Bücher, English, International, Gebundene Ausgaben,

Anbieter: hugendubel
Stand: 18.02.2020
Zum Angebot
SQL Server 2019 Administration Inside Out
62,99 € *
ggf. zzgl. Versand

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 time-saving 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. SQL Server experts offer a complete tour of DBA capabilities available in SQL Server 2019 Database Engine, SQL Server Data Tools, SQL Server Management Studio, and via PowerShell. Discover how experts tackle today's essential tasks-and challenge yourself to new levels of mastery. Install, customize, and use SQL Server 2019's key administration and development tools Manage memory, storage, clustering, virtualization, and other components Architect and implement database infrastructure, including IaaS, Azure SQL, and hybrid cloud configurations Provision SQL Server and Azure SQL databases Secure SQL Server via encryption, row-level security, and data masking Safeguard Azure SQL databases using platform threat protection, firewalling, and auditing Establish SQL Server IaaS network security groups and user-defined routes Administer SQL Server user security and permissions Efficiently design tables using keys, data types, columns, partitioning, and views Utilize BLOBs and external, temporal, and memory-optimized tables Master powerful optimization techniques involving concurrency, indexing, parallelism, and execution plans Plan, deploy, and perform disaster recovery in traditional, cloud, and hybrid environments For Experienced SQL Server Administrators and Other Database Professionals Your role: Intermediate-to-advanced level SQL Server database administrator, architect, developer The definitive one-stop SQL Server 2019 database administration resource for all working DBAs Includes coverage of features introduced in SQL Server 2019 Serves as a complete reference for the modern SQL DBA Readers can upgrade SQL Server Administration skillset to SQL Server 2019, plus Azure SQL Databases, Azure SQL Database Managed Instances, and SQL on Linux Covers Migration strategies, automation with PowerShell, and proven implementation strategies for High Availability solutions

Anbieter: buecher
Stand: 18.02.2020
Zum Angebot