SQLSaturday #915 - Bucuresti 2019

Event Date: 10/05/2019 00:00:00

Event Location:

  • Impact Hub Bucharest, Bucharest
  • Splaiul Unirii 165 Timpuri Noi Square, clădirea 2, etaj 1 București 030133 Romania
  • Bucharest, Bucharest, 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: T-SQL Performance Guidelines for the optimal DB stress powers

Abstract: To reach your desired business functionalities, it can be easy using some common T-SQL practices like MTVF , scalar functions , Temp tables, Union…etc and they might perform pretty well on development server coz neither adequate stress of users nor adequate volume of data exist there but actually they seem totally strange once going to live where they become performing badly ending up eventually with and sharp skew of performance and standstill cases sometimes , this is due to the lack of stress powers of T-SQL codes which should be considered largely for critical mission DBs in particular more therefore I am going to talk to you about How to capture expensive queries using different techniques ..?and How to optimize them in the shortest time using scientific ways ..? (10 different T-SQL Practices will be explained within this session)


  • Shehab El-Najjar

Track and Room: Application Database Development - San Francisco

Title: Azure Data Explorer - Fast and highly scalable interactive analytics

Abstract: Azure Data Explorer is one of the newest offerings from Microsoft which went GA on the 7th of February. I am going to provide an overview of Azure Data Explorer, an interactive analytics service that will enable you to ask the questions on real time data. You can find answers in rapidly changing data generated by systems such as applications, websites, and IoT devices – anything really that generates volumes of streaming data that has potential to uncover a number of unknowns.


  • Liviu Ieran

Track and Room: Cloud Application Development Deployment - Viena

Title: BI Powers - The A.I. Who Tagged Me

Abstract: So everyone knows how to make some nice graphs in Power BI from Excel or SQL Server… But what about getting “intelligent” results from unusual data sources? Disclaimer: A.I. will eventually take over the world. Unlike Doctor Evil, it won’t ask for a ransom.


  • André Melancia

Track and Room: Analytics and Visualization - San Francisco

Title: Handling JSONs in SQL Server

Abstract: Consuming data from JSON is now much easier with the new built-in support introduced in SQL Server 2016. During this session will talk about JSON representation and will explore the new functions used for handling the content from a JSON file. Based on some examples we’ll transform a JSON text to relational table and then will export some data from SQL Server as JSON.


  • ILIE Mugurel

Track and Room: Application Database Development - Viena

Title: SQL Server 2019 on Linux - What’s new?

Abstract: OS supported by SQL Server 2019 Presenting SQL Server on Linux 2019 and it is new features, things to have in mind when installing, running. Advanced security features, Big data clusters, Data virtualization - the opening to open source source databases


  • Gabriel Petrescu

Track and Room: Professional Development - Viena

Title: What I have seen so far in my performance tuning audits

Abstract: In the last ten years, I have audited many SQL Server databases, for performance tuning. And I have encountered the same problems again and again. Let’s call them SQL Server antipatterns. This session is designed to show you what those antipatterns are, and how to avoid them once and for all.


  • Rudi Bruchez

Track and Room: Application Database Development - San Francisco

Title: Embedding Power BI in your application

Abstract: Power BI is great tool and reports we made are always beautiful and catchy, right? But sometimes forcing users to open their browser to go to Power BI Service web site isn’t so nice. In this session we will explore the various ways to embed Power BI reports, dashboards and tiles. We will learn what is needed to do this, what it will costs us (can we do it for free?) and what architecture decisions must be taken to build an embedded solution.


  • Andrey Nikolov

Track and Room: Application Database Development - San Francisco

Title: Big Data Clusters: SQL Server 2019 Meets Big Data

Abstract: With the new Big Data Clusters feature in SQL Server 2019, you can store and reason over mountains of data, structured and unstructured, using both Transact-SQL and Apache Spark, a proven Open Source big data processing engine. You can dynamically scale-out your compute power by adding nodes, independently from the distributed storage (HDFS), to support your analytic workloads. You can also bring the power of Spark’s Machine Learning library to build predictive models and operationalize them right inside SQL Server. And everything is running in containers and being orchestrated by Kubernetes. Come to this session to see what the Big Data future looks like for SQL Server.


  • Sorin Peste

Track and Room: Application Database Development - Viena

Title: SQL Managed Instance - From the ground to the cloud

Abstract: The session focuses on migrating SQL onprem databases and objects hosted outside the database context to SQL MI . We will take a look at the migration life cycle and modernization best practices. We’ll share stories and learnings from the field including our most common scenarios in the context of SQL 2008 end of support.


  • Alexandra Ciortea

Track and Room: Enterprise Database Administration Deployment - San Francisco

Title: Dataism

Abstract: The story of Dataism begins with David Brooks that used in the New York Times in 2013. Dataism is a term that has been used to describe the mindset or philosophy created by the emerging significance of Big Data. More recently, the term has been expanded to describe what social scientist Yuval Noah Harari has called an emerging ideology or even a new form of religion, in which ‘information flow’ is the ‘supreme value’. What is the impact of Dataism in our life? Let’s discover that together!


  • Cristian Lefter

Track and Room: Strategy and Architecture - San Francisco

Title: Running Microsoft SQL Server on Amazon Web Services

Abstract: Amazon Web Services (AWS) has multiple ways to host and support Microsoft SQL Server. This session will review the Relational Database Service (RDS) offering of Microsoft SQL Server as well as using our virtual machine service (Elastic Compute Cloud, or EC2) to host SQL Server database services. We will review options for security, availability, and reliability operations in both offerings and how to choose the optimal solution for your existing and new SQL Server workloads.


  • Dragos Madarasan

Track and Room: Cloud Application Development Deployment - Viena

Title: ML on the Edge

Abstract: Or options in running TensorFlow on Pi or similar class devices. My idea was (a bit born from need), to run TensorFlow on Pi class device. And this presentation is born from my adventures, showing pro and cons of each approach. From running directly on Pi to Azure IoT Edge on to Intel Neural Stick, and the list most probably is in “works” you will see the challenges and results of implementing TensorFlow using these technologies. Remark: Kinder chocolates have nothing to do with ML but will be present.


  • Catalin Gheorghiu

Track and Room: BI Platform Architecture, Development Administration - Viena


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

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.

Andrey Nikolov

Andrey is MCSA for SQL Server 2012/2014 with almost 20 years of experience in designing and implementing applications for Windows. He is working with various database platforms, but SQL Server is his favorite. He is also a leader of Plovdiv Power BI User Group and active member of local .NET, Power BI and SQL Server communities.

André Melancia

Twitter: - AndyPT

LinkedIn: André Melancia

Contact: http://Andy.PT

Owner / Principal Consultant at LunarCat.PT Microsoft Certified Trainer (MCT) focusing on SQL Server, Azure, IoT and Security.

19+ years’ fun developing information and multimedia systems, DBA, project and IT management.

Data Community Portugal, IT Pro Portugal and PowerShell Portugal communities organiser. IPv6 Portugal, DNSSec Portugal and Windows Development Portugal online communities moderator. Actively volunteering, organising, speaking or just participating at community meetings and events around the world.

Proud uncle and food devouring expert, with dangerous рuϧϧy cat as companion.

Go to http://Andy.PT and you’ll know the same as the NSA…

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.

Shehab El-Najjar

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

LinkedIn: Shehab El-Najjar

Contact: http://sqlserver-performance-tuning.net/

Shehab El-Najjar was the ONLY Microsoft SQL Server MVP in Gulf for the past 6 years and the 2nd one all over the Middle East , he is the founder of SQL Gulf events series (SQL Gulf #1 , #2 and #3 ) where he spent so much time and efforts to broadcast Microsoft SQL Server technologies all over the Gulf such as KSA and Emirates and other Gulf cities ahead ..)

 He is now Professional Services Manager at Saudi Emircom

 He was previously COO and business leader in KSA market through his startup WAJA IT for 3 years

 He is an influencing Database community leader all over the region  A senior Database Consultant (SQL Server MVP for 6 years in row) -The 2nd MVP awardee SQL Server all over Middle East and Arabic region

Gabriel Petrescu

LinkedIn: Gabriel Petrescu

Experienced professional on Windows and Linux servers, virtualization, hardware and open source technologies. Many years of experience on open source database with a special interest on SQL Server Performance and Always On issues as long as SQL Server on Linux.

Sorin Peste

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

Dragos Madarasan

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

LinkedIn: Dragos Madarasan

Contact: https://dragos.madarasan.com/

Solutions Architect at Amazon Web Services, where he works with companies and their partners in Central and Eastern Europe by transforming their enterprise IT landscape and helping them design reliable, cost-effective cloud architectures. Dragos works with clients to assess their infrastructure and application portfolio while developing a shared vision, leading the customer and partner over the technical and business hurdles of cloud adoption. Before joining Amazon, he worked for Endava and Emerson and is an alumni of the Technical University of Cluj-Napoca.

Alexandra Ciortea

2005-2009 Computer Science - Polytechnic University of Bucharest 2009-2011 - Master -IT Management - Polytechnic University of Bucharest

I started working for Microsoft in 2009 as a Support Engineer for Project Server and SQL Server for EMEA. In 2012 I changed to a Premier Field Engineer position working onsite for SQL Server and Project Server

Rudi Bruchez

Twitter: - nepasderanger

LinkedIn: Rudi Bruchez

Contact: http://www.babaluga.com/

(same as before)

ILIE Mugurel

Data warehouse developer on MS SQL Server

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.


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

Back to the SQLSaturday Event List

Back to the home page