Event Date: 27-10-2018 - Session time: 09:15:00 - Track: Administration
In this session we will learn to embrace the power in PowerShell to allow us to sit back and relax..... or rather focus on the real work of designing better, faster systems instead of fighting for short time slots when we can do actual work.
Along the way we will see that we can benefit from the wide world of PowerShell expertise and avoid re-inventing the wheel, again!
Event Date: 27-10-2018 - Session time: 09:15:00 - Track: Analytics
Doch das hat jetzt ein Ende. In dieser Session zeigt Sascha Dittmann wie man mit der Azure Machine Learning Workbench und dem Azure Batch AI Dienst eine durchgängige und einfach zu nutzende Data Science Umgebung aufbaut. Mit dieser lassen sich dann im großem Umfang parallel experimentieren, sowie Deep Learning- und KI-Modelle trainieren.
Event Date: 27-10-2018 - Session time: 09:15:00 - Track: Business Intelligence
Event Date: 27-10-2018 - Session time: 09:15:00 - Track: Development
Microsofts new "Azure Blockchain Workbench" let you do this in hours, not months. We will see how to
Event Date: 27-10-2018 - Session time: 10:45:00 - Track: Business Intelligence
Let’s see, how that goes…
Event Date: 27-10-2018 - Session time: 10:45:00 - Track: Development
Event Date: 27-10-2018 - Session time: 10:45:00 - Track: Analytics
This session will kick you off to the new language by using analogies from T-SQL. You will learn how to write your first R-scripts, make usage of packages and will leave this session with a basic understanding of typical use-cases of R and how to integrate that into your existing environment with SQL Server.
Event Date: 27-10-2018 - Session time: 10:45:00 - Track: Business Intelligence
Yes, it takes minutes to create and share Power BI reports. Which means every user who has relevant Power BI access can create Workspaces, Apps, reports, dashboards and schedules. With no deployment strategy, maintaining Power BI service could become a terrible job. In this session, I will cover how having a having deployment strategy can make a terrible maintenance job seamless.
This session will include: What happens when a user creates a Power BI app workspace How to control user access Working with different environments Creating and sharing reports using Power BI Apps How to monitor dataset schedules and failure notifications How to use Power BI API to document your organisation Power BI Service
Event Date: 27-10-2018 - Session time: 12:00:00 - Track: Business Intelligence
Continuous Delivery is a way to bridge the gap between developers and IT professionals and for that we need to address the both the toolchain to support the practices as well as the mindset on the team. Microsoft offers a set of tools that'll help you on your journey towards the end goal: Maximize predictability, efficiency, security and maintainability of operational processes.
We will in detail be looking at:
Agile Development Frame of Mind The Path Ahead (direction) Visual Studio Online (tool) Feature/User Story/Work Item (concept) Team Services Code Branching (concept) Build Agents (tool) Releases (tool)
Event Date: 27-10-2018 - Session time: 12:00:00 - Track: Administration
Event Date: 27-10-2018 - Session time: 12:00:00 - Track: Analytics
Where the data years ago was always structured, the growth of different data types now seems to be infinite. We are struggling with saving data with changing schemas and getting insights of new data types like social media, video, and pictures.
In this whiteboard session, I would like to talk with you about modern ways to store, analyze and visualize data. We will draw a Modern Data Warehouse and have a look at the ways to get more insights out of your data and why the cloud could help us.
Come and join my session and draw a Modern Data Warehouse together.
Event Date: 27-10-2018 - Session time: 12:00:00 - Track: Development
Event Date: 27-10-2018 - Session time: 13:30:00 - Track: Sponsor/Lunch Session
Quizmaster Ben Weissman hostet DAS Quiz für Nerds, Geeks und Fans, bei dem jede richtige Antwort mit einem Preis belohnt wird. Ihr wisst alles über Star Trek, Wars und Gate, schlaft im DC-PJ in der MARVEL-Bettwäsche und kennt die Frage zur Antwort 42? Dann seid ihr beim Solisyon Nerd-Quiz genau richtig! Für diejenigen, die jetzt den Kopf geschüttelt haben, ist das Quiz eine Pflichtveranstaltung: Dort wird euch geholfen. Spielt mit oder schaut zu und lernt fürs Leben – Spaß habt ihr in jedem Fall.
Nerdolisyon Round Three: Quizmaster Ben Weissman will be hosting THE Quiz for nerds, geeks and fans where EVERY right answer wins a prize. You know everything about Star Trek, Wars and Gate, sleep with DC-PJs in MARVEL-bedding sets knowing the question that is answered with 42? Then the game is on! For those that’s a negative for, the Solisyon Nerd Quiz is MANDATORY: there is still hope! Join in, watch, learn and laugh with us.
Event Date: 27-10-2018 - Session time: 14:20:00 - Track: Development
Event Date: 27-10-2018 - Session time: 14:20:00 - Track: Analytics
Event Date: 27-10-2018 - Session time: 14:20:00 - Track: Business Intelligence
Event Date: 27-10-2018 - Session time: 14:20:00 - Track: Administration
Event Date: 27-10-2018 - Session time: 15:40:00 - Track: Development
Event Date: 27-10-2018 - Session time: 15:40:00 - Track: Administration
In this session, you’ll see the differences, functionalities, restrictions, and opportunities in SQL Azure DB and On-Premise SQL Server 2008/2008 R2/2012/2014/2016/2017. We will look for topics such as how to be prepared for backup and restore, and which parts of a cloud environment are most important: keys, triggers, indexes, prices, security, service level agreements, etc.
Event Date: 27-10-2018 - Session time: 15:40:00 - Track: Development
1- There is a nonsargable filter 2- An index is missing 3- It is a query optimizer mistake 4- The subquery is unnecessary 5- Query join order is incorrect 6- A filtered statistic is missing 7- Scalar functions are running twice per each row 8- High number of reads on worktable 9- An unknown syntax could be used 10- Memory grant wasn’t enough 11- Distributed query doesn't look good 12- Residual predicates 13- Avoid window spool ondisk
Event Date: 27-10-2018 - Session time: 15:40:00 - Track: Business Intelligence
Event Date: 27-10-2018 - Session time: 17:00:00 - Track: Administration
Neben dem virtuellen Server gibt es auch die Azure SQL Databases, welche in zahlreichen Solution völlig ausreichend sind und sich flexibel an die Bedürfnisse anpassen lassen. Dieser Vortrag zeigt die verschiedenen Möglichkeiten des Deployments ebenso der Migration und gibt Hinweise, worauf bei der Migration zu achten ist bzw welche Features eventuell (noch) fehlen. Es wird eine Demo-reiche Session, aus der jeder etwas mitnehmen kann wie zum Beispiel Powershell-Ideen, Ansätze für Hochverfügbarkeit oder wie man Kosten reduzieren kann.
Event Date: 27-10-2018 - Session time: 17:00:00 - Track: Development
Event Date: 27-10-2018 - Session time: 17:00:00 - Track: Business Intelligence
This new term was introduced by Satya Nadella and James Philips as the serving foundation for building powerful (cloud-baked) applications. PowerApps as the data manipulation part, Microsoft Flow as the connecting workflow engine and Power BI for analysis and reporting. In addition, the Common Data Service (CDS) and the Common Data Model (CDM) provide a solid framework for data storage and modelling. Join me in this session if you want to get an overview about the involved technologies, how they work together, see them live working together in many demos and how they will definitely change the way of building powerful solutions in the future!