sqlsathistory

Nr: 805

Back to Main list

SQLSaturday #805 - Bucuresti 2018

Start Time (24h) Speaker Track Title
09:30:00 Peter Willmot Application Database Development Working with SQL Managed Data Types
09:30:00 Sorin Peste Application Database Development Azure SQL Database Managed Instance - Finally, SQL Server with None of the Headaches
09:30:00 Liviu Ieran Enterprise Database Administration Deployment SQL Server - Performance Basics
10:45:00 Peter Willmot Application Database Development Building low-cost back-end app services with SQL Express and .Net Core on Linux
10:45:00 Marcelo Fernandes Strategy and Architecture How to build solution for High Availability/Disaster Recovery
10:45:00 Janusz Rokicki Strategy and Architecture The Road to The Autonomous Databases
12:00:00 Dennes Torres BI Information Delivery PowerBI: From Zero to Hero
12:00:00 Marcelo Fernandes Strategy and Architecture Thinking out of the Box! - SMB 3.0
12:00:00 Catalin Gheorghiu Application Database Development “SQL-like” or query languages in Azure IoT
14:00:00 Andrey Nikolov Application Database Development The hidden power of Power BI or what we can do using Power BI REST API
14:00:00 Alexandru Dinica Enterprise Database Administration Deployment Upgrading to a newer SQL Server version: Tip, Tricks, Issues
14:00:00 Alexandra Ciortea Strategy and Architecture SQL vNext: What’s next?
15:15:00 Cristian Lefter Analytics and Visualization Data Storytelling
15:15:00 Ozana Buse Application Database Development S (tudent) QL - SQL Server guide for students

SessionID: 84159

Working with SQL Managed Data Types

Back to calendar

Event Date: 06-10-2018 - Session time: 09:30:00 - Track: Application Database Development

Speaker: Peter Willmot

Title: Working with SQL Managed Data Types

Abstract:

The Geospatial and Hierarchical managed data types were introduced with SQL 2005 but are sadly seldom used (or understood) by most developers more than a decade later. In this session Peter Willmot will take you on a guided tour of these data types and help you to understand the pros and cons of their inclusion in your database/application design.

SessionID: 84490

Azure SQL Database Managed Instance - Finally, SQL Server with None of the Headaches

Back to calendar

Event Date: 06-10-2018 - Session time: 09:30:00 - Track: Application Database Development

Speaker: Sorin Peste

Title: Azure SQL Database Managed Instance - Finally, SQL Server with None of the Headaches

Abstract:

Ever since Azure SQL Database was released way back in 2010, if you wanted to get SQL Server as cloud managed database service, you had to accept some compromises. SQL Server's cloud-born cousin came with missing features and different ways of doing things, some of them better, others just different, and still others came with specific caveats. But now, with the introduction of Managed Instance, we might have finally found our database holy grail: full-on SQL Server, as a service, with none of the management headaches. Could it really be that simple? Come to this session and find out.

SessionID: 84672

SQL Server - Performance Basics

Back to calendar

Event Date: 06-10-2018 - Session time: 09:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Liviu Ieran

Title: SQL Server - Performance Basics

Abstract:

Discover and learn how to approach a performance problem.

What information should I collect? What data should I gather? How to best approach the data analysis. Tips and tricks.

SessionID: 84157

Building low-cost back-end app services with SQL Express and .Net Core on Linux

Back to calendar

Event Date: 06-10-2018 - Session time: 10:45:00 - Track: Application Database Development

Speaker: Peter Willmot

Title: Building low-cost back-end app services with SQL Express and .Net Core on Linux

Abstract:

Learn how to leverage the latest SQL and .Net Core offerings to develop and deploy low-cost (including potentially license free), effective back-end application services on contemporary Linux platforms.

This session will provide an overview of challenges and opportunities, notably including:

SessionID: 84909

How to build solution for High Availability/Disaster Recovery

Back to calendar

Event Date: 06-10-2018 - Session time: 10:45:00 - Track: Strategy and Architecture

Speaker: Marcelo Fernandes

Title: How to build solution for High Availability/Disaster Recovery

Abstract:

How does your SQL Server environment meet the RPO and RTO service levels?

In this session, we will cover all aspects of HA / DR. We will cover all technology options and compare the benefits between them. We will also talk about processes to maintain your RPO and RTO level.

SessionID: 85231

The Road to The Autonomous Databases

Back to calendar

Event Date: 06-10-2018 - Session time: 10:45:00 - Track: Strategy and Architecture

Speaker: Janusz Rokicki

Title: The Road to The Autonomous Databases

Abstract:

Autonomous means capable of existing independently. Think maintenance free, self-healing, auto-tuning databases able to detect and automatically mitigate security risks. Sounds like impossible dream, but here is the best part - Azure is gradually making that next level of automation possible. Cloud economy of scale combined with unique features of Azure Sql PaaS resources transform and enhance the way we collect, store and process data. And that also affects our professional lives. Find out where we are on The Road to The Autonomous Databases, what are main building blocks, what kind of obstacles we still have to overcome and how to turn these challenges into opportunities.

SessionID: 84621

PowerBI: From Zero to Hero

Back to calendar

Event Date: 06-10-2018 - Session time: 12:00:00 - Track: BI Information Delivery

Speaker: Dennes Torres

Title: PowerBI: From Zero to Hero

Abstract:

Starting from the very beginning, in this session we will cross together the main features Power BI has to offer, starting with the powerful self-service ETL using M language when needed, modeling our tables and finally using powerful features to create a great data visualization, allowing you to better understand all the power and flexibility of this tool and how it will fit into your solution

SessionID: 84910

Thinking out of the Box! - SMB 3.0

Back to calendar

Event Date: 06-10-2018 - Session time: 12:00:00 - Track: Strategy and Architecture

Speaker: Marcelo Fernandes

Title: Thinking out of the Box! - SMB 3.0

Abstract:

In this session the SMB 3.0 protocol will be presented and how we can take advantages and increase the availability and performance of the environment by investing less in infrastructure.

SessionID: 85111

“SQL-like” or query languages in Azure IoT

Back to calendar

Event Date: 06-10-2018 - Session time: 12:00:00 - Track: Application Database Development

Speaker: Catalin Gheorghiu

Title: “SQL-like” or query languages in Azure IoT

Abstract:

If you are reading Azure IoT documentation you will stumble a lot on the “SQL-like query language” or “SQL-like language” syntagms.

In this presentation we will explore Azure IoT places where queries are used and see how to use them. And in the process to find out more about this “SQL-like” languages and how being a DB developer cam make you a IoT hero. We will concentrate on the scenarios with the greatest impact, where a little SQL can solve you a lot of hassle. So, we will leave no SQL query unturned in Azure IoT Hub, Stream Analytics, Power Bi to name a few.

SessionID: 84140

The hidden power of Power BI or what we can do using Power BI REST API

Back to calendar

Event Date: 06-10-2018 - Session time: 14:00:00 - Track: Application Database Development

Speaker: Andrey Nikolov

Title: The hidden power of Power BI or what we can do using Power BI REST API

Abstract:

Power BI is a very powerful tool. But behind the shiny UI, Power BI REST API gives you even more features to create better solutions! In this session we will explore what you can do using Power BI REST API and what you can’t (at least not yet!). I will demonstrate how your program can authenticate itself (both in interactive and non-interactive way), how it can add new rows to a dataset or refresh it programmatically, and how to share one dataset between multiple reports.

SessionID: 85048

Upgrading to a newer SQL Server version: Tip, Tricks, Issues

Back to calendar

Event Date: 06-10-2018 - Session time: 14:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Alexandru Dinica

Title: Upgrading to a newer SQL Server version: Tip, Tricks, Issues

Abstract:

Considering a SQL Server upgrade or migration? You’ll have to eventually.

In the session, we will try to present you some best practices regarding the SQL Server version upgrade and the roadblocks that you might hit along the road.

SessionID: 85223

SQL vNext: What’s next?

Back to calendar

Event Date: 06-10-2018 - Session time: 14:00:00 - Track: Strategy and Architecture

Speaker: Alexandra Ciortea

Title: SQL vNext: What’s next?

Abstract:

We will discuss the features under devopment in the upcoming release of SQL Server

SessionID: 85266

Data Storytelling

Back to calendar

Event Date: 06-10-2018 - Session time: 15:15:00 - Track: Analytics and Visualization

Speaker: Cristian Lefter

Title: Data Storytelling

Abstract:

Behind the data, behind the numbers, there is a hidden story and sometimes more. Our job is to discover the story and make it accessible to others.

SessionID: 85708

S (tudent) QL - SQL Server guide for students

Back to calendar

Event Date: 06-10-2018 - Session time: 15:15:00 - Track: Application Database Development

Speaker: Ozana Buse

Title: S (tudent) QL - SQL Server guide for students

Abstract:

As a student, how can SQL Server help with university projects or personal tech hobbies?

In the session we will talk about how SQL Server can help you learn, integrate it in your university projects, and many more.

This site is open source. Improve this page.