Nr: 583
SQLSaturday #583 - Lisbon 2017
SessionID: 54540
Think work like a Data Scientist with SQL 2016 R
Event Date: 11-03-2017 - Session time: 09:00:00 - Track: Data Science Track
Speaker: Dr. Subramani Paramasivam
Title: Think work like a Data Scientist with SQL 2016 R
Abstract:
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.
SessionID: 54641
Advanced BIML - for the advanced ETL developer
Event Date: 11-03-2017 - Session time: 09:00:00 - Track: BI Track
Speaker: Regis Baccaro
Title: Advanced BIML - for the advanced ETL developer
Abstract:
SessionID: 56262
Event Date: 11-03-2017 - Session time: 09:00:00 - Track: DEV Track
Speaker: Peter ter Braake
Abstract:
SessionID: 56696
SQL Server Monitor and Maintenance with Azure Operations Management Suite
Event Date: 11-03-2017 - Session time: 09:00:00 - Track: Azure Infrastructure Track
Speaker: Pedro Sousa
Title: SQL Server Monitor and Maintenance with Azure Operations Management Suite
Abstract:
Microsoft Operations Management Suite (OMS) is Microsoft's cloud-based IT management solution that helps you manage and protect your on-premises and cloud infrastructure.
SessionID: 58175
Event Date: 11-03-2017 - Session time: 09:00:00 - Track: DBA Track
Speaker: Ivan Campos
Abstract:
SQL Server Vnext is already out there and like Microsoft has announced it will run on Windows and Linux environments.
Join me in this session and see how to start working with SQL Server on Linux, what tools are available for Linux and how to use them. Let's see how Microsoft has "cooked" this new solution for Linux
SessionID: 54502
A Game of Hierarchies: From GROUP BY to Recursive CTEs
Event Date: 11-03-2017 - Session time: 10:40:00 - Track: DEV Track
Speaker: Markus Ehrenmueller-Jensen
Title: A Game of Hierarchies: From GROUP BY to Recursive CTEs
Abstract:
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".
SessionID: 56263
Combining the Power of Machine Learning with the ease of PowerBI
Event Date: 11-03-2017 - Session time: 10:40:00 - Track: Data Science Track
Speaker: Peter ter Braake
Title: Combining the Power of Machine Learning with the ease of PowerBI
Abstract:
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.
SessionID: 57099
Troubleshooting Blocking for Beginners
Event Date: 11-03-2017 - Session time: 10:40:00 - Track: DBA Track
Speaker: Kendra Little
Title: Troubleshooting Blocking for Beginners
Abstract:
SessionID: 58194
SQL Server and Docker. What, How and Why
Event Date: 11-03-2017 - Session time: 10:40:00 - Track: Azure Infrastructure Track
Speaker: André Kamman
Title: SQL Server and Docker. What, How and Why
Abstract:
Docker has come to windows, and also SQL Server is coming to Linux. Can you run SQL Server in Docker? Why would you? In this session I'll show you what Docker is, what you can use it for and what the use case is regarding SQL Server. I'm using SQL Server on Docker for Windows myself in test environments for instance, it turns out to be very usefull in Continuous Integration and database upgrade testing scenarios. We'll discuss production scenarios as well.
SessionID: 58206
RAD with MDS
Event Date: 11-03-2017 - Session time: 10:40:00 - Track: BI Track
Speaker: Tillmann Eitelberg
Title: RAD with MDS
Abstract:
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
SessionID: 56905
Delivering changes for databases and applications
Event Date: 11-03-2017 - Session time: 12:00:00 - Track: DEV Track
Speaker: Eduardo Piairo
Title: Delivering changes for databases and applications
Abstract:
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.
SessionID: 58008
SQL Server real-life bizarre things
Event Date: 11-03-2017 - Session time: 12:00:00 - Track: DBA Track
Speaker: Etienne Lopes
Title: SQL Server real-life bizarre things
Abstract:
We all have experienced most strange behaviors in SQL Server that at some point made us say: What the heck!
Some influence integrity, others performance or even both!
Well, I’ve compiled some of them to show you while explaining why they happen and how to avoid/correct them.
Yep it’s not magic, there is an explanation for it! Come and get it
SessionID: 58186
New Azure SQL DB with blades or scripts? Humm what should I use?
Event Date: 11-03-2017 - Session time: 12:00:00 - Track: Azure Infrastructure Track
Speaker: Ricardo Cabral
Title: New Azure SQL DB with blades or scripts? Humm what should I use?
Abstract:
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.
SessionID: 58188
Power BI from the Trenches
Event Date: 11-03-2017 - Session time: 12:00:00 - Track: BI Track
Speaker: Rui Romano
Title: Power BI from the Trenches
Abstract:
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 ;)
SessionID: 58218
First steps with R RStudio for SQL Developers DBAs
Event Date: 11-03-2017 - Session time: 12:00:00 - Track: Data Science Track
Speaker: Rui Quintino
Title: First steps with R RStudio for SQL Developers DBAs
Abstract:
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.
SessionID: 54504
My Favorite Pie (Chart): Simple Rules for Clear Visualizations
Event Date: 11-03-2017 - Session time: 14:10:00 - Track: BI Track
Speaker: Markus Ehrenmueller-Jensen
Title: My Favorite Pie (Chart): Simple Rules for Clear Visualizations
Abstract:
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.
SessionID: 54581
Data Science for beginners
Event Date: 11-03-2017 - Session time: 14:10:00 - Track: Data Science Track
Speaker: Tomaž Kaštrun
Title: Data Science for beginners
Abstract:
We will focus on answering 5 simple questions.
- is this weird?
- is A better than B, respectively?
- how much / many of this is needed?
- this belong to group A?
- what is next?
Session we will look into technologies that can be tackled using SQL Server 2016 and ML Azure.
SessionID: 58150
Event Date: 11-03-2017 - Session time: 14:10:00 - Track: DBA Track
Speaker: Cláudio Silva
Abstract:
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
SessionID: 58190
BizTalk Server and SQL Server Together: For Developers Admins
Event Date: 11-03-2017 - Session time: 14:10:00 - Track: DEV Track
Speaker: Sandro Pereira
Title: BizTalk Server and SQL Server Together: For Developers Admins
Abstract:
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.
SessionID: 58210
Introduction to Microsoft Azure Search
Event Date: 11-03-2017 - Session time: 14:10:00 - Track: Azure Infrastructure Track
Speaker: Tiago Costa
Title: Introduction to Microsoft Azure Search
Abstract:
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.
SessionID: 54485
What is SQL Data Warehouse? Is it for me?
Event Date: 11-03-2017 - Session time: 15:50:00 - Track: Azure Infrastructure Track
Speaker: Vitor Pombeiro
Title: What is SQL Data Warehouse? Is it for me?
Abstract:
Do you know what SQL Data Warehouse is? Will it be the right choice for my solution? How does it work? Is it easy to migrate my solution to it?
This and many more questions will not be answered in this session but you will leave with the information to answer yourself those questions and many more.
SessionID: 54539
Revolution R models in SQL 2016 Reporting Services
Event Date: 11-03-2017 - Session time: 15:50:00 - Track: Data Science Track
Speaker: Dr. Subramani Paramasivam
Title: Revolution R models in SQL 2016 Reporting Services
Abstract:
As we have always seen a steady growth in SSRS since 2005, we now have much more advanced brand new features in 2016 SQL Server Reporting Services, beyond our imagination. Sit tight and buckle up for an amazing roller coaster ride, to not only briefly see the advanced SSRS killer features but also some of the R statistical charts within SSRS 2016 and the new user interface of Report Builder.
SessionID: 57100
Tuning Problem Queries in Table Partitioning
Event Date: 11-03-2017 - Session time: 15:50:00 - Track: DEV Track
Speaker: Kendra Little
Title: Tuning Problem Queries in Table Partitioning
Abstract:
SessionID: 58163
Recovery Models Made SIMPLE
Event Date: 11-03-2017 - Session time: 15:50:00 - Track: DBA Track
Speaker: Kalen Delaney
Title: Recovery Models Made SIMPLE
Abstract:
SessionID: 58202
Quo vadis SSAS – What's new with SQL Server 2016 SP1 and SQL Server vNext?
Event Date: 11-03-2017 - Session time: 15:50:00 - Track: BI Track
Speaker: Gabi Münster
Title: Quo vadis SSAS – What's new with SQL Server 2016 SP1 and SQL Server vNext?
Abstract:
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.
SessionID: 54579
Microsoft Azure Machine Learning Algorithms
Event Date: 11-03-2017 - Session time: 17:10:00 - Track: Data Science Track
Speaker: Tomaž Kaštrun
Title: Microsoft Azure Machine Learning Algorithms
Abstract:
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.
SessionID: 58142
High Availability and Disaster Recovery patterns with SQL Server and Windows Server 2016
Event Date: 11-03-2017 - Session time: 17:10:00 - Track: Azure Infrastructure Track
Speaker: Murilo Miranda
Title: High Availability and Disaster Recovery patterns with SQL Server and Windows Server 2016
Abstract:
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.
SessionID: 58164
A Look Inside SQL Server Distribution Statistics
Event Date: 11-03-2017 - Session time: 17:10:00 - Track: DBA Track
Speaker: Kalen Delaney
Title: A Look Inside SQL Server Distribution Statistics
Abstract:
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
SessionID: 58198
New features for devs in SQL Server 2016
Event Date: 11-03-2017 - Session time: 17:10:00 - Track: DEV Track
Speaker: António Lourenço
Title: New features for devs in SQL Server 2016
Abstract:
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.
SessionID: 58204
Columnstore killed the OLAP-Star: Did it really?
Event Date: 11-03-2017 - Session time: 17:10:00 - Track: BI Track
Speaker: Gabi Münster
Title: Columnstore killed the OLAP-Star: Did it really?
Abstract:
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.