Ebooks
Microsoft SQL Server 2012 Reporting Services Tom 1 i 2. Pakiet
Misner Stacia
Microsoft SQL Server 2012 Reporting Services Użyj swoich umiejętności do tworzenia i zarządzania kluczowymi raportami Twórz interaktywne raporty analiz biznesowych przy użyciu platformy SQL Server 2012 Reporting Services, by ułatwić podejmowanie natychmiastowych decyzji. Ekspert w zakresie produktu SQL Server, Stacia Misner, szczegółowo opisuje, jak projektować, zarządzać i udostępniać dostosowane raporty uwzględniające dane z wielu źródeł. Dowiedz się, jak: Korzystać z najnowszych funkcji, a w tym narzędzia tworzenia raportów w trybie ad hoc Power View Projektować raporty, wiedząc, jak odbiorcy uzyskują dostęp do danych i jak z nich korzystają Dodawać interaktywne funkcje, ułatwiające użytkownikom sortowanie i filtrowanie danych Tworzyć bogate wizualnie prezentacje danych za pomocą wykresów, mierników, wskaźników i map danych Konfigurować serwer raportów, zapewnić bezpieczeństwo i monitorować zawartość raportów Posługiwać się oprogramowaniem SharePoint lub Report Manager do wyszukiwania i uzyskiwania dostępu do raportów online Budować biblioteki częściowych raportów, które klienci mogą używać do tworzenia raportów w trybie ad hoc Tworzyć raporty i zarządzać nimi przy użyciu platformy Reporting Services Pliki przykładów dostępne pod adresem: https://aka.ms/SQL2012RS/files Wprowadzenie do książki zawiera instrukcje instalacji plików.
Debarchan Sarkar
With the explosion of data, the open source Apache Hadoop ecosystem is gaining traction, thanks to its huge ecosystem that has arisen around the core functionalities of its distributed file system (HDFS) and Map Reduce. As of today, being able to have SQL Server talking to Hadoop has become increasingly important because the two are indeed complementary. While petabytes of unstructured data can be stored in Hadoop taking hours to be queried, terabytes of structured data can be stored in SQL Server 2012 and queried in seconds. This leads to the need to transfer and integrate data between Hadoop and SQL Server.Microsoft SQL Server 2012 with Hadoop is aimed at SQL Server developers. It will quickly show you how to get Hadoop activated on SQL Server 2012 (it ships with this version). Once this is done, the book will focus on how to manage big data with Hadoop and use Hadoop Hive to query the data. It will also cover topics such as using in-memory functions by SQL Server and using tools for BI with big data.Microsoft SQL Server 2012 with Hadoop focuses on data integration techniques between relational (SQL Server 2012) and non-relational (Hadoop) worlds. It will walk you through different tools for the bi-directional movement of data with practical examples.You will learn to use open source connectors like SQOOP to import and export data between SQL Server 2012 and Hadoop, and to work with leading in-memory BI tools to create ETL solutions using the Hive ODBC driver for developing your data movement projects. Finally, this book will give you a glimpse of the present day self-service BI tools such as Excel and PowerView to consume Hadoop data and provide powerful insights on the data.
Abolfazl Radgoudarzi, Reza Rad
Written in an easy-to-follow, example-driven format, there are plenty of step-by-step instructions to help get you started! The book has a friendly approach, with the opportunity to learn by experimenting. If you are a BI and Data Warehouse developer new to Microsoft Business Intelligence, and looking to get a good understanding of the different components of Microsoft SQL Server for Business Intelligence, this book is for you. It’s assumed that you will have some experience in databases systems and T-SQL. This book is will give you a good upshot view of each component and scenarios featuring the use of that component in Data Warehousing and Business Intelligence systems.
Microsoft SQL Server 2016 Analysis Services: Modelowanie tabelaryczne
Alberto Ferrari, Marco Russo
Wraz z wprowadzeniem wersji SQL Server Analysis Services 2016 firma Microsoft dramatycznie udoskonaliła podejście tabelaryczne do modelowania danych w analizie biznesowej, czyniąc model tabelaryczny najłatwiejszym i najlepszym rozwiązaniem dla większości nowych projektów. W tej książce dwóch ekspertów o światowej sławie w dziedzinie technologii modelowania danych i analizy firmy Microsoft przedstawiają wszystko, co trzeba wiedzieć, aby móc tworzyć kompletne rozwiązania BI przy użyciu tych potężnych narzędzi. Marco Russo i Alberto Ferrari prowadzą czytelnika krok po kroku poprzez tworzenie modeli danych, a następnie objaśniają zaawansowane funkcje, takie jak optymalizacja, wdrażanie czy skalowalność. Modelowanie tabelaryczne w Microsoft SQL Server Analysis Services będzie nieodzowne dla każdego, kto planuje przejście do rozwiązań tabelarycznych Analysis Services, niezależnie od jego wcześniejszych doświadczeń z modelami w stylu tabelarycznym lub ze starszymi wersjami Analysis Services. Będzie również podstawową lekturą uzupełniającą dla każdego czytelnika wcześniejszego bestsellera tych autorów: Microsoft SQL Server 2012 Analysis Services: Model tabelaryczny BISM.
Microsoft SQL Server. Modelowanie i eksploracja danych
Danuta Mendrala, Marcin Szeliga
Odkryj najlepsze narzędzia do eksploracji danych Naucz się przygotowywać dane i poprawiać ich jakość Dowiedz się, jak prowadzić zaawansowane analizy danych Poznaj sprawdzone techniki profesjonalnej eksploracji danych! Eksploracja danych jest najmłodszą i najszybciej rozwijającą się dziedziną informatyki. Łączy zaawansowane algorytmy analizowania danych i znajdowania ukrytych w nich wzorców z klasycznymi technikami statystycznymi, rachunkiem prawdopodobieństwa i technologiami bazodanowymi. Dziedzina ta zyskuje na znaczeniu wraz z lawinowo rosnącą ilością informacji cyfrowych, które każdego dnia na całym świecie są wytwarzane, zapisywane i przeszukiwane przez stale zwiększającą się grupę użytkowników technologii informatycznych. Trzydzieści lat temu świat zrewolucjonizowały komputery PC, a dziś w ogarnięciu tego chaosu pomóc mogą jedynie najskuteczniejsze narzędzia do modelowania i eksploracji danych. "Microsoft SQL Server. Modelowanie i eksploracja danych" to książka, z której analitycy, informatycy i biznesmeni dowiedzą się, jak tworzyć właściwe modele, odpowiednio przygotowywać dane i prawidłowo je eksplorować, a także jak należycie analizować i oceniać otrzymane wyniki przy użyciu narzędzi oferowanych przez oprogramowanie Microsoft SQL Server. Publikacja przybliża zagadnienia związane z poszczególnymi etapami procesu modelowania i eksploracji, prezentując przy tym zastosowanie różnych metod i technik analizy do rozwiązywania praktycznych problemów naukowych i biznesowych. Podstawowe techniki i narzędzia wykorzystywane w eksploracji danych Instalacja i konfiguracja niezbędnego oprogramowania Analiza biznesowa projektu eksploracji danych Ocena, przygotowywanie i poprawianie jakości danych Przegląd technik eksploracji danych Wykorzystywanie serwera SQL w procesie eksploracji danych Składnia i zastosowanie języka DMX Łatwe w użyciu narzędzia pakietu Office i zaawansowane narzędzia eksploracji danych serwera SQL firmy Microsoft Zasada działania zaawansowanych algorytmów eksploracji danych Ocena i poprawianie modeli eksploracyjnych Programowanie predykcyjne Naucz się wykorzystywać zaawansowane narzędzia do inteligentnej zamiany dużych zbiorów danych w przydatne informacje!
Brian Mason, Greg Ramsey
Microsoft System Center 2012 Configuration Manager (CM12) is a systems management application for managing large groups of Windows-based computer systems. System Center 2012 Configuration Manager provides remote control, patch management, software distribution, operating system deployment, network access protection, and hardware and software inventory.This practical cookbook shows you how to administer System Center 2012 Configuration Manager and understand how to solve particular problems/scenariosPacked with over 50 task-based and immediately reusable recipes, this book starts by showing you how to design a System Center 2012 Configuration Manager Infrastructure. The book then dives into topics such as recommended SQL configuration for System Center 2012 Configuration Manager, deploying Windows 7 with Operating System Deployment (OSD), deploying Applications and Software Updates, managing Compliance Settings, managing Sites and managing Inventory amongst others.
Andrew J Plue
Microsoft System Center 2012 Endpoint Protection (previously known as Forefront Endpoint Protection 2012) protects client and server operating systems against threats with leading malware detection technologies. Built on Configuration Manager, it provides a unified infrastructure for client security and compliance management and Microsoft System Center 2012 Endpoint Protection Cookbook will help you get to grips with vital tasks for implementing this security tool.With the release of System Center 2012 Endpoint Protection, Microsoft is continuing its commitment to offering a cutting edge, enterprise- ready Anti-Virus solution. With its practical and easy to follow recipes, Microsoft System Center 2012 Endpoint Protection Cookbook fully prepares you for a simple, headache-free migration. This hands-on, practical cookbook will have you equipped with the knowledge to install and manage System Center 2012 Endpoint Protection like a pro in no time by following step by step recipes.You'll gain insight into a wide range of management tasks, such as building your SCEP infrastructure, deploying SCEP clients and building the perfect AV policies for your workstation and servers. You'll also benefit from a complete SCEP walk-through in a bonus appendix chapter.With Microsoft System Center 2012 Endpoint Protection Cookbook in hand, you will have the confidence to tackle essential tasks like deployment, policy and much more for SCEP.
Andreas Baumgarten
Whether you are an IT manager, an administrator, or security professional who wants to learn how Microsoft Security Compliance Manager and Microsoft System Center can help fulfil compliance and security requirements, this is the book for you. Prior knowledge of Microsoft System Center is required.
Jonathan Horner, Chiyo Odika
If you are tasked with monitoring the IT infrastructure within your organization, this book demonstrates how System Center 2012 R2 Operations Manager offers a radical and exciting solution to modern administration.
Samuel Erskine, Anders Asp, Andreas Baumgarten, Steve...
Microsoft System Center Service Manager (SCSM) offers enterprises a complete, integrated platform for automating and adapting IT Service Management best practices to your organization's requirements.Microsoft System Center Service Manager Cookbook provides you with real-world, immediately usable recipes which will show you how to configure and administer System Center Service Manager 2012 and understand how to solve particular problems and scenarios to take this tool further.In Microsoft System Center Service Manager Cookbook, you will get to grips with practical recipes which will show you how to configure and administer System Center Service Manager 2012. This cookbook features distinct recipes on the practical implementation of ITSM Frameworks and Processes, Microsoft System Center 2012 Service Manager Administration, how to configure Service Level Agreements (SLAs). It will also cover incident and problem management, the design of change and release management as well as implementing and editing security roles.
Steve Beaumont, Samuel Erskine (EUR), Andreas Baumgarten,...
With Microsoft System Center 2016 Orchestrator Cookbook, you will start by learning how to efficiently install and secure System Center Orchestrator. You will then learn how you can create configuration files for SCO 2016. After initial installation and configuration, you will soon be planning and creating functional and fault-tolerant System Center runbooks to automate daily tasks and routine operations. Next you will delve into runbooks; you will learn how to create powerful and advanced runbooks such as Building your Runbook without a Dead End. You will also learn to create simple and advanced runbooks for your daily tasks. Towards the end of the book, you will learn to use SCO for other interesting tasks and also learn to maintain and perform SCO health checks.By the end of the book, you will be able to automate your administrative tasks successfully with SCO.
Steve Buchanan, Steve Beaumont, Anders Asp, Dieter...
Keep your organization up to speed with the Microsoft System Center 2016 Service Manager Cookbook. Over 100 practical recipes for SCSM 2016 give you all the tools to master IT service management.
Martyn Coupland
If you are an experienced Configuration Manager administrator looking to advance your career or get more from your current environment, then this book is ideal for you. Prior experience of deploying and managing a Configuration Manager site would be helpful in following the examples throughout this book.
Samir Hammoudi, Chuluunsuren Damdinsuren, Brian Mason, Greg...
This practical cookbook is based on the 1602 current branch of System Center Configuration Manager (SCCM). It shows you how to administer SCCM, giving you an essential toolbox of techniques to solve real-world scenarios. Packed with over 60 task-based and instantly usable recipes, you’ll discover how design a SCCM Infrastructure, and dive into topics such as the recommended SQL configuration for SCCM and how to deploy Windows 10 with Operating System Deployment (OSD). You will learn to easily manage Windows 10 devices by deploying applications, software updates, and feature upgrades, andl be able to leverage Mobile Device Management (MDM) using SCCM and Microsoft Intune. Finally, you see how to gather the inventory of all your PC park and create reports based on it. By the end of the book, you will have learned the best practices when working with SCCM and have a handy reference guide for troubleshooting.
Marius Sandbu
Microsoft Configuration Manager is both extensive and complex, and for many, it is the primary tool for Enterprise management. With each new release, Configuration Manager continually proves itself to be the ultimate solution for managing both clients and mobile devices.This book covers in detailed and easy-to-understand steps how to set up highly available Configuration Manager roles and backend services such as SQL, DNS, and AD. You will learn how to plan for high availability, what kind of roles there are, and how they scale.The book starts by examining what needs to be taken into account when planning for high availability before moving on to focus on the different roles and how they can be set up. The book will also go through different scenarios as well as various backup and recovery procedures. You will learn how to identify bottlenecks within the different components and create sample design scenarios for high availability on Configuration Manager. The book will also look at the different high availability options and how to deploy them.
Robert Heldblom, Robert Hedblom
If you are a DPM administrator, this book will help you verify your knowledge and provide you with everything you need to know about the 2012 R2 release. No prior knowledge about System Center DPM is required, however some experience of running backups will come in handy.
Charbel Nemnom, Patrick Lownds
System Center Data Protection Manager (SCDPM) is a robust enterprise backup and recovery system that contributes to your BCDR strategy by facilitating the backup and recovery of enterprise data. With an increase in data recovery and protection problems faced in organizations, it has become important to keep data safe and recoverable. This book contains recipes that will help you upgrade to SCDPM and it covers the advanced features and functionality of SCDPM.This book starts by helping you install SCDPM and then moves on to post-installation and management tasks. You will come across a lot of useful recipes that will help you recover your VMware and Hyper-V VMs. It will also walk you through tips for monitoring SCDPM in different scenarios. Next, the book will also offer insights into protecting windows workloads followed by best practices on SCDPM. You will also learn to back up your Azure Stack Infrastructure using Azure Backup. You will also learn about recovering data from backup and implementing disaster recovery. Finally, the book will show you how to configure the protection groups to enable online protection and troubleshoot Microsoft Azure Backup Agent.
Nicolai Henriksen
System Center Configuration Manager is now used by over 70% of all the business in the world today and many have taken advantage engaging the System Center Endpoint Protection within that great product. Through this book, you will gain knowledge about System Center Endpoint Protection, and see how to work with it from System Center Configuration Manager from an objective perspective.We’ll show you several tips, tricks, and recipes to not only help you understand and resolve your daily challenges, but hopefully enhance the security level of your business.Different scenarios will be covered, such as planning and setting up Endpoint Protection, daily operations and maintenance tips, configuring Endpoint Protection for different servers and applications, as well as workstation computers. You’ll also see how to deal with malware and infected systems that are discovered. You’ll find out how perform OS deployment, Bitlocker, and Applocker, and discover what to do if there is an attack or outbreak.You’ll find out how to ensure good control and reporting, and great defense against threats and malware software. You’ll see the huge benefits when dealing with application deployments, and get to grips with OS deployments, software updates, and disk encryption such as Bitlocker. By the end, you will be fully aware of the benefits of the System Center 2016 Endpoint Protection anti-malware product, ready to ensure your business is watertight against any threat you could face.
Microsoft System Center Orchestrator 2012 R2 Essentials
Miguel Oliveira
With the increasing complexity of systems in our infrastructure designs, administrating these systems has become more complex and repetitive. This ultimately translates into an inefficient environment and loss of time. System Center Orchestrator 2012 R2 is the tool that can help you regain that time again, by simplifying repetitive tasks (or complex ones) into a simple one that will require minimum intervention from you, or even none.This technology will drive you one step forward towards a more dynamic infrastructure and can also be used to make a customized Private Cloud environment setup.Starting off with the fundamentals of Orchestrator, this book helps you to learn the configuration and deployment of the Orchestrator 2012 R2 in a corporate environment to successfully deploy and mitigate real-life issues that you might encounter. You’ll learn the most used part of Orchestrator, the Runbook Designer, with all its components and mechanisms to help you efficiently design and implement your Runbooks from top to bottom. Additionally, you will also get familiarized with configuring key Integration Packs available for Orchestrator to extend its functionality and enhance the automation solution.Furthermore, you will explore the possibilities of extending and integrating Orchestrator with other parties and learn to set up core infrastructure administrative tasks that can save time and effort when automated with Orchestrator. You finally round off by gaining insights on the maintenance aspects of Orchestrator, while simultaneously covering the troubleshooting, backup, and recovery features.
Guruprasad HP, Harshul Patel
If you are a Microsoft System Center administrator who manages System Center environments and utilizes the console for management, then this book is ideal for you. This book is also for System Center users who now want to learn to manage systems using PowerShell.
EDVALDO ALESSANDRO CARDOSO, Edvaldo Alessandro Cardoso Sobrinho
Microsoft System Center 2012 is a comprehensive IT infrastructure, virtualization, and cloud management platform. With System Center 2012, you can more easily and efficiently manage your applications and services across multiple hypervisors as well as across public and private cloud infrastructures to deliver flexible and cost-effective IT services for your business.This cookbook covers architecture design and planning and is full of deployment tips, techniques, and solutions designed to show users how to improve VMM 2012 in a real world scenario. It will guide you to create, deploy, and manage your own Private Cloud with a mix of Hypervisors: Hyper-V, Vmware ESXi, and Citrix XenServer. It also includes the VMM 2012 SP1 features.This book is a cookbook that covers architecture design, planning and is full of deployment tips, techniques and solutions designed to show users how to improve VMM 2012 in a real world scenario. It will guide you to create, deploy and manage your own Private Cloud with a mix of Hypervisors : Hyper-V, Vmware ESXi and Citrix XenServer.
Microsoft System Center Virtual Machine Manager 2012. Poradnik praktyczny
Edvaldo Alessandro Cardoso
Microsoft System Center 2012 jest wszechstronną platformą wirtualizacji, chmury i zarządzania infrastrukturą IT. Poprzez System Center 2012 możesz dużo łatwiej i wydajniej zarządzać swoimi aplikacjami i usługami w obrębie kilku różnych hiperwizorów oraz infrastruktur chmur publicznych i prywatnych w celu dostarczenia elastycznych i oszczędnych usług IT dla Twojego biznesu. Treść niniejszej książki obejmuje projekt architektury i planowanie, a przy tym zawiera wiele różnych porad, technik i rozwiązań wdrożeniowych, które pokażą Ci, w jaki sposób możesz usprawnić VMM 2012 w praktycznych scenariuszach. Poprowadzi Cię ona przez etapy tworzenia, wdrażania i zarządzania Twoją chmurą prywatną, zbudowaną w oparciu o różne hiperwizory: Hyper-V, VMware ESXi oraz Citrix XenServer. Uwzględnia ona także funkcje zawarte w VMM 2012 SP1. Dla kogo jest ta książka? Książka ta przeznaczona jest dla projektantów rozwiązań, konsultantów technicznych, administratorów, a także dla każdego innego miłośnika wirtualizacji, który musi korzystać na co dzień z Microsoft System Center Virtual Machine Manager 2012. Dzięki tej książce nauczysz się - Korzystać z architektury VMM oraz planować praktyczne wdrożenia - Wykorzystywać wirtualizację sieci, bramy czy magazynu, dławienie zasobów oraz opcje dostępności - Wdrażać system Operations Manager i integrować z VMM - Integrować z VMM kontroler SC App Controller w celu zarządzania chmurami prywatnymi i publicznymi (Azure) - Wdrażać klastry poprzez VMM Bare Metal - Tworzyć i wdrażać z szablonów maszyny wirtualne - Wdrażać wysoko dostępny serwer zarządzania VMM - Zarządzać Hyper-V, VMware oraz Citrix z poziomu VMM - Aktualizować SCVMM 2008 R2 do SCVMM 2012 SP1
Paul te Braak
Business Intelligence Semantic Models (BISM) is a technology that is designed to deliver analytical information to users through a variety of mechanisms that include model structure, definition, and design. This book demonstrates how to create BISM models so that information can be presented to users in an intuitive and easy-to-use format. Once the model is defined, we also show you how it can be managed and maintained so that the data in it remains current and secure.Microsoft Tabular Modeling Cookbook is an all-encompassing guide to developing, managing, creating, and using analytical models using the Business Intelligence Semantic Model (BISM). This title covers a range of modeling situations and common data analysis related problems to show you the techniques required to turn data into information using tabular modeling.Microsoft Tabular Modeling Cookbook examines three areas of tabular modeling: model development, model management and maintenance, and reporting. This book is a practical guide on how to develop semantic models and turn business data into information. It covers all phases of the model lifecycle from creation to administration and finally reporting. It also shows you how to create models which are designed to analyze data.All sections of BISM modeling from development to management and finally reporting are covered. The sections on development examine a wide range of techniques and tricks required to build models, including moving data into the model, structuring the model to manipulate the data, and finally the formulas required to answer common business questions; all of these are discussed in this book in detail.Finally, the book examines methods of reporting on the data within the model, including the creation of data-driven workbooks and reports for a powerful end user experience.
Tarun Arora
Team Foundation Server (TFS) allows you to manage code repositories, build processes, test infrastructure, and deploy labs. TFS supports your team, enabling you to connect, collaborate, and deliver on time. Microsoft's approach to Application Lifecycle Management (ALM) provides a flexible and agile environment that adapts to the needs of your team, removes barriers between roles, and streamlines processes.The book introduces you to creating and setting up team projects for scrum teams. You'll explore various source control repositories, branching, and merging activities, along with a demonstration of how to embed quality into every code check-in. Then, you'll discover agile project planning and management tools. Later, emphasis is given to the testing and release management features of TFS which facilitate the automation of the release pipeline in order to create potentially shippable increments. By the end of the book, you'll have learned to extend and customize TFS plugins to incorporate them into other platforms and enable teams to manage the software lifecycle effectively.