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
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: