Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type


Sessions Found: 34
This session will show a lot of things in the world of data that went very, very wrong... 
And yes you are welcome to have a laugh at the misfortune of other people (or as the german speaking population would call it: Let's have some "Schadenfreude"!
After a log day, come in and have some fun before the evening event starts
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: December 14

Time: 8:20 AM - 9:35 AM

Room: Connecticut 7050

Data compliance in the modern technology landscape feels like a constantly moving target as more and different laws, rules and regulations are passed locally, nationally and internationally. The days when only some organizations or certain countries had to worry about data compliance are gone. It’s everyone’s problem.

However, it is possible to define a core set of processes that will help to enable your ability to assist your business, or government agency, in meeting these compliance requirements. This session will walk you through the 10 steps you need to implement in order to move your organization towards full compliance with any, or all, of the regulations we all now face. From identifying where your data lives to monitoring for compliance and all the steps in between, you can meet this challenge.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Strategy and Architecture

Level: Intermedia

Session Code:

Date: December 14

Time: 1:40 PM - 2:55 PM

Room: Connecticut 7050

Are you a relative newcomer to SQL Server and want to get into performance tuning? Or maybe you just want to expand your knowledge of hidden performance killers?

Then join me for a survey of seven worst practices that kill performance in SQL Server. In this demo-filled session, we will cover a mix of administrative and T-SQL development practices, making this session suitable for DBAs and developers alike! Topics include server configuration mistakes, T-SQL parallelism, and TempDB headaches.

When you leave, you'll be armed with knowledge and tools to tackle your current workloads and hit the ground running.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: December 14

Time: 11:10 AM - 12:25 PM

Room: Georgia 7054

This immersive full day hands on session will arm you with all the skills you need to build and orchestrate pipelines using Azure Data Factory v2 that solve both traditional data integration problems and also adapt to newer challenges such as real-time and complex event processing.
We will start with a conceptual overview, and then explore using metadata to build scalable serverless pipelines to move data from disparate data sources including On-Premises and Platform As A Service. We will look at how to leverage SSIS Lift and shift to maximize reuse for your existing code base and review the pros and cons of this approach. We will dive deep and cover the design patterns and architectures for modern data warehouses and big data pipelines. We will also review best practices for operationalizing solutions including configuring monitoring, logging and alerting and implementing DevOps and CI/CD. This day is everything you need to do amazing things with Azure Data Factory.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: December 13

Time: 8:00 AM - 9:15 AM

Room: Delaware 7052

In this session you will learn the Managed instance deployment, best practices, challenges and monitoring capabilities with real-time scenarios and demos.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: December 14

Time: 8:20 AM - 9:35 AM

Room: Georgia 7054

Are you a DBA or data professional working with out-dated technology or feel your skills are quickly becoming irrelevant? Stay ahead in today's ever changing tech space and take your career to the next level.

Join Mohammad Darab this session to explore the cutting-edge technology that SQL Server 2019 has to offer: Big Data Clusters.

Topics include:
-Big Data Cluster architecture and its components such as: Containers, Kubernetes and the newly enhanced Polybase
-Unique advantage of SQL Server Big Data Clusters
-Data Virtualization, Scale-out Data Marts, and Data Hub concepts
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: December 14

Time: 9:45 AM - 11:00 AM

Room: North Carolina 7022

Are you excited to know about the MSBI tools and work as a Business Intelligence Professional, a dynamic and rewarding career in Information Technology? If yes, this is the right time and place for you. In this session, I will give you the overview of the MSBI tools (SSIS, SSRS, SSAS, Power BI, Azure Analytics). I will also provide you some insights to build the MSBI career and to leverage the learning curve in Microsoft Data Platform, based on my knowledge and experience,  the proven strategies and techniques.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: December 14

Time: 1:40 PM - 2:55 PM

Room: Pennsylvania 7024

In this case study, I detail how I went about designing and implementing a Speaker Database for the Project Management Institute using SharePoint, Flow, Power Apps, and Microsoft Forms. We will do a brief intro of what each technology is and it's pros and cons, and then dive into what I learned about each, each strengths and weaknesses, and how I was able to build a functional Speaker Database.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: December 14

Time: 1:40 PM - 2:55 PM

Room: North Carolina 7022

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 100 times now and it is always very highly rated!
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: December 14

Time: 9:45 AM - 11:00 AM

Room: Georgia 7054

This session is an introduction to the unique functionality offered by COZYROC to create integration packages that dynamically map columns at runtime. The standard SSIS Data Flow Task can only use static metadata which is defined when the package is initially designed. The mapping of columns is configured and remains unchanged until the package is re-opened and design changes are made, thus costing maintenance time and effort. Data Flow Task Plus extends the capabilities of the standard Microsoft Data Flow task in that it allows you to set up dynamic data flows, thus eliminating maintenance time and effort. Changes to tables and columns are automatically incorporated at run time without the need to change and redeploy the package. Columns and fields are mapped automatically at run time. Furthermore, the initial design time and effort may be greatly reduced when dealing with huge amounts of data in a large number of files and/or databases.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: December 14

Time: 12:45 PM - 2:00 PM

Room: Connecticut 7050

PolyBase is Microsoft's data virtualization technology, allowing you to integrate SQL Server with external systems such as Hadoop and Azure Blob Storage.  As of SQL Server 2019, PolyBase also allows you to connect to diverse systems such as Oracle, MongoDB, Cosmos DB, Teradata, Apache Spark, and even other SQL Server instances.  In this talk, we will walk through the mechanics of PolyBase, showing how we can write T-SQL queries to access data from heterogeneous sources.  We will investigate the Dynamic Management Views (DMVs) and other resources needed to tease out what the PolyBase engine is doing behind the scenes and where to go when things break down.  Finally, we will look at several interesting use cases for PolyBase in the modern data environment.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: December 14

Time: 8:20 AM - 9:35 AM

Room: North Carolina 7022

Containerization with Docker is a hot topic these days, and SQL Server’s ability to run in-side Docker containers on both Windows and Mac has revolutionized the way develop-ers work with Microsoft’s venerable database engine. This dynamic session starts with a quick introduction to Docker and how it utilizes OS virtualization in Windows 10 and Windows Server 2019 to provide isolation across multiple containers running on your machine. Then you’ll see how fast and easy it is to spin up any number of SQL Server in-stances to run in both Windows and Linux containers simultaneously. Get bit by the Docker bug, and you’ll never go through the pain of installing SQL Server on your devel-opment machine ever again!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: December 14

Time: 9:45 AM - 11:00 AM

Room: Delaware 7052

Curious how to monitor your IT Services using Power BI? Come see how UCF tracks our IT services to ensure our staff, students, and faculty are meeting their teaching, learning, research, and service objectives. Utilizing ITIL (Information Technology Infrastructure Library) practices, ServiceNow data, and Power BI we are able to take quantitative information and turn it into graphical visualizations to aid leadership and our customers in making informed decisions.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code:

Date: December 14

Time: 11:10 AM - 12:25 PM

Room: Pennsylvania 7024

Azure applications (PowerBI, Power Apps, AI & Machine Learning, etc) can greatly enhance business processes. Most organizations, however, have already invested in on-premises infrastructure for storing their data (database & file servers). The problem therefore is: How can you use on-prem data sources with cloud-based (Azure) applications?

In this session, we will look at using an Azure On-Premises Data Gateway to integrate local (on-prem) data sources with Azure-based applications.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: December 14

Time: 1:40 PM - 2:55 PM

Room: Pennsylvania 7024

In this session, we will look at the new Query Store feature in SQL Server 2016, 2017, and 2019.  Query Store tracks changes in execution plans, allowing you to easily view performance differences and revert to older plans with a few clicks of the mouse in 2016.

Then in 2017, Microsoft added wait stats per query plan and Automatic Plan Correction capabilities.  Allowing DBAs more tools to troubleshoot fires with and a way to automatically resolve issues.

In this session, we will walk through the features of Query Store, so you can understand how to use them in SQL Server 2016, 2017, and 2019.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: December 14

Time: 3:05 PM - 4:20 PM

Room: Georgia 7054

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.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: December 14

Time: 3:05 PM - 4:20 PM

Room: Delaware 7052

When it comes to getting your data into Excel or Power BI, M is your best choice. The M Language (A.K.A Power Query) is a powerful tool for self-service data preparation. However, it's not clear where it fits compared to tools like SSIS or TSQL. It's also not clear what it's limitations are. This session will cover the basics of M and when to use it.

In this session, we'll demonstrate how M is a linear series of transformations, just like a set of steps from a recipe. We'll show how 80% of what you will ever need to do can be done from the GUI. We'll also talk about how to write custom code for that other 20%. By the end of this presentation, you'll be able to take any manual cleanup you do today and turn it into a repeatable process with M.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: December 14

Time: 11:10 AM - 12:25 PM

Room: 7030

SQL 2019 is coming here to stay. Do you know how to move to SQL 2019? In this riveting session we will learn about 
1. New Features of SQL 2019
2. Why you need to migrate?
3. How to upgrade/move to SQL 2019
4. Certifying your application for SQL 2019- A tricky question and discussion
5. Compatibility level and things you normally wouldn't care for!
6. Changes in functionality and caveats
7. The holy trinity: "Database Migration Guide", "Database Experimentation Assistant" and "Query Tuning Assistant"; tools that make your life easy.
8. A direct look into the "MAP Toolkit"
Time permitting we will demo these.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: December 14

Time: 8:20 AM - 9:35 AM

Room: Delaware 7052

Looking to get the most out of your SQL Saturday, PASS Summit, or local user group meeting? Plan ahead!  Events aren't just about learning new things, they're about meeting new people, networking with peers, and learning different approaches to common issues.

In this session, we'll go over steps you can take before, during and after the event to maximize the amount of great stuff you'll take away at the end (besides cool vendor swag).  Not just keeping up on new technologies, but meeting new people, getting leads on solutions/opportunities, and an appreciation for the community you're in and what it has to offer.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: December 14

Time: 8:20 AM - 9:35 AM

Room: 7030

Were you roped into “taking care” of SQL Server, gaining the “coveted” title DBA? (Had you only known…)

Do you have to deal with frequent performance problems like the app throwing timeouts at the users or the daily reports closing in on 24 hours runtime?

Does it seem, constant blocking or frequent deadlocks are now a common part of your daily agenda?
So, how do you even know where to start? Do you “add more indexes”, “increase memory”, “buy a new SAN”, “update statistics”, “move to the cloud”, or something else entirely?

The good news: SQL Server provides the tools you need to clear the fog and identify exactly what the problem is.

In this session, we’ll take a look at the query store, wait stats, live execution plans and more. After attending you’ll have the tools you need to be able to quickly identify the exact culprit in any low-performance situation.

And, next time your boss breathes down your neck, you might even be able to point out that SQL Server is not the problem.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: December 14

Time: 1:40 PM - 2:55 PM

Room: Georgia 7054

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