Practical Maintenance Plans in SQL Server
Automation for the DBA
| Price | $37.99 - $44.49
|
| Rating |   |
| Author | Bradley Beard |
| Publisher | Apress |
| Published | 2016 |
| Pages | 200 |
| Language | English |
| Format | Paper book / ebook (PDF) |
| ISBN-10 | 1484218949 |
| ISBN-13 | 9781484218945 |
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.
- Bradley Beard (2 books)
3 5 4
Similar Books
Pro Full-Text Search in SQL Server 2008
by Hilary Cotter, Michael Coles
Businesses today want actionable insights into their data - they want their data to reveal itself to them in a natural and user-friendly form. What could be more natural than human language? Natural-language search is at the center of a storm of ever - increasing web-driven demand for human-computer communication and information access. S...
Price: $26.72 | Publisher: Apress | Release: 2008
SQL Server 2019 Administration Inside Out
by Randolph West, Melody Zacharias, William Assaf, Sven Aelterman, Louis Davidson, Joseph D'Antoni
Dive into SQL Server 2019 administration - and really put your SQL Server DBA expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds - all you need to plan, implement, manage, and secure SQL Server 2019 in any production environment: on-premises, cloud, or hybrid. Six experts th...
Price: $48.15 | Publisher: Microsoft Press | Release: 2020
SQL Server 2017 Administration Inside Out
by William Assaf, Randolph West, Sven Aelterman, Mindy Curnutt
Dive into SQL Server 2017 administration - and really put your SQL Server DBA expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds - all you need to plan, implement, manage, and secure SQL Server 2017 in any production environment: on-premises, cloud, or hybrid. Four SQL Serve...
Price: $34.23 | Publisher: Microsoft Press | Release: 2018
Microsoft SQL Server 2012 Integration Services
by Wee-Hyong Tok, Rakesh Parida, Matt Masson, Xiaoning Ding, Kaarthik Sivashanmugam
Build and manage data integration solutions with expert guidance from the Microsoft SQL Server Integration Services (SSIS) team. See best practices in action and dive deep into the SSIS engine, SSISDB catalog, and security features. Using the developer enhancements in SQL Server 2012 and the flexible SSIS toolset, you'll handle compl...
Price: $8.80 | Publisher: Microsoft Press | Release: 2012
Tabular Modeling in Microsoft SQL Server Analysis Services, 2nd Edition
by Marco Russo, Alberto Ferrari
Create a semantic model and analyze data using the tabular model in SQL Server 2016 Analysis Services to create corporate-level business intelligence (BI) solutions. Led by two BI experts, you will learn how to build, deploy, and query a tabular model by following detailed examples and best practices. This hands-on book shows you how to u...
Price: $45.42 | Publisher: Microsoft Press | Release: 2017
by Bart Weller
Beginning SQL Server Modeling will help you gain a comprehensive understanding of how to apply DSLs and other modeling components in the development of SQL Server implementations. Most importantly, after reading the book and working through the examples, you will have considerable experience using SQL Modeling components, because the book...
Price: $17.99 | Publisher: Apress | Release: 2010
Microsoft SQL Server 2012 with Hadoop
by Debarchan Sarkar
With the explosion of data, the open source Apache Hadoop ecosystem is gaining traction, thanks to its huge ecosystem that has arisen around the core functionalities of its distributed file system (HDFS) and Map Reduce. As of today, being able to have SQL Server talking to Hadoop has become increasingly important because the two are indee...
Price: $23.99 | Publisher: Packt Publishing | Release: 2013
Data Science with SQL Server Quick Start Guide
by Dejan Sarka
SQL Server only started to fully support data science with its two most recent editions. If you are a professional from both worlds, SQL Server and data science, and interested in using SQL Server and Machine Learning (ML) Services for your projects, then this is the ideal book for you.This book is the ideal introduction to data science w...
Price: $34.99 | Publisher: Packt Publishing | Release: 2018