Event Date: 17-09-2016 - Session time: 08:30:00 - Track: IoT/AA/Cloud
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.
Event Date: 17-09-2016 - Session time: 08:30:00 - Track: DEV
Both the different operational scenarios and the technical background of JSON and XML, however, require a different range of functions and language. Therefore, initially, as far as practicable the parallels will be demonstrated. Especially the T-SQL extensions „FOR JSON“ and „OpenJSON“ are very similarly implemented in comparison to „FOR XML“ and „OpenXML“. Furthermore the new functions „IsJSON“, „JSON_VALUE“ and „JSON_QUERY“ are now contained in T-SQL. Do they also have these as T-SQL functions for XML or can these results be calculated with XML-methods? Additionally, XML has some more features which concern saving ( and indexing ) and requesting (in particular with XQuery) in relational tables. These will also be demonstrated exemplary. The goal of the session is to show, when which language is of advantage in which case.
Event Date: 17-09-2016 - Session time: 08:30:00 - Track: DBA
Event Date: 17-09-2016 - Session time: 08:30:00 - Track: DBA
Most DBAs are probably using unattended installs followed by a bunch of post configuration scripts to make sure their SQL Server instances are production ready. We will take a look at how Powershell DSC works, and how this can be used by DBAs to install, configure and manage SQL Servers. I will try to answer questions like:
How does Powershell DSC work? How would a DBA use Powershell DSC? Are the resources to manage SQL Server mature enough?
After this session you are better equiped to decide if Powershell DSC is useful for you, now or in the near future.
Event Date: 17-09-2016 - Session time: 10:00:00 - Track: DEV
Event Date: 17-09-2016 - Session time: 10:00:00 - Track: BI
In this talk I will show you different techniques and models related to time: process mining, lean, six sigma, process datawarehousing, relational temporal theory and SQL 2016 temporal
Event Date: 17-09-2016 - Session time: 10:00:00 - Track: DBA
In this session you will learn why it is so and techniques how you can use to overcome this. You will also learn that the same techniques can be to permit users to perform specific actions they need to do without granting them general high-level permissions on database or server level by packaging these actions into a stored procedure. You will also learn why should should be careful with setting a database TRUSTWORTHY.
The session should be of interest both to DBAs and application developers that need to consider advanced permissions in their stored procedures.
Event Date: 17-09-2016 - Session time: 10:00:00 - Track: IoT/AA/Cloud
monitoring a (virtual) production line. We will cover the concept of field gateways and talk about how to build a solution that is both fail-safe and can bring sensor processing close to the actual manufactoring, while still utilizing the massive power that the cloud can offer. Expect a level 400 session with a lot of demos and code.
Event Date: 17-09-2016 - Session time: 10:00:00 - Track: Application Database Development
Event Date: 17-09-2016 - Session time: 11:15:00 - Track: BI
How can you achieve your purpose? There are different ways in Power BI to spread your work. Are you an invidual wishing to share datasets and report with your coworkers? Then you need a group. Are you a company aims to broadcast contents to every employee? Then you need an organizational content pack. In this session will scroll across all the collaborative and delivering features of Power BI to find the the right solution that match your needs.
Event Date: 17-09-2016 - Session time: 11:15:00 - Track: IoT/AA/Cloud
This technology uses a T-SQL like syntax to express its intents. A language that most data-power users will be familiar with.
The biggest advantage of Stream Analytics is when events are being published to the Stream Analytics, the only thing that event publishers needs to know is which Event Bus or Blob storage to place the data. Stream Analytics will then fetch the data.
This talk is about the main concepts and solution architecture when using Azure Stream Analytics, and also how to use this technology together with MS SQL Server, Azure SQL Database and Power BI.
Event Date: 17-09-2016 - Session time: 11:15:00 - Track: DBA
Event Date: 17-09-2016 - Session time: 11:15:00 - Track: BI
The M language is not yet available in SSIS, but there are already power shell scripts that can perform the load to your database. I will walk through the steps in a simple ETL process and explain some of the quick wins when using the transformations, lookup, variable and parameter functions that M provides compared to standard SSIS and how to create your own functions. We will finish the session with a demo on how to load data from your tables to your SQL database.
Event Date: 17-09-2016 - Session time: 13:30:00 - Track: BI
Event Date: 17-09-2016 - Session time: 13:30:00 - Track: DEV
Event Date: 17-09-2016 - Session time: 13:30:00 - Track: DBA
Event Date: 17-09-2016 - Session time: 13:30:00 - Track: DBA
Windows Server 2016 will not only increase functionality from previous versions but brings entirely new features such as Storage Spaces Direct and Storage Replica to the table.
The session will briefly cover the Windows Server 2012 R2 and SQL Server 2012/2014/2016 setups, but we can also add this functionality to older versions of SQL Server.
But the main part will show how new Windows Server 2016 features for the first time can overcome SQL Server limitations, all the way up to and including SQL Server 2014.
This will all be based on the last version of Windows 2016 before release and show results from the first customer in the world to run this in full production on the beta builds.
Event Date: 17-09-2016 - Session time: 13:30:00 - Track: Lightning Talk
An execution plan is in many ways similar to an organisation. And the operators are like the employees, trying hard (and sometimes even succeeeding) to work together effectively. Managing people, or execution plans, is easier if you know their idiosyncrasies. In this lightning talk, I will highlight a few of my favorite empl... eehrmm, operators; and tell you what you need to know in order to manage them effectively.
Do you Trust Me? - By John Martin Let me show you why you really ought not to trust those databases and what you can do if you need to.
BI Bullocks Bingo - By Jens Vestergaard "This session will be hosted around a Quiz, where everyone attending will be able to participate, learn and most importantly have fun while doing so.
The Categories of the Quiz are: Analysis Services Data Warehousing SQL Server RDBMS Integration Services
The session is intended to highlight misconceptions surrounding typical Business In
Event Date: 17-09-2016 - Session time: 14:45:00 - Track: BI
We will talk about how to collect the data, how to build something meaningful from the data and how you can report on top of the data. We will do this for OLAP cubes and for Reporting Services Reports and we will explore ways you can further develop this for your own organization.
At the end of the session all participants will leave with all the code as well as the know how to get started with the collection of usage statistics for their Microsoft BI Solutions
Event Date: 17-09-2016 - Session time: 14:45:00 - Track: DBA
Why Upgrade? Data Platform Upgrade topic has been a popular session that I've presented in major conferences like Microsoft Tech-Ed (North America, Europe India) and SQLbits since 2008.
In this session, we will overview in depth end-to-end upgrade process that covers the essential phases, steps and issues involved in upgrading SQL Server (2000 to 2012), SQL Server 2014 (with a good overview on 2016 too) by using best practices and available resources.
What to-do and what not-to-do?
A popular session that I have been presenting since the year 2008, in MS Tech-Ed, SQL Saturday SQLbits UK. We will cover the complete upgrade cycle, including the preparation tasks, upgrade tasks, and post-upgrade tasks. Real-world examples from my Consulting experience expanding on why how such a solution.
Event Date: 17-09-2016 - Session time: 14:45:00 - Track: DBA
Event Date: 17-09-2016 - Session time: 14:45:00 - Track: DBA
I have worked with SQL Server as a developer in the Redmond team for more than 12 years and during this time I've investigated countless performance problems. In time I developed a strategy on how to use the performance monitoring data to analyze problems and identify the root cause. This session is going to to show you how I monitor SQL Server, what data do I look for, and how I interpret the collected data to analyze performance issues. Going beside the obvious CPU, Memory and IO counters, I will show you how to identify typical performance issues from monitoring data, all without overwhelming the captured data volume.
Event Date: 17-09-2016 - Session time: 16:00:00 - Track: IoT/AA/Cloud
You now have answers to these questions and thanks to Microsoft for integrating R Revolution within new SQL Server 2016. We all now have the opportunity to use R packages and see the results within SQL 2016.
In this session, you will definitely take away a breakthrough concept of Advanced R Analytics within SQL 2016 and get ready to kick your creative horse, and go beyond your imagination on how you can build advanced analytics and impress your employers/customers.
Event Date: 17-09-2016 - Session time: 16:00:00 - Track: DBA
What should be a straight forward and simple process can lead to all sorts of issues and trying to resolve them can turn into a nightmare. This talk looks at the principle of Kerberos, how it applies to SQL Server and what we need to do ensure it works
Event Date: 17-09-2016 - Session time: 16:00:00 - Track: DBA
Event Date: 17-09-2016 - Session time: 16:00:00 - Track: IoT/AA/Cloud
Focus on this session will be mathematical and graphical explanation of algorithms available for predictive analytics in Azure ML service. Algorithms - grouped by learning type - will be examined and crossed referenced through all available and ready-to-use. Understanding the the basics - data inference, data splitting, data stratification, to sweeping, SMOTH, to logic and theory of algorithms: regression, decision trees/forest/jungle, Clustering and Naive Bayes.
This session will clarify the confusion over algorithms, which data is suitable for which algorithm and what problem.
Event Date: 17-09-2016 - Session time: 16:00:00 - Track: BI