| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 08:30:00 | Derik Hammer | Database Administration | Architecting Availability Groups |
| 08:30:00 | Sunil Kadimdiwan | Enterprise BI | Learn On-premises BI: SSRS 2016 and Power BI |
| 08:30:00 | John Miner | Database Administration | Public Preview of SQL Server on Linux |
| 08:30:00 | Fabiano Amorim | Optimization/Tuning | Advanced SQL Server execution plans |
| 08:30:00 | Chris Sommer | Database Administration | Painting with PowerShell: SQL Server Administration |
| 08:30:00 | Mike Hillwig | Database Administration | Leaving the Past Behind: Rewriting Your Checklist for SQL 2016 |
| 10:00:00 | George Walters | Database Administration | Organizational Security Compliance with SQL 2012 through 2016 |
| 10:00:00 | Taiob Ali | Database Administration | Think like the Cardinality Estimator |
| 10:00:00 | Bryan Cafferky | Cloud Application Development Deployment | Managing Azure Resources with PowerShell |
| 10:00:00 | Andy Mallon | Database Administration | PS > .\Install-SqlServer.ps1 "Automating your SQL Server Install" |
| 10:00:00 | Greg Moore | Database Administration | Whoa! Backup, what happened? |
| 10:00:00 | Lisa Margerum | Professional/Personal Development | Network your Way to Success! |
| 12:00:00 | David Bermingham | Database Administration | SANLess clustering for physical, virtual and cloud environments |
| 12:30:00 | Kevin Feasel | Big Data | Much Ado About Hadoop |
| 12:30:00 | Azhagappan Arunachalam | Enterprise BI | SQL Server - R Services |
| 12:30:00 | Matt Batalon | Database Development | Dissecting the Data Flow: Exploring SSIS Transformations, Memory and the Pipeline |
| 12:30:00 | Rachel Blum | Enterprise BI | Top 10 Features of a Great Business Intelligence Solution |
| 12:30:00 | Deborah Melkin | Database Development | Back to the Basics: T-SQL 101 |
| 12:30:00 | Fabiano Amorim | Database Administration | Man vs Machine: Adaptive query processing and auto tune on SQL2017 |
| 14:00:00 | Paresh Motiwala | Professional/Personal Development | SQL Server 2016 Migration:A Technical/Project Management Approach |
| 14:00:00 | Justin Dearing | Application Development | Utilizing Docker to create developer instances for SQL Server. |
| 14:00:00 | Thomas Grohser | Database Administration | # vs @ - it's not about Social Media it's about temporary tables and data |
| 14:00:00 | Bryan Cafferky | Big Data | Learn How to do Predictive Modeling with R |
| 14:00:00 | Beth Wolfset | Database Development | Master Your Data using DQS and MDS |
| 14:00:00 | George Walters | Self-Service BI | Power BI: Architecture and demo |
| 15:30:00 | Ray Kim | Professional/Personal Development | Tech Writing for Techies: A Primer |
| 15:30:00 | Steve Simon | Application Development | Surviving parsing XML with T-SQL |
| 15:30:00 | Stephen Mokszycki | Database Administration | Outsourcing database administration to your users. |
| 15:30:00 | Sebastian Meine | Database Development | Introduction to Unit-Testing in SQL Server |
| 15:30:00 | David Bermingham | Cloud Application Development Deployment | SQL Server High Availability in Azure IaaS |
| 15:30:00 | Edward Pollack | Lightning Talks | Lightning Talks |
Event Date: 29-07-2017 - Session time: 08:30:00 - Track: Database Administration
Event Date: 29-07-2017 - Session time: 08:30:00 - Track: Enterprise BI
In this session I will give you a tour of enhancements in SSRS 2016 including KPI, mobile paginated reports. Mobile reports can now be viewed on any device; tablet, smartphone and desktop.
I will also show you the newly introduced Power BI Report Server, that allows you to deploy Power BI Reports on-premises.
Event Date: 29-07-2017 - Session time: 08:30:00 - Track: Database Administration
There was a lot of excitement at the Connect() developer conference in November 2016. Two major announcements were made at the conference.
First, visual studio code now runs on Windows, Linux and Mac. Second, SQL Server v.Next is coming to Linux. This means a developer can
develop code against SQL Server in a Window less environment. If you are really passionate about Linux, join the hundreds downloading and
testing this preview release.
Coverage:
1 - Core code deployed for multiple environments.
2 - Installs on Red Hat and Ubuntu flavors of linux.
3 - Generate ssh key.
4 - Deploy standard Red Hat image.
5 - Install core engine and tools on linux.
6 - Connect to engine via sqlcmd.
7 - Open firewall for external access.
8 - Create database on Linux via SSMS in windows.
9 - Load data into table via bcp.
10 - Supports docker (container) images.
11 - Current limitations.
12 - Future road map.
Event Date: 29-07-2017 - Session time: 08:30:00 - Track: Optimization/Tuning
Event Date: 29-07-2017 - Session time: 08:30:00 - Track: Database Administration
Join me to learn how to paint your own SQL Server canvas with PowerShell.
Event Date: 29-07-2017 - Session time: 08:30:00 - Track: Database Administration
These are questions you addressed long ago in your setup checklist. You've spent a lot of time with that checklist, and you're sure it's perfect. Or is it? When was the last time you visited that checklist? Does it make sense for SQL 2014? What about SQL 2016? Change is hard, and DBAs need to constantly challenge yesterday's best practices to ensure they meet today's business needs.
Join veteran DBA Mike Hillwig and his list of server administration best practices that need to be revisited for modern versions of SQL Server, especially SQL 2016.
Event Date: 29-07-2017 - Session time: 10:00:00 - Track: Database Administration
Event Date: 29-07-2017 - Session time: 10:00:00 - Track: Database Administration
Event Date: 29-07-2017 - Session time: 10:00:00 - Track: Cloud Application Development Deployment
Event Date: 29-07-2017 - Session time: 10:00:00 - Track: Database Administration
My team manages hundreds of SQL Server instances, and performs dozens of installations every year. By automating our SQL Server install, each new server requires just a few minutes of effort before they are ready for use. Even if you only install a few SQL Server instances every year, introducing automation will save you time, and ensure a more consistent configuration.
I will share my automation script, and show you different methods to add automation to your installation routine.
Event Date: 29-07-2017 - Session time: 10:00:00 - Track: Database Administration
Many DBAs still setup their backups via a GUI and “fire and forget” and don’t think about backups and restores until too late. This session will show you while that works in many cases, for larger or more complex databases, or databases with specialized HA requirements, the out of the box solution may be far from optimal.
Event Date: 29-07-2017 - Session time: 10:00:00 - Track: Professional/Personal Development
Whether or not you’ve been in your role for a few months, years, or even decades – or you’re looking for a new job and new opportunities -- strategic networking is the way to make yourself more relevant, more attractive for projects and promotion – or more hirable by potential customers.
Join us for an interactive session to strategize the best actions to increase your social capital and network your way to success!
Event Date: 29-07-2017 - Session time: 12:00:00 - Track: Database Administration
This is the SIOS sponsored lunch time session.
Event Date: 29-07-2017 - Session time: 12:30:00 - Track: Big Data
Event Date: 29-07-2017 - Session time: 12:30:00 - Track: Enterprise BI
Event Date: 29-07-2017 - Session time: 12:30:00 - Track: Database Development
Event Date: 29-07-2017 - Session time: 12:30:00 - Track: Enterprise BI
Event Date: 29-07-2017 - Session time: 12:30:00 - Track: Database Development
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: 29-07-2017 - Session time: 12:30:00 - Track: Database Administration
Event Date: 29-07-2017 - Session time: 14:00:00 - Track: Professional/Personal Development
We will start by discussing the ten Knowledge Areas and five Process Groups in a Project Management Framework. Each of these in turn, has multiple inputs/outputs; and each of them has multiple tools. Then we will learn how all these map to a SQL Server upgrade/migration project.
Most projects fail due to ‘Scope Creep’ , bad Stakeholder Management and poor communication. We will learn how to handle each of these along the way towards a successful completion.
Finally we shall discuss a relatively new concept of a ‘Go Live’ environment that will help you save hundreds of hours of work and help you complete your SQL Server migration project “In Time In Budget”.
Event Date: 29-07-2017 - Session time: 14:00:00 - Track: Application Development
In this session we will go over the basics of docker, as well as the SQL Server For Linux docker image. We will talk about how to use docker and docker-compose to create a development instance of our production server as well as loading test data on it. We will go over the challenges of hosting a database server in a docker container.
Event Date: 29-07-2017 - Session time: 14:00:00 - Track: Database Administration
Event Date: 29-07-2017 - Session time: 14:00:00 - Track: Big Data
Event Date: 29-07-2017 - Session time: 14:00:00 - Track: Database Development
Event Date: 29-07-2017 - Session time: 14:00:00 - Track: Self-Service BI
Event Date: 29-07-2017 - Session time: 15:30:00 - Track: Professional/Personal Development
Event Date: 29-07-2017 - Session time: 15:30:00 - Track: Application Development
In this hands on presentation we shall be looking at varied techniques to materialize our data (from XML format) in an efficient and effective manner. We shall begin by tackling the subject within Management Studio and then progress to SQL Server Integration Services and SQL Server Reporting Services. The presentation is based upon true case scenarios and will show many of the pitfalls or gotcha’s of which to be wary.
Event Date: 29-07-2017 - Session time: 15:30:00 - Track: Database Administration
There will be a demo!
Event Date: 29-07-2017 - Session time: 15:30:00 - Track: Database Development
In this session you’ll learn techniques to write SQL code that is resilient to defects and is easier to change and maintain. We will cover writing simple unit tests and look into more advanced topics such as faking tables and spying procedures. We will also look at how unit testing improves code quality and maintainability.
You will leave this session ready to write unit tests for your own environment to get started on the way to a defect-free and maintainable SQL Server code base.
Event Date: 29-07-2017 - Session time: 15:30:00 - Track: Cloud Application Development Deployment
Azure Resource Manager (ARM) replaces Azure “Classic” as the preferred deployment method in Azure. New features such as Deployment Templates and Resource Groups introduced in ARM make it a powerful tool in managing the entire life-cycle of SQL Server in Azure.
In this session attendees will learn how to leverage ARM to deploy SQL AlwaysOn Availability Groups and Failover Cluster Instances. Template Deployments and manual configurations using the Azure Portal and Azure PowerShell will be demonstrated.
Event Date: 29-07-2017 - Session time: 15:30:00 - Track: Lightning Talks
Derek Hammer: Launch your database into the cloud! In this lightning talk, I will explain bacpacs and demonstrate how they can be used to launch your database into the cloud.
George Walters: Making Something With Power BI in 10 Minutes Do you think Power BI is hard? We will show you how easy it can be to get value out of data in under 10 minutes.
Paresh Motiwala: Fine Tuning Your Execution Plans In this session, we'll discuss how best to shorten your backup times using both native SQL and third party tools.
Sunil Kadimdiwan: Graph data processing - SQL Server 2017 In this brief session I will demonstrate how to utilize graph database capabilities in SQL Server 2017.
Kevin Feasel: Learning Languages The purpose of this light-hearted talk is to think a little bit about ways to sharpen our skills while still leaving at least a trace of free time.