Build Schedule

Advanced Filters:
  • Track

    clear all








  • Speaker


  • Level


  • Session Type


Sessions Found: 12
Machine Learning is a subfield of computer science concerned with systems that learn from data. So this isn’t about systems that follow explicitly programmed instructions, but rather about systems that find patterns and trends within datasets, and use them to deliver insight and predictions.

In this session, you will learn how an Azure Machine Learning solution comes to life: From the creation of a workspace, to the preparation of data, to experimentation with Machine Learning algorithms, and then finally to the integration and embedding of predictive insights into applications.

This session has been specifically designed to describe Machine Learning fundamentals, and to help enable and inspire existing data professionals taking their first steps to leverage cloud-based predictive models delivered with Azure Machine Learning. It is guaranteed to thrill you with potential, and excite you with the relative ease by which it can be accomplished.
Speaker:

Session Type:
Extended Session (90 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: June 04

Time: 10:15 AM - 11:45 AM

Room: Room #2

Can ETL be fun? Unfortunately very often creation of ETL layer is a time-consuming, tedious, and error-prone task. What’s more, any change in requirements needs a lot of work to be redone. In our session we’ll present new approach to creating BI solutions using Biml language and BimlStudio programming environment. They greatly simplify the process, allowing for amazing flexibility, and make the ETL work more pleasant. We will show real examples of how Biml and C# generates hundreds of usable SSIS packages in just couple of minutes. We will also cover integration of ETL with TFS and CI for ETL. Everything with 100% compatibility with unmodified SQL Server. Join us and see how BI just became fun again.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: June 04

Time: 2:00 PM - 3:00 PM

Room: Room #2

Learn about typical challenges in legal information retrieval, the techniques used in querying data by determining its legal relevance, and how SQL Server 2016 can be used to simplify some of these techniques. For instance, a very important element of legal proceedings is determining which law should be used. Legal rules change over time, resulting in multiple versions of the same law. Laws do not last forever, and can be replaced by other laws (one old law can be replaced by one or more new laws). The timeline of events that are relevant to a particular court case provide one set of criteria to be used to determine the correct law and the correct version of the law. Another example is the trade of products and/or services. In order for a contract to be valid there must be a clear correlation between the offer to buy (or to sell) a product or a service and the corresponding counter-offer. They must both be valid simultaneously, they must both specify the same products or services, and 
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Advanced

Session Code:

Date: June 04

Time: 3:15 PM - 4:15 PM

Room: Room #1

Microsoft Corporate VP James Phillips summarizes Power BI with the simple phrase “5 minutes to WOW!”, but how do we make this a reality? In this talk, we’ll use Power BI to connect multiple data sources to unlock the mysteries of the data to allow application owners and senior leadership to better understand and make key decisions with their data. We'll talk about the "how" you need to create compelling data presentations even if you don't have a data warehouse or SSAS environment: dashboards from SharePoint lists, Excel, web sites or SQL Server databases will also get you that "wow". Attend the talk today and create your first amazing dashboard tomorrow!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code:

Date: June 04

Time: 2:00 PM - 3:00 PM

Room: Room #1

It won’t be long before we host the majority of our data, compute power, reporting, and BI visualizations in the cloud, but we’re not all there quite yet. In this presentation, we will discuss ONLY those options that are available on-premises, covering functionality differences between Power BI and Power BI Desktop as well as the critical integration of .pbix dashboards and visualizations with other enterprise reporting and collaboration tools, such as SharePoint, PowerPoint, Excel, and SQL Server Reporting Services. We’ll also highlight the Microsoft BI roadmap for SQL Server 2016, SSRS Paginated and Mobile Reports, Power BI, and what it means specifically for on-premise customers.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code:

Date: June 04

Time: 4:30 PM - 5:30 PM

Room: Room #1

Since 2008 version Reporting Services was a product that didn't show significative enhancements, today it has several interesting novelties, a new Web Portal, Mobile Report Published, improved Report Builder, integration to pin reports in Power BI Dahsboards, Custom Parameter Panel, all these topics will we covered in this session.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: June 04

Time: 9:00 AM - 10:00 AM

Room: Room #1

The R integration brings a lot of benefits and new scenarios to on premises data platform systems:
•	R can greatly simplify collection of different data.
•	Data manipulation and preparation can also be way easier with R.
•	You can use R to quickly explore and visualize data. 
•	Last but not least, R brings the whole power of modern data mining techniques to SQL Server.   
As if this was not enough, you can use familiar user interface and SQL Server Enterprise R Services to work with large datasets and multi-threaded, multi-core, multi-process computations. So, even if you don’t know R at all, come and see how natural this language is for everybody who already think in rows and columns.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Intermedia

Session Code:

Date: June 04

Time: 3:15 PM - 4:15 PM

Room: Room #2

In this session we'll explore new security features of SQL Server 2016. There's a big list of new features making SQL Server even more secure and flexible. We'll talk about row level security, dynamic data masking, always encrypted and others. All these new features will be explained with practical examples on their usage for production deployments.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: June 04

Time: 9:00 AM - 10:00 AM

Room: Room #2

Every developer heard at least once about NHibernate. There are lots of articles and performance tests describing how fast it runs and how easy is to integrate NHibernate into your application.

In this session I will try to explain why would one consider NHibernate as an option for his application stack, how to solve typical DBA complaints and give a brief comparison of how fast is NHibernate versus ADO.NET with stored procedures.

This session will be interesting to application developers who never worked with NHibernate but want to start, as well as for DBAs to gather some knowledge about how an application works including database layer.
I will also provide some demos to show why NHibernate is not as good as developers might think, and why it is better than DBAs think about this tool.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: June 04

Time: 12:45 PM - 1:45 PM

Room: Room #1

Proper design of cubes, dimensions, hierarchies and attributes is critical to optimal performance of SQL Server Analysis Services solutions.

I've collected a number of best practices during the years I've spent on building and maintaining OLAP cubes. In this session, we will go through the most important ten of these, so you can consider them in your everyday work when you build analytical back-end solutions with SSAS. Join this session, and see how these tips and best practices can save your precious time.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: June 04

Time: 12:45 PM - 1:45 PM

Room: Room #2

Utilising the off-line sales data of retail chain to significantly increase their on-line sales. Show casing different levels of  sophistication for product suggestions, from easy collaborative filtering to advanced models. Explaining what it takes SQL-wise to build each stage of the progress of suggestion engine.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Intermedia

Session Code:

Date: June 04

Time: 4:30 PM - 5:30 PM

Room: Room #2

Nowadays many companies don't have dedicated developer positions. Therefore the most of the SQL code has been written by application developers. And they use only a subset of SQL Server features and usually in a suboptimal manner.
I spent last ten years working with application developers and have collected common mistakes and misunderstandings between them and DBAs that increase development, test and deployment costs and reduce the overall quality.
In this session we will cover the most important things they need to know about SQL Server and that cannot be easily or cheap fixed by DBAs or consultants.
Speaker:

Session Type:
Extended Session (90 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: June 04

Time: 10:15 AM - 11:45 AM

Room: Room #1

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