Presentations

Upcoming Presentations:

Tampa SQL User Group (September 18th, 2012, Tampa FL)

  • Everything you always wanted to know about indexes but were afraid to ask

PASS SQL Rally 2012 (May 10-11, Dallas, TX)

  • Everything you always wanted to know about indexes but were afraid to ask

SQL Saturday #130 (April 28th, 2012, Jacksonville, FL)

  • Everything you always wanted to know about indexes but were afraid to ask (2 hours session)

Voice from the past

Sarasota SQL Server User Group (April 17th, 2012)

  • Everything you always wanted to know about indexes but were afraid to ask

24 Hours of PASS - Russia (April 12th, 2012, online)

SQL Saturday # 110 (March 10th, 2012, Tampa FL)

South Florida Code Camp 2012 (February 18th, 2o12. Ft. Lauderdale - Davie, FL)

Space Coast SQL User Group (October 20th, 2011.  Melbourne, FL)

SQL Saturday #85 (September 24th, 2011. Orlando, FL)

SQL Saturday #79 (August 13th, 2011. South Florida)

  • Data Sharding in OLTP Systems
  • Anti-patterns in Database design and T-Sql code - (Some of the topics covered)
    • Server side sorting and paging
    • Saving large packet of data - See Sql Sat #62 “Refactoring for performance” presentation
    • Functions - Good and ugly - See Sql Sat #62 “Refactoring for performance” presentation
    • Optimizing code with CTE  - See Sql Sat #62 “Refactoring for performance” presentation
    • Dealing with master-detail - See Sql Sat #62 “Refactoring for performance” presentation
    • Views - joins hell

 SQL Saturday #74 (April 30th, 2011. Jacksonville, FL)

Tampa SQL User Group (April 19th, 2011. Tampa, FL)

Tampa Bay IASA Chapter (February 24th, 2011. Tampa, FL)

  1.  Database Design and Architecture for Non-Database Architects

SQL Saturday #62 (January 15th, 2011. Tampa, FL)

  1. Refactoring for Performance 
  2. Blocking waits and deadlocks   (mini session together with Tavolacci and Associates)

SQL Saturday #49 (October 16th, 2010. Orlando, FL)

  1.  Locking and Blocking for Developers

SQL Saturday #40 (July 31th, 2010. Miramar, FL)

  1. Locking and Blocking for Developers
  2. Database Design with Performance in Mind
  3. Getting Familiar with Query Optimizer

SQL Saturday #32 (January 23rd, 2010. Tampa, FL)

  1. Getting Familiar with SQL Server Storage Engine

SQL Saturday #21 (October 17th, 2009. Orlando, FL)

  1. Database Design of Highly Loaded OLTP Systems