Skip to content

Instantly share code, notes, and snippets.

@billinkc

billinkc/Summit13_SessionEval

Created October 30, 2013 17:05
Show Gist options
  • Save billinkc/7236262 to your computer and use it in GitHub Desktop.
Save billinkc/7236262 to your computer and use it in GitHub Desktop.
Download ZIP
Quick and dirty analysis of speaker reviews for Summit 13
Raw
Summit13_SessionEval
CREATE TABLE dbo.SessionEval
(
[SessionCode] varchar(10) NOT NULL
, [Title] varchar(80) NOT NULL
, [Speakers] varchar(250)
, [AvgRating] numeric(3,2) NOT NULL
, [Responses] smallint NOT NULL
, [Attendance] smallint NOT NULL
);
WITH SRC ([SessionCode],[Title],[Speakers],[AvgRating],[Responses],[Attendance]) AS
(
SELECT 'BIA-308-M','Running BI Workloads on Windows Azure Virtual Machines','Chuck Heinzelman, ','4.33','4','34'
UNION ALL SELECT 'DBA-503-S','Waits, Latches, and Spinlocks: Internals and Analysis','Paul Randal, ','4.32','132','540'
UNION ALL SELECT 'BID-202','Delivering Analytics with Excel 2013: 10 Secrets for Success','Josh Fennessy, ','4.3','8','54'
UNION ALL SELECT 'DBA-305-M','CAT: SQL Server on Azure VM – Performance and Best Practices','Sanjay Mishra, Silvano Coriani, ','4.3','5','25'
UNION ALL SELECT 'BIA-101','Building an Effective Data Warehouse Architecture','James Serra, ','4.29','32','145'
UNION ALL SELECT 'DBA-309','Index Fragmentation: Internals, Analysis, and Solutions','Paul Randal, ','4.29','125','668'
UNION ALL SELECT 'DBA-321-S','Skewed Data, Poor Cardinality Estimates, and Plans Gone Bad','Kimberly Tripp, ','4.29','191','792'
UNION ALL SELECT 'DBA-300-HD','SQL Server Disaster Recovery and High Availability Overview','Kendal Van Dyke, ','4.27','10','67'
UNION ALL SELECT 'DBA-499-P','Practical Disaster Recovery Techniques','Paul Randal, ','4.27','79','115'
UNION ALL SELECT 'DBA-500-HD','Inside SQL Server 2012 Memory: The Sequel','Bob Ward, ','4.27','108','280'
UNION ALL SELECT 'BID-311-M','SQL Server 2012 Data Mining: Taking App Design to the Next Level','Peter Myers, ','4.26','37','148'
UNION ALL SELECT 'CLD-309-S','Query Performance Tuning for Azure SQL Database','Grant Fritchey, ','4.26','20','65'
UNION ALL SELECT 'BID-307-M','Mastering the CUBE Functions in Excel','Peter Myers, ','4.25','10','43'
UNION ALL SELECT 'PD-104','DANGER! The Art and Science of Presenting','Mark Vaillancourt, ','4.25','27','71'
UNION ALL SELECT 'DBA-208-S','How to Tell When Storage Is a Problem','Kendra Little, ','4.24','49','130'
UNION ALL SELECT 'DBA-404','Parallel Query Execution','Paul White, ','4.24','74','337'
UNION ALL SELECT 'AD-399-P','Practical T-SQL – Efficient Solutions','Itzik Ben-Gan, ','4.23','89','147'
UNION ALL SELECT 'AD-315-M','Using Batching to Optimize SQL Database Apps on Windows Azure','Jason Roth, Silvano Coriani, ','4.22','3','15'
UNION ALL SELECT 'BIA-202','Choosing the Right Analysis Services: MOLAP vs. Tabular','Devin Knight, Dustin Ryan, ','4.22','54','235'
UNION ALL SELECT 'BIA-207-M','Power BI Self-Service Information Management and Data Stewardship','Matthew Roche, Ofer Ashkenazi, ','4.22','21','137'
UNION ALL SELECT 'DBA-403-M','OLTP Sharding Techniques for Massive Scale','Conor Cunningham, ','4.22','18','92'
UNION ALL SELECT 'PD-201','Convince Me – Persuasion Techniques That Get Things Done','Kevin Kline, ','4.22','50','83'
UNION ALL SELECT 'BID-312','Visualize Your Big Data with HDInsight, Power View, and Excel','Jen Stirrup, ','4.21','11','68'
UNION ALL SELECT 'DBA-212','The Not-So-Secret SQL Server Agent ','Jes Borland, ','4.21','14','115'
UNION ALL SELECT 'LT-101','The Ultimate Tail Log Backup and Restore','Tim Radney, ','4.21','14','-1'
UNION ALL SELECT 'BIA-306','Get Your MDX/DAX Tips and Tricks: Currency Conversion','Christian Wade, ','4.2','25','24'
UNION ALL SELECT 'BID-302','Advanced Analytics in Excel 2013','Dejan Sarka, ','4.2','11','56'
UNION ALL SELECT 'DBA-102','Discover, Document, and Diagnose Your Servers on Your Coffee Break','Kendal Van Dyke, ','4.2','70','213'
UNION ALL SELECT 'LT-102','NodeXL in 10 Minutes','Niko Neugebauer, ','4.19','17','-1'
UNION ALL SELECT 'AD-299-P','Make SQL Server Apps Go Faster','Brent Ozar, Jes Borland, Kendra Little, ','4.18','146','269'
UNION ALL SELECT 'AD-316','Writing Better Queries with Window Functions','Kathi Kellenberger, ','4.18','37','123'
UNION ALL SELECT 'BIA-305-M','Deploying Microsoft BI in SharePoint 2013, Part 1: PowerPivot','Kay Unkroth, ','4.18','33','130'
UNION ALL SELECT 'DBA-322-S','SQL Server Archaeology: Dig into the Past with system_health','Jonathan Kehayias, ','4.18','91','343'
UNION ALL SELECT 'Keynote 2','Hekaton: Why, What, and How','David DeWitt, ','4.18','132','-1'
UNION ALL SELECT 'LT-102','Teaching Nerds T-SQL with “Star Wars”','Richard Douglas, ','4.18','13','-1'
UNION ALL SELECT 'LT-102','From Postal Addresses to Spatial Data: A Simple Geocoding UDF','Yuri Diomin, ','4.18','15','-1'
UNION ALL SELECT 'BIA-211-S','Data Mining in SQL Server Analysis Services','Brian Knight, ','4.17','31','139'
UNION ALL SELECT 'CLD-202','Into the Blue: Extending AlwaysOn Availability Groups','Joseph D''Antoni, ','4.17','3','20'
UNION ALL SELECT 'CLD-307-M','SQL Server Performance and Monitoring in Windows Azure at Scale','Daniel Sol, ','4.17','3','25'
UNION ALL SELECT 'DBA-207','Why Is SQL Server Slow Right Now?','Brent Ozar, ','4.17','123','349'
UNION ALL SELECT 'DBA-304-M','CAT: How Do I Troubleshoot My Database in the Cloud?','Michael Thomassy, Silvano Coriani, ','4.17','1','12'
UNION ALL SELECT 'DBA-323-S','Squeezing Top Performance from Your Virtualized SQL Server','David Klee, ','4.17','39','2226'
UNION ALL SELECT 'LT-101','DBAs in Toyland: Here''s Another Fine Mess You''ve Gotten Me Into!','Ed Watson, Rob Volk, ','4.17','22','-1'
UNION ALL SELECT 'PD-302','Leadership: Transcending Management','Richard Bolesta, ','4.17','37','130'
UNION ALL SELECT 'AD-104-S','10 Query Tuning Techniques Every SQL Programmer Should Know','Aaron Bertrand, Kevin Kline, ','4.16','72','400'
UNION ALL SELECT 'BIA-402-M','CAT: Performance Tuning Tabular Models in SSAS 2012','Greg Galloway, John Sirmon, ','4.16','23','156'
UNION ALL SELECT 'BID-215-S','BI Power Hour','Adam Wilson, Kasper de Jonge, Matt Masson, Matthew Roche, Patrick LeBlanc, Riccardo Muti, ','4.16','77','252'
UNION ALL SELECT 'DBA-209-S','Making the Leap from Profiler to Extended Events','Erin Stellato, ','4.16','143','318'
UNION ALL SELECT 'DBA-316','Query Performance Tuning: A 12-Step Method','Thomas LaRock, Tim Chapman, ','4.16','151','347'
UNION ALL SELECT 'DBA-397-P','Storage and Virtualization for DBAs','Denny Cherry, ','4.16','101','156'
UNION ALL SELECT 'BIA-403','Designing an SSIS Framework','Andy Leonard, ','4.15','52','310'
UNION ALL SELECT 'DBA-314','Policy-Based Management and Central Management Server','Ryan Adams, ','4.15','78','247'
UNION ALL SELECT 'DBA-405-M','SQL Server Index Internals: A Deep Dive','Tim Chapman, ','4.15','81','400'
UNION ALL SELECT 'DBA-501','Understanding Data Files at the Byte Level','Mark S. Rasmussen, ','4.15','43','91'
UNION ALL SELECT 'DBA-502-S','Data Internals Deep Dive','Bradley Ball, ','4.15','59','325'
UNION ALL SELECT 'PD-301','Workplace Coaching: Simple Skills that Change Everything','Brian Moran, ','4.15','13','91'
UNION ALL SELECT 'AD-306-M','Compliance in Azure: The Big Data Conversation','Lara Rubbelke, Rafael Fernandez, ','4.14','5','14'
UNION ALL SELECT 'BIA-299-P','Growing Up with SSAS: From PowerPivot to MOLAP Cubes','Brian Knight, Devin Knight, ','4.14','57','96'
UNION ALL SELECT 'CLD-101','SQL Server Showdown','Colin Stasiuk, ','4.14','12','56'
UNION ALL SELECT 'LT-102','How to Monitor Policy-Based Management','Ryan Adams, ','4.14','19','-1'
UNION ALL SELECT 'AD-209-S','T-SQL: Bad Habits and Best Practices','Aaron Bertrand, ','4.13','88','259'
UNION ALL SELECT 'BID-104','PerformancePoint: Not a Lost Treasure, An Analytic Gem','Josh Fennessy, ','4.13','10','48'
UNION ALL SELECT 'BID-204','From Impaired to Insightful: Analysis with Geospatial Data','Julie Koesmarno, ','4.13','4','27'
UNION ALL SELECT 'LT-101','Are You Certified or Certifiable?','Craig Purnell, ','4.13','22','-1'
UNION ALL SELECT 'LT-102','Lightning Talks 102','Jeff Renz, Jose Chinchilla, Niko Neugebauer, Richard Douglas, Ryan Adams, Yuri Diomin, ','4.13','12','142'
UNION ALL SELECT 'CLD-308-M','Windows Azure SQL Database for the DBA','Scott Klein, ','4.12','18','88'
UNION ALL SELECT 'BIA-303-M','CAT: High Performance, High Volume Data Movement in Azure','Steve Howard, ','4.11','5','35'
UNION ALL SELECT 'CLD-201','Automating in the Cloud','Matt Velic, ','4.11','3','13'
UNION ALL SELECT 'DBA-313','Periodic Table of DMVs: Part 2012 - The SQL','Tim Ford, ','4.1','57','112'
UNION ALL SELECT 'AD-405-S','Maximizing Plan Reuse','Andrew Kelly, ','4.09','33','135'
UNION ALL SELECT 'BID-203-M','From Data to Insight: Views from Microsoft Finance','Marc Reguera, ','4.09','9','23'
UNION ALL SELECT 'BID-306','From Minutes to Milliseconds: High-Performance SSRS Tuning','Doug Lane, ','4.09','72','325'
UNION ALL SELECT 'CLD-203','Windows Azure SQL Database Design: Silver Lining and Dark Side','Karen Lopez, ','4.09','31','92'
UNION ALL SELECT 'DBA-320-S','Dos and Don’ts of Database Corruption ','Gail Shaw, ','4.09','65','268'
UNION ALL SELECT 'AD-101','Geospatial Data Types in SQL Server 2012','Leonard Lobel, ','4.08','20','111'
UNION ALL SELECT 'BIA-209-M','Securing SSAS Tabular Models','Patrick LeBlanc, ','4.08','12','48'
UNION ALL SELECT 'BID-216-S','Ninja Data Moves in Office 2013','Brian Knight, ','4.08','18','55'
UNION ALL SELECT 'DBA-308','How Active Directory Affects SQL Server','Ryan Adams, ','4.08','85','315'
UNION ALL SELECT 'DBA-406-M','SQL Server Transaction Log Internals','Denzil Ribeiro, Tim Chapman, ','4.08','42','256'
UNION ALL SELECT 'AD-207','Understanding Transaction Isolation Levels','Randy Knight, ','4.07','35','77'
UNION ALL SELECT 'BIA-316','Make Your SSIS Packages Run Faster: 10 Quick Tips','Tim Mitchell, ','4.07','33','135'
UNION ALL SELECT 'BID-101','Creating an End-to-End Power View Reporting Solution','Devin Knight, ','4.07','33','125'
UNION ALL SELECT 'BID-102','Dashboard Design Best Practices','Dan Bulos, ','4.07','23','103'
UNION ALL SELECT 'BID-313-M','Power BI – This Is How We Do It','Faisal Mohamood, Kasper de Jonge, Matt Masson, Matthew Roche, Riccardo Muti, ','4.07','48','220'
UNION ALL SELECT 'DBA-202','Doing More with Less: SQL Server Policy-Based Management','Colin Stasiuk, ','4.07','37','206'
UNION ALL SELECT 'DBA-210-S','SQL Server 2014 and Sharks with Freakin’ Lasers','Ari Schorr, Dandy Weyn, ','4.07','59','255'
UNION ALL SELECT 'PD-101','Hirable and Desirable: How to Make Companies Want You','Nicholas Cain, ','4.07','18','65'
UNION ALL SELECT 'PD-102','How to Avoid Living at Work: Lessons from Working at Home','Aaron Bertrand, Andy Leonard, Erin Stellato, Grant Fritchey, Karen Lopez, Kevin Kline, Thomas LaRock, ','4.07','19','55'
UNION ALL SELECT 'BID-208-M','Power View with Analysis Services Multidimensional Models','Kasper de Jonge, Riccardo Muti, ','4.06','6','108'
UNION ALL SELECT 'BID-304-M','Enriching Your BI Semantic Tabular Models with DAX','Kasper de Jonge, ','4.06','21','120'
UNION ALL SELECT 'PD-201-S','Building a Better Team Through Feedback','Joe Webb, ','4.06','21','35'
UNION ALL SELECT 'AD-105','T-SQL Fundamentals: Logical Processing Order','Christina Leo, ','4.05','17','42'
UNION ALL SELECT 'DBA-312','Optimizing SQL Server Performance in a Virtual Environment','Denny Cherry, ','4.05','119','350'
UNION ALL SELECT 'AD-202','Design Matters! The Performance Impact of Database Design','Audrey Hammonds, ','4.04','73','279'
UNION ALL SELECT 'AD-321-M','Clustered Updatable Columnstore Indexes','Brian Mitchell, ','4.04','27','140'
UNION ALL SELECT 'BID-201-M','Introduction to Power BI for Office 365','Dandy Weyn, Michael Tejedor, ','4.04','22','100'
UNION ALL SELECT 'BID-211','Self-Service ETL and Power Query: Are We There Yet?','Rafael Salas, ','4.04','24','96'
UNION ALL SELECT 'BID-401-M','Deep Dive into the Power Query Formula Language','Clemens Szyperski, Faisal Mohamood, Theresa Palmer-Boroski, ','4.04','13','86'
UNION ALL SELECT 'Keynote 1','SQL Server 2014 and the Hybrid Cloud','Quentin Clark, ','4.04','98','-1'
UNION ALL SELECT 'AD-206','SQL Server Database Projects in SQL Server 2012 Data Tools','Robert Cain, ','4.03','15','75'
UNION ALL SELECT 'AD-314','Top Tricks and Best Practices for .NET SQL Server Developers','Mark S. Rasmussen, ','4.03','30','80'
UNION ALL SELECT 'BIA-404-M','Enriching Big Data for Analysis','Adam Jorgensen, Lara Rubbelke, ','4.03','37','230'
UNION ALL SELECT 'BID-213-M','Visual Analytics with Power View in Excel 2013 & SharePoint 2013','Amy Forstrom, Riccardo Muti, ','4.03','15','76'
UNION ALL SELECT 'BID-308-M','Microsoft Power Query for Excel: Discover and Refine Your Data','Faisal Mohamood, ','4.03','30','129'
UNION ALL SELECT 'DBA-315','Professor DMV: How to Use DMVs to Diagnose Performance Issues','Glenn Berry, ','4.03','122','479'
UNION ALL SELECT 'AD-599-P','Understanding the Optimizer and Interpreting Execution Plans','Paul White, ','4.01','121','223'
UNION ALL SELECT 'DBA-101','Congratulations, You''re Now a DBA...','Ben DeBow, ','4.01','52','106'
UNION ALL SELECT 'AD-303-M','CAT: Event-Driven System-Health Monitoring at Microsoft Commerce','Lindsey Allen, Rafael Fernandez, ','4','1','16'
UNION ALL SELECT 'AD-317-M','Zero to 60 with HDInsight','Cindy Gross, ','4','8','64'
UNION ALL SELECT 'BIA-203','Data Cleansing in SSIS','Tim Mitchell, ','4','72','237'
UNION ALL SELECT 'BID-207-M','Power BI: Modern Device and Data Search Experiences','Adam Wilson, Amy Forstrom, ','4','19','75'
UNION ALL SELECT 'BID-212','The New Hotness: SQL Server 2012 and SharePoint 2013','Bradley Schacht, ','4','7','134'
UNION ALL SELECT 'CLD-310-S','Windows Azure Deep Dive','Mark Russinovich, ','4','38','152'
UNION ALL SELECT 'BIA-309-M','SQL Server Integration Services Roadmap','Matt Masson, Wee Hyong Tok, ','3.99','65','205'
UNION ALL SELECT 'AD-400-HD','Indexes: Everything You Need to Know','Gail Shaw, ','3.98','146','321'
UNION ALL SELECT 'BIA-304-M','Death by a Thousand Cuts: A Look at Power View Performance','Adam Saxton, ','3.98','21','105'
UNION ALL SELECT 'AD-320-M','CAT: SQL Server 2014 In-Memory OLTP – Customer Migration','Emanuel Rivera Aleman, Michael Steineke, Mike Weiner, ','3.97','5','100'
UNION ALL SELECT 'BID-210','Predictive Analytics: Letting the Data Decide','Carlos Bossy, ','3.97','50','228'
UNION ALL SELECT 'BID-305','Fraud Detection: Notes from the Field','Dejan Sarka, ','3.97','16','78'
UNION ALL SELECT 'DBA-206','Whatcha Doin''? Passive Security for Hostile Environments','Bob Pusateri, ','3.97','15','86'
UNION ALL SELECT 'DBA-328-M','SQL Server 2014 In-Memory OLTP: DBA Deep Dive','Kevin Liu, ','3.97','84','550'
UNION ALL SELECT 'LT-102','Introduction to Data Vault Data Warehouse Architecture','Jeff Renz, ','3.97','13','-1'
UNION ALL SELECT 'LT-102','Conformed Stored Procedures','Jose Chinchilla, ','3.97','11','-1'
UNION ALL SELECT 'AD-309','NoSQL: An Introduction','Nabeel Derhem, ','3.96','31','140'
UNION ALL SELECT 'BIA-307','Introducing Cube World to Users from Flat Table Land','Michael Antonovich, ','3.95','13','107'
UNION ALL SELECT 'BID-105','PowerPivot + Power View = Self-Service BI Revolution','Jose Chinchilla, ','3.95','32','300'
UNION ALL SELECT 'DBA-103','Storage Subsystem Basics for the DBA','Glenn Berry, ','3.95','53','320'
UNION ALL SELECT 'DBA-318','Using PowerShell to Quickly Deploy New SQL Server Instances','Michael Wells, ','3.95','54','106'
UNION ALL SELECT 'LT-101','Lightning Talks 101','Craig Purnell, Daniel Evans, Ed Watson, Edwin Sarmiento, Rob Volk, Steven Wake, Tim Radney, ','3.95','20','97'
UNION ALL SELECT 'LT-101','Master the Date Dimension Like a Time Lord','Steven Wake, ','3.95','18','-1'
UNION ALL SELECT 'PD-202-S','Never Have to Say "Mayday!!!" Again','Mike Walsh, ','3.95','16','57'
UNION ALL SELECT 'AD-204','Index Methods You''re Not Using ','Jes Borland, ','3.93','46','150'
UNION ALL SELECT 'BID-209','PowerPivot Data Modeling Techniques','Susan O''Connell, ','3.93','35','199'
UNION ALL SELECT 'CLD-306-M','SQL Server High Availability & Disaster Recovery in Windows Azure','Luis Vargas, Sanjay Mishra, ','3.93','12','91'
UNION ALL SELECT 'DBA-211','SQL Server Reference Architectures on Cisco Unified Compute System','Frank Cicalese, ','3.93','9','58'
UNION ALL SELECT 'DBA-398-P','Enterprise High Availability with AlwaysOn Availability Groups ','Curt Mathews, Shon Hauck, ','3.93','54','104'
UNION ALL SELECT 'AD-205','Keeping an Eye on Your Data with Change Data Capture ','Arie Jones, ','3.92','32','150'
UNION ALL SELECT 'AD-305-M','Columnstore Indexes Today & v.Next: Flipping the DW /faster Bit','Jimmy May, ','3.92','54','318'
UNION ALL SELECT 'AD-310-M','Polybase Deep Dive','Brian Mitchell, ','3.92','10','38'
UNION ALL SELECT 'BIA-206','Moving Big Data: SSIS, Pig, and Sqoop','John Welch, ','3.92','10','47'
UNION ALL SELECT 'BID-301','"R" vs "M": Languages for Data Exploration','Julian Breunung, Oliver Engels, ','3.92','10','85'
UNION ALL SELECT 'BID-309-M','Power BI and the Data Management Gateway','Matt Masson, Wee Hyong Tok, ','3.92','24','117'
UNION ALL SELECT 'DBA-303-M','CAT: AlwaysOn Customer Panel – Lessons Learned & Best Practices','Ayad Shammout, David Smith, Michael Steineke, Sanjay Mishra, Thomas Grohser, ','3.92','21','90'
UNION ALL SELECT 'BIA-312','Type More, Click Less: Programmatically Build SSIS Packages','Bill Fellows, ','3.91','18','80'
UNION ALL SELECT 'CLD-401','Running with Elephants: Predictive Analytics with HDInsight','Christopher Price, ','3.91','22','77'
UNION ALL SELECT 'DBA-203','Monitoring Methodologies: The Hierarchy of Database Needs','Michael Fal, ','3.91','26','130'
UNION ALL SELECT 'DBA-205','Table Partitioning: Secret Weapon for Big Data Problems','John Sterrett, ','3.91','48','129'
UNION ALL SELECT 'AD-318-S','How to Model and Implement a Hierarchy in SQL Server','Louis Davidson, ','3.9','31','116'
UNION ALL SELECT 'BIA-314','Unseen Minions: Improving Parallel Processing in SSIS','Josef Richberg, ','3.9','46','150'
UNION ALL SELECT 'DBA-401','DBA Task Automation: Unleash the PowerShell Hero in You!','Aaron Nelson, Michael Wells, ','3.9','40','130'
UNION ALL SELECT 'AD-203','Exposing a Chatty Cathy: What a Drag!','Mindy Curnutt, ','3.89','41','72'
UNION ALL SELECT 'AD-308','From Locks to No Locks – Concurrency in SQL Server','Andreas Wolter, ','3.89','17','104'
UNION ALL SELECT 'AD-319-S','These Aren''t the Joins You''re Looking for...','Rob Farley, ','3.89','111','330'
UNION ALL SELECT 'BIA-208','Putting Quality Back in Your Data Analysis','Michael Antonovich, ','3.89','28','87'
UNION ALL SELECT 'DBA-325-M','Online Operations in SQL Server 2014','Ajay Jagannathan, ','3.89','3','37'
UNION ALL SELECT 'LT-101','The Role of Active Directory and DNS in SQL Server HA/DR','Edwin Sarmiento, ','3.89','18','-1'
UNION ALL SELECT 'AD-201','Building Your T-SQL Tool Kit: Window Function Fundamentals','Christina Leo, ','3.87','61','200'
UNION ALL SELECT 'BIA-200-HD','Fast Performing SSAS Hierarchies: Tips and Tricks','Jose Chinchilla, ','3.87','5','72'
UNION ALL SELECT 'BIA-316-M','Deploying Microsoft BI in SharePoint 2013, Part 2: SSRS & Power View','Chuck Heinzelman, Riccardo Muti, ','3.87','25','112'
UNION ALL SELECT 'BID-310','So You Want to Be a Rockstar Report Developer?','Melissa Coates, ','3.87','62','221'
UNION ALL SELECT 'CLD-311-M','Lap Around Windows Azure SQL Database Premium Service','Gregory Leake, ','3.87','5','22'
UNION ALL SELECT 'PD-103','Mouth Wide Shut: Interviews from the Other Side of the Table','Jennifer McCown, Sean McCown, ','3.87','14','27'
UNION ALL SELECT 'CLD-301','Being the DBA of the Future: A World of On-Premise and Cloud','Dandy Weyn, Grant Fritchey, ','3.86','29','167'
UNION ALL SELECT 'CLD-313-M','What’s New in Database Development with SQL Server Data Tools and Visual Studio?','Adam Mahood, ','3.86','52','280'
UNION ALL SELECT 'DBA-324-S','Troubleshooting Clusters','Allan Hirt, ','3.86','70','227'
UNION ALL SELECT 'AD-322-S','Table Expressions: So Much More than CTEs','Rob Farley, ','3.85','80','215'
UNION ALL SELECT 'BIA-210-S','Automate Your ETL Infrastructure with SSIS and PowerShell','Allen White, ','3.85','43','173'
UNION ALL SELECT 'BIA-311','Transitioning from T-SQL to MDX','Thomas LeBlanc, ','3.84','30','94'
UNION ALL SELECT 'DBA-317-M','Upgrading SQL Server – Done Right','Dandy Weyn, ','3.84','16','95'
UNION ALL SELECT 'AD-102','Spatial Data: Cooler Than You''d Think!','Hope Foley, ','3.83','31','65'
UNION ALL SELECT 'BIA-405','Under the Covers of Hadoop on Windows','Brian Swan, Rohit Bakhshi , ','3.83','36','123'
UNION ALL SELECT 'BID-299-P','From Reporting Services Rookie to Rockstar ','Stacia Misner, ','3.83','53','74'
UNION ALL SELECT 'Board Q&A','PASS Board Q&A','Adam Jorgensen, Bill Graziano, Denise McInerney, Douglas McDowell, James Rowland-Jones, Jennifer Moser, Neil Buchwalter, Olivier Matrat, Richard Bolesta, Rob Farley, Rushabh Mehta, Sri Sridharan, Thomas LaRock, Wendy Pastrick, ','3.83','2','-1'
UNION ALL SELECT 'DBA-201','Accelerate Database Performance Through Data Compression','Joseph D''Antoni, ','3.83','66','190'
UNION ALL SELECT 'BIA-205','Installing and Configuring SQL Server 2012 Reporting Services','Robert Cain, ','3.82','31','69'
UNION ALL SELECT 'CLD-305-M','Private and Hybrid Cloud: Better Together','Darmadi Komo, ','3.82','28','65'
UNION ALL SELECT 'CLD-304','Moving Your Database to the Cloud – What You Need to Know','Nabeel Derhem, ','3.81','42','116'
UNION ALL SELECT 'DBA-301-M','AlwaysOn in SQL Server 2014','Luis Vargas, ','3.81','48','262'
UNION ALL SELECT 'DBA-396-P','Scaling SQL Server 2012','Glenn Berry, ','3.81','30','60'
UNION ALL SELECT 'DBA-399-P','Plan and Deploy Successful Clustered Solutions for SQL Server','Allan Hirt, ','3.81','47','100'
UNION ALL SELECT 'BIA-400-HD','Demystifying Big Data for BI Professionals: The Essentials','Allan Mitchell, Jen Stirrup, ','3.8','27','140'
UNION ALL SELECT 'BID-103','Geospatial Analytics Using Microsoft BI','Jason Thomas, ','3.8','17','58'
UNION ALL SELECT 'BID-205','Planning Your Report Design ','Stacia Misner, ','3.8','10','45'
UNION ALL SELECT 'BIA-313','Unit and Integration Testing for SSIS Packages','John Welch, ','3.78','35','119'
UNION ALL SELECT 'CLD-499-P','SQLCAT: Windows Azure Data Platform Technical Immersion Day','Conor Cunningham, Michael Thomassy, Silvano Coriani, ','3.78','31','76'
UNION ALL SELECT 'AD-307','Custom Replication with Service Broker and CDC/CT','Mladen Prajdic, ','3.77','10','51'
UNION ALL SELECT 'BID-214','Visualizing John Snow''s Cholera Map Using Microsoft BI','Jason Thomas, ','3.77','23','51'
UNION ALL SELECT 'DBA-299-P','Thriving as a DBA in the World of Cloud and On-Premise Data','Grant Fritchey, ','3.77','26','43'
UNION ALL SELECT 'BID-217','NY, London, Paris, Munich… Everybody''s talkin’ ‘bout Mobile BI','Paul Turley, ','3.76','7','44'
UNION ALL SELECT 'AD-302-M','CAT: Architecture Patterns & Lessons Learned from Azure Projects','Kun Cheng, ','3.75','6','24'
UNION ALL SELECT 'AD-401-M','CAT: From Question to Insight with HDInsight and BI','Cindy Gross, Dipti Sangani, ','3.75','2','40'
UNION ALL SELECT 'BIA-300-HD','Slicing and Dicing: Attributes and Hierarchies in SSAS 2012','Thomas LeBlanc, ','3.75','36','134'
UNION ALL SELECT 'DBA-319-M','Windows Azure Virtual Machines and SQL Server Unplugged','Chuck Heinzelman, Evgeny Krivosheev, Khalid Mouss, Luis Vargas, Piyush Ranjan, Sanjay Mishra, ','3.75','2','33'
UNION ALL SELECT 'AD-304-M','CAT: PDW Architecture Gets Real - Customer Implementations','Brian Walker, Murshed Zaman, ','3.74','19','96'
UNION ALL SELECT 'AD-324-M','CAT: Business Continuity with SQL Server – Real-Life War Stories','Sanjay Mishra, ','3.73','31','113'
UNION ALL SELECT 'AD-208','Unit Testing Made Easy for Database Development ','Sanil Mhatre, ','3.72','24','92'
UNION ALL SELECT 'BIA-302','Building a Supportable ETL Framework','David Darden, ','3.71','6','44'
UNION ALL SELECT 'BIA-212-S','What Is a BI DBA?','Jorge Segarra, ','3.7','44','126'
UNION ALL SELECT 'CLD-312-M','Busting Myths: Windows Azure Security and Compliance','Lori Woehler, ','3.68','8','27'
UNION ALL SELECT 'LT-101','BI on the Fly','Daniel Evans, ','3.67','14','-1'
UNION ALL SELECT 'AD-103','SQL Server XML 101','Stuart Ainsworth, ','3.62','26','73'
UNION ALL SELECT 'BID-206-M','Power BI 3D Visualization and Storytelling with Power Map','Ari Schorr, Lara Rubbelke, ','3.61','16','65'
UNION ALL SELECT 'DBA-402','From S to 3XL: Implementing Data Partitioning and Tiered Storage','Dmitri Korotkevitch, ','3.61','15','101'
UNION ALL SELECT 'DBA-326-M','Extended Events in SQL Server 2012','Ajay Jagannathan, ','3.59','45','129'
UNION ALL SELECT 'BIA-310','SSIS Package Failed in Production? Here’s How to Troubleshoot','Reza Rad, ','3.57','9','37'
UNION ALL SELECT 'BIA-315-S','Reduce, Reuse, Recycle: Automating Your BI Framework ','Stacia Misner, ','3.56','48','297'
UNION ALL SELECT 'AD-398-P','How to Design a Relational Database','Louis Davidson, ','3.54','24','58'
UNION ALL SELECT 'DBA-327','Best Practices for Optimizing SQL Server with Solid State Disk','Patrick O''Keeffe, Richard Douglas, ','3.53','54','350'
UNION ALL SELECT 'AD-311-M','SQL Server 2014 and the Hybrid Cloud','Evgeny Krivosheev, Kevin Farlee, ','3.51','13','76'
UNION ALL SELECT 'BIA-499-P','Big Data for the Business Intelligence Professional','Allan Mitchell, Jen Stirrup, ','3.49','75','187'
UNION ALL SELECT 'DBA-310','Load Testing with SQL Server Tools','Neil Hambly, ','3.48','47','125'
UNION ALL SELECT 'AD-323-M','SQL Server 2014 In-Memory OLTP: DB Developer Deep Dive','Kevin Farlee, ','3.47','33','325'
UNION ALL SELECT 'BIA-301','A Systematic Approach to ETL Performance Tuning','Erin Welker, ','3.42','44','232'
UNION ALL SELECT 'AD-501','Defeating the Limitations of the Query Optimizer','Benjamin Nevarez, ','3.41','17','92'
UNION ALL SELECT 'DBA-302','Anatomy of a Join','Luke Jian, ','3.38','51','134'
UNION ALL SELECT 'BIA-201','BI Best Practices: The Good, the Bad, and the Ugly','Erin Welker, ','3.37','84','240'
UNION ALL SELECT 'AD-301-M','CAT: Architecting Near Real-Time Data Warehouses on PDW','Binh Cao, John Hoang, Tomas Polanco, ','3.24','39','118'
UNION ALL SELECT 'AD-404','Database Development with SSDT for Visual Studio 2012','Aaron Nelson, ','3.13','15','76'
)
INSERT INTO dbo.SessionEval
(
SessionCode
, Title
, Speakers
, AvgRating
, Responses
, Attendance
)
SELECT
S.SessionCode
, S.Title
, S.Speakers
, S.AvgRating
, S.Responses
, S.Attendance
FROM
SRC AS S;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment