SQLSaturday #519 - Plovdiv 2016

Event Date: 05/28/2016 00:00:00

Event Location:

Culture Centre “Boris Hristov”
15 Gladston Str., 4000 Plovdiv, Bulgaria
Plovdiv, Plovdiv, Bulgaria

This event has completed. All data shown below is from the historical XML public data available.

Sessions
Speakers
Sponsors

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: New life for Reporting Services: what’s up in 2016

Abstract: During 2015 PASS Summit, Microsoft announced a roadmap to harmonize and standardize its BI reporting solutions into one unique hybrid scenario. Reporting Services will play a crucial role in this new architecture. Starting from 2016 release, Reporting Services will be the Microsoft’s on-premises solution for BI report delivery, meaning that it will host on-premises standard report as well as mobile report as well as Power BI Desktop report. To achieve this goal Reporting Services has been completely revisited and redesigned. Rendering engine has been rewritten in HTML5 to support every modern browser.
Come to this session to have an overview of the new features introduced in Reporting Service 2016. You will see the brand new portal supporting both paginated and mobile reports, how to pin charts to Power BI dashboards, how to position report parameters the way you want, how to export reports to PowerPoint, the new charts introduced and many other exciting outlines.

Speaker(s):

Andrea Martorana Tusa

Track and Room: BI Information Delivery - Ground floor hall

Title: DBA Vs. Hacker: Protecting SQL Server

Abstract: This was never showed before, a Hacker and DBA fighting against the time! The brilliant hacker mind trying to intrude and gain access inside of SQL Server to steal the most valued data using the Kalil Linux distribution when in other side the DBA avoing such achievement by using the security best practice and features available on SQL Server.

A Hacker’s goal is to find vulnerabilities in a system and a DBA’s goal is to make the environment secure and reliable. In this session we will learn how to protect SQL Server from the various forms of attacks that a smart hacker can throw at you. Let’s dig in the Hacker thought process to understand the inception of the attack and how to defeat the invasion. Join with me in this internal session using SQL Server and Kali Linux for the ultimate security showdown!

Speaker(s):

Luan Moreno Medeiros Maciel

Track and Room: Cloud Application Development Deployment - Small Conference Hall

Title: Mobile BI with Microsoft tools

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 April of 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

Track and Room: BI Information Delivery - Big Conference Hall

Title: SQL Server 2016 Query Store – a flight recorder of your database

Abstract: If you are a DBA you know that troubleshooting query performance can become a nightmare, all you have is your current plan cache as a source, and some DMVs to query it. With the Query Store feature, SQL Server 2016 saves historical execution plans. Not only that but it also saves the query statistics that go along with those historical plans. This is a great new feature which allows you to track execution plans performance for your queries over time. Similar to an airplane’s flight data recorder, Query Store collects and presents detailed historic information about all queries, greatly simplifying performance tuning by reducing the time to diagnose and resolve issues.

Speaker(s):

Margarita Naumova

Track and Room: Enterprise Database Administration Deployment - Ground floor hall

Title: Azure Data and Storage in a Nutshell

Abstract: Azure Data and Storage are one of the main parts of Microsoft Azure. It includes many different services like:

Azure SQL Database
Azure SQL Data Warehouse (in preview)
Azure Data Lake Store (in preview)
Document DB
Azure Storage (Blobs, Tables , Queues and File Service)
Azure Search
Redis Cache

These storage and data services offer different type of data - relational, noSQL, file service, distributed cache etc. Often when you work on a design of a cloud solution you need to consider the best option to use some of these services, based on the functionality, throughput, data size and price. This talk is comparison between these storage by features and price. We will discuss about the best practices to use some of these services. The presentation also compares Azure Data and Storage services with similar features of other public clouds like AWS.

Speaker(s):

Mihail Mateev

Track and Room: Cloud Application Development Deployment - Small Conference Hall

Title: A deep dive into SQL Server Plan Cache Management

Abstract: As an experienced DBA you have probably asked yourself questions like how the memory is consumed, is my system well-tuned, and is my memory configuration well defined. In order to understanding such processes as local and global Memory pressure, caches concurrency, adding and removing plans from cache we will go through the internal organization of the plan cache, the metadata available, how SQL Server finds a plan in cache, plan cache sizing, and the plan eviction policy. We will point out the important cache consumers that affect your workload and how to get metadata about them, what are the thresholds in Cache Size Management. At the end you will understand how to monitor the memory consumers in your SQL Server, what are wait types that we need to look for, how to understand if your system is well-tuned and the memory configuration is well defined. You will have a clear understanding of cache plan itself, the problems in cache and how to avoid them.

Speaker(s):

Margarita Naumova

Track and Room: Enterprise Database Administration Deployment - Ground floor hall

Title: Think work like a Data Scientist with SQL 2016 R.

Abstract: What are these DATA Scientists upto? How can we see their statistical model in our day to day familiar tool like Microsoft SQL Server?

You now have answers to these questions and thanks to Microsoft for integrating R Revolution within new SQL Server 2016. We all now have the opportunity to use R packages and see the outcome within SQL 2016 itself.

In this session, you will definitely take away a breakthrough concept of Advanced R Analytics within SQL 2016 and get ready to kick your creative horse, and go beyond your imagination on how you can build advanced analytics and impress your employers/customers.

Speaker(s):

Dr. Subramani Paramasivam

Track and Room: Advanced Analysis Techniques - Big Conference Hall

Title: AlwaysOn Availability Groups for Developers

Abstract: It’s often difficult to choose a high-availability solution and to build your applications around it, Come join me in a session focused on AlwaysOn Availability Groups - how they actually work, how to get the most of them, learn the benefits they provide and the limitations they have. Or at least put a DB Administrator on the interrogation table.

Speaker(s):

Kaloyan Kosev

Track and Room: Application Database Development - Small Conference Hall

Title: Real-Time Dashboards on PowerBI

Abstract: Power BI enables you to create beautiful and very informative dashboards for business users. You can use embedded connectors to many sorts of data sources for getting your data. Moreover, you can get data from real-time data sources as well, for instance monitoring systems, sensors, web sites etc, and get the most from your data. Join this session to learn how to use PowerBI REST API to add real-time dashboards, integrate with external applications and use custom visuals.

Speaker(s):

Sergiy Lunyakin

Track and Room: BI Information Delivery - Small Conference Hall

Title: SQL Server 2016 has Gold plated bullet proof Database Engine

Abstract: Every release of SQL Server has fixed various issues for different customer requirements. This 2016 has not just fixed such type but has started a new era of solution to the current cha(lle)nging world.

In this session, I will let you have a quick look around the new DB Engine feature enhancements like Stretch Database, Built-in JSON Support, Columnstore Indexes, In-Memory OLTP, Live Query Statistics, Query Store, Temporal Tables, Backup to Microsoft Azure, Managed Backup, enabled Trace flag 4199 behaviours, TempDB Database and PolyBase technology.

Speaker(s):

Dr. Subramani Paramasivam

Track and Room: Enterprise Database Administration Deployment - Big Conference Hall

Title: SQL Server 2016 and JSON Support

Abstract: SQL Server 2016 introduces support for JSON data type. In this session we’ll talk about how is the JSON support implemented, the built-in functions and operators such as:

How to get or modify a JSON value with JSON_MODIFY
Check if a JSON value is valid or not
JSON formatting
Read and write JSON data – supported storage types
and some cool ways of using it

Speaker(s):

Branimir Giurov

Track and Room: Application Database Development - Big Conference Hall

Title: Funky reports with Power BI for Excel and Office 365

Abstract: The session will show how to prepare cool reports with Excel and publish them to Office 365.

Speaker(s):

Boriana Petrova

Track and Room: BI Information Delivery - Small Conference Hall

Title: SQL Server 2016 - Always Encrypted deep dive

Abstract: With SQL Server 2016 Microsoft introduced a ground breaking feature for data encryption - Always Encrypted. It enables you to encrypt sensitive data at all times so that even people with elevated privileges do not have the power to decrypt it. But how easy is that feature to implement? Are there any hidden stones? Does this change how I write my applications? I will answer those and many more questions, so just join me and do not forget to bring your coffee for this intensive session with SQL Server 2016 Always Encrypted!

Speaker(s):

Ivan Donev

Track and Room: Application Database Development - Ground floor hall

Title: Why SQL server 2016 rocks

Abstract: SQL Server is released in just a few days and I want to share with you all the major improvements we did in the product that will make your data live and rock your world!

Speaker(s):

Ivan Donev

Track and Room: Strategy and Architecture - Ground floor hall

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 - Small Conference Hall

Title: T-SQL gotchas and powerups

Abstract: You are a database developer and you write a lot of T-SQL queries. But do you want to know what are the most common mistakes that database developers do? Or to hear about some of the widely unused performance powerups that SQL Server can offer? Do you find the syntax of OVER clause so confusing that you need to look it up Books Online every time when you use it? Join this session and learn things that every database developer should know.

Speaker(s):

Andrey Nikolov

Track and Room: Application Database Development - Big Conference Hall

Speakers

This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

Boriana Petrova

Twitter: - borianapetrova

LinkedIn: Boriana Petrova

Contact: http://itraining.bg/category/itraining-blog/

Microsoft Certified Trainer with over 10 years experience as an IT instructor and Consultant. She has many qualifications and professional certifications, including: Excel MVP, MCT, MCITP, MCTS, MOS Master. In 2008 she is among the TOP 25 of the best instructors in Microsoft World Company business evaluation and measurement - Knowledge Advisors.

Kaloyan Kosev

Twitter: - https://twitter.com/nosqltillcoffee

LinkedIn: Kaloyan 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.

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.

Sergiy Lunyakin

Twitter: - slunyakin

LinkedIn: Sergiy Lunyakin

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.

Andrea Martorana Tusa

Twitter: - bruco441

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).

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.

Branimir Giurov

LinkedIn: Branimir Giurov

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.

Dr. Subramani Paramasivam

Twitter: - https://twitter.com/dageop

LinkedIn: Dr. Subramani Paramasivam

Contact: http://www.yoursqlman.com/index.php/blogs

Andrea Martorana Tusa

Twitter: - bruco441

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

Andrea is an author for sqlshack.com, sqlservercentral.com, and UGISS (User Group Italiano SQL Server).

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).

Margarita Naumova

LinkedIn: Margarita Naumova

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.

Ivan Donev

Twitter: - https://twitter.com/ikdonev

LinkedIn: Ivan Donev

Luan Moreno Medeiros Maciel

Twitter: - @luansql

LinkedIn: Luan Moreno Medeiros Maciel

Contact: https://luanmorenodba.wordpress.com/ amp; http://www.sqlshack.com/author/luan-moreno-m-maciel/

Based out of Brazil, Luan Moreno credits his ability to solve problems to thinking critically before acting. He values working with a team because he and his clients can benefit from various perspectives and collaboration, particularly when faced with difficult issues. When Luan Moreno first became interested in technology, he didn’t have a mentor, so he made a commitment to teaching others in the community and sharing his knowledge through blogging, speaking engagements.

Luan Moreno is a addicted Brazilian blogger and speaker. SQL Server MCT, MCSE and MVP living in Brazil. Nowadays he#39;s a Database Consultant at Pythian, company based in Ottawa - Canada.#160;

Andrey Nikolov

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.

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.

Margarita Naumova

LinkedIn: Margarita Naumova

Contact: www.maginaumova.com; http://blogs.technet.com/b/magi/

Ivan Donev

Twitter: - https://twitter.com/ikdonev

LinkedIn: Ivan Donev

SQLSaturday #519 - Plovdiv 2016

Sessions

Title: New life for Reporting Services: what’s up in 2016

Title: DBA Vs. Hacker: Protecting SQL Server

Title: Mobile BI with Microsoft tools

Title: SQL Server 2016 Query Store – a flight recorder of your database

Title: Azure Data and Storage in a Nutshell

Title: A deep dive into SQL Server Plan Cache Management

Title: Think work like a Data Scientist with SQL 2016 R.

Title: AlwaysOn Availability Groups for Developers

Title: Real-Time Dashboards on PowerBI

Title: SQL Server 2016 has Gold plated bullet proof Database Engine

Title: SQL Server 2016 and JSON Support

Title: Funky reports with Power BI for Excel and Office 365

Title: SQL Server 2016 - Always Encrypted deep dive

Title: Why SQL server 2016 rocks

Title: Performance Tuning for the Transaction Log

Title: T-SQL gotchas and powerups

Speakers

Sponsors