sqlsathistory

Nr: 980

Back to Main list

SQLSaturday #980 – Plovdiv – Virtual 2020

Start Time (24h)	Speaker	Track	Title
10:10:00	Marco Obinu	Strategy and Architecture	Implement a disaster recovery solution for your on-prem SQL with Azure? Easy!
10:10:00	Ramesh Satya	Application Database Development	Understanding SQL Server Views - The Right Way
10:10:00	Mihail Mateev	Application Database Development	Creating Custom Visuals in Power BI with TypeScript and D3.j
10:10:00	Ehab Abdelmonem	Cloud Application Development Deployment	Azure DevOps between reality and the fantasy :"Build DevOps CI/CD Pipelines"
11:20:00	Damir Matesic	Application Database Development	MS SQL New functions, syntaxes, tips tricks
11:20:00	Dean Savović	Application Database Development	SQL Server Intelligent Query Processing
11:20:00	Georgi Petkov	BI Platform Architecture, Development Administration	External Tools for Power BI
11:20:00	Anton Boyko	Cloud Application Development Deployment	Azure Logic Apps – how to integrate different systems with zero coding?
13:00:00	Dennes Torres	BI Platform Architecture, Development Administration	Self-Service ETL: The PowerBI Data Flows
13:00:00	Marco Dal Pino	Cloud Application Development Deployment	Azure SQL Database EDGE, put your SQL wherever you want!
13:00:00	André Melancia	Application Database Development	Row Level Security Deep Dive
13:00:00	Denis Reznik	Application Database Development	Why my query is slow and how to make it fast
14:10:00	Reinhard Flügel	Application Database Development	Known T-SQL but not to everybody (especially beginners) Insights and samples for T-SQL
14:10:00	Gonzalo Bissio	Enterprise Database Administration Deployment	Azure Sql DB Managed instance, a different sql server?
14:10:00	Damian Widera	Information Delivery	Quantum computing explained with demos!
14:10:00	Aleksandar Vetsev	BI Platform Architecture, Development Administration	End-to-End Business Intelligence Architecture in Azure
15:20:00	Boriana Petrova	BI Platform Architecture, Development Administration	Working with parameters in Power Query
15:20:00	Sebastiano Galazzo	Application Database Development	Machine Learning - Best Practices and Vulnerabilities
15:20:00	André Melancia	Advanced Analysis Techniques	Machine Learning is full of stars: An Azure Story
15:20:00	Rui Romano	BI Platform Architecture, Development Administration	Big Brother your Power BI deployment

SessionID: 102414

Implement a disaster recovery solution for your on-prem SQL with Azure? Easy!

Back to calendar

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

Speaker: Marco Obinu

Title: Implement a disaster recovery solution for your on-prem SQL with Azure? Easy!

Abstract:

Thanks to Azure cloud, today it's possible to design Disaster Recovery solutions that are easy to implement and affordable also for small and medium-sized companies.

From a SQL Server perspective, we can leverage on different technologies to manage cross-premises scenarios, where Always On Availability Groups technology represents the key feature to design a flexible solution that can be easily integrated with Azure Site Recovery. Let's see together what choices we have, with a particular focus on Availability Groups and their implementation in a hybrid scenario.

SessionID: 107681

Understanding SQL Server Views - The Right Way

Back to calendar

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

Speaker: Ramesh Satya

Title: Understanding SQL Server Views - The Right Way

Abstract:

VIEW is one of the programmable objects often used by Developers to build solutions to business problems but if not used without complete implications, there will be data inconsistency issues. This session focusses on how to create VIEWs, what are issues while doing DML operations through the VIEWS and how does INDEXED VIEWs help us.

SessionID: 109224

Creating Custom Visuals in Power BI with TypeScript and D3.j

Back to calendar

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

Speaker: Mihail Mateev

Title: Creating Custom Visuals in Power BI with TypeScript and D3.j

Abstract:

This presentation is about how to create custom visuals (components) for your PowerBI reports. Power BI reporting features could be extended with custom components, that developers can implement and BI specialist can include in their dashboards. Many visuals are also availabe in the Power BI Visuals Gallery.

Power BI is flexible with which graphical API you prefer to use, but their open source project is all D3.

D3.js is a JavaScript library of objects to produce sophisticated, interactive, dynamic data visualizations using modern web-based technologies

In this talk you will learn how to:

• Set up the dev environment (using PowerBI visuals CLI tool)
• Build your visuals
• Debug your Power BI components
• Use custom visuals in your dashboards
• Publish visuals to Power BI Visuals Gallery
• Road-map of Power BI Visuals API

SessionID: 109302

Azure DevOps between reality and the fantasy :"Build DevOps CI/CD Pipelines"

Back to calendar

Event Date: 12-12-2020 - Session time: 10:10:00 - Track: Cloud Application Development Deployment

Speaker: Ehab Abdelmonem

Title: Azure DevOps between reality and the fantasy :"Build DevOps CI/CD Pipelines"

Abstract:

DevOps, like most new methodologies, is only a catchword for many individuals working in IT industry. Everyone debates about it, but not everyone knows what it is.

In this session, we will talk about Azure DevOps and what is CI/CD then we are going to create a DevOps Pipeline and test it.

SessionID: 108233

MS SQL New functions, syntaxes, tips tricks

Back to calendar

Event Date: 12-12-2020 - Session time: 11:20:00 - Track: Application Database Development

Speaker: Damir Matesic

Title: MS SQL New functions, syntaxes, tips tricks

Abstract:

In this session we will see what bring us some newly introduced MS SQL functions and syntax's like COMPRESS, STRING_SPLIT, STRING_AGG, DROP IF EXISTS (a.k.a. DIE), UTF8 Support and many more. How are they performing compared to some old solutions?

Accompanied with multiple examples, this session will show you many interesting topics.

SessionID: 108235

SQL Server Intelligent Query Processing

Back to calendar

Event Date: 12-12-2020 - Session time: 11:20:00 - Track: Application Database Development

Speaker: Dean Savović

Title: SQL Server Intelligent Query Processing

Abstract:

I will talk about new intelligent query processing features in SQL Server 2019. The features that will be described are adaptive joins, interleaved execution, memory grant feedback, table variable deferred execution, batch mode on rowstore, T-SQL scalar UDF inlining and approximate count distinct. The presentation will end with extensive demo.

SessionID: 109301

External Tools for Power BI

Back to calendar

Event Date: 12-12-2020 - Session time: 11:20:00 - Track: BI Platform Architecture, Development Administration

Speaker: Georgi Petkov

Title: External Tools for Power BI

Abstract:

Sometimes the work process in Power BI Desktop might get slow and cumbersome, especially when our model gets large and complicated. If you want to learn more about:

• how you can optimize your work process
• see where the bottlenecks of your model are
• measure performance
• compare two models ... then this is the perfect place to do that.

SessionID: 109315

Azure Logic Apps – how to integrate different systems with zero coding?

Back to calendar

Event Date: 12-12-2020 - Session time: 11:20:00 - Track: Cloud Application Development Deployment

Speaker: Anton Boyko

Title: Azure Logic Apps – how to integrate different systems with zero coding?

Abstract:

We would love to have "one ring to rule them all", but, unfortunately, life is a very cruel place and I am yet to find a company that is able to use only one system to manage all their business flows. To manage a dozen of different systems it will be just reasonable to have a single point of integration, an integration bus if you prefer. And that's the point where Azure Logic Apps comes very handy. With hundreds, if not thousands, of different connectors to different systems I can easily receive a new order from Sales Force, check that I have required items in stock against my SQL database, post the data to SAP ERP and send an email to a client that his order is on the way. Making those things happen will require no coding whatsoever. I will not be forced to go deep diving into different system APIs and become an expert in everything. Minimum efforts and maximum value.

SessionID: 102516

Self-Service ETL: The PowerBI Data Flows

Back to calendar

Event Date: 12-12-2020 - Session time: 13:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Dennes Torres

Title: Self-Service ETL: The PowerBI Data Flows

Abstract:

What was already good has became even better. We were already able to make ETL in PowerBI using M, now, using the PoweBI Data Flows we are able to store the ETL on the PowerBI Portal, control the ETL execution, the data among many ETL steps and share the result with many Power BI files, instead of having to duplicate M scripts accross different .PBIX files

In this session you will understand better what Data Flows can bring to our already powerful self-service BI tools

SessionID: 103908

Azure SQL Database EDGE, put your SQL wherever you want!

Back to calendar

Event Date: 12-12-2020 - Session time: 13:00:00 - Track: Cloud Application Development Deployment

Speaker: Marco Dal Pino

Title: Azure SQL Database EDGE, put your SQL wherever you want!

Abstract:

Developing application for Smart city, Sensors, Industrial IoT increasingly need more affordable and powerful way to store data and manage it.

Now we can also use the same approach we have in our client server distributed application even in remote deployed devices frquently not connected to internet. Expand device architecture coverage to include ARM-based devices on top of x64-based architecture. Use Kubernetes to orchestrate your device infrastructure for better efficiency and automation. Run SQL Database Edge connected or offline to support various edge environments.

SessionID: 107749

Row Level Security Deep Dive

Back to calendar

Event Date: 12-12-2020 - Session time: 13:00:00 - Track: Application Database Development

Speaker: André Melancia

Title: Row Level Security Deep Dive

Abstract:

You've heard of Row Level Security. You know it can be used in SQL Server, SQL Database, SQL Server Analysis Services, Azure Analysis Services, Power BI and many more technologies.

This deep dive session will show you everything you need to do to use Row Level Security, how to deliver business level rules, typical use cases, how to optimise performance and how to guarantee security. Disclaimer: No rowing or swimming will take place. You can leave your live vest at home.

SessionID: 109357

Why my query is slow and how to make it fast

Back to calendar

Event Date: 12-12-2020 - Session time: 13:00:00 - Track: Application Database Development

Speaker: Denis Reznik

Title: Why my query is slow and how to make it fast

Abstract:

Generally, there are only two options for query slowness: either the query itself is slow (high CPU time), or the query is waiting for some resource (high Wait time) - all other reasons for query slowness derive from these two options. Well, I have to admit it is not that easy, there are a lot of things which can slow down the query, and the slowness root cause is among them. In this session, I will show you the approach which I use for query performance tuning. We will look through the bunch of queries, their query plans, execution statistics, DMV's and extended events to identify the slowness root cause and optimize the queries.

SessionID: 102961

Known T-SQL but not to everybody (especially beginners) Insights and samples for T-SQL

Back to calendar

Event Date: 12-12-2020 - Session time: 14:10:00 - Track: Application Database Development

Speaker: Reinhard Flügel

Title: Known T-SQL but not to everybody (especially beginners) Insights and samples for T-SQL

Abstract:

This session is not intended as a deep dive. It gives a short overview on topics like logical query processing, SARGability, data type precedence, and gives some samples on different ways to write a cursor, how to access data inside a stored procedure constructed by an other procedure and how to create a listing of numbers or dates.

SessionID: 107807

Azure Sql DB Managed instance, a different sql server?

Back to calendar

Event Date: 12-12-2020 - Session time: 14:10:00 - Track: Enterprise Database Administration Deployment

Speaker: Gonzalo Bissio

Title: Azure Sql DB Managed instance, a different sql server?

Abstract:

On this session we are going to cover Azure sql db managed instance service. Introduction, how to Migrate, limitations, best practices among other things :):):):)..

SessionID: 109306

Quantum computing explained with demos!

Back to calendar

Event Date: 12-12-2020 - Session time: 14:10:00 - Track: Information Delivery

Speaker: Damian Widera

Title: Quantum computing explained with demos!

Abstract:

This talk is inspired by the quantum revolution we will see in a moment.

I would like to introduce the topics:

• reminder why basic linear algebra (matrices and vectors) is important
• qbits, superposition, and quantum logic gates
• Show the simplest problem where a quantum computer outperforms classical methods

If time permits - quantum entanglement

I will do demos implemented in Q# with the Microsoft Quantum Development Kit.

I do not assume any special knowledge, but if you know basic linear algebra (matrices, vectors, matrix multiplication) than the topic will be more easily understand!

SessionID: 109332

End-to-End Business Intelligence Architecture in Azure

Back to calendar

Event Date: 12-12-2020 - Session time: 14:10:00 - Track: BI Platform Architecture, Development Administration

Speaker: Aleksandar Vetsev

Title: End-to-End Business Intelligence Architecture in Azure

Abstract:

Presentation and a demo on how to build an end-to-end BI platform for data collection, processing and visualisation, using Azure Data Factory, Azure Databricks, Azure Logic Apps, Azure Data Lake and more.

SessionID: 102412

Working with parameters in Power Query

Back to calendar

Event Date: 12-12-2020 - Session time: 15:20:00 - Track: BI Platform Architecture, Development Administration

Speaker: Boriana Petrova

Title: Working with parameters in Power Query

Abstract:

This session will show how to create and use parameters in Power Query. From basic to advanced techniques - from static to dynamic parameters and functions.

SessionID: 102426

Machine Learning - Best Practices and Vulnerabilities

Back to calendar

Event Date: 12-12-2020 - Session time: 15:20:00 - Track: Application Database Development

Speaker: Sebastiano Galazzo

Title: Machine Learning - Best Practices and Vulnerabilities

Abstract:

It seems like Artificial Intelligence and Machine Learning are a must nowdays.

For projects carrying a simple or well kown problem we can find a lot of ready-made solutions, but this extremne easy to use could be one of our best enemy when facing with specific custom problems. With this session we will cover how to apply best practices in configurin ML but much more, do we reaaly need it always? The second part will cover vulnerabilities of ML discovering how easy could be to fool a neural network by some techinques (Like pixel attack) and their implication in projects that requires no security issues.

SessionID: 104168

Machine Learning is full of stars: An Azure Story

Back to calendar

Event Date: 12-12-2020 - Session time: 15:20:00 - Track: Advanced Analysis Techniques

Speaker: André Melancia

Title: Machine Learning is full of stars: An Azure Story

Abstract:

Want to get started with Machine Learning and have no idea what technologies to use?

Don't hybernate your career. Learn about some of technologies available, focusing on Microsoft's offering, such as Azure Machine Learning (Service) workspace, Spark using Azure Databricks and HDInsight, Azure Synapse Analytics, and many more. Disclaimer: All these worlds are yours except Cognitive Service, that's for a different session.

SessionID: 109356

Big Brother your Power BI deployment

Back to calendar

Event Date: 12-12-2020 - Session time: 15:20:00 - Track: BI Platform Architecture, Development Administration

Speaker: Rui Romano

Title: Big Brother your Power BI deployment

Abstract:

In this session you will learn how to efectively monitor your entire Power BI tenant

Be ready for some powershell scripting…

This site is open source. Improve this page.