| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:00:00 | Eugene Meidinger | PreCon (Friday) | Power BI Implementation: A Guide to the Other 90% |
| 09:00:00 | Grant Fritchey | PreCon (Friday) | SQL Server Tools for Query Tuning |
| 09:00:00 | Alex Grinberg | PreCon (Friday) | XML and JSON deep dive |
| 08:30:00 | Kathi Kellenberger | Application Database Development | T-SQL Window Function Performance |
| 08:30:00 | Zhen Zhang | Cloud Application Development Deployment | Deploy AlwaysOn on Google Cloud in Real Life |
| 08:30:00 | Greg Baldini | Technical Vendor Session | Simple Modeling Solutions to Complex Measure Problems |
| 08:40:00 | Ravi Kumar | BI Platform Architecture, Development Administration | Power BI Security |
| 08:40:00 | Ned Bellavance | Enterprise Database Administration Deployment | Deploying SQL Server using Desired State Configuration |
| 08:40:00 | John Miner | Application Database Development | Effective Data Warehouse Storage Patterns |
| 08:40:00 | Beverly Prohaska | Professional Development | Innovation or Extinction: Reimagining the Role of IT |
| 08:50:00 | Sepand Gojgini | Cloud Application Development Deployment | Data Landscape on Azure |
| 08:50:00 | Tim Gorman | Information Delivery | Reducing The Surface Area Of Risk in Data Security |
| 08:50:00 | Rick Wargo | Analytics and Visualization | Healthcare Analytics using Machine Learning Services with Python in SQL Server 2017 |
| 10:00:00 | David Patrick | Analytics and Visualization | Microsoft and Big Data - An Overview of the Power Tools and more! |
| 10:00:00 | Greg Baldini | BI Information Delivery | DAX More Than Measures: An Introduction to DAX as a Query Language |
| 10:00:00 | Alex Grinberg | Advanced Analysis Techniques | XML and JSON, does the DBA need it |
| 10:10:00 | Chris Bell | Strategy and Architecture | Statistics and Cardinality – How they work together |
| 10:10:00 | Greg Moore | Professional Development | So you want to Present: Tips and Tricks of the trade |
| 10:10:00 | Linda Zhang | Cloud Application Development Deployment | Azure SQL Data Warehouse - Migrate on-premises to cloud: How to and Best Practice |
| 10:10:00 | Joe Wehr | Professional Development | Entrepreneurship - Are you ready to make it on your own? |
| 10:20:00 | Tracey Kroll | Analytics and Visualization | SQL Server 2017 and Python… Perfect Together |
| 10:20:00 | Michael Wells | Technical Vendor Session | #GetModern With Dell EMC |
| 11:30:00 | James Serra | Strategy and Architecture | Big data architectures and the data lake |
| 11:30:00 | Jennifer Brocato | Strategy and Architecture | HA/DR Solutions Using Distributed Availability Groups |
| 11:30:00 | Jerod Johnson | Technical Vendor Session | REST Easy - Instant APIs for Your Database |
| 11:40:00 | Ray Kim | Professional Development | I lost my job! Now what?!? A survival guide for the unemployed |
| 11:40:00 | Walter Shields | Professional Development | Remember what it’s like to be a Beginner? |
| 11:40:00 | Ivan Carter | Professional Development | 7 Steps to Starting Your Own Business |
| 11:50:00 | Tracy Boggiano | Enterprise Database Administration Deployment | Collecting Performance Metrics |
| 11:50:00 | Grant Fritchey | Application Database Development | Extending DevOps to SQL Server |
| 11:50:00 | Clay Jackson | Technical Vendor Session | Move Your SQLServer Database to the cloud |
| 14:10:00 | Brian Carrig | Enterprise Database Administration Deployment | Controlling Competing Workloads with SQL Server Resource Governor |
| 14:10:00 | Chris Bell | Enterprise Database Administration Deployment | 5 Minute No Sweat SQL Security Audits |
| 14:10:00 | Kevin Goff | BI Platform Architecture, Development Administration | Implementing Data Warehouse Patterns with the Microsoft Data Plat |
| 14:15:00 | Kathi Kellenberger | BI Platform Architecture, Development Administration | Azure Machine Learning 101 |
| 14:15:00 | Marsha Pierce | Enterprise Database Administration Deployment | Mom Rules for Managing Enterprise Database Environments |
| 14:15:00 | Nick Chobotar | BI Information Delivery | Power Query ETL: Let’s talk about data integration with Power Query |
| 14:15:00 | Sebastian Meine | Professional Development | The Phenomenal IT Consultant - A Blueprint to Getting New Clients, Charging More, and Working Less |
| 14:20:00 | Vince Napoli | BI Information Delivery | Data Governance and Master Data Management |
| 14:20:00 | Michael Traudt | Technical Vendor Session | Protecting SQL Server on Linux! |
| 14:20:00 | Sarah Hutchins | Professional Development | How to Ace Your Job Interview |
| 15:30:00 | Dan Clark | BI Information Delivery | Power Query Deep Dive |
| 15:30:00 | Brian Carrig | Enterprise Database Administration Deployment | Successfully Running SQL Server in AWS |
| 15:30:00 | Ned Otter | Enterprise Database Administration Deployment | Table Partitioning 101 |
| 15:35:00 | Stephen Mokszycki | Enterprise Database Administration Deployment | DevOps Database administration. |
| 15:35:00 | James Serra | Cloud Application Development Deployment | Choosing technologies for a big data solution in the cloud |
| 15:35:00 | Tracy Boggiano | Enterprise Database Administration Deployment | Tips on Managing Lots of SQL Servers |
| 15:35:00 | Taiob Ali | Enterprise Database Administration Deployment | New features in Management Studio and Showplan -- Performance Troubleshooting made easier! |
| 15:40:00 | Zachary Fanelle | BI Information Delivery | Self Service Business Intelligence: Model for High Efficiency |
| 15:40:00 | Bobbi-Jo Brighton, CST, LCI | Professional Development | Women’s Mental Toughness in the Tech Industry |
| 15:40:00 | Louis Diaz-Delgado | Technical Vendor Session | SQL Automation – In the Cloud, On-Premise, and Hybrid |
Event Date: 21-04-2018 - Session time: 09:00:00 - Track: PreCon (Friday)
In the first half of the day, we will focus on data manipulation. Often times, the hardest part of making a report is shaping the data. We will cover applied database theory, data cleansing with PowerQuery and data modelling with DAX. We'll show you what each tool is good at and when to use it. We'll also cover some internals so you understand at a deeper level how these tools really work.
The second half of the day is all about deployment and administration. Do you have a data governance plan in place? We'll show how to access your on-premises data with data gateways. We'll cover options for securing and protecting your data, including row-level security and auditing. Finally, we'll go over the ways you can share and distribute these reports.
Event Date: 21-04-2018 - Session time: 09:00:00 - Track: PreCon (Friday)
Event Date: 21-04-2018 - Session time: 09:00:00 - Track: PreCon (Friday)
and efficiently is one of the top priorities. Within the last decade, SQL Server has evolved into a sophisticated Enterprise RDBMS tool, and it is still growing by providing more functionalities to store and manipulate data reliably. eXtensible Markup Language (XML) is one of the technologies that SQL Server implements not only for data manipulation but also for internal usage, such as Execution Plans, Extended Events, DDL trigger Eventdata() function, and behind-the- scenes construction for SQL Server Business Intelligence Tools (SSIS, SSRS, SSAS). XML skills often appear in SQL Server DBA job requirements because the ability to work with XML allow the DBA to be faster and more efficient when solving different types of problems.
Event Date: 21-04-2018 - Session time: 08:30:00 - Track: Application Database Development
Event Date: 21-04-2018 - Session time: 08:30:00 - Track: Cloud Application Development Deployment
Event Date: 21-04-2018 - Session time: 08:30:00 - Track: Technical Vendor Session
All manner of date calculations and comparisons Slowly changing dimensions Events in progress Conditional evaluation of measures
By the end of this talk, you should have a stronger understanding of the right questions to ask that will make your BI solution simpler for end users and more performant at run-time.
Event Date: 21-04-2018 - Session time: 08:40:00 - Track: BI Platform Architecture, Development Administration
How secure Power BI really is in the cloud? We will go over what architecture Power BI uses to secure the data.
How does user security work Power BI? We will cover "who can see what" from a user point of view.
Event Date: 21-04-2018 - Session time: 08:40:00 - Track: Enterprise Database Administration Deployment
There will be demos! No death by PowerPoint.
Event Date: 21-04-2018 - Session time: 08:40:00 - Track: Application Database Development
Many companies start off with a simple data mart for reporting. As the company grows, users become dependent on the data mart for monitoring and making decisions on Key Performance Indicators (KPI).
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.
Coverage:
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: 21-04-2018 - Session time: 08:40:00 - Track: Professional Development
Event Date: 21-04-2018 - Session time: 08:50:00 - Track: Cloud Application Development Deployment
Event Date: 21-04-2018 - Session time: 08:50:00 - Track: Information Delivery
When done properly, masked data is not noticeable unless you look closely. Masking data well might still be usable for analytic reporting and aggregation, yet utterly useless for revealing confidential data. Masking is important enough that sophisticated software packages have become available.
Come learn about the right way to mask non-production data in order to allow the organization to limit possible exposure only to production. Learn what techniques can be used, why, and what factors should be considered when deciding to secure confidential data.
Event Date: 21-04-2018 - Session time: 08:50:00 - Track: Analytics and Visualization
Event Date: 21-04-2018 - Session time: 10:00:00 - Track: Analytics and Visualization
Event Date: 21-04-2018 - Session time: 10:00:00 - Track: BI Information Delivery
DAX is actually a query language, with rich semantics to represent all manner of analytical queries. Join us for a deep dive into using DAX to its full potential to answer complex queries using Tabular's in-memory model for lightning speed.
Event Date: 21-04-2018 - Session time: 10:00:00 - Track: Advanced Analysis Techniques
Event Date: 21-04-2018 - Session time: 10:10:00 - Track: Strategy and Architecture
Yes, it’s that dreaded phrase you hear all the time when it comes to performance tuning your SQL Server. What does it matter? Why should I care about statistics? Aren’t they automatic or something like that? In this session we will go over why statistics matter, how they are generated, how they impact performance, and even how to maintain them. Once we have that all settled, we will take a quick look at how the cardinality estimator uses statistics to determine a ‘good enough’ plan to use. We will close out the session by taking a look at the performance impact a simple upgrade of your SQL Server to 2014 and the new cardinality estimator can have.
Event Date: 21-04-2018 - Session time: 10:10:00 - Track: Professional Development
This talk will guide you through the process of selecting a topic, preparing for it and actually giving it.
We'll talk about what can go wrong and how to handle that. We'll also talk about what can be done to prevent something from going wrong in the first place.
What are some good guidelines to follow and when can, or even should, you break them.
This will be partly interactive so come with questions and be prepared to be asked some.
Event Date: 21-04-2018 - Session time: 10:10:00 - Track: Cloud Application Development Deployment
We will discuss what is Azure SQL DW and ways to build it and migrate to it. Azure SQL DW is a SQL-based, fully managed, petabyte-scale cloud data warehouse, that is highly elastic and enables you to set up in minutes and scale capacity in seconds.
Event Date: 21-04-2018 - Session time: 10:10:00 - Track: Professional Development
Attend this inspiring session by Prof Joe Wehr of the MCCC and discover the good and the bad of becoming an entrepreneur.
This includes the things everyone needs to know, like
And the less obvious, including
If you have been thinking about “it” but aren't sure if you're ready, you need to attend this session. You might be surprised what you learn about yourself.
Event Date: 21-04-2018 - Session time: 10:20:00 - Track: Analytics and Visualization
This session explores how the basics of Python, how it is integrated within SQL Server, and demonstrates some code in the context of a potential use case.
Event Date: 21-04-2018 - Session time: 10:20:00 - Track: Technical Vendor Session
Event Date: 21-04-2018 - Session time: 11:30:00 - Track: Strategy and Architecture
Event Date: 21-04-2018 - Session time: 11:30:00 - Track: Strategy and Architecture
Event Date: 21-04-2018 - Session time: 11:30:00 - Track: Technical Vendor Session
API-driven data consumption platforms and services highlight the need for RESTful access to SQL server data. The existing options for REST access to SQL Server data or using web development frameworks to convert relational data to JSON objects soak up time, resources, and energy on software development and maintenance that enterprises could be using to drive business.
With the CData API Server, users can rapidly create RESTful APIs for SQL Server data using a point-and-click interface. API Server includes everything needed to create, run, manage, and secure APIs for your SQL Server data. In this talk, we will walk through creating an OData API for SQL Server data and demonstrate connectivity using modern web development frameworks.
Event Date: 21-04-2018 - Session time: 11:40:00 - Track: Professional Development
Unemployment is a scary situation. You're dealing with emotions and uncertainty. You don't know if you'll be out of work for days, weeks, or months.
Fortunately, unemployment is survivable. In this session, I'll share my own experiences (and perhaps we'll talk about some of yours) with unemployment, and how I managed to get through the tough times. We'll discuss emotional impact, the job hunt, and things you can do to get yourself through this tough time. Hopefully, you'll land on your feet once again before long!
Event Date: 21-04-2018 - Session time: 11:40:00 - Track: Professional Development
This is the new crop of beginners I see every day that are attracted to you and what you do as a professional in database technology!
The thing is, as attractive as we are; to someone who wishes to enter this field; the actual steps they must take to become part of this profession can seem daunting.
In this session, I will walk us down memory lane back to the place we all started, as a beginner. I will raise your awareness of just how influential you already are and how you can use that influence to help those starting on their journey to understanding databases and SQL.
Event Date: 21-04-2018 - Session time: 11:40:00 - Track: Professional Development
Event Date: 21-04-2018 - Session time: 11:50:00 - Track: Enterprise Database Administration Deployment
Only if you have baseline performance information can you answer these questions and form a plan to address the issues at hand. In this session, we will be discussing several open source tools you can combine into an inexpensive baselining system you can use to troubleshoot issues and answer important questions.
Attendees in this session will learn how to collect important metric data, what data to collect, and how to interpret that data and develop a plan of action to address any issues.
Event Date: 21-04-2018 - Session time: 11:50:00 - Track: Application Database Development
Event Date: 21-04-2018 - Session time: 11:50:00 - Track: Technical Vendor Session
What’s “The Cloud”? Why Should I Move to The Cloud? When Should I Move to The Cloud? What Should I Move to The Cloud? How Do I Move to The Cloud?
Event Date: 21-04-2018 - Session time: 14:10:00 - Track: Enterprise Database Administration Deployment
Event Date: 21-04-2018 - Session time: 14:10:00 - Track: Enterprise Database Administration Deployment
In this session, you will get scripts that I use for compliance audits that help to collect the information required for many different audits quickly. Even when you have multiple SQL Servers, you can quickly and easily identify where to focus your efforts to ensure you pass security audits. Through demonstration and discussion of what and why certain items get reviewed you will leave with a better understanding of how to be compliant within you SQL Server environment.
Event Date: 21-04-2018 - Session time: 14:10:00 - Track: BI Platform Architecture, Development Administration
Event Date: 21-04-2018 - Session time: 14:15:00 - Track: BI Platform Architecture, Development Administration
Event Date: 21-04-2018 - Session time: 14:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 21-04-2018 - Session time: 14:15:00 - Track: BI Information Delivery
Some key topics include:
Event Date: 21-04-2018 - Session time: 14:15:00 - Track: Professional Development
Now, imagine having potential clients call you instead. Imagine getting enough inquiries to be able to pick and chose (while increasing your prices working less). Discover how in this unique session where Sebastian Meine, Ph.D. will introduce a simple way to attract new clients to your business: The NICER Client Attraction Method™.
Event Date: 21-04-2018 - Session time: 14:20:00 - Track: BI Information Delivery
Event Date: 21-04-2018 - Session time: 14:20:00 - Track: Technical Vendor Session
Event Date: 21-04-2018 - Session time: 14:20:00 - Track: Professional Development
Event Date: 21-04-2018 - Session time: 15:30:00 - Track: BI Information Delivery
Event Date: 21-04-2018 - Session time: 15:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 21-04-2018 - Session time: 15:30:00 - Track: Enterprise Database Administration Deployment
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: 21-04-2018 - Session time: 15:35:00 - Track: Enterprise Database Administration Deployment
There will be a demo!
Event Date: 21-04-2018 - Session time: 15:35:00 - Track: Cloud Application Development Deployment
Event Date: 21-04-2018 - Session time: 15:35:00 - Track: Enterprise Database Administration Deployment
In this talk we will answer these questions and more as we discuss technologies and approaches you can use to make sure your environment is configured and performing at its best.
Event Date: 21-04-2018 - Session time: 15:35:00 - Track: Enterprise Database Administration Deployment
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: 21-04-2018 - Session time: 15:40:00 - Track: BI Information Delivery
In this discussion, Zack Fanelle will be covering the intricacies of why the self-service business model drives high levels of efficiency and productivity. This requires a new approach to collaboration with the business and IT. In addition, he will be covering technical examples of what the model would look like in 2018 and how to take advantage of it using modern products.
Event Date: 21-04-2018 - Session time: 15:40:00 - Track: Professional Development
Mental Toughness coach Bobbi-Jo Brighton, CST, LCI, helps us take a critical and insightful look at challenges that women professionals face in building their tech careers and becoming effective, influential leaders. Bobbi-Jo shares her expertise on empowering women through mental toughness to objectively look at workplace dissatisfaction, as well as the vital importance of strengthening your mindset to shift from frustration, doubt, and confusion within yourself to stay in the game and thrive in your life and tech career. (7 mi
Event Date: 21-04-2018 - Session time: 15:40:00 - Track: Technical Vendor Session
In this working session, we will walk through defining, executing, monitoring, and logging SQL jobs with JAMS. Then, we’ll show you how to leverage one centralized automation solution to manage all your SQL jobs, and combine them into powerful business workflows that span on-premise, cloud, and hybrid instances.