sqlsathistory

Nr: 494

Back to Main list

SQLSaturday #494 - Vienna 2016

Start Time (24h)	Speaker	Track	Title
11:00:00	Andre Essing	Administration	Best Practices – Jeder kann sie haben, die perfekte SQL Server Installation
11:00:00	Tomaž Kaštrun	Business Intelligence	Microsoft Azure Machine Learning Algorithms
11:00:00	Markus Ehrenmueller-Jensen	Lightning Talks	Lightning Talks
11:00:00	Oliver Lintner	Cloud Big Data	Microsoft Azure Overview
11:00:00	Argenis Fernandez	Administration	Hacking Into SQL Server for Fun and Profit
13:00:00	Mark Broadbent	Administration	Ye Olde Cluster Curiosity Shoppe - A miscellany of SQL Clustering top tips
13:00:00	Sonja Chevre	Development	Performance: Es ist nicht immer die Datenbank schuld!
13:00:00	Mario Schnalzenberger	Cloud Big Data	R, Rattle und SQL Server 2016
13:00:00	Cathrine Wilhelmsen	Business Intelligence	Biml for Beginners: Speed up your SSIS development
13:00:00	Oliver Lintner	Cloud Big Data	Getting started with Microsoft Azure Data Services
14:15:00	Zoltán Horváth	Business Intelligence	Top 10 SSAS Solution Design Best Practices
14:15:00	Frank Geisler	Business Intelligence	Neuigkeiten zu Reporting Services 2016
14:15:00	Neil Hambly	Administration	Load Testing With SQL Server Tools
14:15:00	Marcel Franke	Cloud Big Data	Azure SQL Database vs. Azure SQL Data Warehouse
14:15:00	Oliver Lintner	Cloud Big Data	Instructor-Led Lab: Azure SQL DB in Action
15:30:00	Jen Stirrup	Business Intelligence	What a boozy day at the Guinness factory teaches us about Analytics
15:30:00	Hugo Kornelis	Development	Indexes, beyond the basics
15:30:00	Markus Wagner	Administration	[Der faule DBA
15:30:00	Jean-Pierre Riehl	Business Intelligence	From Personal BI to Managed BI with Power BI
16:45:00	Brent Ozar	Development	Watch Brent Tune Queries
16:45:00	Klaus Aschenbrenner	Development	UNIQUEIDENTIFIER als Prim#228;rschl#252;ssel im SQL Server
16:45:00	Margarita Naumova	Administration	The Top 8 Reasons for Your Transaction Performance Problems
16:45:00	Alberto Ferrari	Business Intelligence	Tabular vs. Multidimensional in SQL Server Analysis Services

SessionID: 41945

Best Practices – Jeder kann sie haben, die perfekte SQL Server Installation

Back to calendar

Event Date: 01-04-2016 - Session time: 11:00:00 - Track: Administration

Speaker: Andre Essing

Title: Best Practices – Jeder kann sie haben, die perfekte SQL Server Installation

Abstract:

Best Practices sind Empfehlungen, die eine optimale Systemkonfiguration f#252;r einen stabilen und performanten Betrieb widerspiegeln. Diese beruhen meist auf den Aussagen der Hersteller und den unz#228;hligen Erfahrungen der Community. Alle diese Erfahrungen, Tipps und Empfehlungen zusammen ergeben dann eine Anleitung, wie ein System zu konfigurieren sein sollte. Auch f#252;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#228;ufig k#246;nnen jedoch viele Performance- und Stabilit#228;tsprobleme durch die Implementierung der richtigen Best Practices beseitigt werden. Von den BIOS Einstellungen, #252;ber die Windows Settings bis hin zum SQL Server m#246;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

SessionID: 43114

Microsoft Azure Machine Learning Algorithms

Back to calendar

Event Date: 01-04-2016 - Session time: 11:00:00 - Track: Business Intelligence

Speaker: Tomaž Kaštrun

Title: Microsoft Azure Machine Learning Algorithms

Abstract:

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.

SessionID: 45687

Lightning Talks

Back to calendar

Event Date: 01-04-2016 - Session time: 11:00:00 - Track: Lightning Talks

Speaker: Markus Ehrenmueller-Jensen

Title: Lightning Talks

Abstract:

F#252;nf zehnmin#252;tige Kurz-Vortr#228;ge. Agenda folgt.

SessionID: 48574

Microsoft Azure Overview

Back to calendar

Event Date: 01-04-2016 - Session time: 11:00:00 - Track: Cloud Big Data

Speaker: Oliver Lintner

Title: Microsoft Azure Overview

Abstract:

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.

SessionID: 49305

Hacking Into SQL Server for Fun and Profit

Back to calendar

Event Date: 01-04-2016 - Session time: 11:00:00 - Track: Administration

Speaker: Argenis Fernandez

Title: Hacking Into SQL Server for Fun and Profit

Abstract:

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.

SessionID: 41953

Ye Olde Cluster Curiosity Shoppe - A miscellany of SQL Clustering top tips

Back to calendar

Event Date: 01-04-2016 - Session time: 13:00:00 - Track: Administration

Speaker: Mark Broadbent

Title: Ye Olde Cluster Curiosity Shoppe - A miscellany of SQL Clustering top tips

Abstract:

Welcome to the strange and mysterious world of SQL Server Failover-Clustering and enter Ye Olde Cluster Curiosity Shoppe where we will reveal a miscellany of top tips, tricks and advice gained from nearly two decades of installing and troubleshooting SQL Clusters.

Roll-up roll-up! Come and see: The Shrunken Head; The Bearded Lady; Many Headed Cluster; The Marie Celeste; The Zombie; Installation of Death; The Bodysnatcher; Montezuma’s Revenge ...and many more exhibits and top tips from the field.

SessionID: 42580

Performance: Es ist nicht immer die Datenbank schuld!

Back to calendar

Event Date: 01-04-2016 - Session time: 13:00:00 - Track: Development

Speaker: Sonja Chevre

Title: Performance: Es ist nicht immer die Datenbank schuld!

Abstract:

Die Benutzer beschweren sich, dass die Applikation zu langsam ist. Die Entwickler beschuldigen die Datenbank. Wie kann die Ursache f#252;r das Performance-Problem gefunden werden?

Viel zu oft wird die Datenbank beschuldigt der Grund f#252;r Performance- und Skalierbarkeits-Probleme zu sein. In vielen F#228;llen ist das Problem nicht die Datenbank selbst, sondern vielmehr auf welche Art und Weise die Applikation auf die Datenbank zugreift. Zu den h#228;ufigsten Problemen z#228;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#246;nnen um schneller die Ursache zu ermitteln und das Problem zu l#246;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.

SessionID: 44142

R, Rattle und SQL Server 2016

Back to calendar

Event Date: 01-04-2016 - Session time: 13:00:00 - Track: Cloud Big Data

Speaker: Mario Schnalzenberger

Title: R, Rattle und SQL Server 2016

Abstract:

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#228;nge in den Daten, wie kann ich diese Zusammenh#228;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.

SessionID: 44240

Biml for Beginners: Speed up your SSIS development

Back to calendar

Event Date: 01-04-2016 - Session time: 13:00:00 - Track: Business Intelligence

Speaker: Cathrine Wilhelmsen

Title: Biml for Beginners: Speed up your SSIS development

Abstract:

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!

SessionID: 48575

Getting started with Microsoft Azure Data Services

Back to calendar

Event Date: 01-04-2016 - Session time: 13:00:00 - Track: Cloud Big Data

Speaker: Oliver Lintner

Title: Getting started with Microsoft Azure Data Services

Abstract:

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.

SessionID: 41915

Top 10 SSAS Solution Design Best Practices

Back to calendar

Event Date: 01-04-2016 - Session time: 14:15:00 - Track: Business Intelligence

Speaker: Zoltán Horváth

Title: Top 10 SSAS Solution Design Best Practices

Abstract:

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.

SessionID: 41918

Neuigkeiten zu Reporting Services 2016

Back to calendar

Event Date: 01-04-2016 - Session time: 14:15:00 - Track: Business Intelligence

Speaker: Frank Geisler

Title: Neuigkeiten zu Reporting Services 2016

Abstract:

„The box is back“ unter diesem Motto standen viele Vortr#228;ge auf dem PASS Summit 2015. Was Microsoft damit sagen m#246;chte ist, dass nach den gro#223;en Investments in die Cloud L#246;sungen in den letzten Jahren nun auch wieder in die On-Premises L#246;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 #252;ber dem Bericht anordnen kann. In seiner Session wird Frank #252;ber die Neuereungen in Reporting Services 2016 sprechen und diese in zahlreichen Demos pr#228;sentieren.

SessionID: 41928

Load Testing With SQL Server Tools

Back to calendar

Event Date: 01-04-2016 - Session time: 14:15:00 - Track: Administration

Speaker: Neil Hambly

Title: Load Testing With SQL Server Tools

Abstract:

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.

SessionID: 42968

Azure SQL Database vs. Azure SQL Data Warehouse

Back to calendar

Event Date: 01-04-2016 - Session time: 14:15:00 - Track: Cloud Big Data

Speaker: Marcel Franke

Title: Azure SQL Database vs. Azure SQL Data Warehouse

Abstract:

Microsoft hat f#252;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#252;ber einem SQL Server On-Premise unterscheiden. Wir werden weiterhin auf Themen wie Skalierbarkeit, Performance und Kosten eingehen.

SessionID: 48576

Instructor-Led Lab: Azure SQL DB in Action

Back to calendar

Event Date: 01-04-2016 - Session time: 14:15:00 - Track: Cloud Big Data

Speaker: Oliver Lintner

Title: Instructor-Led Lab: Azure SQL DB in Action

Abstract:

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.

SessionID: 42074

What a boozy day at the Guinness factory teaches us about Analytics

Back to calendar

Event Date: 01-04-2016 - Session time: 15:30:00 - Track: Business Intelligence

Speaker: Jen Stirrup

Title: What a boozy day at the Guinness factory teaches us about Analytics

Abstract:

Anyone who can type commands into R but that does not mean that can 'do' statistics for analytics. They may even misuse those methods, and it's an entirely different thing to really understand what’s happening. This is vital, because this knowledge is what really drives each phase of your analysis and create effective models for the business to use in order to create actionable insights. It can be difficult to see when someone is building faulty statistical models, especially when their intentions are good, and their results look pretty! Results are important, and it's down to you to create models that are sound and robust.

Drinking Guinness is optional, but admittedly might be preferred for this intensive session.

In this session, we will look at modeling techniques in Predictive Analytics using R, using our boozy day at the Guinness factory as a backdrop to understanding why statistical learning is important for analytics today.

SessionID: 42620

Indexes, beyond the basics

Back to calendar

Event Date: 01-04-2016 - Session time: 15:30:00 - Track: Development

Speaker: Hugo Kornelis

Title: Indexes, beyond the basics

Abstract:

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.

SessionID: 44385

Der faule DBA | 7 Schritte zu einer automatisierten Datenbankumgebung

Back to calendar

Event Date: 01-04-2016 - Session time: 15:30:00 - Track: Administration

Speaker: Markus Wagner

Title: Der faule DBA | 7 Schritte zu einer automatisierten Datenbankumgebung

Abstract:

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

SessionID: 44458

From Personal BI to Managed BI with Power BI

Back to calendar

Event Date: 01-04-2016 - Session time: 15:30:00 - Track: Business Intelligence

Speaker: Jean-Pierre Riehl

Title: From Personal BI to Managed BI with Power BI

Abstract:

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.

SessionID: 41966

Watch Brent Tune Queries

Back to calendar

Event Date: 01-04-2016 - Session time: 16:45:00 - Track: Development

Speaker: Brent Ozar

Title: Watch Brent Tune Queries

Abstract:

You’re in a dark room with an ugly query. What do you do next? Microsoft Certified Master Brent Ozar shares his time-tested method of tuning queries starting with simplifying, analyzing the execution plan, making index tweaks, and measuring improvements with statistics. You’ll learn a repeatable process you can use to make queries go faster.

SessionID: 42324

UNIQUEIDENTIFIER als Prim#228;rschl#252;ssel im SQL Server

Back to calendar

Event Date: 01-04-2016 - Session time: 16:45:00 - Track: Development

Speaker: Klaus Aschenbrenner

Title: UNIQUEIDENTIFIER als Prim#228;rschl#252;ssel im SQL Server

Abstract:

Ob es eine Best-Practice ist, einen UNIQUEIDENTIFIER als Prim#228;rschl#252;ssel im SQL Server zu verwenden - dar#252;ber kann man streiten. UNIQUEIDENTIFIER haben eine Vielzahl unterschiedlicher Vorteile aus einer Entwickler-Perspektive, aber aus der Administrations-Perspektive verursachen sie eine Vielzahl unterschiedlicher Performance Probleme. Im Rahmen dieses Vortrags werden wir uns dem UNIQUEIDENTIFIER als Prim#228;rschl#252;ssel widmen, und Sie werden Schritt f#252;r Schritt sehen, in welche Performance-Fallen Sie laufen k#246;nnen, wenn Sie nicht genau aufpassen. Zus#228;tzlich bekommen Sie eine Reihe unterschiedlicher Tipps, die Ihnen die tagt#228;gliche Arbeit mit dem UNIQUEIDENTIFER als Prim#228;rschl#252;ssel erleichtern werden.

SessionID: 44462

The Top 8 Reasons for Your Transaction Performance Problems

Back to calendar

Event Date: 01-04-2016 - Session time: 16:45:00 - Track: Administration

Speaker: Margarita Naumova

Title: The Top 8 Reasons for Your Transaction Performance Problems

Abstract:

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.

SessionID: 45688

Tabular vs. Multidimensional in SQL Server Analysis Services

Back to calendar

Event Date: 01-04-2016 - Session time: 16:45:00 - Track: Business Intelligence

Speaker: Alberto Ferrari

Title: Tabular vs. Multidimensional in SQL Server Analysis Services

Abstract:

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.

This site is open source. Improve this page.