Build Schedule

Advanced Filters:
  • Track

    clear all









  • Speaker


  • Level


  • Session Type


Sessions Found: 19
? ???? ????????????? ?????? ????? ?? ?????????? ?????????????? ???????? ??????? ???? ????? ?????????? ? ???. ??????? ?????????? ???????? ???? ?? ????? ???????? MS SQL Server. ???? ?? ??? ???????? ?? ???????????? ? ????????????????? ????? ?????????; ?????? ??, ???, ????????? ???????????? ????????????? ???????? ??????, ?????????? ??????? ?/??? ??????? ?? ?????? ??????????? ??????? ???????????? ? ???????? ?????. ???? ??, ?????? ?? ????, ????????? ? ?????????? ????? ??????????.

? ?????? ?? ???? ???? ? ???????? ???????, ?? ???????? ?? ?????????? ??? ?????????? ??????? ?????????, ? ????? ? ???? ????? ???? ?? ?? ??????? ???????? ????? ???? ????? ?????????????? ????? ?????????
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: November 03

Time: 9:45 AM - 10:45 AM

Room: Room 1

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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: November 03

Time: 1:00 PM - 2:00 PM

Room: Room 1

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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: November 03

Time: 3:30 PM - 4:30 PM

Room: Room 2

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.
Speaker:

Accompanying Materials:

Session Type:
Extended Session (90 minutes)

Track:
Advanced Analysis Techniques

Level: Advanced

Session Code:

Date: November 03

Time: 8:30 AM - 10:00 AM

Room: Room 3

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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: November 03

Time: 3:30 PM - 4:30 PM

Room: Room 3

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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: November 03

Time: 2:15 PM - 3:15 PM

Room: Room 2

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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: November 03

Time: 2:15 PM - 3:15 PM

Room: Room 3

Docker has taken the world of IT by storm and looks to be ushering in the greatest platform paradigm shift since virtualisation and the public cloud. The transient nature of Docker containers makes them the perfect fit for spinning up and then tearing down SQL Server instances as part of continuous integration pipelines. Jenkins is the most popular build automation engine in the open source community, it has phenomenal plugin support, it is used by the likes of Netflix and eBay and excels in its ability to handle build pipelines as code. In this session you will learn how a simple build pipeline that takes a SQL Server data tools project checked out from source code control, built into a DACPAC which is then deployed to a SQL Server instance can be extended to use containers, multi-branch build pipelines, tSQt testing and much much more.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: November 03

Time: 8:30 AM - 9:30 AM

Room: Room 1

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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: November 03

Time: 8:30 AM - 9:30 AM

Room: Room 2

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: November 03

Time: 11:00 AM - 12:00 PM

Room: Room 2

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
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: November 03

Time: 1:00 PM - 2:00 PM

Room: Room 2

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: November 03

Time: 11:00 AM - 12:00 PM

Room: Room 1

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: November 03

Time: 8:30 AM - 9:30 AM

Room: Room 1

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: November 03

Time: 9:45 AM - 10:45 AM

Room: Room 2

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!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Advanced

Session Code:

Date: November 03

Time: 1:00 PM - 2:00 PM

Room: Room 3

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: November 03

Time: 2:15 PM - 3:15 PM

Room: Room 1

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Extended Session (90 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: November 03

Time: 11:00 AM - 12:30 PM

Room: Room 3

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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Advanced

Session Code:

Date: November 03

Time: 9:45 AM - 10:45 AM

Room: Room 3

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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: November 03

Time: 3:30 PM - 4:30 PM

Room: Room 1

Sessions Found: 19
Back to Top cage-aids
cage-aids
cage-aids
cage-aids