Nr: 429
SQLSaturday #429 - Oporto 2015
SessionID: 35778
Learning R through a typical BI task
Event Date: 03-10-2015 - Session time: 09:00:00 - Track: Other
Speaker: Mark Wilcock
Title: Learning R through a typical BI task
Abstract:
R is a language for data munging and stats that is growing in popularity. Many Microsoft BI professionals are curious about R but few have used it on a real project yet. This talk aims to introduce you to the capabilities of R by comparing the implementation of a typical BI task both in Power BI and in R. We’ll load some data from a SQL database, explore the data and ask some basic questions, draw some insightful conclusions and then communicate these to a broader audience.
The purpose of this session is to show R strengths and weaknesses to help you decide if R is a useful language that is worth investing time and effort to learn and master.
SessionID: 38075
Query Store in SQL Server 2016
Event Date: 03-10-2015 - Session time: 09:00:00 - Track: SQL Server 2016
Speaker: Andre Batista
Title: Query Store in SQL Server 2016
Abstract:
Query Store is a new feature that will be released with SQL Server 2016 that will allow to store history of execution plans of each query with his performance counters. It will allow more easily to fix some performance problems about query plan changes. Join me in this session, to take a look and talk about this new great feature that will change the way we can fix and troubleshoot performance tuning problems
SessionID: 38107
SQL vNext Business Intelligence
Event Date: 03-10-2015 - Session time: 09:00:00 - Track: SQL Server 2016
Speaker: Bruno Basto
Title: SQL vNext Business Intelligence
Abstract:
SessionID: 38118
PowerShell - Jump from simple scripts to advanced functions
Event Date: 03-10-2015 - Session time: 09:00:00 - Track: Other
Speaker: Cláudio Silva
Title: PowerShell - Jump from simple scripts to advanced functions
Abstract:
Have you ever thought to take your PowerShell scripts to the next level? And if by doing so they become more robust and reusable?
In this session we will convert a simple PowerShell script in an advanced function and we will explore what we gain with this transformation.
Among others we will see how:
- Create / import modules from functions;
- Take advantage of:
- Input by pipeline;
- Common parameters to cmdlets as "Verbose", "-ErrorAction" and "-WarningAction";
- Risk mitigation parameters as "-WhatIf" and "-Confirm";
- Help
We will also see in action a set of functions that are designed to automate and save time on real cases of everyday life of a DBA.
SessionID: 40777
What is IoT? What does Microsoft offer? Azure IoT Suite.
Event Date: 03-10-2015 - Session time: 09:00:00 - Track: Big Data
Speaker: Scott Klein
Title: What is IoT? What does Microsoft offer? Azure IoT Suite.
Abstract:
What is IoT? What does Microsoft offer? Azure IoT Suite. What devices do we have?
SessionID: 37778
Event Date: 03-10-2015 - Session time: 10:40:00 - Track: SQL
Speaker: Joseph D'Antoni
Abstract:
• Optimizing TempDB in an Azure VM
• Reducing latency between application VMs and database VMs
• Right sizing Azure VMs for performance and cost
• Striping I/O across devices in Azure VMs
• Performance Tuning in Azure DB
You will learn about techniques that will not just improve your system performance, but save you company money, which can be easily quantified just in time for your performance review.
SessionID: 37869
Columnstore in SQL Server 2016
Event Date: 03-10-2015 - Session time: 10:40:00 - Track: BI
Speaker: Niko Neugebauer
Title: Columnstore in SQL Server 2016
Abstract:
Operational Analytics In-Memory Analytics are the 2 new amazing options that Microsoft is offering in the upcoming SQL Server 2016.
Build up Columnstore Analytics over your existing OLTP Clustered Table with a new updatable Nonclustered Columnstore Index, or use the In-Memory Updatable Nonclustered Columnstore Index over the InMemory OLTP Tables.
Discover what features of manageability and monitoring are being added to the SQL Server 2016.
This session will be delivering an overview of what is new and how it is going to change the landscape of OLTP OLAP.
SessionID: 38542
SSIS 2016 and Master Data – Whats new?
Event Date: 03-10-2015 - Session time: 10:40:00 - Track: SQL Server 2016
Speaker: Pedro Perfeito
Title: SSIS 2016 and Master Data – Whats new?
Abstract:
SessionID: 40778
Let them hack with Tessel.io’s
Event Date: 03-10-2015 - Session time: 10:40:00 - Track: Big Data
Speaker: Scott Klein
Title: Let them hack with Tessel.io’s
Abstract:
Let them hack with Tessel.io’s
SessionID: 35776
Triple Trouble - Running a SQL Failover Cluster on a Cluster from a Cluster
Event Date: 03-10-2015 - Session time: 12:00:00 - Track: Other
Speaker: Mark Broadbent
Title: Triple Trouble - Running a SQL Failover Cluster on a Cluster from a Cluster
Abstract:
SQL Server Failover Clustering has traditionally been deployed on physical architecture for a very long time, and is considered by many to be the optimal architectural deployment even today.
Experienced High Availability implementors and pioneers will remember the Microsoft Cluster Hardware Compatibility List with terror and early Virtualization adopters will recoil in disgust at their memories of poorly performing SQL Server VM deployments and will never want to go back there again. Times are changing and with the introduction of Microsoft's Scalable Shared File Server and improvements to Hyper-V Clustering, High Availability will never be the same again.
In this session we will investigate whether times have really changed for the better and discuss how to implement, administrate and benefits of running a Cluster on a Cluster from a Cluster!
SessionID: 36089
Introduction to Azure DocumentDB
Event Date: 03-10-2015 - Session time: 12:00:00 - Track: Other
Speaker: Leonard Lobel
Title: Introduction to Azure DocumentDB
Abstract:
SessionID: 37576
Hiding your data with SQL Server 2016
Event Date: 03-10-2015 - Session time: 12:00:00 - Track: Other
Speaker: Ivan Campos
Title: Hiding your data with SQL Server 2016
Abstract:
Lately Microsoft has been announcing a series of new features in this huge product that is SQL Server, in this session i will talk about the new developments that were made for security purposes, such as Dynamic Data Masking; Row-level security and Always Encrypted.
SessionID: 38289
The Reporting Machine!
Event Date: 03-10-2015 - Session time: 12:00:00 - Track: BI
Speaker: Tillmann Eitelberg
Title: The Reporting Machine!
Abstract:
In this demo based session, we will give you a complete overview into a customer project, where we used SSIS, SSRS and MDS to do exactly that.
You will see, how we:
- import statistical data with R and SSIS
- stuck report parts together, to get complete reports with almost 100 pages
- define themes for different corporate designs
- define languages for different reports
- render the reports with different rendering extensions
- developing Office add-ins to automate SSIS, SSRS and MDS
SessionID: 40779
Azure Stream Analytics + Azure Event Hubs
Event Date: 03-10-2015 - Session time: 12:00:00 - Track: Big Data
Speaker: Scott Klein
Title: Azure Stream Analytics + Azure Event Hubs
Abstract:
Azure Stream Analytics + Azure Event Hubs
SessionID: 36712
Approaches to database Unit Testing
Event Date: 03-10-2015 - Session time: 14:10:00 - Track: SQL
Speaker: Gavin Campbell
Title: Approaches to database Unit Testing
Abstract:
Database testing can be challenging, for a number of reasons that will be touched on in this session.
We will discuss the motivations for unit testing, as well as some of the particular challenges involved in testing database code and integrating this testing into the software development process.
Over the years, a number of tools and approaches have been developed to address these difficulties, and we will draw comparisons between some of these in order to highlight the questions you need to consider in choosing a testing approach for your own projects.
SessionID: 37371
Power BI for Developers
Event Date: 03-10-2015 - Session time: 14:10:00 - Track: SQL
Speaker: Rui Romano
Title: Power BI for Developers
Abstract:
Are you a developer? Want to learn what PowerBI has for you? Then come to my session where you will learn how to enhance your applications with PowerBI experiences...
SessionID: 37645
HDInsight: new tricks for the Azure Elephant
Event Date: 03-10-2015 - Session time: 14:10:00 - Track: Big Data
Speaker: Filipe Coelho
Title: HDInsight: new tricks for the Azure Elephant
Abstract:
SessionID: 38262
In-memory OLTP: The faster is now simpler in SQL Server 2016
Event Date: 03-10-2015 - Session time: 14:10:00 - Track: SQL Server 2016
Speaker: Murilo Miranda
Title: In-memory OLTP: The faster is now simpler in SQL Server 2016
Abstract:
After its debut, in SQL Server 2014, the in-memory OLTP technology, also known as Hekaton, brought a new option to improve that very critical database, something that we were always waiting for. However, some limitations were disencouraging its implementation. Your problems are over! Join this session and discover what SQL Server 2016 is bringing to us, in order to make "The Faster" more "Simpler".
SessionID: 40780
HDInsight
Event Date: 03-10-2015 - Session time: 14:10:00 - Track: Big Data
Speaker: Scott Klein
Title: HDInsight
Abstract:
HDInsight
SessionID: 37795
A journey through the Modern Data Warehouse
Event Date: 03-10-2015 - Session time: 15:50:00 - Track: Big Data
Speaker: Ruben Pertusa Lopez
Title: A journey through the Modern Data Warehouse
Abstract:
The traditional data warehouse has been the key of our business analytics architecture for many years. In a world ruled by the data culture concept, new challenges are emerging: data growth; unstructured data; hidden patterns and cloud-born data.
Which is the best architecture in order to get over these new challenges?
Join this session and learn how to enable the Modern Data Warehouse in your organization using Cubes, HDInsight, AzureML, Stream Analytics and DocumentDB. All through a continuous example using a retail shop scenario.
SessionID: 38100
Temporal Tables in SQL Server 2016
Event Date: 03-10-2015 - Session time: 15:50:00 - Track: SQL Server 2016
Speaker: Andre Batista
Title: Temporal Tables in SQL Server 2016
Abstract:
Temporal Data is one of the new features that will allow user's to audit data changes over time, that will be released with SQL Server 2016. With this feature, it will be possible, to see our records on a "point-in-time" perspective. Join me in this session, to take a look and talk about this new great feature that will change the way we can handle and audit data, or even recover some data that got changed by mistake.
SessionID: 38213
Storage For the DBA
Event Date: 03-10-2015 - Session time: 15:50:00 - Track: SQL
Speaker: Denny Cherry
Title: Storage For the DBA
Abstract:
SessionID: 40781
Spark on HDInsight
Event Date: 03-10-2015 - Session time: 15:50:00 - Track: Big Data
Speaker: Olivia Klose
Title: Spark on HDInsight
Abstract:
Spark on HDInsight
SessionID: 37648
PolyBase: unleash the power of Big Data in SQL Server 2016
Event Date: 03-10-2015 - Session time: 17:10:00 - Track: Big Data
Speaker: Filipe Coelho
Title: PolyBase: unleash the power of Big Data in SQL Server 2016
Abstract:
SessionID: 37678
Event Date: 03-10-2015 - Session time: 17:10:00 - Track: Other
Speaker: Tiago Quaresma
Abstract:
How to create simple mobile dashboards with DataZen.
SessionID: 38261
Curious Cases of Availability Groups
Event Date: 03-10-2015 - Session time: 17:10:00 - Track: SQL
Speaker: Murilo Miranda
Title: Curious Cases of Availability Groups
Abstract:
It's been more than two years after the release of the AlwaysOn Availability Groups and every day we see more and more architects implementing this technology. Either on new projects or as a new solution on existing systems, at the design stage everything looks feasible and possible, but sometimes small details may cause a headache during the implementation phase. In this session, we will go through common cases, and others not so common, when implementing Availability Groups in a production environment. Dive with me into these AG cases so when one of these situations pops during your professional life you will already be armed with the knowledge to resolve it!
SessionID: 40782
Azure Machine Learning
Event Date: 03-10-2015 - Session time: 17:10:00 - Track: Big Data
Speaker: Olivia Klose
Title: Azure Machine Learning
Abstract:
Azure Machine Learning