Build Schedule

Advanced Filters:
  • Track

    clear all





  • Speaker


  • Level


  • Session Type

Sessions Found: 34
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:
Admin

Level: Intermedia

Session Code:

Date: March 16

Time: 11:30 AM - 12:30 PM

Room: 201

Have you struggled to get BI off the ground, or had months or years of work overturned by a change in management? 
In this talk we will discuss how we can set ourselves up for success with an AGILE data warehouse, and methods of utilising AGILE and DevOps in delivering business intelligence in a fast, effective, and user-centred method. Architecture of our warehouse, data flows, data security, user engagement and how it all fits together to build rapid value for the organisation and set yourself apart.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Intermedia

Session Code:

Date: March 16

Time: 4:00 PM - 5:00 PM

Room: 211

Azure Data Studio is no longer the new kid on the block. How many of you have used Azure Data Studio? 
              In this session we will take you on a journey introducing you to Azure Data Studio so that you can understand the ins and outs and when you should consider using Azure Data Studio in place of SQL Server Management Studio. In this demo heavy session we will look at how productive you can be with Azure Data studio and some of the features that are not available in SQL Server Management Studio.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Admin

Level: Beginner

Session Code:

Date: March 16

Time: 4:00 PM - 5:00 PM

Room: 217

There are several ways to create a machine learning model. You can use R or Python or even other languages such as C#. Advanced coding skills are required no matter which language you choose. Once the solution is created, it’s often difficult to deploy. 

Microsoft addresses those problems with Azure Machine Learning, or Azure ML. Azure ML has built-in transforms for cleansing and munging data. It also contains a variety of configurable machine learning models that can be used without coding. Deploying the model is easy, and users can link to it directly with Excel or a custom application can be written.

If you are experienced in machine learning but haven’t seen Azure ML or if you are curious about machine learning and data science, this session is for you.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Intermedia

Session Code:

Date: March 16

Time: 1:30 PM - 2:30 PM

Room: 219

Abstract:

You just found out that a client needs a SQL database to be designed from scratch.  However, you existing DBA has given two week notice.

This presentation is meant for the Accidental DBA that has little to no experience with creating a database from the group up.

Topics are focused on data storage structures, security, and integrity.  After this presentation, will be ready to meet that clients need.

Coverage:

1 - Files & File Groups
2 - Logins & Users
3 - Security using schemas
4 - Database roles for access.
5 - Table design via SSMS or TSQL.
6 - Default, Check, and NULL constraints
7 - Handling table relationships (PK vs FK).
8 - To index or not to index?
9 - Testing database integrity using DML.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Dev

Level: Beginner

Session Code:

Date: March 16

Time: 2:45 PM - 3:45 PM

Room: 219

Your database is running fine month after month with no problems. Suddenly someone reports that their query won’t run. They get an error stating “SQL Server detected a logical consistency-based I/O error“, or something even scarier. Do you know what to do now? We will walk through 3 corrupt databases exploring ways to go about finding and fixing the corruption. More importantly we will explore how to prevent further data loss at the time corruption occurs. Learn what things you can do to protect yourself when corruption strikes. Learn how to avoid making things worse, and how to protect your data if things do get worse. You will leave with a checklist of steps to use when you encounter corruption. By the end of this session you will be ready to take on corruption, one database at a time.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Admin

Level: Intermedia

Session Code:

Date: March 16

Time: 1:30 PM - 2:30 PM

Room: 217

DevOps automation can be intriguing to learn and overwhelming to implement. This session will take a real life use case of a multi-tier and complex environments, with various stake holders to a successful conclusion. The session will demonstrate the reasons to automate, along with the steps required to make it possible, offering insight into concepts that are often too vague to employ. The attendee will see multi-platform and cloud tool demonstrations on how to take the DevOps methodology and continuous delivery to actuality in their own projects, no matter if small or large.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud

Level: Intermedia

Session Code:

Date: March 16

Time: 9:00 AM - 10:00 AM

Room: 217

In order to ascertain the abilities of cloud computing platform, let us overview what is available & offered on Microsoft Azure.

Microsoft Azure has the ability to move, store and analyze data within the cloud. It is essential to evaluate multiple opportunities and options with Microsoft Azure data insights. In this session let us talk about strategies on data storage, data partitioning and availability options with Azure. A tour on how best these Azure components can help you achieve success for your Big Data platform.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud

Level: Intermedia

Session Code:

Date: March 16

Time: 11:30 AM - 12:30 PM

Room: 227

Continuous Integration (CI) and Continuous Deployment (CD) are well used methods in modern software engineering approaches and can help reduce workload, risks and therefore costs significantly. But Business Intelligence projects and amongst those especially Analysis Services projects offer certain challenges to the appliance of those methods. Comprehensive support by software vendors is definitely not given. So if you want to integrate those methods into your application life-cycle management (ALM) you probably will need to build your own solution. We will shortly recap definition and advantages of CI and CD. After a short analysis of the special challenges for BI projects we will dive into possible approaches. And let's try to find out if cloud services can be of significant importance.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Intermedia

Session Code:

Date: March 16

Time: 2:45 PM - 3:45 PM

Room: 201

In the times of data explosion, a dazzling array of information streams and unbelievable possibilities of different techniques to manage data via the Microsoft Data Platform, this session asks the question: what about data curation? 
We dive into the requirements of modern curation and show in examples, what the Microsoft Data Platform has to offer: Can SQL Server Master Data Service (MDS), Data Quality Services (DQS) and Integration Service (SSIS) especially with the integration in ADF help? Which options offers the Azure Data Catalog and how does the Microsoft Dataflows come into play? We also look at the potential of the new integrated languages in the Data Platform like R or Python via Azure Databricks. At the end of this session you will have an overview and understanding of the possibilities, that Microsoft Data Platform offers you to address your data curation requirements.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Intermedia

Session Code:

Date: March 16

Time: 2:45 PM - 3:45 PM

Room: 220

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:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Beginner

Session Code:

Date: March 16

Time: 4:00 PM - 5:00 PM

Room: 219

Learn the power of modern data transformation using DataBricks with Azure Data Factory.  Take a look how to power transformations using R, Phyton, SQL, Scala and more.  Utilize runtime job clusters to power through the biggest data.  Integrate, deploy, schedule and monitor with Azure Data Factory.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud

Level: Beginner

Session Code:

Date: March 16

Time: 1:30 PM - 2:30 PM

Room: 211

Now that SQL Server loves PowerShell and Microsoft loves open source, it is even easier to automate even your most time-consuming, repetitive, mundane or burdensome tasks.

Using the DbaChecks PowerShell module released at the SQLBits 2018 conference we can:
    Track SQL Server instance configurations
    Promptly provide required information to managmement, change configuration or developers
    Deftly respond to audit change requirements across your entire estate (and impress your auditor with PowerShell;)
    Restore SQL Servers to their correct state prior and post deployment
    Test *everything* from configuration to permissions, SQL service account share access to sysadmins, Agent Jobs to SPNs
 
This session will look at how to install and use this module . With multiple examples we will look at both running the checks and viewing the data in the supplied PowerBI reports.

Pre-requisites
Some basic knowledge of PowerShell and DBA
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Admin

Level: Intermedia

Session Code:

Date: March 16

Time: 9:00 AM - 10:00 AM

Room: 201

Ever wondered what makes an index useful? Curious about why the optimizer picks the indexes that it does? Wondered what black magic goes into designing good indexes?

In this session, we'll look at design considerations for rowstore non-clustered indexes. We'll investigate what makes an index useful to SQL Server and what common mistakes make indexes useless. We'll go into the details of how various query predicates interact with indexes and what the primary driver is when designing indexes for any database application.

This session is aimed at people who are relatively new to SQL Server indexing.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Dev

Level: Beginner

Session Code:

Date: March 16

Time: 10:15 AM - 11:15 AM

Room: 219

What is Governance?
Information Access Policy Groups/Workspaces
Sharing vs Publishing
Licensing Policy – Who is important enough??
Visual Governance 
Reporting the reports 
Including the exciting 
How to enforce/enable the policy?
Best Practices and Lessons (already) Learned… 
Will include the latest and greatest updates in PowerBI, as presented in PASS 2018 and the developments since in the Governance area.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Beginner

Session Code:

Date: March 16

Time: 10:15 AM - 11:15 AM

Room: 201

In todays hyper accelerated pace of business there is a massive demand for insights, intelligence and automation delivered at the speed of business.

In this session I will demonstrate and explain how you can integrate Power BI, Power Apps, Flow, Azure Machine Learning and Dynamics 365 to rapidly build a functioning system which allows users to analyze, insert, automate and action customer data. 

I will show you how you can use the tools listed above to rapidly build a system that will allow sales reps to instantly analyze and segment customers based on their purchases in real-time, enabling them to better serve their customers.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Beginner

Session Code:

Date: March 16

Time: 9:00 AM - 10:00 AM

Room: 211

According to the Economist magazine, data is the world’s most valuable resource.  So, it makes sense that Data Science, Azure Machine Learning, and Analytics are all becoming core pieces to the success of every business.  As data professionals, we need to know how these core pieces will affect what we do, and how we can use the Azure AI suite to help our clients.  Microsoft’s AI suite is the central hub for learning and implementing each of these core pieces.  Using an easy to follow example, I will show the flow from problem to solution.  Multiple demonstrations of the different pieces will show use cases of the AI suite.  This overview of Azure AI will use the various pieces like a puzzle which, when brought together, will form a seamless picture of the whole so that participants can see that the individual pieces were meant to work together.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud

Level: Beginner

Session Code:

Date: March 16

Time: 11:30 AM - 12:30 PM

Room: 217

As an Excel user, you've probably been building Pivot Tables for years… but do you know the difference between a Fact and a Dimension? The reality is that PivotTables have done a great job of protecting us from needing to understand proper data modeling, but in modern Excel and Power BI that has changed.
In this session we will look at understanding the benefits of dimensional modeling in Power Pivot. We will define and review key terms and best practices, and show you how to use Power Query to reshape, split and combine tables into their proper tabular formats for a model.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Intermedia

Session Code:

Date: March 16

Time: 1:30 PM - 2:30 PM

Room: 201

This fall Microsoft introduced Power BI dataflows, a powerful new feature for self-service data preparation powered by Azure Data Lake Storage gen2. Dataflows bring the familiar Power Query data prep experience to the Power BI service, and enable analysts and business users to define reusable data entities that can be shared and reused across workspaces and apps.

In this session, Power BI program manager Matthew Roche will introduce this exciting new capability, including an end-to-end demonstration of the Power BI dataflows experience. If you haven’t yet started to explore dataflows – or if you want to build on what you already know – this is the session for you.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Intermedia

Session Code:

Date: March 16

Time: 10:15 AM - 11:15 AM

Room: 217

When SQL Server arrived on Linux in 2017, Microsoft brought with it a database engine that works exactly the same as it does on Windows.

While you can manage and monitor SQL Server on Linux using existing tools designed for Windows, there are command line tools that will feel right at home to seasoned command-line and scripting veterans, including Oracle DBAs.

This session will cover mssql-conf (for configuring the server instance), mssql-cli (for connecting to the database engine), and dbfs (mounting a virtual file system) to query database management views (DMVs) using bash.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Admin

Level: Intermedia

Session Code:

Date: March 16

Time: 2:45 PM - 3:45 PM

Room: 211

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