Event Location:
Biblioteca Centrală a Universității Politehnica Timișoara
Bulevardul Vasile Pârvan 2b, Timișoara, Romania
Timișoara, Timiș County, Romania
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
LinkedIn: https://www.linkedin.com/in/dbulic/
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
LinkedIn: https://www.linkedin.com/in/IeranLiviu
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.
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, SQL Saturday 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.
LinkedIn: https://www.linkedin.com/in/cristianlefter
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.
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.
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
LinkedIn: https://www.linkedin.com/profile/view?id=126446983amp;trk=hp-identity-name
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
LinkedIn: https://www.linkedin.com/in/dragosmadarasan
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.
LinkedIn: https://pl.linkedin.com/pub/michal-sadowski/4/b33/717
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.
Data warehouse developer on MS SQL Server
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.
LinkedIn: http://LinkedIn.COM/in/AndreMelancia
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...
LinkedIn: https://www.linkedin.com/in/alexandru-craciun-3a829574
creaTiVe... SQL Expert, IT Architect, gamer, rocker, guerrila minded and laugh a lot about anything
LinkedIn: https://www.linkedin.com/in/dennestorres/
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.
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.
LinkedIn: https://www.linkedin.com/in/culjakivan/
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.
LinkedIn: http://www.linkedin.com/pub/mihail-mateev/1/6b3/4b1
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.
LinkedIn: https://www.linkedin.com/in/miroslavpopovic/
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.
LinkedIn: http://LinkedIn.COM/in/AndreMelancia
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...