| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 08:30:00 | Eugene Meidinger | Professional Development | Drinking From the Firehose: a Guide to Keeping Up with Technology |
| 08:30:00 | Hasan Savran | Strategy and Architecture | What's new in SQL Server 2017 |
| 08:30:00 | Chris Sommer | Enterprise Database Administration Deployment | Painting with PowerShell: SQL Server Administration |
| 08:30:00 | John Miner | SQL Starter Track | Basic Database Programming |
| 08:30:00 | Hilary Cotter | Enterprise Database Administration Deployment | Replication Technologies |
| 09:40:00 | Paresh Motiwala | Professional Development | Getting to and Nailing Your Interviews |
| 09:40:00 | James Serra | Strategy and Architecture | Should I move my database to the cloud? |
| 09:40:00 | James Livingston | Enterprise Database Administration Deployment | Pester your SQL Servers! |
| 09:40:00 | Deborah Melkin | SQL Starter Track | Back to the Basics: T-SQL 101 |
| 09:40:00 | Tracy Boggiano | Enterprise Database Administration Deployment | Query Store Primer |
| 10:50:00 | Eugene Meidinger | Enterprise Database Administration Deployment | Execution Plans 101 |
| 10:50:00 | Mike Hays | Enterprise Database Administration Deployment | “Go Faster!” And Other Things Yelled at the Backup Jobs |
| 10:50:00 | Chris Seferlis | Business Intelligence | Destination Azure... building ETL workloads in the cloud! |
| 10:50:00 | John Miner | Application Database Development (Cloud On-Premises) | How to audit and prevent unwanted user actions. |
| 10:50:00 | Hilary Cotter | Enterprise Database Administration Deployment | Stress testing SQL Server |
| 13:30:00 | Paresh Motiwala | Strategy and Architecture | Big Data and Hadoop: A primer for the weary DBA |
| 13:30:00 | Ray Kim | Professional Development | I lost my job! Now what?!? A survival guide for the unemployed |
| 13:30:00 | Edward Pollack | Enterprise Database Administration Deployment | Insight into the SQL Server Buffer Cache |
| 13:30:00 | Bert Wagner | Application Database Development (Cloud On-Premises) | SQL Injection Vulnerabilities: Is Your Data Secure? |
| 13:30:00 | Hasan Savran | Strategy and Architecture | How to use Spatial Data in SQL Server |
| 14:40:00 | James Serra | Professional Development | How to build your career |
| 14:40:00 | Taiob Ali | Enterprise Database Administration Deployment | New features in Management Studio and Showplan -- Performance Troubleshooting made easier! |
| 14:40:00 | Chris Sommer | Enterprise Database Administration Deployment | Running SQL Server in Amazon's Relational Database Service (RDS) |
| 14:40:00 | Kimberly StJacques | SQL Starter Track | I have to support what!? SQL, Oracle, and Mongo - A side by side “how to” |
| 14:40:00 | Andy Yun | Enterprise Database Administration Deployment | Uncovering Duplicate, Redundant, Missing Indexes |
| 15:50:00 | Ray Kim | Professional Development | Disaster Documents: The role of documentation in disaster recovery |
| 15:50:00 | Edward Pollack | Application Database Development (Cloud On-Premises) | Dynamic SQL: Writing Efficient Queries on the Fly |
| 15:50:00 | Deborah Melkin | Application Database Development (Cloud On-Premises) | From (User) Story to Tables: Read Between the Lines to Find Your Data |
| 15:50:00 | Bert Wagner | Application Database Development (Cloud On-Premises) | DBAs vs. Developers: JSON in SQL Server |
| 15:50:00 | Andy Yun | Professional Development | Everyone Has a Story to Tell: Developing Your First Presentation |
Event Date: 24-03-2018 - Session time: 08:30:00 - Track: Professional Development
Event Date: 24-03-2018 - Session time: 08:30:00 - Track: Strategy and Architecture
Event Date: 24-03-2018 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment
Join me to learn how to paint your own SQL Server canvas with PowerShell.
Event Date: 24-03-2018 - Session time: 08:30:00 - Track: SQL Starter Track
You just found out that a client needs a SQL database to be designed from scratch. However, you existing DBA has given two week notice.
This presentation is meant for the Accidental DBA that has little to no experience with creating Transaction SQL objects.
After this presentation, will be ready to meet that clients need.
Coverage:
1 - How is a view better than ad-hoc SQL? 2 - Abstracting underlying tables via a view. 3 - Avoiding DML updates to views. 4 - Using triggers to enforce business rules. 5 - Using triggers to prevent data modifications. 6 - What are the different types of functions? 7 - Simple use of each type. 8 - Using stored procedures as an application interface. 9 - Batch programming using stored procedures. 10 - How to schedule batch jobs.
Event Date: 24-03-2018 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 24-03-2018 - Session time: 09:40:00 - Track: Professional Development
In this session I'll share my and other people's real stories and the techniques about keeping abreast the job market and finding new opportunities.
We'll also talk about normal mistakes that people make when they are cozy in a job. But, what do we do once we get that rare opportunity to interview.
We must take care of :
Keep going at it. Never stop looking!!!
Event Date: 24-03-2018 - Session time: 09:40:00 - Track: Strategy and Architecture
Event Date: 24-03-2018 - Session time: 09:40:00 - Track: Enterprise Database Administration Deployment
This session will explore the PowerShell unit testing module Pester and how it can be applied to the automation code that a DBA creates. We'll cover the basics of Pester, test driven development, how it can be employed by DBAs, and more.
This session will work through some light demos. Familiarity with SQL Server database administration and PowerShell is helpful but not required.
Event Date: 24-03-2018 - Session time: 09:40:00 - Track: SQL Starter Track
This session is designed for the junior DBA or developer who is looking for a better foundation of the basics. The goal is to feel more confident with how to write queries and understand how to build on that knowledge.
Event Date: 24-03-2018 - Session time: 09:40:00 - Track: Enterprise Database Administration Deployment
Event Date: 24-03-2018 - Session time: 10:50:00 - Track: Enterprise Database Administration Deployment
Event Date: 24-03-2018 - Session time: 10:50:00 - Track: Enterprise Database Administration Deployment
Event Date: 24-03-2018 - Session time: 10:50:00 - Track: Business Intelligence
Event Date: 24-03-2018 - Session time: 10:50:00 - Track: Application Database Development (Cloud On-Premises)
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: 24-03-2018 - Session time: 10:50:00 - Track: Enterprise Database Administration Deployment
Event Date: 24-03-2018 - Session time: 13:30:00 - Track: Strategy and Architecture
We'll also discuss various real life examples like detection and spread of Ebola virus, the 2016 elections, the traffic patterns in a third world country; all of this using Big Data. You will also learn how Big Data is produced, processed(with cheap hardware using Hadoop like environments), reported and acted upon by producing meaningful and actionable reports/predictions. Over and above, we'll also take a quick peek at some of the huge and successful installations of Hadoop ecosystems around the world; installations that affect our lives.
Event Date: 24-03-2018 - Session time: 13:30: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: 24-03-2018 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 24-03-2018 - Session time: 13:30:00 - Track: Application Database Development (Cloud On-Premises)
This session will provide an overview of how SQL injection works as well as T-SQL examples and techniques to protect against it. We’ll also take a look at why some commonly used techniques aren’t as secure as many people think.
If you ever write or maintain dynamic SQL queries then this session is for you.
Event Date: 24-03-2018 - Session time: 13:30:00 - Track: Strategy and Architecture
In the first half, learn the spatial data types and common spatial functions in SQL Server, and in the second, use the new JSON functions and In-Memory tables to create/query spatial data in SQL Server. Here's your chance to learn how to handle spatial data in SQL Server using modern ways.
Event Date: 24-03-2018 - Session time: 14:40:00 - Track: 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: 24-03-2018 - Session time: 14:40: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: 24-03-2018 - Session time: 14:40:00 - Track: Enterprise Database Administration Deployment
In this session I will outline a number of the benefits of running your databases in the Amazon cloud. I will also highlight some of the limitations and differences that you'll encounter there. Whether you are a total beginner or a seasoned SQL Server veteran, if you're new to Amazon RDS, then this session is for you.
Event Date: 24-03-2018 - Session time: 14:40:00 - Track: SQL Starter Track
Event Date: 24-03-2018 - Session time: 14:40:00 - Track: Enterprise Database Administration Deployment
Attend this session and learn how SQL Server tracks actual index usage, and how you can make use of that information to improve the state of indexes in your database. We will use this data to identify wasteful, unused, redundant indexes, and explore performance penalties you pay for not addressing these inefficient indexes. Finally, we will dive into the Missing Index DMV and explore the art of evaluating its recommendations to make proper indexing decisions.
Event Date: 24-03-2018 - Session time: 15:50:00 - Track: Professional Development
While other disaster recovery presentations talk about strategies, plans, and techniques, this presentation focuses on the documentation itself. We will discuss the documents we had and how they were used in our recovery. We will also discuss what documents we didn't have, and how they could have made the process better.
Event Date: 24-03-2018 - Session time: 15:50:00 - Track: Application Database Development (Cloud On-Premises)
Explore the many uses for dynamic SQL as well as best practices for writing, testing, debugging, and maintaining it, with the bonus of helping to improve the sanity of your coworkers (and your own) in the process!
Event Date: 24-03-2018 - Session time: 15:50:00 - Track: Application Database Development (Cloud On-Premises)
For example: As a DBA, I want to be able to break down user stories to understand how they translate into our current database design and usage and have an understanding as to how it will affect future needs.
That user story is also the goal for the session. This will present one approach to how we can think about these user stories to find the data that we need to design our databases for. We'll even work through an example together.
This is for DBAs who are involved in any part of designing databases, who want to practice how to come up with database designs, or who just another way to think about how they approach their database development in general.
Event Date: 24-03-2018 - Session time: 15:50:00 - Track: Application Database Development (Cloud On-Premises)
This session will explore the new JSON functionality introduced in SQL Server 2016. We will use T-SQL examples to learn how these functions can be used to parse, create, and modify JSON data. More importantly, we will discuss how to optimize performance when using these functions.
By the end of this session DBAs and developers will know how to efficiently work with JSON in SQL Server 2016 and 2017. It will also usher in an era of peace between DBAs and developers…
… at least until someone brings up the topics of cursors, NOLOCKs, or Entity Framework.
Event Date: 24-03-2018 - Session time: 15:50:00 - Track: Professional Development
Well I say you can and will show you how to get started! In this session, I will teach you how to develop your idea and create session content, and share tips tricks that I have learned along the way.
You will leave armed with a wealth of resources (and hopefully some inspiration) to venture forth and develop your first presentation.