Advanced Filters:
  • Track

    clear all








  • Speaker


  • Level


  • Session Type

Sessions Found: 20
Microsoft Azure SQL Database's built-in smart tuning models help you achieve great performance for your database apps while saving you time and effort in the process. We demo the state-of-the-art capabilities, including tailored actionable recommendations, auto-tuning and insights into query performance. In addition, we present real-life case studies to illustrate how SQL Database built-in tuning will make a difference for your app performance.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: March 18

Time: 9:15 AM - 10:15 AM

Room: Room 015

Today, data is everywhere, in all forms and sizes and being generated faster then ever before. In the same time, falling storage costs for data make it cheap to store vast amounts of information and cloud solutions offer compute power on demand. With all the technology innovation, today, easier then ever, any organization can start gaining insights and making data driven decisions. Microsoft in no exception here, so we build bunch of solutions for our own teams. Now, we're taking everything we've learned on this journey and bringing it to our customers. Joint the session to learn about different big data solutions which Microsoft offers on Azure and how to get started with some of them.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: March 18

Time: 10:30 AM - 11:30 AM

Room: Room 015

U ovoj sesiji potrudicu se da docaram zašto je Query Store najvažnije dostignuce Database Engine-a nakon 2005. i OPTION(RECOMPILE).
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: March 18

Time: 3:00 PM - 4:00 PM

Room: Room 005

Columnstore technology in SQL Server has been continuously improved with new features and capabilities. In this session we will talk about Columnstore Index basics, and then dive into some of the internal details. Let's cover all available Columnstore Index flavors and when each of them should be used. We'll go through some of the features and how to utilize them the best. We'll also talk about maintenance of Columnstore Index internal structures to keep the best possible performance, as well as other best practices, tips and tricks.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: March 18

Time: 1:45 PM - 2:45 PM

Room: Room 015

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:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: March 18

Time: 4:15 PM - 5:15 PM

Room: Room 015

Transact-SQL language in latest editions of SQL Server has so many business intelligence (BI) improvements that it might become your primary analytic database system. You might even decide to use T-SQL for advanced analyses directly, without including R, SSAS or Azure ML. However, to get the maximum out of these language constructs, you need to learn how to properly use them. This in-depth session shows extremely efficient statistical queries that use the new window functions and are optimized through algorithms that use mathematical knowledge and creativity. During the session, the formulas and usage of those statistical procedures are explained as well. This session is useful not only for BI developers; database and other developers can successfully learn how to write efficient queries. Or maybe you want to become a data scientist? Then you need to know statistics and programming. You get the best of both in this session.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Advanced

Session Code:

Date: March 18

Time: 11:45 AM - 12:45 PM

Room: Room 005

Machine learning service is Microsoft Azure drag and drop tool for building,testing and deploying any kind of predictive model on your data-set. Finalized solution is published and used by daily business in larger stack of your Microsoft Azure services. With easy and interactive creation of models, algorithms and decisions do not tend to be that simple! Especially when one has to make business decision on results.

Focus on this session will be mathematical and graphical explanation of algorithms available for predictive analytics in Azure Machine Learning 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, to theory of algorithms: regression, decision trees, Clustering and Naive Bayes. We will clarify the confusion over algorithms, suitable data for algorithms and what type of problem can be tackled with.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: March 18

Time: 1:45 PM - 2:45 PM

Room: Room 001

Being part of Microsoft is challenging. But also rewarding. With the countless cases of pretty and not so pretty SQL Servers. With so many good, but also bad practices. Cases going from badly written code to cases with improper plan caching. And I want to share them all with you. So let's hope we have enough time to do that!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: March 18

Time: 4:15 PM - 5:15 PM

Room: Room 005

There is a vast array of material in the SQL Server community that covers the in-memory engine in great detail, this session will cover some of the internals of the in-memory engine, however what it will also do is fill in the void as to common performance issues and how they can be solved with the in-memory engine, specifically:

- Staging data as fast as possible
- Turbo charging scalar aggregate functions
- Implementing a scalable sequence
- Overcoming the performance limitations of temporary tables
- Making the critical path in your code base run faster
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: March 18

Time: 10:30 AM - 11:30 AM

Room: Room 005

Row-level security
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: March 18

Time: 1:45 PM - 2:45 PM

Room: Room 005

Spatial dimension of business such as ‘where are things happening’ and ‘where are my customers’ becomes more and more important. An unprecedented amount of location-referenced data that will be produced in years to come has to be not just stored, but more important analyzed on strategic, tactical and operational level, sometimes in (near) real time. This session covers use cases and best practices for spatial analytics and shows significant performance improvements in spatial with SQL Server 2016 and demonstrates synergy offered in Azure ecosystem.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: March 18

Time: 3:00 PM - 4:00 PM

Room: Room 015

The current IoT devices are pretty powerful, so could very well run a version of SQL engine.
It would be a good idea?  What will be the use of it? How to make it work and make the most of it? 
How does all fit with the field gateway concept?  During the presentation, we will take a real word scenario, real hardware, and together we will try to answer these questions
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: March 18

Time: 11:45 AM - 12:45 PM

Room: Room 001

SQL Server 2012 introduced an important extension to its integrated Full-text Search, namely the Statistical Semantic Search. In this session you will learn how to install and configure this new functionality, how to use it to extend your existing full-text search capabilities, and how to utilize it properly to improve your information management solutions. You will learn how to automatically extract key phrases from your documents, and how to find similarities between individual documents of your information corpus based on the key phrases that they contain.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Advanced

Session Code:

Date: March 18

Time: 10:30 AM - 11:30 AM

Room: Room 001

JSON support that was introduced in SQL Server 2016 and Azure SQL Database enables you to get the best both from relational and NoSQL worlds. You can easily combine relational design that provides high query performance and non-relational concepts that provide you flexibility and rapid development to create optimal design for your application.
In this session, we will see how you can combine relational data and JSON, query and index JSON data, load semi-structured data from log files, create REST/OData services, and easily integrate your database with modern web apps.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: March 18

Time: 11:45 AM - 12:45 PM

Room: Room 015

Slow cubes? Don't worry, you have a lot of options. Join this session and let me show you how aggregations and partitioning work (even on Standard Edition with a workaround!), and how to scale your solution to deal with heavy workloads.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: March 18

Time: 9:15 AM - 10:15 AM

Room: Room 001

What are these DATA Scientists up to? How can we see their statistical model in our day to day familiar tool like Microsoft SQL Server?

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

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: March 18

Time: 3:00 PM - 4:00 PM

Room: Room 001

Keynote session
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Information Delivery

Level: Beginner

Session Code:

Date: March 18

Time: 9:00 AM - 10:00 AM

Room: Room 005

Keynote session
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Information Delivery

Level: Beginner

Session Code:

Date: March 18

Time: 9:00 AM - 10:00 AM

Room: Room 001

Keynote session
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Information Delivery

Level: Beginner

Session Code:

Date: March 18

Time: 9:00 AM - 10:00 AM

Room: Room 015

SQL Server 2016 has lots of new features and changes in Availability Group. This session is about the new things and demo about the followings: Workgroup cluster + AAG, Direct Seeding, DB_FAILOVER and Load balancing secondary replica.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: March 18

Time: 9:15 AM - 10:15 AM

Room: Room 005

Sessions Found: 20
SQLSaturday