Build Schedule

Advanced Filters:
  • Track

    clear all





  • Speaker


  • Level


  • Session Type

Sessions Found: 30
We have all now had a play around with Docker and Containers or at least heard about them.

This demo heavy session will walk through some of the challenges around managing container environments and how Kubernetes orchestration can help alleviate some of the pain points. 

We will be talking about what Kubernetes is and how it works and through the use of demos we will:

- Highlight some of the issues with getting setup, 
- Deploying/Updating containers in Kubernetes 
- Persisting data
- How to avoid making the same mistakes as I have
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
DBA

Level: Intermedia

Session Code:

Date: December 14

Time: 1:30 PM - 2:30 PM

Room: P21: DBA

Presented by Redgate 

DevOps is transforming software development, with many organizations and individuals adopting lean development practices, implementing Continuous Integration (CI), Continuous Deployment (CD), and performing on-demand deployments to their production environments. However, the database is largely ignored and seen as a bottleneck for a DevOps software development process. We will discuss the challenges of database development and deployment and examine why many developers find the database to be an impediment. We examine the risks of sensitive data in the development process and how you can ensure that data security concerns do not get in the way of the need for speed and agility. We’ll look at how you can adopt a Compliant Database DevOps approach that removes the database bottleneck while ensuring compliance with regulations governing the use of data within your organization such as GDPR, HIPPA or SOX.  We’ll discuss the techniques used to include the data
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
DEV/DBA

Level: Beginner

Session Code:

Date: December 14

Time: 4:00 PM - 5:00 PM

Room: P20: DEV/DBA

Everyone is talking about advanced analytics or data science these days and many companies are interested in taking their first steps in these new fields of data analytics. But how do you get started with new techniques like machine learning? What kind of new hardware or software do you need to buy to get started and how do you get your IT department to implement and support those choices?
Before you decide on designing an advanced analytics solution on-premises, why not give it a go on a platform that only charges money for the time you are actually using it? Azure Machine learning is a cloud service that enables you to easily build, deploy and share analytics solutions with all the flexibility of the cloud. The perfect platform to start with advanced analytics without having to invest a lot of money!
In this session we are going to take a close look at AzureML, from how you can build your first machine learning model, to connecting AzureML to your on-premises SQL Server database!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI/DEV

Level: Intermedia

Session Code:

Date: December 14

Time: 11:30 AM - 12:30 PM

Room: P19: BI/DEV

As the value of data is being recognized across the world, the ability to communicate data to your audience effectively is becoming a sought after skill for professionals. Thankfully, effective data visualization is not only a skill for artists and designers, anyone can improve their data presentation by choosing the right visuals and following best practices.
 
In this session, we will discuss how different types of visuals are perceived and which charts are best suited to each category. We’ll cover a basic introduction into colour theory, how to use colour effectively in reports, and how to create Power BI themes for your enterprise. Finally, you will learn an introduction to the design approach and how it helps us to tell a good data story.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Beginner

Session Code:

Date: December 14

Time: 9:00 AM - 10:00 AM

Room: P22: BI

With ever increasing complexity in data platform and application solutions, it is becoming ever more important to take people out of the loop when it comes to system provisioning. Infrastructure as code is the way forward with Azure Resource Manager Templares, Google Deployment Manager, or AWS Cloud Formation.

This is where Terraform from Hashicorp can step in, one solution that has a provider model that will interact with Azure, AWS, Google, and others. Meaning that you only need to learn one syntax. Add that to the automation potential and now we have something that can really help get us down the road to infratructure as code.

This session will take an introductory look at how infrastructure can be defined as code and be shipped to standardise the deployment process and minimise the chance of mistakes creeping in when deployed by different memebers of Development or Operations.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
DEV/DBA

Level: Beginner

Session Code:

Date: December 14

Time: 9:00 AM - 10:00 AM

Room: P20: DEV/DBA

Microsoft Cognitive Services (formerly Project Oxford) are a set of APIs, SDKs and services. They are available to developers to make their applications smarter, more engaging and easier to find. Cognitive services extend Microsoft's AI platform.

How can you use these API's if you don't want to send your data to an Azure Data Center? Not every data set should leave your company. That's why Microsoft now offers the whole thing as a docker image, which you can run on your own hardware. As a company, you regain control over your data.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI/DEV

Level: Beginner

Session Code:

Date: December 14

Time: 10:15 AM - 11:15 AM

Room: P19: BI/DEV

Containers have quietly been taking over the world of infrastructure, especially amongst developers and CI/CD practitioners. However, in the database space, container adoption has been lower. SQL Server 2017 introduced the concept of deploying databases into Docker containers. In this session, you will learn the fundamentals of creating containers, learning about Kubernetes for management, and how to further your learning in this new and emerging space.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DBA

Level: Beginner

Session Code:

Date: December 14

Time: 11:30 AM - 12:30 PM

Room: P21: DBA

In this session we will look at a couple of approaches to create a datalake on a budget. The samples will use Python, Spark and some Databricks. It will all be done in Azure, but we will discuss how you could set this up on-prem as well.

You get to decide how far you want to go, from cost-effective to penny pinching. Don't worry if you've never used any of these technologies, I will start at the beginning.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI/DEV

Level: Intermedia

Session Code:

Date: December 14

Time: 2:45 PM - 3:45 PM

Room: P19: BI/DEV

In this session, we will follow a Premium capacity admin on his day to day activities on managing his capacities, from refreshes, slow queries and a busy capacity. Furthermore we will look at some common DAX and Model performance scenario's. we will use the profiling tools and improve performance by going through concrete examples.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
BI/DEV

Level: Intermedia

Session Code:

Date: December 14

Time: 1:30 PM - 2:30 PM

Room: P19: BI/DEV

In this session, you will see Query Store in action and learn from many real-world examples, the author experienced in the last three years in the complex SQL Server production environment with heavy workloads. 
Plan forcing is a very powerful feature, but a bit controversial. This session will demystify it; you’ll see what Query Store exactly does when an execution plan is forced when it is respected, when and why isn’t, and the most important – when you have to force a plan in the production system, and when forcing can bring additional troubles. 
We’ll also cover in detail the automatic tuning. You will understand benefits and potential issues you can have with this feature and how to leverage it with no or minimal risk.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
DBA

Level: Intermedia

Session Code:

Date: December 14

Time: 9:00 AM - 10:00 AM

Room: P21: DBA

Containers are an increasingly popular way for deployment and application management. Regardless whether we have monolith applications or we make applications as a collection of micro-services, containers provide extreme portability and the possibility of running the same applications in different environments (on local machines, servers, cloud...) without any code or configuration changes. Docker is the leading container technology and Microsoft did a lot to enable it to run on Windows and Azure. Where do the ASP.NET Core applications fit into that picture? After the introduction to containers and Docker, we'll go through the basics of working with Docker from ASP.NET Core developer perspective.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
DEV

Level: Intermedia

Session Code:

Date: December 14

Time: 4:00 PM - 5:00 PM

Room: P01: DEV

Any SQL programmer with some experience knows that loops are bad and that you should work with all data at once in set-based statements. However, you may have experienced situations where this strategy did not work out well and you ran into problems like out-growing the transaction log or blocking other users.

You can solve this by operating on the data in chunks. Implementing chunking is not that difficult, but there are still pitfalls you can run into. In this session, I will discuss in what situations you may want to use chunking. I will give some best practices for how to implement chunking for good performance and I will highlight some things you need keep in mind, for instance, recovering from interruptions. 

I will also look at how you can use chunking for error handling: You want process many rows and you want the good rows to succeed even if some rows yield errors – something you cannot do in a single set-based statement.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
DEV

Level: Advanced

Session Code:

Date: December 14

Time: 2:45 PM - 3:45 PM

Room: P01: DEV

How do you setup and build a complete Microsoft BI solution with only Azure Services? Lessons learned from a project with eleven different source systems in the one end and 12.000 users in seven countries in the other end. 

Extracting, transforming and loading with the help from Functions, Data Factory, Data Lake Store, Polybase, SQL Data Warehouse, SQL Database, Automation Runbooks, Analysis Services and Power BI Embedded.

A look into the overall architecture and the different components and how they work together.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Beginner

Session Code:

Date: December 14

Time: 4:00 PM - 5:00 PM

Room: P22: BI

If you flirt with SSAS Tabular or you are forced by circumstances to start you journey as SSAS Tabular developer. If you work with Power BI and want to understand the engine better. Or if you just want to understand basics of SSAS Tabular technology and its traps. Join me for a short ride around SSAS Tabular galaxy. We will look into basic concepts, architecture and development process of SSAS Tabular.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Beginner

Session Code:

Date: December 14

Time: 1:30 PM - 2:30 PM

Room: P22: BI

How is Excel changing, to keep up with the people's expectations of a modern BI tool?
Exciting times of endless possibilities and fast shifting demands of modern BI are proving to be a big challenge for products with nowhere near as long of a history as the one that Excel has. But if history taught us anything, it's that Excel will persevere and transform to fulfill all the user's needs.
This is a story of how Excel went from a single piece of data (a cell) focused application to a Rows (records), Columns and Tables focused application in a span of ten years with an explosion of possibilities in the last two.
We will breeze past the early staples like Power Query and Power Pivot to submerge ourselves into the world of New data types in Excel and finish on a high note of Dynamic Arrays in Excel showing how incredibly agile (considering the long tail it's got (history))  Excel is with a transformation of its core to open up the world of incredible possibilities.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Intermedia

Session Code:

Date: December 14

Time: 10:15 AM - 11:15 AM

Room: P22: BI

The “new database on the block” Snowflake, the data warehouse built for the cloud is now available on Azure with a strategic alliance with Microsoft. What makes the new platform worth over 4B and having the status of the fastest-growing SaaS solution in the analytics market? In the presentation, we will build a sample data warehouse, ingest the data using Azure Data Factory and look at the unique capabilities of the database comparing to the cloud alternatives (Azure SQL Datawarehouse, Google BigQuery, Amazon Redshift). The presentation will be based on the practical examples of use cases in the region and what I have learned regarding the new platform in the last 2 years. Lots of hands-on examples and integrations with Azure stack like Data Factory, Power BI and Azure Databricks.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI/DEV

Level: Intermedia

Session Code:

Date: December 14

Time: 9:00 AM - 10:00 AM

Room: P19: BI/DEV

SQL Server 2017 started with query processing improvements called Adaptive Query Processing. Now, in SQL Server 2019, there are additional improvements; all of them are packed in a feature with a very promising name - Intelligent Query Processing. 
The intention of these improvements is to fix plans for poor performing queries due to wrong cardinality estimations and other sub-optimal plan decisions, and hereby enhance query performance with no code changes. 
This session will cover briefly all 2019 features: Batch Mode on Rowstore, Batch and Row Mode Memory Grant Feedback, Scalar UDF Inlining, Table Variable Deferred Compilation, and Approximate Query Processing. If time permits, you’ll see also Batch Mode Adaptive Join and Interleaved Execution.
After the session, you’ll understand how much improvements you should expect in your workloads, but also which of these features, and under which circumstances, can cause significant performance regression and how to overcome those issues.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
DBA

Level: Intermedia

Session Code:

Date: December 14

Time: 10:15 AM - 11:15 AM

Room: P21: DBA

Join this vibrant round table debate of community experts discussing various aspects of IoT. Topics to be covered contain best practices, approaches, processes, challenges, ethics and much more. If you are about to start your own IoT journey or if you feel that IoT is changing the world then don't miss this special kind of session ...
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DEV/DBA

Level: Beginner

Session Code:

Date: December 14

Time: 1:30 PM - 2:30 PM

Room: P20: DEV/DBA

We've all experienced weird situations in IT - things break without any real apparent reason. Sometimes, error messages can be helpful, but mostly they are cryptic and lead to no real explanations/solutions.

In this session, I will show a few ways to approach problem solving in a practical and concise manner. Using real-world scenarios that I have run into in the past I will explain how I approached each issue. Sometimes by finding simple solutions, but sometimes having to be creative and employ methods that may not be so intuitive.

You will leave the session with a better understanding on how to approach solving any technical issues you experience at work.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
DEV/DBA

Level: Beginner

Session Code:

Date: December 14

Time: 10:15 AM - 11:15 AM

Room: P20: DEV/DBA

DML operations mean lot of work for the database engine of Microsoft SQL Server. Understanding the details of a DML transaction may give you great benefits when planning workloads for INSERT, UPDATE and DELETE operations.

Come and learn the differences of space allocation/deallocation between Clustered Indexes and Heaps in this demo oriented session. It will answer these questions:

What is the difference of data page allocation for heaps and clustered indexes?
What is the amount of transaction log when you update data in a heap and/or in a clustered index?
What are the differences when data are delete from a heap and clustered index?
Can ETL processes be improved by usage of the right strategy for INSERTS and DELETES?
What performance drawbacks will Page Splits and Forwarded Records have for my application design?
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
DEV/DBA

Level: Advanced

Session Code:

Date: December 14

Time: 11:30 AM - 12:30 PM

Room: P20: DEV/DBA

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