Here is the list of the upcoming events where I will be speaking:
PASS Summit 2020: Migrating & Running SQL Server on Azure VMs Cloud Solutions (10-13th of November 2020) This 2.5 hour session will focus on the experience with diverse clients (big & small) on how to efficiently migrate and run the SQL Server on Azure VMs. Besides the infra-structure configurations and proper SQL Server configurations, I will dive into some of the more interesting aspects .
PASS Summit 2020: When & Where to use Columnstore Indexes (10-13th of November 2020) I will delivere a session that focus on some good old and some of the yet unpublished examples of how to make Columnstore Indexes useful.
SQLBits 2020: Graph Solutions in Azure SQL DB & SQL Server (2nd of October 2020) – With further grow of the SQL Graph surface in 2018-2019 we have now function ShortestPath() that allows us to do some pretty exciting calculations and start comfortably analyzing different types of Networks such as Social Networks.
SQLBits 2020: Columnstore Indexes 2017-2020 (1st of October 2020) I will deliver a session on the newest additions & evolutions of the Columnstore Indexes in Azure SQL Database, Sql Server 2017 & Sql Server 2019. As well as beyond that. :)
SQLBits 2020: Migrating & Running SQL Server on Azure VMs (29th of September 2020) – I will deliver a whole-day workshop on possible migrations and how to run most efficiently SQL Server on Azure VMS.
Previous Events (Starting from January of 2014):
SQLPort 112: Azure Synapse Analytics Relational (30th of January 2020) – I spoke about the exceptional and exciting new features of the Azure Synapse Analytics.
SQLSaturday Vienna 2020: Columnstore Indexes – Practical Solutions & Techniques Workshop (23rd of January 2020) – I gave a whole -day workshop on the practical aspects & techniques for the Columnstore Indexes.
Redmond PASS User Group: Batch Execution Mode on the Rowstore (11th of December 2019) I have delivered a deep dive on the Batch Mode on the Rowstore Indexes that is new in Azure SQL Database and Sql Server 2019.
SQLSaturday Lisbon 2019: Batch Execution Mode on the Rowstore (30th of November 2019) I have delivered a deep dive on the Batch Mode on the Rowstore Indexes that is new in Azure SQL Database and Sql Server 2019.
SQLSaturday Porto 2019: Batch Execution Mode on the Rowstore (23rd of November 2019) I have delivered a deep dive on the Batch Mode on the Rowstore Indexes that is new in Azure SQL Database and Sql Server 2019.
PASS Summit 2019: Columnstore Indexes in 2017-2019 (5-8th November 2019) I have delivered a session on the newest additions & evolutions of the Columnstore Indexes in Azure SQL Database, Sql Server 2017 & Sql Server 2019.
PASS Summit 2019: Batch Execution Mode on Rowstore Indexes (5-8th November 2019) I have delivered a deep dive on the Batch Mode on the Rowstore Indexes that is new in Azure SQL Database and SQL Server 2019.
Techorama Netherlands 2019: Columnstore Indexes – Practical Solutions & Techniques (2nd of October 2019) I have delivered a session on tips and tricks with Columnstore Indexes.
PASS Marathon: Portuguese Edition: Batch Execution Mode on the Rowstore (4th of July 2019) I have delivered a deep dive on the Batch Mode on the Rowstore Indexes that is new in Azure SQL Database and Sql Server 2019.
TechInPorto 2019: Intelligent Query Processing (13th of June 2019) I have delivered my view on what is intelligent query processing is, what people think is and what it should and could be.
Porto.Data #51: Batch Execution Mode on the Rowstore (12th of June 2019) I have delivered a deep dive on the Batch Mode on the Rowstore Indexes that is new in Azure SQL Database and Sql Server 2019.
SQLBits 2019: Batch Mode on Rowstore (1st of March 2019) – I delivered a session on the Batch Mode on Rowstore Indexes.
SQLBits 2019: Optimising ETL on Microsoft Data Platform (SQL & Azure) (28th of February 2019) – This was a full-day workshop on the ETL optimisation for the relational Microsoft Data Platform.
Claranet DevOps Day 2019 (8th of February 2019) – I have presented on the Databases & Containers (Docker & Kubernetes) where myth meets the reality.
SQLPort 106th Meeting: Froid vs Freud: Scalar T-SQL UDF Inlining (23rd of January 2019) – On the first event of SQLPort in 2019 I have presented on the Froid Framework that will help to inline many User Defined Functions in SQL Server 2019 and Azure SQL Database.
Columnstore Indexes: What are waiting for? (21st of December 2018) This was an online presentation for the Group By Conference.
TriPASS: Columnstore Indexes, What are we waiting for? (13th of November 2018) This was an online presentation on the Columnstore Wait Stats for the TriPASS User Group.
PASS Summit 2018: Columnstore Clustered vs Nonclustered, when to choose what (6-9th November 2018) – I will deliver the session on the drivers and limitations behind the choice between the Clustered vs Nonclustered Columnstore Indexes.
SQLSaturday Madrid 2018: Columnstore Clustered vs Nonclustered, when to choose what (20th October 2018) I have delivered a session on the drivers and limitations behind the choice between the Clustered vs Nonclustered Columnstore Indexes.
SQLSaturday Madrid 2018: Optimised Analytics: Tune your Data Warehouse with Columnstore Indexes (19th October 2018) I have presented a workshop on working with Columnstore Indexes in the Data Warehouse environment and how to tune them to achieve the maximum performance possible.
SQLSaturday Porto 2018: Graph Databases and Solutions (29th of September 2018) – I have presented a session on Graph databases and possible solutions at SQLSaturday Porto.
SQLSaturday Cambridge: Graph Databases and Solutions (8th of September 2018) – I have presented a session on Graph databases and possible solutions at one of my all-time favourite events – SQLSaturday Cambridge.
SQLSaturday Cambridge: KeyNote (8th of September 2018) – I have helped to kick off this wonderful event by co-presenting the keynote, which focused on the challenge of challenging the marketing materials. :)
TechInPorto: Fast Calculations with Big Amounts of Data (on the Good Old Relational Platform) (14th of June 2018) – I have delivered this brand new session at the Tech In Porto 2018 event. Yes, the Relational Databases are here to stay! :)
Porto.Data: (13th of June 2018) I have delivered a session on the drivers and limitations behind the choice between the Clustered vs Nonclustered Columnstore Indexes.
SQLSaturday Rheinland 2018: Columnstore Clustered vs Nonclustered, when to choose what (9th of June 2018) – I have delivered a session on the drivers and limitations behind the choice between the Clustered vs Nonclustered Columnstore Indexes.
Group By: Columnstore Clustered vs Nonclustered, when to choose what (1st of June 2018) I have delivered a session on the drivers and limitations behind the choice between the Clustered vs Nonclustered Columnstore Indexes.
SQLDay Poland 2018 (14-16th of May 2018) I have deliver a precon on the Columnstore Indexes on the 14th of May and a session Columnstore Clustered vs Nonclustered, when to choose what on the 15th of May 2018. The session was focused on the strategies and scenarios of the one over the other (Clustered vs Nonclustered) Columnstore Index selection for your application and the reasons behind that.
SQLPort 100: Columnstore Indexes: What are we waiting for (21st of April 2018) I have presented a session on the Columnstore Wait stats at the 100th SQLPort event.
SQLPort 99: Columnstore Clustered vs Nonclustered, when to choose what (20th of March 2018) I Have delivered a session on the drivers and limitations behind the choice between the Clustered vs Nonclustered Columnstore Indexes.
PASS Germany in Koblenz: Columnstore Internals (1st of March 2018) I will deliver a 90-minutes session on the Columnstore Indexes Internals and compression methods.
SQLKonferenz 2018: Columnstore Clustered vs Nonclustered, when to choose what (28th of February 2018) The Session on understanding the differences and scenarios of application between Clustered and Nonclustered Columnstore Indexes. This will touch all SQL Server versions since 2012 and including SQL Server 2017.
SQLKonferenz 2018: Columnstore Indexes: Practical Solutions & Techniques (26th of February 2018) I have delivered a workshop on the Columnstore Indexes practical solutions and techniques in German at the biggest SQL Server conference in Germany.
SQLSaturday Vienna 2018: Worst Practices & Less Known Limitations for Columnstore Indexes (19th of January 2018) I gave the last version of the talk I have been giving in 2017 on the Columnstore Indexes worst practices and limitations. Yes, there are new discoveries every month. :)
PASSCamp 2017 (4-8th of December 2017) I have delivered a hands-on the CosmosDB for the DBAs at one of my all-time favourite events in Germany.
24 Hours of PASS in Portuguese 2017 (30th of November 2017) I have delivered a session for the DEVs & DBAs on the CosmosDB.
SQLPort 97th meeting – (28th of November 2017) I have delivered a session on the CosmosDB at 97th SQLPort meeting.
PASS Summit 2017 (31st October – 3rd of November 2017) – Together with Ned Otter, Jos de Bruijn, Kevin Farlee, Bob Ward & Tejas Shah, I have lead a panel discussion on the In-Memory Technology found in SQL Server & Azure SQL Database.
PASS Summit 2017 (31st October – 3rd of November 2017) – Together with Gabi Münster, I will present a 75-minutes session on the differences and advantages of the Columnstore Indexes when compared to the SSAS.
PASS Summit 2017 (31st October – 3rd of November 2017) – I have delivered the first ever full day precon on the Columnstore Indexes.
SQLSaturday Portland 2017: Whats new for Columnstore in SQL Server 2017 (28th of October 2017) – I have delivered a session on the new and unsung features of the SQL Server 2017, that are related to the Columnstore Indexes.
Launch the SQL Server 2017 in Lisbon (30th of September 2017) – I have delivered a session on the new in the BI (SSRS & SSAS) for SQL Server 2017.
Porto.Data User Group (28th of September 2017) – I have delivered a session on the new and unsung features of the SQL Server 2017, that are related to the Columnstore Indexes.
SQLSaturday Madrid 2017: Worst Practices & Lesser known limitations for Columnstore Indexes (23rd of September 2017) I have delivered another updated version of the talk I have been giving in 2017 on the Columnstore Indexes worst practices and limitations.
SQLSaturday Cambridge 2017: Columnstore killed the OLAP-Star? Did it really ? (9th of September 2017) Together with Gabi Münster, I co-presented a 60-minutes session on the differences and advantages of the Columnstore Indexes when compared to the SSAS.
(29th of August 2017) – I did an online session on the Columnstore Indexes anti-patterns for the Central Illinois PASS User Group.
SQLPort 95th Meeting: Lightning Talk on Surprising Topic (22nd of August 2017) – this lightning talk was on the future of the Data Platform and the age of the constant changes.
SQLPort 94: Columnstore Indexes in SQL Server 2017 (25th of July 2017) – I delivered a session on the new and unsung features of the SQL Server 2017, that are related to the Columnstore Indexes.
24 Hours of PASS 2017 Summit Preview: Becoming Proficient with Columnstore Indexes (20th of July 2017) I will give an introductionary session on the Columnstore Indexes for the 24 Hours of PASS 2017 Summit Preview.
SQLSaturday Rheinland 2017: Columnstore Indexes Worst Practices & Limitations (10th of June 2017) SQLSaturday Rheinland 2017. I will present an hour on the worst practices & limitations of the columnstore indexes.
GroupBy Conference: Columnstore Indexes Worst Practices & Limitations (28th of April 2017) At the online conference Group By, I will present an hour on the worst practices & limitations of the columnstore indexes.
SQLBits 2017: Columnstore Indexes Worst Practices & Limitations (8th of April 2017) I will present an hour on the worst practices & limitations of the columnstore indexes.
SQLBits 2017: Columnstore killed the OLAP Star – Did it really? (7th of April 2017) Together with Gabi Münster, I will present a 60-minutes session on the differences and advantages of the Columnstore Indexes when compared to the SSAS.
SQLBits 2017: Columnstore Indexes-the practical solutions (workshop) (6th of April 2017) I will present a whole day workshop at the biggest european Data Platform conference – The SQLBits.
SQLSaturday Portugal Lisbon 2017: Columnstore killed the OLAP Star – Did it really? (11th of March 2017) Together with Gabi Münster, I will present a 60-minutes session on the differences and advantages of the Columnstore Indexes when compared to the SSAS on the main Data Platform conference in Portugal.
SQLKonferenz 2017: Big, Fast und Data-Furious mit den SQL Server R Services (16th of February 2017) Together with Sascha Klein, I will present a 60-minutes session on how to optimise SQL Server performance for the basic R Analysis.
SQLKonferenz 2017: Azure Advantages (16th of February 2017) Together with Patrick Heide, I will present a 60-minutes session on the advantages of using Azure when compared with some of the On-Premises Installations.
SQLKonferenz 2017: Columnstore killed the OLAP Star – Did it really? (15th of February 2017) Together with Gabi Münster, I will present a 60-minutes session on the differences and advantages of the Columnstore Indexes at the biggest German Microsoft Data Platform Conference.
Columnstore Indexes Worst Practices & Limitations (26th of January 2017), at the 27th event of Porto.Data I will be talking and showing the best practices of using the Columnstore Indexes.
Columnstore Technology Improvements in SQL Server 2016 (26th of January 2017) – Join me online for an hour of very exciting session on the Columnstore Indexes in SQL Server 2016.
Taking your InMemory & Op Analytics Apps to Azure SQLDB @ PASS Cloud VC (21st of December 2016) – The session was focusing on how to take advantage of the InMemory & Columnstore offerings in the Azure.
PASSCamp 2016 (6-9th of December 2016) I have delivered 3 new hands-on labs & 1 session at one of my all-time favourite events in Germany:
– Columnstore vs. OLAP together with Gabi Münster (hands-on lab)
– Columnstore mit CISL (hands-on lab)
– What’s new for Developers in SQL Server 2016 & SP1 (hands-on lab)
– What’s new in SQL Server 2016 Service Pack 1 & SQL Server vNext (session)
Columnstore Technology Improvements in SQL Server 2016 (14th of November 2016) – 24 Hours of PASS, Portuguese Language Edition.
PASS Summit 2016 – Columnstore Technology Improvements in SQL Server 2016 (26th-28th October 2016) – An hour of very exciting session on the Columnstore Indexes in SQL Server 2016.
SQLSaturday Munich 2016 – Columnstore Technology Improvements in SQL Server 2016 (8th of October 2016) – this session will be focusing on all new stuff that can be found in Columnstore Indexes in SQL Server 2016.
Columnstore Deep Dive (06th of October) at the brand new Microsoft Germany Offices – full day workshop with deep dive into Columnstore Indexes.
MS Virtuelle SQL Konferenz: Operational Analytics mit SQL Server 2016 (05th of October) online for Microsoft Germany – an explanation of the Operational Analytics with some practical examples.
SQLSaturday Porto 2016 – Hadoop’s Architecture it’s relation to Microsoft Data Platform (1st of October 2016) – The introduction session on Big Data, Hadoop (its distributions, and associated Apache Projects) and their relation & implementation within Microsoft Data Platform.
SQLSaturday Porto 2016 – SQL Server Professional Configuration & Optimisation Workshop (30th of September 2016) – A full day workshop on configuration & optimisation of SQL Server. This is a SQLSaturday #546 Porto 2016 Pre-Conference.
Using CISL for getting the insights on Columnstore Indexes (20th of July 2016) – The session “Using CISL for getting the insights on Columnstore Indexes” session will focus on CISL release 1.3.0 that is supporting SQL Server 2016 RTM.
Hadoop’s Architecture it’s relation to Microsoft Data Platform (19th of July 2016) – The introduction session on Big Data, Hadoop (its distributions, and associated Apache Projects) and their relation & implementation within Microsoft Data Platform.
24 Hours of PASS: Columnstore technology improvements in SQL Server 2016 (25th of May 2016) – Join me for an hour of very exciting session on the Columnstore Indexes in SQL Server 2016.
SQLBits XV (6th of May 2016) The session “Using CISL for getting the insights on Columnstore Indexes” session will focus on CISL … I guess, I have to admit that it will be special :)
SQLBits 15: Columnstore Indexes – from basics to optimised analytics (Precon) (4-7th of May 2016) I will be delivering a full day workshop on the Columnstore Indexes for the biggest european Data Platform conference.
4th PASS Germany SIG Meeting (20th of April 2016) – I have delivered a 90-minutes dive into the Columnstore Indexes & CISL.
SQLKonferenz (23-25 of February 2016): Darmstadt – the biggest German SQL Server Conference. I gave a deep dive session on the Columnstore improvements in SQL Server 2016
SQLSaturday #485, Lisboa 2016 (20th of February 2016) I gave a session on “Getting Started with U-SQL & Azure Data Lake Analytics”
XV Evento Porto.Data (28th of January 2016) I gave a session on “Getting Started with U-SQL & Azure Data Lake Analytics”
LXXVIII Encontro da Comunidade SQLPort (26th of January 2016) I gave a session on “Getting Started with U-SQL & Azure Data Lake Analytics”
SQL Sentry Presents: Columnstore Indexes Improvements in SQL Server 2016 with Niko Neugebauer (9th of December 2015) – This 60 minutes session was focused on the Columnstore Indexes improvements in SQL Server 2016. It will be touching on whole 3 flavours of Columnstore in 2016 – DataWarehousing, Operational Analytics & InMemory Operational Analytics.
PASS Camp 2015, Germany (1-3 of December 2015) – I have delivered a couple :) of sessions, with content ranging from DEV to DBA & BI tracks. SQL Server 2016.
76th SQLPort Meeting (24st of November 2015) – I gave a session focusing on Relational & Engine improvement in SQL Server 2016.
SQLSaturday #459 Madrid 2015 (21st of November 2015) – I gave a session focusing on Columnstore Indexes improvement in SQL Server 2016.
24 Hours of PASS Portuguese 2015 (18st of November 2015) – I have delivered a 75 minutes session on the Understanding and Solving Common Columnstore Problems in Portuguese language.
PASS Summit 2015 (26-30th of October 2015) – I have delivered a 75 minutes session on the Understanding and Solving Common Columnstore Problems.
SQLSaturday #446 Portland 2015 (24th of October 2015) – I have delivered a 75 minutes session on the Understanding and Solving Common Columnstore Problems.
SQLSaturday #429 Porto 2015 (3rd of October 2015) – I did a session focusing on Columnstore Indexes improvement in SQL Server 2016.
Porto.Data Meeting, Porto (1st of October 2015) – I delivered a 60 minutes session on the Columnstore Indexes Revealed. Unedited and unpublished insights, some of which I will not be publishing at all.
SQL Server Days 2015, Belgium (29th of September 2015) – I delivered a 75 minutes session on the Understanding and Solving Common Columnstore Problems.
SQLPort 73th Meeting in Coimbra (24th of September 2015) – I did a 60 minutes session on Columnstore Indexes (2012, 2014 & 2016).
SQLSaturday #411 Cambridge, UK 2015 (12th of Septebmer 2015) – I have delivered a deep dive session on the monitoring and solving Columnstore Problems.
SQLSaturday #411 Cambridge, UK 2015 (10th of September 2015) – Full day workshop with focus on Columnstore Indexes.
NetPonto User Group Meeting (18th of July 2015) – This session at NetPonto community served to explain the basic concepts and functionalities for Operational Analytics with Columnstore Indexes in SQL Server 2016.
In-Memory Operational Analytics In SQL Server 2016 (30th of June 2015) – This session explained the basic concepts and functionalities for In-Memory Analytics with Columnstore Indexes in SQL Server 2016.
Columnstore Indexes (22nd of June 2015) – 2 Hours presentation on Columnstore Indexes for the PASS Germany Munich User Group.
SQLSaturday #409 Rheinland, Germany 2015 (13th of June 2015) – I have delivered a deep dive session on the monitoring and solving Columnstore Problems.
NT Conference 2015 (19th of May 2015): Slovenia – I have delivered an updated version of my session on Understanding & Solving Columnstore Problems for SQL Server 2012 & SQL Server 2014.
SQLSaturday #369 Lisbon 2015 (16th of May 2015) – I did a session on what’s coming for Columnstore in SQL Server 2016.
66th SQLPort Meeting in Coimbra (5th of May 2015) – I have delivered an introduction session on SQL Server Performance Tunning at the very first meeting of SQLPort in the wonderful city of Coimbra.
MVP Showcase 2015 (22nd of April 2015): Lisbon – I have delivered a short session on the past, present and the future of the Microsoft Data Platform at the first edition of the MVP ShowCase Portugal 2015.
SQLBits XIV (4-7 of March 2015): London – I gave 2 sessions – Monitoring & Solving Columnstore Problems & Importing Data into NodeXL.
LXIII Evento da Comunidade SQLPort (24th of February 2015): Lisbon – I have delivered a deep dive session on the monitoring and solving Columnstore Problems.
IV Evento Porto.Data (19th of February 2015): Porto – I delivered a deep dive session on the monitoring and solving Columnstore Problems.
SQLKonferenz (3-5 of February 2015): Darmstadt – the biggest German SQL Server Conference. I co-delivered a deep dive precon + a regular session. Top notch Columnstore stuff guaranteed :)
IT Pro Airlift 2015 – Data Platform (22 of January 2015) Lisbon – I gave a very enhanced version of my ETL for Columnstore session.
PASS Camp 2014 (2-4th of December) – I have given 2 hands-on labs: on Columnstore Indexes (focusing on the Multi-Dimensional Clustering) and introduction analytical lab on NodeXL.
PASS Summit 2014 (4-7th of November) – I have delivered a 75 minutes session on the ETL patterns with Clustered Columnstore.
SQLSaturday #338 Barcelona 2014 (25rd of October 2014) – I did a Deep Dive session on the Clustered Columnstore.
SQLSaturday #341 Port-wine edition Portugal (18th of October 2014) I have delivered a Deep Dive session on the ETL patterns with Clustered Columnstore.
48th SQLPort meeting in Porto (15th of October 2014) – I did an introduction session on the Clustered Columnstore.
Virtual PASS em Portugu̻s (Online, 8th of September) РI did an online Deep Dive session on the ETL patterns with Clustered Columnstore.
SQLSaturday #317 Norway 2014 (30th of August 2014) – I have delivered a Deep Dive session on the Clustered Columnstore.
50th SQLPort Meeting in Lisbon (19th of August) – I delivered a Lightning Talk on the new technologies and Microsoft Data Platform development.
54th SQLPort Meeting in Lisbon (22nd of July 2014) – I did a Deep Dive session on the ETL patterns with Clustered Columnstore.
SQLBits XI (19th of July 2014) – I delivered a session on the ETL patterns with Clustered Columnstore.
SQLBits Full day Precon (17th of July 2014) – I have co-delivered a workshop on the In-Memory Technologies, focusing on Clustered Columnstore.
SQLSaturday #313 Rheinland, Germany 2014 (28th of June 2014) – I have delivering a Deep Dive session on the Clustered Columnstore.
SQLSaturday BI Edition #281 Edinburgh, Scotland 2014 (14th of June 2014) – I have delivering a Deep Dive session on the Clustered Columnstore.
47th NetPonto Meeting (31st of May 2014) – I did an introduction session on SQL Server Performance Tunning at NetPonto User Group Meeting.
50th SQLPort Meeting (20th of May 2014) – I have delivered a session on the Delayed Durability (New Feature of SQL Server 2014).
PASS Business Analytics Conference 2014 (7-9th of May 2014) – I have delivered a session together with Scott Stauffer on the Managing Your Alibi with Social Media. Foursquare, Facebook, Twitter & PowerBI – here we go!
SQLSaturday #267 Lisbon, Portugal 2014 (12th of April 2014) – I have delivered a Deep Dive session on the Clustered Columnstore.
MVP Open Session 2014 Barcelona (22nd of March 2014) – I delivered a session on SQL Server Memory management.
47th SQLPort Meeting in Oporto (13th of March 2014) – I delivered an introduction session on SQL Server Performance Tunning.
SQLSaturday #280 Vienna 2014 (6th of March 2014) – I had delivered a Deep Dive session on the Clustered Columnstore.
SQLKonferenz (10-12 of February 2014): Darmstadt – the biggest German SQL Server Conference. I co-delivered a precon + a regular session. Everything was on the Clustered Columnstore.