sqlsathistory

Nr: 582

Back to Main list

SQLSaturday #582 - Melbourne 2017

Start Time (24h)	Speaker	Track	Title
09:00:00	Craig Bryden	Analytics and Visualization	An Introduction to R and R Services
09:00:00	Kevin Boles	Application Database Development	Common TSQL Mistakes
09:00:00	Bernard Spence	BI Platform Architecture, Development Administration	Excel tips and tricks for the data professional
09:00:00	Greg Low	Azure Services and Platform	What on earth are all the Azure* and Power* services and why would I want them?
09:00:00	Johnley John	BI Platform Architecture, Development Administration	SQL Server Integration Services
09:00:00	Ajay Jagannathan	Enterprise Database Administration Deployment	Become A Troubleshooting Ninja with PowerBI and SQL Server Extended Events
10:10:00	Edwin M Sarmiento	Enterprise Database Administration Deployment	Proactively Identifying and Dealing with SQL Server Database Corruption
10:10:00	Susantha Bathige	Enterprise Database Administration Deployment	Statistics and New Cardinality Estimator Model
10:10:00	Ankit Patira	Azure Services and Platform	Real time reporting with Power BI
10:10:00	Jim McLeod	BI Platform Architecture, Development Administration	Azure SQL Data Warehouse - Massive, Parallel, and in the Cloud
10:10:00	Matt Masson	Analytics and Visualization	The Power of Power Query!
10:10:00	Victor Isakov	Application Database Development	New Security Features in SQL Server 2016
11:25:00	Tobias Koprowski	Enterprise Database Administration Deployment	SQL Security in the Cloud
11:25:00	Matt Allington	Analytics and Visualization	How you can use disconnected tables in PowerPivot/Tabular models to solve real world problems
11:25:00	Victor Isakov	Application Database Development	Query Store: A (R)evolution in Query Tuning
11:25:00	Reza Rad	BI Platform Architecture, Development Administration	10 Amazing Things About Power BI You Don't Know
11:25:00	Michael Carder	Enterprise Database Administration Deployment	Simplify management of multi-server, multi-region SQL Server deployments with Conductor4SQL
11:25:00	Julie Koesmarno	Analytics and Visualization	Intro to Azure Data Lake and U-SQL
14:05:00	Martin Catherall	Application Database Development	Oh, When did THAT change happen?
14:05:00	Adam Gilmore	BI Platform Architecture, Development Administration	Automate Data Warehouse build and deployment (db,SSIS SSAS) with Visual Studio 2015 and TFS
14:05:00	Warwick Rudd	Enterprise Database Administration Deployment	2016 – The Rise and Fall of DBM
14:05:00	Hamish Watson	Strategy and Architecture	Making DevOps work in the wild...
14:05:00	Rob Douglas	Enterprise Database Administration Deployment	Adding Powershell to Your Skillset
14:05:00	Lindsey Allen	Azure Services and Platform	What's new in Azure SQL DB and SQL engine
15:15:00	Manohar Punna	Enterprise Database Administration Deployment	Plan, Design and Implement a HADR Solution - a Journey
15:15:00	Martin Cairney	Azure Services and Platform	Database Administration for Azure SQL DB
15:15:00	Patrick Flynn	Enterprise Database Administration Deployment	SQL Server on Linux - The How, the What and the Why?
15:15:00	Allen White	Application Database Development	Scalable Application Design with Service Broker
15:15:00	James Beresford	BI Platform Architecture, Development Administration	Creating High Performance Tabular Models
15:15:00	Darren Gosbell	Analytics and Visualization	Why your charts suck and how to fix them
16:30:00	Manjot Kaur	BI Platform Architecture, Development Administration	DW SuperHero-Columnstore Index
16:30:00	Nagaraj Venkatesan	Enterprise Database Administration Deployment	R for Database Administrators
16:30:00	Rolf Tesmer	Azure Services and Platform	Azure Cognitive Services - The Rise of the Machines!
16:30:00	Leila Etaati	Analytics and Visualization	R; One Ring to Rule Them All
16:30:00	Sunil Agarwal	Enterprise Database Administration Deployment	SQL Server 2016 SP1: Enhancements that will make your SQL Server roar!
16:30:00	Guy Glantser	Application Database Development	How to Use Parameters Like a Pro and Boost Performance

SessionID: 54457

An Introduction to R and R Services

Back to calendar

Event Date: 11-02-2017 - Session time: 09:00:00 - Track: Analytics and Visualization

Speaker: Craig Bryden

Title: An Introduction to R and R Services

Abstract:

R is the most popular programming language for advanced analytics today. With Microsoft's purchase of Revolution R, we are seeing native integration of R capabilities in the SQL Server 2016 database engine (R Services). We are also seeing R support in most of the Azure cloud products.

In this session I will provide an introduction to the R language as well as discuss how you go about using this inside SQL Server and other Microsoft provided tools.

SessionID: 56651

Common TSQL Mistakes

Back to calendar

Event Date: 11-02-2017 - Session time: 09:00:00 - Track: Application Database Development

Speaker: Kevin Boles

Title: Common TSQL Mistakes

Abstract:

We are going to examine a variety of oopsies MANY developers fall prey too - some obvious, some pretty subtle and some down right sneaky! Lots of code examples with the bad AND good code presented. I GUARANTEE that you will find things here that will either prevent you from getting bad data, throwing unwanted errors or vastly improving your database application's performance. I have given this talk over SEVENTY times now and it is always very highly rated!

SessionID: 57059

Excel tips and tricks for the data professional

Back to calendar

Event Date: 11-02-2017 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Bernard Spence

Title: Excel tips and tricks for the data professional

Abstract:

Data is fast becoming the new currency of the 21 century as compute power increases whilst the cost of the storage decreases. Analysing data has never been easier with tools like Azure Machine learning (and R) which can provide powerful insights. Many data professions can only provide these insights if the has been cleaned beforehand. Microsoft Excel is one of the tools of choice for BI professionals and Data Scientists. This session will show a number of killer Excel tips and tricks that every data geek should be using in their career. This session will enable you to go back to the office and wow your boss and clients with cool and amazing techniques! Well ... only if they are also data geeks.

SessionID: 57175

What on earth are all the Azure* and Power* services and why would I want them?

Back to calendar

Event Date: 11-02-2017 - Session time: 09:00:00 - Track: Azure Services and Platform

Speaker: Greg Low

Title: What on earth are all the Azure* and Power* services and why would I want them?

Abstract:

Don't know your Power Apps from your Power BI, Flow, etc.? In this session Greg will do his best to explain what on earth all the various services are, or at least the ones that he thinks are relevant to data people. Can't promise the final list until nearer the day but the aim at present would be to spend a short while on each of: SQL DB, SQL Data Warehouse, Elastic Database Pools, DocumentDB, Search, Storage, Power BI, Power Apps, Flow, Event Hubs, Stream Analytics, Azure ML, Cortana Intelligence Suite, Azure AD

SessionID: 57254

SQL Server Integration Services

Back to calendar

Event Date: 11-02-2017 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Johnley John

Title: SQL Server Integration Services

Abstract:

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications.

It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data.

SessionID: 57282

Become A Troubleshooting Ninja with PowerBI and SQL Server Extended Events

Back to calendar

Event Date: 11-02-2017 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Ajay Jagannathan

Title: Become A Troubleshooting Ninja with PowerBI and SQL Server Extended Events

Abstract:

New to Extended Events? Want to become a ninja in troubleshooting common SQL issues using extended events? This is a demo filled session that will show you how to troubleshoot several common issues in SQL server database engine and identify hotspots as well failures using only extended events. The session will showcase how extended events make scenario based troubleshooting easier using Power BI dashboards and without having to collect disparate sets of diagnostic data, gather memory dumps and comprise on performance. There have been a plethora of Extended Events which have been added to SQL Server recently based on customer feedback which deprecates the need to run profiler in many commonly encountered situations in production environments. This session covers the new enhancements and capabilities available for Extended Events.

SessionID: 56689

Proactively Identifying and Dealing with SQL Server Database Corruption

Back to calendar

Event Date: 11-02-2017 - Session time: 10:10:00 - Track: Enterprise Database Administration Deployment

Speaker: Edwin M Sarmiento

Title: Proactively Identifying and Dealing with SQL Server Database Corruption

Abstract:

Corruption occurs on every SQL Server database whether we like it or not. And the only way to minimize downtime and data loss when it occurs is to proactively identify and deal with database corruption.

In this session, we will learn how to identify and detect database corruption. We will look at incorporating these different approaches in proactively identifying corruption in our regular database maintenance routines. We will also look at how to deal with database corruption using restore or repair that is appropriate to your edition of SQL Server.

SessionID: 56874

Statistics and New Cardinality Estimator Model

Back to calendar

Event Date: 11-02-2017 - Session time: 10:10:00 - Track: Enterprise Database Administration Deployment

Speaker: Susantha Bathige

Title: Statistics and New Cardinality Estimator Model

Abstract:

Statistics in SQL Server plays a major role creating execution plan which essentially decides server performance. If you get a good execution plan the server performance is good otherwise it will impact negatively on the server performance. SQL Server 2014 introduced new Cardinality Estimation (CE) model to improve the quality of the execution plans via quality estimates of row counts. The new CE model is a major redesign to the Query Optimizer since SQL Server 7.0. In this session, I'm going to talk about how statistics is used to generate the execution plan, how execution plan changes with new CE model with demos.

SessionID: 57060

Real time reporting with Power BI

Back to calendar

Event Date: 11-02-2017 - Session time: 10:10:00 - Track: Azure Services and Platform

Speaker: Ankit Patira

Title: Real time reporting with Power BI

Abstract:

Real-time dashboards and reporting is no longer an exclusive technology with Power BI currently offering several ways to achieve that. In this session we will look at and talk about several ways you can achieve that and include demo(s) on those technologies. We will cover technologies such as using Azure Stream Analytics, Power BI REST APIs and recently introduced Streaming Datasets feature in Power BI service.

SessionID: 57253

Azure SQL Data Warehouse - Massive, Parallel, and in the Cloud

Back to calendar

Event Date: 11-02-2017 - Session time: 10:10:00 - Track: BI Platform Architecture, Development Administration

Speaker: Jim McLeod

Title: Azure SQL Data Warehouse - Massive, Parallel, and in the Cloud

Abstract:

Azure SQL Data Warehouse is a cloud-based massively parallel database platform, based on the concepts that the Analytics Platform System/Parallel Data Warehouse uses for on-premises extreme performance. While it appears at first glance to be a familiar SQL Server environment, Azure SQL Data Warehouse has a few gotchas and design implications that can bite you (and your data warehouse's performance!) if you're not aware of them. This session will teach you the basic concepts of Azure SQL Data Warehouse, and provide tips and guidance on how to get the most of it.

SessionID: 59926

The Power of Power Query!

Back to calendar

Event Date: 11-02-2017 - Session time: 10:10:00 - Track: Analytics and Visualization

Speaker: Matt Masson

Title: The Power of Power Query!

Abstract:

Microsoft Power Query started a revolution in self-service data transformation. First launched as an Excel add-in, this incredible product was soon integrated into Excel 2016, and became a core component of the wildly successful Power BI Desktop. Thi

SessionID: 61623

New Security Features in SQL Server 2016

Back to calendar

Event Date: 11-02-2017 - Session time: 10:10:00 - Track: Application Database Development

Speaker: Victor Isakov

Title: New Security Features in SQL Server 2016

Abstract:

SQL Server 2016 promises to be one of the more interesting releases from a security perspective. This releases sees an unprecedented number of new security features. And already, the market is getting it “wrong” with a number of “myths” and “misconceptions” growing about how these features work.

This session will examine these new security features, specifically Always Encrypted, Dynamic Data Masking and Row-Level Security. It will look at these new features potential benefits, implementation considerations and importantly their limitations. Make sure you attend this session if you want to implement security correctly in SQL Server 2016!

SessionID: 54533

SQL Security in the Cloud

Back to calendar

Event Date: 11-02-2017 - Session time: 11:25:00 - Track: Enterprise Database Administration Deployment

Speaker: Tobias Koprowski

Title: SQL Security in the Cloud

Abstract:

Our data should be secure. And our environment too. What we can do for maximize security in a hybrid environment, where SQL Server exist in two forms: premise and cloud. How organize our job, how control our data if we use Windows Azure SQL Database - The Cloud Database. Physical security, policy based management, auditing, encryption, federation, access and authorization. All of those subjects will be covered on my session.

SessionID: 54934

How you can use disconnected tables in PowerPivot/Tabular models to solve real world problems

Back to calendar

Event Date: 11-02-2017 - Session time: 11:25:00 - Track: Analytics and Visualization

Speaker: Matt Allington

Title: How you can use disconnected tables in PowerPivot/Tabular models to solve real world problems

Abstract:

When people first start out with Power Pivot/Tabular data models, the first thing they learn is how to create "one to many" relationships between tables. But did you know it is quite valid to load tables into your data model that are "disconnected"?

In this session I introduce 4 real world scenarios that demonstrate how you can use the power of DAX disconnected tables to solve business problems. The scenarios are:

• Allow users to perform what if analysis and change the calculation values in a pivot table by altering the input values for key variables using a slicer.
• Allow users to change the series that is displayed on a chart using input from a slicer.
• Grouping you customers into age groups so you can create cohorts for reporting and analysis using "banding"
• Displaying the "latest survey result" in a Pivot Table for any date selected. It is very easy to see the "results" for a period using Power Pivot/Tabular. But it is much harder to find the "latest " from any period.

SessionID: 56174

Query Store: A (R)evolution in Query Tuning

Back to calendar

Event Date: 11-02-2017 - Session time: 11:25:00 - Track: Application Database Development

Speaker: Victor Isakov

Title: Query Store: A (R)evolution in Query Tuning

Abstract:

Fixing performance problems and detecting query regressions has never been easy in SQL Server as the database engine fundamentally does not capture the relevant information. With the release of SQL Server 2016, Microsoft has introduced a feature called Query Store that will help you capture vital query metrics that will help performance troubleshooting and regression detection. In this session we will examine Query Store and how it can be used in a myriad of use cases. We will examine its architecture, configuration and shortcomings. This session will help you build a monitoring solution that will help you detect and solve real-world performance problems across your entire SQL Server infrastructure. It will also substantially help de-risk upgrade projects, so there's no "excuse" not to upgrade to SQL Server 2016!

SessionID: 56885

10 Amazing Things About Power BI You Don't Know

Back to calendar

Event Date: 11-02-2017 - Session time: 11:25:00 - Track: BI Platform Architecture, Development Administration

Speaker: Reza Rad

Title: 10 Amazing Things About Power BI You Don't Know

Abstract:

Have you use Power BI for a real-time dashboard? Have you looped through source files in your Power Query and applied custom functions on them? Have you changed your data model to help Power QA to respond intelligently? Have you head of structured columns in Power Query? Have you used Calculated Tables in DAX? Have you used Power BI Embedded? Have you done many other amazing things with Power BI?

In this session you can expect many live demos and to be impressed by the extraordinary things you can do with Power BI. You will learn tips and tricks to empower your Power BI solution. Tips and tricks that you learn in this session helps you to make your Power BI solution more scale-able, robust, and high performance.

SessionID: 57007

Simplify management of multi-server, multi-region SQL Server deployments with Conductor4SQL

Back to calendar

Event Date: 11-02-2017 - Session time: 11:25:00 - Track: Enterprise Database Administration Deployment

Speaker: Michael Carder

Title: Simplify management of multi-server, multi-region SQL Server deployments with Conductor4SQL

Abstract:

Conductor4SQL helps organisations with a large SQL Server footprint to manage their environment remotely in a more effective and efficient manner with guaranteed resiliency.

We will cover topics that are critical to every SQL Server DBA including: security, auditing, governance, task automation, system standardisation and real-time data synchronisation -all of which are great aspects to the Conductor4SQL product.

SessionID: 59644

Intro to Azure Data Lake and U-SQL

Back to calendar

Event Date: 11-02-2017 - Session time: 11:25:00 - Track: Analytics and Visualization

Speaker: Julie Koesmarno

Title: Intro to Azure Data Lake and U-SQL

Abstract:

With ever growing demand to store different types of data and provide intelligent analytics, it can be a challenging task for data professionals. Join this session to learn more about the on-demand scalable platform for big data analysis, Azure Data Lake, that allows you to use language that you are already familiar with. This session will show case an end-to-end demo using Azure Data Lake for image processing and text analysis.

SessionID: 56508

Oh, When did THAT change happen?

Back to calendar

Event Date: 11-02-2017 - Session time: 14:05:00 - Track: Application Database Development

Speaker: Martin Catherall

Title: Oh, When did THAT change happen?

Abstract:

“Oh, when did that change happen?” is a reasonably common question that SQL consultants hear.

Closely followed by “who made that change?” and possibly “how do we revert the change?”. There’s a few mechanisms available in SQL Server to do this – but we have to have these active in order to capture information about the change. In this session, we’ll look at some of the options that we have available to us for auditing data (and meta data) changes. These include SQL Audit and the new Temporal tables and Query Store features among other. You should leave this session with a firm knowledge of which feature is right for your auditing scenario.

SessionID: 56684

Automate Data Warehouse build and deployment (db,SSIS SSAS) with Visual Studio 2015 and TFS

Back to calendar

Event Date: 11-02-2017 - Session time: 14:05:00 - Track: BI Platform Architecture, Development Administration

Speaker: Adam Gilmore

Title: Automate Data Warehouse build and deployment (db,SSIS SSAS) with Visual Studio 2015 and TFS

Abstract:

See a demonstration of automated generation, build and deployment of a Data Warehouse (database, SSIS and SSAS) using Visual Studio 2015 and 'Visual Studio Team Services' Online.

It's not enough to 'do' Agile you must 'be' Agile...

This means modifying, building and deploying your DW/BI solution, on a daily/weekly basis. Achieving this without automation is very difficult.

Topics include:

1. Visual Studio 2015 and Visual Studio Team Services Online licencing for BI developers (things have changed).
2. A primer on setting up a project in 'Visual Studio Team Services'.
3. Automated Data Warehouse development (code generation) in Visual Studio 2015.
4. Using MSBUILD, Source Control and Build Release functionality of 'Visual Studio Team Services' to automate the build and deployment of a Data Warehouse, SSIS and SSAS Cubes to multiple environments.

Grab a free script at the end to get you started.

SessionID: 56723

2016 – The Rise and Fall of DBM

Back to calendar

Event Date: 11-02-2017 - Session time: 14:05:00 - Track: Enterprise Database Administration Deployment

Speaker: Warwick Rudd

Title: 2016 – The Rise and Fall of DBM

Abstract:

With the release of SQL Server 2016, a true shift achieving and implementing High Availability and Disaster Recovery has come about. Database Mirroring has been the only option available to meet certain requirements. SQL Server 2016 now changes the game and in this session Warwick will introduce you to the replacement for DBM taking you through what there is, what it gives you and how you can move from DBM to AGs.

SessionID: 57170

Making DevOps work in the wild...

Back to calendar

Event Date: 11-02-2017 - Session time: 14:05:00 - Track: Strategy and Architecture

Speaker: Hamish Watson

Title: Making DevOps work in the wild...

Abstract:

You may have heard about DevOps and wondered whether it is just another buzzword and/or what it can do for you and your organisation.

In this session I will demystify the concepts of DevOps and more importantly show it in action in a real life application deployment pipeline. By using a realistic live demonstration and great technologies such as the Azure platform, Team Foundation Server, SSDT and docker on Windows Server 2016 I will show how DevOps can help you automate deploys reliably and repeatedly to your production applications. You will be able to take what you learned in this session and implement it successfully in your organisation.

SessionID: 57172

Adding Powershell to Your Skillset

Back to calendar

Event Date: 11-02-2017 - Session time: 14:05:00 - Track: Enterprise Database Administration Deployment

Speaker: Rob Douglas

Title: Adding Powershell to Your Skillset

Abstract:

Powershell is not new, but to those bred and raised on the GUI it can be incredibly intimidating. This session is a complete beginners guide to understanding Powershell, how it works and what you can do with it. You'll learn what a cmdlet is, what it does and how you can make it work for you.

Most importantly - you'll learn how Powershell can make your job administering a SQL server easier and allow you to do more, faster.

SessionID: 57283

What's new in Azure SQL DB and SQL engine

Back to calendar

Event Date: 11-02-2017 - Session time: 14:05:00 - Track: Azure Services and Platform

Speaker: Lindsey Allen

Title: What's new in Azure SQL DB and SQL engine

Abstract:

I will share the new improvements in Azure SQL DB and SQL engine

SessionID: 54458

Plan, Design and Implement a HADR Solution - a Journey

Back to calendar

Event Date: 11-02-2017 - Session time: 15:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Manohar Punna

Title: Plan, Design and Implement a HADR Solution - a Journey

Abstract:

Have you ever struggled to get a HA and DR solution for a single instance with more than 50 applications, 100 databases and 4 TB of data?

Over the years, HA and DR has been a challenge with SQL Server. As the product evolved so did the options simplified for achieving a feasible HADR solution. In this session I will walk you through various projects I have worked on in past 8 years. I will start with the basic DR solution built using Log shipping, an alternate to AGs in SQL 2008 using Powershell/.NET and SAN Replication and the latest 4 node, two site cluster built with Availability Groups.

SessionID: 56876

Database Administration for Azure SQL DB

Back to calendar

Event Date: 11-02-2017 - Session time: 15:15:00 - Track: Azure Services and Platform

Speaker: Martin Cairney

Title: Database Administration for Azure SQL DB

Abstract:

Azure SQL DB promises low touch once you have deployed your database. However the reality is that to gain the maximum benefit and lowest cost, you still need to be proactive with monitoring and management of your database.

This session will identify the main aspects of the Azure SQL DBA role, including how to ensure you have longer term backups (if you need them for compliance), how to manage your Tier level automatically, how to ensure you have the best performance to keep your DTUs to a minimum. You will leave this session with a better story for your manager to convince him to move your workload to Azure and lower your total SQL Server costs.

SessionID: 56963

SQL Server on Linux - The How, the What and the Why?

Back to calendar

Event Date: 11-02-2017 - Session time: 15:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Patrick Flynn

Title: SQL Server on Linux - The How, the What and the Why?

Abstract:

In this Demo Heavy Session we will explore the recently released SQL Server on Linux

Join me as we try to understand questions like? How do we install and run SQL Server on Linux? What is different, what is the same? What may be better? What might be worse? Why would it be useful? What new skills will you need?

The presentation will be based around experience gained in evaluating the Public CTP and will help introduce you into the brave new world of SQL Server on Linux

SessionID: 56973

Scalable Application Design with Service Broker

Back to calendar

Event Date: 11-02-2017 - Session time: 15:15:00 - Track: Application Database Development

Speaker: Allen White

Title: Scalable Application Design with Service Broker

Abstract:

How your business applications interact directly with the corporate database can dramatically affect how successful you are. One of the biggest issues is performance with large databases. By designing the application to use asynchronous messaging for non-critical updates, you can focus performance concerns where the timeliness is critical. SQL Server Service Broker handles the asynchronous requests quickly and efficiently and minimizes conflicts with your critical updates. This session walks you through the steps to get Service Broker running and providing a consistent delivery of your business data.

SessionID: 57167

Creating High Performance Tabular Models

Back to calendar

Event Date: 11-02-2017 - Session time: 15:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: James Beresford

Title: Creating High Performance Tabular Models

Abstract:

In this session James will use his experience building large cubes for large organisations and show how you can optimise all aspects of the process - preparing data for load, processing tips and how to get the thing to perform as users expect.

SessionID: 57240

Why your charts suck and how to fix them

Back to calendar

Event Date: 11-02-2017 - Session time: 15:15:00 - Track: Analytics and Visualization

Speaker: Darren Gosbell

Title: Why your charts suck and how to fix them

Abstract:

Building effective data visualizations is an increasingly important skill. As data professionals the amount of data and the speed at which it is arriving is constantly growing. At the same time our business users are increasingly time poor in a world filled with distractions and shiny things. With social media, instant messaging, conference calls and emails if the message that you are trying to convey is not clear, engaging and easy to understand it will not get the attention that it deserves.

Clicking next, next, next, finish on a chart wizard is not the way to build engaging data visualizations.

In this presentation we will look at what you need to consider to build clear and engaging data visualizations and what pitfalls you should avoid.

SessionID: 54832

DW SuperHero-Columnstore Index

Back to calendar

Event Date: 11-02-2017 - Session time: 16:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Manjot Kaur

Title: DW SuperHero-Columnstore Index

Abstract:

Columnstore indexes were introduced in SQL 2012. They have the superpower to boost SQL server performance by flipping row based indexing to column based indexing. In this session, we will cover basics of this technology, its usability, performance impact, implementation (through demo), access mechanism and what's new in SQL 2016.

SessionID: 56411

R for Database Administrators

Back to calendar

Event Date: 11-02-2017 - Session time: 16:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Nagaraj Venkatesan

Title: R for Database Administrators

Abstract:

"R", the latest buzzword in data platform, has all along been viewed as programming language for data scientists. However, "R" can be a handy tool for database administrators too. The presentation will show case how "R" can be used innovatively by Database Administrators to handle some of their common problems like tracking query regressions, capacity planning and detecting performance abnormalities. The session will introduce few algorithms of "R" and showcase how it can be used in DBA's world. The session would serve as a good starting point for DBA's exploring the world of "R"

SessionID: 56483

Azure Cognitive Services - The Rise of the Machines!

Back to calendar

Event Date: 11-02-2017 - Session time: 16:30:00 - Track: Azure Services and Platform

Speaker: Rolf Tesmer

Title: Azure Cognitive Services - The Rise of the Machines!

Abstract:

With advances in computing power, advanced machine learning algorithms and globally consumable data sources the real world use cases for Cognitive Services within our everyday lives has begun to grow significantly. This fun and demo heavy session first introduces the full suite of Azure Cognitive Services API’s and discusses the approach to solution design, API deployment and consumption within the context of a set of real deployments and practical use cases. The session then deep dives into 2 of the more commonly deployed Azure Cognitive Services detailing methods available for SQL and .Net developers to code, interact, and scale the usage of the Cognitive API services to create interesting, fun and innovative solutions. At the end of this session you will have a much clearer understanding of how the suite of Azure Cognitive Services could be used within your business and the methods available by which you can start to plan, deploy and actively consume these innovative services.

SessionID: 56865

R; One Ring to Rule Them All

Back to calendar

Event Date: 11-02-2017 - Session time: 16:30:00 - Track: Analytics and Visualization

Speaker: Leila Etaati

Title: R; One Ring to Rule Them All

Abstract:

R is one of the most popular and powerful analytics languages. That helps data scientists to prepare data, predict data, and visualize it. Microsoft offers several deployment options to bring next-generation advanced analytics to your business. Microsoft R Server delivers R-based analytics to where your data lives. Processing analytics in-place eliminates data movement, reducing latencies and operational costs.

In this session, first basic concepts of machine learning will be discussed. Then, a demo of how to use R for data wrangling, and visualization (show map) in R studio will present. Then I will show how R can be helpful for software developers to create a intelligence software using R in visual studio and Azure ML API in c# codes. Finally a couple of demos will be presented on how R can help BI developers and database administrators using R server ,R in SQL Server 2016, and power BI to create smart reports.

SessionID: 56904

SQL Server 2016 SP1: Enhancements that will make your SQL Server roar!

Back to calendar

Event Date: 11-02-2017 - Session time: 16:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Sunil Agarwal

Title: SQL Server 2016 SP1: Enhancements that will make your SQL Server roar!

Abstract:

This session will showcase several improvements in SQL Server 2016 SP1 that address some of the most common customer pain points with HA and the Database Engine. as well as diagnostics. Understand these changes in performance and scale, and the new and improved diagnostics for faster troubleshooting and mitigation.

SessionID: 59688

How to Use Parameters Like a Pro and Boost Performance

Back to calendar

Event Date: 11-02-2017 - Session time: 16:30:00 - Track: Application Database Development

Speaker: Guy Glantser

Title: How to Use Parameters Like a Pro and Boost Performance

Abstract:

Parameters are a fundamental part of T-SQL programming, whether they are used in stored procedures, in dynamic statements or in ad-hoc queries. Although widely used, most people aren't aware of the crucial influence they have on query performance. In fact, wrong use of parameters is one of the common reasons for poor application performance.

In this session we will learn about plan caching and how the query optimizer handles parameters. We will talk about the pros and cons of parameter sniffing as well as about simple vs. forced parameterization. But most important – we will learn how to identify performance problems caused by poor parameter handling, and we will also learn many techniques for solving these problems and boosting your application performance.

This site is open source. Improve this page.