| Session Date/Time (dd-MM-YYYY 24h) | Speaker | Category | Track | Title |
|---|---|---|---|---|
| 09-09-2014 12:00 | Brent Ozar | 24 Hours of PASS (60 minutes) | Enterprise Database Administration & Deployment | Developers: Who Needs a DBA? |
| 09-09-2014 13:00 | Brian Knight | 24 Hours of PASS (60 minutes) | BI Platform Architecture, Development & Administration | Performance Tuning SQL Server Integration Services (SSIS) |
| 09-09-2014 14:00 | Allan Hirt | 24 Hours of PASS (60 minutes) | Enterprise Database Administration & Deployment | Availability Groups vs. Failover Cluster Instances: What’s the Difference? |
| 09-09-2014 15:00 | Kalen Delaney | 24 Hours of PASS (60 minutes) | Enterprise Database Administration & Deployment | In-Memory OLTP Internals: How is a 30x Performance Boost Possible? |
| 09-09-2014 16:00 | Marco Russo | 24 Hours of PASS (60 minutes) | BI Platform Architecture, Development & Administration | Create your first SSAS Tabular Model |
| 09-09-2014 17:00 | Jonathan Kehayias, Erin Stellato | 24 Hours of PASS (60 minutes) | Enterprise Database Administration & Deployment | Everything You Never Wanted to Know about Extended Events |
| 09-09-2014 18:00 | Hope Foley | 24 Hours of PASS (60 minutes) | Application & Database Development | Spatial Data: Looking Outside the Map |
| 09-09-2014 19:00 | Gail Shaw | 24 Hours of PASS (60 minutes) | Enterprise Database Administration & Deployment | Guessing Games: Statistics, Heuristics, and Row Estimations |
| 09-09-2014 20:00 | Tim Chapman, Denzil Ribeiro | 24 Hours of PASS (60 minutes) | BI Information Delivery | Troubleshoot Customer Performance Problems Like a Microsoft Engineer |
| 09-09-2014 21:00 | Argenis Fernandez | 24 Hours of PASS (60 minutes) | Enterprise Database Administration & Deployment | Secure Your SQL Server Instance without Changing Any Code |
| 09-09-2014 22:00 | Joe Webb | 24 Hours of PASS (60 minutes) | Professional Development | Hiring the Right People: Interviewing and Selecting the Right Team |
| 09-09-2014 23:00 | Chris Shaw, John Morehouse | 24 Hours of PASS (60 minutes) | Application & Database Development | Real World SQL 2014 Migration Path Decisions |
| 10-09-2014 00:00 | Robert Cain, Bradley Ball, Jason Strate | 24 Hours of PASS (60 minutes) | Application & Database Development | Zero to Hero with PowerShell and SQL Server |
| 10-09-2014 01:00 | Peter Myers | 24 Hours of PASS (60 minutes) | BI Information Delivery | Past to Future: Self-service Forecasting with Microsoft BI |
| 10-09-2014 02:00 | Grant Fritchey | 24 Hours of PASS (60 minutes) | Application & Database Development | Query Performance Tuning in SQL Server 2014 |
| 10-09-2014 03:00 | Jes Schultz | 24 Hours of PASS (60 minutes) | Application & Database Development | Are Your Indexes Hurting You or Helping You? |
| 10-09-2014 04:00 | Kevin Kline | 24 Hours of PASS (60 minutes) | Professional Development | Irreplaceable: Techniques to Fireproof Your IT Career |
| 10-09-2014 05:00 | Carlos Bossy | 24 Hours of PASS (60 minutes) | BI Platform Architecture, Development & Administration | Predictive Analytics in the Enterprise |
| 10-09-2014 06:00 | Allen White | 24 Hours of PASS (60 minutes) | Enterprise Database Administration & Deployment | Manage Both On-Prem and Azure Databases with PowerShell |
| 10-09-2014 07:00 | Julie Koesmarno | 24 Hours of PASS (60 minutes) | BI Information Delivery | "I Want It NOW!" Data Visualization with Power View |
| 10-09-2014 08:00 | Davide Mauri | 24 Hours of PASS (60 minutes) | BI Platform Architecture, Development & Administration | Agile Data Warehousing: Start to Finish |
| 10-09-2014 09:00 | Alberto Ferrari | 24 Hours of PASS (60 minutes) | BI Platform Architecture, Development & Administration | DAX Formulas in Action |
| 10-09-2014 10:00 | Jen Stirrup | 24 Hours of PASS (60 minutes) | BI Information Delivery | Business Intelligence Toolkit Overview: Microsoft Power BI and R |
| 10-09-2014 11:00 | Ryan Adams | 24 Hours of PASS (60 minutes) | Enterprise Database Administration & Deployment | SQL Server AlwaysOn Quickstart |
Event Date: 09-09-2014 12:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment
In just one hour, you'll learn the basics of performance troubleshooting and index tuning. Brent Ozar, recovering developer, will teach you the basic care and feeding of a Microsoft SQL Server 2005, 2008, 2012, or 2014 instance and give you scripts to keep you out of trouble.
Event Date: 09-09-2014 13:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 09-09-2014 14:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 09-09-2014 15:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment
n this session, Kalen Delaney (a SQL Server MVP for over 20 years) will show you the in-memory architecture for your Hekaton data and indexes, and discuss what gets written to disk during checkpoints. Finally, she’ll go into detail on just what it is that makes Hekaton so much FASTER!
Event Date: 09-09-2014 16:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Platform Architecture, Development & Administration
This session is just a preview of what you can learn in the Data Modeling in SSAS Tabular pre-conference session at PASS Summit 2014.
Event Date: 09-09-2014 17:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment
We hope you'll take this opportunity to see why Extended Events has so much offer, and learn how you can start using them in your environment today.
Event Date: 09-09-2014 18:00 - Category: 24 Hours of PASS (60 minutes) - Track: Application & Database Development
In this session, we will explore spatial data and discover many ways it can be used for incredible analytics. You will learn some new ways to visualize your data outside of the typical plots on a Bing map layer. Come and learn how powerful spatial data can be even though it lacks a snazzy "power" title.
Event Date: 09-09-2014 19:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 09-09-2014 20:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Information Delivery
Event Date: 09-09-2014 21:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment
n this session, you will learn about Transparent Data Encryption, IPSec, Database Firewalls, Contained Databases and many other technologies that help you lock down your systems and close attack vectors. This talk puts great emphasis on the biggest threat to your database: SQL injection, offering many remediation techniques to prevent such attacks.
During the demos, you will learn techniques to deal with vendors who require SA accounts to run their applications. Protect your SQL Servers without having to wait for your Developers or Vendors to make changes!
Event Date: 09-09-2014 22:00 - Category: 24 Hours of PASS (60 minutes) - Track: Professional Development
Event Date: 09-09-2014 23:00 - Category: 24 Hours of PASS (60 minutes) - Track: Application & Database Development
In this session, we will talk about the options each upgrade path has, preparing you to take control of the upgrade and not let it control you. John Morehouse and Chris Shaw have experienced many of the requirements that you may be faced with today, and by attending this session, you will:
• Be able to identify the different upgrade paths and what makes them a strong option. • Learn the critical decision points that are the difference between success and failure. • Be able to discuss upgrade options and then plan around them like a seasoned pro.
Event Date: 10-09-2014 00:00 - Category: 24 Hours of PASS (60 minutes) - Track: Application & Database Development
We'll begin with a super fast-paced introduction to PowerShell starting with a quick overview of the two environments in which you can use PowerShell, as well as command Windows and the ISE (Integrated Scripting Environment). Next you'll learn about cmdlets, variables, functions, and logic flow. But wait, there's more! After that we'll learn how to interact with SQL Server using the SQL Provider. For the last dance we limbo, going low-level with the SQL Management Object library, also known as SMO.
Don't be left behind, learn how to leverage the power of PowerShell in your SQL Server environment.
Event Date: 10-09-2014 01:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Information Delivery
In this session, you will learn how Microsoft Self-Service BI enables time series forecasting for the Information Worker and Analyst. This session will commence by introducing the fundamentals of time series forecasting. It will then explore the capabilities available in Excel 2007-2013 delivered by the SQL Server Data Mining Add-ins. Finally, the session will introduce Self-service Predictive Analytics (SSPA) available in Power View in Office 365, and you will learn how easy it is to use Power View to produce visually impressive forecasts and hindcasts.
Event Date: 10-09-2014 02:00 - Category: 24 Hours of PASS (60 minutes) - Track: Application & Database Development
Today, though, we’ll run through a basic optimization checklist of common problems, issues and things to watch out for. We’ll go over database design, server configuration settings and query design. You’ll have a good starting point for getting your own performance issues under control.
Event Date: 10-09-2014 03:00 - Category: 24 Hours of PASS (60 minutes) - Track: Application & Database Development
Event Date: 10-09-2014 04:00 - Category: 24 Hours of PASS (60 minutes) - Track: Professional Development
This session will teach you a variety of communication and interpersonal skills that help you become irreplaceable in your workplace and can lead to a fireproof career. You will:
Event Date: 10-09-2014 05:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Platform Architecture, Development & Administration
In this session, we’ll cover the predictive analytics process so you can obtain a practical understanding of how to develop predictive models for your data. The session includes an overview of predictive modeling concepts and terminology, followed by a demonstration of an actual predictive modeling exercises using Excel and Visual Studio.
You’ll see how to fine-tune and compare results using various algorithms, and how to make the best use of the models within your enterprise.
Event Date: 10-09-2014 06:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment
In this session, you'll be introduced to the new cmdlets and learn how to manage your on-prem and Azure databases consistently
Event Date: 10-09-2014 07:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Information Delivery
This session will discuss how to design the appropriate data model to enable self-service data exploration and insightful analysis in Power View, and how to create pixel perfect visualization for mobile devices. You will also learn how the techniques differ from traditional platforms. Using live demo, we will walk through ways to channel users focus on actionable analytics.
Event Date: 10-09-2014 08:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Platform Architecture, Development & Administration
We'll go over the tools and the methodology that can be used to streamline the production; the maintenance and the evolution of a Data Warehouse; cutting cost where there is no value and investing time; and using resources where appropriate. Everything will be done using the SQL Server Data Platform at its full potential.
Event Date: 10-09-2014 09:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Platform Architecture, Development & Administration
We will start with the Contoso database in Excel and perform some basic analysis using the DAX language to create calculated columns and measures, to obtain a good, yet effective, PivotTable analysis. Then, we will promote the prototype to a SQL Server Analysis Services database to run queries that will be the source of a Reporting Services report (not shown).
The goal of the session is to let you see the kind of analysis you can obtain with just a basic understanding of the DAX language.
Event Date: 10-09-2014 10:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Information Delivery
In this session, we will look at an overview of theory and scientific evidence about data visualization. We will also look at an overview of the Power BI suite of tools in terms of data visualization and the utility of R for its ability to support our analyses in everyday life.We will look at the following technologies in an end-to-end environment: RPower PivotPower QueryPower ViewPower MapExcel. The end result is that we will look at creating dashboards in Power BI tools and Excel.
To summarize, this session aims to deliver a breadth of data visualization knowledge, underpinned by cognitive psychology theory to provide deeper understanding of data visualization, and translated into Microsoft Power BI functionality.
Event Date: 10-09-2014 11:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment