Professional Microsoft SQL Server 2012 Administration


Author: Adam Jorgensen,Steven Wort,Ross LoForte,Brian Knight
Publisher: John Wiley & Sons
ISBN: 1118286847
Category: Computers
Page: 960
View: 3707
DOWNLOAD NOW »
An essential how-to guide for experienced DBAs on the most significant product release since 2005! Microsoft SQL Server 2012 will have major changes throughout the SQL Server and will impact how DBAs administer the database. With this book, a team of well-known SQL Server experts introduces the many new features of the most recent version of SQL Server and deciphers how these changes will affect the methods that administrators have been using for years. Loaded with unique tips, tricks, and workarounds for handling the most difficult SQL Server admin issues, this how-to guide deciphers topics such as performance tuning, backup and recovery, scaling and replication, clustering, and security. Serves as a must-have how-to guide on the new features of the 2012 release of Microsoft SQL Server Walks you through ways to manage and monitor SQL Server and automate administration Guides you through SQL Azure for cloud computing, data replication, and data warehouse performance improvements Addresses client-connectivity enhancements, new features that ensure high availability of mission-critical applications, and tighter integration with Excel and SharePoint for data analysis and reporting Highlights major changes to the suite of SQL Server BI tools, including integration, reporting, and analysis services Includes real-world case examples and best practices from Microsoft insiders If you're a database administrator eager to get started with the newest version of SQL Server, then this book is essential reading.

Beginning Microsoft SQL Server 2012 Programming


Author: Paul Atkinson,Robert Vieira
Publisher: John Wiley & Sons
ISBN: 1118236211
Category: Computers
Page: 864
View: 9815
DOWNLOAD NOW »
Get up to speed on the extensive changes to the newest release of Microsoft SQL Server The 2012 release of Microsoft SQL Server changes how you develop applications for SQL Server. With this comprehensive resource, SQL Server authority Robert Vieira presents the fundamentals of database design and SQL concepts, and then shows you how to apply these concepts using the updated SQL Server. Publishing time and date with the 2012 release, Beginning Microsoft SQL Server 2012 Programming begins with a quick overview of database design basics and the SQL query language and then quickly proceeds to show you how to implement the fundamental concepts of Microsoft SQL Server 2012. You'll explore the key additions and changes to this newest version, including conditional action constructs, enhanced controls for results paging, application integration with SharePoint and Excel, and development of BI applications. Covers new features such as SQL Azure for cloud computing, client-connectivity enhancements, security and compliance, data replication, and data warehouse performance improvements Addresses essential topics including managing keys, writing scripts, and working with store procedures Shares helpful techniques for creating and changing tables, programming with XML, and using SQL Server Reporting and Integration Services Beginning Microsoft SQL Server 2012 Programming demystifies even the most difficult challenges you may face with the new version of Microsoft SQL Server.

Administrieren von Microsoft SQL Server 2012-Datenbanken - Original Microsoft Training für Examen 70-462

Praktisches Selbststudium und Prüfungsvorbereitung
Author: Orin Thomas,Peter Ward,boB Taylor
Publisher: Microsoft Press Deutschland
ISBN: 3848311585
Category: Computers
Page: 634
View: 3391
DOWNLOAD NOW »
Erlernen Sie das Administrieren von Microsoft SQL Server 2012-Datenbanken und bereiten Sie sich gleichzeitig auf das Examen 70-462 vor. Das vorliegende Buch bietet Ihnen einen umfassenden Lehrbuchteil, mit dem Sie selbständig lernen und anhand praktischer Übungen die prüfungsrelevanten Fähigkeiten erwerben. Die anschließende Lernzielkontrolle ermöglicht Ihnen, anhand von Fragen und Antworten Ihre Kenntnisse zu überprüfen. Das Buch eignet sich auch als Nachschlagewerk für die tägliche Arbeit. Verbessern Sie Ihre Kenntnisse und Ihre beruflichen Chancen mit diesem Original Microsoft Training.

Microsoft SQL Server 2012 - Überblick über Konfiguration, Administration, Programmierung


Author: Markus Raatz,Jörg Knuth,Ruprecht Dröge
Publisher: Microsoft Press Deutschland
ISBN: 384831925X
Category: Computers
Page: 576
View: 5856
DOWNLOAD NOW »
Microsoft SQL Server 2012 ist ein mächtiges Datenbanksystem, das mit vielen anderen Anwendungen in den Bereichen Business Intelligence, Office, Reporting und Cloud-Computing verwoben werden kann. Damit Sie nicht den Überblick verlieren, haben Markus Raatz, Jörg Knuth und Ruprecht Dröge eine für SQL Server 2012 aktualisierte Auflage ihres erfolgreichen Buchs geschrieben. Eingebettet in den Kontext klassischer Datenbankthemen wie Entwurf, Entwicklung und Betrieb erläutern die Autoren Ihnen das Wichtigste zu den Neuerungen in SQL Server 2012. Dabei beweisen die Autoren, dass ein Fachbuch unterhaltsam und kurzweilig sein und dennoch das Know-how dreier ausgewiesener Experten transportieren kann. Wenn Sie die Möglichkeiten von SQL Server 2012 kennenlernen und die Software erfolgreich zum Einsatz bringen möchten, ist dieses Buch genau das Richtige für Sie!

Professional Microsoft SQL Server 2012 Analysis Services with MDX and DAX


Author: Sivakumar Harinath,Ronald Pihlgren,Denny Guang-Yeu Lee,John Sirmon,Robert M. Bruckner
Publisher: John Wiley & Sons
ISBN: 1118237080
Category: Computers
Page: 1176
View: 4695
DOWNLOAD NOW »
Understand Microsoft's dramatically updated new release of its premier toolset for business intelligence The first major update to Microsoft's state-of-the-art, complex toolset for business intelligence (BI) in years is now available and what better way to master it than with this detailed book from key members of the product's development team? If you're a database or data warehouse developer, this is the expert resource you need to build full-scale, multi-dimensional, database applications using Microsoft's new SQL Server 2012 Analysis Services and related tools. Discover how to solve real-world BI problems by leveraging a slew of powerful new Analysis Services features and capabilities. These include the new DAX language, which is a more user-friendly version of MDX; PowerPivot, a new tool for performing simplified analysis of data; BISM, Microsoft's new Business Intelligence Semantic Model; and much more. Serves as an authoritative guide to Microsoft's new SQL Server 2012 Analysis Services BI product and is written by key members of the Microsoft Analysis Services product development team Covers SQL Server 2012 Analysis Services, a major new release with a host of powerful new features and capabilities Topics include using the new DAX language, a simplified, more user-friendly version of MDX; PowerPivot, a new tool for performing simplified analysis of data; BISM, Microsoft's new Business Intelligence Semantic Model; and a new, yet-to-be-named BI reporting tool Explores real-world scenarios to help developers build comprehensive solutions Get thoroughly up to speed on this powerful new BI toolset with the timely and authoritative Professional Microsoft SQL Server 2012 Analysis Services with MDX.

Professional Microsoft SQL Server 2014 Administration


Author: Adam Jorgensen,Bradley Ball,Steven Wort,Ross LoForte,Brian Knight
Publisher: John Wiley & Sons
ISBN: 1118859197
Category: Computers
Page: 936
View: 9539
DOWNLOAD NOW »
Learn to take advantage of the opportunities offered by SQLServer 2014 Microsoft's SQL Server 2014 update means big changes fordatabase administrators, and you need to get up to speed quicklybecause your methods, workflow, and favorite techniques will bedifferent from here on out. The update's enhanced support oflarge-scale enterprise databases and significant price advantagemean that SQL Server 2014 will become even more widely adoptedacross the industry. The update includes new backup and recoverytools, new AlwaysOn features, and enhanced cloud capabilities.In-memory OLTP, Buffer Pool Extensions for SSDs, and a newCardinality Estimator can improve functionality and smooth out theworkflow, but only if you understand their full capabilities.Professional Microsoft SQL Server 2014 is your comprehensiveguide to working with the new environment. Authors Adam Jorgensen,Bradley Ball, Ross LoForte, Steven Wort, and Brian Knight are thedream team of the SQL Server community, and they put theirexpertise to work guiding you through the changes. Improve oversight with better management and monitoring Protect your work with enhanced security features Upgrade performance tuning, scaling, replication, andclustering Learn new options for backup and recovery Professional Microsoft SQL Server 2014 includes acompanion website with sample code and efficient automationutilities, plus a host of tips, tricks, and workarounds that willmake your job as a DBA or database architect much easier. Stopgetting frustrated with administrative issues and start takingcontrol. Professional Microsoft SQL Server 2014 is yourroadmap to mastering the update and creating solutions thatwork.

Pro SQL Server 2012 Administration


Author: Ken Simmons,Sylvester Carstarphen
Publisher: Apress
ISBN: 1430239158
Category: Computers
Page: 508
View: 2210
DOWNLOAD NOW »
Pro SQL Server 2012 Administration is a one-stop source for all the knowledge you'll need to professionally manage a database under Microsoft SQL Server 2012. SQL Server administration is a complex field requiring an unusually broad and well-rounded skill set. A good database administrator must be part system administrator, part database design expert, and part SQL tuning optimization guru. Above all, he or she must be capable of restoring a damaged database at any time. Database administration requires excellent people skills for dealing with management and clients, and solid technical skills for dealing with the hardware and the software. Pro SQL Server 2012 Administration addresses all aspects of database administration, regardless of the size of the implementation. Install SQL Server 2012 and create new database environments. Develop a sound backup strategy for your database. Perform recovery as needed, which many consider to be job #1. Authors Ken Simmons and Sylvester Carstarphen also help you automate your work through the use of policy-based management. Performance optimization gets good coverage, so that you can render assistance when developers need help with problem queries. Rare among database and other technical books is solid guidance on the people side of the equation. Success as a database administrator comes from working well with others, becoming involved in the community, and building the right combination of technical knowledge and people skills to solve problems and get things done professionally and amicably. Simmons and Carstarphen pay special attention to these aspects of the job in this new edition of their comprehensive book on SQL Server administration. Helps you manage a SQL Server 2012 database at professional level Covers the gamut of database administration skills Provides guidance on performance optimization What you’ll learn Install SQL Server 2012 and create new databases Implement backup & recovery strategies to protect your database, and your job Diagnose and resolve query performance problems Apply policy-based management for consistency across all databases in an organization Turn every interaction with a client, manager or executive into a stepping-stone towards career success Who this book is for Pro SQL Server 2012 Administration is aimed at junior and seasoned database administrators who are looking to develop their knowledge and skill set in Microsoft SQL Server 2012. Readers should already have some exposure to databases in general, or to SQL Server in specific. Table of Contents What's New? Pre-Install Considerations Choosing a High-Availability Solution Installing and Upgrading Post Installation Multi-Server Administration Security Administering Database Objects Indexing for Performance Managing Backups Restore and Recovery Strategies Automating Routine Maintenance Monitoring Your Server Auditing Extended Events Interface Managing Query Performance Secrets to Excelling as a Professional DBA What's Next?

Microsoft SQL Server 2012 Administration

Real-World Skills for MCSA Certification and Beyond (Exams 70-461, 70-462, and 70-463)
Author: Tom Carpenter
Publisher: John Wiley & Sons
ISBN: 1118654900
Category: Computers
Page: 936
View: 7647
DOWNLOAD NOW »
Implement, maintain, and repair SQL Server 2012databases As the most significant update since 2008, Microsoft SQL Server2012 boasts updates and new features that are critical tounderstand. Whether you manage and administer SQL Server 2012 orare planning to get your MCSA: SQL Server 2012 certification, thisbook is the perfect supplement to your learning and preparation.From understanding SQL Server's roles to implementing businessintelligence and reporting, this practical book explores tasks andscenarios that a working SQL Server DBA faces regularly and showsyou step by step how to handle them. Includes practice exams and coverage of exam objectives forthose seeking MSCA: SQL Server 2012 certification Explores the skills you'll need on the job as a SQL Server 2012DBA Discusses designing and implementing database solutions Walks you through administrating, maintaining, and securing SQLServer 2012 Addresses implementing high availability and datadistribution Includes bonus videos where the author walks you through someof the more difficult tasks expected of a DBA Featuring hands-on exercises and real-world scenarios, thisresource guides you through the essentials of implementing,maintaining, and repairing SQL Server 2012 databases.

Professional Windows 8 Programming

Application Development with C# and XAML
Author: Nick Lecrenski,Doug Holland,Allen Sanders,Kevin Ashley
Publisher: John Wiley & Sons
ISBN: 1118240820
Category: Computers
Page: 504
View: 7133
DOWNLOAD NOW »


Microsoft SQL Server 2008 Internals

Insiderwissen zur Verbesserung der Systemleistung von Microsoft SQL Server 2008
Author: Kalen Delaney
Publisher: N.A
ISBN: 9783866456563
Category: Database management
Page: 818
View: 3019
DOWNLOAD NOW »


Abfragen von Microsoft SQL Server 2012 - Original Microsoft Training für Examen 70-461

Praktisches Selbststudium und Prüfungsvorbereitung
Author: Itzik Ben-Gan,Dejan Sarka,Ron Talmage
Publisher: Microsoft Press Deutschland
ISBN: 3848301679
Category: Computers
Page: 700
View: 1553
DOWNLOAD NOW »
Erlernen Sie das Abfragen von Microsoft SQL Server 2012 und bereiten Sie sich gleichzeitig auf das Examen 70-461 vor. Das vorliegende Buch bietet Ihnen einen umfassenden Lehrbuchteil, mit dem Sie selbständig lernen und anhand praktischer Übungen die prüfungsrelevanten Fähigkeiten erwerben. Die anschließende Lernzielkontrolle ermöglicht Ihnen, anhand von Fragen und Antworten Ihre Kenntnisse zu überprüfen. Das Buch eignet sich auch als Nachschlagewerk für die tägliche Arbeit. Auf CD finden Sie eine Testprüfung mit 200 Fragen (englischsprachig). Verbessern Sie Ihre Kenntnisse und Ihre beruflichen Chancen mit diesem Original Microsoft Training.

Professional Microsoft SQL Server 2012 Reporting Services


Author: Paul Turley,Robert M. Bruckner,Thiago Silva,Ken Withee,Grant Paisley
Publisher: John Wiley & Sons
ISBN: 1118237137
Category: Computers
Page: 912
View: 5880
DOWNLOAD NOW »
A must-have guide for the latest updates to the new release of Reporting Services SQL Server Reporting Services allows you to create reports and business intelligence (BI) solutions. With this updated resource, a team of experts shows you how Reporting Services makes reporting faster, easier and more powerful than ever in web, desktop, and portal solutions. New coverage discusses the new reporting tool called Crescent, BI semantic model's impact on report design and creation, semantic model design, and more. You'll explore the major enhancements to Report Builder and benefit from best practices shared by the authors. Builds on the previous edition while also providing coverage of the new features introduced with SQL Server 2012 Explains Reporting Services architecture and BI fundamentals Covers advanced report design and filtering techniques, walking you through each design, discussing its purpose and the conditions where it could be more efficient Discusses semantic model design, Report Builder, Crescent, and more Targets business analysts and report designers as well as BI solution developers Professional Microsoft SQL Server 2012 Reporting Services is mandatory reading if you are eager to start using the newest version of SQL Server Reporting Services.

Virtualizing SQL Server with VMware

Doing IT Right
Author: Michael Corey,Jeff Szastak,Michael Webster
Publisher: VMWare Press
ISBN: 0133430154
Category: Computers
Page: 512
View: 2642
DOWNLOAD NOW »
The start-to-finish guide to virtualizing business-critical SQL Server databases on VMware vSphere 5 By virtualizing business-critical databases, enterprises can drive far more value from existing IT infrastructure. But squeezing maximum performance out of a virtualized database instance is an art as much as a science. This indispensable start-to-finish guide brings together all the techniques, tips, and insights you need to succeed. Drawing on unsurpassed personal experience, three leading experts share complete best practices for deploying business-critical database servers in virtualized vSphere 5 environments. They cover the entire project lifecycle, bridging technical and communications gaps between SQL Server and VMware professionals that often make database virtualization more difficult than it needs to be. You’ll find specific guidance for architects and administrators responsible for systems, storage, databases, applications, or VMware virtualization. The authors also present detailed, start-to-finish coverage of performance baselining and testing: all you need to make your virtualized databases as fast as they are cost effective. Although this book focuses on SQL, the authors’ proven guidance for enhancing performance can be leveraged by any IT professional virtualizing a demanding Tier 1 application. Coverage includes • Business cases for database virtualization: consolidation, Database as a Service (DaaS), efficiency, and “SLAs on steroids” • Using the redundancy inherent in virtualization to improve availability • Constructing a careful, conservative implementation plan • Balancing disk, CPU, memory, and network for superior performance • Mastering the five key principles of database storage design • Leveraging memory: SQL MAX, page locking, NUMA, reservations, swapping, large memory pages, and more • Ensuring responsiveness by providing a fast, reliable, low-latency network • Supporting advanced AlwaysOn Failover Cluster Instances and Availability Groups • Baselining physical systems and properly determining resource requirements • Configuring performance tests from beginning to end • Migrating existing SQL Server databases onto a vSphere platform • Avoiding traps and pitfalls in virtualizing production databases • Managing and monitoring virtualized database instances and resources

Professional Microsoft SQL Server 2014 Integration Services


Author: Brian Knight,Devin Knight,Jessica M. Moss,Mike Davis,Chris Rock
Publisher: John Wiley & Sons
ISBN: 1118850858
Category: Computers
Page: 912
View: 8822
DOWNLOAD NOW »
Fill the gap between planning and doing with SSIS 2014 The 2014 release of Microsoft's SQL Server Integration Servicesprovides enhancements for managing extraction, transformation, andload operations, plus expanded in-memory capabilities, improveddisaster recovery, increased scalability, and much more. Theincreased functionality will streamline your ETL processes andsmooth out your workflow, but the catch is that your workflow mustchange. New tools come with new best practices, and ProfessionalMicrosoft SQL Server 2014 Integration Services will keep youahead of the curve. SQL Server MVP Brian Knight is the mostrespected name in the business, and your ultimate guide tonavigating the changes to use Microsoft SQL Server IntegrationServices 2014 to your utmost advantage. Implement new best practices for effective use of SSIS Work through tutorials for hands-on learning of complextechniques Read case studies that illustrate the more advancedconcepts Learn directly from the foremost authority on SSIS SQL Server Integration Services is a complex tool, but it's thelifeblood of your work. You need to know it inside out, and youmust understand the full potential of its capabilities in order touse it effectively. You need to make sure the right architecture isin place. Professional Microsoft SQL Server 2014 IntegrationServices is your roadmap to understanding SSIS on a fundamentallevel, and setting yourself up for success.

Microsoft SQL Server 2012 Bible


Author: Adam Jorgensen,Jorge Segarra,Patrick LeBlanc,Jose Chinchilla,Aaron Nelson
Publisher: John Wiley & Sons
ISBN: 1118282175
Category: Computers
Page: 1416
View: 8106
DOWNLOAD NOW »
Harness the powerful new SQL Server 2012 Microsoft SQL Server 2012 is the most significant update to thisproduct since 2005, and it may change how database administratorsand developers perform many aspects of their jobs. If you're adatabase administrator or developer, Microsoft SQL Server 2012Bible teaches you everything you need to take full advantage ofthis major release. This detailed guide not only covers all the newfeatures of SQL Server 2012, it also shows you step by step how todevelop top-notch SQL Server databases and new data connections andkeep your databases performing at peak. The book is crammed with specific examples, sample code, and ahost of tips, workarounds, and best practices. In addition,downloadable code is available from the book's companion web site,which you can use to jumpstart your own projects. Serves as an authoritative guide to Microsoft's SQL Server 2012for database administrators and developers Covers all the software's new features and capabilities,including SQL Azure for cloud computing, enhancements to clientconnectivity, and new functionality that ensures high-availabilityof mission-critical applications Explains major new changes to the SQL Server BusinessIntelligence tools, such as Integration, Reporting, and AnalysisServices Demonstrates tasks both graphically and in SQL code to enhanceyour learning Provides source code from the companion web site, which you canuse as a basis for your own projects Explores tips, smart workarounds, and best practices to helpyou on the job Get thoroughly up to speed on SQL Server 2012 with MicrosoftSQL Server 2012 Bible.

Microsoft SQL Server 2012 Master Data Services 2/E


Author: Tyler Graham
Publisher: McGraw Hill Professional
ISBN: 0071797866
Category: Computers
Page: 416
View: 1954
DOWNLOAD NOW »
Deploy and Maintain an Integrated MDS Architecture Harness your master data and grow revenue while reducing administrative costs. Thoroughly revised to cover the latest MDS features, Microsoft SQL Server 2012 Master Data Services, Second Edition shows how to implement and manage a centralized, customer-focused MDS framework. See how to accurately model business processes, load and cleanse data, enforce business rules, eliminate redundancies, and publish data to external systems. Security, SOA and Web services, and legacy data integration are also covered in this practical guide. Install Microsoft SQL Server 2012 Master Data Services Build custom MDS models and entityspecific staging tables Load and cleanse data from disparate sources Logically group assets into collections and hierarchies Ensure integrity using versioning and business rules Configure security at functional, object, and attribute levels Extend functionality with SOA and Web services Facilitate collaboration using the MDS Excel Add-In Export data to subscribing systems through SQL views

Microsoft SQL Server 2012 A Beginners Guide 5/E


Author: Dusan Petkovic
Publisher: McGraw Hill Professional
ISBN: 0071761608
Category: Computers
Page: 832
View: 9176
DOWNLOAD NOW »
Essential Microsoft SQL Server 2012 Skills Made Easy Get up and running on Microsoft SQL Server 2012 in no time with help from this thoroughly revised, practical resource. Filled with real-world examples and hands-on exercises, Microsoft SQL Server 2012: A Beginner's Guide, Fifth Edition starts by explaining fundamental relational database system concepts. Then, you'll learn how to write Transact-SQL statements, execute simple and complex database queries, handle system administration and security, and use the powerful analysis, business intelligence, and reporting tools. XML, spatial data, and full-text search are also covered in this step-by-step tutorial. Install, configure, and customize SQL Server 2012 Create and modify database objects with Transact SQL statements Write stored procedures and user-defined functions Handle backup and recovery Automate administrative tasks Tune your database system for optimal performance, availability, and reliability Implement security measures using authentication, encryption, and authorization Work with SQL Server Analysis Services, SQL Server Reporting Services, and other business intelligence tools Store, display, and query XML documents Manage spatial data Query documents using MS Full-Text Search (FTS)

Microsoft SQL Server 2012 Unleashed


Author: Ray Rankins,Paul Bertucci,Chris Gallelli,Alex T. Silverstein
Publisher: Sams Publishing
ISBN: 0133408515
Category: Computers
Page: 1872
View: 6457
DOWNLOAD NOW »
Buy the print version of¿ Microsoft SQL Server 2012 Unleashed and get the eBook version for free! eBook version includes chapters 44-60 not included in the print. See inside the book for access code and details. ¿ With up-to-the-minute content, this is the industry’s most complete, useful guide to SQL Server 2012. ¿ You’ll find start-to-finish coverage of SQL Server’s core database server and management capabilities: all the real-world information, tips, guidelines, and samples you’ll need to create and manage complex database solutions. The additional online chapters add extensive coverage of SQL Server Integration Services, Reporting Services, Analysis Services, T-SQL programming, .NET Framework integration, and much more. ¿ Authored by four expert SQL Server administrators, designers, developers, architects, and consultants, this book reflects immense experience with SQL Server in production environments. Intended for intermediate-to-advanced-level SQL Server professionals, it focuses on the product’s most complex and powerful capabilities, and its newest tools and features. Understand SQL Server 2012’s newest features, licensing changes, and capabilities of each edition Manage SQL Server 2012 more effectively with SQL Server Management Studio, the SQLCMD command-line query tool, and Powershell Use Policy-Based Management to centrally configure and operate SQL Server Utilize the new Extended Events trace capabilities within SSMS Maximize performance by optimizing design, queries, analysis, and workload management Implement new best practices for SQL Server high availability Deploy AlwaysOn Availability Groups and Failover Cluster Instances to achieve enterprise-class availability and disaster recovery Leverage new business intelligence improvements, including Master Data Services, Data Quality Services and Parallel Data Warehouse Deliver better full-text search with SQL Server 2012’s new Semantic Search Improve reporting with new SQL Server 2012 Reporting Services features Download the following from informit.com/title/9780672336928: Sample databases and code examples ¿ ¿

Professional Microsoft SQL Server 2008 Administration


Author: Brian Knight,Ketan Patel,Wayne Snyder,Ross LoForte,Steven Wort
Publisher: John Wiley & Sons
ISBN: 0470440376
Category: Computers
Page: 924
View: 1496
DOWNLOAD NOW »
SQL Server 2008 is how-to guide for experienced DBAs. Tutorial-based, this book will get you over the learning curve of how to configure and administer SQL Server 2008. Whether you're an administrator or developer using SQL Server, you can't avoid wearing a DBA hat at some point. The book is loaded with unique tips and workarounds for the most difficult SQL Server admin issues, including managing and monitoring SQL Server, automating administration, security, performance tuning, scaling and replications, clustering, and backup and recovery. A companion website is also available.

MCSA Guide to Microsoft SQL Server 2012 (Exam 70-462)


Author: Faisal Akkawi,Kayed Akkawi,Schofield
Publisher: Cengage Learning
ISBN: 1285821130
Category: Computers
Page: 464
View: 8426
DOWNLOAD NOW »
MCSA GUIDE TO MICROSOFT SQL SERVER 2012 (Exam #70-462) provides a thorough introduction to essential database administration principles and practices to prepare readers for certification and career success. Ideal for formal courses, self-study, or professional reference, this detailed text employs a lab-based approach to help users develop the core knowledge and practical skills they need to master Microsoft SQL Server administration in an enterprise environment and pass Microsoft Certified Solutions Associate Exam 70-462. The text opens with information on the latest version of Microsoft SQL Server, offering step-by-step guidance on selecting an edition and completing initial installation and configuration. Several chapters then explore key topics such as database programming, security, performance tuning, backup and recovery, data integration, and system monitoring. Within each chapter, numerous resources and features reinforce teaching and learning, including learning objectives, summaries of key ideas, hands-on activities, discusssion questions, definitions of important terms, and case studies to provide real-world context. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.