PDF of Schedule
T-SQL Performance Guidelines for the optimal DB stress powers
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)
Azure Data Explorer - Fast and highly scalable interactive analytics
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.
BI Powers - The A.I. Who Tagged Me
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.
Handling JSONs in SQL Server
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.
SQL Server 2019 on Linux - What's new?
OS supported by SQL Server 2019
Presenting SQL Server on Linux 2019 and it is new features, things to have in mind when installing, running.
Advanced security features, Big data clusters, Data virtualization - the opening to open source source databases
What I have seen so far in my performance tuning audits
In the last ten years, I have audited many SQL Server databases, for performance tuning. And I have encountered the same problems again and again. Let's call them SQL Server antipatterns. This session is designed to show you what those antipatterns are, and how to avoid them once and for all.
Embedding Power BI in your application
Power BI is great tool and reports we made are always beautiful and catchy, right? But sometimes forcing users to open their browser to go to Power BI Service web site isn't so nice. In this session we will explore the various ways to embed Power BI reports, dashboards and tiles. We will learn what is needed to do this, what it will costs us (can we do it for free?) and what architecture decisions must be taken to build an embedded solution.
Big Data Clusters: SQL Server 2019 Meets Big Data
With the new Big Data Clusters feature in SQL Server 2019, you can store and reason over mountains of data, structured and unstructured, using both Transact-SQL and Apache Spark, a proven Open Source big data processing engine. You can dynamically scale-out your compute power by adding nodes, independently from the distributed storage (HDFS), to support your analytic workloads. You can also bring the power of Spark's Machine Learning library to build predictive models and operationalize them right inside SQL Server. And everything is running in containers and being orchestrated by Kubernetes. Come to this session to see what the Big Data future looks like for SQL Server.
SQL Managed Instance - From the ground to the cloud
The session focuses on migrating SQL onprem databases and objects hosted outside the database context to SQL MI . We will take a look at the migration life cycle and modernization best practices. We’ll share stories and learnings from the field including our most common scenarios in the context of SQL 2008 end of support.
The story of Dataism begins with David Brooks that used in the New York Times in 2013. Dataism is a term that has been used to describe the mindset or philosophy created by the emerging significance of Big Data. More recently, the term has been expanded to describe what social scientist Yuval Noah Harari has called an emerging ideology or even a new form of religion, in which 'information flow' is the 'supreme value'.
What is the impact of Dataism in our life? Let's discover that together!
Running Microsoft SQL Server on Amazon Web Services
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.
ML on the Edge
Or options in running TensorFlow on Pi or similar class devices. My idea was (a bit born from need), to run TensorFlow on Pi class device. And this presentation is born from my adventures, showing pro and cons of each approach. From running directly on Pi to Azure IoT Edge on to Intel Neural Stick, and the list most probably is in “works” you will see the challenges and results of implementing TensorFlow using these technologies. Remark: Kinder chocolates have nothing to do with ML but will be present.
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
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.
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.
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...
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.
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
Experienced professional on Windows and Linux servers, virtualization, hardware and open source technologies. Many years of experience on open source database with a special interest on SQL Server Performance and Always On issues as long as SQL Server on Linux.
I am a Technical Evangelist @ Microsoft and passionate about all things software development.
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.
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
(same as before)
Data warehouse developer on MS SQL Server
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.