SQLSaturday #874 - Timisoara 2019
Event Date: 06/08/2019 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: Data Overview and Manipulation – T-SQL, R, Python
Abstract: In a real data mining or machine learning project, you spend more than half of the time on data preparation and data understanding. The R language is extremely powerful in this area. The Python language is a match. Of course, you do work with data by using T-SQL. You will learn in this session how to get data understanding with really quickly prepared basic graphs and descriptive statistics analysis. You can do advanced data preparation with many data manipulation methods available out of the box and in additional packages from R and Python. After this session, you will understand what tasks data preparation involves, and what tools you have in SQL Server suite for these tasks.
Speaker(s):
- Dejan Sarka
Track and Room: AIML Architecture, Development Administration - R1
Title: When Things go Wrong - Error Handling in SQL Server
Abstract: In an ideal world, we would not need any error handling, because there would be no errors. But in the real world we need to have error handling in our stored procedures. Error handling in SQL Server is a most confusing topic, because there are such great inconsistencies. But that does not mean that we as database developers can hide our head in the sand.
This presentation starts with a horror show of the many different actions SQL Server can take in case of an error. We will then learn how should deal with this - what we should do and what we should not and that with SET XACT_ABORT we get better consistency. We will learn how TRY-CATCH works in SQL Server, and we will get a recipe for how to write CATCH blocks. More generally, we will learn why it pays off to be simple-minded to survive in this maze. The session mainly looks at traditional T-SQL code, but the session ends with a quick look at natively compiled stored procedures, where everything is different.
Speaker(s):
- Erland Sommarskog
Track and Room: Application Database Development - R2
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)
Speaker(s):
- Shehab El-Najjar
Track and Room: Application Database Development - R2
Title: How to be polite with databases when going serverless
Abstract: Like it wasn’t enough that just anyone could use an ORM and start molesting a database, nowadays just anyone can use serverless and communicate with a database… and use ORM… First of all, we’re gonna focus on how to communicate with a database from your serverless system presuming that there aren’t any parallel requests to the database. In that way, we’ll first polish cold starts, memory/CPU consumption, and basically everything we need to worry about now when we’re not running our code on servers with 10+ cores, and tens of GB of RAM. Once we’re done with the first task, we’ll end up with something that can quickly and effortlessly communicate with our database. Which is perfect, except in cases where we handle thousands or more of parallel requests to the database which isn’t scalable as serverless is. That brings us to our second task- making sure our serverless system won’t DDoS our databases :) Come and find out how to approach this problems ;)
Speaker(s):
- Ivan Čuljak
Track and Room: Cloud Application Development Deployment - R3
Title: Lightning-fast management of cloud and legacy databases, breaking vendor lock-in
Abstract: With the infrastructure increasingly moving to the cloud, developers are stuck with legacy tools, suboptimal for the new workflows. Current reality is slow and unreliable web applications bundled using Electron - or native applications that look like they are made 20 years ago. We have started from scratch, imagining the ideal database manager for modern times. UI responds to your actions in less than 0.1 seconds and your data stays in the cloud. Connection switching is instant and the workspace is preserved between devices and application restarts. A sneak peek - state of the art SQL code translation solution - removing vendor lock-in. This is a work-in-progress report, detailing why it’s so hard to get right and why does it take so long to make something seemingly simple - not a sales talk, not a self-congratulatory talk.
Speaker(s):
- Damir Bulic
Track and Room: Cloud Application Development Deployment - R3
Title: Successfully Virtualizing SQL Server on vSphere - Straight from the Source
Abstract: Over the years, virtualization has matured from the exotic black magic realm to become a mainstream standard IT practice. quot;Virtualize Firstquot; is now a well-accepted default practice in most enterprises and any deviation is now considered an anomaly. In spite of this trend, many IT administrators and architects still have some reservations about virtualizing SQL Server workloads. They consider SQL too quot;criticalquot; to be virtualized; they wonder and worry about scale about performance; they are looking for guidance and reassurance. If this is where you (or your clients) are today, be sure to attend this session. You will gain valuable insights from what others have done to successfully undertake similar tasks in their environments. We will talk about configuration pitfalls to avoid and also review the configuration and current performance data for some of the most demanding applications in customers environments. Got an SQL virtualization or performance question? Bring i
Speaker(s):
- Deji Akomolafe
Track and Room: Cloud Application Development Deployment - R2
Title: SQL Server Data Science: Python or R?
Abstract: SQL Server 2016 brought support or the R language. SQL Server 2017 added a new language to the list, the Python language. Both languages target advanced analytics scenarios, popularly known as data science. For a SQL Server professional who wants to move in the data science area, the first question is which language to choose. In this presentation, you will learn basics about both languages. We will try to solve the same problem with both languages. This way, through demos with a lot of explanation, you will realize the most important differences between the two competing languages. You will understand which one is more appropriate for you to start with.
Speaker(s):
- Dejan Sarka
Track and Room: AIML Architecture, Development Administration - R1
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.
Speaker(s):
- André Melancia
Track and Room: AIML Architecture, Development Administration - R1
Title: Encryption in SQL Server
Abstract: An application that you administer stores sensitive data in the database and you would like to keep them safe in Microsoft SQL Server - how to approach this issue? What type of encryption should you use in your environment? On the session I will walk through available options in Microsoft SQL Server and show when to use encryption, how to identify threats, and countermeasure them by using options like Transparent Data Encryption, SSL certificates, Always Encrypted, etc. After this session, you will know a set of best practices that you can apply in your environment.
Speaker(s):
- Michal Sadowski
Track and Room: Application Database Development - R2
Title: SQL Managed Instance - From the ground to the cloud
Abstract: The session presents SQL MI features and different tiers. We will also focus on lift and shift SQL onprem databases and objects hosted outside the database context to SQL MI . This also covers common issues, solutions and workarounds from various migration projects.
Speaker(s):
- Alexandra Ciortea
Track and Room: Cloud Application Development Deployment - R3
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.
Speaker(s):
- Dragos Madarasan
Track and Room: Cloud Application Development Deployment - R3
Title: Handling JSONs in SQL Server 2016
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.
Speaker(s):
- ILIE Mugurel
Track and Room: Application Database Development - R2
Title: Visual Studio productivity
Abstract: Visual Studio is an excellent tool, praised by many as the best IDE there is. One of the important things that Visual Studio provides is productivity. Besides a plethora of built-in features, even more functionality can be added through extensions. This presentation is a short overview of some integrated features as well as a look into some extensions that improve productivity.
Speaker(s):
- Miroslav Popovic
Track and Room: Application Database Development - R2
Title: Connecting IoT data with artificial intelligence at scale
Abstract: This talk is about intersection of IoT and artificial intelligence. IoT solutions to generate more data than traditional systems and users can analyse. Nowadays, AI enabled software solutions that optimize equipment and process performance for large industrial customers. These solutions use large volumes of real-time, batch data from equipment and processes in real time, and apply AI/ML algorithms to predict failures and anomalies as well as optimize performance. The concept is explained in the context of Azure IoT and Azure AI platforms.
Speaker(s):
- Mihail Mateev
Track and Room: Cloud Application Development Deployment - R3
Title: SQL Server full optimization
Abstract: Automation and optimization for all related components to SQL Server: storage, memory, cpu, sql low level design, query plan etc
Speaker(s):
- Alexandru Craciun
Track and Room: Application Database Development - R2
Title: If a computer can understand, why can’t YOU understand Azure Cognitive Services?
Abstract: Cognitive services can recognise objects, faces, describe images, understand speech, perform advanced searches and so much more. If you are a developer and know nothing about Azure Cognitive Services for free, this is a good place to start. Disclaimer: Cognitive services will never guess a doctor’s handwriting. That’s just impossible.
Speaker(s):
- André Melancia
Track and Room: AIML Architecture, Development Administration - R2
Title: AI in Power BI
Abstract: AI and Power BI? Yes! Azure Cognitive Service comes with a set of powerful, pretrained models for intelligent applications. At this point, four of them are exposed in Power BI: language detection, sentiment scoring, key phrase extraction, and image tagging. These models can be used on textual data or images. During the 60 minutes of the sessions we will find out together the answer to the questions WHAT, HOW and the most important one, WHY. Fun is guaranteed :)
Speaker(s):
- Cristian Lefter
Track and Room: AIML Architecture, Development Administration - R1
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.
Speaker(s):
- Liviu Ieran
Track and Room: Cloud Application Development Deployment - R3
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: AIML Architecture, Development Administration - R1
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Damir Bulic
Twitter: - spectral_core
LinkedIn: Damir Bulic
Contact: https://database.blog
The founder of Spectral Core, a database tools company with customers in over 90 countries. Fell in love with computers in high school, didn’t stop since.
- Released a 3D Amiga game with a classroom buddy back in 1994 (MC680x0 assembly)
- As a first PC project, ported a 3D modeler Amorphium from Mac to PC in 1998. (C++)
- Reverse-engineered EXE (and ELF) file format, wrote an EXE protector dismantling and a full system loader launching the encrypted apps with trial/rent functionality (with no source code of the protected apps required) in 1999-2001 (C++ on Windows/Mac/Linux)
- Developed many business apps for local companies up to 2003 (Delphi)
- Co-architected a very popular ERP system in 2003-2004 (Delphi)
- Spectral Core ever sinc
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.
Deji Akomolafe
Twitter: - @dejify
Contact: http://blogs.vmware.com/apps
Deji Akomolafe (a member of the Office of the CTO Ambassador Program and Staff Solutions Architect within VMware#39;s Global Field and Partners Readiness Group) specializes in the virtualization of Microsoft Business Critical Applications on VMware#39;s vSphere platform. Deji is a regular speaker at VMworld, Partners Exchange Conference, VMUG, SQLSaturday and EMCWorld, presenting technical subject matters related to Microsoft Applications virtualization and providing technical guidance to help clients enhance their expertise and ability to optimally virtualize and operate their critical applications.
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.
Dejan Sarka
Twitter: - DejanSarka
Contact: http://blogs.solidq.com/dsarka/Home.aspx
Dejan Sarka, MCT and Data Platform MVP, is an independent trainer and consultant that focuses on development of database and business intelligence applications. Besides projects, he spends about half of his time on training and mentoring. He is the founder of the Slovenian SQL Server and .NET Users Group. Dejan Sarka is the main author or co-author of eighteen books about databases and SQL Server. Dejan Sarka has also developed many courses and seminars for Microsoft, Radacad, SolidQ, and Pluralsight.
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
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
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.
Michal Sadowski
Twitter: - SadowskiMichal
LinkedIn: Michal Sadowski
Contact: https://sqlplayer.net/michal-sadowski
Senior Database Platform Engineer, leader of Krakow chapter of Data Community Krakow (former Polish SQL Server User Group) - PASS Chapter. With more than 10 years of experience in Microsoft technology, helps in advisory for performance optimization on database and application levels. Active speaker on SQL Server related events like SQLSaturday, SQLDay, MCT Global Summit etc. Holds many Microsoft certificates including MCSE: Data Platform, MCSA: SQL Server 2012/2014/2016, MCSA: Windows Server 2008/2012/2016 and MCT.
ILIE Mugurel
Data warehouse developer on MS SQL Server
Dejan Sarka
Twitter: - DejanSarka
Contact: http://blogs.solidq.com/dsarka/Home.aspx
Dejan Sarka, MCT and Data Platform MVP, is an independent trainer and consultant that focuses on development of database and business intelligence applications. Besides projects, he spends about half of his time on training and mentoring. He is the founder of the Slovenian SQL Server and .NET Users Group. Dejan Sarka is the main author or co-author of eighteen books about databases and SQL Server. Dejan Sarka has also developed many courses and seminars for Microsoft, Radacad, SolidQ, and Pluralsight.
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…
Alexandru Craciun
LinkedIn: Alexandru Craciun
creaTiVe… SQL Expert, IT Architect, gamer, rocker, guerrila minded and laugh a lot about anything
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.
Erland Sommarskog
Contact: http://www.sommarskog.se
Erland Sommarskog is an independent consultant based in Stockholm, working with SQL Server since 1991. He was first awarded SQL Server MVP in 2001, and has been re-awarded every year since. His focus is on systems development with the SQL Server Database Engine and his passion is to help people to write better SQL Server applications.
Ivan Čuljak
Twitter: - @CuljakIvan
LinkedIn: Ivan Čuljak
Contact: https://www.culjak.xyz
Ivan is a .NET freelance developer in love with Azure, Xamarin, and the idea of automating whatever. When he’s not developing something new, he’s salvaging something inherited, consulting with enthusiasm, and testing and breaking new technologies in a quest for something useful.
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.
Miroslav Popovic
Twitter: - miroslavpopovic
LinkedIn: Miroslav Popovic
Contact: https://miroslavpopovic.com
Miroslav is senior software architect for .NET and JavaScript, employed as Technical Lead at Seavus. He uses .NET from version 1.0. From Windows Forms, through WPF and Silverlight, all the way to ASP.NET Core. Currently, he is focused on ASP.NET Core, client-side JavaScript development and software craftsmanship. During his career, he worked on a lot of small and big projects, including a couple of local startups. He was one of the members of the development team for the Kicks platform and one of the moderators for https://javascriptkicks.com and https://dotnetkicks.com. Besides that, he is an active community member, conference speaker and one of the leaders of “BLbit Banja Luka” user group.
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…
Sponsors
The following is a list of sponsors that helped fund the event: