Build Schedule

Advanced Filters:
  • Track

    clear all





  • Speaker


  • Level


  • Session Type


Sessions Found: 41
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: 227

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:

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Intermedia

Session Code:

Date: March 16

Time: 1:30 PM - 2:30 PM

Room: 217

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:

Session Type:
Regular Session (60 minutes)

Track:
Dev

Level: Beginner

Session Code:

Date: March 16

Time: 1:30 PM - 2:30 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: 227

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:

Session Type:
Regular Session (60 minutes)

Track:
Cloud

Level: Intermedia

Session Code:

Date: March 16

Time: 9:00 AM - 10:00 AM

Room: 227

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:

Session Type:
Regular Session (60 minutes)

Track:
Cloud

Level: Intermedia

Session Code:

Date: March 16

Time: 11:30 AM - 12:30 PM

Room: 227

At Birds-of-a-Feather (BoF) sessions, attendees group together based on a shared interest and carry out discussions without any pre-planned agenda.  This is a chance to connect and share over lunch at an informal gathering.  The speaker(s) listed are NOT presenting to the room, they're just there to join in.  

Topic: Big Data, Data Science & AI
Speaker:

Accompanying Materials:

No material found.

Session Type:
Birds of a Feather (35 minutes)

Track:
Cloud

Level: Beginner

Session Code:

Date: March 16

Time: 12:45 PM - 1:20 PM

Room: 201

At Birds-of-a-Feather (BoF) sessions, attendees group together based on a shared interest and carry out discussions without any pre-planned agenda.  This is a chance to connect and share over lunch at an informal gathering.  The speaker(s) listed are NOT presenting to the room, they're just there to join in.  

Topic: Data Warehousing, Analytics & Reporting
Speaker:

Accompanying Materials:

No material found.

Session Type:
Birds of a Feather (35 minutes)

Track:
Admin

Level: Beginner

Session Code:

Date: March 16

Time: 12:45 PM - 1:20 PM

Room: 227

At Birds-of-a-Feather (BoF) sessions, attendees group together based on a shared interest and carry out discussions without any pre-planned agenda.  This is a chance to connect and share over lunch at an informal gathering.  The speaker(s) listed are NOT presenting to the room, they're just there to join in.  

Topic: Database Administration
Speaker:

Accompanying Materials:

No material found.

Session Type:
Birds of a Feather (35 minutes)

Track:
Admin

Level: Beginner

Session Code:

Date: March 16

Time: 12:45 PM - 1:20 PM

Room: 217

At Birds-of-a-Feather (BoF) sessions, attendees group together based on a shared interest and carry out discussions without any pre-planned agenda.  This is a chance to connect and share over lunch at an informal gathering.  The speaker(s) listed are NOT presenting to the room, they're just there to join in.  

Topic: Development & DevOps
Speaker:

Accompanying Materials:

No material found.

Session Type:
Birds of a Feather (35 minutes)

Track:
Dev

Level: Beginner

Session Code:

Date: March 16

Time: 12:45 PM - 1:20 PM

Room: 211

At Birds-of-a-Feather (BoF) sessions, attendees group together based on a shared interest and carry out discussions without any pre-planned agenda.  This is a chance to connect and share over lunch at an informal gathering.  The speaker(s) listed are NOT presenting to the room, they're just there to join in.  

Topic: PowerBI
Speaker:

Accompanying Materials:

No material found.

Session Type:
Birds of a Feather (35 minutes)

Track:
BI

Level: Beginner

Session Code:

Date: March 16

Time: 12:45 PM - 1:20 PM

Room: 219

Scott isn't a rocket scientist… far from it… he will shy away from .NET development ANY chance he can get!  PowerApps, part of Microsoft's Power Platform, allow the knowledgeable information worker to develop in a "Low Code/No Code" environment.  Sure, there are expressions to control logic in PowerApps, but if you can handle writing excel formulas, I'm sure you'll be just fine.  Watch Scott sweat on stage as he builds a responsive application in the cloud and push it down to his iPhone, store and retrieve data from an enterprise data solution, and take a bow… (or scrunch up into a fetal position and never step on stage again… )
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Dev

Level: Beginner

Session Code:

Date: March 16

Time: 2:45 PM - 3:45 PM

Room: 217

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:

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:

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Intermedia

Session Code:

Date: March 16

Time: 2:45 PM - 3:45 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:

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:

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:

Session Type:
Regular Session (60 minutes)

Track:
Dev

Level: Beginner

Session Code:

Date: March 16

Time: 10:15 AM - 11:15 AM

Room: 217

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

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