sqlsathistory

Nr: 747

Back to Main list

SQLSaturday #747 - Timisoara 2018

Start Time (24h)	Speaker	Track	Title
09:00:00	Liviu Ieran	Application Database Development	SQL Server 2017 - Understanding Statistics
09:00:00	Laurentiu Codorean-Onea	Application Database Development	How powerful is Power BI?
10:00:00	André Melancia	Application Database Development	If a machine can learn, why can't YOU learn Azure Machine Learning?
10:00:00	Cristian Lefter	Application Database Development	SQL Code Smells
11:00:00	Mihail Mateev	Application Database Development	Dealing with CosmosDB
11:00:00	Dragos-Cristian Furdui	Enterprise Database Administration Deployment	SQL SERVER - Next station Azure
13:00:00	Ozana Buse	Application Database Development	S (tudent) QL - SQL Server guide for students
13:00:00	Mihail Mateev	Application Database Development	IoT Duel - Cloud vs. on Premises Solutions
14:00:00	Tobias Koprowski	Enterprise Database Administration Deployment	AD 2018. 2 AM. A Disaster just Began...
14:00:00	Alexandra Ciortea	Enterprise Database Administration Deployment	SQL in GDPR Context

SessionID: 77051

SQL Server 2017 - Understanding Statistics

Back to calendar

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

Speaker: Liviu Ieran

Title: SQL Server 2017 - 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. This will help you troubleshoot query performance at a more deeper level.

SessionID: 78628

How powerful is Power BI?

Back to calendar

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

Speaker: Laurentiu Codorean-Onea

Title: How powerful is Power BI?

Abstract:

I will walk attendees through some of the Power BI best practices and limitations, when using it in collaboration with SQL SERVER and SSAS.

SessionID: 73761

If a machine can learn, why can't YOU learn Azure Machine Learning?

Back to calendar

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

Speaker: André Melancia

Title: If a machine can learn, why can't YOU learn Azure Machine Learning?

Abstract:

Are you a DBA or Developer and would like to get started with AzureML the EASY WAY?

AzureML isn't just for "data scientists"... Anyone can use it! And after this session you'll be using it too... Disclaimer: Sadly, AzureML still can't predict what's on your girlfriend's mind. Nothing ever will.

SessionID: 75795

SQL Code Smells

Back to calendar

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

Speaker: Cristian Lefter

Title: SQL Code Smells

Abstract:

Can your T-SQL code be improved?

Where? And how? Code Smells are indications that your code can be refactored for better design, performance or even better security. In this session we will take a look at as many of them (code smells) as sixty minutes will allow us.

SessionID: 73865

Dealing with CosmosDB

Back to calendar

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

Speaker: Mihail Mateev

Title: Dealing with CosmosDB

Abstract:

CosmosDB service is a NoSQL is a globally distributed, multi-model database database service designed for scalable and high performance modern applications. CosmosDB is delivered as a fully managed service with an enterprise grade SLA. It supports querying of documents using a familiar SQL over hierarchical JSON documents. Azure Cosmos DB is a superset of the DocumentDB service. It allows you to store and query noSQL data, regardless of schema.

In this presentation, you will learn: • How to get started with DocumentDB you provision a new database account. • How to index documents • How to create applications using CosmosDb (using REST API or programming libraries for several popular language) • Best practices designing applications with CosmosDB • Best practices creating queries.

SessionID: 83291

SQL SERVER - Next station Azure

Back to calendar

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

Speaker: Dragos-Cristian Furdui

Title: SQL SERVER - Next station Azure

Abstract:

This session will cover the main aspects to start or migrate from an OnPremise model to one of the two architectures available in SQL Server on Azure, providing the keys to select the more suitable environment for our requirements.

We will cover:

1. Red pill or blue pill SQL Server on Azure VM (IaaS) vs SQL Azure DB (PaaS) Which one?
2. Always available. High availability in Azure
3. Now what ... Best practices and configuration connectivity.

SessionID: 82186

S (tudent) QL - SQL Server guide for students

Back to calendar

Event Date: 09-06-2018 - Session time: 13:00: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.

SessionID: 83775

IoT Duel - Cloud vs. on Premises Solutions

Back to calendar

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

Speaker: Mihail Mateev

Title: IoT Duel - Cloud vs. on Premises Solutions

Abstract:

This talk is a parallel, between IoT solutions, based on premise and systems, build with Microsoft Azure components. The presentation will cover the architecture, technology stack, implementation and best practices. We will consider pluses and deltas in different cases, using both approaches. You will see also many demos, which will help you to build own cloud based or on premises Internet of Things systems.

SessionID: 80597

AD 2018. 2 AM. A Disaster just Began...

Back to calendar

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

Speaker: Tobias Koprowski

Title: AD 2018. 2 AM. A Disaster just Began...

Abstract:

2AM. We sleeping well. And our mobile ringing and ringing. Message: DISASTER! In this session (on slides) we are NOT talk about potential disaster (such BCM); we talk about: What happened NOW? Which tasks should have been finished BEFORE. Is virtual or physical SQL matter? We talk about systems, databases, peoples, encryption, passwords, certificates and users. In this session (on few demos) I'll show which part of our SQL Server Environment are critical and how to be prepared to disaster. In some documents I'll show You how to be BEST prepared.

SessionID: 82174

SQL in GDPR Context

Back to calendar

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

Speaker: Alexandra Ciortea

Title: SQL in GDPR Context

Abstract:

The session targets positioning SQL Server in the current GDPR context. Different security functionalities as TDE, Always Encrypted, RLS and Dynamic Data Masking can enhance privacy and address certain GDPR requirements.

This site is open source. Improve this page.