Build Schedule

Advanced Filters:
  • Track

    clear all








  • Speaker


  • Level


  • Session Type

Sessions Found: 60
Due to varying definitions of Big Data which confuse data volume and data organization, the common perception is that Big Data requires the use of Hadoop, MongoDB, or another NoSQL database.  SQL Server can easily store and manipulate very large volumes of data and perform quite well provided the database is properly set up and tuned.  In this session we'll cover some of the definitions and misconceptions of Big Data, look at some Big Data solutions that went horribly wrong and review a case where Big Data was successfully implemented in SQL Server.  Finally, we'll take a peek under the covers to see how SQL Server best handles Big Data through proper data models, table designs, performance tuning, and T-SQL techniques.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: May 19

Time: 3:30 PM - 4:30 PM

Room: Humperdinck's Castle

Not sure what value Power BI brings to your BI projects? Join me to discuss 10 ways Power BI can help augment your existing or envisioned Power BI strategy. If you're interested in the Power BI but you're not sure how it fits within your organizational BI strategy, this event is for you. Discussion points include:
•	Organizational BI
•	Self-service BI
•	Cloud vs. on-premises deployments
•	Predictive analytics
•	External reporting
•	Power BI-centric integrated solutions

Get your Power BI questions answered and see demos along the way.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: May 19

Time: 2:15 PM - 3:15 PM

Room: Patagonia

Are you new to Power BI? Do you want to learn what all the buzz is about and how to use it from a purely novice standpoint? Do you need to ramp up quickly to be able to build some great visualizations?  This session is the session that you need! We will walk you through the basic architecture and nuances of Power BI all the while taking a fun adventure to building your first Power BI report. The attendee will leave the class ready to start using Power BI in the real world.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: May 19

Time: 10:30 AM - 11:30 AM

Room: Patagonia

The Query Store has now been around for a little while but there are still lots of people questioning what to do with it. We will walk thru some of the common real life scenarios in which the Query Store can help you to find and fix everyday performance problems. We will also cover the necessary TSQL along with the built in tools and reports that you should be familiar with on a day to day basis. See how the Query Store can be an effective tool in your arsenal when it comes to poor query performance.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: May 19

Time: 8:00 AM - 9:00 AM

Room: Guilder

A sense of automation  is about developing awareness for patterns in our day-to-day repeatable tasks and processes, and creating solutions to automate them.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: May 19

Time: 9:15 AM - 10:15 AM

Room: Pirate Ship Revenge

Does your database development process match your agile frontend counterparts?
Is SQLServer Data Tools the right tool for an agile deployment methodology?

Join me in a fresh approach that will build deployments designed to be agile from the beginning, and also support the capability for zero down time deployments by supporting multiple states of the application, so database deployments can be made in advance, without breaking the application or requiring an outage.

Going zero will make you a hero!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: May 19

Time: 1:00 PM - 2:00 PM

Room: Guilder

Collaboration is the heart of SQLSaturday's, but too often attendees move from session to session in a passive learning mode.  This session is based on the Lean Coffee model, and is a structured workshop with no pre-planned agenda.  The goal is to involve YOU in the conversation; bring your questions, your answers, your business cards, and your desire to learn.  YOU set the agenda, YOU decide when to move on, and YOU engage and learn.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: May 19

Time: 1:00 PM - 2:00 PM

Room: Pit of Despair

Data Lake may be the hot new way to store data for reporting, but few people have actually worked with it. If you have no idea what a data lake is, have no fear! You will get an intro to the concept of data lake and what scenarios you should be considering it as your platform. From there you’ll get to see how Azure Data Lake Analytics and USQL allow developers and data professionals to create compelling analytics with data that previously was hard to work with.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
101: Beginner Level Sessions

Level: Beginner

Session Code:

Date: May 19

Time: 3:30 PM - 4:30 PM

Room: Cliffs of Insanity

While Azure SQL Database provides the full feature of the SQL Server database engine, it is designed primarily for newly developed, cloud-based applications.  For existing applications running on traditional SQL Server instances, the cost and complexity of migration can be prohibitive.  With the release of Azure Managed Instances, much of the cost and complexity have been removed.  Join me for this session to learn about the differences between Azure SQL Database and Azure Managed Instances. Additionally, discover methods for migrating existing instances to Azure.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: May 19

Time: 8:00 AM - 9:00 AM

Room: The Thieve's Forest

Have you been wondering what Azure SQL Database is and what it means for you as a production DBA? Azure SQL Database has become an Enterprise-worthy database platform that provides relational database-as-a-service. In this session you’ll get a grounding in the fundamentals of  Azure SQL Database from a DBA perspective. First we’ll cover how to create an Azure SQL Database using the Azure Portal and an approach for sizing a new Azure SQL Database. Then we’ll cover some of the similarities and differences between on premises SQL Server and Azure SQL Database. Finally we will cover how monitoring and performance tuning Azure SQL Database differs from on premises SQL Server. If you’ve been considering Azure SQL Database for your organization, this session is for you!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: May 19

Time: 2:15 PM - 3:15 PM

Room: Guilder

Write me a query where a SQL Position/Job does not ultimately affect an end customer. The reality is that even the most isolated IT teams have multiple customers - internal and external. Disney is a world class leader in Customer Experience. In this session we will explore how Disney's approach can help us build better platforms! Learn how to define your customers and their needs, differentiate your service, envision the future, and influence change. Come be Moused - Mickey Ears Optional!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: May 19

Time: 8:00 AM - 9:00 AM

Room: Pit of Despair

Automating extract packages is trivial., you simply use INFORMATION_SCHEMA.  The problem is not all your data sources have easy to read metadata like SQL Server.  How do you create usable metadata from these sources? In this hour, I’ll show you how easy it is to make an educated guess on the schema of flat files and other “semi-structured” data sources.  

With that schema, automatically generating your extract package is a matter of seconds!  Join me while I share my interrogator project with you and start saving hours at work today!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: May 19

Time: 2:15 PM - 3:15 PM

Room: Miracle Max's Hut

Is this a replacement for architectures out there today like Kimball, Inmon, Federated, etc? 
NO! It’s more about creating patterns and designs that focus on putting the data in the hands of the users by leveraging existing architectures.

All data assets, we really want to give our users a single source of the truth. We want them to go to one place to get all their data, that’s the common goal in enterprise data solutions. The problem is not all the data resides in one place, especially with big data, more tech savvy users, the vast amount of data resources available… you can really get data from anywhere. 

Promotes self-service by 
leveraging data assets you already have
increasing your business’ consumable data based on both need and data readiness. 

This is not a data dump but more about getting good data to the right business people at the right time.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: May 19

Time: 1:00 PM - 2:00 PM

Room: Miracle Max's Hut

Containers have quietly been taking over the world of infrastructure, especially amongst developers and CI/CD practitioners. However, in the database space, container adoption has been lower. SQL Server 2017 introduced the concept of deploying databases into Docker containers. In this session, you will learn the fundamentals of creating containers, learning about Kubernetes for management, and how to further your learning in this new and emerging space.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: May 19

Time: 10:30 AM - 11:30 AM

Room: The Thieve's Forest

In this session you will be learn what Cosmos DB is and why it is the hottest thing in Azure.
What does massively scalable, mullti-model, globally distributed, well-defined consistency models look like?

Most important, who is going to be using it and why?
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: May 19

Time: 2:15 PM - 3:15 PM

Room: The Thieve's Forest

Why create a SQL Server Test premise environment in Azure cloud?  One of the first steps into moving to Azure cloud, is building an environment that looks a feels like premise but only in the cloud.  This session is an overview of getting started with basics of Azure environment, such as Accounts, virtual networks, Storage and creating virtual machines..  Once we fly by reviewing several building blocks, we then build Active Directory VM, SQL Server VM and App Server Tier VM using Azure portal and PowerShell.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: May 19

Time: 3:30 PM - 4:30 PM

Room: The Thieve's Forest

Dreams become reality and it's time for you to create the life you want. What's your vision? Where do you see yourself in 5 years? What's the next step in your professional career? Are you living life to the fullest and doing what really makes you happy? Discover a new you and learn to succeed and live without regrets in this very interactive seminar.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: May 19

Time: 9:15 AM - 10:15 AM

Room: Pit of Despair

They're just numbers, right?  A date's a date.  It's just string data, who cares?  I can't tell you how many times I've heard these phrases.  This session will help you understand why choosing the correct data type for your data is so important.  It affects data quality, storage and performance.  It can even produce incorrect query results.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: May 19

Time: 8:00 AM - 9:00 AM

Room: Humperdinck's Castle

How do you optimize a DAX expression? In this session, we analyze some DAX expressions and Tabular models. Through the usage of DAX Studio and some understanding of the VertiPaq model, we will look at how to optimize them.
As you will see, most optimizations are the direct application of best practices. Moreover, the session has the additional takeaway of understanding what kind of performance you should expect from your formulas, and what improvements you might expect from learning how to optimize the model and the code.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Advanced

Session Code:

Date: May 19

Time: 9:15 AM - 10:15 AM

Room: Fire Swamp

Do you want to make your deployments risk free? Do you want to deliver business values to your customers faster? Do you want to increase the efficiency of your Team? Are your application and database deployment separate processes? Do you encounter issues while deploying your database changes? Is your database slowing you down?

If the answer to any of the above questions is a Yes, then this presentation is for YOU. 

Come join me in this 60 min session to understand the problems with traditional database development, why organizations are moving towards achieving Continuous Integration and Database DevOps, the problems it tries to solve and learn about the toolsets which will assist you in this journey towards painless database deployments.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: May 19

Time: 1:00 PM - 2:00 PM

Room: Humperdinck's Castle

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