Pro SQL Server on Linux (eBook)
XXVII, 605 Seiten
Apress (Verlag)
978-1-4842-4128-8 (ISBN)
- Learn about the history and internal of the unique SQL Server on Linux architecture.
- Install and configure Microsoft's flagship database product on the Linux platform
- Manage your deployments using container technology through Docker and Kubernetes
- Know the basics of building databases, the T-SQL language, and developing applications against SQL Server on Linux
- Use tools and features to diagnose, manage, and monitor SQL Server on Linux
- Scale your application by learning the performance capabilities of SQL Server
- Deliver high availability and disaster recovery to ensure business continuity
- Secure your database from attack, and protect sensitive data through encryption
- Take advantage of powerful features such as Failover Clusters, Availability Groups, In-Memory Support, and SQL Server's Self-Tuning Engine
- Learn how to migrate your database from older releases of SQL Server and other database platforms such as Oracle and PostgreSQL
- Build and maintain schemas, and perform management tasks from both GUI and command line
Bob Ward is Principal Architect for the Microsoft Database Systems Group, which owns the development for all SQL Server versions. He has worked for Microsoft for 24 years, supporting and speaking on every version of SQL Server shipped from OS/2 1.1 to SQL Server 2017. He has worked in customer support as a principal escalation engineer and Chief Technology Officer (CTO), interacting with some of the largest SQL Server deployments in the world. Bob is a well-known speaker on SQL Server, often presenting talks on new releases, internals, performance, and troubleshooting at events such as PASS Summit, SQLBits, SQLIntersection, and Microsoft Ignite.
Get SQL Server up and running on the Linux operating system and containers. No database professional managing or developing SQL Server on Linux will want to be without this deep and authoritative guide by one of the most respected experts on SQL Server in the industry. Get an inside look at how SQL Server for Linux works through the eyes of an engineer on the team that made it possible.Microsoft SQL Server is one of the leading database platforms in the industry, and SQL Server 2017 offers developers and administrators the ability to run a database management system on Linux, offering proven support for enterprise-level features and without onerous licensing terms. Organizations invested in Microsoft and open source technologies are now able to run a unified database platform across all their operating system investments. Organizations are further able to take full advantage of containerization through popular platforms such as Docker and Kubernetes. Pro SQL Server on Linux walks you through installing and configuring SQL Server on the Linux platform. The author is one of the principal architects of SQL Server for Linux, and brings a corresponding depth of knowledge that no database professional or developer on Linux will want to be without. Throughout this book are internals of how SQL Server on Linux works including an in depth look at the innovative architecture.The book covers day-to-day management and troubleshooting, including diagnostics and monitoring, the use of containers to manage deployments, and the use of self-tuning and the in-memory capabilities. Also covered are performance capabilities, high availability, and disaster recovery along with security and encryption. The book covers the product-specific knowledge to bring SQL Server and its powerful features to life on the Linux platform, including coverage of containerization through Docker and Kubernetes.What You'll LearnLearn about the history and internal of the unique SQL Server on Linux architecture.Install and configure Microsoft's flagship database product on the Linux platformManage your deployments using container technology through Docker and KubernetesKnow the basics of building databases, the T-SQL language, and developing applications against SQL Server on LinuxUse tools and features to diagnose, manage, and monitor SQL Server on LinuxScale your application by learning the performance capabilities of SQL ServerDeliver high availability and disaster recovery to ensure business continuitySecure your database from attack, and protect sensitive data through encryptionTake advantage of powerful features such as Failover Clusters, Availability Groups, In-Memory Support, and SQL Server'sSelf-Tuning EngineLearn how to migrate your database from older releases of SQL Server and other database platforms such as Oracle and PostgreSQLBuild and maintain schemas, and perform management tasks from both GUI and command lineWho This Book Is ForDevelopers and IT professionals who are new to SQL Server and wish to configure it on the Linux operating system. This book is also useful to those familiar with SQL Server on Windows who want to learn the unique aspects of managing SQL Server on the Linux platform and Docker containers. Readers should have a grasp of relational database concepts and be comfortable with the SQL language.
Bob Ward is Principal Architect for the Microsoft Database Systems Group, which owns the development for all SQL Server versions. He has worked for Microsoft for 24 years, supporting and speaking on every version of SQL Server shipped from OS/2 1.1 to SQL Server 2017. He has worked in customer support as a principal escalation engineer and Chief Technology Officer (CTO), interacting with some of the largest SQL Server deployments in the world. Bob is a well-known speaker on SQL Server, often presenting talks on new releases, internals, performance, and troubleshooting at events such as PASS Summit, SQLBits, SQLIntersection, and Microsoft Ignite.
1. Why SQL Server on Linux?2. Install and Configuration3. Building A Database and T-SQL Fundamentals4. Building an Application and Advanced T-SQL5. SQL Server Tools6. Performance Capabilities7. Security in SQL Server8. High Availability and Disaster Recovery for SQL Server9. Managing and Monitoring SQL Server10. Migrating to SQL Server on Linux11. SQL Server and Containers12. Epilogue
| Erscheint lt. Verlag | 27.10.2018 |
|---|---|
| Zusatzinfo | XXVII, 605 p. 172 illus. |
| Verlagsort | Berkeley |
| Sprache | englisch |
| Themenwelt | Informatik ► Datenbanken ► SQL Server |
| Mathematik / Informatik ► Informatik ► Programmiersprachen / -werkzeuge | |
| Mathematik / Informatik ► Informatik ► Software Entwicklung | |
| Schlagworte | Architecture • Availability Group • Disaster Recovery • Docker • Encryption • Failover Cluster • High Availability • Kubernetes • Linux • performance tuning • RDBMS • SQL • SQL Server |
| ISBN-10 | 1-4842-4128-2 / 1484241282 |
| ISBN-13 | 978-1-4842-4128-8 / 9781484241288 |
| Haben Sie eine Frage zum Produkt? |
PDF (Wasserzeichen)Größe: 18,4 MB
DRM: Digitales Wasserzeichen
Dieses eBook enthält ein digitales Wasserzeichen und ist damit für Sie personalisiert. Bei einer missbräuchlichen Weitergabe des eBooks an Dritte ist eine Rückverfolgung an die Quelle möglich.
Dateiformat: PDF (Portable Document Format)
Mit einem festen Seitenlayout eignet sich die PDF besonders für Fachbücher mit Spalten, Tabellen und Abbildungen. Eine PDF kann auf fast allen Geräten angezeigt werden, ist aber für kleine Displays (Smartphone, eReader) nur eingeschränkt geeignet.
Systemvoraussetzungen:
PC/Mac: Mit einem PC oder Mac können Sie dieses eBook lesen. Sie benötigen dafür einen PDF-Viewer - z.B. den Adobe Reader oder Adobe Digital Editions.
eReader: Dieses eBook kann mit (fast) allen eBook-Readern gelesen werden. Mit dem amazon-Kindle ist es aber nicht kompatibel.
Smartphone/Tablet: Egal ob Apple oder Android, dieses eBook können Sie lesen. Sie benötigen dafür einen PDF-Viewer - z.B. die kostenlose Adobe Digital Editions-App.
Buying eBooks from abroad
For tax law reasons we can sell eBooks just within Germany and Switzerland. Regrettably we cannot fulfill eBook-orders from other countries.
aus dem Bereich
