Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type

Sessions Found: 17
For years we have been bombarded with AI-enabled/smart/intelligent features, tools and platforms. But what does it actually mean for Sql Server developers and DBAs in practical terms? Is it just marketing hype or contrary - distinct trend that has already started and impacts how and what we do, our workplaces and future careers? This session defines what AIOPs is, provides framework to measure AI, goes through the list and evaluates 'the latest and greatest' tools and features available in Sql Server both on-premises and in the cloud and finally shows practical use cases of the best of them that we have to adopt to stay relevant on increasingly competitive market. Let's find out if maintenance free, self-healing, auto-tuning databases that are able to detect and automatically mitigate security risks are ready for real-world workloads! Areas covered:
- Conditional Access VS Thread Detection
- Query Store and Automatic Tuning
- Intelligent Query Processing
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: January 26

Time: 2:45 PM - 3:45 PM

Room: Audi

In this session I will walk through some of the out-of-box SQL Server tools that you will need to know or never knew could be so much fun. A number of commandline utilities exist with SQL Server that we are never exposed to. In this session, I will take a tour of each of these tools and the scenario’s that real world customers used them in innovative ways. From SQL Server Management Studio to every tools will be an hour of Demo extravaganza not to be missed. This is a Zero slide but an hour of demo marathon.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: January 26

Time: 11:45 AM - 12:45 PM

Room: Room 1

In this session, we will go through architecture, components & demos in order to build Power BI Dashboards with Real-time* data. Of course in fun way :)
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code:

Date: January 26

Time: 10:45 AM - 11:45 AM

Room: Room 2

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: January 26

Time: 1:45 PM - 2:45 PM

Room: Room 1

We have more information available to us today than ever before. So much so that we run the risk of not being able to tell concise stories. There's a lot more to creating that story than just getting the correct information. Come learn not just the do's and don'ts, but the whys…
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: January 26

Time: 11:45 AM - 12:45 PM

Room: Room 2

Spark and Azure Databricks have become game changing features in data world and processing large volume of data has never been faster. In this session , I will give a introduction to Azure Databricks, Apache Spark and will walk though step by step on how to use Azure Databricks.Additionally I will showcase how to perform ETL operations using Azure Databricks.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: January 26

Time: 10:45 AM - 11:45 AM

Room: Audi

In the last few years the requirement to understand and use distributed Source control systems has become an increasing part of a Data Professionals life. 
With the move into Open Source and community involvement even Microsoft has embraced the use of GitHub!

In this session we will investigate the setup and use of GitHub and Git for source control.
Using the highly popular DBATools open source project we will also investigate getting involved in an Open Source project and the process of Pull and Push requests!

Based around personal experience of learning not to hate Source control, this session assume no experience with Git or Github
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: January 26

Time: 1:45 PM - 2:45 PM

Room: Audi

ORMs - oh how I LOVE them! As a consultant, when I see them in play at a client I go KACHIIINNNNGGGG!! :-D Seriously though, they can provide some substantial benefits for coding throughput. But if you don't Read The Fine Manual and do some things right and avoid some major gotchas you will fall prey to one of my favorite Guruisms: "Anything that allows developers to slap code together more quickly is inversely proportional to the performance, concurrency and scalability you will get from that code"! Although this talk is based on Entity Framework, all ORMs suffer from the same flaws.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: January 26

Time: 4:00 PM - 5:00 PM

Room: Room 1

Have you heard about the Business Intelligence Markup Language (Biml)? Maybe you’ve even seen a session about it before but you still have doubts about how easily you can make something useful out of it. In this session, we’ll use Biml to build and populate a staging area including the corresponding SSIS packages. But there won’t be any pre-compiled demos - everything is happening live! Starting with a blank staging database, we will end up building a complete solution over the course of this session to prove that you can start from scratch and still quickly be successful.
Let’s see, how that goes… ?

PS: Even if you have not heard about Biml but are still tired of manually building SSIS packages, this is the right session for you!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Information Delivery

Level: Intermedia

Session Code:

Date: January 26

Time: 2:45 PM - 3:45 PM

Room: Room 2

The Data & AI technology landscape have change drastically for the past few years and we are beginning to see more real-life implementation of modern data warehouses, big data, machine learning, chat-bots & IoT in customers environment. In this years keynote session, I will share Microsoft's overall Data & AI technologies and which have been the most asked about from real customers on the ground and how are they implementing the various software & services components to realize business value.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code: Keynote

Date: January 26

Time: 9:30 AM - 10:30 AM

Room: Room 1

What is a Modern Data Warehouse? How is it different from the traditional Data Warehouse architecture? Where to start building the Data Warehouse? Cloud or no Cloud?

This session will answer and expand upon each one of these questions.

From the traditional data warehouse architecture to the modern data warehouse using Azure technologies, you will learn different services that are a good fit for your solutions and how to integrate them.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: January 26

Time: 11:45 AM - 12:45 PM

Room: Audi

During this session, you will learn about what is neccessary to know
and learn about SQL Server to have the best performing database environment in
terms of managability, performance, security, HADR and etc.
SQL Server is not just only a data storage, and due to very complex and complicated
interanl engines, requires to be maintained and administrated in proper manner.
This session will give you enough knowledge about what you are not aware about 
SQL Server.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: January 26

Time: 2:45 PM - 3:45 PM

Room: Room 1

Data sourcing has changed a lot in the past. This session walks through on orchestrating data movement by an ELT approach by sourcing data from a centralized data lake store to Azure SQL DW and performing data transformation using Azure Data Factory.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: January 26

Time: 1:45 PM - 2:45 PM

Room: Room 2

Being a BI Professional, you need all the performance tuning the DB folks get and more.  In this hour, we will go over important performance tuning tips that you can use to help make your deliverables faster and more effective.  We will touch on the MSBI tools of SSIS, SSAS, SSRS and PowerBI.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: January 26

Time: 4:00 PM - 5:00 PM

Room: Room 2

We will discover what are the best new features in SQL Server 2019!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: January 26

Time: 7:00 PM - 8:00 PM

Room: Room 1

With SQL Server 2019, Microsoft is introducing a new couple of features for data virtualization, data mart scale out and big data analysis. They all together for the SQL Server Big Data Clusters.

Let's take a look at what that means and how you can make use of the extended polybase capabilities, built in spark queries and more!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Information Delivery

Level: Intermedia

Session Code:

Date: January 26

Time: 10:45 AM - 11:45 AM

Room: Room 1

If you are considering moving your SQL Server instances to "The Cloud" you will need to have a plan in place for both high availability and disaster recovery. In this session we will examine the three top public cloud providers and what they have to offer in terms of both high availability and disaster recovery. We will discuss where the providers are the same and where the differ. Some real life customer configurations will be presented. With content from Cloud and Datacenter Management MVP Dave Bermingham, Jason Aw will lead this session and encourages you to bring your questions specific to your environment.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: January 26

Time: 4:00 PM - 5:00 PM

Room: Audi

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