Build Schedule

Advanced Filters:
  • Track

    clear all






  • Speaker


  • Level


  • Session Type




Sessions Found: 24
Microsoft hat für die Speicherung der Daten im SQL Server in Azure zwei Angebote. Zum einen die Azure SQL Database und das Azure Data Warehouse. In diesem Vortrag werde ich auf die Unterschiede beider Versionen eingehen und auch vergleichen, wie sie sich gegenüber einem SQL Server On-Premise unterscheiden. Wir werden weiterhin auf Themen wie Skalierbarkeit, Performance und Kosten  eingehen. 
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud & Big Data

Level: Beginner

Session Code: DEUTSCH

Date: April 01

Time: 2:15 PM - 3:15 PM

Room: Pure Storage

Best Practices sind Empfehlungen, die eine optimale Systemkonfiguration für einen stabilen und performanten Betrieb widerspiegeln. Diese beruhen meist auf den Aussagen der Hersteller und den unzähligen Erfahrungen der Community. Alle diese Erfahrungen, Tipps und Empfehlungen zusammen ergeben dann eine Anleitung, wie ein System zu konfigurieren sein sollte. Auch für den SQL Server sind solche Best Practices zu finden und man soll Sie sogar schon in den PASS Regionalgruppen, auf SQL Saturdays und auf der SQL Konferenz gesichtet haben.
Doch leider treten Best Practices auf vielen SQL Server Systemen nur vereinzelt auf. Häufig können jedoch viele Performance- und Stabilitätsprobleme durch die Implementierung der richtigen Best Practices beseitigt werden.
Von den BIOS Einstellungen, über die Windows Settings bis hin zum SQL Server möchte ich aufzeigen, was bei einer SQL Server Installation zu beachten ist und wie ein SQL Server stabil und performant nach Best Practices eingerichtet werden
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Administration

Level: Beginner

Session Code: DEUTSCH

Date: April 01

Time: 11:00 AM - 12:00 PM

Room: Profisee

SSIS is a powerful tool for extracting, transforming and loading data, but creating and maintaining a large number of SSIS packages can be both tedious and time-consuming. Even if you use templates and follow best practices you often have to repeat the same steps over and over and over again. Handling metadata and schema changes is a manual process, and there are no easy ways to implement new requirements in multiple packages at the same time.

It is time to bring the Don't Repeat Yourself (DRY) software engineering principle to SSIS projects. First learn how to use Biml and BimlScript to generate SSIS packages from database metadata and implement changes in all packages with just a few clicks. Then take the DRY principle one step further and learn how to update all packages in multiple projects by separating and reusing common code. 

Speed up your SSIS development by using Biml and BimlScript, and see how you can complete in a day what once took more than a week!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: April 01

Time: 1:00 PM - 2:00 PM

Room: Profisee

Was mehr als 2 mal händisch gemacht werden muss wird automatisiert! Diese Session zeigt in 7 Schritten einen Weg zur automatisierten Datenbankumgebung, präsentiert mit Beispielen und Geschichten aus der Arbeitswelt. Es werden konkrete Anwendungsbeispiele, Tipps und Tricks präsentiert, jedoch liegt der Fokus darauf, eine Bild darüber zu bekommen, wie man den Weg der Automatisierung beschreiten könnte. 

Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Administration

Level: Intermedia

Session Code: DEUTSCH

Date: April 01

Time: 3:30 PM - 4:30 PM

Room: Profisee

Power BI was initialy a Self-Service BI oriented solution. Personal BI can become a nightmare when not managed. Data governance and data stewardship are good practices to avoid dataset-hell and leverage data culture of your company.
In that session, you'll discover ways to manage your Power BI assets by process, organization and some tools like Azure Data Catalog.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: April 01

Time: 3:30 PM - 4:30 PM

Room: Pure Storage

Get a comprehensive overview of the Microsoft Azure Data Services (SQL, NoSQL, KeyValue and more). Learn how easy it is to get started and how these services can support you in managing, securing and scaling your data.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud & Big Data

Level: Beginner

Session Code:

Date: April 01

Time: 1:00 PM - 2:00 PM

Room: Microsoft

In this session we'll explore several methods of hacking into SQL Server instances. Some methods assume you have Windows Administrator privileges on the box; others only require access to your physical network. We'll cover SQL injection, memory dumps, man-in-the-middle, pass-the-hash, and other attack vectors. Armed with this knowledge, you should be able to go back to your job and make a difference in your network security.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Administration

Level: Intermedia

Session Code:

Date: April 01

Time: 11:00 AM - 12:00 PM

Room: Pure Storage

Do you know all about heaps, clustered indexes, and nonclustered indexes, but still aren't satisfied? Then this is the session for you! Learn about advanced features such as included columns, indexed views, and filtered indexes. Discover how they are stored on disk and how SQL Server uses them to satisfy queries. Then, see the tools SQL Server hands you to help identify just the right subset of indexes. Finally, get an stunning demonstration of just how badly you can hurt performance by creating too many indexes.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Development

Level: Intermedia

Session Code:

Date: April 01

Time: 3:30 PM - 4:30 PM

Room: Dell Software

This instructor-led lab is a 100% demo/lab show! Attendees have the option to actively follow the instructor during this tour around some of the most interesting Azure SQL DB features. Please bring your own PC if you plan to do the labs by yourself.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud & Big Data

Level: Beginner

Session Code:

Date: April 01

Time: 2:15 PM - 3:15 PM

Room: Microsoft

Session Type:
Lightning Talk (10 minutes)

Track:
Lightning Talks

Level: Intermedia

Session Code: DEUTSCH

Date: April 01

Time: 11:00 AM - 11:10 AM

Room: Dell Software

It’s often difficult to know how your SQL Servers will perform under different loads. By performing load testing, we can gain these key insights, perform modifications to existing configurations, and understand the impact on performance levels.

Come learn about the native tools at our disposal for performing these important load tests and how we can identify when performance levels begin to drop. Using demos of these native tools – including Distributed Replay Utility (DRU), Database Tuning Adviser (DTA), Perfmon, Extended Events, and Profiler – we’ll see how to plan and perform a load test project, gain an understanding of SQL Server’s performance under varying load scenarios, and discover which tell-tale indicators can help alert us to performance degradation.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Administration

Level: Intermedia

Session Code:

Date: April 01

Time: 2:15 PM - 3:15 PM

Room: Dell Software

Focus of this session will be explanation of algorithms available for predictive analytics in Azure Machine Learning service.  Algorithms will be grouped by learning style (Supervised, semi-supervised and unsupervised) and will take a look into 1) regression algorithms, 2) Regularization algorithms, 3) Decision trees algorithms, 4) Naive Bayes algorithms, 5) Dimension reduction algorithms, 6) Associated learning (not Kernel) Algorithms  and 7) Clustering algorithms. With theory explained we will look into data samples and later examples in ML for these algorithms.
Within this session we will explore, which algorithm is used and useful for what kind of empirical problem and which is suitable for particular data-set.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: April 01

Time: 11:00 AM - 12:00 PM

Room: Solid Q

Microsoft Azure is a flexible, open, and secure cloud built for business. Access a broad collection of integrated cloud services that accommodate many languages and operating systems. Join this session to get an introduction into the cloud platform and discover, at a high level, what powerful data and analytics services it provides.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud & Big Data

Level: Beginner

Session Code:

Date: April 01

Time: 11:00 AM - 12:00 PM

Room: Microsoft

„The box is back“ unter diesem Motto standen viele Vorträge auf dem PASS Summit 2015. Was Microsoft damit sagen möchte ist, dass nach den großen Investments in die Cloud Lösungen in den letzten Jahren nun auch wieder in die On-Premises Lösungen und hier insbesondere in den SQL Server investiert wird. In Bezug auf Reporting Services bedeutet dass, das es neue und verbesserte Funktionen gibt. Eine dieser neuen Funktionen stellt die Integration von Datazen Dashboards und KPIs als mobile Berichte in Reporting Services dar. Auch neu ist, dass man Reporting Services Berichte in ein Power BI Dashboard „anpinnen“ kann und dass man nun die Berichtsparameter über dem Bericht anordnen kann. In seiner Session wird Frank über die Neuereungen in Reporting Services 2016 sprechen und diese in zahlreichen Demos präsentieren.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Intermedia

Session Code: DEUTSCH

Date: April 01

Time: 2:15 PM - 3:15 PM

Room: Solid Q

Die Benutzer beschweren sich, dass die Applikation zu langsam ist. Die Entwickler beschuldigen die Datenbank. Wie kann die Ursache für das Performance-Problem gefunden werden?
 
Viel zu oft wird die Datenbank beschuldigt der Grund für Performance- und Skalierbarkeits-Probleme zu sein. In vielen Fällen ist das Problem nicht die Datenbank selbst, sondern vielmehr auf welche Art und Weise die Applikation auf die Datenbank zugreift. Zu den häufigsten Problemen zählen u.a. das Anfordern von zu vielen Daten, ineffiziente SQL Abfragen, schlechte Wahl von Indexen, ...
 
Basierend auf Praxisbeispielen wird gezeigt wie Performance-Probleme analysiert werden können um schneller die Ursache zu ermitteln und das Problem zu lösen.
Based on real life examples, you will learn how to approach performance problems, how to figure out if the database is really to blame and how to end the finger pointing between developers and DBAs.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Development

Level: Beginner

Session Code: DEUTSCH

Date: April 01

Time: 1:00 PM - 2:00 PM

Room: Dell Software

Im SQL Server 2016 hat Microsoft mit Revolution Analytics R eine volle Predictive Suite bzw. Bibliothek in die Standard Datenbank inkludiert. Mit R kann man allerlei Berechnungen, Analysen und vor allem Prognosen erstellen. Wie kann ich mit diesem Werkzeug Nutzen aus meinen Daten ziehen? Wo finde ich wirklich relevante Zusammenhänge in den Daten, wie kann ich diese Zusammenhänge in der Datenbank nutzen? Diese Session bietet einen kurzen Einstieg in die Welt von R mit Rattle, dem Tool zur einfachen und auch komplexen Analyse von Daten. Darauf aufbauend wird aus den Ergebnissen ein Modell generiert und in der Datenbank implementiert. Der Focus dieser Session liegt in der Arbeit mit R und den Daten.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud & Big Data

Level: Intermedia

Session Code: DEUTSCH

Date: April 01

Time: 1:00 PM - 2:00 PM

Room: Pure Storage

SQL Server 2014 introduces Extreme Transaction Processing, a brand new memory-optimized data management feature, targetting OLTP workloads. In this session you will learn about two new, and not very well known, features that you can use to share sets of data between modules - either within the database, or between client applications and databases:
- Memory-optimized Table Variables; and
- Memory-optimized Table-valued Parameters.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Development

Level: Advanced

Session Code:

Date: April 01

Time: 2:15 PM - 3:15 PM

Room: Profisee

Since 2012, SQL Server Analysis Services has two engines: Tabular and Multidimensional. Somebody believes Multidimensional is granny stuff and aim to learn only Tabular. Somebody trust only the good-old well-debugged code of Multidimensional, and ignores Tabular. We try to use a more informed approach: by looking at the difference in features, hardware requirements, scalability, required knowledge and business needs, we will discuss which engine to use for different kinds of projects. The goal is to teach when to use what, and to avoid the common (and very expensive) mistake of choosing the wrong technology.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: April 01

Time: 4:45 PM - 5:45 PM

Room: Solid Q

Transaction is running slow! How many times have you seen this message on your production system or heard it from users? It’s time to isolate and resolve these issues!

Typical reasons for transaction delays include slow transaction logs, page splits, blocking, over-indexing, and even some configuration settings of your database or instance. Query-tuning tips are slightly different than those for transactions, and this session is about OLTP performance troubleshooting. See some typical scenarios of transaction delays and the reasons behind them. This session will help you in your performance troubleshooting efforts and improve your level of confidence. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Administration

Level: Intermedia

Session Code:

Date: April 01

Time: 4:45 PM - 5:45 PM

Room: Dell Software

Proper design of cubes, dimensions, hierarchies and attributes is critical to optimal performance of SQL Server Analysis Services solutions.

I've collected a number of best practices during the years I've spent on building and maintaining OLAP cubes. In this session, we will go through the most important ten of these, so you can consider them in your everyday work when you build analytical back-end solutions with SSAS. Join this session, and see how these tips and best practices can save your precious time.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: April 01

Time: 2:15 PM - 3:15 PM

Room: Dell Software

Sessions Found: 24
Back to Top cage-aids
cage-aids
cage-aids
cage-aids