Advanced Filters:
  • Track

    clear all






  • Speaker


  • Level


  • Session Type


Sessions Found: 32
Temporal Tables is a new feature in SQL Server 2016, that allows to see the data (in one or more tables) exactly as they were in a point of time ago.

In this session will be shown the most useful scenarios:
1) Auditing efects
2) Trending Analytics
3) A cloud based approach to handle Historical Data
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Development (Application & Database)

Level: Beginner

Session Code:

Date: January 20

Time: 1:00 PM - 2:00 PM

Room: Trivadis

Azure Data Lake Analytics (ADLA) is a new service from Microsoft for Analytics on Big Data Workload. U-SQL as a query language offers extraordinary query and transformation power by combining C# and SQL together. Nice! But: How do you integrate this service into your existing BI workload? 

In this session you will learn how to integrate relational databases (SQL Azure DB, Azure DWH, or SQL Server) by federation with ADLA, how to trigger jobs from on-prem systems like SSIS, and how to orchestrate the service via Azure Data Factory. Through live demos you will see that this service gives you great computing power for your BI landscape and integration is not that difficult.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
BI (Architecture, Development, Administration, Analytics, Vizual

Level: Beginner

Session Code:

Date: January 20

Time: 4:45 PM - 5:45 PM

Room: Microsoft

If you want to accelerate the testing of your BI solutions, the best strategy is the automation of your tests with the help of a dedicated framework. During this session, we’ll take a look to the features of the open-source framework named “NBi” (www.nbi.io). This framework is providing support for automated tests on the fields of databases, cubes, reports and ETLs, without the need of .Net skills. The demos will show us the best approaches to quickly and effectively assert the quality of BI developments. We'll go a step further, generating the tests by an interesting system of templates and test-cases sources.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI (Architecture, Development, Administration, Analytics, Vizual

Level: Intermedia

Session Code:

Date: January 20

Time: 1:00 PM - 2:00 PM

Room: Acceleratio

Die Cloud ist derzeit das Thema in der IT. Microsoft hat mit seiner Cloud Plattform Azure eine umfassende Lösung für die Entwicklung und den Betrieb von Anwendungen bereitgestellt, die in vielen Szenarien (Serverless-Computing, Mobile-Anwendungen, etc.) eingesetzt werden kann. Da es auch für Datenbank Administratoren und Entwickler interessant ist, welche Anwendungen auf meine Datenbank zugreifen, möchte ich in dieser Session einen kurzen Einblick in die verschiedenen Services von Azure liefern. Mit prägnanten Beispielen wird gezeigt, wie diese eingesetzt werden können und in Verbindung mit einem SQL Server stehen. Ebenso möchte ich zeigen, wie die Verwaltung und Einrichtung eines Azure-Kontos funktioniert und welche Tipps und Tricks es gibt, um Kosten zu sparen.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: January 20

Time: 2:15 PM - 3:15 PM

Room: Trivadis

Have you heard about Azure SQL DWH? Do you want to move your current DWH into the Cloud? Can I use Azure SQL DWH like my regular DWH on-premise?
In this session I'm going to answer on these questions. Also, I will prodive information where is better to use Azure SQL DWH and what is more important, how to use it.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI (Architecture, Development, Administration, Analytics, Vizual

Level: Beginner

Session Code:

Date: January 20

Time: 4:45 PM - 5:45 PM

Room: Solid Q

The Internet of Things is becoming reality at a rapid pace. Many objects in the real world can be connected to the Internet. Cloud computing is the best option for the IoT backend. Microsoft Azure offers the best set of services, required for the Internet of Things solutions, including a wide set of storages, websites, cloud services, Azure Service Bus / Event Hubs, Mobile Services, AD authentication and many data platform and BI related products like Azure SQL Database, DocumentDB, Azure Storage, Azure Stream Analytics, Machine Learning, Power BI and more..

This talk is about the main types of BI, used in IoT systems. Presentation is also about the most used Azure components, related to BI. You will see several real-life examples for BI in IoT solutions in different areas: smart energy systems, charging stations for electric cars and logistic systems.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: January 20

Time: 2:15 PM - 3:15 PM

Room: Pyramid

Gain the skills you need to help you get the job you want - and use new, innovative solutions and knowledge services to build up your skills.

When you apply for a job in data science, employers want to know if you can analyze and visualize data with Excel or Power BI and whether you can use R or Python to explore the data. They also want to know that you understand key topics, like statistics and machine learning. 

Use the latest tools to solve real-world data problems
It takes more than knowledge to be effective as a data scientist—technical skills and real-world experience with data are critical. The courses in the Microsoft Professional Program include hands-on labs so you can practice with tools used by data scientists in the field today.

We show you in that session, how you can benefit from this Microsoft Professional Degree Program - Data Science, how we enrich the Microsoft content with additional services and what you can expect from this best-of-breed solution
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI (Architecture, Development, Administration, Analytics, Vizual

Level: Intermedia

Session Code:

Date: January 20

Time: 10:45 AM - 11:45 AM

Room: ETC

Hadoop is everywhere. Growing from a project within Yahoo, it soon became a very popular tool for data analytics. Today, there are a lot of Hadoop installations in major companies and Hadoop is capable of analyzing large amounts of data. In this session, we will have a look at what Hadoop by outlining different tools such as HCatalog, Hive, Pig, Storm, Spark and HBase and will then look at HDInsight and its benefits.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: January 20

Time: 1:00 PM - 2:00 PM

Room: Solid Q

With the addition of R into SQL Server 2016, Microsoft have provided a few extra degrees of freedom for the standard SQL developer. You can now use the R language to wrangle, clean and collect external data, using libraries and functionality that simply wasn’t available to you before with regular T-SQL. Performing data enrichment at scale with SQL Server or even Microsoft R Server can provide extremely valuable new insights for your clients and start reaping the benefits of big data.
     
In this session, Consolidata’s Oliver Frost shows you how to develop your own application for tapping into ‘dark data’. Ollie will demonstrate how to stream live tweets, perform aggregations in R and pipe the output to a Power BI dashboard, giving you a full end-to-end experience of the importance of learning some basic R code in 2016. 
     
This session is for anyone who is new to R and is interesting expanding their skill set beyond their comfort zone in SQL Server.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Development (Application & Database)

Level: Beginner

Session Code:

Date: January 20

Time: 2:15 PM - 3:15 PM

Room: Microsoft

Extended Events, which entered the product in SQL Server 2008, are replacing the old SQL Trace & Profiler - and there are many good reasons for that. In this session you will see a selection of the most fascinating possibilities using this Tracing Framework. If you want to find out how to trace in a flexible and lightweight way, how to do advanced analysis directly inside the GUI, how to audit Database and Table-access without Auditing, how to analyze deadlocks without old-fashioned TraceFlags based on the built-in system_health session, this session is just for you. You will also learn how to use the GUI in an effective way for top-down-analysis and what is possible with some XQuery scripting.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Administration (Enterprise Database & Deployment)

Level: Intermedia

Session Code:

Date: January 20

Time: 3:30 PM - 4:30 PM

Room: Pyramid

Are you a DBA or Developer and would like to get started with AzureML the EASY WAY?
AzureML isn't just for "data scientists"... Anyone can use it! And after this session you'll be using it too...
Disclaimer: Sadly, AzureML still can't predict what's on your girlfriend's mind. Nothing ever will.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: January 20

Time: 1:00 PM - 2:00 PM

Room: ETC

The queries that are used for reports are usually the least efficient because you are dealing with huge amounts of data from tables sometimes joined many, many times. In this session we will go through good and bad examples of aggregating the data from your relational database. You will see tips on how to get good use of the indexes, how to lower the number of actual table queries and other  tricks that will make your queries run faster.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Development (Application & Database)

Level: Intermedia

Session Code:

Date: January 20

Time: 3:30 PM - 4:30 PM

Room: Solid Q

Microsoft Azure is a flexible, open, and secure cloud built for business. It provides access to 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 Application Development & Deployment

Level: Beginner

Session Code:

Date: January 20

Time: 10:45 AM - 11:45 AM

Room: Acceleratio

In this session the learnings and architecture of an implemented IoT prototype will be presented. It implements a full working IoT solution with as less as possible individual coding and as such ready “made” components were preferred. Therefore, components like Azure IoTHub, Azure Stream Analytics, Azure Data Factory, Azure Logic Apps, Azure SQL Database, Power BI, and many more were put together. The implemented approach includes alarming, aggregation (Stream Analytics) and concludes with Machine Learning processes.

You will see an active solution with all parts working in a ready-made demo up to the dashboards in Power BI. So get ready for an interesting practical view on IoT in the "wild".
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: January 20

Time: 4:45 PM - 5:45 PM

Room: Acceleratio

Markus Ehrenmüller-Jensen: Burst Your Sun (Glasses) - Improve your Datavizualisation
Heino Zunzer: Testing your database with tSQLt 
Gerhard Brückl: Polybase – Big Data meets SQL Server
Erik Monchen: SQL Server Reporting Services - What's new
Wolfgang Strasser: Power BI und ihre On-Premises Daten
Speaker:

Session Type:
Lightning Talk (10 minutes) (10 minutes)

Track:
Lightning Talks

Level: Beginner

Session Code:

Date: January 20

Time: 10:45 AM - 10:55 AM

Room: Pyramid

Die Datennutzung, d.h. die effektive Sammlung, Auswertung und Reporting von organisationsrelevanten Informationen, ist eine der wichtigsten Aufgaben, die CIOs derzeit als wettbewerbsfähigen Vorteil betrachten und für die CFOs bereit sind, erheblich zu investieren.
Zahlreichen branchenführenden Unternehmen ist es bereits gelungen, ihre Geschäftsabläufe von „datenblind“ auf „datengestützt“ umzustellen. Der Business Intelligence-Markt 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 und hören Sie dazu hilfreiche Praxisbeispiele.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI (Architecture, Development, Administration, Analytics, Vizual

Level: Beginner

Session Code:

Date: January 20

Time: 1:00 PM - 2:00 PM

Room: Pyramid

Cloud First, Mobile First! Das gilt auch für SQL Server 2016. In dieser Session betrachten wir die mobilen Fähigkeiten von SQL Server 2016. Der Reporting Service hat nun umfangreiche Möglichkeiten, um Daten und Analysen auf mobilen Geräten darzustellen Die Session beleuchtet Erstellung, Datenzugriff, Sicherheit, Design und Verteilung und zeigt an Beispielen, dass die Reporting Services 2016 wirklich „Mobile First“ sind. Ein Vergleich mit den mobilen Lösungen von Power BI, der Cloud-Lösung für Self-Service-BI, rundet die Session ab.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI (Architecture, Development, Administration, Analytics, Vizual

Level: Beginner

Session Code:

Date: January 20

Time: 3:30 PM - 4:30 PM

Room: Acceleratio

In this session, I’ll feature some crazy useful PowerShell commands from the dbatools module. This SQL Server-centric toolset, which has evolved into an open-source community project with over 20 contributors, includes commands like Remove-SqlDatabaseSafely, Set-SqlTempDbConfiguration, Find-SqlDuplicateIndex, Show-SqlWhoIsActive, Test-SqlPowerPlan and Repair-SqlOrphanUser.

Join for me for this electric, demo-heavy session to learn how to greatly simplify your life as a DBA.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Administration (Enterprise Database & Deployment)

Level: Intermedia

Session Code:

Date: January 20

Time: 2:15 PM - 3:15 PM

Room: Solid Q

A typical business case: A customer needs an analytical approach for several departments. Some requirements are identical, others differ. How do you design your architecture? Do you prefer building one big solution containing everything or do you build several small solutions, repeatedly building the shared requirements?

In this session we are looking into one possible approach: Build a large solution containing all client views. Maintain the client-specific master data in MDS 2016. The client specific deployment is designed to use AMO based on a client specific configuration.

But how about the Tabular mode? Let's find out together if we can apply a similar approach by using TOM, the AMO extension for tabular model in SQL Server 2016.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI (Architecture, Development, Administration, Analytics, Vizual

Level: Intermedia

Session Code:

Date: January 20

Time: 3:30 PM - 4:30 PM

Room: Trivadis

In this session we will explore the new features introduced with SQL Server 2016 to enhance security. 
Always Encrypted is a new technology that protects your data not only at rest, but also throughout the whole interaction between the application and the database.
Dynamic Data Masking is another interesting feature that allows us to protect sensitive data by masking it to all users that don’t have enough privileges to see the actual contents.
Row Level Security allows showing to end users only the data they’re entitled to access, without changing the applications’ code.
We will demonstrate the use of these three features with example applications and we will explore the use cases where these technologies represent a big leap from previous custom implementations.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Administration (Enterprise Database & Deployment)

Level: Intermedia

Session Code:

Date: January 20

Time: 1:00 PM - 2:00 PM

Room: Microsoft

Sessions Found: 32
SQLSaturday