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
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: 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
- Understand what in-memory tables are and how to create and maintain them including their limitations
- Be able to identify performance gains over equivalent disk back tables
- Comprehend the new data monitoring needed for in-memory table
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- Cristian Lefter
Track and Room: Application Database Development - Cinema
Title: SQL XML unleashed
Abstract: This session covers XQuery implementation and XML index performance considerations.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- Dr. Subramani Paramasivam
Track and Room: Analytics and Visualization - Downtown2
Title: SQL Server migration
Abstract: Best practices and recommendations for SQL Server migrations.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- Razvan Socol
Track and Room: Application Database Development - 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.
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
Sponsors
The following is a list of sponsors that helped fund the event: