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:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: March 21

Time: 3:20 PM - 4:20 PM

Room: CEB104

Going to the Cloud can be a very scary proposition for most companies, but a lot of your fears can be mitigated as long as you prepare for the experience.  Come learn with me and learn from my experiences as we cover the preparatory steps that can be taken to improve the initial experience.  After that, we will be listing out the general tasks that need to be setup in order to maintain an expected level of performance.  Next, we will be working on how to improve performance on an existing hybrid VM running SQL Server.  Finally, we will discuss some of settings and roles that you will want to have in the Azure Portal to allow you to monitor your well-performing Azure instance.  Bring your questions!  

Note, this session will exclusively deal with issues on a hybrid VM running SQL Server in Azure.  We may cover general issues that affect SQL Azure instances such as storage issues.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: March 21

Time: 8:30 AM - 9:30 AM

Room: CEB105

If you’ve never looked at CosmosDB before then you may be in the group of SQL professionals who assume this is just another relational database technology.
This viewpoint could in fact lead you into a world of pain, and you may wish to attend this Lightning Talk and get to know the facts around this NoSQL (or NOSQL) technology.
You might have questions around phases like NoSQL, NOSQL and schema-less that are putting you off looking at this globally distributed, multi-model cloud-based database.
Come along to this fast-paced Lightning talk and get the facts on the Cosmos.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code: Remote

Date: March 21

Time: 10:50 AM - 11:50 AM

Room: CEB105

As more and more Artificial Intelligence (AI) and Machine Learning (ML) impacts our lives, voices are raising valid questions about Ethics, Morality,  and AI/ML technologies. AI and ML are initially created by humans, and reflect the predilections, biases, preferences, and goals of the creators, and of the organizations that employ them. Often critical algorithms are deeply obfuscated, sometimes under the guise of ‘Trade Secrets’. 

What are the decision points that guide data acquisition and impact outcomes? How do we, as a society, ensure that software, and products controlled by software, have our, and societies’ best interests at a high enough level of concern? How do we, as creators, designers, abettors, and enablers of AI/ML ensure that our self-interests are aligned with the interests of society? How do we prevent ourselves from being unwitting dupes in unleashing products with intended or accidental nefarious impacts? 

You should expect to leave with many questions to ponder.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Beginner

Session Code: Remote

Date: March 21

Time: 9:40 AM - 10:40 AM

Room: CEB106

We will discuss ETL software, have an intro to SSIS basics, create a basic package, and implement third-party tools like MelissaData and CozyRoc
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: March 21

Time: 3:20 PM - 4:20 PM

Room: CEB205

SQL (the language) is not a third generation language, where the developer tells the computer every step it needs to take. It is a declarative language that specifies the required results. SQL Server itself will figure out what steps it takes to get to those results. Most of the time, that works very well.

But sometimes it doesn't. Sometimes a query takes too much time. You need to find out why, so you can fix it. That's where the execution plan comes in. In the execution plan, SQL Server exposes exactly which steps it took for your query, so you can see why it's slow.

However, execution plans can be daunting to the uninitiated. Especially for complex queries. Where do you even start?

In this session you will learn how to obtain execution plans. and how to start reading and understanding them.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code: Remote

Date: March 21

Time: 8:30 AM - 9:30 AM

Room: CEB205

Git isn't just for application developers and their code anymore. Database development can (and should) be included in change management and we're seeing the need for more folks to learn how to interact with Version Control Software:  Do you manage a collection of SQL or PowerShell scripts, runbooks or repository of text files for your organization? Version control is coming for you too. In this primarily demonstration session we'll cover the basic Git commands and how VSCode and Azure Data Studio make it easier to work with Git in the long run.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: March 21

Time: 8:30 AM - 9:30 AM

Room: CEB106

When Microsoft released SQL Server 2017, it allowed us to run SQL Server in docker containers. This radical change provides a wider and open platform that data professionals can choose how to deploy and run SQL Server. 

This session will demonstrate how containers are a game changer for deploying and managing SQL Server. It  will also showcase how the Azure Kubernetes Service (AKS) is a scalable and highly available platform for SQL Server running in containers. 

Demonstrations will show how easy it is to create containers, deploy SQL Server in them, and how to automate and manage your SQL Server containers using Kubernetes on the Azure platform.

This session will show you the exciting future of SQL Server and you will walk away with knowledge of practical scenarios where SQL Server running in containers on Kubernetes may be the right deployment model for you.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code: Remote

Date: March 21

Time: 1:00 PM - 2:00 PM

Room: CEB105

TBA
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: March 21

Time: 1:00 PM - 2:00 PM

Room: CEB106

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: March 21

Time: 9:40 AM - 10:40 AM

Room: CEB105

At the heart of every Power BI report lies a data model. Poor data models limit insights, require complicated DAX and perform poorly, whereas great data models support an abundance of insights that deliver value faster.  
During this session, we discuss the elements of a great data model and how to build one, this session will include lots of tips,  tricks and best practices that you can use to improve you Power BI models.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code: Remote

Date: March 21

Time: 9:40 AM - 10:40 AM

Room: CEB104

Power BI has lots of different connectors and ways of working with data that frequently get overlooked by people just using it to load Excel, CSV and SQL Server Data. May people don't know that Power BI has a built in Website scraper, PDF scraper as well as a features like grabbing all files out of a folder. Using some of these unconventional connections, we can build really cool analytics tools that reach nearly any corner of our data warehouse.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: March 21

Time: 10:50 AM - 11:50 AM

Room: CEB205

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:
Advanced Analysis Techniques

Level: Intermedia

Session Code:

Date: March 21

Time: 2:10 PM - 3:10 PM

Room: CEB104

The world you know is about to change in profound and radical ways. A historic confluence of emerging technologies, powered by ubiquitous connectivity and advances like artificial intelligence (AI), are poised to complement and catalyze each other to change the way we work, play, relate and live.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: March 21

Time: 3:20 PM - 4:20 PM

Room: CEB105

If you've dipped your toe into the waters of Azure SQL DB, you'll know that there's no SQL Agent available. Fortunately there are many options available to get you over this hurdle. One of these is Azure Automation, a scheduling engine which runs PowerShell or Python scripts to perform your tasks. As a bonus, these Runbooks can also be triggered from Azure SQL DB alerts. This session will introduce Azure Automation, from a basic, manually executed Runbook to an alert-driven responsive utility that can save you considerable effort. We'll then take Alert responses a step further and use them to trigger an Azure Logic App workflow - a utility that provides a robust workspace with built-in scalability & retry logic along with a multitude of connectors which can expand the response to your alert. Imagine being able to capture an Alert, perform the remedial action, log the issue & response in your ticketing system and switch on your kettle so you can sit back and let Azure do it all for you.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Advanced

Session Code:

Date: March 21

Time: 2:10 PM - 3:10 PM

Room: CEB105

If you like being the surly IT geek who lives in a dark office and gets fed pizza under the door (i.e. a flat boxer) this session is NOT for you.  However, if promotion, appreciation for what you do, and the adoration of your peers and management are appealing to you, you might want to participate in this one.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: March 21

Time: 10:50 AM - 11:50 AM

Room: CEB106

SQL Server 2019 is more than the database engine, it is a data solution platform. This release introduces multiple new features that will give you new ways to implement better and faster multi platform data solutions. Armando will demo many of these features on processing high data volume from multiple data sources and data formats without leaving SSMS.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code: Remote

Date: March 21

Time: 1:00 PM - 2:00 PM

Room: CEB205

Over the years, virtualization has matured from the exotic black magic realm to become a mainstream standard IT practice. "Virtualize First" is now a well-accepted default practice in most enterprises and any deviation is now considered an anomaly. In spite of this trend, many IT administrators and architects still have some reservations about virtualizing SQL Server workloads. They consider SQL too "critical" to be virtualized; they wonder and worry about scale about performance; they are looking for guidance and reassurance. If this is where you (or your clients) are today, be sure to attend this session. You will gain valuable insights from what others have done to successfully undertake similar tasks in their environments. We will talk about configuration pitfalls to avoid and also review the configuration and current performance data for some of the most demanding applications in customers environments.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code: Remote

Date: March 21

Time: 12:00 PM - 1:00 PM

Room: CEB105

As a developer, analyst, or beginner, it's relatively easy to learn how to query a database for information.  T-SQL is a declarative language, meaning we simply tell the engine what to get, not how to get it. Some queries are fast, others are slow. We've all heard that an index will make the query faster, and often the solution to performance problems are indeed indexes. Why is that? What are they? How do you use them? With a good understanding of what indexes are and how the engine uses them, and by writing our queries with indexes in mind, we can make queries perform much faster.   

In this beginner session we'll learn index basics and how to write queries that can take advantage of them for more efficient, better-performing queries.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: March 21

Time: 9:40 AM - 10:40 AM

Room: CEB205

SQL Server offers several isolation levels beyond the default "READ COMMITTED".  But understanding when to use each one can be daunting.  Whether you are a developer who needs to understand how isolation works and  and why NOLOCK is not an appropriate hint in most cases, or a seasoned DBA who needs to understand the less commonly used isolation methods, this session is for you.  We will look at each level, how it impacts the engine, and examine appropriate (and inapproriate) use cases for each.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: March 21

Time: 3:20 PM - 4:20 PM

Room: CEB106

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