Brads Sure Guide To Sql Server Maintenance Plans

Download Brads Sure Guide To Sql Server Maintenance Plans full books in PDF, epub, and Kindle. Read online Brads Sure Guide To Sql Server Maintenance Plans ebook anywhere anytime directly on your device. Fast Download speed and no annoying ads. We cannot guarantee that every ebooks is available!

Brad's Sure Guide to SQL Server Maintenance Plans

Author : Brad McGehee
Publisher :
ISBN 13 : 9781906434342
Total Pages : 281 pages
Book Rating : 4.4/5 (343 download)

DOWNLOAD NOW!

Book Synopsis Brad's Sure Guide to SQL Server Maintenance Plans by : Brad McGehee

Download or read book Brad's Sure Guide to SQL Server Maintenance Plans written by Brad McGehee and published by . This book was released on 2010-01 with total page 281 pages. Available in PDF, EPUB and Kindle. Book excerpt: In his new book, Brad's Sure Guide to SQL Server Maintenance Plans, Brad McGehee takes you on a comprehensive tour of two SQL Server tools designed to help DBAs ensure that a "required minimum" level of maintenance takes place on their SQL Server instances: the Maintenance Plan Wizard and the Maintenance Plan Designer. Table of Contents * Chapter 01: Why is Database Maintenance Important? Chapter 02: Before you Create any Maintenance Plans Chapter 03: Getting Started with the Maintenance Plan Wizard Chapter 04: Task Scheduling Chapter 05: Check database Integrity Task Chapter 06: Shrink Database Task Chapter 07: Rebuild Index Task Chapter 08: Reorganize Index Task Chapter 09: Update Statistics Task Chapter 10: Execute SQL Server Agent Job Task Chapter 11: History Cleanup Task Chapter 12: Define Back Up Database (Full) Task Chapter 13: Define Back Up Database (Differential) Task Chapter 14: Back Up Database (Transaction Log) Task Chapter 15: Maintenance Cleanup Task Chapter 16: Using the Maintenance Plan Designer Why read this book? Millions of SQL Server instances run in the offices of small and medium-sized organizations and there are many "accidental" DBAs out there whose job it is to maintain them. Often, they find that they don't have the knowledge, experience, or critically the time, to perform the correct level of maintenance on their SQL Server databases, much as they might like to. This can mean poor performance and reduced availability. Regardless of the size of your organization, if your mission critical data becomes unavailable, then business will suffer greatly. The Maintenance Plan Wizard and Designer allow you to configure and schedule eleven core database maintenance tasks, ranging from integrity checks, to database backups, to index reorganizations and rebuilds. Brad walks through every one of these tasks covering: * The intent of each task and why it's important * How to configure each task and what all the options mean * Scheduling considerations: when and how often should you run the task? * Customizing and extended your Maintenance Plans using the Designer Used carefully, these Maintenance Plan tools represent powerful time-saving devices for any DBA. At each stage of the book, Brad explains clearly the correct and incorrect uses for the tool, and indicates where more advanced solutions, using T-SQL or PowerShell scripting, would be more appropriate.

Practical Maintenance Plans in SQL Server

Author : Bradley Beard
Publisher : Apress
ISBN 13 : 1484218957
Total Pages : 288 pages
Book Rating : 4.4/5 (842 download)

DOWNLOAD NOW!

Book Synopsis Practical Maintenance Plans in SQL Server by : Bradley Beard

Download or read book Practical Maintenance Plans in SQL Server written by Bradley Beard and published by Apress. This book was released on 2016-04-21 with total page 288 pages. Available in PDF, EPUB and Kindle. Book excerpt: This book is a complete guide to setting up and maintaining maintenance plans for SQL Server Database Administrators. Maintenance plans too often consist of a backup task and that’s it, but there is so much more that can and must be done to ensure the integrity of your most important company resource – the data you are tasked to manage and safeguard. This book walks even the newest of users through creating a powerful, automated maintenance plan. Automate your job using SQL Server Agent to leverage the power of Maintenance Plans to deliver real, proactive solutions to common issues. Schedule common tasks such as backups and index rebuilds to run automatically, and get early-warning notifications of impending problems relating to resource usage and query performance. By the time your boss knows to call you about a problem, you’ll have already called him to describe your solution. The large majority of books never really cover the topic of inheriting a database server with multiple live databases; the common thread is that the databases will be created and maintained by the reader forever and ever. In the real world, that scenario rarely happens. Practical Maintenance Plans in SQL Server covers that scenario and provides you with the knowledge and tools needed to get comfortable writing your own maintenance plans for any SQL Server database, whether created by you or inherited. Shows the different tasks that can be run in a maintenance plan. Explains how and why those tasks can be implemented. Provides a roadmap to creating your own custom maintenance plan. What You Will Learn Implement a completely automated backup maintenance plan Be alerted to performance problems and outages ahead of your boss Learn the different types of database maintenance tasks Plan the workflow of tasks within a maintenance plan Automate your work by implementing custom maintenance plans Who This Book Is For Practical Maintenance Plans in SQL Server is for any level of database administrator, but specifically it’s for those administrators with a real need to set up a powerful maintenance plan quickly. New and seasoned administrators will appreciate the book for its robust learning pattern of visual aids in combination with explanations and scenarios. Practical Maintenance Plans in SQL Server is the perfect “new hire” gift for new database administrators in any organization.

SQL Server Backup and Restore

Author : Shawn McGehee
Publisher :
ISBN 13 : 9781906434861
Total Pages : 408 pages
Book Rating : 4.4/5 (348 download)

DOWNLOAD NOW!

Book Synopsis SQL Server Backup and Restore by : Shawn McGehee

Download or read book SQL Server Backup and Restore written by Shawn McGehee and published by . This book was released on 2012 with total page 408 pages. Available in PDF, EPUB and Kindle. Book excerpt: A database administrator's duties include ensuring that a database can be restored and recovered in the event of error or disaster. This book discusses how to perform backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Red Gate's SQL Backup tool. Capturing backups using SSMS or simple scripts is fine for one-off backup operations, but any backups that form part of the recovery strategy for any given database must be automated with some built-in checks that, for example, alert the responsible database administrator immediately if a problem arises. The tool of choice in this book for backup automation is Red Gate SQL Backup. Building an automated solution will take a lot of work, but this book offers some advice on possible options, such as PowerShell scripting, T-SQL scripts and SQL Server Agent jobs. --

SQL Server Hardware

Author : Glenn Berry
Publisher :
ISBN 13 : 9781906434632
Total Pages : 340 pages
Book Rating : 4.4/5 (346 download)

DOWNLOAD NOW!

Book Synopsis SQL Server Hardware by : Glenn Berry

Download or read book SQL Server Hardware written by Glenn Berry and published by . This book was released on 2011-06 with total page 340 pages. Available in PDF, EPUB and Kindle. Book excerpt: SQL Server Hardware will provide the fundamental knowledge and resources you need to make intelligent decisions about choice, and optimal installation and configuration, of SQL Server hardware, operating system and the SQL Server RDBMS.

Performance Tuning with SQL Server Dynamic Management Views

Author : Louis Davidson
Publisher : Fastprint Publishing
ISBN 13 : 9781906434472
Total Pages : 344 pages
Book Rating : 4.4/5 (344 download)

DOWNLOAD NOW!

Book Synopsis Performance Tuning with SQL Server Dynamic Management Views by : Louis Davidson

Download or read book Performance Tuning with SQL Server Dynamic Management Views written by Louis Davidson and published by Fastprint Publishing. This book was released on 2010 with total page 344 pages. Available in PDF, EPUB and Kindle. Book excerpt: Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting armory, laying bare previously unavailable information regarding the under-the-covers activity of your database sessions and transactions. Why, then, aren't all DBAs using them? Why do many DBAs continue to ignore them in favour of "tried and trusted" tools such as sp_who2, DBCC OPENTRAN, and so on, or make do with the "ready made" reports built into SSMS? Why do even those that do use the DMVs speak wistfully about "good old sysprocesses"? There seem to be two main factors at work. Firstly, some DBAs are simply unaware of the depth and breadth of the information that is available from the DMvs, or how it might help them troubleshoot common issues. This book investigates all of the DMVs that are most frequently useful to the DBA in investigating query execution, index usage, session and transaction activity, disk IO, and how SQL Server is using or abusing the operating system. Secondly, the DMVs have a reputation of being difficult to use. In the process of exposing as much useful data as possible, sysprocesses has been de-normalized, and many new views and columns have been added. This fact, coupled with the initially-baffling choices of what columns will be exposed where, has lead to some DBAs to liken querying DMVs to "collecting mystic spells." In fact, however, once you start to write your own scripts, you'll see the same tricks, and similar join patterns, being used time and again. As such, a relatively small core set of scripts can be readily adapted to suit any requirement. This book is here to de-mystify the process of collecting the information you need to troubleshoot SQL Server problems. It will highlight the core techniques and "patterns" that you need to master, and will provide a core set of scripts that you can use and adapt for your own systems, including how to: * Root out the queries that are causing memory or CPU pressure on your system * Investigate caching, and query plan reuse * Identify index usage patterns * Track fragmentation in clustered indexes and heaps * Get full details on blocking and blocked transactions, including the exact commands being executed, and by whom. * Find out where SQL Server is spending time waiting for resources to be released, before proceeding * Monitor usage and growth of tempdb The DMVs don't make existing, built-in, performance tools obsolete. On the contrary, they complement these tools, and offer a flexibility, richness and granularity that are simply not available elsewhere. Furthermore, you don't need to master a new GUI, or a new language in order to use them; it's all done in a language all DBAs know and mostly love: T-SQL.

Microsoft SQL Server 2008 R2 Administration Cookbook

Author : Satya Shyam K. Jayanty
Publisher : Packt Publishing Ltd
ISBN 13 : 1849681457
Total Pages : 686 pages
Book Rating : 4.8/5 (496 download)

DOWNLOAD NOW!

Book Synopsis Microsoft SQL Server 2008 R2 Administration Cookbook by : Satya Shyam K. Jayanty

Download or read book Microsoft SQL Server 2008 R2 Administration Cookbook written by Satya Shyam K. Jayanty and published by Packt Publishing Ltd. This book was released on 2011-05-24 with total page 686 pages. Available in PDF, EPUB and Kindle. Book excerpt: Over 70 practical recipes for administering a high-performance SQL Server 2008 R2 system with this book and eBook.

Troubleshooting SQL Server

Author : Jonathan Kehayias
Publisher :
ISBN 13 : 9781906434786
Total Pages : 370 pages
Book Rating : 4.4/5 (347 download)

DOWNLOAD NOW!

Book Synopsis Troubleshooting SQL Server by : Jonathan Kehayias

Download or read book Troubleshooting SQL Server written by Jonathan Kehayias and published by . This book was released on 2011 with total page 370 pages. Available in PDF, EPUB and Kindle. Book excerpt: This book describes, diagnoses, and solves the most common problems with SQL Server 2005, 2008, and 2008 R2. The authors explain a basic approach to troubleshooting and the essential tools. They explore areas in which problems arise with regularity: high disk I/O (RAID misconfiguration, inadequate I/O throughput, poor workload distribution, SAN issues, disk partition misalignment); high CPU usage (insufficient memory, poorly written queries, inadequate indexing, inappropriate configuration option settings); memory mismanagement; missing indexes; blocking (caused mainly by poorly designed databases that lack proper keys and indexing, and applications that apply needlessly restrictive transaction isolation levels); deadlocking (Bookmark Lookup, Serializable Range Scan, Cascading Constraint); full transaction logs (lack of log backups, hefty index maintenance operations, long running transaction, problems with replication and mirroring environments); and accidentally-lost data. Finally, the authors discuss diagnosing tools such as the Performance Monitor, Dynamic Management Views, and server-side tracing. --

Mastering SQL Server Profiler

Author : Brad McGehee
Publisher : Red Gate Software
ISBN 13 : 1906434115
Total Pages : 306 pages
Book Rating : 4.9/5 (64 download)

DOWNLOAD NOW!

Book Synopsis Mastering SQL Server Profiler by : Brad McGehee

Download or read book Mastering SQL Server Profiler written by Brad McGehee and published by Red Gate Software. This book was released on 2009 with total page 306 pages. Available in PDF, EPUB and Kindle. Book excerpt:

Deployment Guide for InfoSphere Guardium

Author : Whei-Jen Chen
Publisher : IBM Redbooks
ISBN 13 : 0738439355
Total Pages : 472 pages
Book Rating : 4.7/5 (384 download)

DOWNLOAD NOW!

Book Synopsis Deployment Guide for InfoSphere Guardium by : Whei-Jen Chen

Download or read book Deployment Guide for InfoSphere Guardium written by Whei-Jen Chen and published by IBM Redbooks. This book was released on 2015-04-14 with total page 472 pages. Available in PDF, EPUB and Kindle. Book excerpt: IBM® InfoSphere® Guardium® provides the simplest, most robust solution for data security and data privacy by assuring the integrity of trusted information in your data center. InfoSphere Guardium helps you reduce support costs by automating the entire compliance auditing process across heterogeneous environments. InfoSphere Guardium offers a flexible and scalable solution to support varying customer architecture requirements. This IBM Redbooks® publication provides a guide for deploying the Guardium solutions. This book also provides a roadmap process for implementing an InfoSphere Guardium solution that is based on years of experience and best practices that were collected from various Guardium experts. We describe planning, installation, configuration, monitoring, and administrating an InfoSphere Guardium environment. We also describe use cases and how InfoSphere Guardium integrates with other IBM products. The guidance can help you successfully deploy and manage an IBM InfoSphere Guardium system. This book is intended for the system administrators and support staff who are responsible for deploying or supporting an InfoSphere Guardium environment.

Inside the SQL Server Query Optimizer

Author : Benjamin Nevarez
Publisher :
ISBN 13 : 9781906434601
Total Pages : 272 pages
Book Rating : 4.4/5 (346 download)

DOWNLOAD NOW!

Book Synopsis Inside the SQL Server Query Optimizer by : Benjamin Nevarez

Download or read book Inside the SQL Server Query Optimizer written by Benjamin Nevarez and published by . This book was released on 2011-03 with total page 272 pages. Available in PDF, EPUB and Kindle. Book excerpt: The SQL Server Query Optimizer is perceived by many to be a magic black box, transforming SQL queries into high performance execution plans in the blink of an eye through some unknowable process. The truth is that, while the Query Optimizer is indeed the highly-complex result of decades of research, learning how it works its magic is not only possible, but immensely useful to DBAs and Developers alike. A better understanding of what the Query Optimizer does behind the scenes can help you to improve the performance of your databases and applications, and this book explains the core concepts behind how the SQL Server Query Optimizer works. With this knowledge, you'll be able to write superior queries, provide the Query Optimizer with all the information it needs to produce efficient execution plans, and troubleshoot the cases when the Query Optimizer is not giving you the best plan possible. With over 15 years of experience in the use of Relational Databases (including SQL Server since version 6.5), Benjamin has watched the SQL Server Query Optimizer grow and evolve. His insight will leave you with an excellent foundation in the practicalities of the Query Optimizer, and everything you need to know to start tuning your queries to perfection.

The Guru's Guide to SQL Server Architecture and Internals

Author : Ken Henderson
Publisher : Addison-Wesley Professional
ISBN 13 : 9780201700473
Total Pages : 1076 pages
Book Rating : 4.7/5 (4 download)

DOWNLOAD NOW!

Book Synopsis The Guru's Guide to SQL Server Architecture and Internals by : Ken Henderson

Download or read book The Guru's Guide to SQL Server Architecture and Internals written by Ken Henderson and published by Addison-Wesley Professional. This book was released on 2004 with total page 1076 pages. Available in PDF, EPUB and Kindle. Book excerpt: bull; Contains the most depth and breadth of coverage of any book on SQL Server architecture, internals, and tuning bull; Will be a key reference for anyone working with SQL Server, no matter what their skill level bull; The latest book in the bestselling series of Guru's Guides from Ken Henderson

Building a Data Warehouse

Author : Vincent Rainardi
Publisher : Apress
ISBN 13 : 1430205288
Total Pages : 526 pages
Book Rating : 4.4/5 (32 download)

DOWNLOAD NOW!

Book Synopsis Building a Data Warehouse by : Vincent Rainardi

Download or read book Building a Data Warehouse written by Vincent Rainardi and published by Apress. This book was released on 2008-03-11 with total page 526 pages. Available in PDF, EPUB and Kindle. Book excerpt: Here is the ideal field guide for data warehousing implementation. This book first teaches you how to build a data warehouse, including defining the architecture, understanding the methodology, gathering the requirements, designing the data models, and creating the databases. Coverage then explains how to populate the data warehouse and explores how to present data to users using reports and multidimensional databases and how to use the data in the data warehouse for business intelligence, customer relationship management, and other purposes. It also details testing and how to administer data warehouse operation.

IBM i 6.1 Independent ASPs: A Guide to Quick Implementation of Independent ASPs

Author : Scott Vetter
Publisher : IBM Redbooks
ISBN 13 : 0738433683
Total Pages : 268 pages
Book Rating : 4.7/5 (384 download)

DOWNLOAD NOW!

Book Synopsis IBM i 6.1 Independent ASPs: A Guide to Quick Implementation of Independent ASPs by : Scott Vetter

Download or read book IBM i 6.1 Independent ASPs: A Guide to Quick Implementation of Independent ASPs written by Scott Vetter and published by IBM Redbooks. This book was released on 2009-12-10 with total page 268 pages. Available in PDF, EPUB and Kindle. Book excerpt: This IBM® Redbooks® publication explains how to configure and manage independent disk pool (IASP) functionality of IBM i 6.1. It is designed to help IBM technical professionals, business partners, and customers understand and implement independent disk pools in the IBM i 6.1. In addition, this publication provides the background information that is necessary to plan, implement, and customize this functionality to your particular environment. It provides guidance on running user applications with either application data or most application objects residing in an independent disk pool. Considering that you can also use independent disk pools in a cluster environment, this publication shows you the basic steps to make your independent disk pool switchable between two Power SystemsTM servers or a single server with multiple LPARs. Independent auxiliary storage pools have many business and technical advantages for Power Systems using IBM i. Not only are independent auxiliary storage pools (IASPs) easy to create and maintain, most applications can use them by simple work management changes. IASPs can provide immediate benefits to your enterprise.

The Art of High Performance SQL Code

Author : Grant Fritchey
Publisher :
ISBN 13 : 9781906434021
Total Pages : 242 pages
Book Rating : 4.4/5 (34 download)

DOWNLOAD NOW!

Book Synopsis The Art of High Performance SQL Code by : Grant Fritchey

Download or read book The Art of High Performance SQL Code written by Grant Fritchey and published by . This book was released on 2009-03 with total page 242 pages. Available in PDF, EPUB and Kindle. Book excerpt: Execution plans show you what's going on behind the scenes in SQL Server. They can provide you with a wealth of information on how your queries are being executed by SQL Server, including: Which indexes are being used, and where no indexes are being used at all. How the data is being retrieved, and joined, from the tables defi ned in your query. How aggregations in GROUP BY queries are put together. The anticipated load and the estimated cost that all these operations place upon the system. Grant Fritchey's book is the only in-depth look at how to improve your SQL query performance through careful design of execution plans. Sample chapters of the ebook have garnered stunning reviews, such as: "All I can say is WOW. This has to be the best reference I have ever seen on Execution Plans in SQL Server. My hats off to Grant Fritchey" Jonathan Kehayias.

IBM System Storage Business Continuity: Part 1 Planning Guide

Author : Charlotte Brooks
Publisher : IBM Redbooks
ISBN 13 : 0738489700
Total Pages : 422 pages
Book Rating : 4.7/5 (384 download)

DOWNLOAD NOW!

Book Synopsis IBM System Storage Business Continuity: Part 1 Planning Guide by : Charlotte Brooks

Download or read book IBM System Storage Business Continuity: Part 1 Planning Guide written by Charlotte Brooks and published by IBM Redbooks. This book was released on 2007-03-07 with total page 422 pages. Available in PDF, EPUB and Kindle. Book excerpt: A disruption to your critical business processes could leave the entire business exposed. Today's organizations face ever-escalating customer demands and expectations. There is no room for downtime. You need to provide your customers with continuous service because your customers have a lot of choices. Your competitors are standing ready to take your place. As you work hard to grow your business, you face the challenge of keeping your business running without a glitch. To remain competitive, you need a resilient IT infrastructure. This IBM Redbooks publication introduces the importance of Business Continuity in today's IT environments. It provides a comprehensive guide to planning for IT Business Continuity and can help you design and select an IT Business Continuity solution that is right for your business environment. We discuss the concepts, procedures, and solution selection for Business Continuity in detail, including the essential set of IT Business Continuity requirements that you need to identify a solution. We also present a rigorous Business Continuity Solution Selection Methodology that includes a sample Business Continuity workshop with step-by-step instructions in defining requirements. This book is meant as a central resource book for IT Business Continuity planning and design. The companion title to this book, IBM System Storage Business Continuity: Part 2 Solutions Guide, SG24-6548, describes detailed product solutions in the System Storage Resiliency Portfolio.

Azure SQL Revealed

Author : Bob Ward
Publisher : Apress
ISBN 13 : 1484259319
Total Pages : 408 pages
Book Rating : 4.4/5 (842 download)

DOWNLOAD NOW!

Book Synopsis Azure SQL Revealed by : Bob Ward

Download or read book Azure SQL Revealed written by Bob Ward and published by Apress. This book was released on 2020-10-30 with total page 408 pages. Available in PDF, EPUB and Kindle. Book excerpt: Access detailed content and examples on Azure SQL, a set of cloud services that allows for SQL Server to be deployed in the cloud. This book teaches the fundamentals of deployment, configuration, security, performance, and availability of Azure SQL from the perspective of these same tasks and capabilities in SQL Server. This distinct approach makes this book an ideal learning platform for readers familiar with SQL Server on-premises who want to migrate their skills toward providing cloud solutions to an enterprise market that is increasingly cloud-focused. If you know SQL Server, you will love this book. You will be able to take your existing knowledge of SQL Server and translate that knowledge into the world of cloud services from the Microsoft Azure platform, and in particular into Azure SQL. This book provides information never seen before about the history and architecture of Azure SQL. Author Bob Ward is a leading expert with access to and support from the Microsoft engineering team that built Azure SQL and related database cloud services. He presents powerful, behind-the-scenes insights into the workings of one of the most popular database cloud services in the industry. What You Will LearnKnow the history of Azure SQLDeploy, configure, and connect to Azure SQLChoose the correct way to deploy SQL Server in AzureMigrate existing SQL Server instances to Azure SQLMonitor and tune Azure SQL’s performance to meet your needsEnsure your data and application are highly availableSecure your data from attack and theft Who This Book Is For This book is designed to teach SQL Server in the Azure cloud to the SQL Server professional. Anyone who operates, manages, or develops applications for SQL Server will benefit from this book. Readers will be able to translate their current knowledge of SQL Server—especially of SQL Server 2019—directly to Azure. This book is ideal for database professionals looking to remain relevant as their customer base moves into the cloud.

XML and JSON Recipes for SQL Server

Author : Alex Grinberg
Publisher : Apress
ISBN 13 : 1484231171
Total Pages : 303 pages
Book Rating : 4.4/5 (842 download)

DOWNLOAD NOW!

Book Synopsis XML and JSON Recipes for SQL Server by : Alex Grinberg

Download or read book XML and JSON Recipes for SQL Server written by Alex Grinberg and published by Apress. This book was released on 2017-12-18 with total page 303 pages. Available in PDF, EPUB and Kindle. Book excerpt: Quickly find solutions to dozens of common problems encountered while using XML and JSON features that are built into SQL Server. Content is presented in the popular problem-solution format. Look up the problem that you want to solve. Read the solution. Apply the solution directly in your own code. Problem solved! This book shows how to take advantage of XML and JSON to share data and automate tasks. JSON is commonly used to move data back and forth between the database and front-end applications, often running in a browser. This book shows all you need to know about transforming query results into JSON format, and back again. Also covered are the processes and techniques for moving data into and out of XML format for business intelligence and other purposes, such as when transferring data from a reporting system into a data warehouse, or between different database brands such as between SQL Server and Oracle. Microsoft intensively implements XML in SQL Server, and in many related products. Execution plans are generated in XML format, and this book shows you how to parse those plans and automate the detection of performance problems. The relatively new Extended Events feature writes tracing data into XML files, and the recipes in this book help in parsing those files. XML is also used in SQL Server's BI tool set, including in SSIS, SSR, and SSAS. XML is used in many configuration files, and is even behind the construction of DDL triggers. In reading this book you’ll dive deeply into the features that allow you to build and parse XML, and also JSON, which is a specific format of XML used to transmit objects in a web-friendly format between a database and its front-end applications. What You Will Learn Build XML and JSON objects in support of automation and data transfer Import and parse XML and JSON from operating system files Build appropriate indexes on XML objects to improve query performance Move data from query result sets into JSON format, and back again Automate the detection of database performance problems by querying and parsing the database’s own execution plans Replace external and manual JSON processes with SQL Server's internal, JSON functionality Who This Book Is For Database administrators, .NET developers, business intelligence developers, and other professionals who want a deep and detailed skill set around working with XML and JSON in a SQL Server database environment. Web developers will particularly find the book useful for its coverage of transforming database result sets into JSON text that can be transmitted to front-end web applications.