Start Time (24h) | Speaker | Track | Title |
---|---|---|---|
08:30:00 | Brian Hansen | Application Database Development | Remember Back When? Temporal Tables in SQL Server 2016 and 2017 |
08:30:00 | Monica Rathbun | Enterprise Database Administration Deployment | How to Get SQL Server to Run Better on Crappy Hardware. |
08:30:00 | Dave Bland | Enterprise Database Administration Deployment | Statistics - Why are they there and what do I do with them |
08:30:00 | John Morehouse | Cloud Application Development Deployment | Azure Basics for the DBA |
08:30:00 | Rick Lowe | Enterprise Database Administration Deployment | Why should I care about ... the plan cache? |
08:30:00 | Ed Leighton-Dick | Application Database Development | Understanding SQL Server Always Encrypted |
10:00:00 | Kevin Feasel | Application Database Development | APPLY Yourself |
10:00:00 | Sean McCown | Enterprise Database Administration Deployment | Monster Text Manipulation: Regular Expressions for the DBA |
10:00:00 | Brett Powell | BI Information Delivery | Husker Power BI |
10:00:00 | Jennifer McCown | Enterprise Database Administration Deployment | Beginning Admin: The Care and Feeding of SQL Server |
10:00:00 | John Morehouse | Application Database Development | Temporal Tables – The New Hotness in Data Auditing |
10:00:00 | B.D. Softley | Professional Development | SELECT Tidbits FROM My.Experience WHERE NiceToKnow = 1 and date = DATEADD(D,-1,current_timestamp) |
12:45:00 | Marc Beacom | BI Platform Architecture, Development Administration | Implementing a Cloud Analytics Solution: Options, costs and more |
12:45:00 | Chris Lumnah | Enterprise Database Administration Deployment | Taking the pain out of database migrations |
12:45:00 | David Klee | Enterprise Database Administration Deployment | Zen and the Art of Baselines |
12:45:00 | Bill Fellows | Application Database Development | What's new for Developers - SQL Server 2014-2017 |
12:45:00 | Ed Leighton-Dick | Enterprise Database Administration Deployment | How to Keep Your Databases Secure in Just Minutes a Day |
12:45:00 | Brett Powell | BI Platform Architecture, Development Administration | Processing Analysis Services Tabular Models |
14:15:00 | Tim Gorman | Enterprise Database Administration Deployment | Reducing The Surface Area Of Risk in Data Security |
14:15:00 | Kevin Feasel | Application Database Development | Using Kafka for Real-Time Data Ingestion with .NET |
14:15:00 | Sean McCown | Enterprise Database Administration Deployment | Loading SQL Server Data with Powershell |
14:15:00 | Brian Hansen | Enterprise Database Administration Deployment | Let's Explore SQL Internals |
14:15:00 | Monica Rathbun | Professional Development | I'm It - Survival Techniques for the Lone DBA |
14:15:00 | Phillip Labry | Cloud Application Development Deployment | Analysis Services is in Azure? Seriously!? Let's build a model! |
15:45:00 | Ryan Casey | BI Platform Architecture, Development Administration | Shiny, SSAS Tabular Model Developed from a Star Schema |
15:45:00 | Andy Galbraith | Enterprise Database Administration Deployment | Getting Started with Extended Events |
15:45:00 | David Klee | Enterprise Database Administration Deployment | Level Up Your Cloud Skills |
15:45:00 | Jennifer McCown | Application Database Development | T-SQL's Hidden Support Feature |
15:45:00 | Rick Lowe | Cloud Application Development Deployment | SQL Server on Amazon Web Services - Elastic Compute Cloud vs Relational Database Service? |
15:45:00 | Wm Bruce Wray | Security | Data Breach 101 - Legal and IT Responses |
Event Date: 27-10-2018 - Session time: 08:30:00 - Track: Application Database Development
Event Date: 27-10-2018 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 27-10-2018 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 27-10-2018 - Session time: 08:30:00 - Track: Cloud Application Development Deployment
Event Date: 27-10-2018 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment
Perfect for those who are relatively new to performance tuning concerns, or advanced DBAs trying to figure out how to have a similar conversation with their less experienced peers, or developers who are curious as to why their DBAs often seem so frazzled. This is not a deep dive into the cache, it really is primarily a session exploring why these DMOs are worth slogging through.
Event Date: 27-10-2018 - Session time: 08:30:00 - Track: Application Database Development
Event Date: 27-10-2018 - Session time: 10:00:00 - Track: Application Database Development
Event Date: 27-10-2018 - Session time: 10:00:00 - Track: Enterprise Database Administration Deployment
Here you’ll learn: • The most useful regular expression commands. • The appropriate times to use regular expressions. • How to use regular expressions to write code for you. • How to incorporate regular expressions into large tasks and combine them with other methods.
Event Date: 27-10-2018 - Session time: 10:00:00 - Track: BI Information Delivery
Event Date: 27-10-2018 - Session time: 10:00:00 - Track: Enterprise Database Administration Deployment
Being a database administrator is a big job, but we can cover the basics in one session!
Event Date: 27-10-2018 - Session time: 10:00:00 - Track: Application Database Development
Event Date: 27-10-2018 - Session time: 10:00:00 - Track: Professional Development
Event Date: 27-10-2018 - Session time: 12:45:00 - Track: BI Platform Architecture, Development Administration
Event Date: 27-10-2018 - Session time: 12:45:00 - Track: Enterprise Database Administration Deployment
This session will discuss what you need to take into account to ensure a successful pain free database migration. These steps can be used for a single database, multiple databases, or an entire server. By the end of the session, you will have a checklist of the items you need to consider for a database migration.
Event Date: 27-10-2018 - Session time: 12:45:00 - Track: Enterprise Database Administration Deployment
Event Date: 27-10-2018 - Session time: 12:45:00 - Track: Application Database Development
Topics covered will include JSON, string splitting and aggregation, data masking, row level security, graph processing, and too many "minor" features to mention.
Event Date: 27-10-2018 - Session time: 12:45:00 - Track: Enterprise Database Administration Deployment
Things like that happen on a daily basis, poking holes in even the most well-secured database. Those holes are just waiting for someone to find them. That someone could be you, or it could be an attacker probing for a way to get data from your company.
In this session, we will explore how to create reports that are quick to review so you can find the holes before someone else does - without interfering with the rest of your day. Along the way, you'll also learn where to find security-related information in SQL Server's metadata and logs to allow you to customize and extend the reports to meet your company's unique needs.
Event Date: 27-10-2018 - Session time: 12:45:00 - Track: BI Platform Architecture, Development Administration
Event Date: 27-10-2018 - Session time: 14:15:00 - Track: Enterprise Database Administration Deployment
Data masking for data at-rest removes the value from the asset. This reduces your organizations "surface area of risk" overall, permitting your organization to prioritize security efforts where they are absolutely needed. There are other possible solutions, such as synthesizing data and redaction, which present other challenges.
Come learn about the right way to secure non-production data to limit 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: 27-10-2018 - Session time: 14:15:00 - Track: Application Database Development
Event Date: 27-10-2018 - Session time: 14:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 27-10-2018 - Session time: 14:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 27-10-2018 - Session time: 14:15:00 - Track: Professional Development
Event Date: 27-10-2018 - Session time: 14:15:00 - Track: Cloud Application Development Deployment
This demo heavy session will be focused on setting up Azure Analysis Services, deploying a model, loading the model with data and finally reporting from your Azure Analysis Services instance.
Event Date: 27-10-2018 - Session time: 15:45:00 - Track: BI Platform Architecture, Development Administration
“Live” Demos using Power Pivot and Power BI • Integrated workspace / server workspace • Data connections (impersonation) • Import tables into the tabular model • Date Dimension for Time Intelligence • Relationships between facts and dimensions • DAX to create measures and calculated tables • Ragged Hierarchies • Detail Rows Expression Property for Measures • Project deployment and processing • Best practices and what to avoid • Dimensions, facts, and reference tables (parameters) • Bridge table and M:M relationships • Bi-directional filtering versus cross-filtering • DAX Expanded Tables • Filter context and DAX
Event Date: 27-10-2018 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment
Extended Events started out in SQL Server 2008 with no user interface and only a few voices in the community documenting the features as they found them. Since then it has blossomed into a full feature of SQL Server and an amazingly low-impact replacement for Profiler and Trace.
Come learn how to get started - the basics of sessions, events, actions, targets, packages, and more. We will look at some base scenarios where Extended Events can be very useful as well as considering a few gotchas along the way. You may never go back to Profiler again!
Event Date: 27-10-2018 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment
Event Date: 27-10-2018 - Session time: 15:45:00 - Track: Application Database Development
In this session, Microsoft Certified Master Jennifer McCown will demonstrate the various commenting methods that make code supportable. Attendees will#160;learn what’s important in a header comment, use code blocking to edit code, build a comprehensive help system, and explore alternative comment methods in stored procedures, SSIS packages, SSRS reports, and beyond. These methods help prevent errors and reduce troubleshooting.
Event Date: 27-10-2018 - Session time: 15:45:00 - Track: Cloud Application Development Deployment
Event Date: 27-10-2018 - Session time: 15:45:00 - Track: Security