| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:15:00 | Jeff Prom | Strategy and Architecture | SQL Injections and How to Stop Them |
| 09:15:00 | Peter Kral | Application Database Development | JSON and the Astronauts |
| 09:15:00 | Mindy Curnutt | Application Database Development | The Ins and Outs of SQL Indexes |
| 09:15:00 | Sean Forgatch | BI Platform Architecture, Development Administration | Processing Big Data with Azure Data Lake Analytics |
| 09:15:00 | Rick Lowe | Enterprise Database Administration Deployment | Why should I care about ... the plan cache? |
| 09:15:00 | Denny Cherry | Enterprise Database Administration Deployment | How to Maintain the Same Level of Utilities in Cloud Deployments - Securability, Reliability and Sca |
| 09:15:00 | Kim Schmidt | Cloud Application Development Deployment | Cloud 9 on AWS |
| 09:15:00 | Sitotpal Sarkar | Enterprise Database Administration Deployment | AlwaysOn from the Front Lines |
| 10:30:00 | Kellyn Pot'Vin-Gorman | Enterprise Database Administration Deployment | The Next Frontier- Opportunities When Migrating to the Cloud with Virtualization |
| 10:30:00 | Peter Kral | Enterprise Database Administration Deployment | SSIS Project Deployment: The T-SQL Way |
| 10:30:00 | Jason Brimhall | Enterprise Database Administration Deployment | A Masters Passport to Extended Events |
| 10:30:00 | Mindy Curnutt | Application Database Development | Fun with SQL Server Spatial Data |
| 10:30:00 | Paul Stanton | Enterprise Database Administration Deployment | SQL Server Containers and Clones |
| 10:30:00 | Paul Ou Yang | Enterprise Database Administration Deployment | Tuning SQL Server Transactional Replication |
| 10:30:00 | Kerry Tyler | BI Platform Architecture, Development Administration | 45 Minutes to Your First SSAS Tabular Model |
| 10:30:00 | Randy Knight | Application Database Development | But it worked great in Dev! Perfomance for Devs |
| 12:15:00 | Kim Schmidt | Cloud Application Development Deployment | Self-driving Solutions on AWS |
| 13:30:00 | Andrew Nakamura | Enterprise Database Administration Deployment | From Zero to Hero: The New Powershell DBA |
| 13:30:00 | Lori Edwards | Professional Development | Do More Than Just Talk |
| 13:30:00 | Stephen Mokszycki | Enterprise Database Administration Deployment | Outsourcing database administration to your users. |
| 13:30:00 | Jason Brimhall | Enterprise Database Administration Deployment | Bare Naked Skinny on SQL Server |
| 13:30:00 | Benjamin Nevarez | Application Database Development | Dive into the Query Optimizer - Undocumented Insight |
| 13:30:00 | Rick Lowe | Application Database Development | Weird stuff I saw ... while supporting a Java team |
| 13:30:00 | Kerry Tyler | Application Database Development | Managing Your Schema with Database Projects in Visual Studio |
| 13:30:00 | Jonathan Kehayias | Enterprise Database Administration Deployment | Diagnosing SQL Amnesia: Where is Your Memory Going? |
| 14:45:00 | Lori Edwards | Enterprise Database Administration Deployment | DBA 101 – Let’s Get It Started |
| 14:45:00 | Kevin Kline | Enterprise Database Administration Deployment | End-to-End Troubleshooting Checklist for SQL Server |
| 14:45:00 | Prakash Heda | Enterprise Database Administration Deployment | SQL server on containers – Part 1 |
| 14:45:00 | Benjamin Nevarez | Application Database Development | Understanding Parameter Sniffing |
| 14:45:00 | Steve Rezhener | BI Platform Architecture, Development Administration | More than introduction to SQL Server Reporting Services aka SSRS |
| 14:45:00 | Mickey Stuewe | Application Database Development | Changing Your Habits to Improve the Performance of Your T-SQL |
| 14:45:00 | Randy Knight | Enterprise Database Administration Deployment | Understanding the SQL Server Transaction Log |
| 14:45:00 | Peixin Wang | Professional Development | SQL Server 2016 and R Service introduction |
| 14:45:00 | Phil Helmer | Application Database Development | Building Your Way to Better Database Testing |
| 16:00:00 | Sergio Pacheco | Enterprise Database Administration Deployment | SQL Server in Azure, One Year In |
| 16:00:00 | Kevin Kline | Professional Development | How to be the Most Important IT Person in the Room: Why Data Experts Own the Future |
| 16:00:00 | Prakash Heda | Enterprise Database Administration Deployment | SQL server on containers – Part 2 |
| 16:00:00 | Vazi Okhandiar | Analytics and Visualization | Building a Dashboard in an Hour using Power BI |
| 16:00:00 | Steve Rezhener | BI Platform Architecture, Development Administration | New features of SSIS 2016 |
| 16:00:00 | Ted Stathakis | BI Platform Architecture, Development Administration | Better Report Management and Development Techniques |
| 16:00:00 | Ben Aminnia | Application Database Development | How I Met Your SQL Server |
| 16:00:00 | Thomas Hull | Application Database Development | Concurrency in SQL Server - a.k.a. What to do when your database has more than 1 user |
Event Date: 23-09-2017 - Session time: 09:15:00 - Track: Strategy and Architecture
During the demo, we will take on a couple of different roles. As a hacker, we will walk through steps a hacker might take to compromise a web application in order to retrieve sensitive data such as credit card information, usernames, passwords, and social security numbers. Assuming the role of a developer, we will then show various prevention techniques and their effectiveness in preventing SQL injections.
Attend this session to learn how SQL injections work, identify if you are being attacked, and how to stop them!
Event Date: 23-09-2017 - Session time: 09:15:00 - Track: Application Database Development
Prerequisites: You should have experience writing queries in T-SQL. No previous knowledge of JSON is needed.
Event Date: 23-09-2017 - Session time: 09:15:00 - Track: Application Database Development
Event Date: 23-09-2017 - Session time: 09:15:00 - Track: BI Platform Architecture, Development Administration
Event Date: 23-09-2017 - Session time: 09:15: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 drink in the morning (allegedly). 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: 23-09-2017 - Session time: 09:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 23-09-2017 - Session time: 09:15:00 - Track: Cloud Application Development Deployment
Would you like to:
Event Date: 23-09-2017 - Session time: 09:15:00 - Track: Enterprise Database Administration Deployment
Beginners as well as experts will learn from my experience with AlwaysOn. Don't just keep pushing that NEXT button until you come and join my session.
Event Date: 23-09-2017 - Session time: 10:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 23-09-2017 - Session time: 10:30:00 - Track: Enterprise Database Administration Deployment
Prerequisites: You should have previous experience with SQL Server Integration Services (SSIS) package deployment and/or development.
Event Date: 23-09-2017 - Session time: 10:30:00 - Track: Enterprise Database Administration Deployment
It is time to let those old tools retire gracefully and move into the world of XE. This full day workshop will provide you the means to let Profiler and Trace be retired from your toolset as you discover all that XE has to offer.
This full day session on Extended Events will help prepare you to put this tool to immediate use as you walk back to your daily duties. This workshop will teach you about Extended Events starting with the basics and moving through how to create XE sessions that will get the right data for you, while doing so with minimal impact.
You will be exposed to advanced troubleshooting techniques as we work through complex issues that are made easier through the use of XE. Take advantage
Event Date: 23-09-2017 - Session time: 10:30:00 - Track: Application Database Development
Event Date: 23-09-2017 - Session time: 10:30:00 - Track: Enterprise Database Administration Deployment
Microsoft is emphasizing the use of containers for development and test on SQL Server 2017, and new solutions from Red Gate and Windocks add support for containers and SQL Server database database cloning, for the full range of the SQL Server family. We’ll explore use of Docker based tooling for delivery of container environments, and their pros and cons. We’ll also look at SQL Server cloning, and how clones enable Dev and Test teams to work on large database environments for containers as well as existing SQL Server instances.
Event Date: 23-09-2017 - Session time: 10:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 23-09-2017 - Session time: 10:30:00 - Track: BI Platform Architecture, Development Administration
SSAS Tabular is a new-ish form of business intelligence model released with SQL Server 2012, intended as an alternative to more traditional Multidimensional cubes. In this session, we will talk briefly about what Tabular is and what it does, in addition to the various options for deployment, before exploring the development process of creating a tabular model ready for ad-hoc querying through Excel or Power BI.
Event Date: 23-09-2017 - Session time: 10:30:00 - Track: Application Database Development
Event Date: 23-09-2017 - Session time: 12:15:00 - Track: Cloud Application Development Deployment
AWS Marketplace Solution demos: Botmetric is an intelligent cloud management solution for AWS to simplify the work of engineers, offering cost management/cloud governance, security/compliance, ops/cloud automation solutions to make cloud management E-A-S-Y! Zoomdata, a Visionary in Gartner Magic Quadrant for Business Intelligence and Analytics Platforms, delivers the fastest visual analytics for big data from any source, on premise in the cloud - without moving the data! Their micro-query architecture delivers results on billions of records in seconds, accelerating time-to-insight. Seeing is believing!
Event Date: 23-09-2017 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment
In this session, you'll learn about the Powershell community that is creating awesome solutions to ease your life as a DBA. This session is aimed at DBAs from zero to heroes who want to see the new Powershell DBA in action. Come see brand new techniques and demos and become the hero that others will envy.
Come and join me for a momentous session of PowerShell and SQL, full of demos and useful solutions that you will be able to take back to your workplace. This will improve your knowledge and skills, show you how the modern DBA will work and future proof your career by becoming a new Powershell DBA.
Event Date: 23-09-2017 - Session time: 13:30:00 - Track: Professional Development
Event Date: 23-09-2017 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment
There will be a demo!
Event Date: 23-09-2017 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment
Join this NSFW (not safe for whining) session as we strip SQL down to the bare bones. I will help you undress the complexities of a few of the basic SQL Server concepts. These concepts will include locks, principals, query directives and deadlocks.
In this session I will disrobe misunderstandings related to the aforementioned topics. I will show the different types of principals in SQL Server. I will also show various scenarios involving locks and deadlocks along with some of their effects with and without query directives. The goal is to better understand these topics and to hopefully stop using and perpetuating common mis-uses of terminology and common misconceptions about the technology.
Event Date: 23-09-2017 - Session time: 13:30:00 - Track: Application Database Development
Event Date: 23-09-2017 - Session time: 13:30:00 - Track: Application Database Development
Event Date: 23-09-2017 - Session time: 13:30:00 - Track: Application Database Development
Event Date: 23-09-2017 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment
physical deficiencies, and interestingly enough the same holds true for SQL Server! In this preconference seminar you'll learn about common patterns and problems that affect SQL Server memory usage and how to solve them, based on real world scenarios. From incorrectly-sized hardware for a specific workload to code and schema design challenges that tax SQL Servers memory usage, this seminar will give you the practical tools necessary to tackle even the most challenging memory problems.
Event Date: 23-09-2017 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment
Event Date: 23-09-2017 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment
In this session, attendees will see demonstrations of the tools and techniques which make difficult troubleshooting scenarios much faster and easier, including:
• XEvents, Profiler/Traces, and PerfMon • Using Dynamic Management Views (DMVs) • Advanced Diagnostics Using Wait Stats • Reading SQL Server execution plan
Every DBA needs to know how to keep their SQL Server in tip-top condition, and you’ll need skills the covered in this session to do it.
Event Date: 23-09-2017 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment
SQL server 2017 with complete support for creating containers using Dockers, a defacto industry standard API for container packaging is to allow running SQL Server as micro-services. Docker has industry-wide support with hosted services on Azure/AWS, monitoring, logging, orchestration. No matter you want to deploy SQL server on Linux or windows containers are the way…
This introductory session will help seasoned SQL Server DBA/Developers understand the basics of containers and windows 16 NANO servers running SQL Server 2016 17. in subsequent session Prakash will cover several demos and share scripts to start with containers
Event Date: 23-09-2017 - Session time: 14:45:00 - Track: Application Database Development
Event Date: 23-09-2017 - Session time: 14:45:00 - Track: BI Platform Architecture, Development Administration
Event Date: 23-09-2017 - Session time: 14:45:00 - Track: Application Database Development
Event Date: 23-09-2017 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment
Event Date: 23-09-2017 - Session time: 14:45:00 - Track: Professional Development
One of the biggest changes in SQL Server 2016 on the analytics front is the inclusion of R into the database engine. SQL Server R Services is the result of Microsoft’s acquisition of Revolution Analytics. R is a popular open-source data analysis language that’s used by data scientists, statisticians and data analysts for data analysis, data exploration and predictive modeling. R can produce both data analytic results and data visualizations. However, in the past, the use of R in an enterprise environment involved several challenges. By marrying R with its core data platform, Microsoft is signaling that it is serious about advancing its analytic offerings not only in the cloud, but on-premise as well. This presentation will tell why it’s important for SQL developer to know R and vice versa.
Event Date: 23-09-2017 - Session time: 14:45:00 - Track: Application Database Development
Event Date: 23-09-2017 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 23-09-2017 - Session time: 16:00:00 - Track: Professional Development
Event Date: 23-09-2017 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment
Those of you remember physical server consolidation phase started with VM, and struggle to run SQL server on VM with predictable performance…. Since than this is biggest change in the way SQL will be installed. Windows 16 introduced containers support, headless NANO servers and SQL server 2017 with complete support for creating containers using Dockers, a defacto industry standard API for container packaging is to allow running SQL Server as micro-services. No matter you want to deploy SQL server on Linux or windows containers are the way…
Will show you how can you install 5 SQL server implementations in 5 minute with each dedicated SQL implementation taking 15 GB of space. Will show you how containerization solves the “dependency hell” problem by incorporating software dependencies into a container image and provide smooth application deployment…
This session is designed for seasoned SQL Server DBA Developers
Event Date: 23-09-2017 - Session time: 16:00:00 - Track: Analytics and Visualization
Event Date: 23-09-2017 - Session time: 16:00:00 - Track: BI Platform Architecture, Development Administration
Event Date: 23-09-2017 - Session time: 16:00:00 - Track: BI Platform Architecture, Development Administration
See how to make your reports pop with polish while shortening your development time and easing your maintenance efforts. An exploration of Shared Data Sets will show how to reduce data discrepancies and improve performance. Learn how to leverage the power of Linked Reports to reduce the number of reports needed and to streamline report publication. The session will conclude with a look at how you can have a custom report footer, which you can use on any version of Reporting Services, that shows report utilization, performance details, stored procedures and data sets used in the report. Leave excited about how great your Reporting Services implementation can be.
Event Date: 23-09-2017 - Session time: 16:00:00 - Track: Application Database Development
Significant additions and new features in some of the new versions; Which new versions were adopted more rapidly? Why not all new versions?! Have you always upgraded to every new version of SQL Server?
Event Date: 23-09-2017 - Session time: 16:00:00 - Track: Application Database Development