Computers

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: 2114

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 ¿ ¿
Computers

Microsoft SQL Server 2012 Unleashed

Author: Ray Rankins,Paul Bertucci,Chris Gallelli,Alex T. Silverstein,Hilary Cotter

Publisher: Pearson Education

ISBN: 0672336928

Category: Computers

Page: 2711

View: 4035

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 � �
Computers

Microsoft SQL Server 2014 Unleashed

Author: Ray Rankins,Paul Bertucci,Chris Gallelli,Alex T. Silverstein

Publisher: Sams Publishing

ISBN: 0134084454

Category: Computers

Page: 1992

View: 4150

The industry’s most complete, useful, and up-to-date guide to SQL Server 2014. 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 examples you’ll need to install, monitor, maintain, and optimize the most complex database environments. The provided examples and sample code provide plenty of hands-on opportunities to learn more about SQL Server and create your own viable solutions. Four leading SQL Server experts present deep practical insights for administering SQL Server, analyzing and optimizing queries, implementing data warehouses, ensuring high availability, tuning performance, and much more. You will benefit from their behind-the-scenes look into SQL Server, showing what goes on behind the various wizards and GUI-based tools. You’ll learn how to use the underlying SQL commands to fully unlock the power and capabilities of SQL Server. Writing for all intermediate-to-advanced-level SQL Server professionals, the authors draw on immense production experience with SQL Server. Throughout, they focus on successfully applying SQL Server 2014’s most powerful capabilities and its newest tools and features. Detailed information on how to… Understand SQL Server 2014’s new features and each edition’s capabilities and licensing Install, upgrade to, and configure SQL Server 2014 for better performance and easier management Streamline and automate key administration tasks with Smart Admin Leverage powerful new backup/restore options: flexible backup to URL, Managed Backup to Windows Azure, and encrypted backups Strengthen security with new features for enforcing “least privilege” Improve performance with updateable columnstore indexes, Delayed Durability, and other enhancements Execute queries and business logic more efficiently with memoryoptimized tables, buffer pool extension, and natively-compiled stored procedures Control workloads and Disk I/O with the Resource Governor Deploy AlwaysOn Availability Groups and Failover Cluster Instances to achieve enterprise-class availability and disaster recovery Apply new Business Intelligence improvements in Master Data Services, data quality, and Parallel Data Warehouse
Computers

Introducing Microsoft SQL Server 2012

Author: Ross Mistry,Stacia Misner

Publisher: N.A

ISBN: 9780735665156

Category: Computers

Page: 268

View: 6065

Describes the components of SQL Server 2012, covering such topics as security, integration services, data services, reporting services, and PowerPivot.
Computers

Windows Server 2016 Unleashed (includes Content Update Program)

Author: Rand Morimoto,Jeffrey Shapiro,Guy Yardeni,Omar Droubi,Michael Noel,Andrew Abbate,Chris Amaris

Publisher: Sams Publishing

ISBN: 0134583795

Category: Computers

Page: 1584

View: 2802

Book + Content Update Program This is the most comprehensive and realistic guide to Windows Server 2016 planning, design, prototyping, implementation, migration, administration, and support. Extensively updated, it contains unsurpassed independent and objective coverage of Windows Server 2016’s key innovations, from the cloud and containers to security and mobility. Windows Server 2016 Unleashed reflects the authors’ extraordinary experience implementing Windows Server 2016 in large-scale environments since its earliest alpha releases. Microsoft MVP Rand Morimoto and colleagues fully address all aspects of deploying and operating Windows Server 2016, including Active Directory, networking, application services, security, administration, business continuity, virtualization, optimization, and troubleshooting. You’ll find up-to-the-minute coverage of new features ranging from Storage Spaces Direct to Cluster-Aware Updating, and Dynamic Access Control to Nano Server. Valuable for Windows pros at all levels, this book will be indispensable especially for intermediate-to-advanced level professionals seeking expert, in-depth solutions. Every chapter contains tips, tricks, best practices, and lessons learned from actual deployments—practical help for solving real problems. Detailed information on how to: Take full advantage of key Windows Server 2016 innovations Plan, prototype, install, migrate to, and deploy Windows Server 2016 and Server Core Design a modern Windows Server Active Directory, from OUs and infrastructure to Federated Forests and Lightweight Directories Deliver reliable networking services: DNS, WINS, DNSSEC, DHCP, IPv, IPAM, and IIS Systematically harden server-level security Protect data in transit with PKI, certificates, rights management, and IPsec encryption Safely provide appropriate remote and mobile access for your users Efficiently administer, automate, maintain, and document Windows Server production environments Control Windows devices centrally with Group Policies and Policy Management Implement advanced fault tolerance, clustering, and other business continuity features Optimize, tune, and debug Windows Server, and plan for growth Leverage integrated application services, including SharePoint and Hyper-V
Computers

Microsoft System Center 2012 Unleashed

Author: Chris Amaris,Rand Morimoto

Publisher: Sams Publishing

ISBN: 067233612X

Category: Computers

Page: 1011

View: 8037

Presents a guide to the newest version of Microsoft System Center, providing instructions and tips on asset management, security reporting, and data protection within managed environments for data centers and cloud environments.
Computers

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: 1418

Harness the powerful new SQL Server 2012 Microsoft SQL Server 2012 is the most significant update to this product since 2005, and it may change how database administrators and developers perform many aspects of their jobs. If you're a database administrator or developer, Microsoft SQL Server 2012 Bible teaches you everything you need to take full advantage of this major release. This detailed guide not only covers all the new features of SQL Server 2012, it also shows you step by step how to develop top-notch SQL Server databases and new data connections and keep your databases performing at peak. The book is crammed with specific examples, sample code, and a host 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 2012 for database administrators and developers Covers all the software's new features and capabilities, including SQL Azure for cloud computing, enhancements to client connectivity, and new functionality that ensures high-availability of mission-critical applications Explains major new changes to the SQL Server Business Intelligence tools, such as Integration, Reporting, and Analysis Services Demonstrates tasks both graphically and in SQL code to enhance your learning Provides source code from the companion web site, which you can use as a basis for your own projects Explores tips, smart workarounds, and best practices to help you on the job Get thoroughly up to speed on SQL Server 2012 with Microsoft SQL Server 2012 Bible.
Computers

Microsoft SQL Server 2005 Integration Services

Author: Kirk Haselden

Publisher: Sams Publishing

ISBN: 9780768689983

Category: Computers

Page: 888

View: 4930

All medium to large companies have to deal with data being stored in a number of databases, spreadsheets and proprietary applications. Bringing all this data together into one system can be useful to analyzing the business; but can also be quite difficult to do. Integration Services is the next big bet in Microsoft's business intelligence lineup, providing you with true enterprise extract transform and load features (ETL). Microsoft SQL Server 2005 Integration Services concentrates on providing you with real world solutions to real world problems, giving you a head start on various projects. If you are only evaluating Integration Services, you'll be able to focus on the early chapters with the option of drilling down into details in the later chapters where some of the more complex concepts will be discussed in detail. The interesting sidebars peppered throughout the book provide insight into the processes, people and decisions that yielded the final IS product.
Computers

Microsoft SQL Server 2008 Management and Administration

Author: Ross Mistry,Hilary Cotter

Publisher: Pearson Education

ISBN: 9780768688856

Category: Computers

Page: 912

View: 5010

If you need to deploy, manage, or secure Microsoft SQL Server 2008, this is the complete, fast-paced, task-based reference you’ve been searching for. Authored by a world-class expert on SQL Server in the enterprise, this book goes far beyond the basics, taking on the complex tasks that DBAs need to make the most of Microsoft’s flagship database platform. SQL Server MVP, Ross Mistry presents proven techniques for SQL Server 2008 installation, upgrades, backup/restore, data transfer, indexing, high availability, security, and much more. He draws on extensive testing in high-profile production environments to offer step-by-step solutions and powerful tips you won’t find anywhere else. Every chapter begins with a section identifying SQL Server 2008’s most significant new improvements, and concludes with a convenient summary of best practices. Each chapter also outlines the benefits of leveraging Windows Server 2008. Understand how to: Master DBA tips, tricks, and best practices proven in actual enterprise environments Install, upgrade or transition to SQL Server 2008. Harden and Secure an implementation. Encrypt SQL Server from an end-to-end perspective. Implement high availability—and leverage SQL Server 2008’s major improvements to failover clustering and database mirroring Save time with SQL Server 2008’s new policy-based management tools Performance tune and troubleshoot a SQL Server 2008 environment. Optimize application performance and manage workloads with the powerful new Resource Governor Implement Performance Studio, maintenance plans, Transparent Data Encryption and much more… Bonus Content: The book is based on Windows Server 2008 Step by step instructions of how to implement a failover cluster on Windows Server 2008 SQL Server PoweShell Administration Tasks Consolidate and virtualize SQL Server with Hyper-V Step by step instructions on how to install Hyper-V Proactively Monitor SQL Server with Operations Manager Install Windows Server 2008 certificates to encrypt SQL Server data Contributing Writers include: Hilary Cotter – SQL Server MVP John Welch – SQL Server MVP Marco Shaw – PowerShell MVP Maciej Pilecki – SQL Server MVP Shirmattie Seenarine – Technical Writer
Computers

Windows Server 2012 Unleashed

Author: Rand Morimoto,Michael Noel,Guy Yardeni,Omar Droubi,Andrew Abbate,Chris Amaris

Publisher: Sams Publishing

ISBN: 9780672336225

Category: Computers

Page: 1656

View: 7120

This is the most comprehensive and realistic guide to Windows Server 2012 planning, design, prototyping, implementation, migration, administration, and support. Extensively updated, it contains unsurpassed independent and objective coverage of Windows Server 2012’s key innovations, including improved virtualization components, enhanced security tools, new web and management resources, and Windows 8 integration. Windows Server 2012 Unleashed reflects the authors’ extraordinary experience implementing Windows Server 2012 in large-scale environments since its earliest alpha releases, reaching back more than two years prior to its official launch. Microsoft MVP Rand Morimoto and his colleagues fully address every aspect of deploying and operating Windows Server 2012, including Active Directory, networking and core application services, security, migration from Windows Server 2003/2008, administration, fault tolerance, optimization, troubleshooting, and much more. Valuable for Windows professionals at all skill levels, this book will be especially indispensable for intermediate-to-advanced level professionals seeking expert, in-depth solutions. Every chapter contains tips, tricks, best practices, and lessons learned from actual deployments: practical information for using Windows Server 2012 to solve real business problems. Plan and migrate from Windows Server 2003 and 2008 Leverage powerful capabilities that are truly new in Windows Server 2012 Install Windows Server 2012 and the GUI-less Windows Server Core Upgrade to Windows Server 2012 Active Directory Utilize advanced AD capabilities including federated forests and identity management Plan and deploy network services, from DNS and DHCP to IPv6, IPAM, and IIS Protect systems and data with server-level security, transport-level security, and security policies Deliver true end-to-end secured anytime/anywhere access to remote/mobile clients Efficiently configure and manage users, sites, OUs, domains, and for­ests through Server Manager console Create more fault-tolerant environ­ments with DFS, clustering, and Network Load Balancing Leverage major Hyper-V virtualization improvements in availability, redun­dancy, and guest support Manage Active Directory more efficiently with Active Directory Administrative Center, Best Practice Analyzer, and PowerShell scripts Systematically tune, optimize, debug, and troubleshoot Windows Server 2012
Computers

Microsoft SQL Server 2008 R2 Unleashed

Author: Ray Rankins,Paul Bertucci,Chris Gallelli,Alex T. Silverstein

Publisher: Pearson Education

ISBN: 9780768696547

Category: Computers

Page: 1704

View: 1101

This is the industry’s most comprehensive and useful guide to SQL Server 2008 and 2008 R2. It presents start-to-finish coverage of SQL Server’s core database server and management capabilities, plus complete introductions to Integration, Reporting, and Analysis Services, application development, and much more. Four expert SQL Server administrators, developers, and consultants have packed this book with real-world information, tips, guidelines, and samples drawn from their own extensive experience creating and managing complex database solutions. Writing for intermediate-to-advanced-level SQL Server professionals, they focus on the product’s most complex and powerful capabilities, and its newest tools and features. For example, you’ll find invaluable information on administering SQL Server more efficiently, analyzing and optimizing queries, implementing data warehouses, ensuring high availability, and tuning performance. The accompanying CD-ROM contains an extraordinary library of practical tools and information including sample databases and all code examples. Whether you’re responsible for SQL Server 2008 analysis, design, implementation, support, administration, or troubleshooting, no other book offers you this much value. Understand the Microsoft SQL Server 2008 environment, R2’s newest features, and each edition’s capabilities Manage SQL Server 2008 more effectively with SQL Server Management Studio, the SQLCMD command-line query tool, and Powershell Efficiently manage security, users, backup/restore, replication, Database Mail, and database objects—from tables and indexes to stored procedures and triggers Increase availability with clustering, database mirroring, and other features Use new Policy-Based Management to centrally configure and operate SQL Server throughout the organization Use SQL Server Profiler to capture queries and identify bottlenecks Improve performance by optimizing queries, design more effective databases, and manage workloads with the new Resource Governor Develop applications using SQL Server 2008’s enhancements to T-SQL and SQLCLR, .NET integration, LINQ to SQL, XML, and XQuery Make the most of Analysis Services, Integration Services, and Reporting Services—especially Microsoft’s new R2 reporting improvements Improve data security using Column-level and Transparent Data Encryption CD-ROM includes: 15 additional chapters Code samples, scripts, and databases utilized within the book Free version of SQL Shot (performance & tuning software)
Computers

Microsoft SQL Server 2008 Reporting Services Unleashed

Author: Michael Lisin,Jim Joseph,Amit Goyal

Publisher: Sams Publishing

ISBN: 9780672330261

Category: Computers

Page: 661

View: 4279

Provides details on creating, managing, and delivering reports using Microsoft SQL Server 2008 Reporting Services.
Computers

SQL Server 2016 High Availability Unleashed (includes Content Update Program)

Author: Paul Bertucci

Publisher: Sams Publishing

ISBN: 0134467574

Category: Computers

Page: 432

View: 9864

Book + Content Update Program SQL Server 2016 High Availability Unleashed provides start-to-finish coverage of SQL Server’s powerful high availability (HA) solutions for your traditional on-premise databases, cloud-based databases (Azure or AWS), hybrid databases (on-premise coupled with the cloud), and your emerging Big Data solutions. This complete guide introduces an easy-to-follow, formal HA methodology that has been refined over the past several years and helps you identity the right HA solution for your needs. There is also additional coverage of both disaster recovery and business continuity architectures and considerations. You are provided with step-by-step guides, examples, and sample code to help you set up, manage, and administer these highly available solutions. All examples are based on existing production deployments at major Fortune 500 companies around the globe. This book is for all intermediate-to-advanced SQL Server and Big Data professionals, but is also organized so that the first few chapters are great foundation reading for CIOs, CTOs, and even some tech-savvy CFOs. Learn a formal, high availability methodology for understanding and selecting the right HA solution for your needs Deep dive into Microsoft Cluster Services Use selective data replication topologies Explore thorough details on AlwaysOn and availability groups Learn about HA options with log shipping and database mirroring/ snapshots Get details on Microsoft Azure for Big Data and Azure SQL Explore business continuity and disaster recovery Learn about on-premise, cloud, and hybrid deployments Provide all types of database needs, including online transaction processing, data warehouse and business intelligence, and Big Data Explore the future of HA and disaster recovery In addition, this book is part of InformIT’s exciting Content Update Program, which provides content updates for major technology improvements! As significant updates are made to SQL Server, sections of this book will be updated or new sections will be added to match the updates to the technologies. As updates become available, they will be delivered to you via a free Web Edition of this book, which can be accessed with any Internet connection. To learn more, visit informit.com/cup. How to access the Web Edition: Follow the instructions inside to learn how to register your book to access the FREE Web Edition.
Computers

SQL Server 2012 T-SQL Programming Unleashed

Author: David Solomon

Publisher: Sams Publishing

ISBN: 9780672336201

Category: Computers

Page: 850

View: 6047

In SQL Server 2012 T-SQL Programming Unleashed, leading SQL Server consultant David Solomon shows database programmers how to take full advantage of it. This comprehensive how-to guide integrates exceptionally useful examples with detailed discussions of the underlying database behavior they illustrate. It provides self-contained modular coverage of each topic for rapid reference, and is organized intelligently to help readers build their knowledge incrementally as they proceed through the book. Solomon illuminates both the fundamental characteristics of T-SQL processing and the relationship between T-SQL code style and performance. Coverage includes: * T-SQL basics: how T-SQL and SQL Server interact * Data manipulation: database objects, DML, selection, complex queries, data modification, loading, and merge * Batch programming: transactions, logging, locking, temporary storage, Dynamic SQL, server-side cursors, and error handling * Creating SQL programming objects: views, stored procedures, UDFs, and triggers * Using CLR to integrate non-SQL programs * And much more
Computers

System Center 2012 Operations Manager Unleashed

Author: Kerrie Meyler,Cameron Fuller,John Joyner

Publisher: Sams Publishing

ISBN: 0132953854

Category: Computers

Page: 1536

View: 4152

This is the first comprehensive Operations Manager 2012 technical resource for every IT implementer and administrator. Building on their bestselling OpsMgr 2007 book, three Microsoft System Center Cloud and Data Center Management MVPs thoroughly illuminate major improvements in Microsoft’s newest version–including new enhancements just added in Service Pack 1. You’ll find all the information you need to efficiently manage cloud and datacenter applications and services in even the most complex environment. The authors provide up-to-date best practices for planning, installation, migration, configuration, administration, security, compliance, dashboards, forecasting, backup/recovery, management packs, monitoring including .NET monitoring, PowerShell automation, and much more. Drawing on decades of enterprise and service provider experience, they also offer indispensable insights for integrating with your existing Microsoft and third-party infrastructure. Detailed information on how to… Plan and execute a smooth OpsMgr 2012 deployment or migration Move toward application-centered management in complex environments Secure OpsMgr 2012, and assure compliance through Audit Collection Services Implement dashboards, identify trends, and improve forecasting Maintain and protect each of your OpsMgr 2012 databases Monitor virtually any application, environment, or device: client-based, .NET, distributed, networked, agentless, or agent-managed Use synthetic transactions to monitor application performance and responsiveness Install UNIX/Linux cross-platform agents Integrate OpsMgr into virtualized environments Manage and author management packs and reports Automate key tasks with PowerShell, agents, and alerts Create scalable management clouds for service provider/multi-tenant environments Use OpsMgr 2012 Service Pack 1 with Windows Server 2012 and SQL Server 2012
Computers

Knight's Microsoft SQL Server 2012 Integration Services 24-Hour Trainer

Author: Brian Knight,Devin Knight,Mike Davis,Wayne Snyder

Publisher: John Wiley & Sons

ISBN: 1118539141

Category: Computers

Page: 528

View: 6183

Book-and-video package gets novices up to speed on Microsoft SQL Server 2012 If you need a practical, hands-on introduction, especially to SQL Server Integration Services (SSIS), this book-and-video package from authority Brian Knight is the perfect solution. Each lesson includes three major components: a description of how each SSIS feature or process works, a tutorial that walks you through the process or technique, and an accompanying video lesson. It's a complete learning package that will give you the confidence you need to start your first SSIS project. Guides novice database administrators and developers who are learning Microsoft SQL Server 2012 and SQL Server Integration Services (SSIS) Provides expert instruction from leading SQL Server authority and author, Brian Knight Includes a book and a video, complete instruction that includes lessons, hands-on tutorials, and video demonstrations by the author Covers the very latest changes and updates in the SQL Server 2012 release Microsoft SQL Server 2012 Integration Services 24-Hour Trainer makes SQL Server 2012 and SSIS much less intimidating. Note: CD-ROM/DVD and other supplementary materials are not included as part of the e-book file, but are available for download after purchase.
Computers

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

Author: Faisal Akkawi,Kayed Akkawi,Gabriel J. Schofield

Publisher: Cengage Learning

ISBN: 1285821130

Category: Computers

Page: 464

View: 5696

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.
Computers

Microsoft SQL Server 2008 Internals

Author: Kalen Delaney,Adam Machanic,Paul S. Randal,Kimberly L. Tripp,Conor Cunningham,Ben Nevarez

Publisher: Microsoft Press

ISBN: 0735638225

Category: Computers

Page: 784

View: 8830

Delve inside the core SQL Server engine—and put that knowledge to work—with guidance from a team of well-known internals experts. Whether database developer, architect, or administrator, you’ll gain the deep knowledge you need to exploit key architectural changes—and capture the product’s full potential. Discover how SQL Server works behind the scenes, including: What happens internally when SQL Server builds, expands, shrinks, and moves databases How to use event tracking—from triggers to the Extended Events Engine Why the right indexes can drastically reduce your query execution time How to transcend normal row-size limits with new storage capabilities How the Query Optimizer operates Multiple techniques for troubleshooting problematic query plans When to force SQL Server to reuse a cached query plan—or create a new one What SQL Server checks internally when running DBCC How to choose among five isolation levels and two concurrency models when working with multiple concurrent users
Computers

Introducing Microsoft SQL Server 2014

Author: Ross Mistry,Stacia Misner

Publisher: Microsoft Press

ISBN: 0133966178

Category: Computers

Page: 144

View: 7504

NOTE: This title is also available as a free eBook on the Microsoft Download Center. It is offered for sale in print format as a convenience. Get a head start evaluating SQL Server 2014 - guided by two experts who have worked with the technology from the earliest beta. Based on Community Technology Preview 2 (CTP2) software, this guide introduces new features and capabilities, with practical insights on how SQL Server 2014 can meet the needs of your business. Get the early, high-level overview you need to begin preparing your deployment now. Coverage includes: SQL Server 2014 Editions and engine enhancements Mission-critical performance enhancements Hybrid cloud enhancements Self-service Business Intelligence enhancements in Microsoft Excel Enterprise information management enhancements Big Data solutions
Computers

Microsoft BizTalk Server 2010 Unleashed

Author: Brian Loesgen,Charles Young,Jan Eliasen,Scott Colestock,Anush Kumar,Jon Flanders

Publisher: Sams Publishing

ISBN: 0672331187

Category: Computers

Page: 840

View: 836

The most complete, practical guide to BizTalk Server 2009: an all-new book focused on delivering real, start-to-finish enterprise solutions • •Pragmatic coverage of every crucial step of BizTalk development: architecture, design, infrastructure, deployment, lifecycle management, and more. •Fully up to date with the R2 release of BizTalk Server 2009. •Not a revision of previous BizTalk Server Unleashed books, but completely rewritten from the ground up. Microsoft BizTalk Server 2009 Unleashed is the definitive, pragmatic guide toMicrosoft BizTalk Server Microsoft's latest and most powerful version of BizTalk Server. In this book, a team of world-class BizTalk Server 2009 experts bring together the deep practical insights .NET developers need to solve real business problems with BizTalk Server 2009 in any enterprise environment. Drawing on their immense BizTalk experience, the authors present best practices for the entire development lifecycle, from planning and architecture through deployment, and beyond. Writing at just the right level of technical detail for experienced .NET developers now starting out with BizTalk, they cover these and many other crucial issues: • •Architecting and designing effective, high-value BizTalk solutions. •Working with BizTalk schemas, maps, orchestrations, pipelines, pipeline components, and adapters. •Implementing business rules with the Microsoft Business Rules Framework. •Creating highly-available, high-performance BizTalk environments. •Monitoring business activity. •Collaborating effectively among BizTalk developers and users. •Using BizTalk's leading-edge RFID capabilities Note: This is a 100% new book, NOT an update to 2004 Unleashed