| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:00:00 | Peter Kral | Application Database Development | JSON and the Astronauts |
| 09:00:00 | Allen White | Enterprise Database Administration Deployment | Maintain SQL Server Performance Baseline with PowerShell |
| 09:00:00 | Melody Zacharias | Strategy and Architecture | Azure Data Catalog – Turning Unused Assets into Usable Knowledge |
| 09:00:00 | Dan Li | Application Database Development | Introduction to Relational Databases |
| 10:15:00 | Kellyn Pot'Vin-Gorman | Enterprise Database Administration Deployment | Oracle vs. SQL Server Indexing- The Good, the Bad and the Ugly |
| 10:15:00 | Julie Koesmarno | Analytics and Visualization | Boost your Analytics with Machine Learning for SQL Nerds |
| 10:15:00 | Arnie Rowland | Professional Development | Prevent Presentation Paralysis |
| 10:15:00 | josh smith | Enterprise Database Administration Deployment | RPO, RTO SLA: Three Letter Words for When the S H T Hits the F A N |
| 11:30:00 | Clay Jackson | Cloud Infrastructure | Move Your SQLServer Database to "The Cloud" With Almost Zero Downtime |
| 11:30:00 | Rick Lowe | Application Database Development | Why is my DBA So Grumpy ... When I Use NOLOCK and Other Query Hints. |
| 11:30:00 | Michael Wall | Professional Development | Becoming a Master by Giving it All Away |
| 11:30:00 | Elizabeth Hunt | Application Database Development | Creating Dynamic, Reusable, SSIS Packages |
| 13:30:00 | Steve Stedman | Enterprise Database Administration Deployment | Basics of Database Corruption Repair |
| 13:30:00 | Kevin Feasel | Analytics and Visualization | R For the SQL Server Developer |
| 13:30:00 | Melody Zacharias | Professional Development | Confidence: The fuel for action |
| 13:30:00 | Swagatika Sarangi | Strategy and Architecture | Master Data: Theory Reality |
| 14:45:00 | Hamish Watson | Enterprise Database Administration Deployment | DevOPs and the DBA |
| 14:45:00 | Arnie Rowland | Application Database Development | Magical Memory Moments |
| 14:45:00 | Michael Johnson | Analytics and Visualization | Analyzing real-time data using Azure Streaming Analytics |
| 14:45:00 | Jody Roberts | Strategy and Architecture | Data without technology |
| 16:00:00 | Armando Lacerda | Enterprise Database Administration Deployment | Azure SQL DB - Where is SQL Agent? |
| 16:00:00 | Kevin Feasel | Enterprise Database Administration Deployment | Securing SQL Server |
| 16:00:00 | Philip Spokas | Strategy and Architecture | Building a Modern Data Warehouse in Azure for Power BI |
| 16:00:00 | Kyle Stevenson | Analytics and Visualization | Starting From Nothing to a Dashboard and Analysis in an Hour Using PowerBI |
Event Date: 10-03-2018 - Session time: 09:00:00 - Track: Application Database Development
Prerequisites: You should have experience writing queries in T-SQL. No previous knowledge of JSON is needed.
Event Date: 10-03-2018 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 10-03-2018 - Session time: 09:00:00 - Track: Strategy and Architecture
ADC is an indispensable tool that helps companies organize and make sense of the mountains of data they collect every day. By walking participants through an implementation of ADC, I will introduce them to the product, and show how easy it is to use. By presenting concrete examples of how ADC is used, I will demonstrate its importance. Participants should leave this session determined to introduce ADC to their team and resolute in their intention to implement it within their company.
Event Date: 10-03-2018 - Session time: 09:00:00 - Track: Application Database Development
Event Date: 10-03-2018 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment
Takeaways are:
Event Date: 10-03-2018 - Session time: 10:15:00 - Track: Analytics and Visualization
This session will provide a gentle and fun introduction to SQL Server R Services for SQL Nerds. We will walk through pragmatic examples of using R through demos, to illustrate Machine Learning in boosting your Data Analysis capabilities. The goal of this session is to provide quick tips and tricks for attendees to get started on SQL Server R Services, either for fun or for work.
Event Date: 10-03-2018 - Session time: 10:15:00 - Track: Professional Development
Arnie will guide you with techniques to better understand and match the audience's expectations to your presentation goals. You will gain a better understanding of how to prepare your presentation, as well as how to get, and hold the audience's attention. And even how to be more relaxed with the inevitable critique from colleagues. Ramp up your career. Don't miss this session!
Event Date: 10-03-2018 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 10-03-2018 - Session time: 11:30:00 - Track: Cloud Infrastructure
Event Date: 10-03-2018 - Session time: 11:30:00 - Track: Application Database Development
Event Date: 10-03-2018 - Session time: 11:30:00 - Track: Professional Development
The community spirit of PASS is for like-minded professionals to interact and share knowledge. But how do you do this in your own workplace? What happens when Bob takes off with one day of notice? How do you manage when Jane unfortunately has to spend a month in the hospital? All joking aside, the only way to truly become a master at your craft is to share your precious knowledge with your peers and workmates. We will discuss past and current trends in knowledge transfer, the reasons why you should (and shouldn’t) pass on knowledge, and methods for making this happen in your workplace and in your life. Be prepared for an interactive and lively discussion and to walk away with some new concepts that are going to make you think about how you too can become a Master!
Event Date: 10-03-2018 - Session time: 11:30:00 - Track: Application Database Development
Event Date: 10-03-2018 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 10-03-2018 - Session time: 13:30:00 - Track: Analytics and Visualization
Event Date: 10-03-2018 - Session time: 13:30:00 - Track: Professional Development
Event Date: 10-03-2018 - Session time: 13:30:00 - Track: Strategy and Architecture
SQL Server Master Data Services 2016 feature enhancements, tremendously helpful to the users can be grouped into: Business rules enhancements, Domain based attributes usages across Hierarchies, Import T
Event Date: 10-03-2018 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment
In this session I will demystify the concepts of DevOps and we will look at two aspects of DevOps - Continuous Integration Continuous Delivery.
Continuous Integration is the practice in which software developers frequently integrate their work with that of other members of the development team.It also involves automating tests around the integrated work
Continuous Delivery is the next step after Continuous Integration in the deployment pipeline and is the process of automating the deployment of software to test, staging, and production environments.
Database migrations/changes are an area that may not be typically automated or utilise Continuous Delivery.
Through the use of a comprehensive live demo to a running database hosted in Azure the audience will learn the benefits and how to implement Continuous Delivery in their database systems deployment pipeline.
Event Date: 10-03-2018 - Session time: 14:45:00 - Track: Application Database Development
OK, so you’ve been reading about, perhaps even testing out some of the ‘in-memory’ objects now available in SQL Server. Some of the claims are exciting, and some seem overly optimistic. And Yet, you want to know, experience more … Perhaps your situation doesn’t really call out for in-memory tables. But you should consider memory-optimized #Temp tables, memory-optimized table variables, and natively compiled stored procedures.It’s true. Using memory-optimized tables requires a little more fore-thought, a bit more care, even a few configuration tweaks. • But what are the real advantages of memory-optimized objects? • What are the memory-optimized objects you can use? • How can you best use memory-optimized objects? In this demo packed session, we will discuss the pros and cons of using memory-optimized objects in ways that will supercharge your SQL Server.
Event Date: 10-03-2018 - Session time: 14:45:00 - Track: Analytics and Visualization
Event Date: 10-03-2018 - Session time: 14:45:00 - Track: Strategy and Architecture
Event Date: 10-03-2018 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 10-03-2018 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 10-03-2018 - Session time: 16:00:00 - Track: Strategy and Architecture
In this presentation, we’ll Use Azure services to extract, load, and transform transactional data using Azure Data Factory, Azure Functions, Azure SQL, and Azure Analysis Services to create an agile and scalable data warehouse consumable by Power BI.
Event Date: 10-03-2018 - Session time: 16:00:00 - Track: Analytics and Visualization