sqlsathistory

Nr: 791

Back to Main list

SQLSaturday #791 - Banja Luka 2018

Start Time (24h) Speaker Track Title
08:30:00 Dejan Sarka Analytics and Visualization Data Overview and Manipulation – T-SQL, R, Python
08:30:00 Tobias Koprowski Enterprise Database Administration Deployment Maintenance Plans: A Daily Task
08:30:00 Marcin Szeliga Advanced Analysis Techniques Beyond image classification - object detection with multi-task deep models
08:30:00 Christopher Adkin Application Database Development Continuous Integration Pipelines With Jenkins, Docker and SQL Server
09:45:00 Dejan Sarka BI Platform Architecture, Development Administration Staatistical Analysis with T-SQL
09:45:00 Miloš Radivojević Application Database Development Најчешће грешке и заблуде на релацији програмер – SQL Server
09:45:00 Jasmin Azemović Enterprise Database Administration Deployment Minimizing consequences of data breach using SQL Server
11:00:00 Dejan Dular Application Database Development How to downgrade a database
11:00:00 Tobias Koprowski Enterprise Database Administration Deployment SQL Security in the Cloud
11:00:00 Tomaž Kaštrun BI Information Delivery Data Science for beginners
13:00:00 Mladen Prajdić Enterprise Database Administration Deployment Getting To Know SQL Server Encryption Capabilities
13:00:00 Tomaž Kaštrun Advanced Analysis Techniques Most common mistakes data scientists make
13:00:00 Catalin Gheorghiu Application Database Development “SQL-like” or query languages in Azure IoT
14:15:00 Mladen Prajdić Application Database Development Optimizing Database Access And Diving Into .Net SqlClient
14:15:00 Dean Savović Enterprise Database Administration Deployment Bulk Load and Minimal Logging
14:15:00 Ratomir Vukadin Application Database Development CI/CD Database deployment
15:30:00 Miloš Radivojević Application Database Development Transact SQL Performance Tips
15:30:00 Tomasz Libera Cloud Application Development Deployment Azure SQL Data Warehouse
15:30:00 Miroslav Popovic Application Database Development Building production-ready APIs with ASP.NET Core 2.x

SessionID: 82620

Data Overview and Manipulation – T-SQL, R, Python

Back to calendar

Event Date: 03-11-2018 - Session time: 08:30:00 - Track: Analytics and Visualization

Speaker: Dejan Sarka

Title: Data Overview and Manipulation – T-SQL, R, Python

Abstract:

In a real data mining or machine learning project, you spend more than half of the time on data preparation and data understanding. The R language is extremely powerful in this area. The Python language is a match. Of course, you do work with data by using T-SQL. You will learn in this session how to get data understanding with really quickly prepared basic graphs and descriptive statistics analysis. You can do advanced data preparation with many data manipulation methods available out of the box and in additional packages from R and Python. After this session, you will understand what tasks data preparation involves, and what tools you have in SQL Server suite for these tasks.

SessionID: 83137

Maintenance Plans: A Daily Task

Back to calendar

Event Date: 03-11-2018 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Tobias Koprowski

Title: Maintenance Plans: A Daily Task

Abstract:

Maintenance Plans is one of the best helpers for daily DBA work. Some novice DBA never touches this feature, some accidental DBA never touch this feature. Sometimes even senior DBA did not know too much how it works and how powerful tool it could be. Powerful and dangerous. In my session I would to show how Maintenance Plans can help us, how strong and in the same way dangerous could be. few slides, few demos, few topics for discussion in fifty-five minutes.

SessionID: 83778

Beyond image classification - object detection with multi-task deep models

Back to calendar

Event Date: 03-11-2018 - Session time: 08:30:00 - Track: Advanced Analysis Techniques

Speaker: Marcin Szeliga

Title: Beyond image classification - object detection with multi-task deep models

Abstract:

Object detection can be challenging to understand, mostly because there is a gap in the literature between image classification and object detection — the former is explained in deluge of easy to understand blog posts and articles, the latter is the subject of research papers, full of scary looking math.

In this session we will take different approach and built state of the art object detection model in easy to understand steps. First, we are going to make sure that everybody understand concepts of convolution networks, the importance of model architecture and loss function. Then we are going to build a model that will classify single object, a model that finds this object on a picture, and a model that combine both and is able to classify and localize the largest object in each image. Finally, we will move to multiple objects detection, discus latest architectures and design appropriate loss function for this task. All this illustrated with examples built using fastai library.

SessionID: 83780

Continuous Integration Pipelines With Jenkins, Docker and SQL Server

Back to calendar

Event Date: 03-11-2018 - Session time: 08:30:00 - Track: Application Database Development

Speaker: Christopher Adkin

Title: Continuous Integration Pipelines With Jenkins, Docker and SQL Server

Abstract:

SessionID: 82622

Staatistical Analysis with T-SQL

Back to calendar

Event Date: 03-11-2018 - Session time: 09:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Dejan Sarka

Title: Staatistical Analysis with T-SQL

Abstract:

Transact-SQL language in latest editions of SQL Server has so many business intelligence (BI) improvements that it might become your primary analytic database system. You might even decide to use T-SQL for advanced analyses directly, without including R, Python, SSAS or Azure ML. However, to get the maximum out of these language constructs, you need to learn how to properly use them. This in-depth session shows extremely efficient statistical queries that use the window functions and are optimized through algorithms that use mathematical knowledge and creativity. During the session, the formulas and usage of those statistical procedures are explained as well. This session is useful not only for BI developers; database and other developers can successfully learn how to write efficient queries. Or maybe you want to become a data scientist? Then you need to know statistics and programming. You get the best of both in this session.

SessionID: 82989

Најчешће грешке и заблуде на релацији програмер – SQL Server

Back to calendar

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

Speaker: Miloš Radivojević

Title: Најчешће грешке и заблуде на релацији програмер – SQL Server

Abstract:

У овој популистичкој сесији аутор ће уприличити рестроспективу типичних грешака које праве програмери и тзв. софтвер девелопери приликом рада са базом података MS SQL Server. Неке од њих почивају на ограничењима и неконзистентности самог производа; већина је, пак, последица неразумевања функционисања дејтабез енџина, недостатка времена и/или потребе за дубљим разумевањем процеса оптимизације и извршења упита. Неке су, истини за вољу, последице и ограничења самог девелопера.

У сесији ће бити речи о узроцима грешака, те начинима за избегавање или ублажавање њихових последица, а пашће и који савет како да се побољша опхођење према овом веома респектабилном РДБМС производу

SessionID: 85667

Minimizing consequences of data breach using SQL Server

Back to calendar

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

Speaker: Jasmin Azemović

Title: Minimizing consequences of data breach using SQL Server

Abstract:

Intrusions into the systems have become so common, that there is no single day without news headline. User’s data, trade secrets, private habits of users are becoming the subject of "public" unauthorized access. Outcomes are blackmailing, loss of reputation and credibility. Database is a service that represents the last line of defense and as such deserves special your attention.

This session is about how to implement state of the art cryptographic features that are built in in to SQL Server (current version 2017). Focus is on the inside and outside threats. We will demonstrate the following : transparent database encryption, backup encryption, column level encryption and encryption data in the motion.

SessionID: 82847

How to downgrade a database

Back to calendar

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

Speaker: Dejan Dular

Title: How to downgrade a database

Abstract:

You just can't simply move or restore a database to a SQL server with lower build version. Some would say that this is impossible! Well it's not!

In this session we'll discuss why would you need to downgrade a database and then I will demonstrate a few ways how it can be done for different levels of database complexity.

SessionID: 83136

SQL Security in the Cloud

Back to calendar

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

Speaker: Tobias Koprowski

Title: SQL Security in the Cloud

Abstract:

Our data should be secure. And our environment too. What we can do for maximize security in a hybrid environment, where SQL Server exist in two forms: premise and cloud. How organize our job, how control our data if we use Windows Azure SQL Database - The Cloud Database. Physical security, policy based management, auditing, encryption, federation, access and authorization. All of those subjects will be covered on my session.

SessionID: 83287

Data Science for beginners

Back to calendar

Event Date: 03-11-2018 - Session time: 11:00:00 - Track: BI Information Delivery

Speaker: Tomaž Kaštrun

Title: Data Science for beginners

Abstract:

Data science can be hard to grasp, complex and big, but making data science easy to understand and bringing it closer to all who want to tackle this new emerging field is an important task in world of data. Exploring, extracting and finding hidden gems from data using statistical and mathematical methods, computer science and several different technologies is essentially what data science is doing. In practice this means, data science is an iterative process of harvesting data, managing and cleaning the data, performing analysis and and at the end interpreting, visualizing and using information that will bring insights to end-user, business people and making decisions much easier.

We will focus on answering 5 simple questions.

  1. is this weird?
  2. is A better than B, respectively?
  3. how much / many of this is needed?
  4. this belong to group A?
  5. what is next?

Session we will look into technologies that can be tackled using SQL Server 2016 and ML Azure.

SessionID: 83180

Getting To Know SQL Server Encryption Capabilities

Back to calendar

Event Date: 03-11-2018 - Session time: 13:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Mladen Prajdić

Title: Getting To Know SQL Server Encryption Capabilities

Abstract:

With stricter EU privacy laws like GDPR, the need to encrypt data is greater than ever.

In this session we'll look at what SQL Server offers in this area:

  1. symmetric and asymmetric server encryption which lets the server encrypt table data and control the keys,
  2. Always Encrypted (AE) which works similarly to server encryption but the client control the keys meaning server can't decrypt the data
  3. Transparent Data Encryption (TDE) which encrypts your data at rest making getting data from stolen drives useless
  4. creating secure SSL/TLS communication channels between your apps and the server to prevent clear text network traffic which can be observed

SessionID: 83288

Most common mistakes data scientists make

Back to calendar

Event Date: 03-11-2018 - Session time: 13:00:00 - Track: Advanced Analysis Techniques

Speaker: Tomaž Kaštrun

Title: Most common mistakes data scientists make

Abstract:

In the middle of deploying the model, team of data scientists realize that the predictions are "somewhat-off". Troubleshooting on the horizon and what to do.

Session will guide you through most common mistakes data scientists and statisticians are making when preparing and engineering the data using T-SQL or any other database system. Further more, we will explore common statistical and data science mistakes when modeling data, extracting know-how from the data, finding the hidden patterns and running different test against the structural models using mainly R, Python, or Spark.

What not-to-do will be replaced with what to-do explanations using sample datasets and sample codes.

Some statistical knowledge or background is a plus!

SessionID: 85662

“SQL-like” or query languages in Azure IoT

Back to calendar

Event Date: 03-11-2018 - Session time: 13: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: 83181

Optimizing Database Access And Diving Into .Net SqlClient

Back to calendar

Event Date: 03-11-2018 - Session time: 14:15:00 - Track: Application Database Development

Speaker: Mladen Prajdić

Title: Optimizing Database Access And Diving Into .Net SqlClient

Abstract:

The prevailing opinion is that the optimizations for SQL Server are usually only done on the server itself. But is there anything we can do on the client to gain more speed? Because there are always at least two sides of the performance coin, in this session aimed at .Net and SQL developers, we'll dive into the workings of the .Net SqlClient and give you insight into things like connection pools, transaction scopes, batch inserting, async data access and more.

SessionID: 84137

Bulk Load and Minimal Logging

Back to calendar

Event Date: 03-11-2018 - Session time: 14:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Dean Savović

Title: Bulk Load and Minimal Logging

Abstract:

Session subject is bulk load and minimal logging. I will show you on various demos how bulk load and minimal logging behieves on heap and cluster tables, in-memory tables, clustered and non-clustered columnstore tables and on all combinations as well.

SessionID: 85243

CI/CD Database deployment

Back to calendar

Event Date: 03-11-2018 - Session time: 14:15:00 - Track: Application Database Development

Speaker: Ratomir Vukadin

Title: CI/CD Database deployment

Abstract:

Almost an every enterprise system needs a some kind of database in the background. In the process of development, architects, developers, they need to prepare and build a database. When the application comes into the production, can be a very difficult to move new changes and that slow down our process of release. Also, here can happen a problem with a bad script, a poor thing can gone happened and all goes into a bad situation. This is the right place for CI/CD process, helping to teams how to manage new database changes in a different environment.

In this lecture we'll see how to set up CI/CD process for database pipeline, deploy database changes into the Azure SQL Database and move that change into the production. It will be demonstrated how to include RedGate tools in the process. Also, there will be a best practices notes how to deploy a very large database.

SessionID: 82993

Transact SQL Performance Tips

Back to calendar

Event Date: 03-11-2018 - Session time: 15:30:00 - Track: Application Database Development

Speaker: Miloš Radivojević

Title: Transact SQL Performance Tips

Abstract:

In this session we will advice how to avoid common developer mistakes and show how bad designed queries reduce the SQL Server optimizer's capabilities for choosing an optimal execution plan.

SessionID: 84553

Azure SQL Data Warehouse

Back to calendar

Event Date: 03-11-2018 - Session time: 15:30:00 - Track: Cloud Application Development Deployment

Speaker: Tomasz Libera

Title: Azure SQL Data Warehouse

Abstract:

Azure SQL Data Warehouse - what is it and how it is different from SQL Database. During the session I’ll demonstrate how to create SQL DWH databases and different methods of importing data from on-premise database and files.

SessionID: 85566

Building production-ready APIs with ASP.NET Core 2.x

Back to calendar

Event Date: 03-11-2018 - Session time: 15:30:00 - Track: Application Database Development

Speaker: Miroslav Popovic

Title: Building production-ready APIs with ASP.NET Core 2.x

Abstract:

Creating REST APIs with ASP.NET Core is simple and comes down to defining controllers and routes. But, there are a lot of things to take care of before the API becomes ready for production. This talk is about best practices, authorization, routing, logging, data formatting, testing, documentation, versioning and monitoring REST APIs built with ASP.NET Core 2.x.