Build Schedule

Advanced Filters:
  • Track

    clear all
















  • Speaker


  • Level


  • Session Type



Sessions Found: 30
Hierarchies are the bread and butter of most business applications and you find them almost everywhere:
* Product Categories
* Sales Territories
* Calendar and Time
Even when there is a big need from a business perspective, the solutions in relational databases are still sort of awkward. Since Version 2008, SQL Server makes life a bit easier with the data type hierarchyid. If you want to successfully query self-referenced hierarchies, you will need recursive common table expressions. To make use of aggregations, you have to master GROUP BY clauses, as well as GROUPING SETS, CUBE, ROLLUP, WITH CUBE, and WITH ROLLUP.
If these terms caught your attention, then join this session for a journey through best practices to model your hierarchies and handy scripts to transform your hierarchies into useful information. We will have fun playing around with a sample database based on G. R. R. Martin’s famous "Game of Thrones".
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
DEV Track

Level: Intermedia

Session Code:

Date: March 11

Time: 10:40 AM - 11:40 AM

Room: DEV Track

Room Windows B
3º Floor

Where do the estimated rowcount values come from? Look inside SQL Server’s distribution statistics to see how they are used to come up with the estimates. We’ll also discuss changes in the cardinality estimator in recent versions and look at some new metadata that gives us more statistics information.

Goals:
•	Explore the output of DBCC SHOW_STATISTICS
•	Describe when the density information is useful
•	Look at some problem scenarios for which the statistics can’t give good estimates
•	Understand why cardinality estimation involves more than just the statistics
Speaker:

Accompanying Materials:

No material found.

Session Type:
Extended Session (90 minutes)

Track:
DBA Track

Level: Advanced

Session Code:

Date: March 11

Time: 5:10 PM - 6:40 PM

Room: DBA Track

Room Windows A
3º Floor

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:

Session Type:
Regular Session (60 minutes)

Track:
BI Track

Level: Advanced

Session Code:

Date: March 11

Time: 9:00 AM - 10:00 AM

Room: BI Track

Room Azure A

As DBA we need to perform a lot of repetitive tasks. We also want to know the current state of our environments. What if we have a PowerShell module that help us with those tasks? That module is DBATools.
Have you ever need to verify if best practices are in use? How do you do it when you have dozens if not hundreds or thousands of SQL servers? One by one?
And, what if you have to apply the best practices on those SQL servers? You will also do it one by one?

In this session we will see how easy, fast, precise and less error prone can be validate if a set of SQL servers is respecting the best practices and if not how we can configure them to just by using a set of commands from DBATools module. 

This module is one of the most popular tools among DBAs and is developed and maintained by more than 30 contributors from the community. We have PowerShell and SQL Server MVPs, DBAs, developers and QA people.
If you do not know this tool or if you want to learn more this is a great oppo
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
DBA Track

Level: Intermedia

Session Code:

Date: March 11

Time: 2:10 PM - 3:10 PM

Room: DBA Track

Room Windows A
3º Floor

This session will be an introduction to two existing roles in BizTalk: BizTalk Administrator and a BizTalk Developer.

The first parts of this session I will address some of the topics that a SQL Admin needs to know to administrate a BizTalk Server platform at the SQL level, I will demonstrate some of common mistakes, how we can avoid them and some of the best practices.

But BizTalk Server also have a strong development component, so in the second part I will introduce and explain how can we connect and exchange messages with SQL Server: How to consume messages from SQL Server and how to send messages to SQL Server.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
DEV Track

Level: Intermedia

Session Code:

Date: March 11

Time: 2:10 PM - 3:10 PM

Room: DEV Track

Room Windows B
3º Floor

With increasing speed in relational query execution classical analytical solutions get challenged more and more. Why loose time for processing data into multi-dimensional databases? Why analyze outdated data if you can have fresh data instead? We are analyzing typical scenarios from classical multi-dimensional analysis like YTD calculation, DistinctCount and others in regards to their efficiency with different solution approaches: Classical multi-dimensional databases in ROLAP mode, DirectQuery, T-SQL… And we are going to show how Columnstore indexes are influencing those solutions. Find out about advantages and disadvantages of the different solutions in regards to the problem. And maybe you will discover new approaches for your own challenges.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Track

Level: Intermedia

Session Code:

Date: March 11

Time: 5:10 PM - 6:10 PM

Room: BI Track

Room Azure A

With the introduction of Azure Machine Learning predictive analytics and text analysis is within everyone’s reach. It is (relatively) easy to implement and it is easy to use when combined with PowerBI. In this session you will learn how to take advantage of Azure ML from PowerBI and you will learn how powerfull PowerBI is as a tool for Data Scientists.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Data Science Track

Level: Intermedia

Session Code:

Date: March 11

Time: 10:40 AM - 11:40 AM

Room: Data Science Track

Room Azure B

Data science can be hard to grasp, complex and big, but making data science easy to understand and bringing it closer to all who want to tackle this new emerging field is an important task in world of data.  Exploring, extracting and finding hidden gems  from data using statistical and mathematical methods, computer science and several different technologies is essentially what data science is doing. In practice this means, data science is an iterative process of harvesting data, managing and cleaning the data,  performing analysis and and at the end interpreting, visualizing and using information  that will bring insights to end-user, business people and making decisions much easier.
We will focus on answering 5 simple questions. 

1) is this weird? 
2) is A better than B, respectively? 
3) how much / many of this is needed? 
4) this belong to group A? 
5) what is next?

Session we will look into technologies that can be tackled using SQL Server 2016 and ML Azure.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Data Science Track

Level: Beginner

Session Code:

Date: March 11

Time: 2:10 PM - 3:10 PM

Room: Data Science Track

Room Azure B

In the world of agile software development, the database development process introduces some challenges to the application development process. The delivery of changes at database level tend to be a different and separated process of the application delivery process, or even an entirely manual process. This contributes to the perspective that the database is a bottleneck in the agile process.
In this session, we will explore the aspects that bring closer and distinguishes databases from the applications. We will share methodologies and strategies that allows to bring together databases and applications in the development process reducing the delivery pain.
The final purpose is to understand that applications and databases do not need to live in different worlds with different development processes.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
DEV Track

Level: Intermedia

Session Code:

Date: March 11

Time: 12:00 PM - 1:00 PM

Room: DEV Track

Room Windows B
3º Floor

Are you a BI Developer? DBA? BI Analyst or a data/analytics lover? Come along, join us in this session as we explore this powerful, sometimes even strange!... language , showing main differences from the typical SQL/BI development. 

This is a beginner level session to guide you on why & when to use R, and help with the very first steps & typical challenges.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Data Science Track

Level: Beginner

Session Code:

Date: March 11

Time: 12:00 PM - 1:00 PM

Room: Data Science Track

Room Azure B

Cloud, cloud and cloud. That's all we hear nowadays, but there's still life out of the Cloud!

Windows Server 2016 and SQL Server 2016 can together broader the capabilities of your systems. With regards to High Availability and Disaster Recovery, we have more flexibility by taking advantage of the improved AlwaysOn Availability Groups, Windows Server Failover Cluster and, of course, Azure's integration.

During this session we will explore those new possibilities, checking what is new, the current limitations and what we can build by taking advantage of all the improvements.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Azure & Infrastructure Track

Level: Intermedia

Session Code:

Date: March 11

Time: 5:10 PM - 6:10 PM

Room: Azure & Infrastructure Track

Room .NET

Microsoft Azure Search is a new fully managed full-text search service in Microsoft Azure which provides powerful and sophisticated search capabilities to your applications. In this session we will introduce this great new services from the very beginner and create a full search experience in a standard web application and a mobile App.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Azure & Infrastructure Track

Level: Intermedia

Session Code:

Date: March 11

Time: 2:10 PM - 3:10 PM

Room: Azure & Infrastructure Track

Room .NET

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:
Data Science Track

Level: Intermedia

Session Code:

Date: March 11

Time: 5:10 PM - 6:10 PM

Room: Data Science Track

Room Azure B

Dataviz guru Stephen Few once stated that we should “save the pies for dessert”. What he meant is that pie charts are good in some specific use cases, but they should not be used in others. The same is true for other chart types. Using the wrong type of chart will make it harder for report users to understand the story behind the data. To enable insights, information has to be presented in the most intuitive way possible. You will leave this session with five easy-to-implement rules, which will guide you through the process of creating clear and attractive visualizations.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Track

Level: Beginner

Session Code:

Date: March 11

Time: 2:10 PM - 3:10 PM

Room: BI Track

Room Azure A

What's the best way to create a new SQL Azure Database is it through the blades of the portal or by automization?

Anyone of them has the desired result but what surprise effect has automation in store and why is it used more and more? Come and find out in this session.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Azure & Infrastructure Track

Level: Beginner

Session Code:

Date: March 11

Time: 12:00 PM - 1:00 PM

Room: Azure & Infrastructure Track

Room .NET

Do you know that now you can DIE with SQL Server 2016? Well, only if you know that DIE is DROP IF EXISTS. We will time travel with temporal data, will secure our data with row-level security, dynamic data masking and always encrypted, will stretch our database to Azure and even talk JSON natively.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DEV Track

Level: Beginner

Session Code:

Date: March 11

Time: 5:10 PM - 6:10 PM

Room: DEV Track

Room Windows B
3º Floor

This talk is all about showing real world tips from real world scenarios of using Power BI: the goods and the bads.

This session is targeted to whom is using or start using Power BI and want to take home some really good tips & tricks ;)
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Track

Level: Beginner

Session Code:

Date: March 11

Time: 12:00 PM - 1:00 PM

Room: BI Track

Room Azure A

SQL Server Analysis Services are on the move. Not only did they just enter the cloud but some really cool new features are new with SQL Server 2016 SP1 and even more is planned for SQL Server vNext. Let's have a look into those features and possibilities.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
BI Track

Level: Beginner

Session Code:

Date: March 11

Time: 3:50 PM - 4:50 PM

Room: BI Track

Room Azure A

If you think about RAD tools, you think about Visual Studio LightSwitch, Project Sienna or even Power Apps. But usually you don't think about Microsoft SQL Server Master Data Services. 
MDS makes the administration and maintenance of your master data quite easy and comfortable. But in more and more projects, we no longer use MDS only as a master data system. Every time you need a small list, a maintainable table, something where somebody can store in any manner manageable information – we use Master Data Services. 
From the simple management of SSIS jobs to a complex forecasting or annual planning system. With MDS you can create very quickly and easily applications for the processing of well-structured data. And together with the Excel AddIn directly for an environment with a high degree of acceptance. With SQL Server 2016, many more features have been added, to even more simplify the rapid application development process.
In this session, we will show different development approach
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
BI Track

Level: Beginner

Session Code:

Date: March 11

Time: 10:40 AM - 11:40 AM

Room: BI Track

Room Azure A

SQL Server always logs every change to a database. But exactly what is logged can vary based on a number of factors. Some operations are referred to as "minimally logged," but even those operations can log a different level of detail depending on your recovery model. This session looks inside the transaction log to see exactly what is logged for minimally logged operations. First, we look at some background information regarding how the log is used and managed, and then we introduce a tool that can help you actually see your log records. When you can query the log, you can determine how logging for operations such as index rebuilds and SELECT INTO differs depending on whether you are using the FULL or BULK_LOGGED recovery model. We also look at other factors in our SQL Server operations that can affect what is actually written to the log. In addition, I’ll describe the benefits and caveats for each of the recovery models.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Extended Session (90 minutes)

Track:
DBA Track

Level: Intermedia

Session Code:

Date: March 11

Time: 3:50 PM - 5:20 PM

Room: DBA Track

Room Windows A
3º Floor

Sessions Found: 30
Back to Top