Nr: 635
SQLSaturday #635 - Vancouver 2017
SessionID: 61685
Power BI : Dashboard in an hour
Event Date: 26-08-2017 - Session time: 09:00:00 - Track: Power BI
Speaker: Sophie Marchand
Title: Power BI : Dashboard in an hour
Abstract:
*** Attendees must bring their own laptop.
During this one-hour session, attendees will learn how to import, transform and merge data with Power BI. They will also learn how to create and share reports and dashboards. They will also learn how to use natural language to ask questions and get answers. Finally, the will learn how to use the Power BI Mobile app to consume their reports and dashboards.
https://www.eventbrite.com/e/power-bi-dashboard-in-an-hour-tickets-37301476721
This is a hands-on session for beginners. You will be invited to download Power BI Desktop (preferably before the session) at https://powerbi.microsoft.com/en-us/desktop/ and you will be invited to create a free Power BI Service account.
SessionID: 62718
Back to the Future with Temporal Tables
Event Date: 26-08-2017 - Session time: 09:00:00 - Track: dev
Speaker: Randolph West
Title: Back to the Future with Temporal Tables
Abstract:
Back to the Future is the greatest time travel movie ever. I'll show you how temporal tables work, in both SQL Server and Azure SQL Database, without needing a DeLorean. We cover point in time analysis, reconstructing state at any time in the past, recovering from accidental data loss, calculating trends, and my personal favourite: auditing. There's even a bit of In-Memory OLTP. This is a demo-heavy session.
SessionID: 66635
SQL Server Containers and Clones
Event Date: 26-08-2017 - Session time: 09:00:00 - Track: DBA
Speaker: Paul Stanton
Title: SQL Server Containers and Clones
Abstract:
“Containers and Clones for SQL Server Development and Test”
Microsoft is emphasizing the use of containers for development and test on SQL Server 2017, and new solutions from Red Gate and Windocks add support for containers and SQL Server database database cloning, for the full range of the SQL Server family. We’ll explore use of Docker based tooling for delivery of container environments, and their pros and cons. We’ll also look at SQL Server cloning, and how clones enable Dev and Test teams to work on large database environments for containers as well as existing SQL Server instances.
SessionID: 67102
Power BI Report Server: Self-service BI and Enterprise reporting on-premises
Event Date: 26-08-2017 - Session time: 09:00:00 - Track: Power BI
Speaker: Chris Finlan
Title: Power BI Report Server: Self-service BI and Enterprise reporting on-premises
Abstract:
Love Power BI but need an on-premises solution today? Meet Power BI Report Server -- self-service analytics and enterprise reporting, all in one on-premises solution. Design beautiful, interactive reports in Power BI Desktop, publish them to Power BI Report Server, and view and interact with them in your web browser or the Power BI app on your phone. And since Power BI Report Server includes the proven enterprise reporting capabilities of SQL Server Reporting Services, it can even run your existing Reporting Services reports too. Join me for an overview of Power BI Report Server, a demo of its features in action, and what's coming next.
SessionID: 67230
Internet Of Things: Smart Mirror
Event Date: 26-08-2017 - Session time: 09:00:00 - Track: Other
Speaker: Andrew Cook
Title: Internet Of Things: Smart Mirror
Abstract:
A look at the intersection of hardware, software, and internet. See what it takes to bring your next workshop project to life including stories about the success and failures of creating a Smart Mirror. We will take a look into hardware including that from the hardware store and the software required to make the magic happen.
SessionID: 62408
Make your data mobile with Power BI
Event Date: 26-08-2017 - Session time: 10:00:00 - Track: Power BI
Speaker: Ken Puls
Title: Make your data mobile with Power BI
Abstract:
As amazing as our Power BI reports and dashboards are, they are designed for a full sized web page, not the smaller mobile phone screen. In this session Ken will walk through the process of taking a regular Power BI report and then optimizing both the report and dashboard for mobile consumption, all with tools built in to the Power BI ecosystem. We’ll look at changing layouts, location filtering, setting alerts, annotations and more!
SessionID: 65206
Data Visualization: How to truly tell a great story!
Event Date: 26-08-2017 - Session time: 10:00:00 - Track: Other
Speaker: Jonathan Stewart
Title: Data Visualization: How to truly tell a great story!
Abstract:
We have more information available to us today than ever before. So much so that we run the risk of not being able to tell concise stories. There's a lot more to creating that story than just getting the correct information. Come learn not just the do's and don'ts, but the whys…
SessionID: 65325
Columnstore Index Primer
Event Date: 26-08-2017 - Session time: 10:00:00 - Track: dev
Speaker: Sepand Gojgini
Title: Columnstore Index Primer
Abstract:
SessionID: 67060
Azure SQL Data Warehouse for the SQL Server DBA
Event Date: 26-08-2017 - Session time: 10:00:00 - Track: DBA
Speaker: Warner Chaves
Title: Azure SQL Data Warehouse for the SQL Server DBA
Abstract:
The power of cloud storage and compute power has made data warehousing possible for businesses of all sizes. What was once a large capital expenditure and multi-year implementation can now be deployed and ready to use within minutes and allow any organization to collect, query and discover insights from their structured data sources.
With a full T-SQL interface and compatibility with the rest of the Microsoft data stack, Azure Data Warehouse can fit transparently into your business data strategy and leverage already existing and familiar development and management skills.
In this session we will look at the main concepts of the Azure SQL Data Warehouse service, how it's different than SQL Server and the advantages it provides to an on-premises solution.
SessionID: 67158
Azure Data Technologies Overview
Event Date: 26-08-2017 - Session time: 10:00:00 - Track: Azure
Speaker: Anthony Chu
Title: Azure Data Technologies Overview
Abstract:
With the shift to microservice architectures, gone are the days where all of an organization’s data is stored in a single, massive, relational database. We’re quickly shifting to a polyglot persistence approach for dealing with data — using separate data stores that are each best suited to the data being stored.
We’ll look at the wide variety of managed services available to store data on Microsoft Azure including the usual suspects such as SQL DB, MySQL, PostgreSQL, Table Storage, and others like Cosmos DB, Redis, Search, and more. The audience will walk away with a broad understanding of Azure’s data portfolio and be able select the right tools to meet their data persistence needs.
SessionID: 63749
Oracle vs. SQL Server Indexing- The Good, the Bad and the Ugly
Event Date: 26-08-2017 - Session time: 11:00:00 - Track: DBA
Speaker: Kellyn Pot'Vin-Gorman
Title: Oracle vs. SQL Server Indexing- The Good, the Bad and the Ugly
Abstract:
Takeaways are:
- Receive a strong education on platform differences between Oracle and SQL Server.
- Discover hidden insight on index storage and costs.
- Learn about great tips on maintaining index health and how one platform may perform better than the other and how.
- Translation of common features in both platforms
SessionID: 64651
The Science of Success: Building Faith in a Data Warehouse
Event Date: 26-08-2017 - Session time: 11:00:00 - Track: DW/BI
Speaker: Todd McDermid
Title: The Science of Success: Building Faith in a Data Warehouse
Abstract:
Despite our broad expertise of data tools, the robotic consistency of the computational resources they leverage, and the immutable GIGO law - presenting a reasoned and thorough validation process often isn't enough. Trust isn't given instantly, it has to be earned. The strongest faith is built by participation, and repetition.
Learn how to leverage your tooling expertise in SSIS and SQL to build a dead-simple framework to build faith in data. Leverage analyst and business user questions and angst into repeatable, consistent proof of correctness - that's the science of success for a data warehouse.
SessionID: 67101
What is new and exciting in Power BI
Event Date: 26-08-2017 - Session time: 11:00:00 - Track: Power BI
Speaker: Charles Sterling
Title: What is new and exciting in Power BI
Abstract:
SessionID: 67242
Azure DataFactory for heterogeneous Cloud sources
Event Date: 26-08-2017 - Session time: 11:00:00 - Track: Azure
Speaker: Mohamed Mawla
Title: Azure DataFactory for heterogeneous Cloud sources
Abstract:
Explore Usage of Azure Datafactory to mesh data from various cloud offerings such as AWS and Google Cloud. Many vendors would have more than one cloud offering and they would bring the data together. We will explore strategies to connect data from various sources, obstacles, workarounds, troubleshooting and best practices, all hands-on
SessionID: 67280
How a traditional CMS went from on-prem SQL Server to Azure based CosmosDB, Search, Stream Analytics
Event Date: 26-08-2017 - Session time: 11:00:00 - Track: Azure
Speaker: Ash Prasad
Title: How a traditional CMS went from on-prem SQL Server to Azure based CosmosDB, Search, Stream Analytics
Abstract:
Learn the journey of an Open Source Content Management's move from on premise to the cloud. DNN (formerly known as DotNetNuke) has traditionally been an on-premise solution on IIS and SQL Server. While building a new solution for content management we literally hit a limit with the on-premise Sql Server tools. We needed a schema free database - DocumentDB came to rescue. Find out why we didn't go with MongoDB. We also needed search capability, where Azure Search became the tool of choice. We need logging and telemetry from our application - App Insights was chosen. We also use Event Hubs, Stream Analytics and Data Lake. I will talk about all of these here, and present you a full picture on how to build real life scalable business applications using Azure technologies. We will focus mostly on the Data aspects of the architecture in this session.
SessionID: 67093
Excel and SSIS: Better Together
Event Date: 26-08-2017 - Session time: 12:00:00 - Track: DW/BI
Speaker: Diane Schuster
Title: Excel and SSIS: Better Together
Abstract:
If you’ve ever used the standard Excel Source or Destination components in SSIS, you know there are some limitations. Cozyroc’s Excel Source Plus and Excel Destination Plus components remove those limitations. In addition, Cozyroc’s Excel Task enables editing of Excel files from SSIS packages. In this session, I’ll talk about the capabilities of the Cozyroc components and demonstrate how easy it is use use these components with SSIS.
SessionID: 68951
No future for the DBA
Event Date: 26-08-2017 - Session time: 12:00:00 - Track: Other
Speaker: Andrew Boudreau
Title: No future for the DBA
Abstract:
SessionID: 68990
Using SQL Server on Amazon Web Services
Event Date: 26-08-2017 - Session time: 12:00:00 - Track: DBA
Speaker: Michael Barras
Title: Using SQL Server on Amazon Web Services
Abstract:
Learn how to deploy SQL Server in Amazon Web Services, either self-managed on the Amazon Elastic Compute Cloud (EC2) or use the Amazon Relational Database Service (RDS) for a managed solution. We will cover key aspects of AWS, deployment options for SQL Server, managed High Availability with RDS, and data migration.
SessionID: 66885
Modern Reporting with SQL Server 2016 and 2017 Reporting Services
Event Date: 26-08-2017 - Session time: 13:00:00 - Track: Power BI
Speaker: Paul Turley
Title: Modern Reporting with SQL Server 2016 and 2017 Reporting Services
Abstract:
This session covers:
• What’s new in Reporting Services 2017 (and 2016)?
• Reporting Services and Power BI Report Server Architecture
• Parameter improveme
SessionID: 67232
The Power of Caching
Event Date: 26-08-2017 - Session time: 13:00:00 - Track: dev
Speaker: Andrew Cook
Title: The Power of Caching
Abstract:
Redis is an open source, in-memory data structure store, used as a database, cache and message broker.
SessionID: 67238
Introduction to Azure Data Lake and U-SQL for SQL users
Event Date: 26-08-2017 - Session time: 13:00:00 - Track: Azure
Speaker: Michael Rys
Title: Introduction to Azure Data Lake and U-SQL for SQL users
Abstract:
SessionID: 67241
Linux essential Skills for Mouse clicker DBAs
Event Date: 26-08-2017 - Session time: 13:00:00 - Track: DBA
Speaker: Mohamed Mawla
Title: Linux essential Skills for Mouse clicker DBAs
Abstract:
With SQL Server almost available on Linux, seasonal SQL Server DBAs, who spent most of their work on Windows, should hone their skills on Linux.
The session will explore the essential skills needed to manage SQL server on Linux. It will also explore the most common tasks and procedures DBAs commit on Windows and their equivalents on Linux. Some troubleshooting skills on Linux will be explored, as well
SessionID: 68853
Biml for Beginners: Speed Up Your SSIS Development
Event Date: 26-08-2017 - Session time: 13:00:00 - Track: DW/BI
Speaker: Cathrine Wilhelmsen
Title: Biml for Beginners: Speed Up Your SSIS Development
Abstract:
Are you tired of creating and updating the same SSIS packages again and again? Is your wrist hurting from all that clicking, dragging, dropping, connecting and aligning? Do you want to take the next step and really speed up your SSIS development?
Say goodbye to repetitive work and hello to Biml, the markup language for Business Intelligence projects.
In this session we will look at the basics of Biml. First learn how to use Biml to generate SSIS packages from database metadata. Then see how you can reuse code to implement changes in multiple SSIS packages and projects with just a few clicks. Finally, we will create an example project that you can download and start with to speed up your SSIS development from day one.
Stop wasting your valuable time on doing the same things over and over and over again, and see how you can complete in a day what once took more than a week!
SessionID: 61654
Using Database Replication to Make Your Oracle Data Available in SQLServer
Event Date: 26-08-2017 - Session time: 14:00:00 - Track: DBA
Speaker: Clay Jackson
Title: Using Database Replication to Make Your Oracle Data Available in SQLServer
Abstract:
SessionID: 65208
Event Date: 26-08-2017 - Session time: 14:00:00 - Track: DW/BI
Speaker: Jonathan Stewart
Abstract:
SessionID: 66968
Why Should I Care About ... Partitioned Views?
Event Date: 26-08-2017 - Session time: 14:00:00 - Track: dev
Speaker: Rick Lowe
Title: Why Should I Care About ... Partitioned Views?
Abstract:
Partitioned tables are awesome and partitioned views are dead, right? Well, sure partitioned views are not sexy but there are still plenty of applications where they are critical. And not necessarily just for standard edition who aren't on the new service pack yet. If your data is time stamped, do you see different queries run against older data than new data? Do you with you could segment your data across multiple columns? Do you have data you need to partition horizontally? It's possible partitioned views may still be for you. Come hear why this is still an important topic long after cargo pants and trucker hats went away ... and possibly even after 2016 SP1.
SessionID: 67229
A Deep-Dive with Azure Cosmos DB: Microsoft's globally distributed, multi-model database
Event Date: 26-08-2017 - Session time: 14:00:00 - Track: Azure
Speaker: Andrew Liu
Title: A Deep-Dive with Azure Cosmos DB: Microsoft's globally distributed, multi-model database
Abstract:
Azure Cosmos DB is the first and only globally distributed, multi-model database system. The service is designed to allow customers to elastically and horizontally scale both throughput and storage across any number of geographical regions, it offers guaranteed less than 10 ms latencies at the 99th percentile, 99.99% high availability and five well defined consistency models to developers. It’s been powering Microsoft’s internet-scale services for years.
In this session, we will cover how you can get the most out of Azure Cosmos DB by gaining a deep insight in to the system internals. From global distribution to partitioned collections to automatic indexing - this session will equip you with invaluable insight in to building blazingly fast planet-scale applications
SessionID: 67279
DAX Filters: A Quest for Clarity
Event Date: 26-08-2017 - Session time: 14:00:00 - Track: Power BI
Speaker: Derek Rickard
Title: DAX Filters: A Quest for Clarity
Abstract:
If you are working with SSAS Tabular, Power BI, or good ol' Power Pivot for Excel, you've likely run into a need for DAX, the formula and query language of these tools. A very common task is to augment, override, or otherwise modify a filter context. This sounds easy enough, but if you've had experience beyond simple filters, the syntax and behavior may seem confusing, or worse, counter-intuitive. The purpose of this presentation is to discuss the different types of filters, their behavior, and their interactions with other DAX formulas.
SessionID: 61647
How SQL Server 2016 SP1 changes the game | Microsoft Dev Team
Event Date: 26-08-2017 - Session time: 15:00:00 - Track: DBA
Speaker: Sunil Agarwal
Title: How SQL Server 2016 SP1 changes the game | Microsoft Dev Team
Abstract:
Service Pack 1 for SQL Server 2016 was released to the market in November. It brings lot of enhancements and value for a customer that can greatly improve their experience with SQL Server. This session will cover some of the key enhancements that will entice a customer to upgrade to SQL Server 2016. In this session, we’ll also talk about several supportability and diagnostic improvements in the database engine and high availability technologies that will help customer and the field quickly identify and resolve issues in a mission-critical environment.
SessionID: 64005
Give more power to the users! - Decision Support Using Power BI
Event Date: 26-08-2017 - Session time: 15:00:00 - Track: Power BI
Speaker: Yana Berkovich
Title: Give more power to the users! - Decision Support Using Power BI
Abstract:
SessionID: 67053
Event Date: 26-08-2017 - Session time: 15:00:00 - Track: DBA
Speaker: Warner Chaves
Abstract:
Platform as a Service offerings make this even easier now, enabling developers to roll out their own database infrastructure in minutes with minimal management overhead. However, this same amount of flexibility also comes with the challenges of picking the right tool, on the right provider and with the proper expectations. All of these are new challenges that are coming into the field of responsibility of the SQL DBA professional.
In this session we'll compare the NoSQL and SQL offerings from AWS, Microsoft Azure and Google Cloud, their use cases for each one based on our own client projects, and how they are different to the different SQL Server features we are familiar with.
SessionID: 67239
U-SQL Killer scenarios: Custom Processing, Big Cognition, Image and JSON processing at Scale
Event Date: 26-08-2017 - Session time: 15:00:00 - Track: Azure
Speaker: Michael Rys
Title: U-SQL Killer scenarios: Custom Processing, Big Cognition, Image and JSON processing at Scale
Abstract:
When analyzing big data, you often have to process data at scale that is not rectangular in nature and you would like to scale out your existing programs and cognitive algorithms to analyze your data. To address this need and make it easy for the programmer to add her domain specific code, U-SQL includes a rich extensibility model that allows you to process any kind of data, ranging from CSV files over JSON and XML to image files and add your own custom operators. In this presentation, we will provide some examples on how to use U-SQL to process interesting data formats with custom extractors and functions, including JSON, images, use U-SQL’s cognitive library and finally show how U-SQL allows you to invoke custom code written in Python and R.
SessionID: 68022
Ask The Experts
Event Date: 26-08-2017 - Session time: 15:00:00 - Track: Other
Speaker: Ken Puls
Title: Ask The Experts
Abstract:
Experts in all the represented fields will be answering your questions in this room. First come first answered!