Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type

Sessions Found: 32
A dive into the basics and some advanced dimensional modeling concepts and design patterns. Topics covered will be introduction to dimensional modeling and difference from transaction vs analytics consumptions, primary and foreign keys, different types of facts and dimensions, slowly changing dimensions and various types, common design patterns for handling date, time, product, inventory etc.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: August 17

Time: 4:00 PM - 5:00 PM

Room: 3. San Joaquin

Since Power BI was released four years ago, Power BI, Office 365, and Azure have added significant automation capabilities. To stay informed, you need to learn about the most recent capabilities and what they mean to you.

Angel Abundez will present a wide-ranging overview of the data refresh setups common to Power BI data sources, going from DIY to more advanced scenarios that need IT support. Whether you’re automating reports for your department or for the enterprise, there’s something here for you.

You'll learn how to:

* Set up your datasets in Excel and Power BI to be automated

* Refresh data from files hosted on SharePoint, One Drive, and REST APIs (CSV, Excel, JSON, etc)

* Pull data from on-premises and cloud data sources using the latest capabilities of Power Apps, the Power BI Service, and Azure

* Automate your Power BI analysis?in?PowerBI.com, One Drive, or even your O365 mailbox

* Work with cloud databases such as Amazon Redshift, Azure SQL DB, and Snowflake
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: August 17

Time: 8:30 AM - 9:30 AM

Room: 4. Alameda

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: August 17

Time: 8:30 AM - 9:30 AM

Room: 2. SentryOne (SF)

If data is the new oil, then Big Data is the new snake oil. 
For over a decade, Big Data has managed to delude far too many smart, honest, hard-working data practitioners, with nothing but the best intentions.
This session is a plea for your common sense and decency. 
Together, we will use history, facts, authority, and logic to expose it for what it really is. 
Layer by layer, we will peel off the Confusion, Illusion, Deception, Distraction and the Regression that is "Big Data".
You will realize just how much progress and value Big Data has bestowed on us over the past decade.
But more importantly, we will see what we can and must do to make data practice, and consequently the world, a better place. 
Brace yourself for a thought-provoking session, filled with "Aha" moments. 
I promise that after this session, you will never look at big data the same way as you did before you stepped into the room.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: August 17

Time: 4:00 PM - 5:00 PM

Room: 1. Snowflake (Placer)

Is there a gap between your advanced technical skills and your social-emotional intelligence? Are you or your employees experiencing challenges communicating effectively with others, participating as part of a team, managing emotional reactions, or socially connecting at work? Is this impacting your ability to get promoted, retain employees, or establish positive workplace morale or relationships?  Do you want to increase your “likeability” factor for your professional growth and overall well-being? 

If you answered yes to any of these questions, then this session is for you! For many people, “social” does not come naturally and has to be explicitly taught. In this presentation, you will learn about the mindset that is required for developing new competencies, key cognitive skills needed for social success, and tools and strategies that you can use immediately with your team. This session is for people who have difficulty navigating the social world, as well as for their managers.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: August 17

Time: 1:30 PM - 2:30 PM

Room: 5. San Mateo

Cosmos DB is one of the fastest growing Azure Services, we all have questions about this new database system. In this session, I am going to answer some of the common questions about Azure Cosmos DB by using SQL API. 
Join me to see Cosmos DB in action with many demos! Don't miss it.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: August 17

Time: 2:45 PM - 3:45 PM

Room: 3. San Joaquin

Let's face it: Microsoft Data Platform is not just SQL Server anymore. Azure has added a dozen of other data related products to the menu. Being a cloud DBA means dealing with these new options when needed. 
In this session packed with demos you will see how to cross the bridge between SQL Server and Cosmos DB back and forth; how to related items from both sides and what is required to design a CosmosDB deployment.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: August 17

Time: 9:45 AM - 10:45 AM

Room: 3. San Joaquin

It seems more lately than not, there are daily stories of a data breach somewhere. Data security is one of the most critical things a data professional should be aware of. Now, there are several ways of implementing data security in today's world. SQL Server comes with several native data encryption methods that you can use. In this session, we will explore the basics of data encryption, how to implement some of them, some gotchas as well as some of the newer features of data encryption in newer versions.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: August 17

Time: 1:30 PM - 2:30 PM

Room: 1. Snowflake (Placer)

In today’s world reporting and analytics are no longer focused exclusively on internal data from transactional systems and the data warehouse. Mashups of data from corporate, partner, commercial and public sources are the new normal.
In this presentation we will review traditional strategies for data cleanup, explore Power BI Desktop features for data exploration and look at Power BI Desktop configuration tips. Building readable, reusable and shareable cleanup scripts in M using the Power Query Advanced Editor will also be covered.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: August 17

Time: 8:30 AM - 9:30 AM

Room: 5. San Mateo

Every DBA should know about database corruption because it can be a resume generating event. A corrupt database can ruin your day, affect system stability, lead to unnecessary downtime, and possibly data loss. 

In this presentation we will explore database corruption, learn how to diagnose, and see what we can do to fix it. We will discuss the causes, dispel some myths, and learn what questions to ask. After this, we dive into discovering the root cause and putting a plan in place to stop it in the future. Demos will illustrate diagnosing, troubleshooting, and fixing database corruption. Prepare to break a database and go through the steps to return it back to a usable state. 

Beginners will benefit along with others who may one day find themselves with a corrupt database. By the end of the session, you will have the tools and understanding necessary to take corrective action and prevent your databases from corruption!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: August 17

Time: 1:30 PM - 2:30 PM

Room: 2. SentryOne (SF)

Database testing takes many forms ranging from server setup validation to stored procedure functionality testing and many areas in between. In this session we will cover how to get started when you have existing systems or are designing a new system from the ground up. This is a demo heavy session that all ability levels can get something from.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: August 17

Time: 4:00 PM - 5:00 PM

Room: 5. San Mateo

Environment setup in some organizations can take days and even then it is not consistent and has components missing or configured incorrectly. These problems can be solved and this session will cover several techniques for doing just that. In this session we will use Docker to create 3 SQL environments. The first is a production like environment for UAT. In the second environment will redact the confidential data and in the third environment reduce the dataset by 90%.

This three tiered environment setup can work with or without Docker. In this session we will also cover using Chocolatey NuGet's, which sounds tasty, but it is also a very powerful method of installing software on Windows.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: August 17

Time: 8:30 AM - 9:30 AM

Room: 3. San Joaquin

When called in to diagnose a performance issue what are the 1st things you review? Many DBAs and developers make the mistake of diving straight into the code looking for an answer. However, often times the solution is not in the code but rather in the overall environment. Environmental troubleshooting is often a quick and overlooked method for discovering and configuring SQL Server to perform at a higher level without the need for application change controls.

In this session we will discuss both performance pitfalls and optimizations that can be made to the system outside of code changes. We will diagnose configurations commonly misapplied and review best practices in SQL Server, Windows Server, and VMware!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: August 17

Time: 11:00 AM - 12:00 PM

Room: 4. Alameda

Have you implemented Power BI in your work to build powerful dashboards and want to encapsulate complex business logic? Do you struggle writing MDX queries in the multidimensional model? If your answer is yes, then join me in this DAX presentation to see how to create measures that make use of the DAX language. I will go over the DAX (Data Expression Language), powerful functions such as SUMMARIZECOLUMNS(), HASONFILTER(), CALCULATE(), USERELATIONSHIP(), RELATED(), FILTER(), ALL() and many more. I will go over the use of variables to make your DAX expression self-documenting and create additional columns in the dimension Date table that slicers or parameters can use to detect the years/months with actual data in Fact Tables.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: August 17

Time: 4:00 PM - 5:00 PM

Room: 4. Alameda

If you would like to learn about Spatial Data but don’t know where to start, this session is for you. We will begin by focusing on what Spatial Data is through examples and interactive demo’s. The goal is to show how Spatial Data can improve your professional experience and serve as an asset to your business. 

I will introduce you to Spatial Data in the SQL server and show how to import data into SQL Server. We will focus on demonstrations of the SQL Server 2016 and JSON functions used to create geoJSON objects from Spatial Data. Next we will cache these objects by using In-Memory tables with the help of SQL Server 2017.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: August 17

Time: 9:45 AM - 10:45 AM

Room: 5. San Mateo

Functions are stored blocks of code that can be reused in order to create simpler, more stable, and cleaner code. Functions can be great to have; however, they can also become a royal pain. Scalar and table valued functions can cause serious performance issues and the root cause may not be easy to find. In this session we will go over: (1) How to identify if a function is causing poor performance (with examples); (2) Methods that can be used to modify the function to greatly improve performance; (3) Improvements that come with SQL Server 2019 that may make you want to upgrade sooner rather than later.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: August 17

Time: 11:00 AM - 12:00 PM

Room: 2. SentryOne (SF)

Dan Hess: SSRS Reports in SSMS
Dilip Nayak: Use Cases for Availability Groups
Saru Radhakrishnan: Set Operations Using Inline Table-Valued Functions
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: August 17

Time: 1:30 PM - 2:30 PM

Room: 4. Alameda

Ted Stathakis: ProperCase - My Favorite UDF
Glenn Burnett: Monitoring Failed Queries in SQL Server
Alex Purice: SQL Server Replication 101
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: August 17

Time: 2:45 PM - 3:45 PM

Room: 4. Alameda

Power BI adoption growth has been astonishing. And with growing demand we also have growing needs. The service started as an end user driven data visualization tool, but is now heading to an enterprise grade semantic layer. In this session, we will go through, and dive into, the Power BI pieces and service parts.  We’ll make sense of them together and when to apply and deploy each one.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: August 17

Time: 11:00 AM - 12:00 PM

Room: 5. San Mateo

Monitoring Power BI means having knowledge of all the content currently hosted in your Power BI tenant. What datasets and reports have been published? What users have access to these resources? How often are they looking at these reports? How have data refreshes been performing?

By monitoring, you will truly understand what makes you an Administrator of Power BI. You'll see the different screens it takes to monitor everything in your tenant. Plus, you'll discover if there's a better way to monitor your tenant through collecting API data and analyzing it to derive some actionable insights for improved data governance in your companies.

BI expert Angel Abundez will demo the Power BI administrative screens you use today to monitor your tenant. Then he'll do some PowerShell development in VS Code to collect API data and see if it's possible to use that data in Power BI for added insights.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: August 17

Time: 9:45 AM - 10:45 AM

Room: 2. SentryOne (SF)

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