SQL Server 2016 Reporting Services Cookbook

Author: Dinesh Priyankara,Robert C. Cain

Publisher: Packt Publishing Ltd

ISBN: 1786467992

Category: Computers

Page: 596

View: 2334

Create interactive cross-platform reports and dashboards using SQL Server 2016 Reporting Services About This Book Get up to speed with the newly-introduced enhancements and the more advanced query and reporting features Easily access your important data by creating visually appealing dashboards in the Power BI practical recipe Create cross-browser and cross-platform reports using SQL Server 2016 Reporting Services Who This Book Is For This book is for software professionals who develop and implement reporting solutions using Microsoft SQL Server. It is especially relevant for professionals who are software engineers, software architects, DW/BI engineers, and DW/BI architects who perform simple to complex report authoring implementations. This book is also suitable for those who develop software solutions that integrate reporting solutions and are keen to learn about Microsoft SQL Server 2016's features and capabilities. What You Will Learn Key capabilities, architecture, and components of Reporting Services New features that have been added to Reporting Services Design the architecture for reporting solutions Design the architecture for BI solutions Implement reporting solutions using Reporting Services Improve the performance, availability, and scalability of the reporting solution Enhance reporting solutions with custom programming and improved security In Detail Microsoft SQL Server 2016 Reporting Services comes with many new features. It offers different types of reporting such as Production, Ad-hoc, Dashboard, Mash-up, and Analytical. SQL Server 2016 also has a surfeit of new features including Mobile Reporting, and Power BI integration. This book contains recipes that explore the new and advanced features added to SQL Server 2016. The first few chapters cover recipes on configuring components and how to explore these new features. You'll learn to build your own reporting solution with data tools and report builder, along with learning techniques to create visually appealing reports. This book also has recipes for enhanced mobile reporting solutions, accessing these solutions effectively, and delivering interactive business intelligence solutions. Towards the end of the book, you'll get to grips with running reporting services in SharePoint integrated mode and be able to administer, monitor, and secure your reporting solution. This book covers about the new offerings of Microsoft SQL Server 2016 Reporting Services in comprehensive detail and uses examples of real-world problem-solving business scenarios. Style and approach This comprehensive cookbook follows a problem-solution approach to help you overcome any obstacle when creating interactive, visually-appealing reports using SQL Server 2016 Reporting Services. Each recipe focuses on a specific task and is written in a clear, solution-focused style.
Posted in Computers

MDX with Microsoft SQL Server 2016 Analysis Services Cookbook

Author: Tomislav Piasevoli,Sherry Li

Publisher: Packt Publishing Ltd

ISBN: 1786467887

Category: Computers

Page: 586

View: 1683

Over 70 practical recipes to analyze multi-dimensional data in SQL Server 2016 Analysis Services cubes About This Book Updated for SQL Server 2016, this book helps you take advantage of the new MDX commands and the new features introduced in SSAS Perform time-related, context-aware, and business related-calculations with ease to enrich your Business Intelligence solutions Collection of techniques to write flexible and high performing MDX queries in SSAS with carefully structured examples Who This Book Is For This book is for anyone who has been involved in working with multidimensional data. If you are a multidimensional cube developer, a multidimensional database administrator, or a report developer who writes MDX queries to access multidimensional cube, this book will help you. If you are a power cube user or an experienced business analyst, you will also find this book invaluable in your data analysis. This book is for you are interested in doing more data analysis so that the management can make timely and accurate business decisions. What You Will Learn Grasp the fundamental MDX concepts, features, and techniques Work with sets Work with Time dimension and create time-aware calculations Make analytical reports compact, concise, and efficient Navigate cubes Master MDX for reporting with Reporting Services (new) Perform business analytics Design efficient cubes and efficient MDX queries Create metadata-driven calculations (new) Capture MDX queries and many other techniques In Detail If you're often faced with MDX challenges, this is a book for you. It will teach you how to solve various real-world business requirements using MDX queries and calculations. Examples in the book introduce an idea or a problem and then guide you through the process of implementing the solution in a step-by-step manner, inform you about the best practices and offer a deep knowledge in terms of how the solution works. Recipes are organized by chapters, each covering a single topic. They start slowly and logically progress to more advanced techniques. In case of complexity, things are broken down. Instead of one, there are series of recipes built one on top of another. This way you are able to see intermediate results and debug potential errors faster. Finally, the cookbook format is here to help you quickly identify the topic of interest and in it a wide range of practical solutions, that is – MDX recipes for your success. Style and approach This book is written in a cookbook format, where you can browse through and look for solutions to a particular problem in one place. Each recipe is short, to the point and grouped by relevancy. All the recipes are sequenced in a logical progression; you will be able to build up your understanding of the topic incrementally.
Posted in Computers

Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports

Author: Paul Turley

Publisher: John Wiley & Sons

ISBN: 1119258383

Category: Computers

Page: 816

View: 8244

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 2016 Reporting Services, Fifth Edition

Author: Brian Larson

Publisher: McGraw-Hill Education

ISBN: 9781259641503

Category: Computers

Page: 848

View: 5633

Up-to-Date Coverage of Microsoft® SQL Server® 2016 Reporting Services, Including the Mobile Report Publisher Build, publish, and maintain paginated and mobile reports using the expert tips and best practices contained in this hands-on guide. Written by a member of the original Reporting Services development team, Microsoft SQL Server 2016 Reporting Services, Fifth Edition, fully explains the process of creating and distributing reports and shows how to maximize all of the powerful, integrated SSRS capabilities, including the new and enhanced features. A detailed case study and sample reports are featured in this practical resource. • Plan for, install, configure, and customize SQL Server 2016 Reporting Services • Design and generate feature-rich reports using the Report Wizard • Work with Report Designer in Visual Studio, Report Builder, and the Mobile Report Publisher • Incorporate charts, images, gauges, and maps • Enhance your reports through summarizing, totaling, and interactivity • Build reusable report templates • Embed Visual Basic .NET functions and subreports • Enable end-user access via the Report Server and its web portal interface • Integrate SSRS reports with your own websites and custom applications • Follow along with sample reports from the book’s case study
Posted in Computers

Tabular Modeling with SQL Server 2016 Analysis Services Cookbook

Author: Derek Wilson

Publisher: Packt Publishing Ltd

ISBN: 1786461501

Category: Computers

Page: 372

View: 5065

Expert tabular modeling techniques for building and deploying cutting-edge business analytical reporting solutions About This Book Build and deploy Tabular Model projects from relational data sources Leverage DAX and create high-performing calculated fields and measures Create ad-hoc reports based on a Tabular Model solution Useful tips to monitor and optimize your tabular solutions Who This Book Is For This book is for SQL BI professionals and Architects who want to exploit the full power of the new Tabular models in Analysis Services. Some knowledge of previous versions of Analysis services would be helpful but is not essential. What You Will Learn Learn all about Tabular services mode and how it speeds up development Build solutions using sample datasets Explore built-in actions and transitions in SSAS 2016 Implement row-column, and role-based security in a Tabular Data model Realize the benefits of in-memory and DirectQuery deployment modes Get up to date with the new features added to SQL Server 2016 Analysis Services Optimize Data Models and Relationships Usage In Detail SQL Server Analysis Service (SSAS) has been widely used across multiple businesses to build smart online analytical reporting solutions. It includes two different types of modeling for analysis services: Tabular and Multi Dimensional. This book covers Tabular modeling, which uses tables and relationships with a fast in-memory engine to provide state of the art compression algorithms and query performance. The book begins by quickly taking you through the concepts required to model tabular data and set up the necessary tools and services. As you learn to create tabular models using tools such as Excel and Power View, you'll be shown various strategies to deploy your model on the server and choose a query mode (In-memory or DirectQuery) that best suits your reporting needs. You'll also learn how to implement key and newly introduced DAX functions to create calculated columns and measures for your model data. Last but not least, you'll be shown techniques that will help you administer and secure your BI implementation along with some widely used tips and tricks to optimize your reporting solution. By the end of this book, you'll have gained hands-on experience with the powerful new features that have been added to Tabular models in SSAS 2016 and you'll be able to improve user satisfaction with faster reports and analytical queries. Style and approach This book takes a practical, recipe-based approach where each recipe lists the steps to address or implement a solution. You will be provided with several approaches to creating a business intelligence semantic model using analysis services.
Posted in Computers

SQL Server 2017 Integration Services Cookbook

Author: Christian Cote,Matija Lah,Dejan Sarka

Publisher: Packt Publishing Ltd

ISBN: 1786460874

Category: Computers

Page: 558

View: 4884

Harness the power of SQL Server 2017 Integration Services to build your data integration solutions with ease About This Book Acquaint yourself with all the newly introduced features in SQL Server 2017 Integration Services Program and extend your packages to enhance their functionality This detailed, step-by-step guide covers everything you need to develop efficient data integration and data transformation solutions for your organization Who This Book Is For This book is ideal for software engineers, DW/ETL architects, and ETL developers who need to create a new, or enhance an existing, ETL implementation with SQL Server 2017 Integration Services. This book would also be good for individuals who develop ETL solutions that use SSIS and are keen to learn the new features and capabilities in SSIS 2017. What You Will Learn Understand the key components of an ETL solution using SQL Server 2016-2017 Integration Services Design the architecture of a modern ETL solution Have a good knowledge of the new capabilities and features added to Integration Services Implement ETL solutions using Integration Services for both on-premises and Azure data Improve the performance and scalability of an ETL solution Enhance the ETL solution using a custom framework Be able to work on the ETL solution with many other developers and have common design paradigms or techniques Effectively use scripting to solve complex data issues In Detail SQL Server Integration Services is a tool that facilitates data extraction, consolidation, and loading options (ETL), SQL Server coding enhancements, data warehousing, and customizations. With the help of the recipes in this book, you'll gain complete hands-on experience of SSIS 2017 as well as the 2016 new features, design and development improvements including SCD, Tuning, and Customizations. At the start, you'll learn to install and set up SSIS as well other SQL Server resources to make optimal use of this Business Intelligence tools. We'll begin by taking you through the new features in SSIS 2016/2017 and implementing the necessary features to get a modern scalable ETL solution that fits the modern data warehouse. Through the course of chapters, you will learn how to design and build SSIS data warehouses packages using SQL Server Data Tools. Additionally, you'll learn to develop SSIS packages designed to maintain a data warehouse using the Data Flow and other control flow tasks. You'll also be demonstrated many recipes on cleansing data and how to get the end result after applying different transformations. Some real-world scenarios that you might face are also covered and how to handle various issues that you might face when designing your packages. At the end of this book, you'll get to know all the key concepts to perform data integration and transformation. You'll have explored on-premises Big Data integration processes to create a classic data warehouse, and will know how to extend the toolbox with custom tasks and transforms. Style and approach This cookbook follows a problem-solution approach and tackles all kinds of data integration scenarios by using the capabilities of SQL Server 2016 Integration Services. This book is well supplemented with screenshots, tips, and tricks. Each recipe focuses on a particular task and is written in a very easy-to-follow manner.
Posted in Computers

Beginning SQL Server Reporting Services

Author: Kathi Kellenberger

Publisher: Apress

ISBN: 1484219902

Category: Computers

Page: 329

View: 5283

Learn SQL Server Reporting Services and become current with the 2016 edition. Develop interactive, dynamic reports that combine graphs, charts, and tabular data into attractive dashboards and reports to delight business analysts and other users of corporate data. Deliver mobile reports to anywhere and any device. Build vital knowledge of Reporting Services at a time when Microsoft's dominance in business intelligence is on the rise. Beginning SQL Server Reporting Services turns novices into skilled report developers. The book begins by explaining how to set up the development environment. It then walks you through creating your first reports using the built-in wizard. After showing what is possible, the book breaks down and explains the skills needed to create reports from scratch. And not just reports! But also dashboards with charts, graphs, and maps. Each chapter builds on knowledge gained in the previous chapters with step-by-step tutorials. sql server="" reporting="" services="" is="" a="" skillset="" in="" high="" demand.="" knowing="" about="" can="" help="" everyone="" from="" seasoned="" database="" administrators="" to="" mid-life="" career="" changers="" hoping="" break="" into="" information="" technology. iBeginning SQL Server Reporting Services Build reports with and without the built-in wizard. Build interactive features such as drill-through reports. Build dashboards full of charts, graphs, and maps. Build mobile reports. What You Will Learn Set up your development environment. Organized projects and share components among reports. Create report using a wizard. Create reports from scratch, including grouping levels, parameters, and drill through features. Build interactive dashboard with graphs, charts, and maps. Deploy and manage reports for use by others in the business. Who This Book Is For Database professionals of all experience levels who have some experience in databases and want to make the leap into business intelligence reporting. The book is an excellent choice for those needing to add Reporting Services to their current list of skills, or who are looking for a skill set that is in demand for in order to break into IT.
Posted in Computers

Factfulness

Wie wir lernen, die Welt so zu sehen, wie sie wirklich ist

Author: Hans Rosling,Anna Rosling Rönnlund,Ola Rosling

Publisher: Ullstein Buchverlage

ISBN: 3843717451

Category: Science

Page: 350

View: 8050

Es wird alles immer schlimmer, eine schreckliche Nachricht jagt die andere: Die Reichen werden reicher, die Armen ärmer. Es gibt immer mehr Kriege, Gewaltverbrechen, Naturkatastrophen. Viele Menschen tragen solche beängstigenden Bilder im Kopf. Doch sie liegen damit grundfalsch. Unser Gehirn verführt uns zu einer dramatisierenden Weltsicht, die mitnichten der Realität entspricht, wie der geniale Statistiker und Wissenschaftler Hans Rosling erklärt. Wer das Buch gelesen hat, wird • ein sicheres, auf Fakten basierendes Gerüst besitzen, um die Welt so zu sehen, wie sie wirklich ist • die zehn gängigsten Arten von aufgebauschten Geschichten erkennen • bessere Entscheidungen treffen können • wahre Factfulness erreichen – jene offene, neugierige und entspannte Geisteshaltung, in der Sie nur noch Ansichten teilen und Urteile fällen, die auf soliden Fakten basieren
Posted in Science

SQL Server 2014

Das Programmierhandbuch. Inkl. ADO.NET Entity Framework

Author: Dirk Mertins,Jörg Neumann,Andreas Kühnel

Publisher: N.A

ISBN: 9783836230445

Category: Computers

Page: 1308

View: 4099

Posted in Computers

SQL Server 2014

Der schnelle Einstieg

Author: Klemens Konopasek

Publisher: Carl Hanser Verlag GmbH Co KG

ISBN: 3446441085

Category: Computers

Page: 761

View: 5602

SQL Server 2014// - Ideales Praxisbuch für Ein- und Umsteiger, die schnell und effizient in die Arbeit mit dem SQL Server einsteigen wollen - Fortgeschrittene Techniken zur Backend-Programmierung für Entwickler - Grundlagen der Administration für angehende DBAs - Mit aufeinander aufbauenden Beispielen und Praxistipps - Sämtliche Beispiele aus dem Buch, u.a. Datenbanken, SQL-Skripte und Visual Studio-Projekte, finden Sie auf der Verlagswebsite Dieses Standardwerk bietet Ihnen einen kompakten und zugleich umfassenden Einstieg in SQL Server 2014. Mit Konzentration auf das Wesentliche stellt Klemens Konopasek all jene Themen und Funktionen vor, die im Hinblick auf Einsatz, Programmierung und Administration von Client-Server-Applikationen besonders wichtig sind und in der Praxis am häufigsten gebraucht werden – angefangen bei Installation und Konfiguration, den grundlegenden Werkzeugen wie grafische Tools und SQL bis hin zu Automatisierungslösungen, Power-Tools für Entwickler. Sicherheit, Verwaltung von Berechtigungen, Backup und Recovery bilden einen weiteren Schwerpunkt. Aufeinander aufbauende Beispiele helfen Ihnen, die zugrunde liegenden Konzepte und Techniken zu verstehen, um mit dem SQL Server wirklich effizient arbeiten zu können. AUS DEM INHALT // Installation // Grafische Werkzeuge // Datenbanken und Datenbankobjekte erstellen // SQL für Datenzugriff und Tabellenerstellung // Transact-SQL für serverseitige Programmierung // Gespeicherte Prozeduren, Funktionen und Trigger // CLR-Integration: Serverprogrammierung mit .NET-Sprachen // Data Tier Applications & SQL Server Data Tools // Client-Server-Datenbank administrieren, sichern und wiederherstellen // Sicherheit & Zugriffsberechtigungen // Datenbank-E-Mail, Integration Services, PowerPivot
Posted in Computers

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

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

Einführung in SQL

Author: Alan Beaulieu

Publisher: O'Reilly Germany

ISBN: 3897219387

Category: Computers

Page: 353

View: 4111

SQL kann Spaß machen! Es ist ein erhebendes Gefühl, eine verworrene Datenmanipulation oder einen komplizierten Report mit einer einzigen Anweisung zu bewältigen und so einen Haufen Arbeit vom Tisch zu bekommen. Einführung in SQL bietet einen frischen Blick auf die Sprache, deren Grundlagen jeder Entwickler beherrschen muss. Die aktualisierte 2. Auflage deckt die Versionen MySQL 6.0, Oracle 11g und Microsoft SQL Server 2008 ab. Außerdem enthält sie neue Kapitel zu Views und Metadaten. SQL-Basics - in null Komma nichts durchstarten: Mit diesem leicht verständlichen Tutorial können Sie SQL systematisch und gründlich lernen, ohne sich zu langweilen. Es führt Sie rasch durch die Basics der Sprache und vermittelt darüber hinaus eine Reihe von häufig genutzten fortgeschrittenen Features. Mehr aus SQL-Befehlen herausholen: Alan Beaulieu will mehr vermitteln als die simple Anwendung von SQL-Befehlen: Er legt Wert auf ein tiefes Verständnis der SQL-Features und behandelt daher auch den Umgang mit Mengen, Abfragen innerhalb von Abfragen oder die überaus nützlichen eingebauten Funktionen von SQL. Die MySQL-Beispieldatenbank: Es gibt zwar viele Datenbankprodukte auf dem Markt, aber welches wäre zum Erlernen von SQL besser geeignet als MySQL, das weit verbreitete relationale Datenbanksystem? Der Autor hilft Ihnen, eine MySQL-Datenbank anzulegen, und nutzt diese für die Beispiele in diesem Buch. Übungen mit Lösungen: Zu jedem Thema finden Sie im Buch gut durchdachte Übungen mit Lösungen. So ist sichergestellt, dass Sie schnell Erfolgserlebnisse haben und das Gelernte auch praktisch umsetzen können.
Posted in Computers

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

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
Posted in Electronic books

Datenbankentwicklung lernen mit SQL Server 2016

Der praxisorientierte Grundkurs

Author: Robert Panther

Publisher: O'Reilly

ISBN: 3960100825

Category: Computers

Page: 456

View: 4870

SQL Server 2016 und die kostenlose Version SQL Server 2016 Express sind ideal, um in die professionelle Datenbankentwicklung einzusteigen. Sie können mit ihnen komplexe Datenbankprojekte verwirklichen, die die Funktionalität einer Desktop-Datenbank wie Microsoft Access deutlich übersteigen. Wenn Sie tiefer in die Datenbankentwicklung mit einem professionellen Datenbankserver einsteigen wollen, ist dieses Buch genau das Richtige für Sie. Es vermittelt leicht verständlich sowohl die Datenbankgrundlagen als auch das Programmierwissen, das Sie benötigen, um die umfangreichen Möglichkeiten von SQL Server 2016 zu nutzen. Aufgrund des didaktisch durchdachten Konzepts mit vielen Übungen und Praxistipps ermöglicht dieses Buch Ihnen eine fundierte Einarbeitung in die Entwicklung von Datenbanken. Das Buch basiert auf der kostenfrei erhältlichen Version SQL Server 2016 Express, eignet sich aber auch für größere SQL-Server-Editionen. Aus dem Inhalt: - Neuerungen bei SQL Server 2016 - Installation und erste Schritte - Datenbanken und Tabellen erstellen und bearbeiten - Daten anzeigen und ändern - Sichten erstellen und verwenden - erweiterte SQL-Features (CTEs, Sequenzen, Temporal Tables etc.) - komplexe Datentypen (XML und JSON) - Debugging und Fehlerbehandlung - Sperren, Transaktionen und Deadlocks - gespeicherte Prozeduren, Funktionen, Trigger und Cursor - Datenbankadministration mit SQL, Benutzer, Rollen und Rechte - Daten sichern und bewegen, Reporting - Zusammenarbeit mit anderen SQL Server-Instanzen und -Editionen - Datenebenenanwendungen - SQL Server Data Tools - SQL Server und .NET
Posted in Computers

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

Posted in Database management

Datenbankentwicklung lernen mit SQL Server 2017

Der praxisorientierte Grundkurs

Author: Robert Panther

Publisher: O'Reilly

ISBN: 3960102232

Category: Computers

Page: 508

View: 6780

SQL Server 2017 und die kostenlose Version SQL Server 2017 Express sind ideal, um in die professionelle Datenbankentwicklung einzusteigen. Sie können mit ihnen komplexe Datenbankprojekte verwirklichen, die die Funktionalität einer Desktop-Datenbank wie Microsoft Access deutlich übersteigen. Wenn Sie tiefer in die Datenbankentwicklung mit einem professionellen Datenbankserver einsteigen wollen, ist dieses Buch genau das Richtige für Sie. Es vermittelt leicht verständlich sowohl die Datenbankgrundlagen als auch das Programmierwissen, das Sie benötigen, um die umfangreichen Möglichkeiten von SQL Server 2017 zu nutzen. Aufgrund des didaktisch durchdachten Konzepts mit vielen Übungen und Praxistipps ermöglicht dieses Buch Ihnen eine fundierte Einarbeitung in die Entwicklung von Datenbanken. Das Buch basiert auf der kostenfrei erhältlichen Version SQL Server 2017 Express, eignet sich aber auch für größere SQL-Server-Editionen.Aus dem Inhalt:Neuerungen bei SQL Server 2017Installation und erste SchritteDatenbanken, Tabellen und Sichten erstellen, bearbeiten und verwendenerweiterte SQL-Features (CTEs, Sequenzen, Temporal Tables etc.)komplexe Datentypen (XML und JSON)Debugging und FehlerbehandlungSperren, Transaktionen und Deadlocksgespeicherte Prozeduren, Funktionen, Trigger und CursorDatenbankadministration mit SQL; Benutzer, Rollen und RechteDaten sichern und bewegenSQL Server Reporting Servicesandere SQL-Editionen (SQL LocalDB etc.)DatenebenenanwendungenSQL Server Data ToolsGraphdatenbankenIntegration von R und PythonSQL Server und .NET
Posted in Computers

Microsoft SQL Server 2008 R2 Reporting Services - Das Praxisbuch

Author: Sven Bayer,Jörg Knuth,Martin B. Schultz

Publisher: Microsoft Press Deutschland

ISBN: 9783866456761

Category: Client/server computing

Page: 644

View: 3553

Microsoft SQL Server Reporting Services sind als Bestandteil von SQL Server 2008 R2 ohne weitere Lizenzkosten nutzbar. Als Bestandteil des Microsoft Business Intelligence-Frameworks stellen sie eine serverbasierte Losung zum Entwickeln, Verwalten und Verteilen von Berichten zur Verfugung. Ziel dieses Buchs ist es, Ihnen diese Technologien verstandlich zu machen und dabei nah an der Praxis zu bleiben. Das heit konkret: Die Autoren erlautern Ihnen anhand von Szenarien die Praxisrelevanz der jeweiligen Features und vertiefen wichtige Themen mit Schritt-fur-Schritt-Anleitungen. Das Buch ist so aufgebaut, dass auch Nutzer, die noch keine Erfahrung mit Berichtstools haben, einen leichten und schnellen Einstieg in die Materie finden, und beginnt mit einfachen Beispielen und deren Erlauterung. Auf diesem Wissen aufbauend, sind die darauf folgenden Ausfuhrungen fur die Leser verstandlich und leicht nachvollziehbar.
Posted in Client/server computing

Zeitmanagement für Systemadministratoren

Author: Tom Limoncelli

Publisher: Springer DE

ISBN: 9783897214651

Category: Computer networks

Page: 206

View: 2100

Sie sind gern Sysadmin, klar. Sie haben Ihr Hobby zum Beruf gemacht. Es stort Sie nicht, bis spat in der Nacht vorm Rechner zu sitzen, das machen Sie in Ihrem Privatleben auch ofter mal. Als Sysadmin mussen Sie viele Projekte gleichzeitig managen und haben eine unubersichtliche Menge verschiedener, kleinteiliger Aufgaben zu bewaltigen. Und das bei standigen Unterbrechungen durch Chefs oder Kollegen, die schnell etwas wissen wollen oder dringend Hilfe brauchen. All das in der regularen Arbeitszeit zu schaffen, ist nicht ohne. Der Autor dieses Buchs, Thomas A. Limoncelli, ist selbst Systemadministrator und kennt die Anforderungen an den Beruf genau. Zeitmanagement fur Systemadministratoren konzentriert sich auf die Techniken und Strategien, die Ihnen helfen, Ihre taglichen Aufgaben als Sysadmin zu bewaltigen und gleichzeitig kritische Situationen in den Griff zu bekommen, die unvorhergesehen auf den Plan treten. Unter anderem lernen Sie, wie Sie mit Unterbrechungen am besten umgehen Ihren Kalender effektiv fuhren Routinen fur wiederkehrende Aufgaben entwickeln Prioritaten klug setzen Zeitfresser eliminieren Arbeitsprozesse automatisieren und dokumentieren"
Posted in Computer networks

System Center Configuration Manager Reporting Unleashed

Author: Garth Jones,Dan Toll,Kerrie Meyler

Publisher: Sams Publishing

ISBN: 0134466799

Category: Computers

Page: 416

View: 5602

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