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: 2023
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: 8696
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

SQL Server Security


Author: Thomas Glörfeld
Publisher: MITP-Verlags GmbH & Co. KG
ISBN: 3826694236
Category: Computers
Page: 400
View: 6397
DOWNLOAD NOW »
Alles Wissenswerte rund um Security mit SQL-Datenbanken Für Datenbankentwickler, Betriebswirte und Projektleiter Stand SQL Server 2012 Aus dem Inhalt: Aufwand vs. Sicherheit - Was ist angemessen? Sprich »Freund« und tritt ein – Authentifizierung Benutzer und Rollen Rechte – Der Unterschied zwischen Wollen und Dürfen Softwarearchitektur und Datenbank-Sicherheit Rechteprüfung in der Anwendung SQL-Injection Verschlüsselung mit Zertifikaten und asymmetrischen Schlüsseln Symmetrische Verschlüsselung Daten hashen und signieren Security-Features rund um gespeicherte Prozeduren Auditing Andere bewährte Vorgehensweisen Umgang mit Meldungen über Sicherheitslücken In diesem Buch geht es um typische Angriffe, zu denen Schwächen und Sicherheitslücken in Datenbank-Anwendungen möglicherweise geradezu einladen. Das Themenspektrum, das in diesem Buch abgehandelt wird, reicht von Einsteigerthemen wie die effektive Nutzung von Rechten, Logins, User und Gruppen über die verschiedenen Verschlüsselungsmöglichkeiten der Daten bis hin zu Expertenthemen wie die Signierung von SQL-Code. Die bekannt gewordenen Angriffe der letzten Jahre zeigten zwar, dass auch bei der Administration von IT-Systemen eklatante Mängel vorkamen, dass die wirklich gravierenden und entscheidenden Sicherheitsprobleme aber durch die Anwendungen selbst verursacht wurden. Es geht also vorrangig darum, die Möglichkeiten und Grenzen bei der Entwicklung von Datenbank-Anwendungen aufzuzeigen, zumal mit den Mitteln, die SQL bereit stellt, bereits viele Schwierigkeiten umschifft werden können. Das Buch richtet sich vornehmlich an Software-Entwickler, darüber hinaus aber auch an Betriebswirte, die verstehen wollen, warum manche »einfache« Vorgaben einen immensen Aufwand verursachen, sowie an Projektleiter, die schon bei der grundlegenden Architektur der Anwendung Sicherheitsaspekte berücksichtigen wollen. Sowohl Einsteiger, die sich mit den Grundlagen der SQL-Security vertraut machen wollen, als auch Fortgeschrittene, die tiefer in die Materie eintauchen möchten, werden von diesem Buch profitieren. Thomas Glörfeld studierte Informatik mit Schwerpunkt Datenbanksysteme. Seit 1995 beschäftigt er sich als Berater mit der Sicherheit rund um SQL-Datenbank-Anwendungen, seit der Version 4.21 für den Microsoft SQL Server, inkl. Abstecher zum Sybase SQL Anywhere.

Microsoft System Center 2012 Unleashed


Author: Chris Amaris,Rand Morimoto
Publisher: Sams Publishing
ISBN: 067233612X
Category: Computers
Page: 1011
View: 4028
DOWNLOAD NOW »
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 SQL Server 2008 Internals

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


Windows Server 2008 Unleashed


Author: Rand Morimoto,Michael Noel,Omar Droubi,Ross Mistry,Chris Amaris
Publisher: Sams Publishing
ISBN: 9780132715638
Category: Computers
Page: 1488
View: 8666
DOWNLOAD NOW »
Windows Server 2008 Unleashed covers the planning, design, prototype testing, implementation, migration, administration, and support of a Windows 2008 and Active Directory environment, based on more than three and a half years of early adopter experience in full production environments. This book addresses not only what is new with Windows 2008 compared to previous versions of the Windows Server product, but also what is different and how the similarities and differences affect an organization’s migration to Windows 2008. Chapters are dedicated to the migration process from Windows 2000/2003 to Windows 2008, how to properly use Group Policies in Windows 2008, and tips and tricks on managing and administering a Windows 2008 environment. The authors cover the technologies new to Windows 2008, such as IPv6, Network Access Protection (NAP), Network Policy Server (NPS), Terminal Services Remote Programs, Windows Deployment Services (WDS), Hyper-V virtualization, and more! This book doesn’t just describe the features and functions included in Windows 2008--there are notes throughout the book explaining how organizations have successfully used the technologies to fulfill core business needs. Tips, tricks, and best practices share lessons learned from hundreds of implementations of Windows 2008 in real-world environments. Detailed information on how to… Plan and migrate from Windows 2000/2003 to Windows 2008 Leverage new tools and utilities that simplify system and network administration functions Enable the latest security technologies to improve secured enterprise computing Better manage a Windows 2008 Active Directory environment Optimize a Windows 2008 environment for better scalability and enhanced performance Implement Windows 2008 for better branch office and remote office integration Design a Windows 2008 environment to support the latest in clustering, stretched clusters, fault tolerance, and redundant systems technologies Take advantage of add-on technologies available for Windows 2008, including Windows SharePoint Services, Microsoft Hyper-V virtualization, Windows Media Services, and IIS 7 web server solutions

Linux in a nutshell


Author: Ellen Siever
Publisher: O'Reilly Germany
ISBN: 9783897214262
Category:
Page: 940
View: 6335
DOWNLOAD NOW »


Microsoft SQL Server 2008 Management and Administration


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

Introducing Microsoft® SQL Server® 2012


Author: Ross Mistry,Stacia Misner
Publisher: "O'Reilly Media, Inc."
ISBN: 0735671419
Category: Computers
Page: 290
View: 1391
DOWNLOAD NOW »
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.

Linux-Administrations-Handbuch


Author: Evi Nemeth,Garth Snyder,Trent Hein
Publisher: Pearson Deutschland GmbH
ISBN: 9783827328229
Category:
Page: 1272
View: 8444
DOWNLOAD NOW »


Windows 8 für Dummies


Author: Andy Rathbone
Publisher: John Wiley & Sons
ISBN: 352766906X
Category: Computers
Page: 464
View: 9582
DOWNLOAD NOW »
Erkunden Sie die wunderbare Welt von Windows 8! Andy Rathbone zeigt Ihnen in seiner gewohnt humorvollen Art, wie Sie sich sicher auf der Oberfl?che im Metro-Look bewegen, die neuen Funktionen nutzen und altbekannte wiederfinden. Sie erfahren, wie Sie Windows 8 an Ihre Bed?rfnisse anpassen, mit Dateien und Programmen arbeiten, ins Internet gehen, drucken, Musik und Filme abspielen und nat?rlich auch, wie Sie Apps aus dem Windows Store auf Ihren Computer laden. Praktische Hilfekapitel unterst?tzen Sie dabei, ein Heimnetzwerk einzurichten oder Ihre Daten von einem alten Computer auf einen neuen Windows-8-PC zu ?bertragen. Und auch wenn mal etwas nicht auf Anhieb klappen sollte, finden Sie in diesem Buch eine schnelle und verst?ndliche L?sung. So kommen Sie mit Windows 8 jederzeit ans Ziel!

Microsoft System Center Configuration Manager Current Branch

Der schnelle Einstieg in die automatisierte Client- und Serververwaltung von Windows-Netzwerken
Author: Thomas Joos
Publisher: Carl Hanser Verlag GmbH Co KG
ISBN: 3446458395
Category: Computers
Page: 246
View: 9575
DOWNLOAD NOW »
Der schnelle Einstieg in die automatisierte Bereitstellung und Verwaltung von Anwendungen und Geräten im Unternehmen Netzwerk-Spezialist Thomas Joos zeigt in diesem Buch, wie Sie in zunehmend komplexeren Netzwerken mit System Center 2016 Configuration Manager (SCCM) Ihre Server- und Client-Computer effizient verwalten, Betriebssysteme installieren und Software-Patches bereitstellen. Sie lernen auch die Verwaltung von Windows Containern, die auf Docker basieren und Nano Servern, welche neu in Windows Server 2016 enthalten sind. Nach der Lektüre des Buches können Sie Pakete professionell erstellen und verteilen und Verwaltungsaufgaben durchführen. Der Schwerpunkt liegt immer auf dem praktischen Einsatz. Profitieren Sie von zahlreichen Tipps, den Anleitungen zur Fehlerbehebung und Hinweisen, welche Zusatzwerkzeuge Sie am besten nutzen.

System Center 2012 Service Manager Unleashed


Author: Kerrie Meyler,Kurt Van Hoecke,Samuel Erskine,Steve Buchanan
Publisher: Sams Publishing
ISBN: 0133744175
Category: Computers
Page: 960
View: 7480
DOWNLOAD NOW »
This comprehensive resource will help you automate and optimize all facets of service management with System Center 2012 Service Manager. Expert consultants offer deep “in the trenches” insights for improving problem resolution, change control, release management, asset lifecycle management, chargeback, and more. You’ll learn how to implement high-value best practices from ITIL and the Microsoft Operations Framework. The authors begin with an expert overview of Service Manager, its evolution, and its new capabilities. Next, they walk through overall planning, design, implementation, and upgrades. Then, to help you focus your efforts, they present stepwise coverage of all topics in each feature area, linking technical information about Service Manager with essential knowledge about the technologies it depends on. Whatever your role in deploying or running Service Manager, this guide will help you deliver more responsive support at lower cost and drive more value from all your IT investments. • Leverage MOF and ITIL processes built into System Center 2012 Service Manager • Plan and design your Service Manager deployment • Install Service Manager or upgrade from earlier versions • Efficiently administer work and configuration items • Use connectors to integrate with Active Directory, Exchange, and System Center components • Create service maps • Enable end user access through Service Manager’s self-service portal • Implement incident, problem, change, and release management • Utilize workflows to automate key support processes • Create service level agreements with calendars, metrics, and objectives • Provide quick access to a standardized catalog of services • Use notification to ensure that Service Manager items are promptly addressed • Secure Service Manager and its data warehouse/reporting platform • Perform maintenance, backup, and recovery • Manage Service Manager performance • Customize Service Manager

Abfragen Von Microsoft SQL Server 2012 - Original Microsoft Training Fur Examen 70-461


Author: Itzik Ben-Gan,Dejan Sarka,Ron Talmage
Publisher: Microsoft Press Deutschland
ISBN: 9783866459618
Category: Electronic books
Page: 745
View: 8489
DOWNLOAD NOW »
Erlernen Sie das Abfragen von Microsoft SQL Server 2012 und bereiten Sie sich gleichzeitig auf das Examen 70-461 vor. Das vorliegende Buch bietet Ihnen einen umfassenden Lehrbuchteil, mit dem Sie selbstandig lernen und anhand praktischer Ubungen die prufu

Microsoft Windows Server 2016 – Das Handbuch

Von der Planung und Migration bis zur Konfiguration und Verwaltung
Author: Thomas Joos
Publisher: O'Reilly
ISBN: 396010040X
Category: Computers
Page: 1112
View: 3866
DOWNLOAD NOW »
Dieses Buch gibt Ihnen einen tiefgehenden Einblick in den praktischen Einsatz von Windows Server 2016. Es richtet sich sowohl an Neueinsteiger in Microsoft-Servertechnologien als auch an Umsteiger von Vorgängerversionen. Planung und Migration, Konzepte und Werkzeuge der Administration sowie die wichtigsten Konfigurations- und Verwaltungsfragen werden praxisnah behandelt. Alle wichtigen Funktionen werden ausführlich vorgestellt, ebenso die effiziente Zusammenarbeit mit Windows 10-Clients. Es erwarten Sie über 1000 Seiten praxisnahes und kompetentes Insider-Wissen. Aus dem Inhalt: - Neuerungen, Änderungen im Vergleich zur Vorversion und Lizenzierung - Installieren und Einrichten von Serverrollen und -features - Verwalten von Datenträgern und Speicherpools, Hochverfügbarkeit, Datensicherung und -Wiederherstellung - Betreiben und Erweitern von Active Directory - Diagnose und Fehlerbehebung für Active Directory - Freigeben von Dateiservern und Daten - Einrichten eines Webservers mit IIS 10 - Anwendungsvirtualisierung mit den Remotedesktopdiensten (RDS) - Arbeitsstationsvirtualisierung mit VDI (Virtual Desktop Infrastructure) - Einrichten einer Zertifizierungsstelle - Hochverfügbarkeit und Lastenausgleich - Datensicherung und -wiederherstellung - Windows Server Update Services (WSUS) - Diagnose und Überwachung für System, Prozesse und Dienste - Windows-Bereitstellungsdienste (WDS) - Verwenden von Windows PowerShell 5.0 - Windows Server 2016 Essentials und Foundation - Windows Server Container und Hyper-V-Container nutzen - Virtualisierung mit Hyper-V - Hochverfügbarkeit mit Clustern - Storage Spaces Direct verstehen und einsetzen

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


Author: Paul Bertucci
Publisher: Sams Publishing
ISBN: 0134467574
Category: Computers
Page: 432
View: 4855
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.

Windows Server 2016

Praxiseinstieg
Author: Jörg Schieb
Publisher: MITP-Verlags GmbH & Co. KG
ISBN: 3958454798
Category: Computers
Page: 576
View: 7065
DOWNLOAD NOW »
Windows Server 2016 optimal einrichten, absichern und in der Praxis einsetzen Grundlagen zu allen Neuerungen und den wichtigsten Features wie PowerShell, Active Directory, Exchange Server, Hyper-V, Apache Webserver und Nano Server Mit vielen Beispielen und Schritt-für Schritt-Anleitungen Dieses Buch ist der perfekte Begleiter für einen praxisnahen Einstieg in die Administration mit Windows Server 2016 und zeigt, wie Sie das System bestmöglich für sich nutzen können. In einem ersten Teil wird alles erklärt, was für die ersten Schritte mit Windows Server 2016 wichtig ist: Sie erfahren, welche Kosten auf Sie zukommen, welche Voraussetzungen Ihr System mitbringen muss und wie Sie das System auf dem Server einrichten. Sie lernen den Server-Manager kennen, verwalten Benutzer und Gruppen und erfahren, wie Sie auch von unterwegs und mit beliebigen Geräten auf Windows Server 2016 zugreifen können. Der Autor demonstriert Ihnen anhand von kurzen Skripten, wie Sie auf der PowerShell und mit Cmdlets effektiv und automatisiert arbeiten können. Im nächsten Schritt geht Jörg Schieb ins Detail und und veranschaulicht Ihnen, wie Sie mit Windows Server 2016 im Alltag arbeiten. Er zeigt Ihnen unter anderem, wie Sie Anwendungen, Dienste, Dateien und Ordner für alle Nutzer verfügbar machen und sie zentral verwalten. Sie lernen, Active Directory und Exchange Server 2016 bereitzustellen und optimal zu konfigurieren und machen sich mit den Vorteilen des Apache Webservers auf Windows Server 2016 vertraut. Der dritte Teil beschäftigt sich mit allen Fragen rund um die Sicherheit Ihres Systems. Wie kann Windows Server 2016 wirksam gegen Bedrohungen geschützt werden? Wie muss die Firewall konfiguriert werden und wie können verfügbare Updates möglichst zeitnah installiert werden? Der Autor demonstriert Ihnen die Vorteile der Server-Virtualisierung und begleitet Sie auf Ihren ersten Schritten bei der Arbeit mit Hyper-V, mit Containern oder dem Nano Server.

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


Author: Paul Bertucci
Publisher: Sams Publishing
ISBN: 9780672337765
Category: Computers
Page: 432
View: 2101
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.

System Center Configuration Manager Reporting Unleashed


Author: Garth Jones,Dan Toll,Kerrie Meyler
Publisher: Sams Publishing
ISBN: 0134466799
Category: Computers
Page: 416
View: 7314
DOWNLOAD NOW »
Microsoft System Center Configuration Manager’s SQL Server database contains valuable information about your users, computers, hardware, operating systems, applications, compliance status, and much more. Microsoft has provided excellent tools for extracting this information in meaningful ways, including SQL Server Reporting Services (SSRS) and SQL Server Data Tools Business Intelligence (SSDT-BI). System Center Configuration Manager Reporting Unleashed shows you how to make the most of these tools. World-renowned System Center reporting guru Garth Jones and his expert coauthors guide you through all facets of custom reporting with System Center. You’ll walk through installing and configuring SSRS, using SQL views to find the data you need, writing SQL queries, creating basic and advanced reports, and using role-based administration to securely deliver those reports to the correct individuals. Jones brings together reliable, comprehensive, and up-to-date System Center reporting techniques you’ll find in no other book or website. Using this guide, you can consistently retrieve the right information to solve immediate problems and quickly respond to management concerns. Detailed information on how to… • Install and configure SQL SSRS for optimal System Center reporting and easier troubleshooting • Understand the data stored in the ConfigMgr site database • Efficiently retrieve ConfigMgr data by writing SQL queries in SQL Server Management Studio • Learn best practices for developing and designing System Center reports • Create report templates, customize content with report parameters, and embed charts • Customize logos, color palettes, and other report elements for your own organization • Construct advanced drillthroughs to provide deeper understanding • Strengthen report security by integrating ConfigMgr role-based administration into SQL queries • Leverage reporting to measure KPIs and gain a better understanding of your environment • Tailor your reports to the needs of end-users or management • Foreword by Wally Mead, Principal Program Manager, Cireson The only book entirely dedicated to Configuration Manager reporting, this guide complements Meyler's System Center 2012 Configuration Manager Unleashed, offering far more in-depth coverage of reporting than the single chapter in that book. Most of the content in this new guide will be equally valuable in both System Center 2016 and 2012 environments.

Microsoft SQL Server 2012

das Handbuch
Author: Thomas Joos
Publisher: N.A
ISBN: 9783866451513
Category: Database management
Page: 1022
View: 3849
DOWNLOAD NOW »