SQLSaturday #805 - Bucuresti 2018

Event Date: 10/06/2018 00:00:00

Event Location:

  • Microsoft Romania
  • Piața Presei Libere 3-5
  • 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).


Sessions

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


Title: The Road to The Autonomous Databases

Abstract: Autonomous means capable of existing independently. Think maintenance free, self-healing, auto-tuning databases able to detect and automatically mitigate security risks. Sounds like impossible dream, but here is the best part - Azure is gradually making that next level of automation possible. Cloud economy of scale combined with unique features of Azure Sql PaaS resources transform and enhance the way we collect, store and process data. And that also affects our professional lives. Find out where we are on The Road to The Autonomous Databases, what are main building blocks, what kind of obstacles we still have to overcome and how to turn these challenges into opportunities.

Speaker(s):

  • Janusz Rokicki

Track and Room: Strategy and Architecture - Cinema


Title: PowerBI: From Zero to Hero

Abstract: Starting from the very beginning, in this session we will cross together the main features Power BI has to offer, starting with the powerful self-service ETL using M language when needed, modeling our tables and finally using powerful features to create a great data visualization, allowing you to better understand all the power and flexibility of this tool and how it will fit into your solution

Speaker(s):

  • Dennes Torres

Track and Room: BI Information Delivery - Cinema


Title: Azure SQL Database Managed Instance - Finally, SQL Server with None of the Headaches

Abstract: Ever since Azure SQL Database was released way back in 2010, if you wanted to get SQL Server as cloud managed database service, you had to accept some compromises. SQL Server’s cloud-born cousin came with missing features and different ways of doing things, some of them better, others just different, and still others came with specific caveats. But now, with the introduction of Managed Instance, we might have finally found our database holy grail: full-on SQL Server, as a service, with none of the management headaches. Could it really be that simple? Come to this session and find out.

Speaker(s):

  • Sorin Peste

Track and Room: Application Database Development - Downtown1


Title: Building low-cost back-end app services with SQL Express and .Net Core on Linux

Abstract: Learn how to leverage the latest SQL and .Net Core offerings to develop and deploy low-cost (including potentially license free), effective back-end application services on contemporary Linux platforms.

This session will provide an overview of challenges and opportunities, notably including:

  • migrating existing SQL databases to Linux platforms
  • working with Entity Framework (EF) Core
  • simplified webAPI development on .Net Core with EF Core and SQL

Speaker(s):

  • Peter Willmot

Track and Room: Application Database Development - Downtown1


Title: Working with SQL Managed Data Types

Abstract: The Geospatial and Hierarchical managed data types were introduced with SQL 2005 but are sadly seldom used (or understood) by most developers more than a decade later. In this session Peter Willmot will take you on a guided tour of these data types and help you to understand the pros and cons of their inclusion in your database/application design.

Speaker(s):

  • Peter Willmot

Track and Room: Application Database Development - Downtown2


Title: “SQL-like” or query languages in Azure IoT

Abstract: If you are reading Azure IoT documentation you will stumble a lot on the “SQL-like query language” or “SQL-like language” syntagms. In this presentation we will explore Azure IoT places where queries are used and see how to use them. And in the process to find out more about this “SQL-like” languages and how being a DB developer cam make you a IoT hero. We will concentrate on the scenarios with the greatest impact, where a little SQL can solve you a lot of hassle. So, we will leave no SQL query unturned in Azure IoT Hub, Stream Analytics, Power Bi to name a few.

Speaker(s):

  • Catalin Gheorghiu

Track and Room: Application Database Development - Downtown1


Title: SQL vNext: What’s next?

Abstract: We will discuss the features under devopment in the upcoming release of SQL Server

Speaker(s):

  • Alexandra Ciortea

Track and Room: Strategy and Architecture - Downtown2


Title: S (tudent) QL - SQL Server guide for students

Abstract: As a student, how can SQL Server help with university projects or personal tech hobbies? In the session we will talk about how SQL Server can help you learn, integrate it in your university projects, and many more.

Speaker(s):

  • Ozana Buse

Track and Room: Application Database Development - Downtown2


Title: Thinking out of the Box! - SMB 3.0

Abstract: In this session the SMB 3.0 protocol will be presented and how we can take advantages and increase the availability and performance of the environment by investing less in infrastructure.

Speaker(s):

  • Marcelo Fernandes

Track and Room: Strategy and Architecture - Downtown2


Title: The hidden power of Power BI or what we can do using Power BI REST API

Abstract: Power BI is a very powerful tool. But behind the shiny UI, Power BI REST API gives you even more features to create better solutions! In this session we will explore what you can do using Power BI REST API and what you can’t (at least not yet!). I will demonstrate how your program can authenticate itself (both in interactive and non-interactive way), how it can add new rows to a dataset or refresh it programmatically, and how to share one dataset between multiple reports.

Speaker(s):

  • Andrey Nikolov

Track and Room: Application Database Development - Cinema


Title: Upgrading to a newer SQL Server version: Tip, Tricks, Issues

Abstract: Considering a SQL Server upgrade or migration? You’ll have to eventually. In the session, we will try to present you some best practices regarding the SQL Server version upgrade and the roadblocks that you might hit along the road.

Speaker(s):

  • Alexandru Dinica

Track and Room: Enterprise Database Administration Deployment - Downtown1


Title: SQL Server - Performance Basics

Abstract: Discover and learn how to approach a performance problem. What information should I collect? What data should I gather? How to best approach the data analysis. Tips and tricks.

Speaker(s):

  • Liviu Ieran

Track and Room: Enterprise Database Administration Deployment - Cinema


Title: Data Storytelling

Abstract: Behind the data, behind the numbers, there is a hidden story and sometimes more. Our job is to discover the story and make it accessible to others.

Speaker(s):

  • Cristian Lefter

Track and Room: Analytics and Visualization - Downtown1


Title: How to build solution for High Availability/Disaster Recovery

Abstract: How does your SQL Server environment meet the RPO and RTO service levels? In this session, we will cover all aspects of HA / DR. We will cover all technology options and compare the benefits between them. We will also talk about processes to maintain your RPO and RTO level.

Speaker(s):

  • Marcelo Fernandes

Track and Room: Strategy and Architecture - Downtown2


Speakers

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

Dennes Torres

Twitter: - Dennes

LinkedIn: Dennes Torres

Contact: https://www.red-gate.com/simple-talk/author/dennes-torres/

Dennes Torres is a Data Platform MVP with more than 25 years of experience in the IT area. He improves Data Platform Architectures and turns data into knowledge. As a Brazilian living in Malta, Dennes works as a software developer and leads the Malta MDP User Group. Having the MCSE Data Platform, Business Intelligence, and Microsoft Certified Trainer (MCT) certifications, Dennes has been in love with database servers since he was introduced to SQL Server 6.5, more years ago than he would like to admit.

Janusz Rokicki

Twitter: - DataSic

LinkedIn: Janusz Rokicki

Contact: https://www.datasic.com/

Microsoft Data Platform Expert and certified Azure Solutions Architect with over 12 years’ experience working in the City of London in the Financial Services Industry (retail and investment banking, multi-asset class trading systems). He has passion for secure, high-performance, maintainable data-driven applications that can be deployed with confidence on-premises and in-cloud. With educational background in intelligent sensor networks and machine learning he is always in search of automation and optimisation opportunities.

Has presented at SqlBits, PASS Summit, SqlDay and multiple SQLSaturday events (Tel-Aviv, Kiev, Paris, Tallinn, Bonn, Bratislava, Goteborg, Kharkiv, Bucharest, Sofia, Ljubljana) and user groups.

Marcelo Fernandes

Twitter: - marcelodba

LinkedIn: Marcelo Fernandes

Contact: http://marcelodba.wordpress.com

Marcelo Fernandes is SQL Server MVP and has 12+ years experience with databases, specialized in High Availability, critical missions and very large databases. He holds the MCP / MCDBA / MCSA / MCTS / MCITP and MCT certifications, he lives and works in Berlin for an American e-commerce company that sells home goods. He share their knowledge through webcasts, presentations and articles on Microsoft technologies and can be cantacted by email fernandes_dba@hotmail.com or twitter @ marcelodba

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.

Peter Willmot

Peter has been writing software (and teaching folk how to write software) for over 30 years. He has worked with SQL Server as an architect and developer for more than 20 years (since SQL 4.2) and has also worked extensively with the .Net and various other development platforms.

Peter is a past MSDN Regional Director and was also an MVP (SQL Server and Architecture) for many years. He is a passionate and regular speaker and various industry events around the world.

Ozana Buse

I am Support Engineer SQL Server Core, at Microsoft, and at the same time a student. I am passionate about learning new things and teaching others.

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

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.

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.

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.

Alexandru Dinica

I am passionate about the latest trends in the technology world and in my free time I like to travel a lot, meet new people and form long-lasting bonds.

Sorin Peste

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

Marcelo Fernandes

Twitter: - marcelodba

LinkedIn: Marcelo Fernandes

Contact: http://marcelodba.wordpress.com

Marcelo Fernandes is SQL Server MVP and has 12+ years experience with databases, specialized in High Availability, critical missions and very large databases. He holds the MCP / MCDBA / MCSA / MCTS / MCITP and MCT certifications, he lives and works in Berlin for an American e-commerce company that sells home goods. He share their knowledge through webcasts, presentations and articles on Microsoft technologies and can be cantacted by email fernandes_dba@hotmail.com or twitter @ marcelodba

Peter Willmot

Peter has been writing software (and teaching folk how to write software) for over 30 years. He has worked with SQL Server as an architect and developer for more than 20 years (since SQL 4.2) and has also worked extensively with the .Net and various other development platforms.

Peter is a past MSDN Regional Director and was also an MVP (SQL Server and Architecture) for many years. He is a passionate and regular speaker and various industry events around the world.

Sponsors

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

Back to the SQLSaturday Event List

Back to the home page