sqlsathistory

Nr: 519

Back to Main list

SQLSaturday #519 - Plovdiv 2016

Start Time (24h) Speaker Track Title
10:00:00 Dr. Subramani Paramasivam Advanced Analysis Techniques Think work like a Data Scientist with SQL 2016 R.
10:00:00 Miroslav Dimitrov Enterprise Database Administration Deployment Performance Tuning for the Transaction Log
10:00:00 Ivan Donev Strategy and Architecture Why SQL server 2016 rocks
11:15:00 Sergiy Lunyakin BI Information Delivery Real-Time Dashboards on PowerBI
11:15:00 Dr. Subramani Paramasivam Enterprise Database Administration Deployment SQL Server 2016 has Gold plated bullet proof Database Engine
11:15:00 Margarita Naumova Enterprise Database Administration Deployment A deep dive into SQL Server Plan Cache Management
13:00:00 Luan Moreno Medeiros Maciel Cloud Application Development Deployment DBA Vs. Hacker: Protecting SQL Server
13:00:00 Kaloyan Kosev Application Database Development AlwaysOn Availability Groups for Developers
13:00:00 Margarita Naumova Enterprise Database Administration Deployment SQL Server 2016 Query Store – a flight recorder of your database
13:00:00 Branimir Giurov Application Database Development SQL Server 2016 and JSON Support
14:15:00 Andrey Nikolov Application Database Development T-SQL gotchas and powerups
14:15:00 Boriana Petrova BI Information Delivery Funky reports with Power BI for Excel and Office 365
14:15:00 Andrea Martorana Tusa BI Information Delivery New life for Reporting Services: what's up in 2016
15:45:00 Ivan Donev Application Database Development SQL Server 2016 - Always Encrypted deep dive
15:45:00 Andrea Martorana Tusa BI Information Delivery Mobile BI with Microsoft tools
15:45:00 Mihail Mateev Cloud Application Development Deployment Azure Data and Storage in a Nutshell

SessionID: 45240

Think work like a Data Scientist with SQL 2016 R.

Back to calendar

Event Date: 28-05-2016 - Session time: 10:00:00 - Track: Advanced Analysis Techniques

Speaker: Dr. Subramani Paramasivam

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.

SessionID: 46383

Performance Tuning for the Transaction Log

Back to calendar

Event Date: 28-05-2016 - Session time: 10:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Miroslav Dimitrov

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.

SessionID: 50274

Why SQL server 2016 rocks

Back to calendar

Event Date: 28-05-2016 - Session time: 10:00:00 - Track: Strategy and Architecture

Speaker: Ivan Donev

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!

SessionID: 45234

Real-Time Dashboards on PowerBI

Back to calendar

Event Date: 28-05-2016 - Session time: 11:15:00 - Track: BI Information Delivery

Speaker: Sergiy Lunyakin

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.

SessionID: 45241

SQL Server 2016 has Gold plated bullet proof Database Engine

Back to calendar

Event Date: 28-05-2016 - Session time: 11:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Dr. Subramani Paramasivam

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.

SessionID: 49161

A deep dive into SQL Server Plan Cache Management

Back to calendar

Event Date: 28-05-2016 - Session time: 11:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Margarita Naumova

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.

SessionID: 45598

DBA Vs. Hacker: Protecting SQL Server

Back to calendar

Event Date: 28-05-2016 - Session time: 13:00:00 - Track: Cloud Application Development Deployment

Speaker: Luan Moreno Medeiros Maciel

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!

SessionID: 46183

AlwaysOn Availability Groups for Developers

Back to calendar

Event Date: 28-05-2016 - Session time: 13:00:00 - Track: Application Database Development

Speaker: Kaloyan Kosev

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.

SessionID: 49162

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

Back to calendar

Event Date: 28-05-2016 - Session time: 13:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Margarita Naumova

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.

SessionID: 50710

SQL Server 2016 and JSON Support

Back to calendar

Event Date: 28-05-2016 - Session time: 13:00:00 - Track: Application Database Development

Speaker: Branimir Giurov

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:

SessionID: 45349

T-SQL gotchas and powerups

Back to calendar

Event Date: 28-05-2016 - Session time: 14:15:00 - Track: Application Database Development

Speaker: Andrey Nikolov

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.

SessionID: 45430

Funky reports with Power BI for Excel and Office 365

Back to calendar

Event Date: 28-05-2016 - Session time: 14:15:00 - Track: BI Information Delivery

Speaker: Boriana Petrova

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.

SessionID: 45614

New life for Reporting Services: what's up in 2016

Back to calendar

Event Date: 28-05-2016 - Session time: 14:15:00 - Track: BI Information Delivery

Speaker: Andrea Martorana Tusa

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.

SessionID: 45218

SQL Server 2016 - Always Encrypted deep dive

Back to calendar

Event Date: 28-05-2016 - Session time: 15:45:00 - Track: Application Database Development

Speaker: Ivan Donev

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!

SessionID: 45613

Mobile BI with Microsoft tools

Back to calendar

Event Date: 28-05-2016 - Session time: 15:45:00 - Track: BI Information Delivery

Speaker: Andrea Martorana Tusa

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.

SessionID: 50254

Azure Data and Storage in a Nutshell

Back to calendar

Event Date: 28-05-2016 - Session time: 15:45:00 - Track: Cloud Application Development Deployment

Speaker: Mihail Mateev

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:

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.

This site is open source. Improve this page.