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

Author: Paul Bertucci

Publisher: Sams Publishing

ISBN: 0134467574

Category: Computers

Page: 432

View: 1612

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

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

Author: Paul Bertucci

Publisher: Sams Publishing

ISBN: 9780672337765

Category: Computers

Page: 432

View: 6896

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.
Posted in 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: 8819

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
Posted in Computers

Pro SQL Server Always On Availability Groups

Author: Uttam Parui,Vivek Sanil

Publisher: Apress

ISBN: 1484220714

Category: Computers

Page: 313

View: 9536

This book is your field guide to planning, deploying, managing, and troubleshooting Always On Availability Groups. The Always On Availability Groups feature is an enterprise-level solution for high availability and disaster recovery. Always On provides a rich set of options that reduce overhead and resource usage and enable database administrators to implement and manage high availability and disaster recovery solutions far more easily than by implementing the log-shipping and database-mirroring solutions of the past. Pro SQL Server Always On Availability Groups shows how to reduce downtime, maximize application availability, and provide data protection. The goal is always to have your SQL Server databases up and running whenever you need them, rain or shine, disaster or otherwise. With a focus on real-world experiences and war stories, authors Uttam Parui and Vivek Sanil offer you: Tips, tricks, and best practices for architecting and deploying availability groups. The confidence required to manage and monitor availability groups. Techniques to troubleshoot common issues that you may face during and after deploying availability groups in a mission-critical production environment. What You Will Learn Grasp important concepts underlying high-availability and disaster recovery. Plan and deploy Always On Availability Groups in your corporate environment. Manage Availability Groups to ensure constant readiness and high throughput. Monitor Availability Group performance and troubleshoot problems fast. Build on the cloud and make Windows Azure part of your availability solution. Employ proven techniques and best practices as tested and shared by the authors. Audience Pro SQL Server Always On Availability Groups is aimed at SQL Server architects, database administrators, and IT professionals who are tasked with architecting and deploying a high-availability and disaster recovery solution involving Microsoft SQL Server. This book is also for SQL Server support staff who will be managing and supporting existing availability group deployments.
Posted in 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: 5440

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
Posted in Computers

SQL Server AlwaysOn Revealed

Author: Peter A. Carter

Publisher: Apress

ISBN: 1484223977

Category: Computers

Page: 212

View: 5161

Get a fast start to using AlwaysOn, the SQL Server solution to high-availability and disaster recovery. This second edition is newly-updated to cover the 2016 editions of both SQL Server and Windows Server. Also in this edition is all-new content on troubleshooting and metadata. The book provides a solid and accurate understanding of how to implement systems requiring consistent and continuous uptime, as well as how to troubleshoot those systems in order to keep them running an reliable. Begin with an introduction to high-availability and disaster recovery concepts such as Recovery Point Objectives (RPOs), Recovery Time Objectives (RTO), availability levels, and the cost of downtime. Then move into detailed coverage of implementing and configuring the AlwaysOn feature set in order to meet the business objectives set by your organization. SQL Server AlwaysOn Revealed offers real-world advice on how to build and configure the most appropriate topology to meet the high-availability and disaster recovery requirements you are faced with. Content includes strong coverage on implementing clusters, on building AlwaysOn failover clustered instances, and on configuring AlwaysOn Availability Groups. This is a practical and hand-on book to get you started quickly in using one of the most talked-about SQL Server feature sets. Teaches you to build HA and DR solutions using the AlwaysOn feature set Provides real-world advice on configuration and performance considerations Demonstrates administrative techniques for the AlwaysOn feature set What You Will Learn Understand high availability and disaster recovery in SQL Server 2016 Build and configure a Windows Cluster Create and configure an AlwaysOn failover clustered instance Implement AlwaysOn Availability Groups and appropriately configure them Administer AlwaysOn technologies post implementation Troubleshoot and resolve problems with misbehaving systems Who This Book Is For Database administrators interested in growing their knowledge and skills in Microsoft SQL Server’s high-availability and disaster recovery feature set.
Posted in Computers

SQL Server on Linux

Author: Jasmin Azemovic

Publisher: Packt Publishing Ltd

ISBN: 1788294726

Category: Computers

Page: 222

View: 1026

Bring the performance and security of SQL Server to Linux About This Book Design and administer your SQL Server solution on the open source Linux platform Install, configure, and fine-tune your database application for maximum performance An easy-to-follow guide teaching you how to implement various SQL Server CTP 2.x offerings on Linux—from installation to administration Who This Book Is For This book is for the Linux users who want to learn SQL Server on their favorite Linux distributions. It is not important if you are experienced database user or a beginner as we are starting from scratch. However, it is recommended that you have basic knowledge about relational models. More advanced readers can pick the chapters of their interest and study specific topics immediately. Users from Windows platform can also benefit from this book to expand their frontiers and become equally efficient on both platforms. What You Will Learn Install and set up SQL Server CTP 2.x on Linux Create and work with database objects using SQL Server on Linux Configure and administer SQL Server on Linux-based systems Create and restore database back-ups Protect sensitive data using the built-in cryptographic features Optimize query execution using indexes Improve query execution time by more than 10x using in-memory OLTP Track row-versioning using temporal tables In Detail Microsoft's launch of SQL Server on Linux has made SQL Server a truly versatile platform across different operating systems and data-types, both on-premise and on-cloud. This book is your handy guide to setting up and implementing your SQL Server solution on the open source Linux platform. You will start by understanding how SQL Server can be installed on supported and unsupported Linux distributions. Then you will brush up your SQL Server skills by creating and querying database objects and implementing basic administration tasks to support business continuity, including security and performance optimization. This book will also take you beyond the basics and highlight some advanced topics such as in-memory OLTP and temporal tables. By the end of this book, you will be able to recognize and utilize the full potential of setting up an efficient SQL Server database solution in your Linux environment. Style and approach This book follows a step-by-step approach to teach readers the concepts of SQL Server on Linux using the bash command line and SQL programming language trough examples which can easily be adapted and applied in your own solutions.
Posted in Computers

WPF 4.5 Unleashed

Author: Adam Nathan

Publisher: Sams Publishing

ISBN: 0133496856

Category: Computers

Page: 864

View: 5823

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
Posted in 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: 7044

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

SQL Server 2017 Administration Inside Out

Author: William Assaf,Randolph West,Sven Aelterman,Mindy Curnutt

Publisher: Microsoft Press

ISBN: 0135185394

Category: Computers

Page: 704

View: 1055

Conquer SQL Server 2017 administration—from the inside out Dive into SQL Server 2017 administration—and really put your SQL Server DBA expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds—all you need to plan, implement, manage, and secure SQL Server 2017 in any production environment: on-premises, cloud, or hybrid. Four SQL Server experts offer a complete tour of DBA capabilities available in SQL Server 2017 Database Engine, SQL Server Data Tools, SQL Server Management Studio, and via PowerShell. Discover how experts tackle today’s essential tasks—and challenge yourself to new levels of mastery. • Install, customize, and use SQL Server 2017’s key administration and development tools • Manage memory, storage, clustering, virtualization, and other components • Architect and implement database infrastructure, including IaaS, Azure SQL, and hybrid cloud configurations • Provision SQL Server and Azure SQL databases • Secure SQL Server via encryption, row-level security, and data masking • Safeguard Azure SQL databases using platform threat protection, firewalling, and auditing • Establish SQL Server IaaS network security groups and user-defined routes • Administer SQL Server user security and permissions • Efficiently design tables using keys, data types, columns, partitioning, and views • Utilize BLOBs and external, temporal, and memory-optimized tables • Master powerful optimization techniques involving concurrency, indexing, parallelism, and execution plans • Plan, deploy, and perform disaster recovery in traditional, cloud, and hybrid environments For Experienced SQL Server Administrators and Other Database Professionals • Your role: Intermediate-to-advanced level SQL Server database administrator, architect, developer, or performance tuning expert • Prerequisites: Basic understanding of database administration procedures
Posted in Computers

System Center 2012 Orchestrator Unleashed

Author: Kerrie Meyler,Pete Zerger,Marcus Oh,Anders Bengtsson,Kurt Van Hoecke

Publisher: Sams Publishing

ISBN: 0133057216

Category: Computers

Page: 768

View: 6400

Using System Center 2012 Orchestrator, you can capture and document processes across your entire IT organization, establishing the automation you need to deliver advanced cloud services and self-adjusting computing resources. Authored by five leading System Center experts, this comprehensive reference and technical guide brings together all the knowledge you’ll need to architect, install, implement, integrate, and maximize the value of your own Orchestrator solutions. The authors introduce current best practices based on large-scale enterprise implementations they’ve personally led or participated in. This up-to-date guide shows how to apply Orchestrator’s major improvements to implement IT process automation in any environment, including private clouds. You’ll start with context: what Orchestrator does, how it has evolved, how it works, and essential architecture and design techniques. Next, the authors help you make crucial up-front decisions about activities, runbooks, security, and administration. Finally, you’ll find expert guidance for integrating Orchestrator with the rest of System Center and with Windows Azure cloud services—including advanced automated workflows that encompass both data center and cloud. Detailed information on how to… • Understand System Center 2012 Orchestrator’s capabilities, evolution, architecture, and design, including SP1 improvements and R2 • Successfully install System Center 2012 Orchestrator and migrate smoothly from Opalis Integration Server 6.3 • Take full advantage of Orchestrator’s advanced new runbook automation capabilities • Configure activities associated with runbook control, systems, scheduling, monitoring, files, email, notification, and data handling • Design runbooks for fault tolerance and optimal performance • Enforce strong security using roles, permissions, and auditing • Deliver integration capabilities for Operations Manager, Service Manager, Configuration Manager, Virtual Machine Manager, and Data Protection Manager • Automate end-to-end data center/ cloud workflows with integration packs and PowerShell • Create your own integration packs with Orchestrator Integration Toolkit (OIT.SDK) • Support Orchestrator 2012, troubleshoot problems, and discover the best web and third-party resources
Posted in Computers

Skype for Business Unleashed

Author: Alex Lewis,Pat Richard,Phil Sharp,Rui Young Maximo

Publisher: Sams Publishing

ISBN: 0134289269

Category: Computers

Page: 1088

View: 6556

Skype for Business Unleashed This is the most comprehensive, realistic, and useful guide to Skype for Business Server 2015, Microsoft’s most powerful unified communications system. Four leading Microsoft unified communications consultants share in-the-trenches guidance for planning, integration, migration, deployment, administration, and more. The authors thoroughly introduce Skype for Business 2015’s components and capabilities, as well as changes and improvements associated with the integration of popular Skype consumer technologies. You’ll find detailed coverage of IP voice, instant messaging, conferencing, and collaboration; and expert guidance on server roles, multi-platform clients, security, and troubleshooting. Reflecting their unsurpassed experience, the authors illuminate Microsoft’s new cloud-based and hybrid cloud architectures for unified communications, showing how these impact networking, security, and Active Directory. They cover SDN for unified communications; interoperation with consumer Skype and legacy video conferencing; quality optimization, mobile improvements, and much more. Throughout, the authors combine theory, step-by-step configuration instructions, and best practices from real enterprise environments. Simply put, you’ll learn what works–and how it’s done. Detailed Information on How To · Plan deployments, from simple to highly complex · Deploy Skype for Business Server 2015 as a cloud or cloud-hybrid solution · Walk step by step through installation or an in-place upgrade · Overcome “gotchas” in migrating from Lync Server 2010 or 2013 · Leverage new features available only in cloud or cloud-hybrid environments · Implement and manage Mac, mobile, Windows, browser, and virtualized clients · Establish server roles, including front end, edge, and mediation server · Make the most of Skype for Business Server 2015’s enhanced mobile experience · Manage external dependencies: network requirements, dependent services, and security infrastructure · Efficiently administer Skype for Business Server 2015 · Provide for high availability and disaster recovery · Integrate voice, telephony, and video, step by step · Avoid common mistakes, and discover expert solutions and workarounds Category: Business Applications Covers: Skype for Business User Level: Intermediate—Advanced
Posted in Computers

Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports

Author: Paul Turley

Publisher: John Wiley & Sons

ISBN: 1119258367

Category: Computers

Page: 816

View: 2868

Optimize reporting and BI with Microsoft SQL Server 2016 Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports provides a comprehensive lesson in business intelligence (BI), operational reporting and Reporting Services architecture using a clear, concise tutorial approach. You'll learn effective report solution design based upon many years of experience with successful report solutions. Improve your own reports with advanced, best-practice design, usability, query design, and filtering techniques. Expert guidance provides insight into common report types and explains where each could be made more efficient, while providing step-by step instruction on Microsoft SQL Server 2016. All changes to the 2016 release are covered in detail, including improvements to the Visual Studio Report Designer (SQL Server Data Tools) and Report Builder, Mobile Dashboard Designer, the new Report Portal Interface, HTML-5 Rendering, Power BI integration, Custom Parameters Pane, and more. The Microsoft SQL Server 2016 release will include significant changes. New functionality, new capabilities, re-tooled processes, and changing support require a considerable update to existing knowledge. Whether you're starting from scratch or simply upgrading, this book is an essential guide to report design and business intelligence solutions. Understand BI fundamentals and Reporting Services architecture Learn the ingredients to a successful report design Get up to speed on Microsoft SQL Server 2016 Grasp the purpose behind common designs to optimize your reporting Microsoft SQL Server Reporting Services makes reporting faster, easier, and more powerful than ever in web, desktop and portal solutions. Compatibility with an extensive variety of data sources makes it a go-to solution for organizations across the globe. The 2016 release brings some of the biggest changes in years, and the full depth and breadth of these changes can create a serious snag in your workflow. For a clear tutorial geared toward the working professional, Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports is the ideal guide for getting up to speed and producing successful reports.
Posted in 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: 9706

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

SQL Server 2017 Administrator's Guide

One stop solution for DBAs to monitor, manage, and maintain enterprise databases

Author: Marek Chmel,Vladimir Muzny

Publisher: Packt Publishing Ltd

ISBN: 1786467321

Category: Computers

Page: 434

View: 345

Implement and administer successful database solution with SQL Server 2017 About This Book Master the required skills to successfully set up, administer, and maintain your SQL Server 2017 database solution Design and configure, manage, and secure a rock-solid SQL server Comprehensive guide in keeping your SQL server disaster proof and all-time availability Who This Book Is For This book targets database administrators with an interest in SQL Server 2017 administration. Readers are expected to have some experience with previous SQL Server versions. What You Will Learn Learn about the new features of SQL Server 2017 and how to implement them Build a stable and fast SQL Server environment Fix performance issues by optimizing queries and making use of indexes Perform a health check of an existing troublesome database environment Design and use an optimal database management strategy Implement efficient backup and recovery techniques in-line with security policies Combine SQL Server 2017 and Azure and manage your solution by various automation techniques Perform data migration, cluster upgradation and server consolidation In Detail Take advantage of the real power of SQL Server 2017 with all its new features, in addition to covering core database administration tasks. This book will give you a competitive advantage by helping you quickly learn how to design, manage, and secure your database solution. You will learn how to set up your SQL Server and configure new (and existing) environments for optimal use. After covering the designing aspect, the book delves into performance-tuning aspects by teaching you how to effectively use indexes. The book will also teach you about certain choices that need to be made about backups and how to implement a rock-solid security policy and keep your environment healthy. Finally, you will learn about the techniques you should use when things go wrong, and other important topics - such as migration, upgrading, and consolidation - are covered in detail. Integration with Azure is also covered in depth. Whether you are an administrator or thinking about entering the field, this book will provide you with all the skills you need to successfully create, design, and deploy databases using SQL Server 2017. Style and approach A comprehensive guide for database professionals, covering a wide range of topics from installation, maintenance, and configuration to managing systems for operational efficiency and high availability; best practices for maintaining a highly reliable database solution are also supplied from industry experts.
Posted in Computers

Windows 8 Apps with XAML and C# Unleashed

Author: Adam Nathan

Publisher: Sams Publishing

ISBN: 0132984342

Category: Computers

Page: 624

View: 9703

Windows 8 enables you to build stunning applications that integrate with each other, services, and Windows itself like never before. And you can sell them in the Windows Store for tablets such as Surface, laptops, and traditional desktop PCs! Now, world-renowned Microsoft programming guru Adam Nathan shows you exactly how to write first-class apps for this radically new version of Windows. Clear, accessible, and intensely practical, this guide teaches through concise code examples, fully color-coded to match their appearance in Visual Studio--the same approach that made Nathan’s WPF 4 Unleashed so popular. Writing with unprecedented depth and insight, Nathan guides you through creating advanced user interfaces with XAML and exploiting key Windows 8 features such as touch, sensors, charms, and live tiles. Whether you’re already comfortable with Microsoft programming or relatively new to it, Windows 8 Apps with XAML and C# Unleashed will take you to the cutting edge of Windows 8 development. Detailed information on how to... Use XAML to represent state-of-the-art user interfaces Ensure app usability on multiple devices and form factors Handle touch, mouse, pen, and keyboard input Manage the high-performance, low-power Windows 8 app lifecycle Use Windows 8 controls for managing lists, rich text, images, multimedia, and more Encode, decode, and transcode multimedia content Leverage rich XAML vector graphics and animation Make the most of styles and templates Interact with built-in functionality such as the Camera app, file picker, contact picker, the lock screen, and more Exploit the Windows 8 charms bar with contracts and extensions Work with the rich set of available sensors: accelerometer, compass, light sensor, location, proximity, and more
Posted in Computers

Microsoft SQL Server 2017 on Linux

Author: Benjamin Nevarez

Publisher: McGraw Hill Professional

ISBN: 1260121143

Category: Computers

Page: N.A

View: 5027

Essential Microsoft® SQL Server® 2017 installation, configuration, and management techniques for Linux Foreword by Kalen Delaney, Microsoft SQL Server MVP This comprehensive guide shows, step-by-step, how to set up, configure, and administer SQL Server 2017 on Linux for high performance and high availability. Written by a SQL Server expert and respected author, Microsoft SQL Server 2017 on Linux teaches valuable Linux skills to Windows-based SQL Server professionals. You will get clear coverage of both Linux and SQL Server and complete explanations of the latest features, tools, and techniques. The book offers clear instruction on adaptive query processing, automatic tuning, disaster recovery, security, and much more. •Understand how SQL Server 2017 on Linux works•Install and configure SQL Server on Linux•Run SQL Server on Docker containers•Learn Linux Administration•Troubleshoot and tune query performance in SQL Server•Learn what is new in SQL Server 2017•Work with adaptive query processing and automatic tuning techniques•Implement high availability and disaster recovery for SQL Server on Linux•Learn the security features available in SQL Server
Posted in Computers

Introducing Microsoft SQL Server 2014

Author: Ross Mistry,Stacia Misner

Publisher: Microsoft Press

ISBN: 0133966178

Category: Computers

Page: 144

View: 908

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
Posted in Computers

Professional SQL Server 2005 Administration

Author: Brian Knight,Ketan Patel,Wayne Snyder,Jean-Claude Armand,Ross LoForte,Brad McGehee,Steven Wort,Joe Salvatore,Haidong Ji

Publisher: John Wiley & Sons

ISBN: 0470121092

Category: Computers

Page: 735

View: 8860

Posted in Computers

System Center Configuration Manager Current Branch Unleashed

Author: Kerrie Meyler,Gerry Hampson,Saud Al-Mishari,Greg Ramsey,Kenneth van Surksum,Michael Gottlieb Wiles

Publisher: Sams Publishing

ISBN: 0134652444

Category: Computers

Page: 1168

View: 8984

System Center Configuration Manager Current Branch provides a total systems management solution for a people-centric world. It can deploy applications to individuals using virtually any device or platform, centralizing and automating management across on-premise, service provider, and Microsoft Azure environments. In System Center Configuration Manager Current Branch Unleashed, a team of world-renowned System Center experts shows you how to make the most of this powerful toolset. The authors begin by introducing modern systems management and offering practical strategies for coherently managing today’s IT infrastructures. Drawing on their immense consulting experience, they offer expert guidance for ConfigMgr planning, architecture, and implementation. You’ll walk through efficiently performing a wide spectrum of ConfigMgr operations, from managing clients, updates, and compliance to reporting. Finally, you’ll find current best practices for administering ConfigMgr, from security to backups. Detailed information on how to: Successfully manage distributed, people-centric, cloud-focused IT environments Optimize ConfigMgr architecture, design, and deployment plans to reflect your environment Smoothly install ConfigMgr Current Branch and migrate from Configuration Manager 2012 Save time and improve efficiency by automating system management Use the console to centralize control over infrastructure, software, users, and devices Discover and manage clients running Windows, macOS, Linux, and UNIX Define, monitor, enforce, remediate, and report on all aspects of configuration compliance Deliver the right software to the right people with ConfigMgr applications and deployment types Reliably manage patches and updates, including Office 365 client updates Integrate Intune to manage on-premise and mobile devices through a single console Secure access to corporate resources from mobile devices Manage Microsoft’s enterprise antimalware platform with System Center Endpoint Protection Using this guide’s proven techniques and comprehensive reference information, you can maximize the value of ConfigMgr in your environment–no matter how complex it is or how quickly it’s changing.
Posted in Computers