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

DOWNLOAD NOW »

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)

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

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

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

DOWNLOAD NOW »

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

Microsoft SQL Server 2008 Reporting Services Unleashed

Author: Michael Lisin,Jim Joseph,Amit Goyal

Publisher: Sams Publishing

ISBN: 0768689163

Category: Computers

Page: 696

View: 9923

DOWNLOAD NOW »

Microsoft® SQL Server™ 2008 Reporting Services Unleashed Michael Lisin Jim Joseph Amit Goyal The authoritative, example-rich guide to Microsoft’s powerful reporting platform With Microsoft SQL Server 2008 Reporting Services you can quickly deliver relevant business intelligence data wherever it’s needed–across the entire enterprise, and through the entire reporting lifecycle. SQL Server 2008 Reporting Services Unleashed gives you all the authoritative information you’ll need to make the most of Microsoft’s most powerful reporting platform as a database professional, manager, or user. In-depth coverage makes this book an ideal reference, and its extensive set of practical examples help you address virtually any challenge in deployment, configuration, administration, or report building. The authors have extensively expanded this edition with deeper reference information, many more practical examples, and insider perspective into Reporting Services 2008’s powerful new enhancements. You’ll discover how to take full advantage of Reporting Services’ significant architectural changes, its flexible new Tablix control, improved visualization through charts and gauges, deep SharePoint integration through SharePoint Integrated Mode, new output presentation formats, and much more. Understand how to Learn about the new features of Service Pack 1 (SP1) and the SQL Server 2008 R2 release Quickly take advantage of Microsoft’s newest SQL Server Reporting Services enhancements Use Reporting Services to identify trends and solve real business problems Master report authoring–from basic, wizard-driven techniques to the cutting edge Group, sort, and aggregate data, and define the right scope for your information Utilize advanced report formatting techniques Work effectively with multidimensional sources Manage report data sources and models Secure reports against attacks and intrusions Customize Reporting Services with embedded functions, custom assemblies, URL access, Web Services, and other extensions Thoroughly integrate SQL Server reporting into any SharePoint site Michael Lisin, lead author of Microsoft SQL Server 2005 Reporting Services, has years of field experience working with SQL Server Reporting Services at Microsoft and delivering solutions for Microsoft’s enterprise customers. Jim Joseph, co-author of Microsoft SQL Server 2005 Reporting Services Unleashed, is an independent contractor with 10 years experience developing custom software solutions in a variety of industries. He has worked with SQL Server Reporting Services since the first beta release. Amit Goyal, lead program manager for Microsoft’s Reporting Services team, has extensive insider’s knowledge of SQL Server 2008 Reporting Services. ON THE WEB: Download all examples and source code presented in this book from informit.com/sams Category: Microsoft Databases Covers: Microsoft SQL Server 2008 Reporting Services User Level: Intermediate—Advanced

Windows Server 2008 R2 Unleashed

Author: Rand Morimoto

Publisher: Sams Publishing

ISBN: 9780672330926

Category: Computers

Page: 1653

View: 1741

DOWNLOAD NOW »

The most comprehensive and realistic guide to planning, design, prototyping, implementation, migration, administration, and support, this title addresses major Windows Server 2008 R2 enhancements.

System Center Service Manager 2010 Unleashed

Author: Kerrie Meyler,Alexandre Verkinderen,Anders Bengtsson,Patrik Sundqvist,David Pultorak

Publisher: Sams Publishing

ISBN: 0132701138

Category: Computers

Page: 768

View: 2710

DOWNLOAD NOW »

System Center Service Manager 2010 offers enterprises a complete, integrated platform for adopting and automating service management best practices, such as those found in ITIL and Microsoft Operations Framework (MOF). Now, there’s a comprehensive, independent reference and technical guide to this powerful product. A team of expert authors offers step-by-step coverage of related topics in every feature area, organized to help IT professionals quickly plan, design, implement, and use Service Manager 2010. After introducing the product and its relationship with the rest of Microsoft’s System Center suite, the authors present authoritative coverage of Service Manager’s capabilities for incident and problem resolution, change control, configuration management, and compliance. Readers will also find expert guidance for integrating Service Manager with related Microsoft technologies. This book is an indispensable resource for every IT professional planning, installing, deploying, and/or administering Service Manager, including ITIL, MOF, and other IT consultants; system administrators; and developers creating customized solutions. • Understand Service Manager’s architecture and components • Discover how Service Manager supports ITIL and MOF processes • Accurately scope and specify your implementation to reflect organizational needs • Plan to provide redundancy, ensure scalability, and support virtualization • Design, deploy, and maintain Service Manager with security in mind • Use Service Manager’s consoles and portals to provide the right resources to each user • Create complete service maps with Service Manager’s business services • Fully automate incident management and ticketing • Implement best processes for identifying and addressing root causes of problems • Systematically manage the life cycle of changes • Use Service Manager to strengthen governance, risk management, and compliance • Customize Service Manager’s data layer, workflows, and presentation layer • Use management packs to simplify service desk customization • Make the most of Service Manager’s reporting and dashboards

System Center Opalis Integration Server 6.3 Unleashed

Author: Charles Joy,Mark Gosson,Kerrie Meyler,Pete Zerger

Publisher: Sams Publishing

ISBN: 0672335611

Category: Computers

Page: 529

View: 4228

DOWNLOAD NOW »

The comprehensive reference and technical guide to implementing, integrating and using Microsoft System Center Opalis Integration Server 6.3 • •Covers everything IT professionals need to know about Opalis architecture, installation, policy, foundation objects, the SDK, and much more •Includes extensive practical guidance on orchestrating with System Center and third party products through integration packs. •By an expert team that includes the leaders of many of the world's largest Opalis implementations. Using Microsoft's new Opalis IT process automation software, IT organizations can dramatically reduce operational costs and improve efficiency by replacing resource-intensive, error-prone manual activities with standardized, automated processes. Microsoft doesn't sell Opalis as a separately licensed product: thousands of customers who've licensed Microsoft System Center with SMSE/D already have the rights to use it. They simply have to learn how. System Center Opalis Integration Server 6.3 Unleashed will help them do so. This book's expert author team offers start-to-finish, step-by-step coverage of implementing key Opalis 6.3 features for maximum business value. Drawing on their extensive experience, they bring together coverage of related topics and techniques in ways that enable IT professionals to deploy Opalis more quickly and apply it more successfully. The authors begin with a high-level overview of Opalis 6.3 and the potential value it offers to IT organizations. Next, it guides readers through architecture, installation, policy basics and design, foundation objects and integration packs, the SDK, and best practices based on real-world implementations.

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

DOWNLOAD NOW »

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 In addition, this book is part of InformIT’s Content Update Program, which provides content updates for major technology improvements! As significant updates are made to WIndows Server 2016, 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 in the book to learn how to register your book to access the FREE Web Edition.

Microsoft System Center Enterprise Suite Unleashed

Author: Chris Amaris,Tyson Kopczynski,Alec Minty,Rand Morimoto

Publisher: Sams Publishing

ISBN: 0131387987

Category: Computers

Page: 1056

View: 5929

DOWNLOAD NOW »

Microsoft System Center Enterprise Suite Unleashed is the first and only definitive real-world guide to the entire Microsoft System Center Enterprise Suite. It brings together tips, tricks, best practices, and lessons learned by top consultants who’ve deployed System Center in some of the world’s largest enterprises and most successful small businesses. Drawing on years of early adopter and production experience, Rand Morimoto, Chris Amaris, and their team cover the entire System Center lifecycle and its components for system configuration, operations management, data protection, virtual machine management, help desk support, change management, asset control, capacity planning, and mobile device management. You’ll learn about individual components and how to integrate them to build automated, exceptionally efficient managed environments. For smaller businesses, the book also presents Microsoft’s streamlined, lower-cost IT management offering, System Center Essentials 2010. Use System Center Configuration Manager 2007 to image, update, manage, and support servers and clients Proactively monitor your systems to identify and fix problems before they fail Use System Center Data Protection Manager 2010 to provide reliable, timely backup/recovery Implement and manage all aspects of virtualization, including virtual guest sessions on both Microsoft Hyper-V and VMware Make the most of System Center Service Manager 2010’s integrated tools for managing help desks, incidents, assets, and changes Use System Center Capacity Planner to properly size, procure, and deploy new systems Remotely track, secure, patch, update, and support mobile devices with System Center Mobile Device Manager Simplify small business IT management with System Center Essentials 2010’s wizards and auto-configuration components

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

Author: Paul Bertucci

Publisher: Sams Publishing

ISBN: 0134467574

Category: Computers

Page: 432

View: 1029

DOWNLOAD NOW »

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.