Build Schedule

Advanced Filters:
  • Track

    clear all








  • Speaker


  • Level


  • Session Type

Sessions Found: 68
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:

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 223

Consistent and predictable performance is critical for any successful deployment of Microsoft SQL Server. All-Flash arrays have been available for years and sub-millisecond response times should be the expectation. Maximize the performance and agility of your environment and learn how to automate and leverage self-service for snapshots of your databases for protection and re-purposing. Test/dev infrastructures can be refreshed from production DBs in minutes rather than hours or days. Stop working harder and slower than you need to be, learn how you can leverage Dell EMC. Whether storage, servers, networking, data protection, converged or hyper-converged…  we have you covered.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: May 19

Time: 11:45 AM - 12:45 PM

Room: Pirate Ship Revenge 225

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:

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 214

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:

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 214

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:

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 110

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:

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 225

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:

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 110

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 216

Microsoft Cognitive services is a series of services based on Microsoft Research using Deep Learning techniques, ready for you to enrich your unstructured data. Microsoft Services includes: Vision (Computer Vision, Emotion, Face, Video), Speech/Language (Speaker Recognition, Spell, Sentiment, Language, Key Phrases, Topic detection, Linguistic Analysis), Knowledge, and Search. These services are consumed by using the Cognitive Services APIs. Power BI enables you to consume the APIs to enrich your unstructured data inside your Power BI solutions. During this session, we will cover how to consume the API using Power Query to then visualize the results with Power BI visuals. We will also consume the Cognitive services API by using a R script inside Power BI. This session is structured with a B2C Survey case study solution with a real time Dashboard using a streaming dataset.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
101: Beginner Level Sessions

Level: Intermedia

Session Code:

Date: May 19

Time: 3:30 PM - 4:30 PM

Room: Fire Swamp 111

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:

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 215

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:

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 224

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 110

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:

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 216

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:

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 226

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 226

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 224

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:

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 224

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:

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 224

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 216

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:

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 223

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