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

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)

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

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

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

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

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

Introducing Microsoft® SQL Server® 2012

Author: Ross Mistry,Stacia Misner

Publisher: "O'Reilly Media, Inc."

ISBN: 0735671419

Category: Computers

Page: 290

View: 4052

Introducing Microsoft® SQL Server® 2012 explores the exciting enhancements and new capabilities engineered into SQL Server, ranging from improvements in operation to those in reporting and management. This book is for anyone who has an interest in SQL Server 2012 and wants to understand its capabilities, including database administrators, application developers, and technical decision makers.

Microsoft SQL Server 2008 Reporting Services Unleashed

Author: Michael Lisin,Jim Joseph,Amit Goyal

Publisher: Sams Publishing

ISBN: 9780672330261

Category: Computers

Page: 661

View: 1110

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

Microsoft SQL Server 2008 Step by Step

Author: Mike Hotek

Publisher: Pearson Education

ISBN: 0735637989

Category: Computers

Page: 544

View: 4867

Teach yourself SQL Server 2008—one step at a time. Get the practical guidance you need to build database solutions that solve real-world business problems. Learn to integrate SQL Server data in your applications, write queries, develop reports, and employ powerful business intelligence systems. Discover how to: Install and work with core components and tools Create tables and index structures Manipulate and retrieve data Secure, manage, back up, and recover databases Apply tuning plus optimization techniques to generate high-performing database applications Optimize availability through clustering, database mirroring, and log shipping Tap business intelligence tools—Reporting, Analysis, and Integration Services CD features: Practice exercises and code samples Fully searchable eBook For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.

Microsoft System Center 2012 Unleashed

Author: Chris Amaris,Rand Morimoto

Publisher: Sams Publishing

ISBN: 067233612X

Category: Computers

Page: 1011

View: 8975

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.

Microsoft Lync Server 2013

Author: Alex Lewis,Tom Pacyk,David Ross,Randy Wintle

Publisher: Pearson Education

ISBN: 0672336154

Category: Computers

Page: 933

View: 567

The most comprehensive, realistic, and useful guide to Microsoft Lync Server 2013, today's leading Unified Communications system. Four expert Lync consultants and implementers bring together in-the-trenches guidance for all facets of planning, integration, deployment, and administration. The authors introduce Microsoft Lync Server 2013, outline what it can do, and review the key improvements Microsoft has made in this version. They cover every form of communication Lync Server can manage, including IP voice, instant messaging, audio/video conferencing, web conferencing, and more. You'll find expert guidance on planning infrastructure, managing day-to-day operations, server roles, multi-platform clients, security, troubleshooting, and much more. Microsoft Lync Server 2013 Unleashed contains a new section on Office 365 and Lync Online, a chapter covering coexistence between on-premise and Office 365 Lync deployments, and another introducing Lync online configuration and administration. Throughout, the authors combine theory, step-by-step configuration instructions, and best practices from real enterprise environments. They identify common mistakes and present proven solutions and workarounds. Simply put, they tell you what works--and show how it's done. Detailed information on how to… • Plan for any type of deployment, from simple to highly complex--including virtualized environments • Walk step-by-step through installation, and understand important new changes in the installation process • Overcome obstacles to successful migration from older versions of Lync or Microsoft Office Communications Server • Manage server roles, including Front End, Edge, Monitoring, Archiving, and Director roles • Efficiently administer Lync Server 2013 through the Lync Server Management Shell • Leverage Lync Server 2013's significantly improved capabilities as a PBX replacement and videoconferencing solution • Integrate Lync with third-party video platforms, voice/video gateways, and cloud services • Evaluate the option of providing Lync services through Microsoft Office 365 hosting • Make the most of Lync Server 2013's dramatically upgraded web, mobile, and desktop clients

Microsoft System Center Enterprise Suite Unleashed

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

Publisher: Sams Publishing

ISBN: 9780672333194

Category: Computers

Page: 1035

View: 1922

Provides users with the information they need to leverage all of the capabilities provided in the System Center suite. • •Written by System Center experts who have implemented the entire suite of products in some of the largest enterprises in the world. •Packed with tips, tricks, shortcuts, and examples. •Only book that covers the entire System Center Suite and the interoperability of the products as a unified strategy for Microsoft systems management. Microsoft System Center Enterprise Suite Unleashed is written by System Center experts who have implemented the entire suite of products in some of the largest enterprises in the world to some of the smallest and most automated and efficient small business IT operations around. When planned, designed, and implemented properly, System Center automates tasks that help organizations improve IT efficiencies, improve proactive systems management, and decreases overall costs of operations. It will cover the planning, design, implementation, integration, administration, and best practice support of the entire System Center suite. Being a 'suite' book, each chapter will not only cover the components within the product, but how the product links and integrates with the other System Center products to produce a highly efficient managed environment.

Professional Microsoft SQL Server 2008 Integration Services

Author: Brian Knight,Erik Veerman,Grant Dickinson,Douglas Hinson,Darren Herbold

Publisher: John Wiley & Sons

ISBN: 9781118059562

Category: Computers

Page: 1008

View: 7929

The new edition of the successful previous version is 25 percent revised and packed with more than 200 pages of new material on the 2008 release of SQL Server Integration Services (SSIS) Renowned author Brian Knight and his expert coauthors show developers how to master the 2008 release of SSIS, which is both more powerful and more complex than ever Case studies and tutorial examples acquired over the three years since the previous edition will contribute to helping illustrate advanced concepts and techniques New chapters include coverage of data warehousing using SSIS, new methods for managing the SSIS platform, and improved techniques for ETL operations

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

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.

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

Author: Paul Bertucci

Publisher: Sams Publishing

ISBN: 0134467574

Category: Computers

Page: 432

View: 5943

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.

Microsoft SQL Server 2008 For Dummies

Author: Mike Chapple

Publisher: John Wiley & Sons

ISBN: 9780470486658

Category: Computers

Page: 408

View: 3874

If you’re a database administrator, you know Microsoft SQL Server 2008 is revolutionizing database development. Get up to speed on SQL Server 2008, impress your boss, and improve your company’s data management — read Microsoft SQL Server 2008 For Dummies! SQL Server 2008 lets you build powerful databases and create database queries that give your organization the information it needs to excel. Microsoft SQL Server 2008 For Dummies helps you build the skills you need to set up, administer, and troubleshoot SQL Server 2008. You’ll be able to: Develop and maintain a SQL Server system Design databases with integrity and efficiency Turn data into information with SQL Server Reporting Services Organize query results, summarizing data with aggregate functions and formatting output Import large quantities of data with SSIS Keep your server running smoothly Protect data from prying eyes Develop and implement a disaster recovery plan Improve performance with database snapshots Automate SQL Server 2008 administration Microsoft SQL Server 2008 For Dummies is a great first step toward becoming a SQL Server 2008 pro!

Microsoft SQL Server 2008 Bible

Author: Paul Nielsen,Uttam Parui

Publisher: John Wiley & Sons

ISBN: 1118079876

Category: Computers

Page: 1680

View: 7708

Harness the power of SQL Server, Microsoft’s high-performance database and data analysis software package, by accesing everything you need to know in Microsoft SQL Server 2008 Bible. Learn the best practices, tips, and tricks from this comprehensive tutorial and reference, which includes specific examples and sample code, with nearly every task demonstrated in both a graphical and SQL code method. Understand how to develop SQL Server databases and data connections, how to administer the SQL Server and keep databases performing optimally, and how to navigate all the new features of the 2008 release.

Delivering Business Intelligence with Microsoft SQL Server 2016, Fourth Edition

Author: Brian Larson

Publisher: McGraw-Hill Education

ISBN: 9781259641480

Category: Computers

Page: 880

View: 843

Distribute Actionable, Timely BI with Microsoft® SQL Server® 2016 and Power BI Drive better, faster, more informed decision making across your organization using the expert tips and best practices featured in this hands-on guide. Delivering Business Intelligence with Microsoft SQL Server 2016, Fourth Edition, shows, step-by-step, how to distribute high-performance, custom analytics to users enterprise-wide. Discover how to build BI Semantic Models, create data marts and OLAP cubes, write MDX and DAX scripts, and share insights using Microsoft client tools. The book includes coverage of self-service business intelligence with Power BI. • Understand the goals and components of successful BI • Build data marts, OLAP cubes, and Tabular models • Load and cleanse data with SQL Server Integration Services • Manipulate and analyze data using MDX and DAX scripts and queries • Work with SQL Server Analysis Services and the BI Semantic Model • Author interactive reports using SQL Server Data Tools • Create KPIs and digital dashboards • Implement time-based analytics • Embed data model content in custom applications using ADOMD.NET • Use Power BI to gather, model, and visualize data in a self-service environment

Microsoft SQL Server 2005 Integration Services

Author: Kirk Haselden

Publisher: Sams Publishing

ISBN: 9780768689983

Category: Computers

Page: 888

View: 9514

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.

WPF 4.5 Unleashed

Author: Adam Nathan

Publisher: Sams Publishing

ISBN: 0133496856

Category: Computers

Page: 864

View: 9067

The #1 WPF Book--Now Updated for WPF 4.5! Thorough, authoritative coverage, practical examples, clear writing, and full-color presentation make this one of the most widely acclaimed programming books of the last decade. Windows Presentation Foundation (WPF) is the recommended technology for creating modern Windows desktop apps. Whether you want to develop traditional user interfaces or integrate 3D graphics, audio/video, animation, dynamic skinning, touch, rich document support, speech recognition, or more, WPF enables you to do so in a seamless, resolution-independent manner that scales from small tablets to large TVs. WPF 4.5 Unleashed is the authoritative book that covers it all, in a practical and approachable fashion, authored by WPF guru and Microsoft architect Adam Nathan. Covers everything you need to know about Extensible Application Markup Language (XAML) Examines the WPF feature areas in incredible depth: controls, layout, resources, data binding, styling, graphics, animation, and more Delves into topics that aren’t covered by most books: 3D, speech, audio/video, documents, effects Shows how to create popular UI elements and leverage built-in controls such as the new Office-style Ribbon Demonstrates how to create sophisticated UI mechanisms, such as Visual Studio-like collapsible/dockable panes Explains how to create first-class custom controls for WPF Demonstrates how to create hybrid WPF software that leverages Windows Forms, DirectX, ActiveX, or other non-WPF technologies Explains how to exploit desktop features, such as Jump Lists and taskbar customizations, and the same toast notifications used by Windows Store apps

Practical SQL Queries for Microsoft SQL Server 2008 R2

Author: Art Tennick

Publisher: McGraw Hill Professional

ISBN: 0071746889

Category: Computers

Page: 512

View: 1460

400+ ready-to-use, powerful SQL queries Learn powerful techniques for surfacing and delivering actionable business intelligence using SQL. Practical SQL Queries for Microsoft SQL Server 2008 R2 contains more than 400 downloadable SQL queries you can use to extract meaningful insights from large amounts of data. The application, syntax, and results of each query are described in detail. The book emphasizes SQL for use in SSMS, but the queries also apply to SSRS, WinForms, WebForms, and many other applications. Enter, maintain, and retrieve database data Search records using the Where clause Sort SQL query results with the Order By clause Create tables and perform joins on tables Perform set operations using Union, Intersect, and Except Group data and produce totals with the Group By clause Manipulate and transform data using built-in functions Create reusable views and user-defined functions Use stored procedures to change SQL dynamically based on conditional factors Create, maintain, and secure database objects with DDL and DCL Deliver SQL query results to end users