Conferences / SQLSaturday
SQLSaturday Pittsburgh #907
Oct 5, 2019 · Pittsburgh Technical College, Oakdale, PA, United States
- Conference
- SQLSaturday Database
- Dates
- Oct 5, 2019
- Venue
- Pittsburgh Technical College
- Place
- Oakdale, PA, United States
- Format
- In person
- Status
- Past
- Attendance
- —Organizer's attendee estimate in the PASS event XML feed: 250 (pre-event estimate, not a headcount).
- Website
- sqlsaturday.com
- Recorded
- 11 sponsors · 50 speaker appearances
- Notes
- Official name: SQLSaturday #907 - Pittsburgh 2019. Run under PASS. Sessions, speakers and sponsors from the PASS event XML feed (Wayback snapshot); 50 sessions. Affiliation extracted from each speaker's bio in the feed where it names a current employer, else null.
Ticket prices
| Ticket | Price | Valid until | Notes | Source |
|---|---|---|---|---|
| Pre-con | $125 | — | Event home page: 'Cost: $125' | web.archive.org |
Sponsors 11
Platinum 1
Silver 3
- NIS Technologies · Silver Sponsor
- RDX · Silver Sponsor
- SQLGene Training · Silver Sponsor
Bronze 1
- Pittsburgh Technical College · Bronze Sponsor
Community 1
- PASS · PASS
Other 1
- Microsoft · Global SQLSaturday Partner
Speakers and talks 50
| Speaker | Company | Role | Talk | Links |
|---|---|---|---|---|
| Allen White | — | — | Scalable Application Design with Service Broker | — |
| Allen White | — | — | Emergency! Are You Ready for Disaster to Strike? | — |
| Ameena Lalani | Microsoft | — | SQL Server 2019 - New Features and Enhancements | — |
| Andy Leonard | Enterprise Data & Analytics | — | Faster SSIS | — |
| Andy Leonard | Enterprise Data & Analytics | — | Moving Data with Azure Data Factory | — |
| Andy Mallon | — | — | How to get your Dream Job: Resume job hunting tips | — |
| Andy Mallon | — | — | When to use Indexing ProTools | — |
| Angela Tidwell | — | — | Data Collection and Usage: Illegal or Unethical? | — |
| Angela Tidwell | — | — | Become the Most Valuable Player: Soft Skills for the Hard Market | — |
| Dave Bland | Stericycle | — | How to use Execution Plans to find Performance Issues | — |
| Dave Bland | Stericycle | — | How to do a Complete SQL Server Assessment | — |
| Dave Bland | Stericycle | — | An Introduction to Azure Data Studio | — |
| Diane Schuster | COZYROC | — | CozyRoc: Dynamic Data Flows in SSIS Without Programming | — |
| Ed Wagner | — | — | DBA - What's Most Important | — |
| Eugene Meidinger | — | — | Drinking From the Firehose: a Guide to Keeping Up with Technology | — |
| Eugene Meidinger | — | — | Introduction to M (a.k.a Power Query) | — |
| George Woods | Microsoft | — | Power BI - A guide to each product and licensing | — |
| James Loesch | — | — | Opening SQL Window Functions | — |
| Janis Griffin | Quest | — | Inside the Query Store. What Knowledge can You Gain? | — |
| Jeff Moden | — | — | “Black Arts” Index Maintenance #2: Better Methods that Can Actually Prevent Fragmentation for Weeks. | — |
| Jeff Moden | — | — | “Black Arts” Index Maintenance #1: How the “Best Practice” Methods are Silently Killing Performance | — |
| Jess Pomfret | Westfield Group | — | Life Hacks: dbatools edition | — |
| Jess Pomfret | Westfield Group | — | Install Configure SQL Server with PowerShell DSC | — |
| Jim Donahoe | Microsoft | — | Getting started with Azure SQL Database: What You Need To Know! | — |
| Katie Novotny | DDI | — | Azure Databricks: A Beginner's Journey | — |
| Marsha Pierce | Pure Storage | — | Virtualizing SQL - An overview of what you need to do to virtual | — |
| Matt Nelson | RDX | — | Profisee - Lunchtime chat | — |
| Matt Nelson | RDX | — | Quest - Lunchtime chat | — |
| Matt Nelson | RDX | — | Pure Storage lunchtime chat | — |
| Matt Nelson | RDX | — | Snowflake - Lunchtime chat | — |
| Mike Burek | — | — | Columnstore Indexes for Everyone | — |
| Pat Phelan | Involta | — | Ethics, Morals, and Laws for the DBA 101 | — |
| Paul Stanton | Windocks | — | SQL DevOps Simplified with Production Databases | — |
| Peter Shore | — | — | Hello My Friends, Welcome to CosmosDB | — |
| Peter Shore | — | — | Infrastructure for the DBA: An Introduction | — |
| Peter Shore | — | — | Learn Like Your Life Depends On It | — |
| Ravi Kumar | Microsoft | — | Power BI Suite: What services make up Power BI? | — |
| Ravi Kumar | Microsoft | — | Azure Analysis Service or SSAS Tabular: How they work | — |
| Rayis Imayev | — | — | Using Azure Data Factory Mapping Data Flows to load Data Vault | — |
| Rick Heiges | Microsoft | — | Azure SQL DB Managed Instance: Today | — |
| Russel Loski | — | — | Managing ETL Change Using BIMLScript | — |
| Sam Nasr | NIS Technologies | — | Data Time Travel with SQL Server Temporal Tables | — |
| Slava Murygin | — | — | Power BI: From Zero to 101 | — |
| Slava Murygin | — | — | What treasures are hidden in the Plan Cache? | — |
| Stephanie Bruno | Elizabeth Glaser Pediatric AIDS Foundation | — | Avoiding angry calls: Power BI model optimization | — |
| Thomas Norman | KPA | — | Encrypting Data within SQL Server | — |
| Tracy Boggiano | DocuSign | — | Using Open Source Software to Collect Performance Metrics | — |
| Tyler Graham | — | — | Dimension Management for Power BI | — |
| Vladimir Oselsky | — | — | Performance Tuning for SQL Developer through Execution Plans | — |
| William Wolf | RDX | — | Stop Doing That! Common T-SQL Anti-Patterns | — |