- Table View
- List View
Pro SQL Server Administration
by Peter CarterPro SQL Server Administration brings SQL Server administration into the modern era with strong coverage of hybrid cloud environments, In-Memory OLTP, and installation on Server Core. This comprehensive guide to SQL Server Administration for today’s DBA helps you to administer the new and key areas of SQL Server, including Columnstore indexes and the In-Memory OLTP feature set introduced in 2014.You will also be guided through the administration of traditional areas of SQL Server, including how to secure your instance, monitor and maintain your instance, and to use features such as AlwaysOn to make your instance highly available. Also covered is the use of SQL Server features to scale out read-only workloads. Pro SQL Server Administration is an all-new book taking up-to-date and modern approach that you'll want and need to further your career as a SQL Server database administrator.Extensive coverage of hybrid cloud environments involving Azure SQL Database Detailed discussions on all new, key features, including AlwaysOn and in-memory supportComprehensive coverage of key skills, such as monitoring, maintenance and indexing
Pro SQL Server Always On Availability Groups
by Uttam Parui Vivek SanilThis book is your field guide to planning, deploying, managing, and troubleshooting Always On Availability Groups. The Always On Availability Groups feature is an enterprise-level solution for high availability and disaster recovery. Always On provides a rich set of options that reduce overhead and resource usage and enable database administrators to implement and manage high availability and disaster recovery solutions far more easily than by implementing the log-shipping and database-mirroring solutions of the past. Pro SQL Server Always On Availability Groups shows how to reduce downtime, maximize application availability, and provide data protection. The goal is always to have your SQL Server databases up and running whenever you need them, rain or shine, disaster or otherwise. With a focus on real-world experiences and war stories, authors Uttam Parui and Vivek Sanil offer you: Tips, tricks, and best practices for architecting and deploying availability groups. The confidence required to manage and monitor availability groups. Techniques to troubleshoot common issues that you may face during and after deploying availability groups in a mission-critical production environment. What You Will Learn Grasp important concepts underlying high-availability and disaster recovery. Plan and deploy Always On Availability Groups in your corporate environment. Manage Availability Groups to ensure constant readiness and high throughput. Monitor Availability Group performance and troubleshoot problems fast. Build on the cloud and make Windows Azure part of your availability solution. Employ proven techniques and best practices as tested and shared by the authors. Audience Pro SQL Server Always On Availability Groups is aimed at SQL Server architects, database administrators, and IT professionals who are tasked with architecting and deploying a high-availability and disaster recovery solution involving Microsoft SQL Server. This book is also for SQL Server support staff who will be managing and supporting existing availability group deployments.
Pro SQL Server Internals
by Dmitri KorotkevitchPro SQL Server Internals explains how different SQL Server components work "under the hood" and how they communicate with each other. This is the practical book with a large number of examples that will show you how various design and implementation decisions affect the behavior and performance of your systems. Pro SQL Server Internals covers a multiple SQL Server versions starting with SQL Server 2005 all the way up to the recently released SQL Server 2014. You''ll learn about new SQL Server 2014 features including the new Cardinality Estimator, In-Memory OLTP Engine (codename Hekaton), and Clustered Columnstore Indexes. With Pro SQL Server Internals, you have a solid roadmap for understanding the depth and power of the SQL Server database backend, regardless of the version and edition of SQL Server you use. Pro SQL Server Internals does the following: Explains how to design efficient database schema, indexing, and transaction strategies. Shows how various database objects and technologies are implemented internally and when they should or should not be used. Demonstrates how SQL Server executes queries and works with data and transaction logs. What you''ll learn Design and develop efficient database solutions utilizing SQL Server as the database backend. Troubleshoot and address design, concurrency, and performance issues in systems. Choose the right database objects and technologies for the job. Improve system availability and manageability and reduce implementation costs with data partitioning. Design efficient Disaster Recovery and High-Availability strategies for systems. Improve the performance of OLTP and Data Warehouse systems by utilizing new SQL Server 2014 features, such as the In-Memory OLTP Engine and Clustered Columnstore Indexes. Who this book is for Pro SQL Server Internals is a book for developers and database administrators who want to design, develop, and maintain systems in a way that gets the most from SQL Server. This book is an excellent choice for people who prefer to understand and fix the root cause of a problem, rather than applying a ''band aid'' to it. Table of Contents Part 1 - Tables and Indexes * Chapter 1: Data storage internals * Chapter 2: Tables and Indexes - Internal Structure and Access Methods * Chapter 3: Statistics * Chapter 4: Special Indexing and Storage Features * Chapter 5: Index fragmentation * Chapter 6: Designing and tuning the indexes Part 2: Other things that matter * Chapter 7: Constraints * Chapter 8: Triggers * Chapter 9: Views * Chapter 10: Functions * Chapter 11: XML * Chapter 12: Temporary Tables * Chapter 13: CLR * Chapter 14: CLR types * Chapter 15: Data partitioning * Chapter 16: System design considerations Part 3: Locking, Blocking and Concurrency * Chapter 17: Lock types * Chapter 18: Troubleshooting Blocking issues * Chapter 19: Deadlocks * Chapter 20: Lock Escalations * Chapter 21: Optimistic isolation levels * Chapter 22: Application locks * Chapter 23: Schema locks * Chapter 24: Designing transaction strategies Part 4: Query Life Cycle * Chapter 25: Query Optimization and Execution * Chapter 26: Plan Caching Part 5: Practical Troubleshooting * Chapter 27: System Troubleshooting * Chapter 28: Extended events Part 6: Inside the transaction log * Chapter 29: Transaction Log Internals * Chapter 30: Designing a Backup Strategy * Chapter 31: Designing a High Availability Strategy Part 7: In-Memory OLTP Engine * Chapter 32: Hekaton (In Memory OLTP Engine) Part 8: Columnstore Indexes * Chapter 33: In-Memory OLTP Programmability * Chapter 34: Introduction to Columnstore indexes * Chapter 35: Clustered Columnstore indexes
Pro SQL Server Internals
by Dmitri KorotkevitchImprove your ability to develop, manage, and troubleshoot SQL Server solutions by learning how different components work "under the hood," and how they communicate with each other. The detailed knowledge helps in implementing and maintaining high-throughput databases critical to your business and its customers. You'll learn how to identify the root cause of each problem and understand how different design and implementation decisions affect performance of your systems. New in this second edition is coverage of SQL Server 2016 Internals, including In-Memory OLTP, columnstore enhancements, Operational Analytics support, Query Store, JSON, temporal tables, stretch databases, security features, and other improvements in the new SQL Server version. The knowledge also can be applied to Microsoft Azure SQL Databases that share the same code with SQL Server 2016. Pro SQL Server Internals is a book for developers and database administrators, and it covers multiple SQL Server versions starting with SQL Server 2005 and going all the way up to the recently released SQL Server 2016. The book provides a solid road map for understanding the depth and power of the SQL Server database server and teaches how to get the most from the platform and keep your databases running at the level needed to support your business. The book: * Provides detailed knowledge of new SQL Server 2016 features and enhancements * Includes revamped coverage of columnstore indexes and In-Memory OLTP * Covers indexing and transaction strategies * Shows how various database objects and technologies are implemented internally, and when they should or should not be used * Demonstrates how SQL Server executes queries and works with data and transaction log What You Will Learn Design and develop database solutions with SQL Server. Troubleshoot design, concurrency, and performance issues. Choose the right database objects and technologies for the job. Reduce costs and improve availability and manageability. Design disaster recovery and high-availability strategies. Improve performance of OLTP and data warehouse systems through in-memory OLTP and Columnstore indexes. Who This Book Is For Developers and database administrators who want to design, develop, and maintain systems in a way that gets the most from SQL Server. This book is an excellent choice for people who prefer to understand and fix the root cause of a problem rather than applying a 'band aid' to it.
Pro SQL Server Relational Database Design and Implementation
by Jessica Moss Louis DavidsonLearn effective and scalable database design techniques in a SQL Server 2016 and higher environment. This book is revised to cover in-memory online transaction processing, temporal data storage, row-level security, durability enhancements, and other design-related features that are new or changed in SQL Server 2016. Designing an effective and scalable database using SQL Server is a task requiring skills that have been around for forty years coupled with technology that is constantly changing. Pro SQL Server Relational Database Design and Implementation covers everything from design logic that business users will understand, all the way to the physical implementation of design in a SQL Server database. Grounded in best practices and a solid understanding of the underlying theory, Louis Davidson shows how to "get it right" in SQL Server database design and lay a solid groundwork for the future use of valuable business data. The pace of change in relational database management systems has been tremendous these past few years. Whereas in the past it was enough to think about optimizing data residing on spinning hard drives, today one also must consider solid-state storage as well as data that are constantly held in memory and never written to disk at all except as a backup. Furthermore, there is a trend toward hybrid cloud and on-premise database configurations as well a move toward preconfigured appliances. Pro SQL Server Relational Database Design and Implementation guides in the understanding of these massive changes and in their application toward sound database design. Gives a solid foundation in best practices and relational theory Covers the latest implementation features in SQL Server 2016 Helps you master in-memory OLTP and use it effectively Takes you from conceptual design to an effective, physical implementation What You Will Learn Develop conceptual models of client data using interviews and client documentation Recognize and apply common database design patterns Normalize data models to enhance scalability and the long term use of valuable data Translate conceptual models into high-performing SQL Server databases Secure and protect data integrity as part of meeting regulatory requirements Create effective indexing to speed query performance Who This Book Is For Programmers and database administrators of all types who want to use SQL Server to store data. The book is especially useful to those wanting to learn the very latest design features in SQL Server 2016, features that include an improved approach to in-memory OLTP, durability enhancements, temporal data support, and more. Chapters on fundamental concepts, the language of database modeling, SQL implementation, and of course, the normalization process, lay a solid groundwork for readers who are just entering the field of database design. More advanced chapters serve the seasoned veteran by tackling the very latest in physical implementation features that SQL Server has to offer. The book has been carefully revised to cover all the design-related features that are new in SQL Server 2016.
Pro SQL Server Relational Database Design and Implementation: Best Practices for Scalability and Performance
by Louis DavidsonLearn effective and scalable database design techniques in SQL Server 2019 and other recent SQL Server versions. This book is revised to cover additions to SQL Server that include SQL graph enhancements, in-memory online transaction processing, temporal data storage, row-level security, and other design-related features. This book will help you design OLTP databases that are high-quality, protect the integrity of your data, and perform fast on-premises, in the cloud, or in hybrid configurations. Designing an effective and scalable database using SQL Server is a task requiring skills that have been around for well over 30 years, using technology that is constantly changing. This book covers everything from design logic that business users will understand to the physical implementation of design in a SQL Server database. Grounded in best practices and a solid understanding of the underlying theory, author Louis Davidson shows you how to "get it right" in SQL Server database design and lay a solid groundwork for the future use of valuable business data.What You Will LearnDevelop conceptual models of client data using interviews and client documentationImplement designs that work on premises, in the cloud, or in a hybrid approachRecognize and apply common database design patternsNormalize data models to enhance integrity and scalability of your databases for the long-term use of valuable dataTranslate conceptual models into high-performing SQL Server databasesSecure and protect data integrity as part of meeting regulatory requirementsCreate effective indexing to speed query performanceUnderstand the concepts of concurrencyWho This Book Is ForProgrammers and database administrators of all types who want to use SQL Server to store transactional data. The book is especially useful to those wanting to learn the latest database design features in SQL Server 2019 (features that include graph objects, in-memory OLTP, temporal data support, and more). Chapters on fundamental concepts, the language of database modeling, SQL implementation, and the normalization process lay a solid groundwork for readers who are just entering the field of database design. More advanced chapters serve the seasoned veteran by tackling the latest in physical implementation features that SQL Server has to offer. The book has been carefully revised to cover all the design-related features that are new in SQL Server 2019.
Pro SQL Server Wait Statistics
by Enrico LaarPro SQL Server Wait Statistics is a practical guide for analyzing and troubleshooting SQL Server performance using wait statistics. Whether you are new to wait statistics, or already familiar with them, this book will help you gain a deeper understanding of how wait statistics are generated and what they can mean for your SQL Server's performance. Besides the most common wait types, Pro SQL Server Wait Statistics goes further into the more complex and performance threatening wait types. The different wait types are categorized by their area of impact, and include CPU, IO, Lock, and many more different wait type categories. Filled with clear examples, Pro SQL Server Wait Statistics helps you gain practical knowledge of why and how specific wait times increase or decrease, and how they impact your SQL Server's performance. What you'll learn How wait Statistics are generated by SQL Server Script examples for analyzing and tuning wait statistics How to lower, or even eliminate, wait times that hurt performance How to query wait statistics information from Dynamic Management Views How to build reliable and solid wait statistics baselines from which to detect performance issues Who this book is for Pro SQL Server Wait Statistics is the perfect guide for SQL Server DBAs wanting to troubleshoot and optimize SQL Server database installations. The book is also of interest to database developers who are serious about developing highly-performant applications and reporting systems. Table of Contents Introduction Part I: Foundations of Wait Statistics Analysis 1. How Wait Statistics are Generated 2. Querying Wait Statistics 3. Building a Solid Baseline Part II: Wait Types 4. CPU Wait Types 5. I/O Wait Types 6. Backup Wait Types 7. Lock Wait Types 8. Latch Wait Types 9. High-Availability and Disaster Recovery Wait Types 10: Preemptive Wait Types 11: Background and Miscellaneous Wait Types 12. Chapter 12 13: Appendix A 14. Appendix B 15. Appendix C
Pro SQL Server on Linux: Including Container-Based Deployment with Docker and Kubernetes
by Bob WardGet 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’s Self-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.
Pro SQL Server on Microsoft Azure
by Amit Banerjee Pranab Mazumdar Sourabh AgarwalLearn the basics of Microsoft Azure and see how SQL Server on Azure VMs (Infrastructure-as-a-Service) and Azure SQL Databases (Platform-as-a-Service) work. This concise book shows you how to deploy, operate, and maintain your data using any one or a combination of these offerings along with your on-premise environment. Pro SQL Server on Microsoft Azure is a quintessential book for any IT professional who is planning to host their data on Microsoft Azure. This book will not only equip you with the tips, tricks, and tools to manage SQL Server offerings on Azure, but will also help you in deciding between PaaS, IaaS, or hybrid. In the ever-changing world of operations, IT administrators and SQL Server DBAs often find that the biggest challenges occur once they've deployed to the cloud. This is precisely why Pro SQL Server on Microsoft Azure was written; it will help you master today's cloud world. What You'll Learn Understand the Microsoft Azure IaaS architecture Work with Azure Storage and Networking Deploy SQL Server on Azure VMs using best practices Apply effective security principles to SQL Azure Databases Measure and optimize the performance of SQL Server offerings on Azure Implement Business continuity and disaster recovery options with Azure SQL Databases Who This Book Is For This book is for IT admins and SQL Server DBAs who are managing or would be managing SQL Server deployments on Microsoft Azure. v>
Pro Salesforce Analytics Cloud
by William Smith Helen SunThis book explains Salesforce Analytics Cloud and provides a holistic view of different analytical capabilities and how they fit into the overall information architecture. It features real-world industry use cases and demonstrates how Salesforce's Analytics Cloud solves business challenges and brings real value to the organization. The Salesforce Analytics Cloud represents the rethinking of analytics for the business user. The Analytics Cloud is a cloud-based platform designed for the business user to have access to analytics "on the go," providing answers to questions instantly on any device. This mobile-ready capability of the Salesforce Analytics Cloud means users can immediately collaborate and share insights with team members right inside Salesforce. Pro Salesforce Analytics Cloud provides actionable guidance on creating analytical capabilities using Salesforce Analytics Cloud. The book offers: A practical guide to Salesforce Analytics Cloud, including Builder and Explorer. Detailed business analytics use cases in various industries (e. g. , manufacturing). Advanced architectures and best practices for integration and data discovery. What you'll learn How Salesforce Analytics Cloud delivers competitive analytics to different industries. How to implement best-fit use cases from data sources to analytical application using tools based on best practices. How to query and explore data across enterprise systems like CRM and ERP. How to easily load Excel spreadsheets, enabling user drive data exploration. How to get up and running in just a few short weeks, unlike legacy business intelligence or desktop discovery tools. How cloud capabilities fit into the overall information architecture. Who this book is for The target audience consists of business and IT professionals such as VP/directors of business intelligence and data warehousing, CIOs, CTOs, chief data officers, enterprise architects, data architects, information architects, and business and data analysts in various capacities. It's also a hands-on development guide for developers and designers of analytical systems, including IT developers and consulting professionals. Table of Contents An Overview of the Salesforce Analytics Cloud The Salesforce Analytics Cloud Explorer Analytics Cloud Builder Salesforce Analytics Platform Critical Decision Making and the Salesforce Analytics Cloud Mobile Enterprise Data Discovery Advanced Data Acquisition and Processing
Pro Serverless Data Handling with Microsoft Azure: Architecting ETL and Data-Driven Applications in the Cloud
by Frank Geisler Benjamin KettnerDesign and build architectures on the Microsoft Azure platform specifically for data-driven and ETL applications. Modern cloud architectures rely on serverless components more than ever, and this book helps you identify those components of data-driven or ETL applications that can be tackled using the technologies available on the Azure platform. The book shows you which Azure components are best suited to form a strong foundation for data-driven applications in the Microsoft Azure Cloud.If you are a solution architect or a decision maker, the conceptual aspects of this book will help you gain a deeper understanding of the underlying technology and its capabilities. You will understand how to develop using Azure Functions, Azure Data Factory, Logic Apps, and to employ serverless databases in your application to achieve the best scalability and design. If you are a developer, you will benefit from the hands-on approach used throughout this book. Many practical examples and architectures applied in real-world projects will be valuable to you on your path to serverless success. What You Will LearnKnow what services are available in Microsoft Azure that can deal with large amounts of dataDesign modern data applications based on serverless technology in the cloudTransform and present data without the use of infrastructureEmploy proven design patterns for rapid implementation of serverless data applicationsChoose the correct set of development tools for the services you are usingUnderstand the term "serverless" and how it can be a benefitIdentify scenarios in which serverless is not the best option availableWho This Book Is ForArchitects and decision makers who want to understand how modern architectures are designed and how to modernize their applications. The book is aimed at the developer who needs a steppingstone to quickly implement a serverless data application. And the book is for any IT professional who seeks a head start to serverless computing for data-heavy applications on the Azure platform.
Pro SharePoint 2013 Administration
by Robert GarrettPro SharePoint 2013 Administration is a practical guide to SharePoint 2013 for intermediate to advanced SharePoint administrators and power users, covering the out-of-the-box feature set and capabilities of Microsoft's collaboration and business productivity platform. SharePoint 2013 is an incredibly complex product, with many moving parts, new features, best practices, and "gotchas." Author Rob Garrett distills SharePoint's portfolio of features, capabilities, and utilities into an in-depth professional guide-with no fluff and copious advice-that is designed from scratch to be the manual Microsoft never wrote. Starting with a detailed deployment and initial configuration walkthrough, the book covers all major feature areas, including document management, social computing, metadata management, and administration. You'll also learn about planning for capacity, backup administration and disaster recovery, business intelligence, monitoring, and more. Unlike other books, Pro SharePoint 2013 Administration covers all elements of the product, but has a specific emphasis on features new and enhanced in the 2013 release. Pro SharePoint 2013 Administration is the only book you'll need as you set out to deploy and administer SharePoint 2013.
Pro SharePoint 2013 App Development
by Steve WrightApps have taken the world by storm, and now they're taking SharePoint as well. The biggest new thing in SharePoint 2013, apps are the solution to creating custom code that runs on not just your own SharePoint deployment, but also on others' implementations as well. Pro SharePoint 2013 App Development is your must-have guide to developing app solutions that run on the SharePoint 2013 platform. Using step-by-step tutorials, authorSteve Wrightcreates a sample SharePoint app throughout the course of the book, and you can walk with him through the entire lifecycle of a SharePoint app. Get expert guidance and advice on creating an app, provisioning it for use in SharePoint, securing it from unauthorized use and from other applications, integratingyour app with SharePoint search and other platform features, and much more. You'll even discover how to present your app to users on mobile devices like iPads, smartphones, and Microsoft Surface tablets. Apps in SharePoint are here to stay. Don't miss out - pick up a copy of Pro SharePoint 2013 App Development and get started on your own custom apps today. Introduces the architecture for creating and hosting SharePoint apps. Leads the reader through the creation and deployment of a complete solution. Provides an understanding of the security features in the SharePoint app model. Helps the organization leverage internal data securely over the network. Leverages SharePoint search and other services to create rich SharePoint solutions. Introduces the techniques for delivering data on a multitude of web and mobile platforms. "
Pro SharePoint 2013 Branding and Responsive Web Development
by Chris Beckett Benjamin Niaulin Eric Overfield Kanwal Khipple Oscar Medina Rita ZhangPro SharePoint 2013 Branding and Responsive Web Development is the definitive reference on the technologies, tools, and techniques needed for building responsive websites and applications with SharePoint 2013. The book focuses on solutions that provide the best browser experience for the myriad of devices, browsers, and screen orientations and resolutions. Web technology has changed considerably in the past few years. Microsoft has embraced the new generation of open standards represented by HTML5 and JavaScript, and these changes are represented in a fundamental shift in how SharePoint 2013 supports web content management and publishing. Authors Eric Overfield, Oscar Medina, Kanwal Khipple, and Rita Zhang join forces to dive into the new features and capabilities provided by SharePoint 2013 and combine them with the latest techniques in responsive web design and development to demonstrate how to build modern and progressive websites and applications. Pro SharePoint 2013 Branding and Responsive Web Development covers the following technologies: SharePoint 2013 Server Edition Office 365 SharePoint Online Expression Blend 2013 Napa Tools for Office and SharePoint Development Visual Studio 2012 HTML5 and CSS3 JavaScript, JQuery, JQuery UI, Modernizr, and the Bootstrap Framework SharePoint 2013 Client Object Model
Pro SharePoint 2013 Business Intelligence Solutions
by Sahil Malik Steve Wright Srini Sistla Manpreet Singh Sha Kanjoor AnandanTo get ahead in today's hyper-competitive marketplace, your business has to take advantage of the data you already have and mine that data to give you new insight, metrics, and clues to what drives successful customer interactions. In Pro SharePoint 2013 Business Intelligence Solutions, you'll learn exactly how to unlock that magic, build business intelligence facilities on SharePoint, and glean insights from data to propel your business to the next level. To understand the various business intelligence offerings in SharePoint 2013, you need to understand the core SQL Server business intelligence concepts, and the first part of the book presents a comprehensive tutorial on those fundamentals. Pro SharePoint 2013 Business Intelligence Solutions then focuses on specific SharePoint business intelligence investments including: Visio Services Excel Services SQL Server Reporting Services Business Connectivity Services Power View and PerformancePoint Services Authors Manpreet Singh, Sha Anandan, Sahil Malik, and Steve Wright walk you through all of this material comprehensively in practical, hands-on format, with plenty of examples to empower you to use these products in your real-life projects. As compelling as SharePoint and SQL Server business intelligence are together, the challenge always has been finding people who understand both SharePoint and SQL Server well enough to deliver such business intelligence solutions. With this book in hand, you become part of that select group. Get your copy of Pro SharePoint 2013 Business Intelligence Solutions today! What you'll learn Understand the fundamentals and framework of business intelligence. Learn how to integrate Visio Services, and discover the developer story. Practice working with the Secure Store Service. Experience authoring and publishing reports using Report Builder and how to re-purpose published reports in Reporting Services. Glean practical advice about deploying and developing for Power View and PerformancePoint Services in SharePoint 2013. Learn about the advances in Excel Services and PowerPivot, and their application within SharePoint to practical situations. Gain a deep understanding of the Business Data Services feature set in SharePoint 2013. Who this book is for Pro SharePoint 2013 Business Intelligence Solutions offers SharePoint developers an essential BI foundation experience and an introduction to SQL Server 2012 tools for business intelligence. This book will also benefit SQL Server developers and administrators who require knowledge of setting up the basic infrastructure on the SharePoint platform for business intelligence. Table of Contents Business Intelligence Basics Visio Services Reporting Services Business Connectivity Services Excel Services Power View and PerformancePoint Services
Pro SharePoint Disaster Recovery and High Availability
by Stephen CumminsFew IT professionals take the time to learn what needs to be known to do disaster recovery well. Most labor under the pretense that good administration equals close to five-nines uptime. Most technical people do not see the value of planning for disasters until the unexpected has already happened, and the effects of a disaster involving a SharePoint farm which today houses business information, line-of-business applications, sensitive information, extranets, and other highly important assets can be staggering. Pro SharePoint Disaster Recovery and High Availability, Second Editionwill take you through a step-by-step process to show how to build an awareness and reaction plan for the inevitable. With a focus on real-world experiences and war stories, authorStephen Cumminsweaves an expert tale of woe response and offers you: Ways to see the warning signs of disaster, and ways toavoid it Ways to respond to a disaster while it is happening Perhaps most importantly, how to develop a plan to deal with disaster when it inevitably does happen "
Pro Single Page Application Development
by Gil Fink Ido FlatowOne of the most important and exciting trends in web development in recent years is the move towards single page applications, or SPAs. Instead of clicking through hyperlinks and waiting for each page to load, the user loads a site once and all the interactivity is handled fluidly by a rich JavaScript front end. If you come from a background in ASP. NET development, you ll be used to handling most interactions on the server side. Pro Single Page Application Development will guide you through your transition to this powerful new application type. The book starts in Part I by laying the groundwork for SPA development. You ll master some JavaScript techniques that will come in useful later on, and get to know the building blocks of a single page application, including modules, routing and MV* frameworks. In Part II, you ll build the client for your application. This is where the magic happens, as the authors take you through the process step by step. Backbone. js is the ideal library for demonstrating SPA development in practice, but you can apply the same principles with other frameworks in your future applications. Part III takes you through the process of building the server side of your application using ASP. NET Web API, and hooking up the two parts of your application to create a working whole. SPA development also comes with its own particular challenges, including tracking history, user interface performance, and how to handle search engine optimization. In the final chapters, the authors guide you through some of these issues and advanced techniques and finish by showing you how to deploy your application. As SPAs become the de facto standard of web application development, the in-depth Pro Single Page Application Development will be your one-stop shop for creating fluid, modern applications on the web. What you'll learnReasons to master single page application development SPA architecture and key concepts Mastering modular JavaScript development techniques Meet the popular Backbone. js library and how to use it to build an SPA Create a back end with ASP. NET Web API and consume it from your SPA How to unit test and performance tune your application Overcome the difficulties of search engine optimization in single page applications Who this book is for This book will suit professional web developers familiar with HTML and JavaScript. Readers will need experience with . NET and C# in order to follow along with Part III, which covers back end development with ASP. NET Web API. Table of ContentsPart I: The Road to Single Page Application DevelopmentChapter 1: Introducing Single Page Applications (SPAs)Chapter 2: JavaScript for SPAsChapter 3: Modular JavaScript DevelopmentChapter 4: SPA Concepts and ArchitecturePart II: Building the Front EndChapter 5: Getting Started with Backbone. jsChapter 6: Creating a Single Page Application Step by StepPart III: Building the Back EndChapter 7: Creating a Back-End Service with ASP. NET Web APIChapter 8: Implementing HTTP with ASP. NET Web APIChapter 9: Communication Between Front and Back EndPart IV: Advanced SPA TopicsChapter 10: JavaScript Unit TestingChapter 11: SPA Performance TuningChapter 12: Search Engine Optimization for SPAsChapter 13: Deploying Your SPA"
Pro Spark Streaming
by Zubair NabiLearn the right cutting-edge skills and knowledge to leverage Spark Streaming to implement a wide array of real-time, streaming applications. This book walks you through end-to-end real-time application development using real-world applications, data, and code. Taking an application-first approach, each chapter introduces use cases from a specific industry and uses publicly available datasets from that domain to unravel the intricacies of production-grade design and implementation. The domains covered in the book include social media, the sharing economy, finance, online advertising, telecommunication, and IoT. In the last few years, Spark has become synonymous with big data processing. DStreams enhance the underlying Spark processing engine to support streaming analysis with a novel micro-batch processing model. Pro Spark Streaming by Zubair Nabi will enable you to become a specialist of latency sensitive applications by leveraging the key features of DStreams, micro-batch processing, and functional programming. To this end, the book includes ready-to-deploy examples and actual code. Pro Spark Streaming will act as the bible of Spark Streaming. What you'll learn Spark Streaming application development and best practices Low-level details of discretized streams The application and vitality of streaming analytics to a number of industries and domains Optimization of production-grade deployments of Spark Streaming via configuration recipes and instrumentation using Graphite, collectd, and Nagios Ingestion of data from disparate sources including MQTT, Flume, Kafka, Twitter, and a custom HTTP receiver Integration and coupling with HBase, Cassandra, and Redis Design patterns for side-effects and maintaining state across the Spark Streaming micro-batch model Real-time and scalable ETL using data frames, SparkSQL, Hive, and SparkR Streaming machine learning, predictive analytics, and recommendations Meshing batch processing with stream processing via the Lambda architecture Who this book is for The audience includes data scientists, big data experts, BI analysts, and data architects.
Pro Spring
by Chris Schaefer Clarence Ho Rob HarropPro Spring updates the perennial bestseller with the latest that the Spring Framework 4 has to offer. Now in its fourth edition, this popular book is by far the most comprehensive and definitive treatment of Spring available. With Pro Spring, you'll learn Spring basics and core topics, and share the authors' insights and real-world experiences with remoting, Hibernate, and EJB. Beyond the basics, you'll learn how to leverage the Spring Framework to build the various tiers or parts of an enterprise Java application: transactions, web and presentation tiers, deployment, and much more. A full sample application allows you to apply many of the technologies and techniques covered in this book and see how they work together. The agile, lightweight, open-source Spring Framework continues to be the de facto leading enterprise Java application development framework for today's Java programmers and developers. It works with other leading open-source, agile, and lightweight Java technologies such as Hibernate, Groovy, MyBatis, and more. Spring now works with Java EE and JPA 2 as well. After reading this definitive book, you'll be armed with the power of Spring to build complex Spring applications, top to bottom.
Pro Spring 5
by Chris Schaefer Clarence Ho Rob Harrop Iuliana CosminaPro Spring 2 is the perfect, simple answer for your lightweight, alternative Java EE development needs! Put simply, this book brings J2EE/Java EE "down to earth. " Without the hassles of using the EJB 3 specification and similar, you can build lighter, better-performing agile enterprise Java-based applications using Spring Framework 2. The Spring framework can also integrate other noteworthy and hot open source tools like Apache Struts, Hibernate, OpenJPA, GlassFish, and many more. You'll work through a real, scalable enterprise application and build it from the ground up with Spring, using all the multiple web views and frameworks.
Pro Spring 6 with Kotlin: An In-depth Guide to Using Kotlin APIs in Spring Framework 6
by Chris Schaefer Rob Harrop Iuliana Cosmina Peter SpäthMaster the fundamentals of Spring Framework 6 while learning from the real-world experiences of Spring experts. Over the course of this book, you'll learn how to leverage Spring 6 in tandem with the Kotlin programming language to build complex enterprise applications from top to bottom. From monoliths to cloud native apps for streaming microservices, you’ll gain insight into every aspect of the process, including transactions, data access, persistence, and web and presentation tiers. As you progress through the book, the authors demonstrate how to run Kotlin with a single command, deploy new utility methods in String class, use Local-Variable Syntax for Lambda Parameters Nested Based Access Control, read/write strings to and from files, and using Flight Recorder. Also, a whole new generation of dependencies are available, and you’ll see exactly how to make optimal use of them. A full sample application will show you how to apply Spring 6’s new tools and techniques and see how they work together. After reading this comprehensive book, you'll be ready to build your own Spring applications using Kotlin. What You Will Learn Explore what's new in Spring Framework 6 and the Kotlin APIs it supportsLeverage a new generation of dependenciesBuild complex enterprise monoliths, cloud-native applications, and microservicesMaster data access, persistence, and transactionsUse with Spring Batch, Integration, and other key Spring modulesIntegrate Spring 6 with Hibernate and other third party APIs and packages Who This Book Is For Experienced Kotlin and Java software developers and programmers. Some previous experience with Spring is highly recommended.
Pro Spring 6: An In-Depth Guide to the Spring Framework
by Chris Schaefer Clarence Ho Rob Harrop Iuliana CosminaMaster the Spring Framework, its fundamentals and core topics, and share the authors’ insights and real-world experiences. This book goes well beyond the basics: you'll learn how to leverage the latest Spring Framework 6 to build the various tiers and parts of today's modern, complex enterprise Java applications systems, top to bottom, including data access, SQL generation with jOOQ, persistence with Hibernate, transactions, set up security, classic web and presentation tiers and adding in some reactivity. Spring 6 will be based on the latest available Long Term Support (LTS) release, Java 17. So, you will be able to do the following in your Spring applications: use records, use new utility methods in String class; utilize Local-Variable Syntax for Lambda Parameters; Nested Based Access Control, and more. Integrating Spring with the most used frameworks and libraries is covered in this book, such as Testcontainers, Hibernate, jOOQ, Kafka and many others. A full sample application allows you to apply many of the technologies and techniques covered in Pro Spring 6 and see how they work together. This book updates the perennial bestseller with the latest that Spring Framework 6 has to offer. Now in its sixth edition, this popular title is by far the most comprehensive and definitive treatment of Spring available. After reading this book, you'll be armed with the power of Spring to build complex applications, top to bottom. The agile, lightweight, open-source Spring Framework continues to be the de facto leading enterprise Java application development framework for today's Java programmers and developers.What You Will LearnWhat’s new in Spring Framework 6 and how to use it with the latest LTS version of Java, Java 17How to integrate Spring with the most renowned and practical frameworks and dependenciesHow to build complex enterprise cloud-native applications using Spring 6How to master data access, persistence and transactionsHow to use with Spring Batch, Integration and other key Spring projects This Book Is ForExperienced Java and enterprise Java developers and programmers. Some experience with Spring highly recommended.
Pro Spring Boot
by Felipe GutierrezIncrease your Spring Framework-based enterprise Java and cloud application productivity while decreasing development time using the Spring Boot productivity suite of tools. This book is a no-nonsense guide with case studies of increasing complexity throughout the book. Pro Spring Boot is written by Felipe Gutierrez, a Spring expert consultant who works with Pivotal, the company behind the Spring Framework. Spring Boot makes it easy to create stand-alone, production-grade Spring-based applications that you can almost "just run". The goal is to allow you to get started with minimum fuss. Most Spring Boot applications need very little Spring configuration. Spring Boot provides a radically faster and widely accessible getting started experience for all Spring development and provides a range of non-functional features that are common to large classes of projects (e. g. embedded servers, security, metrics, health checks, externalized configuration); and with absolutely no code generation nor requirements for XML configuration. After you read and use this book, you'll be able to develop complex Spring applications and microservices with minimal fuss on things like configurations. This book will let you fully leverage the Spring Boot productivity suite of tools and show you how to apply them through the use of a few case studies as well. What you'll learn What is Spring Boot and how to write your first Spring Boot application How to configure Spring Boot How to use the Spring Boot Actuator How to do web development with Spring Boot How to build microservices with Spring Boot How to handle databases and messaging with Spring Boot How to test and deploy with Spring Boot How to extend Spring Boot and its available plug-ins Who this book is for This book is for experienced Spring and Java developers seeking increased productivity gains and decreased complexity and development time in their applications and software services writing.
Pro Spring Boot 2: An Authoritative Guide To Building Microservices, Web And Enterprise Applications, And Best Practices
by Felipe GutierrezQuickly and productively develop complex Spring applications and microservices out of the box, with minimal concern over things like configurations. This revised book will show you how to fully leverage the Spring Boot 2 technology and how to apply it to create enterprise ready applications that just work. It will also cover what's been added to the new Spring Boot 2 release, including Spring Framework 5 features like WebFlux, Security, Actuator and the new way to expose Metrics through Micrometer framework, and more.This book is your authoritative hands-on practical guide for increasing your enterprise Java and cloud application productivity while decreasing development time. It's a no nonsense guide with case studies of increasing complexity throughout the book. The author, a senior solutions architect and Principal Technical instructor with Pivotal, the company behind the Spring Framework, shares his experience, insights and first-hand knowledge about how Spring Boot technology works and best practices.Pro Spring Boot 2 is an essential book for your Spring learning and reference library.What You Will LearnConfigure and use Spring Boot Use non-functional requirements with Spring Boot ActuatorCarry out web development with Spring BootPersistence with JDBC, JPA and NoSQL DatabasesMessaging with JMS, RabbitMQ and WebSocketsTest and deploy with Spring BootA quick look at the Spring Cloud projectsMicroservices and deployment to the CloudExtend Spring Boot by creating your own Spring Boot Starter and @Enable featureWho This Book Is ForExperienced Spring and Java developers seeking increased productivity gains and decreased complexity and development time in their applications and software services.
Pro Spring Boot 3 with Kotlin: In-Depth Guide to Best Practices for Cloud-Native and Microservices Development
by Felipe Gutierrez Peter SpäthQuickly and productively build complex Kotlin-based Spring applications and microservices out of the box, with minimal concern over things such as configurations. This revised edition will show you how to fully leverage the Spring Boot 3 micro-framework and apply it to create enterprise-ready Kotlin-based cloud-native applications, microservices, and web applications that just work. The book covers what has been added to the new Spring Boot 3 release, including improved support for the Kotlin programming language, changes to Stream Editor UI, Maven Preemptive Authentication, building Docker images using cloud-native build packs, building layered jars for optimized Docker images, E2E traceability for configuration properties, many dependency upgrades, support for Spring Data, and much more. This book is your in-depth pragmatic guide for increasing your enterprise Kotlin and cloud application productivity while decreasing development time. It is a no-nonsense guide with case studies of increasing complexity throughout the book. The main author, a senior solutions architect and Principal Technical instructor at Pivotal, the company behind the Spring Framework, shares his experience, insights, and first-hand knowledge about how Spring Boot technology works, and best practices. This is an essential book for your Kotlin-based Spring learning and reference library. What You Will Learn Build cloud-native apps and microservices with the Spring Boot 3 framework Persist and access your data using and integrating with Spring Data Message with Kafka, RabbitMQ, and WebSockets Explore Spring Cloud projects Extend Spring Boot by creating your own Spring Boot Starter and @Enable feature Test and deploy Spring Boot with best practices Effectively use Kotlin as a programming language for Spring applications Who This Book Is For Experienced Spring, Java, and Kotlin developers seeking increased productivity gains and decreased complexity and development time in their applications and software services