SQLSaturday Sofia 2017
SQLSaturday is a free training event for Microsoft Data Platform professionals and those wanting to learn about SQL Server, Business Intelligence and Analytics.
Adaptive Query Processing in SQL Server 2017Margarita NaumovaAn improvement of cardinality estimation is something we try to find in every next version of SQL Server. Even with all the improvements the SQL Server 2014 Query Processor gained, we still need to deal with Hash and Sort Warnings, extremely high or low Memory grants, or the well-known User Defined Functions performance issues. That’s why we are so existed to find the new wave of adaptive query processing improvements to handle the more intractable cardinality estimation issues that often result in a poor query performance. Find out how the new wave of adaptive query processing improvements to handle the more intractable cardinality estimation issues that often result in a poor query performance.Margarita Naumova10:00 11:00
From SQL to R – Leverage Your T-SQL Knowledge to Learn RMarkus Markus Ehrenmueller-JensenYou are already familiar with T-SQL and are eager to learn R but do not know, where to start? Start from what you already know: T-SQL. Both languages have many things in common on some levels, but are very different on others. This session will kick you off to the new language by using analogies from T-SQL. You will learn how to write your first R-scripts, make usage of packages and will leave this session with a basic understanding of typical use-cases of R and how to integrate that into your existing environment with SQL Server.Markus Markus Ehrenmueller-Jensen10:00 11:00
Creating data-driven serverless apps with Azure FunctionsAnton BoykoWe already know that cloud provides us with a way to control the amount of resources provisioned based on app load, scale them up and down. But what if I will say that there is a way to create your app, host it in the cloud and make it ready to respond at your call, but if you will have zero load during a month it will cost you nothing? Try to imagine that you will pay not for fixed amount of CPU and RAM, but for a number of function calls and amount of CPU time consumed to execute them. In this scenario you do not have a dedicated virtual machine, but you have an abstract web farm, which consists of 100500 servers and each of them is able to execute your code. In this case we do not have a server, neither physical nor virtual, we have a platform which can scale from zero to infinite in a few seconds. On top of that you can use your favorite language - C#, F#, Java, PHP, Python, Node.JS, PowerShell, Bash, etc.Anton Boyko10:00 11:00
Database Continuous Delivery on the Microsoft PlatformGavin CampbellA look at the state of the art in database continuous delivery using SQL Server Data Tools (SSDT), Visual Studio Team Services(VSTS), and VSTS Release Management.
The features provided by platforms such as TFS and VSTS have been widely adopted by application developers in support of modern software development practices such as continuous delivery.
In the world of database development, adoption has been much slower, due to a number of organisational and technical considerations.
This session will discuss some of the challenges associated with database continuous delivery, and the ways in which Visual Studio, SQL Server Data Tools and Visual Studio Team Services can help to improve delivery of SQL Server databases.Gavin Campbell10:00 11:00
Is Power BI Enterprise ready?Scott HudsonBest practices and recommendations for leveraging/deploying Power BI within a large scale Enterprise environment, utilising new features and a look at the road map.Scott Hudson11:15 12:15
Real world DevOps - challenges, tools and solutionsIvan DonevSo you want to use AlwaysEncrypted, but your app is not using driver level parameters? Or you want to parameterize ad-hoc queries, without rewriting your application? Or you just want to pretty print your t-sql code? SQLDOM is here to help. Not very popular but extremely useful utility/library that can help anyone to intercept and rewrite queries during runtime so they meet feature requirements or just fix performance.Ivan DonevIvan Donev Ivan is a SQL Server engineer with more than 7 years of experience in the field. He is part of Microsoft focusing both on SQL Server and Windows Azure. He is a Microsoft certified trainer and expert in Data Platform, regular speaker on conferences and user group meetings. Previously he was a SQL Server Solution Designer and DBA for Hewlett-Packard. He is also and SQL Server trainer,and holds certifications in several different SQL Server areas - development, business intelligence, database administration. He has more than 5 years of experience with SQL Server, covering versions 2000, 2005, 2008/R2 and 2012. For the last three years he is supporting large scale production environments and leading complex projects for build, support and upgrade of SQL Server Database and BI components. Ivan is writing for www.mssqlinsider.com and active member of SQL and BI user groups in Bulgaria.11:15 12:15
In-database Predictive Analytics with SQL Server 2017Sacha TomeyIn this session we will look at SQL Server Machine Learning Services and, in particular, the new MicrosoftML package available in SQL Server 2017 and how it can be used to build an in-database Predictive Analytics Model, that can scale.
The session will initially provide a primer to supervised Machine Learning before applying that to a real world scenario, taking you through each of the steps required to build an in-database predictive analytics model using R and SQL Server 2017.Sacha Tomey11:15 12:15
Cloud BI with Azure Analysis ServicesSergiy LunyakinWith Azure Analysis Services (Azure AS) we have full set of PAAS and SAAS services like Azure SQL DWH, Azure SQL DB, Azure AS and Power BI for creating our BI solutions in the cloud. In this session I will introduce Azure AS and how we can use it together with other Azure services for creating complete BI solution in the cloud.Sergiy Lunyakin11:15 00:15
Logic Apps - Data Orchestration in AzureSimon WhiteleyFor a long time we've dreamed of full-functioned SSIS in the cloud. If you've wrestled with Data Factory, well... It's not quite there yet. Logic Apps fills a huge gap in the Azure story and if you've not tried it yet - you should.
Logic Apps provides control-flow style functionality and can orchestrate data from a huge range of common sources. Want to scrape twitter, perform sentiment analysis and write to PowerBI? Its now possible with zero coding.
This session will introduce Logic Apps & how it fits into the Modern Azure Warehouse then demonstrate building a twitter scraper step by step, demonstrating the process of building, deploying and debugging an app.Simon Whiteley11:15 00:15
Enabling Citizen Data Science with MicrosoftJan MulkensIn times past, Data Science was only for those elite few with a rare combination of skills including advanced knowledge of statistics.
Microsoft has been making sure that everyone can participate in the data revolution by giving people access to predictive API’s, in-database advanced analytics and drag-and-drop predictive experiments. All thanks to SQL Server 2016 and the Cortana Intelligence Suite in Azure.
These advances have given people with less knowledge of statistics and programming the ability to become what Gartner calls citizen data scientists. Should we be worried about creating fools-with-tools or should we embrace the democratization of data science as the golden age of data? Using a combination of theory and demo’s, we explore Microsoft’s solutions to ensure democratization of data science and the possible dangers that lurk below the surface.Jan Mulkens13:00 14:00
Anomaly DetectionDejan SarkaAnomaly detection is one of the most advanced data mining and machine learning tasks. There are many statistical procedures and data mining algorithms that can be used for it, including Expectation-Maximization Clustering, and Principal Component Analysis. In this session, you will learn through presentation and demos how to detect the low quality data areas with some basic statistics and with advanced algorithms. You will see how you can use T-SQL queries, R code in SQL Server, SSAS Data Mining, and Azure ML for this complex task.Dejan Sarka13:00 14:00
Creating “Always Encrypted” applicationsAndrey NikolovEnd-to-end encryption deserves end-to-end demo :)
In this session you will see not only what Always Encrypted is and how it works, but also how it looks like from developer’s perspective. It is a demo-heavy session and we will spend more time in Visual Studio and SSMS than in PowerPoint. I will show how to read encrypted columns in SSMS and how to do this in the application. You will also learn how to manage certificates in Windows Certificate Store and Azure Key Vault and why we need a separate security officer.
This session is intended for both developers and database administrators.Andrey Nikolov13:00 14:00
Data replication - who with whom, for whom, why and for what?Kamil NowinskiDuring this session we will review all types of replications in SQL Server and find out principal differences between them and when should be applied. Besides examples of practical scenarios, we will consider what we have as alternatives and why the AlwaysOn is not one of them. As always on my sessions quite a lot of demonstrations and T-SQL code.Kamil Nowinski13:00 14:00
How Indexes and Statistics can improve performance of our databasesGilberto ZampattiThis session covers the internals of statistics and indexes in Microsoft® SQL Server®. Creating and maintaining statistics and indexes is a core element in enhancing the performance of the SQL Server Database Engine. Both statistics and indexes are used to select suitable query execution plans; indexes also speed up the retrieval of data. To understand and influence query performance, you should have a good understanding of queries and indexes.Gilberto Zampatti13:00 14:00
SQL database on IoT devices, could you? should you? would you?Catalin GheorghiuThe current IoT devices are pretty powerful, so could very well run a version of SQL engine. It would be a good idea? What will be the use of it? How to make it work and make the most of it? How does all fit with the field gateway concept? During the presentation, we will take a real word scenario, real hardware, and together we will try to answer these questions.Catalin Gheorghiu14:15 15:15
State-of-the-Art Machine Learning Algorithms in R from MicrosoftMarcin SzeligaDo you fancy learning regression and classification in one hour?
We will start with linear regression, simple but powerful machine learning algorithm. With it you will learn about correlation coefficient, loss function, optimization algorithms and regularization. At the end of this section we will built a ML model using Fast linear model with Stochastic Dual Coordinate Ascent (SDCA) optimization. Next step is get to know artificial neural networks, their architecture, activation functions and backpropagation algorithm. This allows us to build a (better?) model using rxNeuralNet and N#.
Evaluation metrics for regression models will conclude first part of the session.
In the second part we will use almost the same ML algorithms for classification — the difference is that Logistic regression will replace Linear regression. Finally we will learn about Evaluation metrics for classification models, which allows us to pick the very best model for problems we are going to solve together.Marcin Szeliga14:15 15:15
Machine Learning for IoT - Unpacking the blackboxIvelin AndreevDevices from the IoT realm generate data in a rate and magnitude that make it practically impossible to retrieve valuable information without support of adequate AI engines. Although being one among many solutions available, Azure ML has proved to be a great balance between flexibility, usability and affordable price. But how does Azure ML compare with the other ML providers? How to choose the appropriate algorithm? Do you understand the key performance indicators and how to improve the quality of your models?
This session is about managing and understanding IoT data. Check this out and see how Azure Machine Learning could support real life problems in building IoT solutions.Ivelin Andreev14:15 15:15
PowerBI for RookiesMiroslav DimitrovJoin me in a session where we will explore PowerBI strength for beginners and what can be achieved with it in about several clicks. We will go through PowerBI Desktop, PowerBI Webservice, different visualizations and a shallow look at Power Query.Miroslav Dimitrov14:15 15:15
USE CASE: LOCALDBDaniel JoskovskiIn our new POS application intended for chains of markets we use Azure SQL Database, for many reasons we decide to store part of data also locally.
We decide to use localDB as our local cache of data.
In this presentation we will show: - what we considered for local storage, - what is localDB, - versioning and differences, - what you need to install, - tools for working locally, - SqlLocalDB functionality, - SqlCmd functionality, - tips & tricks.Daniel JoskovskiOwner, OmnisWorks in IT since 1985, he is a database-centric application developer and architect, instructor, course author, usergroup leader and Owner of Omnis LLC. Over the Past 10 Years he's been teaching Microsoft SQL Server 2000/2005/2008, .NET Development and SharePoint product and technologies courses to premier customers in Macedonia, Kosovo and Albania for SEMOS - first Macedonian Gold Certified Partner for Learning Solution. Starting from July 2009 Daniel is awarded with Microsoft MVP award for SQL Server.14:15 15:15
How GDPR affect most common DBA maintenance tasksTsvetozar Ivanov Miroslav LessevThe European General Data Protection Regulation (GDPR) suggests penalties for those companies and organizations which do not comply with the directive. Fines can go as high as 4% of annual global revenue or 20 million Euros, whichever is greater. That's why everybody from C-level management to regular DBA is crucial to enforce compliance with the new data protection rules and for this very reason data maintenance tasks become absolutely obligatory and if a legal entity has skipped them, from now on it is not going to be possible. In this session, based on our experience, we will speak about the most important DBA maintenance tasks you need to perform to keep your databases GDPR compliant.
Session is suitable for beginner DBAs and Developers.Tsvetozar Ivanov Miroslav Lessev15:30 16:30
Hacking SQL ServerAndré MelanciaHow easy is it to hack a SQL Server?
In this session we'll see examples on how to exploit SQL Server, modify data and take control, while at the same time not leaving a trace.
We'll start by gaining access to a SQL Server (using some "creative" ways of making man-in-the-middle attacks), escalating privileges and tampering with data at the TDS protocol level (e.g. changing your income level and reverting without a trace after payment), hacking DDM, and more.
Most importantly, we'll also cover recommendations on how to avoid these attacks, and take a look at the pros and cons of new security features in SQL Server 2016.
This is a demo-driven session, suited for DBAs, developers and security consultants.André Melancia15:30 16:30
Exploring Dark Data with SQL Server 2016 and ROliver FrostWith the addition of R into SQL Server 2016, Microsoft have provided a few extra degrees of freedom for the standard SQL developer. You can now use the R language to wrangle, clean and collect external data, using libraries and functionality that simply wasn’t available to you before with regular T-SQL. Performing data enrichment at scale with SQL Server or even Microsoft R Server can provide extremely valuable new insights for your clients and start reaping the benefits of big data.
In this session, Consolidata’s Oliver Frost shows you how to develop your own application for tapping into ‘dark data’. Ollie will demonstrate how to stream live tweets, perform aggregations in R and pipe the output to a Power BI dashboard, giving you a full end-to-end experience of the importance of learning some basic R code in 2016.
This session is for anyone who is new to R and is interesting expanding their skill set beyond their comfort zone in SQL Server.Oliver Frost15:30 16:30
GDPR compliant by designMiroslav LessevFrom 25 May 2018, the EU General Data Protection Regulation (GDPR) will affect every organization that processes EU residents’ personally identifiable information (PII). The GDPR contains requirements that systems and processes must consider compliance with the principles of data protection.
The essence of privacy by design is that privacy in a service or product is taken into account not only at the point of delivery, but from the inception of the product concept.
There is also a requirement that controllers should only collect data necessary to fulfil specific purposes, discarding it when it is no longer required, to protect data subject rights.
This presentation provides a breakdown of the key provisions introduced by the new law, which every organization must be aware of.Miroslav Lessev15:30 16:30
I am a DBA!Rozalina ZaharievaIn this session, we will discuss where to start when you get your job as a DBA. What are the first steps you need to do to discover and arrange the environment for which you are responsible. How to answer questions like: How many databases do you have on each server? How big are they?
What they are used for and how many of them are critical? Do you need backups and do you have such, Etc. There are many questions you got from the day 1, but where to start is always the key to not get panicked. The goal of this session is to help you perform your first steps in a DBA job, especially when you get into a situation with only one Excel spreadsheet containing your servers’ list.Rozalina Zaharieva15:30 16:30
Master your Data in the Cloud with Power Apps and Logic AppsAs data warehouses become more advanced and move to the cloud, Master Data Management is often bottom of the list. Being tied to an IAAS server solely for MDS feels like a big step in the wrong direction! In this session, I will show you the secret of ‘app-iness with a cloud alternative which leverages Power Apps and Logic Apps. We will step through a number of real world scenarios, demonstrating how easy it is to deliver a mobile friendly, no-server, no-code Master Data Management solution.16:45 17:45
Dynamic Search ConditionsMatt HowA common requirement in database applications is that users need a function to search a set of data from a large set of possible search conditions. The challenge is to implement such searches in a way that is both maintenanble and efficient in terms of performance. This session looks at the two main techniques to implement such searches and highlights their strengths and limitaitons.Matt How16:45 17:45
Introduction to SQL Server v.Next for LinuxAndrzej KukulaMicrosoft surprised a lot of people with the announcement that SQL Server is going to be released for Linux. And there we have it - preview releases available in public are regularly delivered, working great and fast. On my session I'll show details of solution that allowed this idea to come true. We'll see how to install, use and administer Linux version of SQL Server. We'll see it working as a service and in Docker containers. I'll give you details of why the second option is really interesting, or to say it more clearly - groundbreaking.
In addition to slides you're going to see lots of terminal windows, tools that are familiar to you and new stuff as well.Andrzej Kukula16:45 17:45
Dealing with CosmosDBMihail MateevCosmosDB 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.Mihail MateevSolutions Architect, PM and Senior Technical Evangelist, StrypesMihail Mateev is a Solutions Architect, PM and Senior Technical Evangelist at Strypes, blogger at Infragistics Inc. Microsoft Azure MVP. Mihail worked in various areas related to technology Microsoft: Silverlight, WPF, Windows Phone, , LightSwitch, ASP.Net MVC, Windows Store Applications, MS SQL Server and Microsoft Azure. He also write many jQuery related blogs. Mihail is administrator of many events like SQLSaturday Bulgaria, JS Saturday Bulgaria, SharePoint Saturday Bulgaria, UXify Bulgaria and jQuery Bulgaria.16:45 17:45
Power BI: Performance Tips & TricksCallum GreenThanks to the rapid, community-driven release cycle, Microsoft Power BI has caught and overtaken many visualisation tools and now sits alongside Tableau at the top of the Gartner Magic Quadrant for 2017. It is fast becoming the first-choice reporting tool for both small and large organisations.
However, as with all reporting tools, if the underlying data model is badly designed or custom measures/calculations are poorly written, performance can really suffer. Whether you are designing the front-end for a carefully crafted warehouse, or performing an ad-hoc analysis exercise, you can follow some best practice advice to ensure you’re getting the best out of your reports.
This 1 hour session will range from quick development wins to more strategic, enterprise considerations. The session also aims to explain ad-hoc transformations within the Query Editor and demonstrates best practices for encouraging Query Folding. Designed for all levels of Power BI expertise.Callum Green16:45 17:45
Discover the new graph features of SQL Server 2017Rudi BruchezIn this session, we’ll see in detail how to create nodes and edges tables designed for graphs traversal in SQL Server 2017. After a summary of the underlying graph theory and its implementation in databases, we’ll see how to create graph tables in SQL Server 2017, and how to query them with the match operator. This session will give you a kickstart on using graphs in SQL Server 2017.Rudi Bruchez
VenueSofia Tech Park Technology and Innovation Network (T+IN) or "Sofia Tech Park" is the first science and technology park in Bulgaria designed and created to act as a platform for the exchange of knowledge and ideas between academia, business, government and society.