Upcoming Presentations:

Coming soon

Voice from the past:

DBA Fundamentals (March 30th, 2021)

Size Does Matter – 5 Ways to Reduce DB Size and Improve Performance

• Slides
• Scripts

South Florida SQL Server User Group (October 7th, 2020)

Red Flags and Red Herrings in the Execution Plans

• Slides
• Demos

Pinellas SQL Server User Group (Tampa, FL. April 21st, 2020)

SQL Server Troubleshooting and Performance Tuning: Intro Into Wait Statistics

• Slides
• Diagnostics Scripts
• Video (coming)

PASS Summit 2019

Deep Dive Into Blocking and Deadlock Troubleshooting

• Slides
• Demos

SQL Saturday #982 (Aucklnd, NZ, August 8th, 2020)

SQL Saturday #820 (Jacksonville, FL, May 4th, 2019)

Five Availability Group Issues That May Ruin Your Day

• Slides
• Scripts

SQL Saturday #862 (Cork, Ireland, June 28th, 2019)

Troubleshoot and optimize SQL Server like a Pro! : Full Day Pre-Con

SQL Saturday #862 (Cork, Ireland, June 29th, 2019)

Poland Data Community (May 9th, 2019)

SQL Orlando UG (Orlando, FL, February 20th, 2019)

Pinellas SQL Server UG (Tampa, FL, October 16th, 2018)

SQL Saturday #801 (Orlando, FL, October 6th, 2018)

SQL Saturday #759 (Jacksonville, FL, May 5th, 2018)

Intro Into Index Analysis

• PDF
• Scripts

Data Platform Summit (Bangalore, India, August 2018)

Full-Day Precon: Troubleshoot and Optimize SQL Server like a Pro!

Deep dive into Blocking and Deadlock troubleshooting

• Slides

Data Partitioning for Database Architect and Mere Mortals

• Slides

Tips and Tricks for Successful In-Memory OLTP Migration

Saturday Night SQL VC (October 13th, 2018)

SQL.Ru Community (June 29th, 2018)

Tampa SQL Server User Group (June 26th, 2018)

Deep dive into Blocking and Deadlock troubleshooting

• Slides
• Video (Russian)

SQL Saturday #755 (South FLorida, June 08th, 2018)

Data Platform Geeks (India) – 21 webinar in March 2018

Global Russian SQL Server Virtual Chapter

SQL Saturday #699 (Tampa, FL, February 24th, 2017)

SQL Saturday #678 (Orlando, FL, October 07th, 2017)

SQL Saturday #649 (Jacksonville, FL, August 10th, 2017)

Cautionary Tale of Recompilation, Plan Caching and High CPU Usage

• Scripts and Application
• Video

SQL.RU community (June 2nd, 2018)

Введение в колоночные индексы

PASS Summit 2017 (Seattle, WA, November 2nd, 2017)

Everything you wanted to know about Data Partitioning but Were Afraid To Ask (Half-day Session)

• Slides
• Scripts

Pinellas SQL Server UG (Tampa, FL, October 17th, 2017)

Everything you wanted to know about Data Partitioning but Were Afraid To Ask

• Slides
• Scripts

SQL Server Ireland UG (Dublin, Ireland, July 3rd, 2017)

Brasilia SQL Server UG (February 14th, 2017)

• In-Memory OLTP: Architecture, Implementation and SQL Server 2016 enhancements
• Demos

SQL Saturday #627 (South Florida, June 10th, 2017)

How The Grinch Stole SQL Server Performance

• Art Work by Angella Bekic (senkabekicofficial at gmail dot com)
• Database backup
• Demo App
• Scripts

Malta Microsoft Data Platform User Group (April 27th, 2017)

SQL Saturday #506 (Orlando, October 8th, 2016)

PASS Summit 2016  (Seattle, October 25-28)

Data Partitioning for Database Architects and Mere Mortals

• Slides
• Scripts

SQL Saturday #577 (Dnipro, Ukraine, November 26th, 2016)

Все, что вы хотели узнать об объектах БД, но боялись спросить

• Slides
• Scripts

Как убить SQL Server за 60 минут

• Art Work by Angella Bekic (senkabekicofficial at gmail dot com)
• Database backup
• Demo App
• Scripts

SQL Saturday #577 (Dnipro, Ukraine, November 25th, 2016)

SQL Server Internals v2: Full Day Pre-Con

Казань, SQL Server & BI User Group (October 20, 2016)

Секционирование данных в SQL Server

• Slides
• Scripts

24 Hours of PASS. Summit 2016 Preview (September 7th, 2016)

The Ambiguous Case of Off-Row Storage in In-Memory OLTP

• Slides
• Demos

Hillsborough SQL Server User Group (Tampa, August 25th, 2016)

• In-Memory OLTP: Architecture, Implementation and SQL Server 2016 enhancements
• Demos

Virtual Forum “Data, Technology, SQL Server 2016” (June 6h, 2016)

• In-Memory OLTP: Архитектура и Реализация
• In-Memory OLTP: Практическое Применение
• Демо и Примеры из Докладов

SQL Saturday #506 (Baltimore, April 30th, 2016)

• Data Partitioning for Database Architects and Mere Mortals
• How the Grinch stole SQL Server Performance
  • Art Work by Angella Bekic (senkabekicofficial at gmail dot com)
  • Database backup
  • Demo App
  • Scripts

SQL Saturday #506 (Baltimore, April 30th, 2016)

Pre-Con: SQL Server Internals: The Practical Angle

SQL Saturday #482 (Nepal, March 26th, 2016)

• Size Does Matter: 5 ways to reduce database size and improve performance
  • Slides
  • Scripts
• Thinking outside the in-memory box
• Data Partitioning for Database Architects and Mere Mortals

SQL Saturday #482 (Nepal, March 24th-25th, 2016)

SQL Server Internals – 2 days pre-con

24 Hours of PASS Russia (March 16th, 2016)

In-Memory OLTP: Нестандартные сценарии использования

SQL Saturday #489 (February 27th, 2016. Tampa, FL)

Database Partitioning for DB Architects and Mere Mortals

PASS Summit 2015 (October 27-30, Seattle, WA)

SQL Server Internals: Practical Angle. Full Day Pre-Con

Thinking Outside the In-Memory Box

Tampa (Pinellas) SQL Server User Group (October 20th, 2015. Tampa, FL)

Thinking Outside of In-Memory Box

SQL Saturday #442 (October 10th, 2015. Orlando, FL)

Thinking Outside of In-Memory Box

Idera Geek Sync (September 23rd, 2015)

Size does matter: Reducing the size of the database with In-Row and LOB data compression

24 Hours Of PASS – Summit Preview (September 17th, 2015)

SQL Server Internals: The Practical Angle – Sneak Peek

• Slide deck
• Demos

Tampa Hillsborough SQL Server User Group (August 27th, 2015)

Eternal story on temporal objects

• Slide deck
• Demos
• App (Save RecordSet)

Porto.Data (July 15th, Porto, Portugal)

Thinking Outside of In-Memory Box

Global Russian Virtual Chapter (June 17th, 2015)

“Это Мое” – Блокировки, Дедлоки и прочая чепуха

• Слайды
• Скрипты

Microsoft Novosibirsk (May 28th, 2015)

Круглый стол – Вопросы и ответы по SQL Server

SQL Saturday #377 (Kiev, Ukraine, May 23rd, 2015)

• “Это Мое” – Блокировки, Дедлоки и прочая чепуха (часть 1)
• “Не отдам!” – Блокировки, Дедлоки и прочая чепуха (часть 2)

SQL Saturday #377 Pre-Con (Kiev, Ukraine, May 22nd, 2015)

SQL Server Internals: Практические советы для разработчиков и администраторов БД

SQL Saturday #391 (Jacksonville, FL. May 9th, 2015)

Size Does Matter: 10 ways to reduce database size and improve performance

• Slides
• Scripts

 Lviv SQL Server User Group (March 28th, 2015)

• Art Work by Angella Bekic (senkabekicofficial at gmail dot com)
• Database backup
• Demo App
• Scripts

24 Hours of PASS Russian Edition (March 18-19, 2015)

Размер имеет значение: 10 способов уменьшить размер БД и улучшить производительность системы

• Слайды
• Код

SQL Saturday #371 (Tampa, FL. February 28th, 2015)

Size Does Matter: 10 ways to reduce database size and improve performance

PASS Summit 2014 (Seattle, WA. November 4-7th, 2014)

Windows Azure: An Unexpected Journey

Hillsborough SQL Server User Group (Tampa, FL, October 30, 2014)

Windows Azure: An Unexpected Journey

SQL Saturday #326 BA Edition (Tampa, FL. October 25th, 2014)

Clustered Columnstore Indexes: Internals and Design Considerations

• Slide Deck
• SQL
• Demo Data (~50MB)

Tampa IT Pro Camp (Tampa, FL. October 18, 2014)

Windows Azure: An Unexpected Journey

Russian SQL Server Virtual Chapter (October 15, 2014)

Windows Azure: Нежданное Путешествие

SQL Saturday #318 (Orlando, FL. September 27, 2014)

How to Kill SQL Server in 60 minutes

• Art Work by Angella Bekic (senkabekicofficial at gmail dot com)
• Database backup
• Demo App
• Scripts

Kyiv SQL Server User Group (Kyiv, Ukraine. September 10, 2014)

Как убить SQL Server за 75-120 минут

• Art Work by Angella Bekic (senkabekicofficial at gmail dot com)
• Database backup
• Demo App
• Scripts

MagicPass SQL Server User Group (August 20, 2014)

How to Kill SQL Server in 60 minutes

• Art Work by Angella Bekic (senkabekicofficial at gmail dot com)
• Database backup
• Demo App
• Scripts

Himalayan SQL Server User Group (July 26, 2014)

Into into Locking and Blocking in SQL Server

• Slide Deck
• Scripts

SQL Tune In! (June 2nd-3rd 2014, Zagerb, Croatia)

Practical SQL Server Internals (Full Day Precon)

How to Kill SQL Server in 60 minutes

• Art Work by Angella Bekic (senkabekicofficial at gmail dot com)
• Database backup
• Demo App
• Scripts

PASS Performance Virtual Chapter (May 22nd, 2014. Online)

Eternal story on temporal objects

• Slide deck
• Demos
• App (Save RecordSet)

Krasnodar SQL Server User Group (May 21st, 2014. Online)

Как убить SQL Server за 60/75 минут

Pinellas County SQL Server User Group (May 20th, 2014, Tampa, FL)

How to Kill SQL Server in 60/75 minutes

SQL Saturday #298 (May 10th, 2014, Jacksonville, FL)

Implementing Data Partitioning and Tiered Storage

Sarasota IT Pro Camp (March 22nd, 2014, Sarasota, FL)

Eternal story on temporal objects

• Slide deck
• Demos
• App (Save RecordSet)

Implementing Data Partitioning and Tiered Storage

24 Hours of PASS Russian Edition (March 19-20, 2014)

Вечная история о преходящем

• Slide deck
• Demos
• App (Save RecordSet)

Все, что Вы хотели узнать об объектах БД, но всегда боялись спросить

• Slide deck
• Demos
• App (Save RecordSet)

SQL Saturday #273 (February 22nd, 2014. Tampa, FL)

Eternal story on temporal objects

• Slide deck
• Demos
• App (Save RecordSet)

Krasnoyarsk MCP Club (December 26th, 2013)

Диагностика проблем в SQL Server – практический подход (SQL Server – practical troubleshooting). Presented in Russian

• Слайды
• SQL

PASS SUMMIT 2013 (October 15th – 18th, 2013. Charlotte, NC)

From S to 3XL: Implementing Data Partitioning and Tiered Storage

SQL Saturday #190 (September 28th, 2013. Denver, CO)

From S to 3XL: Implementing Data Partitioning and Tiered Storage

SQL Saturday #190 Full Day Precon (September 27th, 2013. Denver, CO)

SQL Server Internals from the Practical Angle

Global Russian Virtual Chapter (September 18th, 2013. Online)

Индексы и все, все, все (часть 2) (All about Indexes. Part 2. Presented in Russian)

• Слайды
• Скрипты

SQL Saturday #232 (September 14th, 2013. Orlando, FL)

From S to 3XL: Implementing Data Partitioning and Tiered Storage

Global Russian Virtual Chapter (August 21th, 2013. Online)

Индексы и все, все, все (часть 1) (All about Indexes. Part 1. Presented in Russian)

• Слайды
• Скрипты

Krasnoyarsk MCP Club (May 30th, 2013) 

Все, что Вы хотели узнать о секционировании данных, но боялись спросить (Everything you always wanted to know about Data Partitioning but were afraid to ask). Presented in Russian

• Слайды

SQL Saturday #201 (April 20th, 2013. Orange County, CA)

• “It’s mine” – or intro to locking and blocking in SQL Server
• Data Partitioning in VLDB

Full day Pre-Con: SQL Server Internals from the Practical Angle

24 Hours of Pass – Russia (March 21th, 2013) 

Все, что Вы хотели узнать о секционировании данных, но боялись спросить (Everything you always wanted to know about Data Partitioning but were afraid to ask). Presented in Russian

• Слайды

SQL Saturday #192 (March 2nd, 2013. Tampa, FL)

• Locking, Blocking and Other Stuff

SQL Saturday #192 Pre-con (March 1st, 2013. Tampa, FL)

SQL Server Internals from the Practical Angle

Moscow SQL Server User Group (February 28th, 2013)

Диагностика проблем в SQL Server – практический подход (SQL Server – practical troubleshooting). Presented in Russian

• Слайды
• SQL

Sarasota IT Pro Camp (February 16th, 2013. Sarasota, FL)

• SQL Server – Practical Troubleshooting
  • Slide Deck
  • SQL
• Database Backend – Between Ground and Clouds
  • Slide Deck
  • Video 1
  • Video 2
    

TechEd Russia (November 27th-28th, Moscow, Russia)

• Между Землей и Облаками – сходства и различия в реализации платформ БД
  • Слайды
  • Демо Видео 1
  • Демо Видео 2
• Секционирование данных в SQL Server 2012 и Windows Azure SQL Databases

Novosibirsk MCP Club (November 22nd, Novosibirsk, Russia)

• Круглый стол

SQL Saturday #178 (November 17th, 2012, Moscow, Russia)

• “Это Моё” или вечная сага о блокировках и дедлоках
• Дизайн для производительности

Tampa SQL User Group (October 25th, 2012, Tampa FL)

• Data Partitioning in VLDB

Russian BI PASS Chapter – Moscow (October 24th, 2012. Moscow/Online)

•  Секционирование данных в SQL Server 2012 и Windows Azure SQL Database

MagicPASS User Group (October 17th, 2012, Orlando FL)

•  Database Backend – Between Ground and Clouds

SQL Saturday #151 (September 29th, 2012, Sanford FL)

•  Database Backend – Between Ground and Clouds

Tampa IT Pro Camp  (September 22th, 2012, Tampa FL)

•  Database Backend – Between Ground and Clouds

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

• Everything you always wanted to know about indexes but were afraid to ask
  • Demo scripts
  • Presentation Deck

SQL Saturday 141 (South Florida, June 16th, 2012)

• Everything you always wanted to know about indexes but were afraid to ask
  • Demo scripts
  • Presentation Deck

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

• Everything you always wanted to know about indexes but were afraid to ask
  • Demo scripts
  • Presentation Deck

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

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

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

• Everything you always wanted to know about indexes but were afraid to ask
  • Demo scripts
  • Presentation Deck

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

• “Все, что вы хотели узнать об индексах, но боялись спросить” ( Everything you always wanted to know about indexes but were afraid to ask) – 3 hours session. Presented in Russian
  • Примеры, используемые в презентации (Demos from the presentation)

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

• Service Broker – Why, When and Where?

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

• Database Design for Non-Database Developers
• Locking and Blocking for Developers

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

Adopt, Discover and Improve

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

• Data Sharding in OLTP Systems

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)

• Adopt, Discover and Improve

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

• Adopt, Discover and Improve

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