Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type

Sessions Found: 25
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: February 09

Time: 10:30 AM - 11:30 AM

Room: E

Power BI from month to month is better tool. Some of the tasks are very simple but sometimes to achive their goals developers have to implement a lot of workarounds and prepare very... creative code. During this presentation I will show you 30 tips that will help you with your daily work in Power BI. From very simple one to much more complicated using M, DAX and built-in Power BI functionalities. From the beginning to the end demo-only session without uneeded Power Point!  Why? Because nothing is impossible in Power BI.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: February 09

Time: 10:30 AM - 11:30 AM

Room: D

In the perfect world, only Database Administrators have access to SQL Server databases. All database schema changes go through strict Change Management Process where they need to be well described and approved by Change Advisory Board. The database schema is stored in a source code repository and deployed version doesn't drift unexpectedly from its original model.

Unfortunately, we don't live in the perfect world.

Sometimes database schema is changed without our knowledge and supervision. Sooner or later such unexpected schema changes start to be very problematic. They may break some functionality or create some performance issues.

In such a case, various questions arise and you as a DBA will have to answer them.
•	What has been changed?
•	When it has been changed?
•	By who it has been changed?

In this session, I will demonstrate you 5 different ways to track database schema changes. Thanks to this, you always will be able to easily answer such questions.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: February 09

Time: 11:45 AM - 12:45 PM

Room: C

SQL Server is a high frequently used piece of software which need to serve single requests and/or hundreds of thousands of requests in a minute. Within these different kinds of workloads Microsoft SQL Server has to handle the concurrency of tasks in a fashion manner. This demo driven session shows different scenarios where Microsoft SQL Server has to wait and manage hundreds of tasks. See, analyze and solve different wait stats due to their performance impact:
- CXPACKET: when a query goes parallel
- ASYNC_IO_COMPLETION: speed up IO operations (Growth / Backup / Restore)
- ASYNC_NETWORK_IO: What happens if your application refuses data?
- THREADPOOL starvation: crush of requests for Microsoft SQL Server
- PAGELATCH_xx: How does Microsoft SQL Server protects data?
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: February 09

Time: 1:45 AM - 2:45 AM

Room: C

Azure Cognitive Services allow developers to build powerful AI-based solutions, enabling different capabilities in our software: vision. speech, search, text analytics, language understanding, and much more. Basically, the model is already built by Microsoft, you just need to do an API call to the Azure cloud and the service retrieves a result. For instance, you send a message and the Text Analytics API returns its sentiment score.

However, there might be cases in which our customers need a local, non-cloud AI solution (either because of limited Internet access or data compliance). This is now possible thanks to the latest update of Azure Cognitive Services, which offers containerization support. Using containers, we can still deliver ML-driven solutions while keeping the data in-house.

In this talk, we'll explore what it takes to configure and use containers in Azure Cognitive Services. Demos will be showcased as well for local Face and Text Cognitive Services.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Beginner

Session Code:

Date: February 09

Time: 4:15 PM - 5:15 PM

Room: E

One of the problems of the current world is how to deal with the data that are generated. Business, healthcare, governing, education and media are some of the significant areas where data are of extreme importance. However, analysis of these data and drawing insightful conclusions is not always straightforward. Volume, variety, velocity and veracity are the problems that are related to Big Data analysis.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: February 09

Time: 1:45 AM - 2:45 AM

Room: E

We are going to examine a variety of oopsies MANY developers fall prey too - some obvious, some pretty subtle and some down right sneaky! Lots of code examples with the bad AND good code presented. I GUARANTEE that you will find things here that will either prevent you from getting bad data, throwing unwanted errors or vastly improving your database application's performance.  I have given this talk over 100 times now and it is always very highly rated!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Intermedia

Session Code:

Date: February 09

Time: 8:30 AM - 9:30 AM

Room: B

If you are releasing new reports, SSAS cubes or SSIS packages on a regular basis, you've probably offered up your share of blood, toil, tears and sweat on getting them delivered into production in working condition.
Continuous Delivery is a way to bridge the gap between developers and IT professionals and for that we need to address the both the toolchain to support the practices as well as the mindset on the team. Microsoft offers a set of tools that'll help you on your journey towards the end goal: Maximize predictability, efficiency, security and maintainability of operational processes.

We will in detail be looking at:

Agile Development Frame of Mind
        The Path Ahead (direction)
	Visual Studio Online (tool)
	Feature/User Story/Work Item (concept)
Team Services
	Code Branching (concept)
	Build Agents (tool)
        Releases (tool)
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: February 09

Time: 5:30 PM - 6:30 PM

Room: D

In February 2018. at the meeting of the Warsaw Data Comunnity group, I was talking about partitioning. Due to the great interest, I decided to repeat this session but in a slightly changed form. During this session, one of the techniques of database optimization will be presented which is the partitioning of tables and indexes of the SQL Server database. This allows you to improve performance, understood as the speed of access to data and facilitates management. Partitioning is related to various mechanisms such as partition switching, partition sliding window or partition elimination, which can be helpful in everyday work. Basic terms, methods of partitioning, advantages and disadvantages of good practices will be discussed. I will mention the myths of partitioning. Everything will be supported by examples.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: February 09

Time: 10:30 AM - 11:30 AM

Room: C

DBA is key when a database platform change occurs and necessary to support the application, release processes and there is a miracle waiting to happen!

Based on my experience DBA is left out in the key element of DEVOPS, this is unfortunate. DBAs have a lot to offer . 
In this session let us overview where exactly DBAs can make miracles with their magic wand, let's talk about process and procedures. To evaluate each change request to ensure that it is well thought out, is compliant with organizational best practices.

Take away best practices associated in DEVOPS and DBA world.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: February 09

Time: 3:00 PM - 4:00 PM

Room: C

Taras talks about the experience moving from batch-oriented ETL to real-time streams using Apache Kafka and how the design and implementation of Kafka was driven by this goal of acting as a real-time platform for event data. He covers some of the challenges of scaling Kafka to hundreds of millions of events per day.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: February 09

Time: 11:45 AM - 12:45 PM

Room: E

In this session (level 300-400) you will learn how SQL Server physically stores data in pages and how they are grouped together based on IAM -, PFS, GAM, SGAM pages and extents.
Additionally, we will have a look into partitions and allocation units and the different types of pages like in-row, row-overflow (row overflow pointer) and LOB. 
Also, we will dump a data page to analyze the page header and translate the payload with the FixedVarFormat.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: February 09

Time: 3:00 PM - 4:00 PM

Room: B

There are situations in an analyst's life when you have to repeat same list of actions on a little bit different dataset. On the other hand, software development experience tells us to avoid repeating code which was already written and to convert it into procedure or function. On the example of public data and Google Analytics I'll show you how to group your actions in order to simplify data preparing processes.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: February 09

Time: 1:45 AM - 2:45 AM

Room: D

At last... Now the famous analytical swiss-knife Power BI has a brand new tool for use - Python. As its R companion it can be use as a data source, Power Query transformation or visual in the report. Especially the last one is very attractive, because Python charting libraries have a lot, really a lot possibilities.
During my heavy demo loaded session you will see how to use Python to generate data, transform it, predict something interesting and make a stunning visuals with pandas, scikit-learn, seaborn and other libraries. There also will be a place for web scraping and some other suprises Power BI now can done. With Python of course.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: February 09

Time: 11:45 AM - 12:45 PM

Room: D

SQL Server 2017 is full of new features and improvements. The main "Killer" feature of SQL Server 2017 is SQL Server on Linux, but there are some more big and interesting features: Adaptive Query Processing, Graph Processing, Automatic Tuning and many others which you are aware of. And in this session we will not talk  about them. We will not do that just because there are a lot of cool features in SQL Server 2017, which are more hidden from our sight and have not get enough attention. 

In this session, we will learn a lot about these features and improvements. Which features? This is a secret :) Come to the session and discover them with me!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: February 09

Time: 5:30 PM - 6:30 PM

Room: E

Batch mode was introduced as a way to help SQL Server process data from columnstore indexes faster. During this session I'll show you the new feature of SQL Server’s 2019 Database Engine – Batch Mode on Row Store. I'll start with a quick introduction and then we will look at some curious details. I'll show you how to hack previus SQL Server's versions to induce Batch Mode on rowstore.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: February 09

Time: 11:45 AM - 12:45 PM

Room: B

SQL Server 2019 allows you to deploy a scalable cluster of SQL Server, HDFS and Spark in Kubernetes. It brings you new capabilities to integrate structured and non-structured data, create data virtualization on top of it and integrate AI with it. Sounds amazing, right?
Join me in this session and I show you how it is easy to deploy this cluster and start using it, capabilities it provides and how to manage it. We also review some use cases that are relevant to this solution.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: February 09

Time: 4:15 PM - 5:15 PM

Room: C

Everything in life can be hacked… Even SQL Server… Don't believe me? See for yourself…
This is a demo-driven session, suited for DBAs, developers and security consultants. Both exploits and security recommendations to avoid them will be covered.
Disclaimer: No actual crimes will be committed. Please do not send agents to my house again.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: February 09

Time: 5:30 PM - 6:30 PM

Room: C

Power BI Premium introduces a new developer layer for embedding Power BI in custom applications, and a new on-premises deployment option as well. Microsoft Power BI Embedded applications enables developers to integrate Power BI reports into their web or mobile applications so they don’t need to build custom solutions to visualize data for the users. It helps Independent Software Vendors to use Power BI data experiences within their applications.
This talk is abou the best practices designing and implementing in business solutions Power BI Embeded and Power Bi Premium: which version to use and how to take the best advantage from different version and tier of Power BI, offered from Microsoft.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: February 09

Time: 3:00 PM - 4:00 PM

Room: D

The world is not perfect as well as any IT project is. In Business Intelligence, as an example, it's almost impossible to avoid some flat files and/or user input. Usually you will repeat and do some stuff manually on your own or you will create an Excel or flat file upload interface. But maybe there is a better way... What do you say about giving to the users the web application that looks nice, automate the boring stuff for you and send the data to your data warehouse and also doesn't require a lot of development? This can be done with PowerApps and maybe Microsoft Flow. During the session I will first of all introduce PowerApps and Microsoft Flow, and also will share with some experience from previous usage. I will show you how easy it is to create the application, but also I will tell you what sucks and what do you need to keep in mind if you really want to use these two technologies in real world.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: February 09

Time: 4:15 PM - 5:15 PM

Room: D

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