Event Location:
Telerik Academy
бул. Александър Малинов 31
Sofia, Sofiya, Bulgaria
Abstract:
You can stretch your legs and relax and get a quick session on delivering your analytics against hot, warm cold data. If you are not aware of the concept behind hot, warm and cold data, it simply speaks about the age of the data that resides in your systems. Stretch Database is the new concept, which allows you to stretch your data from on-premises to cloud without a need of any SSIS packages or any other automation. In this session you will understand, enabling / disabling data stretch, reading data from stretched database, setup remote data archiving and backup restore for the stretch enabled databases. Stretch DB also covers the concepts of Shallow Deep backups.
Speaker(s): Dr. Subramani Paramasivam,
Abstract:
When I joined runtastic.com to build their very first centralized data warehouse with Microsoft SQL Server, no one really felt in charge of the server – so the responsibility fell into my humble hands. Besides my duties as a business intelligence architect (designing implementing the database, ETL cube), I had to quickly come up with a solution for the most important administrative tasks: • Disaster Recovery and Failover • Database Maintenance • Capacity Management • Job Performance Monitoring In this session I will invite you to discuss the pros cons of the solutions I came up with and you will leave the session with helpful concepts and scripts which you can use freely.
Speaker(s): Markus Ehrenmueller-Jensen,
Abstract:
Nothing is perfect, which means that your database may be not perfect as well. And one day you may decide that your database is slow and it's time to optimize it. But.. Where to start? When to end? What to look at? Which queries are slow? How to identify the real bottleneck? And so on, and so on. There are a lot of questions that should be answered in a process of performance tuning. In this session, we will find answers to all these questions going from collecting data for analysis, through identifying bottlenecks to optimization of the particular queries. On this way, we will learn performance tuning practical techniques and solve a bunch of issues in real-time. All this will be done using plain old tools, which are available on your system by default: Profiler, Performance Monitor, SSMS, and DMVs. Minimum of theory and a lot of practice.
Speaker(s): Denis Reznik,
Abstract:
SQL Server 2016 has major enhancements to existing features as well as brand new ones that will contribute to making SQL Server implementations more highly available. This two-part session will cover not only what is in SQL Server 2016, such as all of the improvements to availability groups like seeding and basic AGs, but important Windows Server 2016 features like site awareness, storage replica, and more that all DBAs should be aware of. With this extended session, most of what will be discussed will be shown so you can see how they work. The session is based on practical scenarios from a customer’s implementation. We will start with requirements list and will end up with an implemented solution.
Speaker(s): Margarita Naumova,
Abstract:
In an enterprise, merging master data, like customer data, from multiple sources is a common problem. Typically, you do not have a single, i.e. the same key identifying a customer in different sources. You have to match data based on similarity of strings, like names and addresses. In this session, we are going to check how different algorithms for comparing strings included in SQL Server work. We are going to use four different algorithms that come with Master Data Services (Levenshtein, Jaccard, Jaro-Winkler and Ratcliff-Obershelp), and Fuzzy Lookup transformation from Integration Services. Finally, we are going to introduce how SQL Server Data Quality Services help us here.
Speaker(s): Dejan Sarka,
Abstract:
In SQL Server 2016 (currently availabe as a preview) Microsoft added support for mobile reports to Reporting Services. They also released the Mobile Report Publisher for authoring and creation of mobile reports. This application is based on Datazen technology, a company that Microsoft acquired in 2015. As Microsoft stated, using only one mobile BI app users will access dashboards and reports on mobile devices. Now developers must choose a tool for developing BI optimized for mobile devices: SSRS, Mobile Report Publisher (former Datazen) or Power BI? The question is: which one to choose? What are the key factor for supporting the correct decision? We will provide a clear and understandable overview of each product, highlighting strengths and weaknesses. Based on some real examples we will set out a comparison matrix to find the best way to meet your needs with the right mobile reporting tool.
Speaker(s): Andrea Martorana Tusa,
Abstract:
SQL Server 2016 has major enhancements to existing features as well as brand new ones that will contribute to making SQL Server implementations more highly available. This two-part session will cover not only what is in SQL Server 2016, such as all of the improvements to availability groups like seeding and basic AGs, but important Windows Server 2016 features like site awareness, storage replica, and more that all DBAs should be aware of. With this extended session, most of what will be discussed will be shown so you can see how they work. The session is based on practical scenarios from a customer’s implementation. We will start with requirements list and will end up with an implemented solution.
Speaker(s): Margarita Naumova,
Abstract:
R is coming to SQL Server. SQL Server 2016 includes new real-time analytics, automatic data encryption, and the ability to run R within the database itself. For deeper insights into data, SQL Server 2016 expands its scope beyond transaction processing, data warehousing and business intelligence to deliver advanced analytics as an additional workload in SQL Server with proven technology from Revolution Analytics. Microsoft SQL Server team want to make advanced analytics more accessible and also to increase performance for your advanced analytic workloads by bringing R processing closer to the data and building advanced analytic capabilities right into SQL Server. With this update, data scientists will no longer need to extract data from SQL server via ODBC to analyze it with R. Instead, you will be able to take your R code to the data, where is will be run inside a sandbox process within SQL Server itself. This eliminates the time and storage required to move the data, and gives you al
Speaker(s): Daniel Joskovski,
Abstract:
Do you still prefer troubleshooting issues using SQL Server Profiler, because you find Extended Events too complicated? Or is it because you have never used Extended Events before, or it was in the dark ages of 2008 and your love for XML wasn’t strong enough to make you use them? The good news are that the recent versions of SQL Server give you a nice UI and made it all as user friendly as possible. The bad news are that you have no excuse anymore to not use them! Join this session to learn the basics of SQL Server Extended Events. You will see example use cases that could make your life easier and will learn how to troubleshoot issues in a modern and efficient way.
Speaker(s): Andrey Nikolov,
Abstract:
Database queries have their own life. Sometimes it is not so long but for sure it is a fascinating one. Come join me in a session where we will be chasing a wild query thru the SQL Server engine. Or at least put a DB Administrator on the interrogation table.
Speaker(s): Kaloyan Kosev,
Abstract:
In order to ascertain the abilities of cloud computing platform, let us overview what is available offered on Microsoft Azure. Microsoft Azure has the ability to move, store and analyze data within the cloud. It is essential to evaluate multiple opportunities and options with Microsoft Azure data insights. In this session let us talk about strategies on data storage, data partitioning and availability options with Azure. A tour on how best these Azure components can help you achieve success for your Big Data platform.
Speaker(s): Satya Jayanty,
Abstract:
This talk will introduce you to the world of real time apps. Nowadays with the help of advanced SDKs like SignalR, real time apps are almost trivial to create and are the ones that provide the "Wow!" factor to our clients. Having real time capabilities in your application is important, can solve you big problems and users gradually start taking them for a given. You will learn how to create an app that magically updates its data and of course some nice tricks about SignalR and SQL Server. Cool demos are guaranteed.
Speaker(s): Samuil Aleksov,
Abstract:
R is the world's most widely-used programming language for data analysis. Despite being the most popular, R suffers from lack of scalability and being slow. In this demo heavy session I will introduce you to the fundamentals of Microsoft R Server, it’s native file format XDF (eXternal Data Frame), data analytics and manipulation functions, as well to scalable machine learning algorithms. Don’t miss the opportunity to see how MRS addresses open source R scalability and performance issues.
Speaker(s): Marcin Szeliga,
Abstract:
Alongside with all other features SQL 2016 now natively supports JSON – one of the most common formats for data exchange. SQL 2016 now has built-in capabilities to query, analyze, exchange and transform JSON data. JSON functionality is quite similar to SQL XML support but despite this being one of the most desired additions to SQL 2016 there is a flavour of something missing – the JSON data type. In this session we will talk about JSON support features, limitations and some tricks to overcome these.
Speaker(s): Ivelin Andreev,
Abstract:
SQL Server is full of misunderstood features and misnomers that could affect how it is operating and respectively our applications. If you do not want to be surprised in a bad way by some intended, but not widely known SQL functionalities, join me in this session where we will, in an entertaining way, examine some of the most common behaviors that you probably have not expected.
Speaker(s): Miroslav Dimitrov,
Abstract:
The Columnstore Indexes technology has been subjected to a number of important improvements, including updateable nonclustered columnstore indexes, columnstore indexes on in-memory tables, and many more new features for operational analytics. In this session we will show this evolution, from the beginnings until today's state of the art.
Speaker(s): Gilberto Zampatti,
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 plusses 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,
Abstract:
Have you heard about Azure SQL DWH? Do you want to move your current DWH into the Cloud? Can I use Azure SQL DWH like my regular DWH on-premise? In this session I'm going to answer on these questions. Also, I will prodive information where is better to use Azure SQL DWH and what is more important, how to use it.
Speaker(s): Sergiy Lunyakin,
Abstract:
EF Core is the new (.NET Core) version of Entity Framework on which the team have started working from scratch. It represents a lightweight and extensible version of the popular Entity Framework data access technology. EF Core supports many database engines (SQLite, MSSQL, Posgre, MySQL, SQL Server Compact, IBM Data Servers and Oracle (soon)). We'll talk about what's in the v1.0 release, and what is still planned. We'll look into some interesting demos as well (C#).
Speaker(s): Branimir Giurov,
Abstract:
The best SQL ServerMigration Strategies
Speaker(s): Virendra Kumar Yaduvanshi,
Abstract:
Have you ever needed to do initial data loads? Or regular ETL in Datawarehouse? And have you ever wondered how you can speed things up? There are number of tips and tricks you can apply and depending on your strategy you can reach throughput of more than 2 TBs per hour. How to do that? Join me on my session and see how companies are doing it all over the world.
Speaker(s): Ivan Donev,
Abstract:
As SQL Server 2016 is coming soon, it is important to see how new features are working. This session is about Always Encrypted feature and covers the followings: - What encryption types are in SQL Server? - A business scenario: handling sensitive data w/o giving access to DBA team. - Always Encrypted basics - Creating table with encryption by using AE - Migrating data from regular table to AE table - Decrypting data from AE table - AE under the hood - Performance impact
Speaker(s): Janos Berke,
Abstract:
During this session we will talk about Azure Search - full-text search engine provided to us via SaaS model. The main advantage of this service is not only that is fully managed by Microsoft, scalable, reliable and all other cloud related stuff. It is more about numerous data sources you can use to populate your search indexes. Also, because you use HTTP to work with Azure Search, you can easily use it not only within your desktop or web applications, but also you can easily consume it in your mobile applications, IoT solutions, etc.
Speaker(s): Anton Boyko,
Abstract:
- Going through mountains of different methods and approaches to better understanding DWH loading. - Show how to use standard components in Microsoft SSIS. - Loading extremely fast data into DWH with components that we can develop or we can use. - Better understanding of architecture of loading.
Speaker(s): Ivan Miliovsky,
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://uk.linkedin.com/sqlmaster
Contact: http://www.sqlserver-qa.net
My experience surrounded with high focus on the data platform with a track record of defining strategy, designing and delivering digital transformation migrations with major enhancements to current working methods. Worked in a capacity of Head of Data Engineering, Enterprise Data Architect and Solutions Key career accomplishment recognition as an industry expert technical excellence from the Microsoft as Data Platform Most Valuable Professional (MVP) recognition since the year 2006 (13 years as MVP and counting), which recognizes exceptional technical community leaders worldwide who actively deliver, present share their extraordinary contributions, high quality, and real-world expertise. Twitter pod (http://twitter.com/sqlmast
LinkedIn: https://www.linkedin.com/in/virendrayaduvanshi
Contact: https://wikidba.net/
Competent, accomplished and result oriented information technology specialist with 20 years of experience, Dynamic leadership career, and demonstrated success in designing and implementing Database with emphasis on System Administration, Database Administration, Technologies deployment and technical analysis of multi-client operations, Innovative, result-driven leader with diverse IT experience emphasizing cross platform systems and network architecture, engineering, installation/implementation, integration, security and Administration for a VLDBs projects. MCTS, MCITP and ITIL - applies broad technical expertise to resolve complex systems and DBs issues associated with progressive growth/expansion.
LinkedIn: https://www.linkedin.com/in/slunyakin
Contact: https://slunyakin.wordpress.com
Sergiy Lunyakin (MCSA, MCSE, MCTS) is a Big Data Architect at SoftServe, Inc. He has extensive experience in designing and developing Big Data Analytics, Data Warehouse, and BI solutions, using both on-premises and cloud products. In 2016, Sergiy became Microsoft Data Platform MVP and has since maintained his MVP status. Sharing knowledge is another one of his passions. He regularly speaks at international conferences such as SQLSaturday, SQLDay, SQLNexus, and SQLBits. He also runs the Lviv SQL Server User Group in Ukraine and organizes SQLSaturday Lviv.
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.
Senior Data Warehouse Consultant, Adastra Bulgaria Ltd. Ivan Miliovsky is a Microsoft Certified Professional and a Database Developer @ Adastra Bulgaria. With over 7 years of hands-on experience in various projects in the Telco and Software Development sectors, he led and participated in many local and international projects. He possesses valuable expertise in design and development of Business Intelligence and ETL processes utilizing MS Technologies. Further Ivan is experienced in developing and testing processes with PL/SQL in Oracle, including optimization of PL/SQL queries and stored procedures. Enthusiastic follower of the latest developments in the area of MS technologies, he spends endless hours in researching and analyzing the poss
LinkedIn: https://bg.linkedin.com/in/kosev
Kaloyan Kosev is a SQL Server expert working with enterprise companies for the last 9 years. His daily work routine is a mixture of troubleshooting bugs and issues, consulting and advising clients and presenting to students. Within his free time he is trying to balance between SQL and x-sports.
LinkedIn: https://www.linkedin.com/in/boykoant
Founder and main speaker at Ukrainian Microsoft Azure Community. 15+ years in application development. Builds apps based on Microsoft Azure platform since 2011. Microsoft Azure technical expert. Microsoft Azure MVP since 2014. Owner and one of the organizers of the most popular Microsoft Azure conferences in Ukraine: Azure Day and Global Azure Bootcamp.
Once upon a time a well skilled and valuable IT pro took care of me and elected himself as my mentor. I bumped into RDBMS when they were just prototypes and... when SQL Server appeared on the market I knew my trek. I#39;m still walking on it, glad to tell the people what I#39;m learning throughout my journey .
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: https://pl.linkedin.com/in/marcinszeliga
Data Philosopher. Since 2006 invariably awarded Microsoft Most Valuable Professional title in the Data Platform category. A speaker at numerous conferences across Europe, as well as at user groups meetings. The author of many books and articles devoted to Microsoft Data Platform. An independent consultant, database-centric application practitioner and architect totally focused on SQL Server and Azure. Huge fan of Data Science and Machine Learning.
LinkedIn: https://www.linkedin.com/in/sam-aleksov-68594142
Contact: https://www.refractiondevelopment.com/category/blog/sam-aleksov/
Currently a Lead Software Engineer at EPAM Systems, with a decade of experience in the most obscure places of CS. Officially a CSharp.NET developer, but every language and framework work for me when they seem to offer the best solution. After years behind the monitor, collaborations with clients from different business fields, infinite requirements and the never ending search for unicorns, I have decided to start sharing with you the good, the bad and the evil of Computer Science.
LinkedIn: https://www.linkedin.com/in/ivandonev/
I am a Data platform MVP with more than 10 years of real-life experience with SQL Server and its stack of services. Besides the support and project work, I am also a trainer, conference speaker and user group organizer (and volunteer).
LinkedIn: https://bg.linkedin.com/in/dimitrovmiroslav
Contact: http://www.sqlshack.com/author/miroslav-dimitrov/
Miroslav Dimitrov is a Senior Big Data and Analytics Engineer at DXC Technology, regular speaker at various events and Microsoft Certified Trainer. He is MCSE: Data Platform for SQL Server and MCITP on SQL 2008. In the last years he had worked on great variety of customers' environments and involved in complex transitions and transformation projects as well as developing private and public cloud solutions. Miroslav is also leading database courses at Sofia University.
LinkedIn: http://www.linkedin.com/pub/denis-reznik/3/502/234
Contact: http://reznik.uneta.com.ua
Denis Reznik is a Data Architect at Intapp, Inc. He has more than ten years experience in software development, database design, and performance tuning for cloud and on-premises solutions. In 2010 Denis became Microsoft Data Platform MVP and maintains MVP status today. Apart from his professional career, Denis actively participates in the development of the Ukrainian Data Community.
LinkedIn: http://bg.linkedin.com/pub/margarita-naumova/9/965/206
Contact: www.maginaumova.com; http://blogs.technet.com/b/magi/
Magi Naumova is SQL Server Architect and Consultant, speaker and trainer, Microsoft Certified Master, MVP Data Platform, MCT, Founder of SQL Master Academy, founder and leader of the Bulgarian SQL User group. She has more than 15 years SQL Server training and consulting experience. Magi is a former member of Microsoft Services Worldwide Technical Leadership Team, а Microsoft Women worth watching http://zd.net/1lwNYKH Currently she speaks, writes, trains and consults people on SQL Server technology. She runs a Data Platform consulting company part of which is SQL Master Academy training program. It helps hundreds of specialists to feel knowledgeable in their daily work or to find an inspirational career path in the world of SQL Server.
Andrea Martorana Tusa is a Business Intelligence Team Manager at Würth Phoenix, the IT and consulting company of the Würth-Group. He is awarded as MVP in the Data Platform category Former BI Specialist at Widex, a Danish manufacturing company, and BI Developer in the IT department of an Italian banking group. 20+ years of experience working with data. He is focused on the entire BI stack: database development, data warehousing, data analysis, reporting, etc. Andrea is a usual speaker at many events: SQLSaturdays, conferences in Europe and PASS Summit, and for PASS Virtual Groups. Andrea is an author for sqlshack.com, sqlservercentral.com, and UGISS (User Group Italiano SQL Server).
LinkedIn: http://bg.linkedin.com/pub/margarita-naumova/9/965/206
Contact: www.maginaumova.com; http://blogs.technet.com/b/magi/
Magi Naumova is SQL Server Architect and Consultant, speaker and trainer, Microsoft Certified Master, MVP Data Platform, MCT, Founder of SQL Master Academy, founder and leader of the Bulgarian SQL User group. She has more than 15 years SQL Server training and consulting experience. Magi is a former member of Microsoft Services Worldwide Technical Leadership Team, а Microsoft Women worth watching http://zd.net/1lwNYKH Currently she speaks, writes, trains and consults people on SQL Server technology. She runs a Data Platform consulting company part of which is SQL Master Academy training program. It helps hundreds of specialists to feel knowledgeable in their daily work or to find an inspirational career path in the world of SQL Server.
LinkedIn: https://www.linkedin.com/in/branimirg
Branimir is a UG Lead of SofiaDev .NET User group since 2003. He has been awarded by Microsoft with MS C# MVP award (2004-2014). Branimir is a Solution Architect in the Enterprise Software Development unit of Bulpros where he’s working on Enterprise-level projects in the area of Sharepoint, BizTalk, MSSQL and other Microsoft’s backend products. Branimir’s interests include: - S.O.L.I.D. design principles - OOP design for maintainability - Agile development - ESB, messaging over and without SOAP - IoC, Unit testing, CI - Adapting software development Branimir has a background in Software development with about 15 years in the area of Enterprise Software Development for solutions based on the Microsoft stack.
Daniel Joskovski work in IT since 1985, he is a database-centric application developer and architect, instructor, course author, user group leader. Over the Past 17 Years as MCT he#39;s been teaching Microsoft SQL Server and .NET Development courses to premier customers in Macedonia, Serbia, Norway, Kosovo and Albania. From 2009 He is being awarded with Microsoft MVP award for SQL Server 8 times in a row. At the moment Daniel works for CloudCoder DOOEL Skopje.
LinkedIn: https://hu.linkedin.com/in/janosberke
Contact: http://www.iamberke.com
I am an IT professional with over a decade of technical and management experience. I am using SQL Server since version 6.5. Currently I am a consultant and helping companies in SQL Server design, migrations, operation and developments as well as providing customized training .
LinkedIn: https://www.linkedin.com/in/markus-ehrenmueller/
Contact: http://www.savorydata.com
Markus Ehrenmueller-Jensen, as the founder of Savory Data, has a long history of providing customer solutions in the areas of data engineering, data science, and Business Intelligence. He is a certified software engineer, a graduated business educator, and professor of Databases Project Management at HTL Leonding, and is certified as an MCSE MCT. He is a published author and writes articles for well-known journals. He co-founded PASS Austria and organizes SQLSaturdays in Austria. Markus is a founding member of Power BI Usergroup Austria. Since 2017 Markus was awarded as an Microsoft Data Platform MVP.
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: http://uk.linkedin.com/in/dageop
Contact: http://www.yoursqlman.com/index.php/blogs
Dr.SubraMANI Paramasivam is a Microsoft MVP, PhD, Microsoft Certified Trainer and Head of Data AI at DAGEOP Ltd having 21 years of DB, BI, Analytics and AI experience. Mani has also spoken in various events like MS IGNITE, PASS Summit, MS Inspire, SQLBITS, Power Platform Summit, Global AI Bootcamp, Data BI Summit, SQLRelay, Power BI World Tour, Data Platform Summit, INSIDESQL UK, Global AI Nights, SQLServerGeeks Summit, MCT Global Summits, Data Day Events and various user group events. Mani also believes in Empowering Every Person in the planet and spreads the awareness on Global challenges via www.EmpoweringEveryPerson.com. He is also a co-owner of 1 Global AI Meetup and 3 Power BI PUG PASS local / user groups.
LinkedIn: https://bg.linkedin.com/in/ivelin
Contact: https://www.slideshare.net/ivoandreev
Ivelin is a Microsoft Azure MVP and software architect in one of the leading and highly innovative Bulgarian IT brands - Interconsult Bulgaria Ltd. He is an external ICT expert in the European Commission, Eurostars-Eureka programme and Innovation Fund Denmark, Microsoft professional developer, senior project manager and Data Platform specialist. With 17+ years of strong experience in design and development of web systems, SOA, enterprise integration, machine learning, web security and data management, he is a practical man who always tries to balance between risk and flexibility. Never scared of work he has turned the weighing of pros and cons into own marked style that urges to make conscious decisions.
The following is a list of sponsors that helped fund the event.