Build Schedule

Advanced Filters:
  • Track

    clear all





  • Speaker


  • Level


  • Session Type


Sessions Found: 25
Face it, using SSIS to work with fixed width flat files is a pain.  The SSIS interface has you clicking around to mark each column. Then you use another interface to set each columns data types, etc.  And when you are done, you still need to document the file structure for your users.  What if you could simply document the file structure and then generate the ETL from the document?
To demonstrate such an approach, I build an Excel file describing US census data that has more than 300 columns of fixed width data.  After demonstrating how this file communicates to business users, I will generate an SSIS package from that metadata using BIML Script.  Then I will also look at how you can generate a SQL Server bulk insert format file from the same metadata.  A small amount of C# code can generate quite a large extract.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Intermedia

Session Code:

Date: March 14

Time: 1:30 PM - 2:30 PM

Room: 211

Big announcement from Microsoft at Ignite and PASS, but what is it?  Is it just Azure SQL DW rebranded?   No, not really...it's way more than that.  In this session we will talk about what this is and what it means for everyone out there.   I'll give you a clue, no more storage keys, and key vaults to do what you need to do to go from Data Lake to Power BI and everything in between.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud

Level: Beginner

Session Code:

Date: March 14

Time: 1:30 PM - 2:30 PM

Room: 219

So when you started your career, you troubleshoot using profiler, got very comfortable with the interface and troubleshooting with it. Then in 2008, the SQL Server team came out with Extended Events. You tried it and said big TSQL scripts and XML shredding to get what I can get with profiler and a few button clicks and you really have never looked back. But really you still wonder if maybe just maybe I should be comfortable with this tool. 
During this basic session we will explore the features that differentiate XE from trace, with a focus on new features that have been recently released. 
After this session you’ll be comfortable creating your own XE sessions and will know when you use XE when to use profiler or when it doesn’t matter.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Admin

Level: Beginner

Session Code:

Date: March 14

Time: 1:30 PM - 2:30 PM

Room: 201

In this session we will create an Power App that will allow users to check-in their location. We will then create a Flow that will take that location and write to a Power BI data source and refresh it. We will then create a Power BI report that will display the data on a map.

Power Apps is a great tool that allows you to create a desktop or mobile app with minimal coding. The app we are creating in this session uses the Bing location services to get the users location when a button is pressed. The Microsoft Flow we create in this session will take the location and user information and write it to an Excel file. We will also look at a custom connector in Flow that will allow us to refresh a Power BI data set. In the Power BI report we will create we will connect to an Excel file with the location information in it and display it in a report including the location on a map.

The audience will take away useful information about Power Apps, Flow and Power BI including all the code used.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Beginner

Session Code:

Date: March 14

Time: 2:45 PM - 3:45 PM

Room: 216 (Auditorium)

You're a lone DBA and you've heard all the buzzwords about Linux and Azure and containers, and it's all a bit overwhelming. Are you really missing out?

Join me on an exploration of what it means to be a DBA in the modern era, and how your existing skills can be leveraged, no matter the platform. Maintenance plans, monitoring, even disaster recovery all work in pretty much the same way across Windows, Linux, Azure SQL DB, and containers.

Then when you go back to work on Monday, you will have a starting point on how to modernize your existing environment and future-proof your career.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Admin

Level: Intermedia

Session Code:

Date: March 14

Time: 2:45 PM - 3:45 PM

Room: 201

Many organization spend months and potentially years designing and implementing their data warehouse and by time of delivery the business requirements have evolved. Moreover such system is very complex and making any changes requires large amount of regression testing which slows down making improvement to system. Many of these problems plagued traditional application development and have for the large part been addressed by adoption of agile methodology and DevOps practices. In this session we'll draw parallel between the challenges of both domain and what the solution may look like.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Dev

Level: Intermedia

Session Code:

Date: March 14

Time: 11:20 AM - 12:20 PM

Room: 227

Do you want to turn your SQL knowledge into a possible career? 
This session will show you what options are available to learn about MS SQL Server and make you more knowledgeable about the product by providing links to people and organizations who offer training and advice 
He has now performed this at 4 SQL Saturday's and gotten great feedback from attendees. The slide deck will contain all the links that are shown during the presentation.
This session will show the many different options available to learn MS SQL Server ranging from free events thru to international conferences
It will also show how to make any conference more affordable and justify the benefits
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: March 14

Time: 10:05 AM - 11:05 AM

Room: 201

Traditional DW solutions pre-date the cloud. They were designed to run on small, static clusters of well-behaved machines, making them a poor architectural fit. ?loud drives innovation. 

Organizations are moving away from on-premise analytics towards shared data centers and software-as-a-service solutions hosted by platform providers such as Microsoft Azure.

The shared infrastructure of the cloud promises increased economies of scale, extreme scalability and availability, and a pay-as-you-go cost model that adapts to unpredictable usage demands. 

Unfortunately, these advantages can only be captured if the software itself is able to scale elastically over the pool of commodity resources that is the cloud. 

This talk will cover the journey towards Modern Cloud Analytics Solutions with Microsoft Azure. 

This talk will help you understand the potential of Azure Cloud Analytics and learn about our use case and save time for future projects.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Beginner

Session Code:

Date: March 14

Time: 11:20 AM - 12:20 PM

Room: 219

It's 2020 - a new decade! How will technology evolve in the 2020s? Join Richard Campbell as he explores different aspects of hardware, software and networking that will have a huge impact over the next ten years. What will take over for the smartphone? Will Artificial Intelligence take over everything? What will PCs even look like over the next ten years? And what about Quantum Computing? All these topics and more will shape our future!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Admin

Level: Beginner

Session Code: Remote

Date: March 14

Time: 8:45 AM - 9:45 AM

Room: 216 (Auditorium)

One of the things we love about Power Query is that you can do amazing things with just a few button clicks. But did you know that behind the scenes, Power Query performs Magic via a coding language called M? In the perfect world, you’d never need to look at this code at all but – as with all coding languages – you can do much more if you’re willing to get your hands dirty.

In this session Ken will provide some simple M tricks to do amazing things. Building a calendar table in seconds, numbering grouped rows, and speeding up a table with a little buffer action.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Intermedia

Session Code:

Date: March 14

Time: 1:30 PM - 2:30 PM

Room: 216 (Auditorium)

Looking to migrate to Azure with minimal to no downtime or just keep a steady stream of data from a source moving to the cloud? Migrating data is no longer a one size fits all scenario. With DEA, DMA, DMS and SSMA all available to you, which one best fits your needs?  This session explores the multiple services and options of migrating data to Azure.  We will delve into each option and compare their features.  We will explore the options for initial load as well as on going loading of data.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud

Level: Beginner

Session Code:

Date: March 14

Time: 10:05 AM - 11:05 AM

Room: 211

Power BI has grown and morphed over the past half decade with its modest start as a Desktop app, Mobile App and PaaS offering.  We will talk about the bits and pieces you might be interested in to support your Power BI solutions.  Sure, we will cover the Desktop App, Mobile App and PaaS, but we will also talk about the Premium service offerings, the On-premises Data Gateway and Power BI Report Server.  Hopefully this tour of the landscape will help you in taking your first steps to discovering how Power BI can help uncover insights in your data.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Beginner

Session Code:

Date: March 14

Time: 10:05 AM - 11:05 AM

Room: 216 (Auditorium)

Data analytics, machine learning and statistical testing are all powerful tools for data science. These techniques all have one thing in common: the quality of the output is largely dependent on the quality of the data input! This session will walk through three scenarios of transforming and manipulating messy data to prepare for analytics. The data from each scenario will be shaped and cleaned with both Power Query in Power BI and tidyverse packages in R Studio. The techniques demonstrated in these examples can be transferred to prepare messy data from numerous other business scenarios!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Intermedia

Session Code:

Date: March 14

Time: 11:20 AM - 12:20 PM

Room: 216 (Auditorium)

SQL Server Agent is a powerful tool to configure scheduled tasks for your SQL Server. However, once this job is about to cross the boundary of the server itself - be it data collection, maintenance or administrative tasks or anything at all - Agent tasks become cumbersome, with complicated syntax and, usually, a mix of T-SQL, Powershell and xp_cmdshell.
This session will talk about an alternative to SQL Server Agent that allows us to orchestrate SQL Server environment in a more centralized manner and opens doors for advanced automation tasks, storing code in repositories and many more! Jenkins, one of the most popular DevOps tools, has a very forgiving learning curve and enables us to use thousands of community-inspired modules from one single point of entry. From Agent Jobs to Jenkins, or how to run your SQL code outside of the box.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Admin

Level: Beginner

Session Code:

Date: March 14

Time: 11:20 AM - 12:20 PM

Room: 201

In this session we will discuss how you can get your data quality problems under control on the Microsoft Data Platform. We'll show you how to quickly and easily integrate a duplicate search into your applications, how to migrate Microsoft SQL Server Data Quality Services to Azure, how to clean data with the SSIS-IR and how to improve your self-service processes in Power BI. All this with HEDDA.IO directly on Azure.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Sponsor Session (45 minutes)

Track:
Admin

Level: Beginner

Session Code: Remote

Date: March 14

Time: 12:35 PM - 1:20 PM

Room: 201

Have you heard the recent industry noise about how people are applying DevOps principles to databases and wondered if it is just hype?

In this session, MVP Hamish Watson demonstrates how the noise is based on facts, and how using Redgate tools will make a huge (positive) difference to how you deploy changes to your SQL Server estate. The session is based on Hamish's experiences "in the wild" and lists all the benefits and pitfalls associated with applying DevOps principles to your database systems.

The session contains a demonstration, that is based on a real-world system. And after watching this session you will come away with practical methods of how to start your journey to DevOps brilliance.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Sponsor Session (45 minutes)

Track:
Admin

Level: Beginner

Session Code:

Date: March 14

Time: 12:35 PM - 1:20 PM

Room: 227

Data is the new oil ! 
But just sitting on a patch of oil does not make one rich.  The oil needs to be drilled, extracted, refined and ultimately sold.
Same with data. Getting the right data in the hands of the right people in a timely manner seems to be more of a challenge than most organizations realize, and the reason for that is the limitations imposed by legacy on-premises and cloud v1.0 data warehouses.
Snowflake is a Modern Cloud Data Platform, rooted in the cloud, freeing you from those shackles and allowing you to use your data more efficiently, rather than spending all your time managing the underlying infrastructure and costs.
Come listen how Snowflake has enabled thousands of customers to make better, faster decisions, save money and discover new ways to use data! 
As a bonus, come learn how Snowflake enables customers to share relevant data in a modern, low-calorie way!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Sponsor Session (45 minutes)

Track:
Cloud

Level: Beginner

Session Code:

Date: March 14

Time: 12:35 PM - 1:20 PM

Room: 216 (Auditorium)

For most DBAs virtualization is no longer a matter of "If" but "When". This means it is critical for DBAs to understand how this technology works and how we can ensure we get the most performance and scalability out of it. In this session we will look at some of the best practices and gotchas when Designing Standalone and Highly Available SQL deployments in a vSphere environment. We'll also cover how to troubleshoot performance issues when they arise.
Speaker:

Session Type:
Sponsor Session (45 minutes)

Track:
Admin

Level: Beginner

Session Code: Remote

Date: March 14

Time: 12:35 PM - 1:20 PM

Room: 219

This is a workshop for beginners in the field of Business Intelligence and Data Analytics.
Data scientists should use the strategic management process to achieve strategic competitiveness and help the company achieve above-average returns. Strategic competitiveness on BI and Data Analytics is achieved when data scientists teams develop and implement a value-creating strategy at work. 
Those making strategic decisions must adopt a different mind-set, one that allows them to learn how to complete in highly turbulent and chaotic environments that produce a great deal of uncertainty. 
The effectiveness of the strategic management process at every level is increased when it is grounded in ethical intentions and behaviors.
Managing core competence (capability that is valuable, rare and costly to imitate) requires careful analysis of the company's resources and capabilities in their data scientist team. The knowledge of the company's human capital possesses is among the most significant o
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Beginner

Session Code:

Date: March 14

Time: 2:45 PM - 3:45 PM

Room: 227

Test Driven Development (TDD)  is a design approach which has enabled application developers to write cleaner code. It is relevant for database development as it ensures that code produced using TDD and unit tests will be of higher quality which means interactions with data will be safer. 

TDD is not a new method of unit testing, it is an essential design practice for improving the quality of your deployed code.

In this session it will be shown how we can use TDD to design and write better unit tests using open-source frameworks and industry standard tools. These tools can be run within SQL Server Management Studio which means DBAs can also take advantage of TDD and unit test, to ensure more reliable code is deployed to databases. 
TDD can result in code that can be deployed more reliably and faster when using DevOps processes such as Continuous Integration and Continuous Delivery. 

A comprehensive DEMO will reveal how Test Driven Development can help you deploy database code
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Dev

Level: Beginner

Session Code:

Date: March 14

Time: 1:30 PM - 2:30 PM

Room: 227

Sessions Found: 25
Back to Top cage-aids
cage-aids
cage-aids
cage-aids