For my first “dbi visit”, I went to Darmstadt, in Germany, to attend SQL Konferenz 2019.

There were more than 50 sessions over two days (20 & 21.02.2019) in several areas as SQL Administration, BI, DevOps, Azure & BigData.

I decided to write a short glimpse of the most appreciated sessions.


To start this event, they introduced the German SQL Server community ( and the upcoming meetings this year, the well-known people are present on stage. Let’s say this year we celebrated the 15th anniversary of this conference.

The next dates
The next dates


Afterward, The organization team prepared a small staging based on “Back to the SQL Future”, the evolution of SQL Server over the years:

Dr Emmett Brown & Marty McFly is back
Dr Emmett Brown & Marty McFly are back


Next, there were a lot of talks about the Azure Cloud and PowerBi, including a demo of Azure Data Factory.

And to finish the keynote, Kusto Explorer was presented through a funny demo. Kusto Explorer is a program that allows to explore your data with a SQL style syntax light version, and to create results with graphs, quickly and easily, focused on BigData.

See details on Microsoft website

Explore your data
Explore your data


Azure Managed Instance

This session was presented by  Björn Peters, who listed the main traditional recurring tasks of a DBA: Backup, ETL, Monitoring, Patching, Reorgs Rebuilds, DBCC CheckDB. These tasks are greatly simplified today in Azure and shows us the functions available in Azure Managed Instance:

  •  Data migration: Native backup/restore
  • Security: Azure AD, TDE, SQL Audit, Dynamic Data Masking
  • Programmability: Global temp tables, Linked servers, CLR module
  • Operational: DMVs & XEvents, Query Store, DB Mail
  • Scenario enablers: Service Broker, Transactional Replication

Azure Data Studio – The new Kid in Town

Presented by Frank Geisler, a member of the community

This is a new tool to manage our databases, not intended to replace SSMS, but more like a new tool more oriented towards Dev or DevOps.

  • Multi-platform: Windows, Mac & Linux
  • Based on a Visual Studio Code fork
  • A modern architecture
  • For developer and DBA
  • Extensions
    • SQL Server Agent
    • SQL Server Import
    • Server Reports
    • WhoIsActive
ADS will kill Microsoft SSMS?
ADS will kill Microsoft SSMS?


I invite you to test Azure Data Studio => Download here

Frank’s podcasts =>

SQL Agent in the cloud

this session was presented by Sam Cogan, As you know the SQL Agent doesn’t exist in Azure SQL and we have 3 alternatives:

  • Azure SQL Elastics Jobs
  • Azure Automation
  • Azure Functions
You have the choice
You have the choice


Trends in databases

It was a presentation about popular databases stats, based on the following website =>

SQl Server VS Oracle?
SQL Server VS Oracle?


After: 15th anniversary

An evening was organized with meals, animations and games to win prizes.

We played "Bingo Monsters"
We played “Bingo Monsters”


Finally, it was a good opportunity to meet some people, who know dbi services but in the context of the DOAG 😉

Thumbnail [60x60]
Microsoft Team