In 2013, I have spoken at 11 conferences and 14 PASS regional group meetings (…I can hardly believe this number myself…).
That year, I basically completed my “Germany tour” on the topic of Extended Events, which had started with the SQL Server 2012 launch in Cologne in 2012, and also expanded the tour to our two neighboring countries, Denmark and the Netherlands. The half-day PreCon of SQLSaturday Rheinland was, so to speak, the big “final” :-).
To those of you who would like to dive deeper into XEvents in practical workshops, I recommend the SQL Server Master-Class “Workshop Advanced Techniques for Tracing with Extended Events” (XE2) on this topic.
In the summer, I applied myself to my 2nd specialty topic, i.e. security, and developed in intensive tests a hitherto undocumented attack technique of the type DoS attack on SQL Server via SQLInjection, as well as a form of privilege elevation, all of which I demonstrated at SQLSaturday Rheinland for the first time, and which I will show in the German regional groups, at the SQL Saturday Istanbul and at the SQL Rally Amsterdam next.
(Note: I am only hinting at details on the DoS attack so as not to provide any templates for automated variants. I will be blogging extensively on privilege elevation in the upcoming months to train developers.)
Konferenz | Session |
PASS Summit, Charlotte 2013, USA
| From Locks to No Locks – concurrency in SQL Server |
TechNet Conference, Berlin
| SQL Hekaton: Extreme Transactional Processing mit XTP in SQL Server 2014 - liegt die Zukunft in InMemory? |
PASS Camp, Darmstadt
| Extreme Transactional Processing mit XTP (Codename "Hekaton") in SQL Server 2014
Monitoring Tools in SQL Server |
PASS SQLRally, Amsterdam
| “SQL Attack(ed)” – SQL Server Under Attack |
BASTA!, Mainz
| Security Essentials und Best Practices für SQL-Server-Entwickler |
TechEd Europe 2013, Madrid
| Support als "Product subject matter expert" für Microsoft SQL Server Data Warehousing & Mission Critical Data Platform |
Frankfurter Datenbanktage
| Hochverfügbarkeit mit Microsoft SQL Server 2012 |
SQLSaturday #258, Istanbul
| PreCon: Performance Analysis & Tuning Techniques
“SQL Attack…ed” – SQL Server under attack.
- Review (extern) |
SQLSaturday #230, Rheinland/Germany
| PreCon: Tracing mit Extended Events
“SQL Server Attack..ed“ – Angriffsszenarien auf SQL Server
- Review (extern) |
SQLSaturday #221, Netherlands
| “Hasta la vista, Profiler” - Tracing with Extended Events |
SQLSaturday #196, Kopenhagen/Denmark
| “Hasta la vista, Profiler” - Tracing with Extended Events |
Regionalgruppentreffen Köln/Bonn/Düsseldorf
| SQL Server Monitoring Tools & Techniken im Überblick Teil 1: integrierte Tools vs. Blocking und Indexing |
Regionalgruppentreffen Hamburg
| SQL Attack..ed – Angriffsszenarien auf SQL Server. Fokus: Webapplication und Netzwerk-Layer |
Regionalgruppentreffen Hannover
| SQL Attack..ed – Angriffsszenarien auf SQL Server. Fokus: Webapplication und Netzwerk-Layer |
Regionalgruppentreffen Köln/Bonn/Düsseldorf
| Von Locks zu Deadlocks bis hin zu Transaktion Isolation Levels |
Regionalgruppentreffen Ruhrgebiet
| Von Locks zu Deadlocks bis hin zu Transaktion Isolation Levels |
Regionalgruppentreffen Hamburg
| Von Locks zu Deadlocks bis hin zu Transaktion Isolation Level |
Regionalgruppentreffen Berlin
| Tracing mit Extended Events – “Hasta la vista, Profiler |
Regionalgruppentreffen Mittelrhein
| From Locks To Deadlocks |
Regionalgruppentreffen Stuttgart & Karlsruhe
| “Hasta la vista, Profiler.” – Einführung in Tracing mit Extended Events. Fokus: Historische Deadlock-Analyse |
Regionalgruppentreffen Rhein/Main
| „Hasta la vista, Profiler.” - Einführung in Tracing mit Extended Events |
Regionalgruppentreffen Karlsruhe
| “Hasta la vista, Profiler.” – Einführung in Tracing mit Extended Events. Fokus: Historische Deadlock-Analyse |
Regionalgruppentreffen Bayern
| Von Locks zu Deadlocks bis hin zu Transaktion Isolation Levels |
Regionalgruppentreffen Franken
| From Locks to Dead-locks. – Concurrency in SQL Server |