Masterarbeit aus dem Jahr 2016 im Fachbereich Informatik - Wirtschaftsinformatik, Note: 1,3, Friedrich-Schiller-Universität Jena, Sprache: Deutsch, Abstract: Wachsende Datenströme und die damit verbundene Herausforderung einer effizienten Verwaltung deuten darauf hin, dass auch Datenbankmanagementsysteme (DBMS) vor einer Revolution stehen. Tape is Dead, Disk is Tape, Flash is Disk, RAM Locality is King. So beschrieb Gray, Informatiker und Wissenschaftler bei Microsoft Research, die zunehmende Verschiebung der Speicherhierarchie. Haben traditionelle DBMS noch Sekundärspeicher unter entweder zeilen- oder spaltenorientierter Datenorganisation verwendet, gebrauchen In-Memory Datenbanken (IMDB) Hauptspeicher und eine primär spaltenorientierte Datenorganisation. Damit soll es in Echtzeit möglich sein zum einen große Datenmengen auswerten und zum anderen die Informationen zum Zeitpunkt des Entstehens verarbeiten zu können. Verhinderte in den Achtziger Jahren die starke Unzuverlässigkeit des Hauptspeichers und das hohe Preisniveau die Etablierung von IMDB, so ist es heute möglich den Einsatz in Datenbanken ökonomisch zu legitimieren.
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. 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 onwards. His passion for SQL Server shows through in everything he does, and his goal is that his passion for the technology will inspire others.
Design and configure SQL Server instances and databases in support of high-throughput applications that are mission-critical and provide consistent response times in the face of variations in user numbers and query volumes. Learn to configure SQL Server and design your databases to support a given instance and workload. Youll learn advanced configuration options, in-memory technologies, storage and disk configuration, and more, all toward enabling your desired application performance and throughput. Configuration doesnt stop with implementation. Workloads change over time, and other impediments can arise to thwart desired performance. High Performance SQL Server covers monitoring and troubleshooting to aid in detecting and fixing production performance problems and minimizing application outages. Youll learn a variety of tools, ranging from the traditional wait analysis methodology to the new query store, and youll learn how improving performance is really an iterative process. High Performance SQL Server is based on SQL Server 2016, although most of its content can be applied to prior versions of the product. This book is an excellent complement to performance tuning books focusing on SQL queries, and provides the other half of what you need to know by focusing on configuring the instances on which mission-critical queries are executed. Covers SQL Server instance-configuration for optimal performance Helps in implementing SQL Server in-memory technologies Provides guidance toward monitoring and ongoing diagnostics What You Will Learn Understand SQL Servers database engine and how it processes queries Configure instances in support of high-throughput applications Provide consistent response times to varying user numbers and query volumes Design databases for high-throughput applications with focus on performance Record performance baselines and monitor SQL Server instances against them Troubleshot and fix performance problems Who This Book Is For High Performance SQL Server is aimed at SQL Server database administrators, developers, and data architects. The book is also of use to system administrators who are managing and are responsible for the physical servers on which SQL Server instances are run. Benjamin Nevarez is an independent consultant based in Los Angeles, California. He specializes in SQL Server query tuning and optimization. Nevarez is author and coauthor of several books, including SQL Server 2014 Query Tuning & Optimization, Inside the SQL Server Query Optimizer, and SQL Server 2012 Internals. He has been a speaker at many SQL Server conferences, including the PASS Summit, SQL Server Connections, and SQLBits.
Learn how to protect, back up, recover, and monitor your data and infrastructure in the cloud with Microsofts Operations Management Suite (OMS), Azure Backup, and Azure Site Recovery. Implementing Operations Management Suite starts with an overview of the Operations Management Suite, followed by an introduction to Azure virtual machines and virtual networks. Chapters cover Azure Backup and how to configure it, followed by deep dives into aspects of Azure Site Recovery (ASR): how it works, how to configure it, how to streamline your disaster recovery failover from on-premises to Azure, and so on. Learn about protection groups, how to perform planned and unplanned failover, and more. Windows IT pro consultant, trainer and MVP Peter De Tender takes you through the necessary theory and background on each topic along with hands-on step-by-step lab guides to help you implement and configure each feature for yourself. Youll also find out how to estimate your platform costs when using Azure infrastructure components, making this book your one-stop guide to the latest disaster recovery services in Microsoft Azure. What Youll Learn Understand current concepts and challenges in IT disaster recovery Get introduced to Microsoft Azure, Azure virtual networks and Azure virtual machines How to protect your data in the cloud with Azure Backup, and the configuration options available Understand how to protect, recover, and monitor your environment with Azure Site Recovery Manager, and the configuration options available How to extend Azure Site Recovery Manager to non-Hyper-V workloads Who This Book Is For This book is for IT professionals and IT decision makers who are interested in learning about Azure backup and Azure Site Recovery Manager in order to build and/or optimize their IT disaster recovery scenarios. Peter De Tender is a freelance Microsoft Infrastructure Expert, Microsoft Certified Trainer (MCT), MVP on Windows IT Pro, STEP member, and international speaker. Starting his IT career in 1996 on Windows NT4 and Exchange Server 5.5 platforms, Peter has never looked back from Microsoft server technologies. At present, hes an expert on Windows Server Hyper-V, Azure infrastructure services, and Mobile Device Management using Microsofts Enterprise Mobility Suite. Peter is a technical writer for Petri, as well as having authored several books for Packt Publishing. Peters enthusiasm as MCT led him to found the IAMCT Belgian chapter in 2010, as well as taking the position of European Chairman since Jan 2013. His dedication to the IT pro community and TechEd conferences led to him founding the TechEdYellowPantsTeam, assisting IT pros in all things Microsoft and certification.
Find out how to use Docker in your ASP.NET Core MVC applications, and how containers make it easier to develop, deploy and manage those applications in production environments. Packed with examples and practical demonstrations, this book will help you deploy even large-scale, cross-platform web applications from development into production. Best-selling author Adam Freeman takes you on a whirlwind tour of Docker, from creating a consistent development environment for your team to deploying a project and scaling it up in production. By the end of the book, you will have a solid understanding of what Docker does, how it does it and why it is useful when developing and deploying ASP.NET Core MVC applications. What You Will Learn Gain a solid understanding of Docker: what it is, and why you should be using it for your ASP.NET Core MVC applications Use Docker to create a development platform for ASP.NET Core MVC so that applications behave consistently across development and production Use Docker to test, deploy and manage ASP.NET Core MVC containers Use Docker Swarms to scale up applications to cope with large workloads Who This Book Is For ASP.NET Core MVC developers who want to use Docker to containerize and manage their applications Adam Freeman is an experienced IT professional who has held senior positions in a range of companies, most recently serving as chief technology officer and chief operating officer of a global bank. Now retired, he spends his time writing and long-distance running.
This book is your hands-on guide to infrastructure provisioning and configuration management in the cloud using Chefs open source, cross-platform toolset. With over 10,000 customers joining the Microsoft Azure cloud platform each week and steadily increasing usage, the need for automation approaches has never been greater. This book provides both practical examples and a much needed strategic overview of how these two technologies can be combined. Using Chef with Microsoft Azure takes you through the process of writing recipes in Chef to describe your infrastructure as code, and simplify your configuration management processes. Youll also meet the Chef tools that can be used to provision complete environments within Microsoft Azure. There are now a wide variety of tools and approaches that can be taken to provision resources such as virtual machines within Microsoft Azure. This book demonstrates them, discusses the benefits and weaknesses of each approach, and shows how a continuous provisioning pipeline can be established as part of a reliable, repeatable, and robust provisioning process. Each chapter has practical exercises that highlight the capabilities of both Chef and Microsoft Azure from an automation perspective and can be executed on Windows, Mac, or Linux platforms. In this book, youll learn: The purpose and principles behind automated provisioning Microsoft Azure concepts and management options How to deploy Chef Azure Virtual Machine Extensions using PowerShell, Azure command-line tools, and Chef Provisioning Chef Provisioning techniques, including provisioning PaaS resources such as KeyVault How to integrate quality tooling into the Chef development lifecycle, including Test Kitchen and InSpec with Azure compute resources How to set up a pipeline for continuous provisioning with Chef and Azure Who This Book Is For This book is for infrastructure platform and operations engineers and DevOps specialists/practitioners working with infrastructure and platform provisioning on Microsofts public cloud, Azure. An understanding of programming in any language would be beneficial, but not necessary as the examples are designed to be easily readable by anyone with general IT experience. While it is expected most users picking up this book will be on the Windows platform, a good proportion of compute workload on the Azure platform is Linux based. As a result the book includes examples that are relevant to both Windows and Linux platforms. Stuart Preston is the Technical Director and co-founder of Pendrica, a technology consultancy based in the United Kingdom focusing on cloud automation with the Microsoft Azure platform. Stuart started his career as a trainee at University College London (UCL) in 1997 and quickly moved into consultancy. Over the last two decades he has specialized in delivering Infrastructure, Platform Architecture and Application Lifecycle Management consultancy on Microsoft.NET and Java-based retail and commerce platforms, motivated by big technical challenges and detailed problem solving that spans the business and technical domains.Prior to starting Pendrica, Stuart was the Chief Technical Officer at RippleRock and EMC Consulting. He resides in London, United Kingdom.
Take a deep dive into one of the most significant SQL Server features-support for In-Memory Online Transaction Processing. The latest developments are covered, including support of off-row storage, columnstore indexes and operational analytics, changes in programmability and native compilation, and more. This book describes the architecture and internals of the In-Memory OLTP Engine and explains how to develop, deploy, and maintain systems using it. With it you can dramatically increase transaction throughput to handle thousands of transactions per second supporting millions of customers. Learn the architecture and the internals of In-Memory OLTP in order to recognize when technology can make a difference. Recognize opportunities for In-Memory OLTP in new development and understand how to benefit from it in existing systems. Dont be without Dmitri Korotkevitch and the deep expertise he imparts in Expert SQL Server In-Memory OLTP, 2nd Edition as you move forward in using SQL Servers In-Memory OLTP technology. Dmitri Korotkevitch is the five-star author of Pro SQL Server Internals , and brings the same combination of clear thinking and deep expertise to help you in this second edition. The book: Explains In-Memory OLTP internals, architecture and programmability, including data storage, indexing, multi-version concurrency control, transaction logging and recovery, and native compilation Covers SQL Server 2016 technology enhancements, including columnstore indexes and off-row storage Guides in using In-Memory OLTP in new development and existing systems What Youll Learn Grasp how SQL Server stores and works with data in memory-optimized tables Properly design and index memory-optimized tables Plan successful deployments, including the required memory size and I/O configuration Accelerate T-SQL processing through the creation of natively compiled modules Monitor and report on the benefits and performance of your In-Memory OLTP solutions Benefit from the technology in existing systems and in the systems with the mixed workload Who This Book Is For Application developers and database administrators who create and manage online transaction processing (OLTP) systems; in particular, those wanting to take advantage of SQL Servers new offering of in-memory OLTP to dramatically improve performance and throughput of their systems Dmitri Korotkevitch is a Microsoft Data Platform MVP and Microsoft Certified Master (SQL Server 2008) with more than 20 years of IT experience, including years of experience working with Microsoft SQL Server as an Application and Database Developer, Database Administrator, and Database Architect. He specializes in the design, development, and performance tuning of complex OLTP systems that handle thousands of transactions per second around the clock. Dmitri regularly speaks at various Microsoft and SQL PASS events, and he provides SQL Server training to clients around the world.
Information Management: Gaining a Competitive Advantage with Data is about making smart decisions to make the most of company information. Expert author William McKnight develops the value proposition for information in the enterprise and succinctly outlines the numerous forms of data storage. Information Management will enlighten you, challenge your preconceived notions, and help activate information in the enterprise. Get the big picture on managing data so that your team can make smart decisions by understanding how everything from workload allocation to data stores fits together. The practical, hands-on guidance in this book includes: Part 1: The importance of information management and analytics to business, and how data warehouses are used Part 2: The technologies and data that advance an organization, and extend data warehouses and related functionality Part 3: Big Data and NoSQL, and how technologies like Hadoop enable management of new forms of data Part 4: Pulls it all together, while addressing topics of agile development, modern business intelligence, and organizational change management Read the book cover-to-cover, or keep it within reach for a quick and useful resource. Either way, this book will enable you to master all of the possibilities for data or the broadest view across the enterprise. Balances business and technology, with non-product-specific technical detail Shows how to leverage data to deliver ROI for a business Engaging and approachable, with practical advice on the pros and cons of each domain, so that you learn how information fits together into a complete architecture Provides a path for the data warehouse professional into the new normal of heterogeneity, including NoSQL solutions William is President of McKnight Consulting Group (www.mcknightcg.com). He is an internationally recognized authority in information management. His consulting work has included many of the Global 2000 and numerous midmarket companies. His teams have won several best practice competitions for their implementations and many of his clients have gone public with their success stories. His strategies form the information management plan for leading companies in various industries. William is a very popular speaker worldwide and a prolific writer with hundreds of articles and white papers published. William is a distinguished entrepreneur, and a former Fortune 50 technology executive and software engineer. He provides clients with strategies, architectures, platform and tool selection, and complete programs to manage information.