Learn SQL Server 2008 R2 with 24-HOP

Last month, the Professional Association for SQL Server (PASS) held its second 24 Hours of PASS, or 24 HOP for short. What is 24 HOP? It is 24 one-hour SQL Server technical presentations streamed back to back for 24 hours straight. Wow!

The line up was impressive with many of the biggest names in the SQL Server community. If you missed the live feed, or simply just couldn’t make your brain focus for 24 consecutive hours, no worries. The 24 HOP recordings are now available on the PASS web site. You need to be a PASS member to view them, but that’s easy and free.

Let’s have a look at the line up.

24 Hours of PASS Sessions

The Line Up

  • Session 01: Introduction to PowerPivot (Brian Knight)
  • Session 02: Database Development Patterns (Andy Leonard)
  • Session 03: What Exactly is in SQL Server 2008 R2 (Kevin Cox)
  • Session 04: Getting Started with SQL Server Utility in SQL Server 2008 R2 (Glenn Berry)
  • Session 05: Data Tier Applications (Jacob Sebastien)
  • Session 06: What’s Really Happening on Your Server? 15 Powerful SQL Server Dynamic Management Objects (Adam Machanic)
  • Session 07: Filtered Indexes, Sparse Columns: Together, Separately (Don Vilen)
  • Session 08: Solving Common Business Problems with Microsoft PowerPivot (Donald Farmer)
  • Session 09: Exploring SQL Server 2005 and 2008 Security (Don Kiely)
  • Session 10: Using Data Compression with SQL Server 2008 and 2008 R2 (Maciej Pilecki)
  • Session 11: Easier than Ever Report Authoring in SSRS 2008 R2 (Jessica M. Moss)
  • Session 12: High Performance Functions (Simon Sabin)
  • Session 13: Manage Your DBA Career, Don’t Let it Manage You (Brad McGehee)
  • Session 14: Top 10 Mistakes on SQL Server (Kevin Kline)
  • Session 15: Producing Dashboards with PerformancePoint Services (Peter Myers)
  • Session 16: Reporting Services Enhancements in SQL Server 2008 (Greg Low)
  • Session 17: SQL Tuning – Get it Right the First Time (Dean Richards)
  • Session 18: Managing SSIS Package Deployments with Powershell (Sean McCown)
  • Session 19: Multi-Server Management With UCP, MDW and PBM (Chuck Heinzelman)
  • Session 20: Advanced T-SQL Query Tuning Techniques (Rob Farley)
  • Session 21: Implementing MDM Using SQL Server 2008 R2 Master Data Services (Rushabh Mehta)
  • Session 22: SQL 2008 R2 How to Manage CPU’s, Cores and CPU Groups (Thomas Grohser)
  • Session 23: Database Design Fundamentals (Louis Davidson)
  • Session 24: BLITZ! 60 Minute Server Takeovers (Brent Ozar)


One Response to Learn SQL Server 2008 R2 with 24-HOP

  1. Pingback: Dew Drop – June 19, 2010 | Alvin Ashcraft's Morning Dew

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s