| Session Date/Time (dd-MM-YYYY 24h) | Speaker | Category | Track | Title |
|---|---|---|---|---|
| 17-09-2015 12:00 | Alex Whittles | 24 Hours of PASS (60 minutes) | BI Platform Architecture, Development & Administration | Beginners Guide to MDX |
| 17-09-2015 13:00 | Melody Zacharias | 24 Hours of PASS (60 minutes) | Application & Database Development | Distributed Replay: Testing with Your Data, Your Way! |
| 17-09-2015 14:00 | Allan Hirt | 24 Hours of PASS (60 minutes) | Enterprise Database Administration & Deployment | What’s New for High Availability in SQL Server 2016 and Windows Server 2016 |
| 17-09-2015 15:00 | Amit Banerjee, Sourabh Agarwal | 24 Hours of PASS (60 minutes) | Enterprise Database Administration & Deployment | How to be a Ninja: Troubleshooting SQL performance on Azure Virtual Machines |
| 17-09-2015 16:00 | Tim Mitchell | 24 Hours of PASS (60 minutes) | BI Platform Architecture, Development & Administration | Building Better SSIS Packages |
| 17-09-2015 17:00 | Pinal Dave | 24 Hours of PASS (60 minutes) | Application & Database Development | 7 Tips to Performance Tuning, Optimization, and Everything |
| 17-09-2015 18:00 | Dmitri Korotkevitch | 24 Hours of PASS (60 minutes) | Enterprise Database Administration & Deployment | SQL Server Internals: The Practical Angle - Sneak Peek |
| 17-09-2015 19:00 | Russ Thomas | 24 Hours of PASS (60 minutes) | Professional Development | Stress Inoculation: Maintaining Performance Under Pressure |
| 17-09-2015 20:00 | Aaron Bertrand | 24 Hours of PASS (60 minutes) | Application & Database Development | 50 Things All SQL Server Developers Need to Know |
| 17-09-2015 21:00 | Chris Bell | 24 Hours of PASS (60 minutes) | Enterprise Database Administration & Deployment | Hacking Exposé Too: Just How Transparent is TDE? |
| 17-09-2015 22:00 | Stacia Varga | 24 Hours of PASS (60 minutes) | BI Information Delivery | Visualizing Data: the Good, the Bad, and the Ugly |
| 17-09-2015 23:00 | Bradley Ball, Josh Luedeman | 24 Hours of PASS (60 minutes) | Application & Database Development | Optimize ALL THE DATA! Preview Edition |
| 18-09-2015 00:00 | Kendra Little | 24 Hours of PASS (60 minutes) | Application & Database Development | Take the SQL Server Index Quiz! |
| 18-09-2015 01:00 | Paul Turley | 24 Hours of PASS (60 minutes) | Enterprise Database Administration & Deployment | Upgrade and Migration Planning BI Features for SQL Server 2014 and 2016 |
| 18-09-2015 02:00 | Mike Hillwig | 24 Hours of PASS (60 minutes) | Professional Development | Leadership Without Borders: Working with Global Teams |
| 18-09-2015 03:00 | Kalen Delaney | 24 Hours of PASS (60 minutes) | Application & Database Development | Highlights From Index Internals: RowStore, ColumnStore, and NoStore! |
| 18-09-2015 04:00 | Pam Shaw | 24 Hours of PASS (60 minutes) | BI Platform Architecture, Development & Administration | Taking the Scare out of Monster Reports |
| 18-09-2015 05:00 | Bill Preachuk | 24 Hours of PASS (60 minutes) | Application & Database Development | Hadoop Essentials for the SQL Server Professional |
| 18-09-2015 06:00 | Joseph D'Antoni | 24 Hours of PASS (60 minutes) | BI Platform Architecture, Development & Administration | Finding Your Balance: BI in the Cloud, On Premises, or Both |
| 18-09-2015 07:00 | Sean McCown | 24 Hours of PASS (60 minutes) | Enterprise Database Administration & Deployment | The Enterprise Scripting Workshop |
| 18-09-2015 08:00 | Margarita Naumova | 24 Hours of PASS (60 minutes) | Application & Database Development | The Top 8 Reasons for Your Transaction Performance Problems |
| 18-09-2015 09:00 | Allan Mitchell | 24 Hours of PASS (60 minutes) | Enterprise Database Administration & Deployment | Building a Scalable Analytical Solution Using IaaS and Elasticsearch |
| 18-09-2015 10:00 | John Welch | 24 Hours of PASS (60 minutes) | BI Platform Architecture, Development & Administration | Advanced Scripting Using SSIS Script Tasks and Components |
| 18-09-2015 11:00 | Edwin M Sarmiento | 24 Hours of PASS (60 minutes) | BI Platform Architecture, Development & Administration | Integrating SQL Server Analysis Services with Hadoop |
Event Date: 17-09-2015 12:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Platform Architecture, Development & Administration
MDX can seem daunting, but when broken down into the basics, it's easier than you think. We'll start at the beginning, so you need no previous MDX experience, but it does help to have some experience with cubes. If you already write MDX but struggle with the syntax, then you need to attend this session!
The session walks through the difference between a member, measure, tuple, set, and dimension. We describe how to decipher a [] from a {} or a (), and we look at some of the awesome power that MDX can provide to your reporting.
Event Date: 17-09-2015 13:00 - Category: 24 Hours of PASS (60 minutes) - Track: Application & Database Development
Event Date: 17-09-2015 14:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 17-09-2015 15:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment
In this session, we will show you what best practices should be known for SQL Server instances running on Azure Virtual Machines! We will talk about tips on automating the implementation of all these best practices during deployment making this a single one-click deployment. This session will be a pre-cursor to our pre-con where we will go the whole nine yards and detail how to automate deployments from scratch, implement best practices automatically and analyze performance issues magically!
Event Date: 17-09-2015 16:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Platform Architecture, Development & Administration
SQL Server Integration Services is deceptively easy to use. With a few hours of instruction or self-study, most data professionals can throw together an SSIS package. However, creating a process that simply runs successfully isn’t the endgame; enterprise-class ETL demands a higher standard. Specifically, well-designed packages will be: • Reliable • Resilient • Reusable • Maintainable • Well performing
There’s nothing magical about building rock-solid SSIS packages, but it does take some discipline, experience, and a library of best practices. That is exactly the aim of this course: to demonstrate a set of proven practices that help frame the development of enterprise-ready SSIS packages.
In this preview of my full-day presentation, we will walk through each of these five facets of well-built packages, discussing and then demonstrating ways of applying these practices to design better SSIS packages. Among the topics for the day: • Checking for problems even when the package executes successfully • Building effective tests for your packages • Error handling and prevention • Being kind to your fellow developers by building clear and easy-to-maintain packages • Leave a trail of evidence: package logging done properly • Avoiding performance bottlenecks: tips for making packages run faster • Using the right tool for the job by integrating non-SSIS tools when appropriate
Event Date: 17-09-2015 17:00 - Category: 24 Hours of PASS (60 minutes) - Track: Application & Database Development
In this session we will go discuss about indexes, bottlenecks and optimization of queries. This session will give you a preview of the pre-con session to be presented at PASS Summit 2015.
Event Date: 17-09-2015 18:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment
“SQL Server Internals: The Practical Angle” pre-con helps to address these issues. It shows how SQL Server components work under the hood and how it affects your systems. It is for database professionals who want to get the most from SQL Server.
In this session, Dmitri provides an overview of the pre-con and gives you a sneak peek of the several topics it covers:
Event Date: 17-09-2015 19:00 - Category: 24 Hours of PASS (60 minutes) - Track: Professional Development
This course presents a variety of simple yet highly actionable techniques borrowed from some of the most stressful fields on earth. In this course, you learn to apply the same methods that doctors, military, law enforcement, and paramedics learn to cope and perform under high-stress situations. Discover how easily these techniques translate to almost any career or endeavor.
Whether you regularly support a multi-million dollar data center on a 24-hour on-call rotation or are asked to restore production while three levels of management look over your shoulder, counting the dollars lost per minute, everyone is susceptible to stress. Some people just have a higher immunity. Attend this inoculation session and get caught up on your boosters.
Event Date: 17-09-2015 20:00 - Category: 24 Hours of PASS (60 minutes) - Track: Application & Database Development
Event Date: 17-09-2015 21:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment
The real question, though, is just how transparent is TDE?
In this second installment of the Hacking Exposé series, we assume the role of a hacker, dig into our database, and steal your backups and data files. Next, we try to restore the files, and even dig into the files themselves and see what might be exposed.
We then go through the steps to lock down your data using TDE. Once again, we assume the role of a hacker and try to dig through the database, steal backups and data files, and see what is available to us.
*Warning: Do not try these demos at work without proper permissions, as some actual hacking techniques are used.
Event Date: 17-09-2015 22:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Information Delivery
Event Date: 17-09-2015 23:00 - Category: 24 Hours of PASS (60 minutes) - Track: Application & Database Development
Your entire IT eco-system is complex. You need to be able to evaluate the maturity of your systems, and understand how to take them to the next level. We will focus on the six pillars of the "data life cycle optimization": Architecture & Configuration, Availability & Continuity, Performance & Optimization, Enterprise BI, Big Data, and Business & Predictive Analytics.
In 60 minutes we will take you on a roller coaster ride of what you should consider, what you should expect, and have a little fun!
Event Date: 18-09-2015 00:00 - Category: 24 Hours of PASS (60 minutes) - Track: Application & Database Development
Event Date: 18-09-2015 01:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 18-09-2015 02:00 - Category: 24 Hours of PASS (60 minutes) - Track: Professional Development
Event Date: 18-09-2015 03:00 - Category: 24 Hours of PASS (60 minutes) - Track: Application & Database Development
Event Date: 18-09-2015 04:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 18-09-2015 05:00 - Category: 24 Hours of PASS (60 minutes) - Track: Application & Database Development
Event Date: 18-09-2015 06:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Platform Architecture, Development & Administration
In this preview of the PASS Summit pre-con, you will learn about: • Building a sample hybrid architecture • How to ensure your data stays secure within the cloud • Thinking about which systems should stay on-premises and which should be cloud candidates • How to configure single sign-on and automatic refresh from your on-premises data sources
You will have a nice preview of what you will learn in October’s pre-con—and what is coming for BI in the near future and how it works with your existing architecture.
Event Date: 18-09-2015 07:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment
This is a preview of the PASS Summit pre-conference session. In the pre-conference workshop, learn how to develop enterprise scripts with a huge range of uses. A good set of reusable scripts can reduce task time from hours or days to just a few minutes, and eliminate mistakes from your environment.• Enterprise philosophy: Tackle simple tasks with the whole environment in mind. • Single data store: Define the benefits and uses of a single central database for common-use data and metadata. • Choice of tools: Choose the best tool (e.g., PowerShell, T-SQL, SSIS) for the job. • Environment ground work: Prepare your environment for enterprise scripting. • Real-world scripts: Work through dozens of enterprise scripting issues (e.g., alerting, error handling, multiple SQL versions) as you develop a real enterprise script in class
This session is for DBAs with a basic understanding of PowerShell. It’s for anyone who touches backups or security, maintains databases, troubleshoots performance, monitors disk space, or any of a hundred other DBA tasks. Enterprise scripting is for anyone who has more tasks than time.
Event Date: 18-09-2015 08:00 - Category: 24 Hours of PASS (60 minutes) - Track: Application & Database Development
Event Date: 18-09-2015 09:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment
My session is going to show you how to take a non Microsoft product (Elasticsearch) and move it into the Microsoft cloud. I will show you how to do this with a repeatable and measurable process.
Elasticsearch is a distributed restful search and analytics application. It is document oriented, schema free, and based on the Lucene search engine. Not content with being a free text search engine, Elasticsearch lets you perform real-time analytics over your data as well. Along with SolR it is at the forefront of text analytics and is used the world over.
Finally I will show you some visualisations in Kibana. Kibana allows you to create time-based comparisons over your data and gives the users power to derive insight from the data.
Remember this session is a teaser. Come to the real session in Seattle to get a much deeper insight.
Event Date: 18-09-2015 10:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 18-09-2015 11:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Platform Architecture, Development & Administration