SQLSaturday #747 - Timisoara 2018
Event Date: 06/09/2018 00:00:00
Event Location:
- Biblioteca Centrală a Universității Politehnica Timișoara
- Bulevardul Vasile Pârvan 2b, Timișoara, Romania
- Timișoara, Timiș County, 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: Dealing with CosmosDB
Abstract: CosmosDB service is a NoSQL is a globally distributed, multi-model database database service designed for scalable and high performance modern applications. CosmosDB is delivered as a fully managed service with an enterprise grade SLA. It supports querying of documents using a familiar SQL over hierarchical JSON documents. Azure Cosmos DB is a superset of the DocumentDB service. It allows you to store and query noSQL data, regardless of schema. In this presentation, you will learn: • How to get started with DocumentDB you provision a new database account. • How to index documents • How to create applications using CosmosDb (using REST API or programming libraries for several popular language) • Best practices designing applications with CosmosDB • Best practices creating queries.
Speaker(s):
- Mihail Mateev
Track and Room: Application Database Development - Track 2
Title: SQL SERVER - Next station Azure
Abstract: This session will cover the main aspects to start or migrate from an OnPremise model to one of the two architectures available in SQL Server on Azure, providing the keys to select the more suitable environment for our requirements. We will cover:
- Red pill or blue pill SQL Server on Azure VM (IaaS) vs SQL Azure DB (PaaS) Which one?
- Always available. High availability in Azure
- Now what … Best practices and configuration connectivity.
Speaker(s):
- Dragos-Cristian Furdui
Track and Room: Enterprise Database Administration Deployment - Track 1
Title: AD 2018. 2 AM. A Disaster just Began…
Abstract: 2AM. We sleeping well. And our mobile ringing and ringing. Message: DISASTER! In this session (on slides) we are NOT talk about potential disaster (such BCM); we talk about: What happened NOW? Which tasks should have been finished BEFORE. Is virtual or physical SQL matter? We talk about systems, databases, peoples, encryption, passwords, certificates and users. In this session (on few demos) I’ll show which part of our SQL Server Environment are critical and how to be prepared to disaster. In some documents I’ll show You how to be BEST prepared.
Speaker(s):
- Tobias Koprowski
Track and Room: Enterprise Database Administration Deployment - Track 1
Title: SQL Code Smells
Abstract: Can your T-SQL code be improved? Where? And how? Code Smells are indications that your code can be refactored for better design, performance or even better security. In this session we will take a look at as many of them (code smells) as sixty minutes will allow us.
Speaker(s):
- Cristian Lefter
Track and Room: Application Database Development - Track 2
Title: IoT Duel - Cloud vs. on Premises Solutions
Abstract: This talk is a parallel, between IoT solutions, based on premise and systems, build with Microsoft Azure components. The presentation will cover the architecture, technology stack, implementation and best practices. We will consider pluses and deltas in different cases, using both approaches. You will see also many demos, which will help you to build own cloud based or on premises Internet of Things systems.
Speaker(s):
- Mihail Mateev
Track and Room: Application Database Development - Track 2
Title: If a machine can learn, why can’t YOU learn Azure Machine Learning?
Abstract: Are you a DBA or Developer and would like to get started with AzureML the EASY WAY? AzureML isn’t just for “data scientists”… Anyone can use it! And after this session you’ll be using it too… Disclaimer: Sadly, AzureML still can’t predict what’s on your girlfriend’s mind. Nothing ever will.
Speaker(s):
- André Melancia
Track and Room: Application Database Development - Track 1
Title: SQL in GDPR Context
Abstract: The session targets positioning SQL Server in the current GDPR context. Different security functionalities as TDE, Always Encrypted, RLS and Dynamic Data Masking can enhance privacy and address certain GDPR requirements.
Speaker(s):
- Alexandra Ciortea
Track and Room: Enterprise Database Administration Deployment - Track 2
Title: SQL Server 2017 - 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. This will help you troubleshoot query performance at a more deeper level.
Speaker(s):
- Liviu Ieran
Track and Room: Application Database Development - Track 1
Title: How powerful is Power BI?
Abstract: I will walk attendees through some of the Power BI best practices and limitations, when using it in collaboration with SQL SERVER and SSAS.
Speaker(s):
- Laurentiu Codorean-Onea
Track and Room: Application Database Development - Track 2
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 - Track 1
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
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.
Mihail Mateev
Twitter: - mihailmateev
LinkedIn: Mihail Mateev
Contact: https://mmateev.wordpress.com/
Mihail Mateev is a technical consultant, community enthusiast, PASS Regional Mentor for CEE, chapter lead, Microsoft Azure MVP, Microsoft Regional Director. He works as a Senior Solutions Architect at EPAM Systems, focused on Data Platform, IoT and cloud related solutions. He also worked many years like a Technical evangelist in the Infragistics. Last years Mihail was focused on various areas related to technology Microsoft: Data Platform, Visual Studio, ASP.Net, Windows client apps, Data Platform, and Microsoft Azure. Michael also has a PhD in cloud computing area. He is a university lecturer on Smart Homes and Smart Energy IoT Solutions.
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.
Dragos-Cristian Furdui
N/A
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…
Laurentiu Codorean-Onea
I am a data enthusiast that used to manage a Data Team and now I work as a Support Engineer for Microsoft Business Application Platform applications.
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
Mihail Mateev
Twitter: - mihailmateev
LinkedIn: Mihail Mateev
Contact: https://mmateev.wordpress.com/
Mihail Mateev is a technical consultant, community enthusiast, PASS Regional Mentor for CEE, chapter lead, Microsoft Azure MVP, Microsoft Regional Director. He works as a Senior Solutions Architect at EPAM Systems, focused on Data Platform, IoT and cloud related solutions. He also worked many years like a Technical evangelist in the Infragistics. Last years Mihail was focused on various areas related to technology Microsoft: Data Platform, Visual Studio, ASP.Net, Windows client apps, Data Platform, and Microsoft Azure. Michael also has a PhD in cloud computing area. He is a university lecturer on Smart Homes and Smart Energy IoT Solutions.
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.
Tobias Koprowski
Twitter: - @KoprowskiT
LinkedIn: Tobias Koprowski
Contact: http://koprowskit.eu/geek/
Founder of Shadowland Consulting. In January 2015 decided to permanently leave Poland and discover new worlds. Actually settled in Hucknall (The Last home of The Byron Family). Community leader focused on SQL Server, SharePoint, security, collaboration and ITIL, DR, BCM, and SLA. Love licensing stuff.
Microsoft Certified Trainer, freelancer, and consultant. Subject Matter Expert at Microsoft. Member of Microsoft Terminology Community, Friends of RedGate PLUS, PASS, ISSA, ACM and more. Since 1st July 2010 Data Platform MVP. Creator of SQLDAY Conference and Conference CEO 2009-2011. Co-Leader of PASS East Midlands Group. Speaker at group meetings and conferences. STEM Ambassador.
Traveler. Coffee Addicted.
Sponsors
The following is a list of sponsors that helped fund the event: