sqlsathistory

Nr: 665

Back to Main list

SQLSaturday #665 - Bucuresti 2017

Start Time (24h) Speaker Track Title
10:00:00 Kaloyan Kosev Enterprise Database Administration Deployment Embrace the future: Running SQL Server in containers
10:00:00 Sorin Peste Cloud Application Development Deployment Azure SQL Database - It's Just SQL Server Without the Headaches, Right?!
10:00:00 Alice-Lavinia Pasare Enterprise Database Administration Deployment SQL XML unleashed
11:00:00 Mike Byrd Application Database Development In-Memory Tables --Formula One Performance Unleashed, Part 1
11:00:00 Catalin Gheorghiu Application Database Development IoT Circus – deathmatch oops, datematch :) Power Bi vs Time Series Insights
11:00:00 Octavian Cretu Enterprise Database Administration Deployment Distributed Availability Groups
13:00:00 Razvan Socol Application Database Development Graph tables in SQL Server 2017
13:00:00 Cristian Lefter Application Database Development Third Party Tools for SQL Server
13:00:00 Andrada Nastasie Enterprise Database Administration Deployment SQL Server migration
14:00:00 Dr. Subramani Paramasivam Analytics and Visualization PowerBI On-Premises Vs Cloud
14:00:00 Gheorghe-Bogdan SAHLEAN Analytics and Visualization Custom Visuals in PowerBI
14:00:00 Liviu Ieran Application Database Development SQL Server 2016 - Understanding Statistics

SessionID: 65058

Embrace the future: Running SQL Server in containers

Back to calendar

Event Date: 16-09-2017 - Session time: 10:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Kaloyan Kosev

Title: Embrace the future: Running SQL Server in containers

Abstract:

Well, the future is now. Join me in demo heavy session covering SQL server running in containers. Starting from scratch we will go through a complete container implementation.

SessionID: 67713

Azure SQL Database - It's Just SQL Server Without the Headaches, Right?!

Back to calendar

Event Date: 16-09-2017 - Session time: 10:00:00 - Track: Cloud Application Development Deployment

Speaker: Sorin Peste

Title: Azure SQL Database - It's Just SQL Server Without the Headaches, Right?!

Abstract:

The Azure SQL Database service's promise to us is simple: we get the nice features of SQL Server, with none of the management and operations hassle. But is it always that simple? Join this session for an overview about what this service really is, its strengths and weaknesses, and how to get the most bang for your database buck in the real world.

SessionID: 69429

SQL XML unleashed

Back to calendar

Event Date: 16-09-2017 - Session time: 10:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Alice-Lavinia Pasare

Title: SQL XML unleashed

Abstract:

This session covers XQuery implementation and XML index performance considerations.

SessionID: 64920

In-Memory Tables --Formula One Performance Unleashed, Part 1

Back to calendar

Event Date: 16-09-2017 - Session time: 11:00:00 - Track: Application Database Development

Speaker: Mike Byrd

Title: In-Memory Tables --Formula One Performance Unleashed, Part 1

Abstract:

Query performance is what it is all about. SQL Server 2014/2016 now has the new in-memory functionality that takes a completely different approach to data access and manipulation. This session will consolidate the relevant information from all these sources so the production DBA/Developer will be able to understand, create, use, maintain, and trouble-shoot in-memory table functionality. This session will also examine several demo scripts showing performance gains using the in-memory tables with and without columnstore indexes over equivalent disk based tables.

This session is all about when and how to apply in-memory tables in a production environment. After this session you will

  1. Understand what in-memory tables are and how to create and maintain them including their limitations
  2. Be able to identify performance gains over equivalent disk back tables
  3. Comprehend the new data monitoring needed for in-memory table

SessionID: 66907

IoT Circus – deathmatch oops, datematch :) Power Bi vs Time Series Insights

Back to calendar

Event Date: 16-09-2017 - Session time: 11:00:00 - Track: Application Database Development

Speaker: Catalin Gheorghiu

Title: IoT Circus – deathmatch oops, datematch :) Power Bi vs Time Series Insights

Abstract:

Or how to visualize your data and find insights for beginner IoT developer

If you create an IoT solution today, you have a variety of components available to mix and match to make your solution, akin LEGO. You get your hardware and firmware right and you get data from the sensors, now what? Of course, you would like to have, some data visualization easy and fast, and of course you would like to learn something from that data easy and fast. And it would be nice to have the results available on mobile devices, yes, yes easy and fast. Now enter our two titan technologies in a match to the death oops data trying to achieve these goals, you guess it easy fast (and cheap). And we will see them clash, from real hardware, to the big Azure cloud, to mobile devices, trying to outmatch each other.

SessionID: 69081

Distributed Availability Groups

Back to calendar

Event Date: 16-09-2017 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Octavian Cretu

Title: Distributed Availability Groups

Abstract:

In this session we will look into detail behind the feature "Distributed Availability Groups". We will cover not only the advantages but also common issues encountered during the implementation and administration of the distributed availability groups.

SessionID: 67300

Graph tables in SQL Server 2017

Back to calendar

Event Date: 16-09-2017 - Session time: 13:00:00 - Track: Application Database Development

Speaker: Razvan Socol

Title: Graph tables in SQL Server 2017

Abstract:

SQL Server 2017 adds new features for storing data regarding graphs. In this session we will explore some of the details behind the implementation of these features, the advantages and drawbacks of the current implementation and evaluate the performance of various graph queries.

SessionID: 67308

Third Party Tools for SQL Server

Back to calendar

Event Date: 16-09-2017 - Session time: 13:00:00 - Track: Application Database Development

Speaker: Cristian Lefter

Title: Third Party Tools for SQL Server

Abstract:

During of my work in the field (for more than 17 years) I noticed that very few people are aware that SQL Server has a great ecosystem of partners that come with functionality where Microsoft tools don't do it, or don't go in depth. Even more, some of the are offered for free and my session will expose as many as possible.

SessionID: 69292

SQL Server migration

Back to calendar

Event Date: 16-09-2017 - Session time: 13:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Andrada Nastasie

Title: SQL Server migration

Abstract:

Best practices and recommendations for SQL Server migrations.

SessionID: 64780

PowerBI On-Premises Vs Cloud

Back to calendar

Event Date: 16-09-2017 - Session time: 14:00:00 - Track: Analytics and Visualization

Speaker: Dr. Subramani Paramasivam

Title: PowerBI On-Premises Vs Cloud

Abstract:

Microsoft initially released PowerBI online services which had restriction of developing dashboards and reports online only. Then came the PowerBI desktop for easy onsite development including the complex DAX logics.

PowerBI support to SQL Server 2016 Reporting Services is a major breakthrough for any dashboards without any need to host in the Cloud.

In this session, we will explore and compare the features availale on PowerBI Online Services and PowerBI On-prem SSRS 2016. This session also covers the PowerBI Roadmap for both on-prem and cloud solutions.

SessionID: 67307

Custom Visuals in PowerBI

Back to calendar

Event Date: 16-09-2017 - Session time: 14:00:00 - Track: Analytics and Visualization

Speaker: Gheorghe-Bogdan SAHLEAN

Title: Custom Visuals in PowerBI

Abstract:

This session will show how to create a custom PowerBI Visual using some basic knowledge about web development and how to integrate it into PowerBI reports or dashboards.

SessionID: 69232

SQL Server 2016 - Understanding Statistics

Back to calendar

Event Date: 16-09-2017 - Session time: 14:00:00 - Track: Application Database Development

Speaker: Liviu Ieran

Title: SQL Server 2016 - Understanding Statistics

Abstract:

When analyzing Query plans understanding statistics and what role they play is a very important part.

The session will be mostly demo based and will show you how to interpret the stats histogram and how SQL estimates the rows returned from a given table. It will also include a demo of the new query profile dmv.