| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:00:00 | Ray Kim | Personal / Professional Development | Networking 101: Building professional relationships |
| 09:00:00 | James Serra | Data Ware House Development / ETL / SSIS | Building a modern data warehouse |
| 09:00:00 | Steve Simon | Data Ware House Development / ETL / SSIS | Creating efficient and effective SSRS BI Solutions |
| 09:00:00 | George Walkey | Data Ware House Development / ETL / SSIS | Using Extended Events to Build a Login Cube |
| 09:00:00 | Marcelo Adade | Database Administration / Infrastructure | Distributed Availability Groups - How to |
| 09:00:00 | Alex Grinberg | Application Database Development | CONVERT_IMPLICIT is a hidden danger |
| 09:00:00 | Eric Blinn | Application Database Development | Intro to indexing for SQL writers |
| 09:00:00 | Allan Hirt | Database Administration / Infrastructure | Top Tips for Deploying AGs and FCIs On Premises or In the Cloud |
| 09:00:00 | John Miner | Application Database Development | Effective Data Warehouse Storage Patterns |
| 09:00:00 | Dan King | Data Visualization/BI/Reporting/Analytics | PowerBI and PowerApps Married at First Sight |
| 09:00:00 | Cornell Emile | Data and the Cloud | Keeping Your Data Secure In Azure While Automatically Refreshing Power BI Datasets |
| 09:00:00 | Jamey Johnston | Machine Learning / AI | Code Like a Pirate ... Intro to R and Data Science Tools in MS |
| 10:15:00 | James Serra | Personal / Professional Development | How to build your career |
| 10:15:00 | Steve Simon | Data Visualization/BI/Reporting/Analytics | SQL Server Reporting Services 2017 on Steroids!! |
| 10:15:00 | Matt Cushing | Personal / Professional Development | Networking 102: Getting Ready for a SQL Event |
| 10:15:00 | Michelle Gutzait | Database Administration / Infrastructure | Top FREE performance troubleshooting tools for SQL Server |
| 10:15:00 | Chris Seferlis | Data and the Cloud | Azure SQL Managed Instances - A mostly full-featured SQL Server in the Cloud |
| 10:15:00 | Paul Stanton | Application Database Development | SQL DevOps Simplified with Production Databases |
| 10:15:00 | Justin Dearing | Application Database Development | Version control with GIT for the DBA |
| 10:15:00 | Matt Gordon | Database Administration / Infrastructure | The DBA Quit and Now You're It: Action Plan |
| 10:15:00 | George Walkey | Database Administration / Infrastructure | Centralized Alert Dashboarding |
| 10:15:00 | Alexander Fleming | Application Database Development | Why You Should Consider Implementing Indexed Views |
| 10:15:00 | Kevin Feasel | Application Database Development | Approaching Zero: Minimizing Downtime During Deployments |
| 10:15:00 | Jamey Johnston | Machine Learning / AI | Code Like a Snake Charmer - Intro to Python! |
| 10:15:00 | Richard Waymire | Data and the Cloud | Running SQL Server on AWS |
| 11:30:00 | Ray Kim | Personal / Professional Development | Tech Writing for Techies: A Primer |
| 11:30:00 | Michelle Gutzait | Data Governance/Privacy/Auditing/Documentation | Implementing Security Standard Regulations in SQL Server Azure |
| 11:30:00 | Darius Liktorius | Data and the Cloud | SQL Server in the Cloud: Microsoft Azure vs Amazon Web Services (AWS) |
| 11:30:00 | Sandy Winarko | Data Ware House Development / ETL / SSIS | PaaSport to Paradise: Lifting Shifting with Azure SQL Database + SSIS in Azure Data Factory |
| 11:30:00 | Ganesh Lohani | Data Visualization/BI/Reporting/Analytics | Implementing ETL solution for incremental data load |
| 11:30:00 | Marcelo Adade | Database Administration / Infrastructure | Linux Administration for SQL SERVER DBAs |
| 11:30:00 | Taiob Ali | Tools Utilities | New features in Management Studio -- Performance Troubleshooting made easier! |
| 11:30:00 | Allan Hirt | Database Administration / Infrastructure | Is Physical Still An Option for SQL Server Deployments? |
| 11:30:00 | MIKE DONNELLY | Strategy and Architecture | DataOps - Deploy SQL Server Databases Using Azure Pipelines |
| 11:30:00 | Joe Obbish | Application Database Development | Improving Columnstore Load Scalability on Large Servers |
| 11:30:00 | Forrest McDaniel | Application Database Development | An Animated Look at Query Plans |
| 11:30:00 | Joshua Higginbotham | Application Database Development | Introduction to GitHub |
| 13:00:00 | Jay Rajendran | Data and the Cloud | Running Windows and SQL Workloads on Google Cloud Platform |
| 13:00:00 | Neil Weicher | Database Administration / Infrastructure | Protecting Distributed and Legacy SQL-based Applications |
| 13:00:00 | Geoffrey Rayner | Data Governance/Privacy/Auditing/Documentation | Data Governance Implications of the California Consumer Protectio |
| 13:00:00 | Kathi Kellenberger | Application Database Development | Myth Busters: the truth of what it’s like to be a woman in tech. |
| 14:15:00 | Thomas Grohser | Database Administration / Infrastructure | Persistent Memory and Hybrid Buffer Pool - The good, bad and ugly |
| 14:15:00 | Carlos Robles | Strategy and Architecture | Exploring SQL Server containers on Docker Kubernetes |
| 14:15:00 | George Walters | Data Governance/Privacy/Auditing/Documentation | Organizational Security Compliance with SQL 2012 through 2016/2017 |
| 14:15:00 | Joseph Yeates | Data Visualization/BI/Reporting/Analytics | Predictive Analytics with R in Power BI |
| 14:15:00 | Rune Ovlien Rakeie | Data and the Cloud | Easing the pain of database migrations, a closer look at the new cloud citizen - DMS |
| 14:15:00 | Jean Joseph | Database Administration / Infrastructure | HOW TO TROUBLESHOOT DATABASE PERFORMANCE ISSUES |
| 14:15:00 | Justin Dearing | Application Database Development | An Introduction to Always Encrypted |
| 14:15:00 | Kathi Kellenberger | Application Database Development | T-SQL Window Function Deep Dive |
| 14:15:00 | Taiob Ali | Data and the Cloud | What is kusto query language? |
| 14:15:00 | Kevin Feasel | Application Database Development | Data Virtualization with PolyBase |
| 14:15:00 | Nilton Kazuyuki Ueda | Data Visualization/BI/Reporting/Analytics | Sharing and collaborating with your company through Tableau Server |
| 14:15:00 | Cecilia Brusatori | Data Visualization/BI/Reporting/Analytics | Level-up your Power BI Reports |
| 15:30:00 | Rahat Yasir | Machine Learning / AI | PoC to Enterprise AI Application Designing using Cognitive Services |
| 15:30:00 | David Bermingham | Database Administration / Infrastructure | High Availability and Disaster Recovery for SQL Server in Azure IaaS |
| 15:30:00 | Mark Broadbent | Database Administration / Infrastructure | SQL Server Availability Groups for dummies |
| 15:30:00 | Jens Vestergaard | Data Visualization/BI/Reporting/Analytics | Power BI Live Data sets, Monitoring your key metrics |
| 15:30:00 | Ned Otter | Application Database Development | Will my workload run faster with In-Memory OLTP? |
| 15:30:00 | John Miner | Application Database Development | How to audit and prevent unwanted user actions. |
| 15:30:00 | Ashwini Jain | Data Visualization/BI/Reporting/Analytics | How to automate row level security in Power BI using DAX and SSAS |
| 15:30:00 | Brandon Leach | Application Database Development | Building a proper indexing strategy |
| 16:45:00 | Ray Kim | Personal / Professional Development | Whacha just say? Talking technology to non-technical people |
| 16:45:00 | Thomas Grohser | Other | "Schadenfreude" - Let's enjoy the mistakes other people made... |
| 16:45:00 | Hasan Savran | Application Database Development | Unexplored Features of SQL Server |
| 16:45:00 | Sarah Patrick | Application Database Development | Case Study: How I used SharePoint, Flow, PowerApps, and Forms to build a Speaker Database |
| 16:45:00 | Rahat Yasir | Machine Learning / AI | Introduction to Financial Data Analysis using Azure Machine Learning |
| 16:45:00 | Sandy Winarko | Data Ware House Development / ETL / SSIS | Back to the Future: Accelerating the Cloud Migration of Legacy SSIS with Azure Data Factory |
| 16:45:00 | Matt Gordon | Database Administration / Infrastructure | Azure-d Availability: SQL Server HA In and To the Cloud |
| 16:45:00 | Dan (Annie) Xu | Data Visualization/BI/Reporting/Analytics | Power BI Performance Improvement |
| 16:45:00 | Mark Broadbent | Data Visualization/BI/Reporting/Analytics | Power BI for absolute beginners |
| 16:45:00 | Eric Blinn | Application Database Development | I have indexes, but do I have the right indexes? |
| 16:45:00 | Ned Otter | Database Administration / Infrastructure | Table Partitioning 101 |
| 16:45:00 | Larry Blake | Application Database Development | Database DevOps with Visual Studio and Jenkins |
| 16:45:00 | James Phillips | Personal / Professional Development | Leadership 101: Guiding principals to success |
Event Date: 05-10-2019 - Session time: 09:00:00 - Track: Personal / Professional Development
In this interactive session, we will discuss networking — what it is, why it’s important, and where opportunities exist. You will even have an opportunity to practice networking within the confines of our room. You might even leave this session with new networking contacts that you didn’t previously have!
Event Date: 05-10-2019 - Session time: 09:00:00 - Track: Data Ware House Development / ETL / SSIS
Event Date: 05-10-2019 - Session time: 09:00:00 - Track: Data Ware House Development / ETL / SSIS
Event Date: 05-10-2019 - Session time: 09:00:00 - Track: Data Ware House Development / ETL / SSIS
you to track SQL Server Logins that can be slices and diced per Hour, Server, User, Host, Connection String and Database.
This session touches on multiple advanced topics that you can use individually, but together, make for a powerful SQL Security Auditing Tool not found anywhere else. Includes downloadable source code.
Event Date: 05-10-2019 - Session time: 09:00:00 - Track: Database Administration / Infrastructure
Event Date: 05-10-2019 - Session time: 09:00:00 - Track: Application Database Development
Event Date: 05-10-2019 - Session time: 09:00:00 - Track: Application Database Development
This class presents indexes from the ground up and lays the foundation for solid index usage. We'll cover what indexes are, different types of indexes, when to use them, and when not to use them. We'll also briefly cover index maintenance.
This class is designed for beginners and is designed to be very practical. It won't dive deep on any one subject and won't bog down with technical minutiae.
Event Date: 05-10-2019 - Session time: 09:00:00 - Track: Database Administration / Infrastructure
Event Date: 05-10-2019 - Session time: 09:00:00 - Track: Application Database Development
Unexpected information growth in your data mart may lead to a performance impacted reporting system. In short, your users will be lining up at your cube for their daily reports.
How do you reduce the size of your data mart and speed up data retrieval? This presentation will review the following techniques to fix your woes.
Techniques: 1 – What is horizontal partitioning? 2 – Database sharding for daily information. 3 – Working with files and file groups. 3 – Partitioned views for performance. 4 – Table and Index partitions. 5 – Row Data Compression. 6 – Page Data Compression. 7 – Programming a sliding window. 8 – What is different in Azure SQL database?
Event Date: 05-10-2019 - Session time: 09:00:00 - Track: Data Visualization/BI/Reporting/Analytics
Event Date: 05-10-2019 - Session time: 09:00:00 - Track: Data and the Cloud
So how do you support the automatic data refresh of the data within Power BI and still ensure that the security of your company's data is not compromised?
This advanced Power BI session presents several techniques that can be used to maintain (and sometimes enhance) the security of your company's data while ensuring that Power BI datasets are regularly refreshed.
Event Date: 05-10-2019 - Session time: 09:00:00 - Track: Machine Learning / AI
Come to this session to get an introduction to the R language including:
We will finish with a brief introductions of how R integrates in Azure ML, Power BI, and SQL Server 2016 using real demos.
The focus of the session will be primarily on the introduction to the R language and getting attendees comfortable with using R to start the journey into Data Science!
Event Date: 05-10-2019 - Session time: 10:15:00 - Track: Personal / Professional Development
I'll cover tips I learned over my career on everything from interviewing to building your personal brand. I'll discuss perm positions, consulting, contracting, working for Microsoft or partners, hot fields, in-demand skills, social media, networking, presenting, blogging, salary negotiating, dealing with recruiters, certifications, speaking at major conferences, resume tips, and keys to a high-paying career.
Your first step to enhancing your career will be to attend this session! Let me be your career coach!
Event Date: 05-10-2019 - Session time: 10:15:00 - Track: Data Visualization/BI/Reporting/Analytics
In this hands on presentation we shall be looking some of the more challenging techniques of extracting our data from our Multidimensional and Tabular Models, in addition to our Data Mining Models. We shall be utilizing concepts of ‘Openquery()’ and ‘linked servers’ as a means to extract data, in addition to looking at the way that these two concepts can help us extract our data utilizing MDX, DMX and DAX expressions; AND YET maintain the flexibility and the ability to utilize all those wonderful techniques that may be done with T-SQL.
Event Date: 05-10-2019 - Session time: 10:15:00 - Track: Personal / Professional Development
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.
Event Date: 05-10-2019 - Session time: 10:15:00 - Track: Database Administration / Infrastructure
Event Date: 05-10-2019 - Session time: 10:15:00 - Track: Data and the Cloud
Event Date: 05-10-2019 - Session time: 10:15:00 - Track: Application Database Development
Event Date: 05-10-2019 - Session time: 10:15:00 - Track: Application Database Development
What does this mean to a DBA? Whether or not you use SSDT, you should be storing your database schema in version control. In addition, your utility scripts certainly belong in VCS.
In my session. We'll cover:
Why should I store my schema in SSDT to help prevent developers from using code first ORMs. What is version control? How does a distributed version control system differ from traditional version control like Visual Sourcesafe, TFS, and SVN? How do I setup git for internal use in my company? How do I host public and private repositories on github. How do pull requests work? We will be covering using git from both the command line and Visual Studio.
Event Date: 05-10-2019 - Session time: 10:15:00 - Track: Database Administration / Infrastructure
Event Date: 05-10-2019 - Session time: 10:15:00 - Track: Database Administration / Infrastructure
Event Date: 05-10-2019 - Session time: 10:15:00 - Track: Application Database Development
Event Date: 05-10-2019 - Session time: 10:15:00 - Track: Application Database Development
Event Date: 05-10-2019 - Session time: 10:15:00 - Track: Machine Learning / AI
The session will be an introduction to the Python language including:
1.) Installing and Configuring Python 2.) Access and Manipulate Data 3.) Install and Manage Packages 4.) Create and Use Objects/Variables 5.) Control Flows and Functions 6.) Managing the Python installation in MSSQL
Attend this session to learn how to use Python to take your data analytics to the next level. We will use Python, SQL Server and the Anaconda distribution of Python to learn the basics of Python and how it is integrated in the Microsoft stack! We will walk through a simple deployment of a machine learning model to see how it all works together and learns some basic data science fundamentals.
No prior statistics knowledge needed.
Event Date: 05-10-2019 - Session time: 10:15:00 - Track: Data and the Cloud
Event Date: 05-10-2019 - Session time: 11:30:00 - Track: Personal / Professional Development
Event Date: 05-10-2019 - Session time: 11:30:00 - Track: Data Governance/Privacy/Auditing/Documentation
Event Date: 05-10-2019 - Session time: 11:30:00 - Track: Data and the Cloud
Event Date: 05-10-2019 - Session time: 11:30:00 - Track: Data Ware House Development / ETL / SSIS
Event Date: 05-10-2019 - Session time: 11:30:00 - Track: Data Visualization/BI/Reporting/Analytics
Event Date: 05-10-2019 - Session time: 11:30:00 - Track: Database Administration / Infrastructure
In this section let´s see how to perform the most common troubleshooting tasks, that we are already used to performing on Windows, now on Linux.
Event Date: 05-10-2019 - Session time: 11:30:00 - Track: Tools Utilities
Do you know that you can now see how many pages are spilled to disk for a sort, as well as the memory statistics for the operator? Are you aware that you can see the top 10 waits for an execution and what trace flags were active during compilation and which ones influenced compilation? Have you ever analyzed a big plan and wish you could search for table name, index name or column name without opening XML plan? When you see a clustered index was used do you know for sure which statistics were used by the Query Optimizer to estimate the number of rows?
In this demo intensive session, I will show you how to find and use new features introduced into SSMS and Showplan. You will walk out of this session equipped to make Query Performance Troubleshooting easier and ready to tackle those nasty, hard to solve query plans.
Event Date: 05-10-2019 - Session time: 11:30:00 - Track: Database Administration / Infrastructure
Event Date: 05-10-2019 - Session time: 11:30:00 - Track: Strategy and Architecture
Event Date: 05-10-2019 - Session time: 11:30:00 - Track: Application Database Development
Event Date: 05-10-2019 - Session time: 11:30:00 - Track: Application Database Development
Event Date: 05-10-2019 - Session time: 11:30:00 - Track: Application Database Development
Event Date: 05-10-2019 - Session time: 13:00:00 - Track: Data and the Cloud
Event Date: 05-10-2019 - Session time: 13:00:00 - Track: Database Administration / Infrastructure
However, what if you are, say, a commercial developer or device manufacturer with hundreds or even thousands of customers who need to come into compliance? You obviously don't want to do a point-and-click deployment on each one. This session will show how you can use Encryptionizer's script-based deployment to install on one or ten thousand machines (even Legacy machines) with no programming and no user interaction.
Event Date: 05-10-2019 - Session time: 13:00:00 - Track: Data Governance/Privacy/Auditing/Documentation
Event Date: 05-10-2019 - Session time: 13:00:00 - Track: Application Database Development
Event Date: 05-10-2019 - Session time: 14:15:00 - Track: Database Administration / Infrastructure
Event Date: 05-10-2019 - Session time: 14:15:00 - Track: Strategy and Architecture
Event Date: 05-10-2019 - Session time: 14:15:00 - Track: Data Governance/Privacy/Auditing/Documentation
Event Date: 05-10-2019 - Session time: 14:15:00 - Track: Data Visualization/BI/Reporting/Analytics
Event Date: 05-10-2019 - Session time: 14:15:00 - Track: Data and the Cloud
In order to overcome these pain points we have now available, both in Azure and AWS, services and tools that alleviate these pains and brings your valuable data safely across with near-zero downtime.
In this talk we will:
Event Date: 05-10-2019 - Session time: 14:15:00 - Track: Database Administration / Infrastructure
Event Date: 05-10-2019 - Session time: 14:15:00 - Track: Application Database Development
Event Date: 05-10-2019 - Session time: 14:15:00 - Track: Application Database Development
SQL Server 2005 and later versions introduced several T-SQL features that are like power tools in the hands of T-SQL developers. If you aren’t using these features, you’re probably writing code that doesn’t perform as well as it could. This session will teach you how to avoid cursor solutions and create simpler code by using the windowing functions that have been introduced between 2005 and 2012. You'll learn how to use the new functions and how to apply them to several design patterns that are commonly found in the real world.
You will also learn what you need to know to take full advantage of these features to get great performance. We’ll also discuss which features perform worse or better than older techniques, what to watch out for in the execution plan, and more.
Event Date: 05-10-2019 - Session time: 14:15:00 - Track: Data and the Cloud
I have invested a lot of effort and received expert advice from Microsoft Engineers in learning how to work with Azure Monitor Log. Sharing what I have learned is going to save time and effort for anyone that will be responsible for managing resources in Azure.
Event Date: 05-10-2019 - Session time: 14:15:00 - Track: Application Database Development
Event Date: 05-10-2019 - Session time: 14:15:00 - Track: Data Visualization/BI/Reporting/Analytics
As a Tableau Desktop user, you will be able to create workbooks and views, dashboards, and data sources in Tableau Desktop, and then publish this content to your Server.
As a Tableau Server user, you will be able to access up-to-date content and gain quick insights without relying on static distributed content.
As a Tableau Server administrator you will control who has access to server content to help protect sensitive data. Administrators can set user permissions on projects, workbooks, views, and data sources.
Schedule: Navigating the Tableau Server Web Authoring Managing subscriptions Publishing Leveraging the Data Server Embedding Views Web Authoring Managing subscriptions Publishing Leveraging the Data Server Embedding Views
Event Date: 05-10-2019 - Session time: 14:15:00 - Track: Data Visualization/BI/Reporting/Analytics
This session is 100% demos: Shortcuts, visuals interactions, drilling down/up/through data , custom tooltips, bookmarks.
Event Date: 05-10-2019 - Session time: 15:30:00 - Track: Machine Learning / AI
Event Date: 05-10-2019 - Session time: 15:30:00 - Track: Database Administration / Infrastructure
While on-prem high availability and disaster recovery options for SQL Server are well defined, moving those instances to Azure immediately presents some questions and challenges. Can I simply lift and shift my SQL Server Failover Cluster Instance to the cloud? Do I need to upgrade to SQL Server Enterprise Edition and us Always On Availability Groups? What about shared storage and failover clustering? What about disaster recovery, what are my options there? Load Balancers, Fault Domains, Availability Zones, Azure Site Recovery and Region Pairs, what are these things and why do they matter to me?
Cloud Datacenter MVP David Bermingham takes explains all this and more in the session.
Event Date: 05-10-2019 - Session time: 15:30:00 - Track: Database Administration / Infrastructure
In this session, we will explain how to plan for, deploy, and manage Availability Groups from the ground up in easy to understand examples and demos.
We will cover both Basic Availability Groups (BAGs) and full deployments, and also cover their use in Windows and Linux environments as well as look at the new SQL Server 2019 availability group support on containers in a Kubernetes cluster.
If you want to finally get to grips with SQL Server Always On Availability Groups, then this is the session for you!
Event Date: 05-10-2019 - Session time: 15:30:00 - Track: Data Visualization/BI/Reporting/Analytics
Differences between pushing, streaming and PubNub streaming will be explained and we will dive deep into each of the three methods. Join this session so learn how to get live data into your PowerBI service. The session will be covering basic entry to best practices.
Event Date: 05-10-2019 - Session time: 15:30:00 - Track: Application Database Development
What are the use cases?
What are the tradeoffs?
We will lift the veil of confusion that surrounds this blazingly fast feature. By the end of the session, you will understand how In-Memory OLTP works and whether your workload is likely to see an increase in performance.
Event Date: 05-10-2019 - Session time: 15:30:00 - Track: Application Database Development
Many corporations are composed of small divisions located in countries throughout the world. While you might be the lead DBA for your corporation, there are several other employees who have the keys to the kingdom. This presentation will review techniques on how to prevent and/or audit data and schema changes.
Coverage:
1 – Granting correct user access is vital. 2 – DML triggers to keep a DATA audit trail. 3 – DDL triggers to keep a SCHEMA audit trail. 4 – Preventing unwanted DATA modifications. 5 – Preventing unwanted SCHEMA changes. 6 – Preventing table TRUNCATIONS. 7 – LOGIN triggers to control who, what, and when. 8 – Change data capture (CDC) an alternative to triggers. 9 - Which of these techniques apply to an Azure SQL database?
Event Date: 05-10-2019 - Session time: 15:30:00 - Track: Data Visualization/BI/Reporting/Analytics
Event Date: 05-10-2019 - Session time: 15:30:00 - Track: Application Database Development
In this session we will cover the following:
Heaps Clustered vs non clustered indexes How the optimizer determines what indexes to use – Statistics! How to determine good indexes How to implement proper index maintenance / Common strategies
Event Date: 05-10-2019 - Session time: 16:45:00 - Track: Personal / Professional Development
Event Date: 05-10-2019 - Session time: 16:45:00 - Track: Other
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
Event Date: 05-10-2019 - Session time: 16:45:00 - Track: Application Database Development
We will start with exploring hierarchid, geometry and geography data types of SQL Server. We will look at the Temp tables and find a way to cache Temp tables for a better performance. We will cover sparse, rowversion columns and finish the session by showing a way to remove ORM from web applications by using JSON functions of SQL Server.
Event Date: 05-10-2019 - Session time: 16:45:00 - Track: Application Database Development
Event Date: 05-10-2019 - Session time: 16:45:00 - Track: Machine Learning / AI
Event Date: 05-10-2019 - Session time: 16:45:00 - Track: Data Ware House Development / ETL / SSIS
Event Date: 05-10-2019 - Session time: 16:45:00 - Track: Database Administration / Infrastructure
Event Date: 05-10-2019 - Session time: 16:45:00 - Track: Data Visualization/BI/Reporting/Analytics
This is a level 300 presentation which we will look at: 1). The analytical engine behind Power BI (called Vertipaq Engine), 2). An overview of the query architecture of each DAX query, 3). How to optimize the query performance. This presentation is best for audience who has basic understanding Power BI, data modeling, and DAX.
Event Date: 05-10-2019 - Session time: 16:45:00 - Track: Data Visualization/BI/Reporting/Analytics
This session is designed to get you started writing beautiful reports and dashboards as quickly as possible. We will first lay the groundwork explaining how the whole Power BI stack hangs together, for both on-premises and cloud services and tools, and how you can use them to share your reports.
Next, we will focus specifically on how you utilize those reporting tools to create beautiful reports, dashboards, and paginated reports.
By the end of this session, you will be comfortable connecting to remote data sources, creating your data model, and designing and publishing your first Power BI reports and dashboards.
Event Date: 05-10-2019 - Session time: 16:45:00 - Track: Application Database Development
This session will help introduce less commonly used index types and settings along with indexing methodologies. Follow along while we learn which indexes your SQL Server is begging you to make and others it wishes you would drop. Learn use cases for filtered, full-text, and columnstore indexes. There will be plenty of demos and shareable scripts to showcase the benefits too!
Are you using a version and edition of SQL Server is able to use these features? We’ll cover that too and you’ll leave this class with a repeatable indexing methodology you can use to improve your database performance.
Event Date: 05-10-2019 - Session time: 16:45:00 - Track: Database Administration / Infrastructure
In this entry-level session, we'll discuss the advantages and disadvantages of deploying this often misunderstood feature. Is it designed to improve performance, or to ease administration?
Only one way to find out!
Event Date: 05-10-2019 - Session time: 16:45:00 - Track: Application Database Development
Keeping your “desired state” database in version control is the first step toward easy, repeatable deployments. When your database contains exactly what it’s supposed to, there’s no such thing as “but it worked in Dev.” And that’s just the beginning.
Join Larry Blake and Shantan Kallu from Teach for America to learn how they created custom Jenkins pipelines to automate deployments, run unit tests, introduce code review approval steps, manage logins, and more. No Jenkins knowledge is assumed.
Event Date: 05-10-2019 - Session time: 16:45:00 - Track: Personal / Professional Development