Nr: 555
SQLSaturday #555 - Munich 2016
| Start Time (24h) |
Speaker |
Track |
Title |
| 09:15:00 |
Bent Pedersen |
Cloud Big Data |
Hybrid BI [EN] |
| 09:15:00 |
Gabi Münster |
Business Intelligence (BI) |
Scoped assignments – Fluch oder Segen? Beispiele aus der Praxis... [DE] |
| 09:15:00 |
William Durkin |
Administration (DBA) |
SQL Server Replication - What, How and Why [EN] |
| 09:15:00 |
Niko Neugebauer |
Development (DEV-OPS) |
Columnstore Technology Improvements in SQL Server 2016 [DE] |
| 10:45:00 |
Uwe Ricken |
Development (DEV-OPS) |
Daily problems with indexing and its - possible - solution [DE] |
| 10:45:00 |
Andre Essing |
Administration (DBA) |
SQL Server Security – Netzwerkkabel ziehen ist keine Lösung [DE] |
| 10:45:00 |
Kenneth Nielsen |
Cloud Big Data |
Azure Data Lake Store / Analytics 101 [EN] |
| 10:45:00 |
Regis Baccaro |
Business Intelligence (BI) |
Kerberos for BI [EN] |
| 12:00:00 |
Marcel Tilly |
Cloud Big Data |
Heute in der Suppenküche: Cognitive Services Allerlei [DE] |
| 12:00:00 |
Ryan Yates |
Administration (DBA) |
Why and how to Implement PowerShell DSC for SQL Server [EN] |
| 12:00:00 |
Oliver Engels |
Business Intelligence (BI) |
2016! Data transformation with M, SSIS, POLY, ADF, ADLA, R [DE] |
| 12:00:00 |
Kalen Delaney |
Development (DEV-OPS) |
Are You Optimistic About Concurrency? [EN] |
| 13:30:00 |
Ben Weissman |
Sponsor Session |
Das ultimative Solisyon SQL Quiz [DE] |
| 13:30:00 |
Gabi Münster |
Women in Technology |
Women in Technology – Still a Rarity. Any Ideas? [EN] |
| 13:30:00 |
Heiko Böhm |
Sponsor Session |
Maximierung Ihres Investments in Microsoft mit Pyramid Analytics |
| 14:30:00 |
Markus Ehrenmueller-Jensen |
Administration (DBA) |
Are You a DBA by Accident? Welcome to the Club! [DE] |
| 14:30:00 |
Hugo Kornelis |
Development (DEV-OPS) |
T-SQL User-Defined Functions, or: Bad Performance Made Easy [EN] |
| 14:30:00 |
Benjamin Kettner |
Business Intelligence (BI) |
Advanced Analytics im ERP-Umfeld [DE] |
| 14:30:00 |
Scott Klein |
Cloud Big Data |
Fun with SQL Server 2016 Stretch Database, Temporal Always Encrypted [EN] |
| 15:45:00 |
Dejan Sarka |
Cloud Big Data |
Using R in SQL Server, Power BI, and Azure ML [EN] |
| 15:45:00 |
Ben Weissman |
Business Intelligence (BI) |
Biml Rezepte für SSIS - Best Practices für das nächste Level [DE] |
| 15:45:00 |
André Melancia |
Administration (DBA) |
NSA Secrets - Hacking SQL Server [EN] |
| 15:45:00 |
Ralph Kemperdick |
Development (DEV-OPS) |
Scenarios and value proposition for JSON data enabled in Azure SQ |
| 17:15:00 |
Gerhard Brueckl |
Cloud Big Data |
Deep-Dive into Polybase of SQL Server 2016 [DE] |
| 17:15:00 |
Miloš Radivojević |
Development (DEV-OPS) |
What Application Developers Should Know About SQL Server? [DE] |
| 17:15:00 |
Wolfgang Strasser |
Business Intelligence (BI) |
Bauer BI und seine Pig Data [DE] |
| 17:15:00 |
André Kamman |
Administration (DBA) |
Powershell community scripts for DBAs [EN] |
SessionID: 50159
Hybrid BI [EN]
Event Date: 08-10-2016 - Session time: 09:15:00 - Track: Cloud Big Data
Speaker: Bent Pedersen
Title: Hybrid BI [EN]
Abstract:
When working with a hybrid platform your organisation will be able to select strategy and features based on the highest ROI. During this session I will go through three different aspects of Hybrid BI which is infrastructure, data-storage and reporting.
As part of this i will go through the advantages and disadvantages of each area to supply you with the information you need to choose the right direction for your platform.
SessionID: 52296
Scoped assignments – Fluch oder Segen? Beispiele aus der Praxis... [DE]
Event Date: 08-10-2016 - Session time: 09:15:00 - Track: Business Intelligence (BI)
Speaker: Gabi Münster
Title: Scoped assignments – Fluch oder Segen? Beispiele aus der Praxis... [DE]
Abstract:
Gerade mulitdimensionale Lösungen können so komplex werden. Die Möglichkeiten sind vielfältig und mit zunehmender Komplexität wird es immer schwieriger, die Auswirkungen einer Änderung zu testen. Diese Session kann das Problem auch nicht lösen, aber an konkreten Praxisbeispielen Probleme und Lösungsmöglichkeiten aufzeigen.
SessionID: 52757
SQL Server Replication - What, How and Why [EN]
Event Date: 08-10-2016 - Session time: 09:15:00 - Track: Administration (DBA)
Speaker: William Durkin
Title: SQL Server Replication - What, How and Why [EN]
Abstract:
In an AlwaysOn world we focus on entire databases being highly available. However, replication offers another, arguably more powerful, way to make data available on multiple servers/locations that steps outside of "normal" High Availability scenarios.
This session will explain what database replication is, what the different parts are that make up the replication architecture and when/why you would use replication. You will leave the session with an understanding of how you can leverage this feature to achieve solutions that are not possible using other High Availability features.
The content will be valid for all versions of SQL Server from 2005 onward.
SessionID: 53445
Columnstore Technology Improvements in SQL Server 2016 [DE]
Event Date: 08-10-2016 - Session time: 09:15:00 - Track: Development (DEV-OPS)
Speaker: Niko Neugebauer
Title: Columnstore Technology Improvements in SQL Server 2016 [DE]
Abstract:
Columnstore Technology has received one of the biggest number of improvements across all SQL Server 2016 technologies. Discover Operational Analytics and InMemory Analytics for the OLTP workloads with updatable Nonclustered Columnstore Indexes, Data Warehousing with vastly enhanced Clustered Columnstore Index that now can have all the typical functionalities of a well-designed amp; high performing database such as Unique Constraints, Foreign Keys and Secondary Indexes. Discover all the maintenance improvements that will allow to operate and manipulate the Columnstore structures with more precision and insights.
SessionID: 49787
Daily problems with indexing and its - possible - solution [DE]
Event Date: 08-10-2016 - Session time: 10:45:00 - Track: Development (DEV-OPS)
Speaker: Uwe Ricken
Title: Daily problems with indexing and its - possible - solution [DE]
Abstract:
Have you ever been in the situation that an application performed well the last day and - suddenly - you run into problems? Although you have Index Maintenance jobs and statistics up to date you will monitor a big degrade of performance! This session will demonstrate in a over 80 percent demo based presentation the following scenarios which happend this way in real life!
- Why performance degradation in spite of maintenance jobs?
- just one more database in the result set and the query runs really bad - why?
- usage of literals is completely different from the usage of variables - why?
- identical data types but the query runs in part perfect and in part bad...
- your execution plan shows an INDEX SEEK - but the table will be scanned!
- you get a query from the business which performs really bad but when you test it it runs pretty cool - why?
SessionID: 50051
SQL Server Security – Netzwerkkabel ziehen ist keine Lösung [DE]
Event Date: 08-10-2016 - Session time: 10:45:00 - Track: Administration (DBA)
Speaker: Andre Essing
Title: SQL Server Security – Netzwerkkabel ziehen ist keine Lösung [DE]
Abstract:
Schon lange ist Sicherheit in der IT ein Thema mit hohem Stellenwert. Dabei steht der Schutz der unternehmenseigenen Daten und der Daten der Kunden an oberster Stelle. Doch wie Schütze ich meine Daten? Die Absicherung der Applikationen, Berechtigungen und Secure Code ist nur ein Teil eines sicheren Systems. Des Weiteren gehört auch die Absicherung der Infrastruktur und des SQL Servers selbst zu einem sicheren System.
Der SQL Server liefert hier eine Vielzahl an Funktionen, welche mit SQL Server 2016 sogar noch um interessante Features wie Always Encrypted, Row Level Security oder Data Masking erweitert werden.
Diese Session bietet einen Überblick über die wichtigsten Security Features des SQL Servers und anhand eines realen Beispiels durchleuchten wir die Absicherung der SQL Server Landschaft.
SessionID: 53285
Azure Data Lake Store / Analytics 101 [EN]
Event Date: 08-10-2016 - Session time: 10:45:00 - Track: Cloud Big Data
Speaker: Kenneth Nielsen
Title: Azure Data Lake Store / Analytics 101 [EN]
Abstract:
In this session we take a look and a deep dive into Aure Data Lake, a new feature on Azure that will enable amost anyone to work with BIG DATA. It combines C# and SQL to a language that is way more intuitive than what we are used to.
Azure Data Lake Store, our new repository for data of various origins – we can collect, store and share data from this lake as we see fit. Azure Data Lake Analytics, a new way to scale and use your analytics on AZURE and BIG Data, it introduces U-SQL a new language combined of C# and T-SQL to make the task of analyzing BIG Data easier and more comprehendible. Azure Data Lake Tools for Visual Studio, provide an integrated development environment that spans the Azure Data Lake, dramatically simplifying authoring, debugging and optimization for processing and analytics at any scale. After this session, you will have an understanding of the new feature, and will hopefully be inspired to use it either in a Proof Of Concept or in a Production scenario.
SessionID: 53664
Kerberos for BI [EN]
Event Date: 08-10-2016 - Session time: 10:45:00 - Track: Business Intelligence (BI)
Speaker: Regis Baccaro
Title: Kerberos for BI [EN]
Abstract:
Have you ever seen this message quot;Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGONquot; ?
Have you ever witnessed Kerberos mentioned in a conversation - or in a forum - and seen developers shiver, sysadmins crawl back under their rock and project managers fear for the consumed hours ?
Have you ever wondered why it seems so complicated ?
If you answered yes to any of these question then this demo-packed session is for you.
Because Kerberos is something that anyone who must deploy SQL Server wishes they didn’t have to worry about. It truly affects all aspects of SQL Server including the engine, Reporting Services, Analysis Services, SharePoint and PowerPivot. Furthermore we will have a close look at how to diagnose problems and troubleshoot the three-headed beast when it breaks loose.
This session is based on many hours spent sweating in setting up Kerberos in BI and SharePoint environments and explaining support people how to troubleshoot and fix Kerberos issues when they a
SessionID: 50166
Heute in der Suppenküche: Cognitive Services Allerlei [DE]
Event Date: 08-10-2016 - Session time: 12:00:00 - Track: Cloud Big Data
Speaker: Marcel Tilly
Title: Heute in der Suppenküche: Cognitive Services Allerlei [DE]
Abstract:
SessionID: 50901
Why and how to Implement PowerShell DSC for SQL Server [EN]
Event Date: 08-10-2016 - Session time: 12:00:00 - Track: Administration (DBA)
Speaker: Ryan Yates
Title: Why and how to Implement PowerShell DSC for SQL Server [EN]
Abstract:
Believe me when I say that I am no SQL Expert but this session will leave those that attend in a position to go away and look to implement this in their organisation and really reap the benefits that managing your Infrastructure as Code brings to a flexible an more maintainable environment.
This session will also briefly cover the other core necessities that will be required to get this underway which include the importance of Source Control for the configurations, Community Developed Resources more.
SessionID: 52528
Event Date: 08-10-2016 - Session time: 12:00:00 - Track: Business Intelligence (BI)
Speaker: Oliver Engels
Abstract:
In this comparison you will find "M" (Power Query Language), SSIS (Integration Services), POLY (Polybase integration in SQL Server 2016), ADF (Azure Data Factory), ADLA (Azure Data Lake Analytics / U-SQL) and R (the Statistical Scripting Language that ships now with SQL 2016)
This gives you a good starting point for new data transformation projects or to review existing under the new approaching technologies.
SessionID: 53559
Are You Optimistic About Concurrency? [EN]
Event Date: 08-10-2016 - Session time: 12:00:00 - Track: Development (DEV-OPS)
Speaker: Kalen Delaney
Title: Are You Optimistic About Concurrency? [EN]
Abstract:
What exactly does it mean to have optimistic concurrency? What is the alternative? Is SQL Server 2012#39;s SNAPSHOT Isolation optimistic? How can SQL Server 2014’s In-Memory OLTP provide truly optimistic concurrency? In this session, we’ll look at what guarantees the various isolation levels provide, the difference between pessimistic and optimistic concurrency, and the new data structures in SQL Server 2014 that allow the enormous benefits of having totally in-memory storage with no waiting!
SessionID: 53148
Das ultimative Solisyon SQL Quiz [DE]
Event Date: 08-10-2016 - Session time: 13:30:00 - Track: Sponsor Session
Speaker: Ben Weissman
Title: Das ultimative Solisyon SQL Quiz [DE]
Abstract:
Um nach dem Mittagessen wieder langsam wach zu werden, veranstalten wir mit euch das ultimative SQL Quiz - freut euch auf Fragen um alles rund um den SQL Server aus verschiedensten Kategorien!
SessionID: 54069
Women in Technology – Still a Rarity. Any Ideas? [EN]
Event Date: 08-10-2016 - Session time: 13:30:00 - Track: Women in Technology
Speaker: Gabi Münster
Title: Women in Technology – Still a Rarity. Any Ideas? [EN]
Abstract:
The proportion of women in the IT sector keeps to be below other occupational areas, even compared to other technical professions. A number of actions to positively influence this situation have been initiated by politics as well as private economy. But is this really enough?
The goal of this session is to provide you with information regarding those activities and concepts. But even more important: We want to get your feedback. How are your experiences as a woman in technology, as a colleague, as an employer…? What are your hopes and expectations? How do you see the role of PASS in this context? Do you have any ideas, proposals, criticism for us?
SessionID: 54070
Maximierung Ihres Investments in Microsoft mit Pyramid Analytics
Event Date: 08-10-2016 - Session time: 13:30:00 - Track: Sponsor Session
Speaker: Heiko Böhm
Title: Maximierung Ihres Investments in Microsoft mit Pyramid Analytics
Abstract:
Zahlreichen branchenführenden Unternehmen ist es bereits gelungen, ihre Geschäftsabläufe von „datenblind“ auf „datengestützt“ umzustellen. Der Business Intelligence (BI)-Bereich wächst zweistellig.
Erfahren Sie in diesem Vortrag, wie Sie mit BI Office Ihr Investment in Microsoft optimieren können und zu einem datengestützten Unternehmen werden. Sehen Sie, wie dies mit Microsofts Power BI zusammenspielt. Hören Sie dazu auch hilfreiche Praxisbeispiele.
SessionID: 49799
Are You a DBA by Accident? Welcome to the Club! [DE]
Event Date: 08-10-2016 - Session time: 14:30:00 - Track: Administration (DBA)
Speaker: Markus Ehrenmueller-Jensen
Title: Are You a DBA by Accident? Welcome to the Club! [DE]
Abstract:
• Disaster Recovery and Failover
• Database Maintenance
• Capacity Management
• Job Performance Monitoring
In this session I will invite you to discuss the pros cons of the solutions I came up with and you will leave the session with helpful concepts and scripts which you can use freely.
SessionID: 49862
Event Date: 08-10-2016 - Session time: 14:30:00 - Track: Development (DEV-OPS)
Speaker: Hugo Kornelis
Abstract:
The reason is performance. In this session, you will learn how user-defined functions feed the optimizer with misleading and insufficient information, how the optimizer fails to use even what little information it has, and how this can lead to shocking query performance.
However, you will also see that there is a way to avoid the problems. With just a little extra effort, you can reap the benefits of code encapsulation and reuse, and still get good performance.
SessionID: 52700
Advanced Analytics im ERP-Umfeld [DE]
Event Date: 08-10-2016 - Session time: 14:30:00 - Track: Business Intelligence (BI)
Speaker: Benjamin Kettner
Title: Advanced Analytics im ERP-Umfeld [DE]
Abstract:
Mit dem SQL Server 2016 wurden im Bereich Analytics durch die Integration von R neue M#246;glichkeiten geschaffen. Die Integration von R in den SQL Server bietet dabei M#246;glichkeiten, die weit #252;ber Ad-Hoc Analysen hinaus gehen.
In der Session zeigen wir, wie man ein Vorhersagemodell in R in eine Standard-Software-L#246;sung integriert. Daf#252;r haben wir eine Vorhersage f#252;r eine Kennzahl im ERP der Firma abas auf Basis von reellen Unternehmensdaten entwickelt und in die L#246;sung integriert. Zus#228;tzlich pr#228;sentieren wir den konkreten Weg zur Entwicklung des Vorhersagemodells sowie die Integration in abas ERP.
SessionID: 53678
Fun with SQL Server 2016 Stretch Database, Temporal Always Encrypted [EN]
Event Date: 08-10-2016 - Session time: 14:30:00 - Track: Cloud Big Data
Speaker: Scott Klein
Title: Fun with SQL Server 2016 Stretch Database, Temporal Always Encrypted [EN]
Abstract:
Your cold data growth is getting out of control, storage consumption is increasing faster than your budget, your end-users won't (or can't) tell you what can delete or truncate, but they demand their cold or archived data always be online and available. Now you have tables so big that you dread re-indexing, and you have to look for ever more creative solutions to manage this data, while still remaining compliant. There’s a solution that lets you take advantage of the Cloud, on your terms, all without impacting your existing end-user applications or queries. Come find out how you can move your data securely and transparently, free up disc space and reduce your enterprise storage consumption, while retaining full control from the on-premises SQL Server. You’ll reduce maintenance operations time and resources, plus lower overall cost. Learn how SQL Server Stretch database will simplify your journey to the Cloud!
SessionID: 49804
Using R in SQL Server, Power BI, and Azure ML [EN]
Event Date: 08-10-2016 - Session time: 15:45:00 - Track: Cloud Big Data
Speaker: Dejan Sarka
Title: Using R in SQL Server, Power BI, and Azure ML [EN]
Abstract:
In SQL Server, Azure ML, and Power BI suites, you can find nearly anything you need for analyzing your data. SQL Server 2016 closes one of the last gaps - support for statistics beyond basic aggregate functions and support for other mathematical calculations. This is done with support for the R code inside SQL Server Database Engine. This session goes beyond showing the basics, i.e. how to use R in the Database Engine, Power BI and Reporting Services reports, and to enhance Azure ML; it shows and explains also some advanced statistical and matrix calculations.
SessionID: 52657
Biml Rezepte für SSIS - Best Practices für das nächste Level [DE]
Event Date: 08-10-2016 - Session time: 15:45:00 - Track: Business Intelligence (BI)
Speaker: Ben Weissman
Title: Biml Rezepte für SSIS - Best Practices für das nächste Level [DE]
Abstract:
sowie die Inkrementelle #220;bernahme von #196;nderungen in eine Staging Area. Den verwendeten Beispielcode gibt es nat#252;rlich direkt zum mitnehmen, selbst ausprobieren und weiterentwickeln.
SessionID: 53111
NSA Secrets - Hacking SQL Server [EN]
Event Date: 08-10-2016 - Session time: 15:45:00 - Track: Administration (DBA)
Speaker: André Melancia
Title: NSA Secrets - Hacking SQL Server [EN]
Abstract:
How easy is it to hack a SQL Server?
In this session we'll see a few examples on how to exploit SQL Server, modify data and take control, while at the same time not leaving a trace.
We'll start by gaining access to a SQL Server (using some "creative" ways of making man-in-the-middle attacks), escalating privileges and tampering with data at the TDS protocol level (e.g. changing your income level and reverting without a trace after payment), and more.
Most importantly, we'll also cover recommendations on how to avoid these attacks, and take a look at the pros and cons of new security features in SQL Server 2016.
This is a demo-driven session, suited for DBAs, developers and security consultants (Jedi level).
Disclaimer: No actual state secrets will be revealed. Please do not send agents to my house again.
SessionID: 53800
Scenarios and value proposition for JSON data enabled in Azure SQ
Event Date: 08-10-2016 - Session time: 15:45:00 - Track: Development (DEV-OPS)
Speaker: Ralph Kemperdick
Title: Scenarios and value proposition for JSON data enabled in Azure SQ
Abstract:
We will cover the following scenarios:
o Loading JSON data into the database
o Transforming Data with the database
o Servicing JSON to the application layer
o Advanced scenarios when working with JSON
SessionID: 50201
Deep-Dive into Polybase of SQL Server 2016 [DE]
Event Date: 08-10-2016 - Session time: 17:15:00 - Track: Cloud Big Data
Speaker: Gerhard Brueckl
Title: Deep-Dive into Polybase of SQL Server 2016 [DE]
Abstract:
SessionID: 50808
What Application Developers Should Know About SQL Server? [DE]
Event Date: 08-10-2016 - Session time: 17:15:00 - Track: Development (DEV-OPS)
Speaker: Miloš Radivojević
Title: What Application Developers Should Know About SQL Server? [DE]
Abstract:
Nowadays many companies don't have dedicated developer positions. Therefore the most of the SQL code has been written by application developers. And they use only a subset of SQL Server features and usually in a suboptimal manner.
I spent last ten years working with application developers and have collected common mistakes and misunderstandings between them and DBAs that increase development, test and deployment costs and reduce the overall quality.
In this session we will cover the most important things they need to know about SQL Server and that cannot be easily or cheap fixed by DBAs or consultants.
SessionID: 53397
Bauer BI und seine Pig Data [DE]
Event Date: 08-10-2016 - Session time: 17:15:00 - Track: Business Intelligence (BI)
Speaker: Wolfgang Strasser
Title: Bauer BI und seine Pig Data [DE]
Abstract:
Bauer BI hat#39;s nicht einfach. Viel Arbeit im Stall und dann soll er noch Daten #252;ber seine Schweine auswerten! Mit Excel kennt er sich ja aus, aber wie soll er hier f#252;r die Kontrolleure vom Landwirtschaftministerium eine #220;bersicht erstellen? Wie gut dass es seinen Nachbarn gibt - der stellt Bauer BI einen neuen Gehilfen im Datenstall vor: Power BI!
Begleiten Sie uns auf der Datenanalysereise von Bauer BI und Power BI. Vielleicht kommt ja auch noch real-time streaming aus dem Schweinestall hinzu und schon haben wir ein Power BI Dashboard f#252;r das Landwirtschaftministerium. Und Bauer BI ist gl#252;cklich..
SessionID: 53714
Event Date: 08-10-2016 - Session time: 17:15:00 - Track: Administration (DBA)
Speaker: André Kamman
Abstract:
There are many community scripts out there that DBAs can use without having to write them yourself. Like Ola Hallengrens scripts, or Brent Ozars or sp_WhoIsActive by Adam Machanic. But how about Powershell? Turns out, this world is still a bit unknown to the DBA but there is a fast growing community with extremely useful scripts for day to day SQL Server management. In this session we will take a look into my favourite scripts and we will also write a bit of Powershell ourselves.