SQLSaturday #665 - Bucuresti 2017

Event Date: 09/16/2017 00:00:00

Event Location:

  • Microsoft Romania
  • Piața Presei Libere nr. 3-5 Clădirea City Gate
  • Bucuresti, Bucureşti, Romania

PDF of Schedule

This event has completed. All data shown below is from the historical XML public data available.

If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).


This is a list of sessions from the event, based on the schedule in the XML files.

Title: In-Memory Tables –Formula One Performance Unleashed, Part 1

Abstract: Query performance is what it is all about. SQL Server 2014/2016 now has the new in-memory functionality that takes a completely different approach to data access and manipulation. This session will consolidate the relevant information from all these sources so the production DBA/Developer will be able to understand, create, use, maintain, and trouble-shoot in-memory table functionality. This session will also examine several demo scripts showing performance gains using the in-memory tables with and without columnstore indexes over equivalent disk based tables.
This session is all about when and how to apply in-memory tables in a production environment. After this session you will

  1. Understand what in-memory tables are and how to create and maintain them including their limitations
  2. Be able to identify performance gains over equivalent disk back tables
  3. Comprehend the new data monitoring needed for in-memory table


  • Mike Byrd

Track and Room: Application Database Development - Downtown2

Title: IoT Circus – deathmatch oops, datematch :) Power Bi vs Time Series Insights

Abstract: Or how to visualize your data and find insights for beginner IoT developer If you create an IoT solution today, you have a variety of components available to mix and match to make your solution, akin LEGO. You get your hardware and firmware right and you get data from the sensors, now what? Of course, you would like to have, some data visualization easy and fast, and of course you would like to learn something from that data easy and fast. And it would be nice to have the results available on mobile devices, yes, yes easy and fast. Now enter our two titan technologies in a match to the death oops data trying to achieve these goals, you guess it easy fast (and cheap). And we will see them clash, from real hardware, to the big Azure cloud, to mobile devices, trying to outmatch each other.


  • Catalin Gheorghiu

Track and Room: Application Database Development - Cinema

Title: Third Party Tools for SQL Server

Abstract: During of my work in the field (for more than 17 years) I noticed that very few people are aware that SQL Server has a great ecosystem of partners that come with functionality where Microsoft tools don’t do it, or don’t go in depth. Even more, some of the are offered for free and my session will expose as many as possible.


  • Cristian Lefter

Track and Room: Application Database Development - Cinema

Title: SQL XML unleashed

Abstract: This session covers XQuery implementation and XML index performance considerations.


  • Alice-Lavinia Pasare

Track and Room: Enterprise Database Administration Deployment - Cinema

Title: Azure SQL Database - It’s Just SQL Server Without the Headaches, Right?!

Abstract: The Azure SQL Database service’s promise to us is simple: we get the nice features of SQL Server, with none of the management and operations hassle. But is it always that simple? Join this session for an overview about what this service really is, its strengths and weaknesses, and how to get the most bang for your database buck in the real world.


  • Sorin Peste

Track and Room: Cloud Application Development Deployment - Downtown1

Title: Custom Visuals in PowerBI

Abstract: This session will show how to create a custom PowerBI Visual using some basic knowledge about web development and how to integrate it into PowerBI reports or dashboards.


  • Gheorghe-Bogdan SAHLEAN

Track and Room: Analytics and Visualization - Cinema

Title: Embrace the future: Running SQL Server in containers

Abstract: Well, the future is now. Join me in demo heavy session covering SQL server running in containers. Starting from scratch we will go through a complete container implementation.


  • Kaloyan Kosev

Track and Room: Enterprise Database Administration Deployment - Downtown2

Title: PowerBI On-Premises Vs Cloud

Abstract: Microsoft initially released PowerBI online services which had restriction of developing dashboards and reports online only. Then came the PowerBI desktop for easy onsite development including the complex DAX logics.

PowerBI support to SQL Server 2016 Reporting Services is a major breakthrough for any dashboards without any need to host in the Cloud.

In this session, we will explore and compare the features availale on PowerBI Online Services and PowerBI On-prem SSRS 2016. This session also covers the PowerBI Roadmap for both on-prem and cloud solutions.


  • Dr. Subramani Paramasivam

Track and Room: Analytics and Visualization - Downtown2

Title: SQL Server migration

Abstract: Best practices and recommendations for SQL Server migrations.


  • Andrada Nastasie

Track and Room: Enterprise Database Administration Deployment - Downtown1

Title: SQL Server 2016 - Understanding Statistics

Abstract: When analyzing Query plans understanding statistics and what role they play is a very important part. The session will be mostly demo based and will show you how to interpret the stats histogram and how SQL estimates the rows returned from a given table. It will also include a demo of the new query profile dmv.


  • Liviu Ieran

Track and Room: Application Database Development - Downtown1

Title: Distributed Availability Groups

Abstract: In this session we will look into detail behind the feature “Distributed Availability Groups”. We will cover not only the advantages but also common issues encountered during the implementation and administration of the distributed availability groups.


  • Octavian Cretu

Track and Room: Enterprise Database Administration Deployment - Downtown1

Title: Graph tables in SQL Server 2017

Abstract: SQL Server 2017 adds new features for storing data regarding graphs. In this session we will explore some of the details behind the implementation of these features, the advantages and drawbacks of the current implementation and evaluate the performance of various graph queries.


  • Razvan Socol

Track and Room: Application Database Development - Downtown2


This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

Kaloyan Kosev

Twitter: - https://twitter.com/nosqltillcoffee

LinkedIn: Kaloyan Kosev

Kaloyan Kosev is a SQL Server expert working with enterprise companies for the last 9 years. His daily work routine is a mixture of troubleshooting bugs and issues, consulting and advising clients and presenting to students. Within his free time he is trying to balance between SQL and x-sports.

Andrada Nastasie

I am working for Microsoft Romania as a Premier Field Engineer since September 2015. My areas of interest are SQL Server High Availability solutions, Security and Configuration. Before Microsoft, I worked as a Database Administrator for 2 years in the banking environment. I studied Computer Science at the Polytechnic University of Bucharest.

Sorin Peste

I am a Technical Evangelist @ Microsoft and passionate about all things software development.

Alice-Lavinia Pasare

Cristian Lefter

LinkedIn: Cristian Lefter

Cristian Lefter is Principal of Esential Training and one of the SQL Server MVPs. His primary competence is training. He is also a consultant, author, speaker and community leader. As his main expertise is Microsoft SQL Server, which resulted in founding an official PASS chapter, writing books and articles, contributing at the development of Microsoft Official Courseware, authoring certification exams, speaking at technical events and working as a Subject Matter Expert in various projects.

Razvan Socol

LinkedIn: Razvan Socol

Software architect, database designer and application developer for business software, having more than 15 years of experience with Microsoft SQL Server. Former SQL Server MVP (July 2007-June 2010)

Mike Byrd

Twitter: - ByrdNest_TX

LinkedIn: Mike Byrd

Contact: http://logicalread.solarwinds.com/?s=byrd, www.TSQLMentoring.com and SQLServerCentral.com

Former rocket scientist and USAF Fighter Pilot – now a SQL Server geek (24 years)! Past opportunities include free-lance technical writer for PC Magazine, Senior Software Manager for government sponsored munitions effectiveness committee, and insurance company CTO. Currently senior database engineer consultant for several Austin companies.

Presenter at many SQLSaturdays over last 6 years in United States, Europe, and Australia.

Specialize in SQL Server performance tuning; database (OLTP OLAP) architecture; trouble-shooting; teaching TSQL (Basic through Advanced).

Video presentations (for local SQL Server user groups or SQLSaturdays) can be found at http://usergroup.tv/videos/category/speaker/mike-byrd

Catalin Gheorghiu

Twitter: - MrSmersh

LinkedIn: Catalin Gheorghiu

Contact: http://ronua.ro/author/catalin/

Catalin Gheorghiu is a solution architect from Romania. He has more than 15 years of experience in developing solutions, especially on Microsoft technologies in very demanding environments. Is contributing articles and blogs to several user groups (MrSmersh), lecturing all over Romania and abroad, is also RONUA Timisoara (PASS Chapter) user group leader. Since 2011, every year he was awarded the Microsoft MVP Award.

Dr. Subramani Paramasivam

Twitter: - https://twitter.com/dageop

LinkedIn: Dr. Subramani Paramasivam

Contact: http://www.yoursqlman.com/index.php/blogs

Dr.SubraMANI Paramasivam is a Microsoft MVP, PhD, Microsoft Certified Trainer and Head of Data AI at DAGEOP Ltd having 21 years of DB, BI, Analytics and AI experience. Mani has also spoken in various events like MS IGNITE, PASS Summit, MS Inspire, SQLBITS, Power Platform Summit, Global AI Bootcamp, Data BI Summit, SQLRelay, Power BI World Tour, Data Platform Summit, INSIDESQL UK, Global AI Nights, SQLServerGeeks Summit, MCT Global Summits, Data Day Events and various user group events. Mani also believes in Empowering Every Person in the planet and spreads the awareness on Global challenges via www.EmpoweringEveryPerson.com. He is also a co-owner of 1 Global AI Meetup and 3 Power BI PUG PASS local / user groups.

Gheorghe-Bogdan SAHLEAN

Twitter: - https://twitter.com/bsahlean

LinkedIn: Gheorghe-Bogdan SAHLEAN

Contact: http://aboutsql.net

Yet another SQL Server enthusiast

Liviu Ieran

Twitter: - @Liviu_Ieran

LinkedIn: Liviu Ieran

More than 9 years of SQL Server experience working for Microsoft currently as a Support Escalation Engineer. My main area of expertise is SQL Server Performance where I helped optimize numerous query’s and environments.

Octavian Cretu

Database Administrator, Database Developer, former Support Escalation Engineer at Microsoft


The following is a list of sponsors that helped fund the event:

Back to the SQLSaturday Event List

Back to the home page