Build Schedule

Advanced Filters:
  • Track

    clear all














  • Speaker


  • Level


  • Session Type


Sessions Found: 24
This is not your regular Agile BIML session. By now you already know that BIML is a great productivity enhancement to SSIS. You also know that you can build metadata driven solution and include C# code in your BIML scripts or snippets. If you don't know what I'm talking about this session is not for you. If you - on the other hand - want to know how to build a modular BIML framework, do real C# development and include it in your BIML code so that you can pass custom objects around for optimized performance and code reuse then this session is for you. We will see how to build a reusable C# framework that can be obfuscated and deployed to customers without worrying about Intellectual property. I promise you no more than a few slides but a lot of demos and real life experience acquired from major BIML projects. We will also have a look at how to harness integration and unit tests in the setup with a twist of Continuous Integration with Team Foundation Server.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Development

Level: Advanced

Session Code:

Date: December 03

Time: 10:45 AM - 11:45 AM

Room: Joyful - Morava

Anomaly detection is one of the most advanced data mining and machine learning tasks. There are many statistical procedures and data mining algorithms that can be used for it, including Expectation-Maximization Clustering, and Principal Component Analysis. In this session, you will learn through presentation and demos how to detect the low quality data areas with some basic statistics and with advanced algorithms. You will see how you can use T-SQL queries, R code in SQL Server, SSAS Data Mining, and Azure ML for this complex task.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence & Analytics

Level: Intermedia

Session Code:

Date: December 03

Time: 4:00 PM - 5:00 PM

Room: Profisee - Room3

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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence & Analytics

Level: Intermedia

Session Code:

Date: December 03

Time: 2:45 PM - 3:45 PM

Room: Joyful - Morava

You are using Extended Events and dynamic management views (DMVs) to analyze performance problems in your databases. How do you go from there to building a performance-monitoring system that is easy to use and that works at scale? In this session, learn techniques for loading and parsing Extended Events into a central monitoring database in close to real time, correlating the events with query plans, indexing the data for performance, and making the information easily available.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database

Level: Intermedia

Session Code:

Date: December 03

Time: 5:15 PM - 6:15 PM

Room: Microsoft - Praha

T-SQL has some limitations, which can be partially overcome by using CLR. That extends power of your database in directions you might not be even aware of. Like a bonus you get solid performance, testable and reusable code, similarly maintainable like a regular application code. But everything reliably secured inside of your 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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database

Level: Intermedia

Session Code:

Date: December 03

Time: 5:15 PM - 6:15 PM

Room: Joyful - Morava

We are going to examine a variety of oopsies MANY developers fall prey too - some obvious, some pretty subtle and some down right sneaky! Lots of code examples with the bad AND good code presented. I GUARANTEE that you will find things here that will either prevent you from getting bad data, throwing unwanted errors or vastly improving your database application's performance.  I have given this talk over SEVENTY times now and it is always very highly rated!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Development

Level: Intermedia

Session Code:

Date: December 03

Time: 12:00 PM - 1:00 PM

Room: Microsoft - Praha

Continuous Integration is not normally associate with data warehouse projects due to the perceived complexity of implementation.  John will be showing how modern tools make it simple to apply continuous integration techniques to data warehouse projects.  In particular, the session will cover: 

* 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
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Development

Level: Intermedia

Session Code:

Date: December 03

Time: 1:30 PM - 2:30 PM

Room: Profisee - Room3

Microsoft Power BI Embedded is a Microsoft Azure that enables developers to integrate Power BI reports into their web or mobile applications so they don’t need to build custom solutions to visualize data for the users. 
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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence & Analytics

Level: Intermedia

Session Code:

Date: December 03

Time: 10:45 AM - 11:45 AM

Room: Profisee - Room3

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:
Business Intelligence & Analytics

Level: Intermedia

Session Code:

Date: December 03

Time: 5:15 PM - 6:15 PM

Room: Profisee - Room3

Have you ever had the need to access documents in your database as if they were files in the file system? SQL Server 2012 introduces a brand new method for managing large data objects (BLOBs) in a database. FILETABLEs provide access to data using Transact-SQL - just like any other table inside the database, while at the same time also provide access to the data using the operating system File I/O API - i.e. just like any other folder in the file system. In this session you will learn how to upgrade your document management solutions by migrating your large data to FILETABLEs. The session covers two most typical migration scenarios: migrating from a distributed data store, and from a homogeneous data store.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database

Level: Advanced

Session Code:

Date: December 03

Time: 4:00 PM - 5:00 PM

Room: Joyful - Morava

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:
Business Intelligence & Analytics

Level: Beginner

Session Code:

Date: December 03

Time: 1:30 PM - 2:30 PM

Room: Microsoft - Praha

In this session we'll see how a security mis-configuration can lead to getting sysadmin privileges. What are your options for getting SA rights, and finding many useful security related information. This session will be based on presentations with practical demos displaying how to attack SQL server surface.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database

Level: Advanced

Session Code:

Date: December 03

Time: 10:45 AM - 11:45 AM

Room: Microsoft - Praha

Have you ever seen this message "Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON" ?
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
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence & Analytics

Level: Intermedia

Session Code:

Date: December 03

Time: 12:00 PM - 1:00 PM

Room: Joyful - Morava

ORMs - oh how I LOVE them! As a consultant when I see them in play at a client I go KACHIIINNNNGGGG!! :-D Seriously though, they can provide some substantial benefits for coding throughput. But if you don't Read The Fine Manual and do some things right and avoid some major gotchas you will fall prey to one of my favorite Guruisms: "Anything that allows developers to slap code together more quickly is inversely proportional to the performance and scalability you will get from that code"! Although this talk is based on Entity Framework, most ORMs suffer from a lot of the same flaws.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Development

Level: Intermedia

Session Code:

Date: December 03

Time: 2:45 PM - 3:45 PM

Room: Microsoft - Praha

SQL Server transaction log is one of the most critical components of the database and in the same time one of the most misunderstood. While being neglected it can easily become a bottleneck for our system. Are you interested in learning how to avoid issues with the transaction log and streamline its work? In these sessions we will explore how to optimize it, configure it and keep it under control.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database

Level: Advanced

Session Code:

Date: December 03

Time: 10:45 AM - 11:45 AM

Room: Microsoft - Praha

Power BI celebrated 1st birthday in August. Product grew in functionality as well as number of users. What were the main challenges of using Power BI in production environment, what are the lessons learned. What I find the best tips for Power BI reports development, data refresh (live vs import) options, content sharing, report life cycle management and everything else you need in corporate environment
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence & Analytics

Level: Intermedia

Session Code:

Date: December 03

Time: 9:30 AM - 10:30 AM

Room: Joyful - Morava

Getting the techniques in your tool belt right, makes a world of a difference. 
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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Development

Level: Intermedia

Session Code:

Date: December 03

Time: 9:30 AM - 10:30 AM

Room: Profisee - Room3

Many of us came across a situation when a query suddenly becomes slow. To understand the reason for the slowdown, it would be nice to see what was the query plan before that. Was it the same or another, if it was another, then what had changed? It was a hard to figure it out unless you had implemented your own monitoring system. Fortunately, in SQL Server 2016 we have the solution out of the box, it's called – Query Store.
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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database

Level: Advanced

Session Code:

Date: December 03

Time: 1:30 PM - 2:30 PM

Room: Joyful - Morava

Green alien from Alza.cz is well known to many peaople in 26 countries in Europe. Most people can see only the website but there is lot more in the background.
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...
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database

Level: Intermedia

Session Code:

Date: December 03

Time: 12:00 PM - 1:00 PM

Room: Microsoft - Praha

This demo-heavy session will take a look at PolyBase in SQL Server 2016. This technology provides the means to access and combine both relational and non-relational data all from within SQL Server. Using the wonderful T-SQL language you are already familiar with, you can run queries using T-SQL against data that resides in Hadoop, HDInsight, or Azure blob storage. This session will show how to use T-SQL to import and export data back and forth between relational tables and non-relational data stores. We'll also show how to join and aggregate data from both SQL Server and a non-relational store using T-SQL and how these queries are optimized to push computation down. We'll also look at how to configure and scale out SQL Server PolyBase for those high-volume workloads.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Development

Level: Intermedia

Session Code:

Date: December 03

Time: 4:00 PM - 5:00 PM

Room: Microsoft - Praha

Sessions Found: 24
Back to Top cage-aids
cage-aids
cage-aids
cage-aids