- Table View
- List View
SQL Pocket Guide: A Guide to SQL Usage (Pocket References Ser.)
by Jonathan GennickIf you're a programmer or database administrator who uses SQL in your day-to-day work, this popular pocket guide is the ideal on-the-job reference. You'll find many examples that address the language's complexity, along with key aspects of SQL used in IBM DB2 Release 9.7, MySQL 5.1, Oracle Database 11g Release 2, PostgreSQL 9.0, and Microsoft SQL Server 2008 Release 2. SQL Pocket Guide describes how these database systems implement SQL syntax for querying, managing transactions, and making changes to data. It also shows how the systems use SQL functions, regular expression syntax, and type conversion functions and formats. All example SQL statements in this book execute against a set of tables, with data that you can quickly download. The third edition covers important database changes, including: Oracle's support of the recursive WITH syntax, and addition of PIVOT and UNPIVOT operators Functions new to Oracle, such as LISTAGG, NTH_VALUE, and more PostgreSQL's support of recursive WITH and some window functions DB2 syntax and datatypes, some compatible with Oracle MySQL features such as the TIMESTAMP type and the TO_SECONDS function
SQL Pocket Guide, 2nd Edition
by Jonathan GennickSQL is the language of databases. It's used to create and maintain database objects, place data into those objects, query the data, modify the data, and, finally, delete data that is no longer needed. Databases lie at the heart of many, if not most business applications. Chances are very good that if you're involved with software development, you're using SQL to some degree. And if you're using SQL, you should own a good reference or two. Now available in an updated second edition, our very popular SQL Pocket Guide is a major help to programmers, database administrators, and everyone who uses SQL in their day-to-day work. The SQL Pocket Guide is a concise reference to frequently used SQL statements and commonly used SQL functions. Not just an endless collection of syntax diagrams, this portable guide addresses the language's complexity head on and leads by example. The information in this edition has been updated to reflect the latest versions of the most commonly used SQL variants including: * Oracle Database 10g, Release 2 (including the free Oracle Database 10g Express Edition (XE)) * Microsoft SQL Server 2005 * MySQL 5 * IBM DB2 8.2 * PostreSQL 8.1 database
SQL Primer: An Accelerated Introduction to SQL Basics
by Rahul BatraBuild a core level of competency in SQL so you can recognize the parts of queries and write simple SQL statements. SQL knowledge is essential for anyone involved in programming, data science, and data management. This book covers features of SQL that are standardized and common across most database vendors. You will gain a base of knowledge that will prepare you to go deeper into the specifics of any database product you might encounter. Examples in the book are worked in PostgreSQL and SQLite, but the bulk of the examples are platform agnostic and will work on any database platform supporting SQL. Early in the book you learn about table design, the importance of keys as row identifiers, and essential query operations. You then move into more advanced topics such as grouping and summarizing, creating calculated fields, joining data from multiple tables when it makes business sense to do so, and more. Throughout the book, you are exposed to a set-based approach to the language and are provided a good grounding in subtle but important topics such as the effects of null value on query results. With the explosion of data science, SQL has regained its prominence as a top skill to have for technologists and decision makers worldwide. SQL Primer will guide you from the very basics of SQL through to the mainstream features you need to have a solid, working knowledge of this important, data-oriented language.What You'll LearnCreate and populate your own database tablesRead SQL queries and understand what they are doingExecute queries that get correct resultsBring together related rows from multiple tablesGroup and sort data in support of reporting applicationsGet a grip on nulls, normalization, and other key conceptsEmploy subqueries, unions, and other advanced featuresWho This Book Is ForAnyone new to SQL who is looking for step-by-step guidance toward understanding and writing SQL queries. The book is aimed at those who encounter SQL statements often in their work, and provides a sound baseline useful across all SQL database systems. Programmers, database managers, data scientists, and business analysts all can benefit from the baseline of SQL knowledge provided in this book.
SQL Server 2000 High Availability Volume 1: Planning
by Microsoft CorporationThe SQL Server 2000 High Availability Planning Guide helps database designers and systems engineers design data centers that can achieve the level of availability needed for particular business environments. This guide discusses each barrier to achieving a highly available data center and analyzes the solutions to each of these barriers. The importance of using a combination of best practices, database backups, redundant components, and redundant servers is emphasized as the key to ensuring high availability. What this guide covers: Best practices to prevent downtime Using backup to recover from disaster Using hardware redundancy to prevent downtime Using redundancy to minimize downtime Patterns & practices contains specific recommendations illustrating how to design, build, deploy, and operate architecturally sound solutions to challenging business and technical scenarios. The technical guidance is reviewed and approved by Microsoft engineering teams, consultants, and Product Support Services, and by partners and customers. Patterns & Practices are: Proven: Based on field experience Authoritative: Offers the best advice available Accurate: Technically validated and tested Actionable: Provides the steps to success Relevant: Addresses real world problems Contents: Introduction to High Availability Overcoming Barriers to High Availability Recovering a Data Center by Using Database Backups Preventing Downtime by Using Redundant Components Minimizing Downtime by Using Redundant Servers
SQL Server 2000 High Availability Volume 2: Deployment
by Microsoft CorporationThe SQL Server High Availability Solution Guide helps database designers and systems engineers implement targeted server redundancy solutions. This guide provides step-by-step guidance for implementing the following solutions: failover clustering, log shipping, log shipping with network load balancing, transactional replication, transactional replication with network load balancing, stretch clusters, and remote mirrors for achieving high availability. Step-by-step guidance is also provided for failing over to or changing the role of a redundant server. This book covers the following topics: Implementing Failover Clustering Implementing Log Shipping Implementing Transactional Replication Implementing Network Load Balancing (NLB) Implementing Remote Clustering
SQL Server 2008 Administration
by Tom CarpenterThe ideal on-the-job reference guide for SQL Server 2008 database administratorsIf you manage and administer SQL Server 2008 in the real world, you need this detailed guide at your desk. From planning to disaster recovery, this practical book explores tasks and scenarios that a working SQL Server DBA faces regularly and shows you step by step how to handle them. Topics include installation and configuration, creating databases and tables, optimizing the database server, planning for high availability, and more.And, if you're preparing for MCTS or MCITP certification in SQL Server 2008 administration, this book is the perfect supplement to your preparation, featuring a CD with practice exams, flashcards, and video walkthroughs of the more difficult administrative tasksDelves into Microsoft's SQL Server 2008, a rich set of enterprise-level database services for business-critical applicationsExplores the skills you'll need on the job as a SQL Server 2008 administratorShows you how to implement, maintain, and repair the SQL Server database, including bonus videos on the CD where the authors walks you through the more difficult tasksCovers database design, installation and configuration, creating databases and tables, security, backup and high availability, and moreSupplements your preparation for MCTS and MCITP SQL Server 2008 certification with in-depth coverage of the skill sets required for certification, as defined by MicrosoftUses hands-on exercises and real-world scenarios to keep what you're learning grounded in the reality of the workplaceMake sure you're not only prepared for certification, but also for your job as a SQL Server 2008 administrator, with this practical reference!Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
SQL Server 2012 Reporting Services Blueprints
by Mickey Stuewe Marlon RibunalFollow the fictional John Kirkland through a series of real-world reporting challenges based on actual business conditions. Use his detailed blueprints to develop your own reports for every requirement.This book is for report developers, data analysts, and database administrators struggling to master the complex world of effective reporting in SQL Server 2012. Knowledge of how data sources and data sets work will greatly help readers to speed through the tutorials.
SQL Server 2012 T-SQL Recipes
by Jonathan Gennick Andy Roberts David Dye Jason Brimhall Wayne SheffieldSQL Server 2012 T-SQL Recipes is an example-based guide to the Transact-SQL language that is at the core of SQL Server 2012. It provides ready-to-implement solutions to common programming and database administration tasks. Learn to create databases, insert and update data, generate reports, secure your data, and more. Tasks and their solutions are broken down into a problem/solution format that is quick and easy to read so that you can get the job done fast when the pressure is on. Solutions in this book are divided into chapters by problem domain. Each chapter is a collection of solutions around a single facet of the language such as writing queries, developing triggers, and applying aggregate functions. Each solution is presented code-first, giving you a working code example to copy from and implement immediately in your own environment. Following each example is an in-depth description of how and why the given solution works. Tradeoffs and alternative approaches are also discussed. Focused on solutions: Look up what you need to do. Learn how to do it. Do it. Current: Newly updated for SQL Server 2012 Comprehensive: Covers all common T-SQL problem domains What you'll learn Create databases, tables, and indexes Query and manipulate data Store and manage XML inside the database Move business logic into the database Resolve common performance problems. Build reports that matter to your business. Perform common backup and recovery tasks. Who this book is for SQL Server 2012 T-SQL Recipes is aimed at technically-oriented users of SQL Server desiring to extract the full power of the platform through it's powerful, built-in programming and scripting language. Target readers include developers who use Microsoft SQL Server 2012 as their backend database, and the database administrators who create, manage, and secure those databases. Table of Contents Getting Started with SELECT Elementary Programming Nulls and Other Pitfalls Combining Data from Multiple Tables Grouping and Summarizing Advanced SELECT Techniques Query Techniques for Reporting Inserting, Updating, Deleting Working with Strings Working with Dates Working with Numbers Transactions, Locking, Blocking, Deadlocking Managing Tables Managing Views Managing Indexes Managing Large Tables Stored Procedures User-Defined Functions Triggers Error Handling Query Performance Hints Index Tuning and Statistics XML Files, Filegroups, and Integrity Backup Recovery Principals and Users Securables and Permissions Objects and Dependencies "
SQL Server 2012 with PowerShell V3 Cookbook
by Donabel SantosSQL Server 2012 with PowerShell V3 Cookbook" is an example-focused book that provides step-by-step instructions on how to accomplish specific SQL Server tasks using PowerShell. Each recipe is followed by an analysis of the steps or design decisions taken, and additional information about the task at hand. Working scripts are provided for all examples so that you can dive in right away. You can read this book sequentially by chapter, or you can pick and choose which topics you need right away,This book is written for the SQL Server database professional (DBA, developer, BI developer) who wants to use PowerShell to automate, integrate, and simplify database tasks. A little bit of scripting background is helpful, but not necessary.
SQL Server 2012 with PowerShell V3 Cookbook
by Donabel Santos"SQL Server 2012 with PowerShell V3 Cookbook" is an example-focused book that provides step-by-step instructions on how to accomplish specific SQL Server tasks using PowerShell. Each recipe is followed by an analysis of the steps or design decisions taken, and additional information about the task at hand. Working scripts are provided for all examples so that you can dive in right away. You can read this book sequentially by chapter, or you can pick and choose which topics you need right away,This book is written for the SQL Server database professional (DBA, developer, BI developer) who wants to use PowerShell to automate, integrate, and simplify database tasks. A little bit of scripting background is helpful, but not necessary.
SQL Server 2014 Development Essentials
by Basit A. Masood-Al-FarooqThis book is an easy-to-follow, comprehensive guide that is full of hands-on examples, which you can follow to successfully design, build, and deploy mission-critical database applications with SQL Server 2014. If you are a database developer, architect, or administrator who wants to learn how to design, implement, and deliver a successful database solution with SQL Server 2014, then this book is for you. Existing users of Microsoft SQL Server will also benefit from this book as they will learn what's new in the latest version.
SQL Server 2016 Developer's Guide
by Dejan Sarka Milos Radivojevic William DurkinGet the most out of the rich development capabilities of SQL Server 2016 to build efficient database applications for your organization About This Book • Utilize the new enhancements in Transact-SQL and security features in SQL Server 2016 to build efficient database applications • Work with temporal tables to get information about data stored in the table at any point in time • A detailed guide to SQL Server 2016, introducing you to multiple new features and enhancements to improve your overall development experience Who This Book Is For This book is for database developers and solution architects who plan to use the new SQL Server 2016 features for developing efficient database applications. It is also ideal for experienced SQL Server developers who want to switch to SQL Server 2016 for its rich development capabilities. Some understanding of the basic database concepts and Transact-SQL language is assumed. What You Will Learn • Explore the new development features introduced in SQL Server 2016 • Identify opportunities for In-Memory OLTP technology, significantly enhanced in SQL Server 2016 • Use columnstore indexes to get significant storage and performance improvements • Extend database design solutions using temporal tables • Exchange JSON data between applications and SQL Server in a more efficient way • Migrate historical data transparently and securely to Microsoft Azure by using Stretch Database • Use the new security features to encrypt or to have more granular control over access to rows in a table • Simplify performance troubleshooting with Query Store • Discover the potential of R's integration with SQL Server In Detail Microsoft SQL Server 2016 is considered the biggest leap in the data platform history of the Microsoft, in the ongoing era of Big Data and data science. Compared to its predecessors, SQL Server 2016 offers developers a unique opportunity to leverage the advanced features and build applications that are robust, scalable, and easy to administer. This book introduces you to new features of SQL Server 2016 which will open a completely new set of possibilities for you as a developer. It prepares you for the more advanced topics by starting with a quick introduction to SQL Server 2016's new features and a recapitulation of the possibilities you may have already explored with previous versions of SQL Server. The next part introduces you to small delights in the Transact-SQL language and then switches to a completely new technology inside SQL Server - JSON support. We also take a look at the Stretch database, security enhancements, and temporal tables. The last chapters concentrate on implementing advanced topics, including Query Store, columnstore indexes, and In-Memory OLTP. You will finally be introduced to R and how to use the R language with Transact-SQL for data exploration and analysis. By the end of this book, you will have the required information to design efficient, high-performance database applications without any hassle. Style and approach This book is a detailed guide to mastering the development features offered by SQL Server 2016, with a unique learn-as-you-do approach. All the concepts are explained in a very easy-to-understand manner and are supplemented with examples to ensure that you—the developer—are able to take that next step in building more powerful, robust applications for your organization with ease.
SQL Server 2016 Integration Services Cookbook
by Christian CoteThis book is for software engineers, DW/ETL architects, and ETL developers who need to create a new, or enhance an existing, ETL implementation with SSIS. This book would also be good for individuals who develop ETL solutions that use SSIS and are keen to learn the Microsoft SQL Server Integration Services 2016 new features and capabilities.
SQL Server 2016 Reporting Services Cookbook
by Dinesh Priyankara Robert C. CainCreate interactive cross-platform reports and dashboards using SQL Server 2016 Reporting Services About This Book * Get up to speed with the newly-introduced enhancements and the more advanced query and reporting features * Easily access your important data by creating visually appealing dashboards in the Power BI practical recipe * Create cross-browser and cross-platform reports using SQL Server 2016 Reporting Services Who This Book Is For This book is for software professionals who develop and implement reporting solutions using Microsoft SQL Server. It is especially relevant for professionals who are software engineers, software architects, DW/BI engineers, and DW/BI architects who perform simple to complex report authoring implementations. This book is also suitable for those who develop software solutions that integrate reporting solutions and are keen to learn about Microsoft SQL Server 2016's features and capabilities. What You Will Learn * Key capabilities, architecture, and components of Reporting Services * New features that have been added to Reporting Services * Design the architecture for reporting solutions * Design the architecture for BI solutions * Implement reporting solutions using Reporting Services * Improve the performance, availability, and scalability of the reporting solution * Enhance reporting solutions with custom programming and improved security In Detail Microsoft SQL Server 2016 Reporting Services comes with many new features. It offers different types of reporting such as Production, Ad-hoc, Dashboard, Mash-up, and Analytical. SQL Server 2016 also has a surfeit of new features including Mobile Reporting, and Power BI integration. This book contains recipes that explore the new and advanced features added to SQL Server 2016. The first few chapters cover recipes on configuring components and how to explore these new features. You'll learn to build your own reporting solution with data tools and report builder, along with learning techniques to create visually appealing reports. This book also has recipes for enhanced mobile reporting solutions, accessing these solutions effectively, and delivering interactive business intelligence solutions. Towards the end of the book, you'll get to grips with running reporting services in SharePoint integrated mode and be able to administer, monitor, and secure your reporting solution. This book covers about the new offerings of Microsoft SQL Server 2016 Reporting Services in comprehensive detail and uses examples of real-world problem-solving business scenarios. Style and approach This comprehensive cookbook follows a problem-solution approach to help you overcome any obstacle when creating interactive, visually-appealing reports using SQL Server 2016 Reporting Services. Each recipe focuses on a specific task and is written in a clear, solution-focused style.
SQL Server 2017 Administrator's Guide
by Marek ChmelThis book will give you all the information you need to become an expert database administrator, and master the administrative aspects of SQL Server 2017. From setting up and configuring your SQL Server instance to fine-tuning your database by using various techniques, this extensive guide will teach you the nitty-gritty of SQL Server 2017 administration
SQL Server 2017 Administrator's Guide
by Marek Chmel Vladimir MuznyImplement and administer successful database solution with SQL Server 2017 About This Book • Master the required skills to successfully set up, administer, and maintain your SQL Server 2017 database solution • Design and configure, manage, and secure a rock-solid SQL server • Comprehensive guide in keeping your SQL server disaster proof and all-time availability Who This Book Is For This book targets database administrators with an interest in SQL Server 2017 administration. Readers are expected to have some experience with previous SQL Server versions. What You Will Learn • Learn about the new features of SQL Server 2017 and how to implement them • Build a stable and fast SQL Server environment • Fix performance issues by optimizing queries and making use of indexes • Perform a health check of an existing troublesome database environment • Design and use an optimal database management strategy • Implement efficient backup and recovery techniques in-line with security policies • Combine SQL Server 2017 and Azure and manage your solution by various automation techniques Perform data migration, cluster upgradation and server consolidation In Detail Take advantage of the real power of SQL Server 2017 with all its new features, in addition to covering core database administration tasks. This book will give you a competitive advantage by helping you quickly learn how to design, manage, and secure your database solution. You will learn how to set up your SQL Server and configure new (and existing) environments for optimal use. After covering the designing aspect, the book delves into performance-tuning aspects by teaching you how to effectively use indexes. The book will also teach you about certain choices that need to be made about backups and how to implement a rock-solid security policy and keep your environment healthy. Finally, you will learn about the techniques you should use when things go wrong, and other important topics - such as migration, upgrading, and consolidation - are covered in detail. Integration with Azure is also covered in depth. Whether you are an administrator or thinking about entering the field, this book will provide you with all the skills you need to successfully create, design, and deploy databases using SQL Server 2017. Style and approach A comprehensive guide for database professionals, covering a wide range of topics from installation, maintenance, and configuration to managing systems for operational efficiency and high availability; best practices for maintaining a highly reliable database solution are also supplied from industry experts.
SQL Server 2017 Developer’s Guide: A professional guide to designing and developing enterprise database applications
by Dejan Sarka William Durkin Miloš RadivojevićBuild smarter and efficient database application systems for your organization with SQL Server 2017Key FeaturesBuild database applications by using the development features of SQL Server 2017Work with temporal tables to get information stored in a table at any time Use adaptive querying to enhance the performance of your queriesBook DescriptionMicrosoft SQL Server 2017 is the next big step in the data platform history of Microsoft as it brings in the power of R and Python for machine learning and containerization-based deployment on Windows and Linux. Compared to its predecessor, SQL Server 2017 has evolved into Machine Learning with R services for statistical analysis and Python packages for analytical processing. This book prepares you for more advanced topics by starting with a quick introduction to SQL Server 2017’s new features and a recapitulation of the possibilities you may have already explored with previous versions of SQL Server. The next part introduces you to enhancements in the Transact-SQL language and new database engine capabilities and then switches to a completely new technology inside SQL Server: JSON support. We also take a look at the Stretch database, security enhancements, and temporal tables.Furthermore, the book focuses on implementing advanced topics, including Query Store, columnstore indexes, and In-Memory OLTP. Towards the end of the book, you’ll be introduced to R and how to use the R language with Transact-SQL for data exploration and analysis. You’ll also learn to integrate Python code in SQL Server and graph database implementations along with deployment options on Linux and SQL Server in containers for development and testing. By the end of this book, you will have the required information to design efficient, high-performance database applications without any hassle.What you will learn Explore the new development features introduced in SQL Server 2017 Identify opportunities for In-Memory OLTP technology Use columnstore indexes to get storage and performance improvements Exchange JSON data between applications and SQL Server Use the new security features to encrypt or mask the data Control the access to the data on the row levels Discover the potential of R and Python integration Model complex relationships with the graph databases in SQL Server 2017Who this book is forDatabase developers and solution architects looking to design efficient database applications using SQL Server 2017 will find this book very useful. In addition, this book will be valuable to advanced analysis practitioners and business intelligence developers. Database consultants dealing with performance tuning will get a lot of useful information from this book as well.Some basic understanding of database concepts and T-SQL is required to get the best out of this book.
SQL Server 2017 Machine Learning Services with R: Data exploration, modeling, and advanced analytics
by Julie Koesmarno Tomaz KastrunDevelop and run efficient R scripts and predictive models for SQL Server 2017 Key Features Learn how you can combine the power of R and SQL Server 2017 to build efficient, cost-effective data science solutions Leverage the capabilities of R Services to perform advanced analytics—from data exploration to predictive modeling A quick primer with practical examples to help you get up- and- running with SQL Server 2017 Machine Learning Services with R, as part of database solutions with continuous integration / continuous delivery. Book Description R Services was one of the most anticipated features in SQL Server 2016, improved significantly and rebranded as SQL Server 2017 Machine Learning Services. Prior to SQL Server 2016, many developers and data scientists were already using R to connect to SQL Server in siloed environments that left a lot to be desired, in order to do additional data analysis, superseding SSAS Data Mining or additional CLR programming functions. With R integrated within SQL Server 2017, these developers and data scientists can now benefit from its integrated, effective, efficient, and more streamlined analytics environment. This book gives you foundational knowledge and insights to help you understand SQL Server 2017 Machine Learning Services with R. First and foremost, the book provides practical examples on how to implement, use, and understand SQL Server and R integration in corporate environments, and also provides explanations and underlying motivations. It covers installing Machine Learning Services;maintaining, deploying, and managing code;and monitoring your services. Delving more deeply into predictive modeling and the RevoScaleR package, this book also provides insights into operationalizing code and exploring and visualizing data. To complete the journey, this book covers the new features in SQL Server 2017 and how they are compatible with R, amplifying their combined power. What you will learn Get an overview of SQL Server 2017 Machine Learning Services with R Manage SQL Server Machine Learning Services from installation to configuration and maintenance Handle and operationalize R code Explore RevoScaleR R algorithms and create predictive models Deploy, manage, and monitor database solutions with R Extend R with SQL Server 2017 features Explore the power of R for database administratorsWho this book is for This book is for data analysts, data scientists, and database administrators with some or no experience in R but who are eager to easily deliver practical data science solutions in their day-to-day work (or future projects) using SQL Server.
SQL Server Advanced Data Types: JSON, XML, and Beyond
by Peter A. CarterDeliver advanced functionality faster and cheaper by exploiting SQL Server's ever-growing amount of built-in support for modern data formats. Learn about the growing support within SQL Server for operations and data transformations that have previously required third-party software and all the associated licensing and development costs. Benefit through a better understanding of what can be done inside the database engine with no additional costs or development time invested in outside software.Widely used types such as JSON and XML are well-supported by the database engine. The same is true of hierarchical data and even temporal data. Knowledge of these advanced types is crucial to unleashing the full power that's available from your organization's SQL Server database investment. SQL Server Advanced Data Types explores each of the complex data types supplied within SQL Server. Common usage scenarios for each complex data type are discussed, followed by a detailed discussion on how to work with each data type. Each chapter demystifies the complex data and you learn how to use the data types most efficiently.The book offers a practical guide to working with complex data, using real-world examples to demonstrate how each data type can be leveraged. Performance considerations are also discussed, including the implementation of special indexes such as XML indexes and spatial indexes.What You'll LearnUnderstand the implementation of basic data types and why using the correct type is so importantWork with XML data through the XML data typeConstruct XML data from relational result setsStore and manipulate JSON data using the JSON data typeModel and analyze spatial data for geographic information systemsDefine hierarchies and query them efficiently through the HierarchyID typeWho This Book Is ForSQL Server developers and application developers who need to store and access complex data structures
SQL Server AlwaysOn Revealed
by Peter A. CarterGet a fast start to using AlwaysOn, the SQL Server solution to high-availability and disaster recovery. This second edition is newly-updated to cover the 2016 editions of both SQL Server and Windows Server. Also in this edition is all-new content on troubleshooting and metadata. The book provides a solid and accurate understanding of how to implement systems requiring consistent and continuous uptime, as well as how to troubleshoot those systems in order to keep them running an reliable. Begin with an introduction to high-availability and disaster recovery concepts such as Recovery Point Objectives (RPOs), Recovery Time Objectives (RTO), availability levels, and the cost of downtime. Then move into detailed coverage of implementing and configuring the AlwaysOn feature set in order to meet the business objectives set by your organization. SQL Server AlwaysOn Revealed offers real-world advice on how to build and configure the most appropriate topology to meet the high-availability and disaster recovery requirements you are faced with. Content includes strong coverage on implementing clusters, on building AlwaysOn failover clustered instances, and on configuring AlwaysOn Availability Groups. This is a practical and hand-on book to get you started quickly in using one of the most talked-about SQL Server feature sets. Teaches you to build HA and DR solutions using the AlwaysOn feature set Provides real-world advice on configuration and performance considerations Demonstrates administrative techniques for the AlwaysOn feature set What You Will Learn Understand high availability and disaster recovery in SQL Server 2016 Build and configure a Windows Cluster Create and configure an AlwaysOn failover clustered instance Implement AlwaysOn Availability Groups and appropriately configure them Administer AlwaysOn technologies post implementation Troubleshoot and resolve problems with misbehaving systems Who This Book Is For Database administrators interested in growing their knowledge and skills in Microsoft SQL Server's high-availability and disaster recovery feature set.
SQL Server Analysis Services 2012 Cube Development Cookbook
by Paul Turley Steve Hughes Baya DewaldA practical cookbook packed with recipes to help developers produce data cubes as quickly as possible by following step by step instructions, rather than explaining data mining concepts with SSAS.If you are a BI or ETL developer using SQL Server Analysis services to build OLAP cubes, this book is ideal for you. Prior knowledge of relational databases and experience with Excel as well as SQL development is required.
SQL Server Integration Services Design Patterns
by Andy Leonard Matt Masson Tim Mitchell Jessica Moss Michelle UffordSQL Server Integration Services Design Patterns is newly-revised for SQL Server 2014, and is a book of recipes for SQL Server Integration Services (SSIS). Design patterns in the book help to solve common problems encountered when developing data integration solutions. The patterns and solution examples in the book increase your efficiency as an SSIS developer, because you do not have to design and code from scratch with each new problem you face. The book's team of expert authors take you through numerous design patterns that you'll soon be using every day, providing the thought process and technical details needed to support their solutions. SQL Server Integration Services Design Patterns goes beyond the surface of the immediate problems to be solved, delving into why particular problems should be solved in certain ways. You'll learn more about SSIS as a result, and you'll learn by practical example. Where appropriate, the book provides examples of alternative patterns and discusses when and where they should be used. Highlights of the book include sections on ETL Instrumentation, SSIS Frameworks, Business Intelligence Markup Language, and Dependency Services. Takes you through solutions to common data integration challengesProvides examples involving Business Intelligence Markup LanguageTeaches SSIS using practical examples
SQL Server on Linux
by Jasmin AzemovicBring the performance and security of SQL Server to Linux About This Book • Design and administer your SQL Server solution on the open source Linux platform • Install, configure, and fine-tune your database application for maximum performance • An easy-to-follow guide teaching you how to implement various SQL Server CTP 2.x offerings on Linux—from installation to administration Who This Book Is For This book is for the Linux users who want to learn SQL Server on their favorite Linux distributions. It is not important if you are experienced database user or a beginner as we are starting from scratch. However, it is recommended that you have basic knowledge about relational models. More advanced readers can pick the chapters of their interest and study specific topics immediately. Users from Windows platform can also benefit from this book to expand their frontiers and become equally efficient on both platforms. What You Will Learn • Install and set up SQL Server CTP 2.x on Linux • Create and work with database objects using SQL Server on Linux • Configure and administer SQL Server on Linux-based systems • Create and restore database back-ups • Protect sensitive data using the built-in cryptographic features • Optimize query execution using indexes • Improve query execution time by more than 10x using in-memory OLTP • Track row-versioning using temporal tables In Detail Microsoft's launch of SQL Server on Linux has made SQL Server a truly versatile platform across different operating systems and data-types, both on-premise and on-cloud. This book is your handy guide to setting up and implementing your SQL Server solution on the open source Linux platform. You will start by understanding how SQL Server can be installed on supported and unsupported Linux distributions. Then you will brush up your SQL Server skills by creating and querying database objects and implementing basic administration tasks to support business continuity, including security and performance optimization. This book will also take you beyond the basics and highlight some advanced topics such as in-memory OLTP and temporal tables. By the end of this book, you will be able to recognize and utilize the full potential of setting up an efficient SQL Server database solution in your Linux environment. Style and approach This book follows a step-by-step approach to teach readers the concepts of SQL Server on Linux using the bash command line and SQL programming language trough examples which can easily be adapted and applied in your own solutions.
SQL Server Query Performance Tuning
by Grant FritcheyQueries not running fast enough? Wondering about the in-memory database features in 2014? Tired of phone calls from frustrated users? Grant Fritchey's book SQL Server Query Performance Tuning is the answer to your SQL Server query performance problems. The book is revised to cover the very latest in performance optimization features and techniques, especially including the newly-added, in-memory database features formerly known under the code name Project Hekaton. This book provides the tools you need to approach your queries with performance in mind. SQL Server Query Performance Tuning leads you through understanding the causes of poor performance, how to identify them, and how to fix them. You'll learn to be proactive in establishing performance baselines using tools like Performance Monitor and Extended Events. You'll learn to recognize bottlenecks and defuse them before the phone rings. You'll learn some quick solutions too, but emphasis is on designing for performance and getting it right, and upon heading off trouble before it occurs. Delight your users. Silence that ringing phone. Put the principles and lessons from SQL Server Query Performance Tuning into practice today. Covers the in-memory features from Project HekatonHelps establish performance baselines and monitor against themGuides in troubleshooting and eliminating of bottlenecks that frustrate users
SQL Server T-SQL Recipes
by Jonathan Gennick Jason Brimhall Wayne SheffieldSQL Server T-SQL Recipes is an example-based guide to the Transact-SQL language that is at the core of SQL Server. This edition has been lightly updated for SQL Server 2014 and provides ready-to-implement solutions to common programming and database administration tasks. Learn to create databases, create in-memory tables and stored procedures, insert and update data, generate reports, secure your data, and more. Tasks and their solutions are broken down into a problem/solution format that is quick and easy to read so that you can get the job done fast when the pressure is on. Solutions in this book are divided into chapters by problem domain. Each chapter is a collection of solutions around a single facet of the language such as writing queries, managing indexes, error handling, and query performance. Each solution is presented code-first, giving you a working code example to copy from and implement immediately in your own environment. Following each example is an in-depth description of how and why the given solution works. Tradeoffs and alternative approaches are also discussed. Focused on solutions: Look up what you need to do. Learn how to do it. Do it. Current: Lightly updated for SQL Server 2014 Comprehensive: Covers all common T-SQL problem domains What you'll learn Create databases, tables, and indexes Query and manipulate data Move business logic into the database Build reports that matter to your business. Perform common backup and recovery tasks Take advantage of window functions in your SQL Who this book is for SQL Server T-SQL Recipes is aimed at technically-oriented users of SQL Server desiring to extract the full power of the platform through it's powerful, built-in programming and scripting language. Target readers include developers who use SQL Server as their back-end database platform, and the database administrators who create, manage, and secure those databases. Table of Contents 1. Getting Started with SELECT 2. Elementary Programming 3. Working with NULLS 4. Combining Data from Multiple Tables 5. Aggregations and Grouping 6. Advanced SELECT Techniques 7. Windowing 8. Inserting, Updating, Deleting 9. Working with Strings 10. Working with Dates 11. Working with Numbers 12. Transactions, Locking, Blocking, Deadlockin 13. Managing Tables 14. Managing Views 15. Managing Indexes 16. Managing Large Tables 17. Stored Procedures 18. User-Defined Functions 19. In-Memory T-SQL 20. Triggers 21. Error Handling 22. Query Performance 23. Hints 24. Index Tuning and Statistics 25. XML 26. Files, Filegroups, and Integrity 27. Backup 28. Recovery 29. Principals and Users 30. Securables and Permissions 31. Objects and Dependencies