| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 08:30:00 | William E Pearson III | Analysis Techniques and Visualization | Pragmatic Power BI: Working with Data Sources |
| 08:30:00 | Kevin Feasel | BI Platform Architecture, Development Administration | Data Migration Using BIML |
| 08:30:00 | Chris Sommer | Enterprise Database Administration Deployment | SQL Server Automation with PowerShell |
| 08:30:00 | Mike Hays | Professional Development | Tackling Technical Blogging |
| 08:30:00 | Colleen Morrow | Enterprise Database Administration Deployment | Inside the Black Box - Making Sense of Service Broker |
| 09:45:00 | Edward Pollack | Enterprise Database Administration Deployment | Dynamic SQL: Writing Efficient Queries on the Fly |
| 09:45:00 | Kevin Feasel | Application Database Development | Peanut Butter Chocolate: Integrating Hadoop with SQL Server |
| 09:45:00 | Chris Bell | Enterprise Database Administration Deployment | Hacking Expos#233; - Using SSL to Secure SQL Server Connections |
| 09:45:00 | George Walters | Application Database Development | In-Memory tables with SQL Server 2014 and 2016 |
| 09:45:00 | Regis Baccaro | BI Platform Architecture, Development Administration | Advanced BIML - for the advanced ETL developer |
| 11:00:00 | Thomas Grohser | Enterprise Database Administration Deployment | SQL Server Storage Engine under the hood |
| 11:00:00 | Robert Davis | BI Platform Architecture, Development Administration | 10 Things Administrators of BI Systems Should Know |
| 11:00:00 | Jeffry Schwartz | Enterprise Database Administration Deployment | Rx for Demystifying Index Tuning Decisions |
| 11:00:00 | Justin Dearing | Application Database Development | Version control with GIT for the DBA |
| 11:00:00 | Kevin Kline | Application Database Development | Learning and Optimizing the SQL Server Plan Cache |
| 13:30:00 | Thomas Grohser | Enterprise Database Administration Deployment | Designing SQL Server HA/DR Infrastructure to meet the SLA |
| 13:30:00 | William E Pearson III | BI Platform Architecture, Development Administration | Getting Started with MDX |
| 13:30:00 | James Serra | Strategy and Architecture | Should I move my database to the cloud? |
| 13:30:00 | Kevin Kline | Application Database Development | Ten Query Tuning Techniques Every SQL Programmer Should Know |
| 13:30:00 | Regis Baccaro | Application Database Development | Continuous Integration with SSDT and Team Foundation Server |
| 14:45:00 | Ray Kim | Professional Development | Whacha just say? Talking technology to non-technical people |
| 14:45:00 | Robert Davis | Enterprise Database Administration Deployment | New Paradigm for Performance Tuning in SQL Server 2016 |
| 14:45:00 | Derik Hammer | Enterprise Database Administration Deployment | Architecting Availability Groups |
| 14:45:00 | Chris Bell | Enterprise Database Administration Deployment | Statistics Cardinality – How they work to find data efficiently |
| 14:45:00 | George Walters | Application Database Development | Tier 1 Application Migration to Azure! |
| 16:00:00 | Edward Pollack | Enterprise Database Administration Deployment | Diving Into Query Execution Plans |
| 16:00:00 | James Serra | Strategy and Architecture | Relational databases vs Non-relational databases |
| 16:00:00 | Gigi Bell | Professional Development | Dealing With Difficult Coworkers |
| 16:00:00 | Mike Hays | Enterprise Database Administration Deployment | Taming the Transaction Log |
| 16:00:00 | Ray Kim | Strategy and Architecture | Disaster Documents: The role of documentation in disaster recovery |
Event Date: 14-05-2016 - Session time: 08:30:00 - Track: Analysis Techniques and Visualization
In this session, BI Architect, SQL Server MVP and Analysis Services Maestro Bill Pearson focuses upon the first step in working with data sources in Power BI: connecting to, and extracting data from, a diverse range of data sources. Throughout the session, we explore various sources and witness how to employ Power BI with each.
Event Date: 14-05-2016 - Session time: 08:30:00 - Track: BI Platform Architecture, Development Administration
Event Date: 14-05-2016 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment
Initially released in 2006, PowerShell has grown to become Microsoft's premier scripting language on the Windows platform. This presentation will begin with a brief overview of the PowerShell language itself, but the primary focus will be on how to interface with SQL Server to help automate your database environment.
Event Date: 14-05-2016 - Session time: 08:30:00 - Track: Professional Development
Event Date: 14-05-2016 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment
It’s not that complicated once you understand how it all works. Service Broker is an asynchronous messaging technology built into SQL Server that allows you to scale out your application, replicate data or perform ETL, all while guaranteeing messages are delivered and processed in the right order. In this session, we'll discuss the basics of the Service Broker architecture, its components, and deployment options. We will discuss troubleshooting tips and performance best practices to help you deploy a Service Broker solution in your own environment.
Event Date: 14-05-2016 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment
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: 14-05-2016 - Session time: 09:45:00 - Track: Application Database Development
Event Date: 14-05-2016 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment
We will assume the role of a hacker and, by using a simple technique, we will sniff packets on a network to reveal what data is being sent. You may be shocked! We will then secure our database connections with a simple self-signed SSL certificate. Once secured, we will resume the role of the hacker and look inside the packets to see what has changed. *Warning - Do not try these demos at work without proper permissions as actual hacking techniques are used.
Event Date: 14-05-2016 - Session time: 09:45:00 - Track: Application Database Development
Event Date: 14-05-2016 - Session time: 09:45:00 - Track: BI Platform Architecture, Development Administration
Event Date: 14-05-2016 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment
How is SQL Server really accessing the data and log files on the disk? What's done asynchronous and what's synchronous and what impact does that have on our queries and DML statements. Which impact have features like database mirroring and replication, what's different when SQL Server is starting up. #160; Which I/O Subsystems (including SSD) are best for which type of data and what's the impact if you choose a different one. Which files can be placed on the same volume and which should not.
Event Date: 14-05-2016 - Session time: 11:00:00 - Track: BI Platform Architecture, Development Administration
Fortunately, I've been administering BI systems for several years, and I have learned the hard way the difference between administering OLTP and BI systems. This session will cover the top 10 things that I think an administrator of BI systems need to know.
Event Date: 14-05-2016 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 14-05-2016 - Session time: 11:00: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:
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? How do I fork a SVN repo to github?
We will be covering using git from both the command line and Visual Studio.
Event Date: 14-05-2016 - Session time: 11:00:00 - Track: Application Database Development
If you don’t know much about SQL Server memory management, especially if you write T-SQL code, then this session is for you! You’ll learn
Event Date: 14-05-2016 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment
This session will show how to select from the many HA/DR features you have in SQL Server to pick the ones that will help you meet the SLA and most important will tell you how you must combine them to be successful. For each one of the solutions we discuss we will define a series of failure modes and then check if the solution actually can fulfill the SLA as promised or if it needs more
Event Date: 14-05-2016 - Session time: 13:30:00 - Track: BI Platform Architecture, Development Administration
Event Date: 14-05-2016 - Session time: 13:30:00 - Track: Strategy and Architecture
Event Date: 14-05-2016 - Session time: 13:30:00 - Track: Application Database Development
Goal 1: Implement a reusable Transact-SQL test harness for reliable query results. Goal 2: Learn ten patterns that kill the performance of SELECT statements and how to avoid them. Goal 3: Discover the high-impact metadata that shows how a SELECT statement behaves … or misbehaves.
Event Date: 14-05-2016 - Session time: 13:30:00 - Track: Application Database Development
Event Date: 14-05-2016 - Session time: 14:45:00 - Track: Professional Development
Event Date: 14-05-2016 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment
SQL Server 2016 will introduce the Query Store and the Plan Compare Tool which will help you to quickly analyze and troubleshoot problem queries, diagnose the root-cause of query slow-downs, force execution plans and prevent future plan regressions, and track actual execution plan run-time statistics.
Have you ever had a job run unusually slow at 2 AM? If you are using Query Store, diagnosing the problem is as easy as looking at the execution data and plan for the 2 AM execution.
Does a query run fast with one plan but slow with another? With the plan compare tool, you can compare 2 plans in the same window to identify what is the same and what is different.
Event Date: 14-05-2016 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment
Event Date: 14-05-2016 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment
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 from a simple upgrade of your SQL Server to 2014 and using the new cardinality estimator.
Event Date: 14-05-2016 - Session time: 14:45:00 - Track: Application Database Development
Event Date: 14-05-2016 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 14-05-2016 - Session time: 16:00:00 - Track: Strategy and Architecture
Event Date: 14-05-2016 - Session time: 16:00:00 - Track: Professional Development
Event Date: 14-05-2016 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 14-05-2016 - Session time: 16:00:00 - Track: Strategy and Architecture
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.