SQLSaturday #475 - Belgrade 2015
Event Date: 11/28/2015 00:00:00
Event Location:
- Microsoft Software d.o.o.
- Španskih boraca 3/III
- Belgrade, Belgrade, Serbia
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: Analyzing Text with SQL Server, R, and Azure ML
Abstract: Text mining is becoming more and more popular. Everybody would like to understand data from blogs, Web sites, and social media. Microsoft SQL Server in versions 2012 and 2014 enhances full-text search support that was substantially available in previous editions. Semantic Search, a new component in Full-Text Search, can help you understanding the meaning of documents. The Term Extraction and Term Lookup components from SQL Server Integration Services also help with text analysis. Free statistical package / language R is also useful for the text mining tasks. Azure ML is adding additional techniques to the big picture. However, the question arises: is all this enough? This presentation unveils the good and the bad side of text mining with the tools mentioned.
Speaker(s):
- Dejan Sarka
Track and Room: Advanced Analysis Techniques - Room 2 (65 seats)
Title: Visualizing streaming data in real time
Abstract: We’re all familiar with reports or dashboards that show you a static snapshot of the data that has to be refreshed on an interval. And those are very important visualizations. But sometimes you just have to have a real time view of your data streams and snapshots aren’t enough. What if you could monitor multiple servers with SQL Trace or Extended Events or had some other source of streaming data and be able to see it all happening live on a central monitoring website? This is a scenario we’ll take a detailed look at and build a system for such monitoring. We’ll do this by using Extended Events .Net provider to get the live data stream, SignalR to get the live stream from the server to the website and the D3 javaScript library for actual real time visualizations on any device. After seeing all this in action, you’ll definitely get a few ideas on where you could use this in your company.
Speaker(s):
- Mladen Prajdić
Track and Room: BI Information Delivery - Room 1 (55 seats)
Title: Complex Event Processing with Azure Stream Analytics
Abstract: Azure Stream Analytics targets complex event streams (CEP’s) to deduce meaningful patterns. Most of the typical use cases for this product is when various devices and sensors are sending data for further processing.
This technology uses a T-SQL like syntax to express its intents. A language that most data-power users will be familiar with.
The biggest advantage of Stream Analytics is when events are being published to the Stream Analytics, the only thing that event publishers needs to know is which Event Bus or Blob storage to place the data. Stream Analytics will then fetch the data.
This talk is about the main concepts and solution architecture when using Azure Stream Analytics, and also how to use this technology together with MS SQL Server, Azure SQL Database and Power BI.
Speaker(s):
- Mihail Mateev
Track and Room: Analytics and Visualization - Room 2 (65 seats)
Title: Tired of connecting on-prem cloud data? Take a DB stretch
Abstract: You can stretch your legs and relax and get a quick session on delivering your analytics against hot, warm cold data. Stretch Database is the new concept, which allows you to stretch from on-prem to cloud easily and this session will enable you to understand enabling / disabling data stretch, accessing data using stretch database, setup remote data archiving, basic concepts on enabling database/table and backup restore for the stretch enabled databases. Stretch DB also covers the concepts of Shallow Deep backups. However, Deep backups are not currently supported with SQL Server 2016 CTP2.
Speaker(s):
- Dr. Subramani Paramasivam
Track and Room: Cloud Application Development Deployment - Room 1 (55 seats)
Title: Performance Tuning for the Transaction Log
Abstract: SQL Server transaction log is one of the most critical components of the database and in the same time one of the most misunderstood. While being neglected it can easily become a bottleneck for our system. Are you interested in learning how to avoid issues with the transaction log and streamline its work? In these sessions we will explore how to optimize it, configure it and keep it under control.
Speaker(s):
- Miroslav Dimitrov
Track and Room: Enterprise Database Administration Deployment - Room 1 (55 seats)
Title: SQL Server Advanced indexing techniques
Abstract: SQL Server indexing is an art. Choosing the right index for the right solution might just not be enough. Options are also without boundaries, but still there are several rules you must always apply to design an effective indexing strategy. Join me in this session and find out about these rules, how the SQL Server optimizer chooses an index and most importantly - is your index useful enough or is just a burden to your database.
Speaker(s):
- Ivan Donev
Track and Room: Application Database Development - Room 2 (65 seats)
Title: IoT and SQL (Server)
Abstract: Or IoT for DBAs And we are not talking about Oracle Index Organized Tables, we are talking about Internet of Things. This buzzword you hear almost everywhere, and for sure needs databases. So let’s take the Microsoft vision of IoT and see the database side of it. We will talk about the vision of IoT and the real world practicalities of it. The presentation goal is to provide a DBA all he/she needs to know to support an IoT application. And to make you curious we will cover topics such SQL 2014 for Embedded Systems or the Azure offerings (and their SQL connections), and I will try full demos with IoT hardware.
Speaker(s):
- Catalin Gheorghiu
Track and Room: Application Database Development - Room 1 (55 seats)
Title: Top 10 SSAS Solution Design Best Practices
Abstract: Proper design of cubes, dimensions, hierarchies and attributes is critical to optimal performance of SQL Server Analysis Services solutions.
I’ve collected a number of best practices during the years I’ve spent on building and maintaining OLAP cubes. In this session, we will go through the most important ten of these, so you can consider them in your everyday work when you build analytical back-end solutions with SSAS. Join this session, and see how these tips and best practices can save your precious time.
Speaker(s):
- Zoltán Horváth
Track and Room: BI Platform Architecture, Development Administration - Room 2 (65 seats)
Title: Optimizacija DWH rešenja u praksi
Abstract: Često velike kompanije imaju BI alate (Cognos, SAS, Informatica Tableau,…) koji kao izvor koriste MS SQL Server. Kako optimizovati dimanzionu bazu podataka na MS SQL Server 2012/2014 tako da se ona može podjednako dobro koristiti kao ROLAP za ad hoc izveštavanje kao i za izvođenje promenljivih za potrebe data mining-a? Na ovom predavanju biće prikazano kako koristiti funkcionalnosti MS SQL Server 2012/2014 kao što su Column Stored Index, Sequence objekat, SUM() OVER() za računanje running totala, particionisanje, kompresija,… Takođe, na predavanju će biti prikazano kako upravljati rastom dimenzione baze.
Speaker(s):
- Vladimir Markovic
Track and Room: BI Platform Architecture, Development Administration - Room 1 (55 seats)
Title: When good pages go bad / The rise and fall of db corruption.
Abstract: We’ll walk through how to detect and repair corruption in a database. The DBCC command is the most important part and its output will be covered. The different methods to repair the pages gives different amounts of data loss, so we’ll go through some of your options such as page level restore, DBCC repair options and some other options. Finally you’ll learn to estimate how much data loss you can expect. We’ll even going to see how to look at the corrupt page with DBCC PAGE to try to see approximately what data we are going to loose.
Speaker(s):
- Mikael Wedham
Track and Room: Enterprise Database Administration Deployment - Room 2 (65 seats)
Title: SQL Server 2016: Operational Analytics
Abstract: Microsoft SQL Server 2016 alloows you to run analytic queries on in-memory and disk-based OLTP tables with minimal impact on business critical OLTP workloads, requiring no application changes. This session covers various configurations and best practices for achieving significant performance gains with Operational Analytics.
Speaker(s):
- Dragoslav Ogar
Track and Room: Application Database Development - Room 2 (65 seats)
Title: SQL Server 2014 Memory-optimized Data Exchange
Abstract: SQL Server 2014 introduces Extreme Transaction Processing, a brand new memory-optimized data management feature, targetting OLTP workloads. In this session you will learn about two new, and not very well known, features that you can use to share sets of data between modules - either within the database, or between client applications and databases:
- Memory-optimized Table Variables; and
- Memory-optimized Table-valued Parameters.
Speaker(s):
- Matija Lah
Track and Room: Application Database Development - Room 1 (55 seats)
Title: Temporal Tables in SQL Server 2016
Abstract: Temporal tables are defined in the SQL 2011 standard and now transactional (system-versioned) temporary tables are included in Azure SQL Database and SQL Server 2016.
In this session we’ll explain why we need them, how system-time tables work and demonstraint how to design and implement solutions for common use cases that involve temporal tables…
Speaker(s):
- Miloš Radivojević
Track and Room: Application Database Development - Room 2 (65 seats)
Title: Welcome Note - Room 1
Abstract: Keynote session
Speaker(s):
- Dejan Pervulov
Track and Room: Other - Room 1 (55 seats)
Title: Welcome Note - Room 2
Abstract: Welcome Note
Speaker(s):
- Goran Milanov
Track and Room: Other - Room 2 (65 seats)
Title: High Availability - Partial Database Availabilty
Abstract: High availability starts at database design. This session will show how to design your database supporting partial database availability. Session agenda is the follwoing:
- What is RPO/RTO?
- What HA options are available?
- Database physical layout basics
- DEMO: files and filegroups
- Multiple filegroups and files
- Filegroup/file restore options
- DEMO: online restore
- DEMO: Auto Page repair in AAG and DBM
- DEMO: offline restore (if time permits)
Speaker(s):
- Janos Berke
Track and Room: Enterprise Database Administration Deployment - Room 1 (55 seats)
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Dr. Subramani Paramasivam
Twitter: - https://twitter.com/dageop
LinkedIn: Dr. Subramani Paramasivam
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.
Mladen Prajdić
Twitter: - @MladenPrajdic
LinkedIn: Mladen Prajdić
Contact: http://weblogs.sqlteam.com/mladenp
Mladen Prajdić is a Data Platform MVP from Slovenia. He’s been programming for 20 years, developing different types of applications in .Net (C#) and SQL Server, ranging from standard line-of-business, image-processing applications to high performace and IoT applications. He’s a regular speaker at various conferences and usergroup meetings, really likes to optimize slow SQL statements, analyze performance, and find unconventional solutions to difficult SQL Server problems. In his free time, he also develops a very popular add-in for SSMS, called the SSMS Tools Pack (www.ssmstoolspack.com).
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.
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.
Janos Berke
Twitter: - @JanosBerke
LinkedIn: Janos Berke
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 .
Vladimir Markovic
LinkedIn: Vladimir Markovic
Contact: https://rs.linkedin.com/in/vlmarkovic
https://rs.linkedin.com/in/vlmarkovic
Dejan Pervulov
Twitter: - @dekiper
As a technical consultant Dejan participated in numerous ERP, CRM and DWH / BI projects in the CEE region. He is also involved in development with Microsoft technologies for last 18 years. Holds MCT, MCSE, MCSA, MCSD, MCDBA, MCTS and MCITP certifications. As a Microsoft Certified Trainer he was involved in preparation and delivery of trainings in several school centers in Serbia. Since October 2014, he is a Microsoft MVP for SQL Server.
Dragoslav Ogar
LinkedIn: Dragoslav Ogar
Dragoslav Ogar is a CEO/Consultant/Trainer of A4ATCP d.o.o. Belgrade. He has 25 years of real-life and theoretical experience with information technologies. He is a tch.math. As Microsoft trainer, he delivered about 70 different MOCs at all and more than 15,000 hours. On five Microsoft conferences, Sinergija 04, 06, 10, 11 and 13, held in Serbia, he was awarded as one of best speakers. Except SQL Server field, his favorite areas are Entity Framework, OData, MVC, and SOLID, also.
Catalin Gheorghiu
Twitter: - MrSmersh
LinkedIn: Catalin Gheorghiu
Contact: http://ronua.ro/author/catalin/
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.
Goran Milanov
LinkedIn: Goran Milanov
Contact: http://www.goranmilanov.rs
My areas of interest are Microsoft SQL Server and its services as the bases for development of Data Warehouse and Business Intelligence Systems (SSAS, SSRS, SSIS, MDS, DQS, PowerPivot, Tabular Model …). For the last five years I have been one of the coordinators of the Belgrade SQL Server User Group. In April 2012, I got the first Microsoft MVP award.
Ivan Donev
Twitter: - https://twitter.com/ikdonev
LinkedIn: Ivan Donev
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).
Matija Lah
Twitter: - @MatijaLah
LinkedIn: Matija Lah
Contact: http://milambda.blogspot.com
Matija Lah has more than a decade of experience working with Microsoft SQL Server, mostly architecting data-centric solutions in the legal domain. His contributions to the SQL Server community have led to the Microsoft Most Valuable Professional award in 2007 (Data Platform), which he held until 2017. In 2008 Matija joined SolidQ as a Mentor, located in Central and Eastern Europe. He spends most of his time on projects involving advanced information management, and natural language processing.
Miloš Radivojević
Twitter: - MilosSQL
LinkedIn: Miloš Radivojević
Contact: https://milossql.wordpress.com/
Miloš Radivojević is a database consultant located in Vienna, Austria. He is Data Platform MVP and specializes in SQL Server for application developers and performance and query tuning. Currently, he works as a principal database consultant in bwin GVC (the largest regulated online gaming company in the world). He is co-founder of the SQL Pass Austria and speaks regularly at local and international database conferences. He is also co-author of the books SQL Server 2016 Developer’s Guide, SQL Server 2017 Developer’s Guide and Mastering SQL Server 2017.
Miroslav Dimitrov
Twitter: - @miro_dd
LinkedIn: Miroslav Dimitrov
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.
Zoltán Horváth
Twitter: - @zoltanhorvath
LinkedIn: Zoltán Horváth
Contact: http://addictivemeasures.blogspot.com
Zolt#225;n is a BI specialist with more than a decade of expertise. He leads the Hungarian User Group of Microsoft SQL Server (HUG-MSSQL), the Hungarian Chapter of PASS. MCSE: BI and MCSE: Data Platform. SQL Server MVP since 2015.
Mikael Wedham
Twitter: - @wedham
Contact: http://www.wedham.com
Mikael Wedham is the first SQL Server MCM in Sweden and the only one who also is a Microsoft Certified Trainer. He has been paid to do things in SQL Server since 1993. His long experience makes him an appreciated speaker at events and conferences all over Europe. To be prepared for deep dives, he is also certified as an Open Water Scuba Instructor.
Sponsors
The following is a list of sponsors that helped fund the event: