Nr: 890
SQLSaturday #890 - Austin 2019
SessionID: 92078
XML and JSON, does the DBA need it?
Event Date: 13-07-2019 - Session time: 08:30:00 - Track: SQL Dev
Speaker: Alex Grinberg
Title: XML and JSON, does the DBA need it?
Abstract:
SessionID: 93230
Azure SQL Managed Instance the New Hotness
Event Date: 13-07-2019 - Session time: 08:30:00 - Track: Azure
Speaker: Ryan Adams
Title: Azure SQL Managed Instance the New Hotness
Abstract:
You can't wait to move your databases to an Azure PaaS offering so you don't have to patch and maintain an operating system and SQL Server. You looked at Azure SQL DB, but there are some limitations that prevent you from migrating to this service. Don't worry, you're not stranded. There is a new option designed to "Lift and Shift" your workload to Azure PaaS. It's a brand new offering that just came out of private preview and into public preview. We'll discuss this new offering, its advantages, and how you can migrate with ease.
SessionID: 93283
A Perfect Ten: The Data Model
Event Date: 13-07-2019 - Session time: 08:30:00 - Track: BI
Speaker: Leslie Andrews
Title: A Perfect Ten: The Data Model
Abstract:
SessionID: 93354
Introduction To Data Governance
Event Date: 13-07-2019 - Session time: 08:30:00 - Track: DevOps
Speaker: Warren Sifre
Title: Introduction To Data Governance
Abstract:
Data Governance has been seen by many as a very SCARY and BIG thing requiring biblical efforts to understand and more so to implement. Our discussion will provide context for what, why, and how of Data Governance. You will have an understanding of this and more importantly a road map for how to begin to implement and evangelize within the organization.
SessionID: 93890
The Future of Database Development with Containers
Event Date: 13-07-2019 - Session time: 08:30:00 - Track: DevOps
Speaker: Steve Jones
Title: The Future of Database Development with Containers
Abstract:
Containers are dramatically changing the way that application developers design and build their systems. Databases will need to be a part of this revolution as every application needs a data store. Come see a future vision of how full stack application development might look in the next few years.
SessionID: 94132
Mastering locks and blocks
Event Date: 13-07-2019 - Session time: 08:30:00 - Track: Performance Tuning
Speaker: Daniel Janik
Title: Mastering locks and blocks
Abstract:
Is blocking giving you grief? How do you know if locking and concurrency is dragging you down? In this session you'll learn the master techniques and tips to solving all your blocking and deadlock troubles.
SessionID: 94134
Querying Semistructured Data in Azure Data Lake with USQL
Event Date: 13-07-2019 - Session time: 08:30:00 - Track: Azure
Speaker: Russel Loski
Title: Querying Semistructured Data in Azure Data Lake with USQL
Abstract:
Data is exploding across enterprises. Much of it is semi-structured junk. Or is it junk? What are you going to do with it until you can find out? Microsoft’s Azure Data Lake is a cloud storage and analytical service for parking a variety of data. I have stored in Azure Data Lake Store several gigabytes of US Census data at a reasonable rate per month. Now I can query that semi-structured data using an ANSI SQL language called U-SQL. In this session I will demonstrate the similarities and differences between U-SQL and T-SQL. I will demonstrate how easy it is to build a query against 21 GB of CSV files. Such queries can help you determine whether you have a gold mine in your data or a bunch of garbage before investing in a full data warehouse build.
SessionID: 94937
Annoyed with a stubborn pivot table? PowerPivot is your answer.
Event Date: 13-07-2019 - Session time: 08:30:00 - Track: BI
Speaker: Toni Haag
Title: Annoyed with a stubborn pivot table? PowerPivot is your answer.
Abstract:
This session is for you if you’ve ever built an amazing data set that was everything you needed, but then you went to create a dashboard, you got annoyed by any of the following:
-Your boss won’t approve the costs to get PowerBI Desktop.
-You’re not a coder, so learning R or Python sounds super scary
-You add a whole bunch of columns to your data set and now your file size is gargantuan
-You add a field to a pivot table and the grand total row makes no reasonable sense
-Your average between two dates is 2.6166666667; how many hours and minutes is that?
-You add a date field to a pivot table and the month names get sorted alphabetically
-You add a graph to your dashboard, but have to add a table that will be hidden from a user later
-The two new pivot tables make your dashboard looks out of whack
Providing an overview of the above, the demos will give an insight into how powerful PowerPivot, PowerBI, and DAX can be. I'll provide cool tricks and new ideas on what to search
SessionID: 92065
SQL DevOps Simplified with Production Databases
Event Date: 13-07-2019 - Session time: 09:40:00 - Track: DevOps
Speaker: Paul Stanton
Title: SQL DevOps Simplified with Production Databases
Abstract:
DevOps is based on building an application binary (immutable artifact) that supports a highly reliable, repeatable engineering process. In the case of SQL Server, however, a database is already in production and isn’t simply replaced (as an app binary), but is upgraded. Current SQL Server DevOps methods use source control to build a “development” database, with schema and objects and static data needed for functional testing. "Near production data" is used in Staging, and finally production is upgraded. This approach involves complexity, and breaks the principle of working with immutable artifacts throughout the process. Our session introduces a new approach to SQL Server DevOps, with production databases used in all stages. Production database clones are delivered more quickly than "built" databases, are more easily integrated with source control, and produces higher fidelity outcomes. Learn how leading enterprises are simplifying SQL DevOps.
SessionID: 92072
Power BI Dashboard - Creating End to End Solutions
Event Date: 13-07-2019 - Session time: 09:40:00 - Track: BI
Speaker: Suresh Datla
Title: Power BI Dashboard - Creating End to End Solutions
Abstract:
We will be discussing the lifecycle of a Power BI Dashboard beginning from
Accessing data, Data preparation, and cleansing, consuming the data for reports and deploying the reports to Power BI services, configuring security and making the Dashboards available to end users.
SessionID: 92650
Make Database Documentation your Minion
Event Date: 13-07-2019 - Session time: 09:40:00 - Track: SQL Dev
Speaker: Jennifer McCown
Title: Make Database Documentation your Minion
Abstract:
Most IT folks aren’t a fan of writing documentation. We are far more interested in creating solutions, solving problems, and making things go faster, than in documenting how we did it.
But, Future Us will need to know what Today Us meant with this procedure’s parameters, and what that job is even for. Coworkers will thank us for explaining choices made for design, development, and admin. How can we do this without a big Word document?
T-SQL comments are simple and natural to create, and can reduce your future troubleshooting time by ten times or more!
In this session you’ll learn innovative options for documenting using comments, like using expanded flower boxes, headers, “extended commenting” (also known as help systems), and more. We’ll also talk about the options available for non-comment-able objects: tables, SSIS packages, and SSRS reports.
Documenting via comments serves YOU. They’re your repository of tribal knowledge, your exobrain, and your minion. Come learn all about it
SessionID: 92939
Building Your First SQL Server Container Lab in Docker
Event Date: 13-07-2019 - Session time: 09:40:00 - Track: DBA
Speaker: Chris Bell
Title: Building Your First SQL Server Container Lab in Docker
Abstract:
In this session, we will go over the concepts of containers, their general capabilities, and then build, connect and configure a SQL Server in a container for use as a private lab.
SessionID: 93037
Overcoming Challenges with Source Control and Continuous Integration.
Event Date: 13-07-2019 - Session time: 09:40:00 - Track: DevOps
Speaker: Elizabeth Noble
Title: Overcoming Challenges with Source Control and Continuous Integration.
Abstract:
Have you tried implementing source control? How has your continuous integration (CI) process gone?
This session is for developers, database administrators, database engineers, and data architects that want to automate their database deployments. Particularly for those individuals that have hit roadblocks along that way. We will discuss the differences between migration and stated-based deployment methods. We will also discuss options with branching and merging.
At the end of the session, attendees will know how to select the best deployment method for their environment. In addition, attendees will be familiar with branching and merging strategies that can be used as part of their continuous integration strategy.
Attendees should be familiar with general concepts about source control and be comfortable with Visual Studio or VS Code.
SessionID: 93871
Python in SQL Server 2017 and 2019
Event Date: 13-07-2019 - Session time: 09:40:00 - Track: BI
Speaker: Chris Hyde
Title: Python in SQL Server 2017 and 2019
Abstract:
SQL Server 2017 and 2019 have arrived, bringing with them a host of exciting new features. Of particular interest to BI practitioners and data scientists is the integration of the Python programming language into the SQL ecosystem. This integration opens up a number of possibilities for in-database analytics and intelligent database applications, so let's get started!
In this introductory session we'll briefly introduce the Python language and then look at how to install and administer Machine Learning Services. We'll start to demonstrate the power of Python by showing you how to create and run simple scripts from within T-SQL. We'll then discuss some of the powerful open source packages that are available to aid your data analyses. Finally, we'll go through some examples of how to use Python to integrate data analytical methods in real-world situations, and wow your customers with the power of analytics!
SessionID: 94006
CosmosDB is the missing piece to your Data puzzle!
Event Date: 13-07-2019 - Session time: 09:40:00 - Track: Azure
Speaker: Hasan Savran
Title: CosmosDB is the missing piece to your Data puzzle!
Abstract:
I will cover the following topics in this session
Why do we need another database system?
How to setup Azure CosmosDB
How to create database and containers.
How much does it cost?
Multi-Model Apis
CosmosDB vs SQL Server
How to Import Data into CosmosDB
How to use Cosmos DB Emulator
CosmosDB Limitations
SessionID: 94896
Managing the mystery database
Event Date: 13-07-2019 - Session time: 09:40:00 - Track: DBA
Speaker: Dustin Dorsey
Title: Managing the mystery database
Abstract:
By figuring out what these mystery databases, you will be more equipped to make decisions on things several items such as the following:
• Decommissions
• Lower resource allocation and costs (especially for storage)
• Better planning for database migrations
• Troubleshoot connection issues
• Better planning for SQL upgrades
SessionID: 92076
Advanced T-SQL Development with latest features.
Event Date: 13-07-2019 - Session time: 10:50:00 - Track: SQL Dev
Speaker: Alex Grinberg
Title: Advanced T-SQL Development with latest features.
Abstract:
SessionID: 92645
The Master Stored Procedure Workshop: Part 1
Event Date: 13-07-2019 - Session time: 10:50:00 - Track: SQL Dev
Speaker: Sean McCown
Title: The Master Stored Procedure Workshop: Part 1
Abstract:
Your job includes designing and writing stored procedures, but you haven’t had a lot of actual training on the subject, right? I will show you how to write stored procedures from scratch, using the design advice I’ve accumulated in my 20+ years of experience.
Here are a few of the things you’ll learn:
When and how to use stored procedures
The benefits and basics of contractual programming
How to write stored procedures from scratch
How to structure and organize stored procedures
Key techniques for ideal stored procedure management
Troubleshooting and debugging stored procedures
The session will be packed with tons of code examples, with plenty of labs to reinforce key concepts. Beginner and experienced T-SQL programmers both will walk away with a greater understanding of how to design, manage, and troubleshoot stored procedures. Join mefor one fun session of SQL Server programming!
SessionID: 93762
PowerShell for the DBA
Event Date: 13-07-2019 - Session time: 10:50:00 - Track: DBA
Speaker: Amy Herold
Title: PowerShell for the DBA
Abstract:
In this session we will explore real-world examples and demonstrate how PowerShell can be leveraged by the DBA to not only improve efficiency but also streamline processes across an enterprise environment.
SessionID: 96045
Event Date: 13-07-2019 - Session time: 10:50:00 - Track: BI
Speaker: David Stein
Abstract:
You may heard that Biml can automate ETL loads, but what if your data warehouse is several terabytes with a tight load window. In this demo focused presentation, we’ll discuss how to use BimlScript to accomplish the following:
– Dynamically create multiple SISS packages for a data warehouse ETL load, each following a different best practice design pattern.
– Automatically execute each package multiple times and record the results for analysis.
– Determine which package version should be used in production.
The only way to be sure that your SSIS packages are performing optimally is to test them against multiple patterns. Make your life easier and let BimlScript do the work for you.
SessionID: 92062
A Primer on SQL Server Clustered Index Architecture
Event Date: 13-07-2019 - Session time: 11:00:00 - Track: Performance Tuning
Speaker: Mike Byrd
Title: A Primer on SQL Server Clustered Index Architecture
Abstract:
SessionID: 93635
An Animated Look at Query Plans
Event Date: 13-07-2019 - Session time: 11:00:00 - Track: Performance Tuning
Speaker: Forrest McDaniel
Title: An Animated Look at Query Plans
Abstract:
SessionID: 93870
Azure Databricks (ADB) and the Traditional DBA
Event Date: 13-07-2019 - Session time: 11:00:00 - Track: Azure
Speaker: Rodney Landrum
Title: Azure Databricks (ADB) and the Traditional DBA
Abstract:
SessionID: 96043
Make Your SQL Server Queries Go Faster
Event Date: 13-07-2019 - Session time: 12:20:00 - Track: Performance Tuning
Speaker: John Sterrett
Title: Make Your SQL Server Queries Go Faster
Abstract:
SessionID: 96044
Ntirety Lunch Session
Event Date: 13-07-2019 - Session time: 12:20:00 - Track: Performance Tuning
Speaker: Mike Burek
Title: Ntirety Lunch Session
Abstract:
Ntirety Lunch Session
SessionID: 92110
Sharing and Collaborating for the Pro Premium Power BI user
Event Date: 13-07-2019 - Session time: 13:15:00 - Track: BI Information Delivery
Speaker: DeNisha Malone
Title: Sharing and Collaborating for the Pro Premium Power BI user
Abstract:
Users will learn the best practices for collaborating in the Power BI web service. We’ll review apps vs workspaces, sharing reports with non-Pro accounts, setting up email alerts for your favorite reports, Sharepoint collaboration, and more! This session is all about the Power of teamwork in Power BI!
SessionID: 92112
Not All Data is Relational: An introduction to Cosmos DB
Event Date: 13-07-2019 - Session time: 13:30:00 - Track: Azure
Speaker: Shawn Weisfeld
Title: Not All Data is Relational: An introduction to Cosmos DB
Abstract:
In this session we will talk about the pros and cons of using a non-relational database and where it might fit best into your applications. We will then demonstrate these concepts using Cosmos DB. Azure Cosmos DB is Microsoft's globally distributed, multi-model database service. Cosmos DB enables you to elastically and independently scale throughput and storage across any number of Azure regions worldwide. You can also take advantage of fast, single-digit-millisecond data access using your favorite API including SQL, MongoDB, Cassandra, Tables, or Gremlin.
SessionID: 92646
The Master Stored Procedure Workshop: Part 2
Event Date: 13-07-2019 - Session time: 13:30:00 - Track: SQL Dev
Speaker: Sean McCown
Title: The Master Stored Procedure Workshop: Part 2
Abstract:
Your job includes designing and writing stored procedures, but you haven’t had a lot of actual training on the subject, right? I will show you how to write stored procedures from scratch, using the design advice I’ve accumulated in my 20+ years of experience.
Here are a few of the things you’ll learn:
When and how to use stored procedures
The benefits and basics of contractual programming
How to write stored procedures from scratch
How to structure and organize stored procedures
Key techniques for ideal stored procedure management
Troubleshooting and debugging stored procedures
The session will be packed with tons of code examples, with plenty of labs to reinforce key concepts. Beginner and experienced T-SQL programmers both will walk away with a greater understanding of how to design, manage, and troubleshoot stored procedures. Join mefor one fun session of SQL Server programming!
SessionID: 93129
Little to Large - How to Scale to Enterprise Analysis Services Solutions
Event Date: 13-07-2019 - Session time: 13:30:00 - Track: BI
Speaker: George Bryant
Title: Little to Large - How to Scale to Enterprise Analysis Services Solutions
Abstract:
In 2018 creating a cube is one of the more common tasks in BI, however what happens when the cube you build/inherit is growing so much? This session shows how to handle tabular models of size and details the fundamental considerations required in order to allow it to continue to scale. It also delves into what to think about when moving or building your cubes in Azure.
SessionID: 93889
Adopting a Compliant Database DevOps Process
Event Date: 13-07-2019 - Session time: 13:30:00 - Track: DevOps
Speaker: Steve Jones
Title: Adopting a Compliant Database DevOps Process
Abstract:
Presented by Redgate
DevOps is transforming software development, with many organizations and individuals adopting lean development practices, implementing Continuous Integration (CI), Continuous Deployment (CD), and performing on-demand deployments to their production environments. However, the database is largely ignored and seen as a bottleneck for a DevOps software development process. We will discuss the challenges of database development and deployment and examine why many developers find the database to be an impediment. We examine the risks of sensitive data in the development process and how you can ensure that data security concerns do not get in the way of the need for speed and agility. We’ll look at how you can adopt a Compliant Database DevOps approach that removes the database bottleneck while ensuring compliance with regulations governing the use of data within your organization such as GDPR, HIPPA or SOX. We’ll discuss the techniques used to include the data
SessionID: 94100
Event Date: 13-07-2019 - Session time: 13:30:00 - Track: Performance Tuning
Speaker: Kerry Tyler
Abstract:
But what if you could bypass support and do all of this analysis yourself?
In this session, you'll learn how to use battle tested tools to analyze your workload and error logs. Armed with this information, you'll understand the root cause of the problem and propose solutions to performance and stability problems.
SessionID: 94706
Event Date: 13-07-2019 - Session time: 13:30:00 - Track: DBA
Speaker: Kevin Hill
Abstract:
And it is probably not your fault.
90% of the SQL Servers I have seen in my 18 year career are just wrong. Not “crash” or “won’t start” wrong. More like “why is the website so slow” wrong.
We are going to roll through a clean install and look at some things that can be made right during the install. And then we will look at some configurations that can only be done after the install.
Things like:
· Instant File Initialization
· Backup Compression
· MAXDOP
· TempDB configuration
· Cost Threshold for Parallelism
· And more if we have time!
Fair warning…I’m going to overuse the phrase “It Depends”
Dallas DBAs is dedicated to helping you find these issues, test them, remediate them and get the most stability, reliability and performance out of your SQL Server.
SessionID: 95126
Event Date: 13-07-2019 - Session time: 13:30:00 - Track: Career
Speaker: Peter Doyle
Abstract:
Do you have a solid social media marketing plan for 2019-2020? Are you sitting on the sidelines paralyzed at the thought of creating engaging content every day for Podcasts, Blog Posts, Twitter, Instagram, Instagram Stories, Instagram TV, Facebook, Linkedin, Twitch, YouTube and SnapChat?
In this session, you will learn the 7.5 steps to create a never-ending fountain of meaningful and engaging content across all social media channels. You will gain actionable insight on how to connect with your community as we analyze how RedBull, Buffer, Virgin and Charity Water connect with their communities.
At the end of the session, you will be equipped with the tools, resources, and energy-efficient shortcuts to create a custom and scalable marketing strategy.
SessionID: 95520
Scales, Measurements and Encoding Schemes
Event Date: 13-07-2019 - Session time: 13:30:00 - Track: DBA
Speaker: Joe Celko
Title: Scales, Measurements and Encoding Schemes
Abstract:
SessionID: 92059
Introduction to Linux for SQL Server Professionals
Event Date: 13-07-2019 - Session time: 14:40:00 - Track: DBA
Speaker: Jay Falck
Title: Introduction to Linux for SQL Server Professionals
Abstract:
SQL Server is now available on Linux but you only know Windows, now what? During this session we'll introduce the Linux version of Windows commands you use on a daily basis for administering SQL Server. We'll look at updating Linux, updating SQL Server, moving files between Windows and Linux, and backing up and restoring databases from one system to another. We'll also look at default file locations for SQL Server and what can be moved and how to accomplish that.
SessionID: 92116
Successfully Migrating Existing Databases to Azure SQL Database
Event Date: 13-07-2019 - Session time: 14:40:00 - Track: Azure
Speaker: John Sterrett
Title: Successfully Migrating Existing Databases to Azure SQL Database
Abstract:
SessionID: 92651
The SQL Career Roadmap for Women (and Men)
Event Date: 13-07-2019 - Session time: 14:40:00 - Track: Career
Speaker: Jennifer McCown
Title: The SQL Career Roadmap for Women (and Men)
Abstract:
The ideal way to become a SQL Server professional is to get a degree, get a junior position, and then work your way up. But, the vast majority of data professionals don’t follow this path! Instead, most of us start out as “accidental DBAs” and fumble our way into a full time data career.
This is not ideal, and we could all use some help navigating through resumes, job hunting, interviews, and negotiating.
You’ll learn about all that in this session. We will also talk about how to get around a big obstacle for both women and men: how to get back to work after a long period of not working.
How can I get a database job with no experience? What’s the best way to learn the newest technology? What resources are out there? Bring your questions, and we’ll explore the answers.
SessionID: 93270
Event Date: 13-07-2019 - Session time: 14:40:00 - Track: BI
Speaker: Jamey Johnston
Abstract:
Come to this session to get an introduction to the R language including:
- installing and Configuring R and RStudio
- RStudio Overview and Debugging
- how to Access and Manipulate Data
- install and Manage Packages
- create and Use Variables
- control Flows
- functions
- basic Graphing and Statistical Analysis.
We will finish with a brief introductions of how R integrates in Azure ML, Power BI, and SQL Server 2016 using real demos.
The focus of the session will be primarily on the introduction to the R language and getting attendees comfortable with using R to start the journey into Data Science!
SessionID: 93619
The True Story of Learning Biml
Event Date: 13-07-2019 - Session time: 14:40:00 - Track: BI
Speaker: Melissa Stein
Title: The True Story of Learning Biml
Abstract:
How do you learn Biml when you don't have years of SQL experience? Is Biml even worth my time and energy when I'm still working on perfecting my SSIS skills? It seems like a lot of work, what is in it for me?
In this session you will learn:
Why Biml is worth your time and effort.
How to identify ideal SSIS packages for conversion.
How to convert those packages into Biml.
How to troubleshoot your Biml build errors when Google fails you.
How to automate SSIS package creation with BimlScript.
SessionID: 94105
How do you Azure?
Event Date: 13-07-2019 - Session time: 14:40:00 - Track: Azure
Speaker: Tamera Clark
Title: How do you Azure?
Abstract:
Most are talking about it, some have migrated to it and others are just overwhelmed. If you thought Azure was the color of the sky and you are wanting to learn about MS Azure then this is the session for you.
Join me for a fun journey to learn the very basics of Azure. Some how-tos, some whys, and some demos.
This is a level 0 session, #N00b, #Imabeginner
SessionID: 94136
Event Date: 13-07-2019 - Session time: 14:40:00 - Track: Performance Tuning
Speaker: Daniel Janik
Abstract:
SessionID: 94456
Event Date: 13-07-2019 - Session time: 14:40:00 - Track: SQL Dev
Speaker: Martin Perez
Abstract:
One of most common problems a data professional may face is finding and syncing data changes efficiently between multiple systems.
In this session we will look into different methods focusing on effective use of T-SQL and explore how these methods can mixed and matched in your workflows.
Target Audience:
Any DBA or developer that has ever faced the problem of moving data changes across databases.
SessionID: 95900
From Zero to Hero: intro to Azure Machine Learning
Event Date: 13-07-2019 - Session time: 14:40:00 - Track: Azure
Speaker: Mohamed Mawla
Title: From Zero to Hero: intro to Azure Machine Learning
Abstract:
The session aim is to get people excited and curious more about ML without digging in coding or deep concepts.
We will explore ML Azure offering, Some ML concepts, ML Studio, create an experiment from Scratch and show how ML can target common business challenges like demand projection or price targeting
Lots of hands-on
SessionID: 92064
A Rocket Scientist Perspective on Index Column Selection
Event Date: 13-07-2019 - Session time: 15:50:00 - Track: Performance Tuning
Speaker: Mike Byrd
Title: A Rocket Scientist Perspective on Index Column Selection
Abstract:
SessionID: 92123
SQL in Azure 101
Event Date: 13-07-2019 - Session time: 15:50:00 - Track: Azure
Speaker: Mark Moore
Title: SQL in Azure 101
Abstract:
Want to run SQL in Azure. This session will cover all of your options from running SQL in a Windows or Linux VM to Azure SQL PaaS offerings.
This is an introductory session. At the end of this session you will have a good understanding of what SQL options are available in Azure and how to create and manage each one.
SessionID: 92608
Event Date: 13-07-2019 - Session time: 15:50:00 - Track: SQL Dev
Speaker: Steven Tidwell
Abstract:
SessionID: 92867
Managing Excel Power Query With VBA
Event Date: 13-07-2019 - Session time: 15:50:00 - Track: BI
Speaker: Bob Phillips
Title: Managing Excel Power Query With VBA
Abstract:
In this demo-rich session, we will show how VBA can be utilised to create and manage Power Query queries within Excel, using Excel functionality and external files, all without using Power Query directly. The Power Query UI is used to validate that queries and functions are bona-fide.
We start by building a query from within Excel VBA to demonstrate the capability and functionality available to the developer. Then we will show how to manage a library of Power Query functions using this VBA technique, demonstrating the usage of one of these functions. Time permitting, we will go on to show how we can extend this technique, taking a multi-company dataset and splitting it into multiple queries, building a template query that can be used to create the multiple queries. All of this will be done without using the Power Query UI, nor even opening Power Query.
It is assumed that delegates will be familiar with VBA and Power Query, using the Power Query UI, basic M, and Power Query functions.
SessionID: 93616
Agile Data Warehouse and ETL Design with Biml
Event Date: 13-07-2019 - Session time: 15:50:00 - Track: BI
Speaker: David Stein
Title: Agile Data Warehouse and ETL Design with Biml
Abstract:
SessionID: 93880
Building your Microsoft Business Intelligence (MSBI) Career
Event Date: 13-07-2019 - Session time: 15:50:00 - Track: Career
Speaker: Ganesh Lohani
Title: Building your Microsoft Business Intelligence (MSBI) Career
Abstract:
SessionID: 95705
Multidimensional Data Cubes and Data Mining in the Real World
Event Date: 13-07-2019 - Session time: 15:50:00 - Track: BI
Speaker: Robert Stewart
Title: Multidimensional Data Cubes and Data Mining in the Real World
Abstract:
SessionID: 95733
Using Oracle GoldenGate to Replicate SQL Server Data
Event Date: 13-07-2019 - Session time: 15:50:00 - Track: DBA
Speaker: Edward Whalen
Title: Using Oracle GoldenGate to Replicate SQL Server Data
Abstract:
Some people think of Oracle and SQL Server as mutually exclusive. In my experience many SQL Server customers use Oracle products to enhance their SQL Server databases because of replication challenges as well as enhanced security. Some of Oracle’s products, such as Oracle GoldenGate, Oracle GoldenGate Veridata, Database Firewall and Audit Vault can greatly enhance Microsoft SQL Server.
This presentation covers the basics of what Oracle GoldenGate is, how it works with Microsoft SQL
Server and a few case studies on how it has enhanced some large SQL Server installations. GoldenGate is a heterogeneous replication project. It can be used to migrate data between various databases as well as different versions of the same database product. It can be used for database upgrades and migrations, loading data warehouses and data lakes and a number of other purposes.
This presentation will introduce you to Oracle GoldenGate, its uses and how to use it.