Event Date: 03-12-2016 - Session time: 09:30:00 - Track: Development
Did you ever wonder, how to deploy a cube, with minimum impact to query performance? Or how to optimize processing performance? Are you really ready to deploy when its required? Or do you get nervous every time? Attend this session to build and improve your SSAS Developer skills, by exploring: Custom Assemblies - To improve Query Performance Partitioning - To improve Processing Performance Unit Testing - To improve Cube Release Quality Synchronization - To improve End User Experience and finally PowerShell to tie all the ends together.
Event Date: 03-12-2016 - Session time: 09:30:00 - Track: Database
Event Date: 03-12-2016 - Session time: 09:30:00 - Track: Business Intelligence Analytics
Event Date: 03-12-2016 - Session time: 10:45:00 - Track: Development
Event Date: 03-12-2016 - Session time: 10:45:00 - Track: Business Intelligence Analytics
Microsoft Power BI Embedded helps Independent Software Vendors to use Power BI data experiences within their applications. Customers, who use applications with Power BI Embedded don’t need to have a Power BI account or to know anything about this Azure service. This talk is a practical session on Microsoft Power BI Embedded concept with many examples how to create custom BI solutions using this technology.
Event Date: 03-12-2016 - Session time: 10:45:00 - Track: Database
Event Date: 03-12-2016 - Session time: 10:45:00 - Track: Database
Event Date: 03-12-2016 - Session time: 12:00:00 - Track: Development
Power BI seems to be an ideal candidate for analyzing and presenting those kind of data. The different types of real-time analytics (Stream Analytics, Power BI API, ..) will be presented and their pros and cons will be envisioned. The challenge: Let's prepare a real-time dashboard of Band2 data in Power BI in 60 minutes!
Event Date: 03-12-2016 - Session time: 12:00:00 - Track: Development
Event Date: 03-12-2016 - Session time: 12:00:00 - Track: Business Intelligence Analytics
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
Event Date: 03-12-2016 - Session time: 12:00:00 - Track: Database
Lead role belongs to SQL Server and his components. We invite you to the presentation of the architecture of database systems in large-scale eshop where you can find a variety of attractions from backstage. How many IT specialists to develop and maintain the system? How many servers? What hardware? What problems do we face? Bonus chapter… We found a bug in the nonclustered index whose fix will be complicated according to the statement of Microsoft's SQL developers...
Event Date: 03-12-2016 - Session time: 13:30:00 - Track: Development
Setting up SQL Server Data Tools for automated deployments: DAC Publish profiles SQLPackage.exe
Automating your build and deployments with PowerShell and psake
Guide to configuring TeamCity as your build server
Automated Integration and Regression testing of your Data Warehouse using NBi test framework
Automating cube and tabular model deployment
Event Date: 03-12-2016 - Session time: 13:30:00 - Track: Database
Query Store is a kind of “flight recorder” for your database, it provides functionality to capture queries, plans and execution statistics in the database, more to the point it allows you to force a particular plan for a query. The session will describe Query Store functionality and capabilities, provide some Query Store internal implementation details and give several usage scenarios.
Event Date: 03-12-2016 - Session time: 13:30:00 - Track: Business Intelligence Analytics
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.
Event Date: 03-12-2016 - Session time: 14:45:00 - Track: Business Intelligence Analytics
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: 03-12-2016 - Session time: 14:45:00 - Track: Development
Event Date: 03-12-2016 - Session time: 14:45:00 - Track: Business Intelligence Analytics
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: 03-12-2016 - Session time: 16:00:00 - Track: Business Intelligence Analytics
Event Date: 03-12-2016 - Session time: 16:00:00 - Track: Development
If you ask experts about using a clustered index you will in most cases hear the following statements: Yes, you need a narrow and contiguous clustered index for your table for good performance. Last but not least Microsoft Azure Databases requires clustered indexes but there might be situations when workloads and queries will suffer from wrong implemented clustered indexes.
Watch the demos which show in an impressive way that clustered indexes are not always the best choice. Build your clustered indexes wise or - as the demos will show - forgo for it for a better scaling. Become aware of the pros and cons of Clustered Indexes and make a wise decision when to use clustered indexes and the correct key attributes for it.
Event Date: 03-12-2016 - Session time: 16:00:00 - Track: Development
Event Date: 03-12-2016 - Session time: 17:15:00 - Track: Database
The potential of CLR capabilites is huge. I will show top patterns and tip tricks we encountered during the last couple of years when we we were developing on-line game backend.
Event Date: 03-12-2016 - Session time: 17:15:00 - Track: Business Intelligence Analytics
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.
Event Date: 03-12-2016 - Session time: 17:15:00 - Track: Database