Build Schedule

Advanced Filters:
  • Track

    clear all





  • Speaker


  • Level


  • Session Type

Sessions Found: 33
Need to report on some data from SharePoint? We will look at three different techniques to pull data from a SharePoint Server. We will start with SSIS and the SharePoint List Source and Destinations. Next, We will use Excel to connect to various SharePoint lists (both online and on premise), and finally We will use Microsoft Access to do the same thing (and throw in the capability to do updates as well). At the end of the talk, We will have three different ways to get data from SharePoint.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database Administration, Deployment, and Development

Level: Intermedia

Session Code:

Date: June 13

Time: 11:30 AM - 12:30 PM

Room: https://tinyurl.com/2020sqlsatla-Blackline

If you are not sure why JSON is in SQL Server or how to use it, this is the session for you!  We will start with the basics of what JSON is and learn all about extracting, querying, and even indexing JSON data.  The goal of this session is to take the mystery out of working with JSON in SQL server and add JSON to the list of tools in your SQL Server tool-belt.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Data Presentation, Visualization, and Analytics

Level: Beginner

Session Code:

Date: June 13

Time: 10:15 AM - 11:15 AM

Room: https://tinyurl.com/2020sqlsatla-Blackline

Data Wrangling is becoming more and more popular in BigData and Enterprise world. Data Lake stores tons of different data and it is not easy to get value from it. To prepare data we need to write and test code that could take a while. But, business requires to have results immediately and reduce time to market. In this session, I invite you together look at Self-Service Data Prep and show how to use Power Query Online in Azure Data Factory Wrangling data flows for code-free data transformations via spark execution.
VMware Room - https://tinyurl.com/2020sqlsatla-vmware
Feedback - https://tinyurl.com/2020sqlsatla-eval
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data Presentation, Visualization, and Analytics

Level: Beginner

Session Code:

Date: June 13

Time: 3:30 PM - 4:30 PM

Room: https://tinyurl.com/2020sqlsatla-VMware

Let us connect DBAs and Infrastructure Admins providing to DBAs vital information how to get best SQL Server deployment on top of VMware virtual platform.

The session will cover both the design and the configuration of a SQL Server virtual machine with the special focus on:

vCPU allocation and deep dive in vNUMA

Memory allocation and configurations options

Storage configuration best practices including PMem/NFS/Snapshots

Network configuration myths and best practices

It all that you want to know about virtual platform configuration but hesitated to ask! Directly from the source with the tom of hands-on from the Professional Services
VMware Room - https://tinyurl.com/2020sqlsatla-vmware
Feedback - https://tinyurl.com/2020sqlsatla-eval
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Private and Public Cloud Architecture and Infrastructure

Level: Intermedia

Session Code:

Date: June 13

Time: 10:15 AM - 11:15 AM

Room: https://tinyurl.com/2020sqlsatla-VMware

The Azure SQL Database Hyperscale tier is  SQL architected for the cloud and allows applications that encountered limits of prior tiers  to be unshackled. Will deep dive into the architecture of Hyperscale and discuss  the components of hyperscale and iteraction between each component and  the internals of each component. We will cover  scaling aspects and the new application patterns it enables. Last but not the least best practices during migration as well as new diagnostics introduced in Hyperscale that help in performance troubleshooting and bottleneck identification.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Administration, Deployment, and Development

Level: Intermedia

Session Code:

Date: June 13

Time: 3:30 PM - 4:30 PM

Room: https://tinyurl.com/2020sqlsatla-Microsoft

In this session, you'll learn from the Microsoft Product Group about the different options for your SQL deployments in Azure. After this session, you should be able to: 
? Articulate the key differentiators between SQL Server on-prem, in Azure VM, in Azure SQL DB (Single database, Elastic Pools, and Managed instance)
? Explain the different service tiers within Azure SQL DB, and evaluate what is best for your workloads and business requirements (Serverless, Hyperscale, General Purpose, Business Critical, etc)
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Private and Public Cloud Architecture and Infrastructure

Level: Beginner

Session Code:

Date: June 13

Time: 11:30 AM - 12:30 PM

Room: https://tinyurl.com/2020sqlsatla-Microsoft

Many companies have small tasks that need to be accomplished regularly. Sometimes these tasks require a number of steps to be successful. Need a basic workflow app but aren't a .Net developer?  We have a solution for you.  

This session will be demo intensive, focusing on how to use SSIS, SSRS, and SQL Server standard edition to stitch together a process that emulates a proper workflow.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data Presentation, Visualization, and Analytics

Level: Intermedia

Session Code:

Date: June 13

Time: 2:15 PM - 3:15 PM

Room: https://tinyurl.com/2020sqlsatla-Microsoft

Would you like to get to $1m annual revenue in 5 easy steps?
Or, do you simply want to go from barely sustainable to profitable?

In this session I will touch on the 5 steps I considered when building and growing out a SQL Data Platform practice. 
1. Choose a specialty.
- How to decide what to do, and how to make it shine.
2. Pick your partners.
- Why partnering is essential.
- Augmenting your capabilities.
3. Defining services.
- What are the differences between Managed Service and Professional Service.
- How many services to offer.
- How to pick a service and price point.
- How long before you actually make money.
4. Market your offerings.
- Yes, you have to sell, yourself.
- When to give things away for free
- The value of existing customers
5. Build your team.
- You're making it, now you need to manage it
- Bringing on the right people.

I'll also touch on how long it took me to achieve each of these, and how I measure success.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Intermedia

Session Code:

Date: June 13

Time: 1:00 PM - 2:00 PM

Room: https://tinyurl.com/2020sqlsatla-PureStorage

In this case study, I detail how I went about designing and implementing a Speaker Database for the Project Management Institute using SharePoint, Power Automate, Power Apps, and Microsoft Forms. We will do a brief intro of what each technology is and it's pros and cons, and then dive into what I learned about each, each strengths and weaknesses, and how I was able to build a functional Speaker Database.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data Presentation, Visualization, and Analytics

Level: Beginner

Session Code:

Date: June 13

Time: 3:30 PM - 4:30 PM

Room: https://tinyurl.com/2020sqlsatla-Blackline

Data lakes have been around for several years and there is still much hype and hyperbole surrounding their use. This session covers the basic design patterns and architectural principles to make sure you are using the data lake and underlying technologies effectively. We will cover things like best practices for data ingestion and recommendations on file formats as well as designing effective zones and folder hierarchies to prevent the dreaded data swamp. We’ll also discuss how to consume and process data from a data lake. And we will cover the often overlooked areas of governance and security best practices. This session goes beyond corny puns and broken metaphors and provides real-world guidance from dozens of successful implementations in Azure.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data Presentation, Visualization, and Analytics

Level: Intermedia

Session Code:

Date: June 13

Time: 1:00 PM - 2:00 PM

Room: https://tinyurl.com/2020sqlsatla-Blackline

The world of analytics and data warehousing has evolved rapidly in the last 10 years with the Data Lake as the backbone of modern data environments. Data Lakes are best built leveraging unique services of the cloud provider to reduce operations complexity. This session will explain why everyone's talking about data lakes, break down the best services in Azure to build a Data Lake, and walk through code for querying and loading with Azure Databricks.

Attendees will leave the session with a firm grasp of why we build data lakes and how Azure Databricks fits in for ETL and querying.

Agenda:
	- Why Data Lakes?
	- Data Lake best practices
	- Reference Architecture implemented with:
		? Azure Databricks
		? Azure Data Lake Storage (Gen 2)
		? Event Hubs for Apache Kafka
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Private and Public Cloud Architecture and Infrastructure

Level: Intermedia

Session Code:

Date: June 13

Time: 9:00 AM - 10:00 AM

Room: https://tinyurl.com/2020sqlsatla-Blackline

"But... it worked on my computer!" A good DevOps practice and implementation will help eliminate that unwelcome phrase! Come to this session to learn how to use tools and platforms like Visual Studio Code, Git, Azure DevOps, GitHub Actions for a modern, secure and easy-to-use database DevOps experience for Azure SQL. We will use demos to show and evaluate two approaches: first, a code-centric migration-based approach (using DbUp and GitHub Actions), and second, a more complex project/state-based approach (using Visual Studio SQL Projects and Azure DevOps and a locked-down Azure SQL DB) to understand some of the many possibilities for implementing DevOps for Azure SQL.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Private and Public Cloud Architecture and Infrastructure

Level: Intermedia

Session Code:

Date: June 13

Time: 1:00 PM - 2:00 PM

Room: https://tinyurl.com/2020sqlsatla-Microsoft

When designing your documents for databases such as MongoDB, CosmosDB, or DocumentDB you should not be following old normalization rules. What rules it should your follow? This session will give you a good foundation for figuring this out. I'll be surveying some common use cases and how to model them. We'll discuss some rules of thumb, and discover both how and why certain designs work better than others. Relationships, entities, indexes, memory, working sets - all the familiar concepts in an all new light.
VMware Room - https://tinyurl.com/2020sqlsatla-vmware
Feedback - https://tinyurl.com/2020sqlsatla-eval
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Administration, Deployment, and Development

Level: Intermedia

Session Code:

Date: June 13

Time: 2:15 PM - 3:15 PM

Room: https://tinyurl.com/2020sqlsatla-VMware

Your server has dozens of CPUs, terabytes of RAM, and solid-state drives, and yet your UPDATE query still takes hours. Why? In this demo-filled session, we examine common pitfalls for any SQL professional who manipulates large sets of data with INSERT, UPDATE, and DELETE statements. We discuss potential issues involving data pages, locks, and the transaction log, as well as techniques you can use to improve performance.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Database Administration, Deployment, and Development

Level: Intermedia

Session Code:

Date: June 13

Time: 2:15 PM - 3:15 PM

Room: https://tinyurl.com/2020sqlsatla-SentryOne

You know that execution plans can provide you with vital information to tune a query, but just how does that plan get generated?  In this session, we will examine details of the query optimization process that are not very well known.  We will discuss how SQL Server parses a T-SQL statement then  begins applying rules to make it more efficient.  Did you know that SQL Server can be coaxed into outputting hidden structures such as parse trees and memos?  We'll do just that, and then take it a step further with a free unique visualization tool that I have created.  With a better understanding of how SQL Server optimizes T-SQL (and sometimes doesn't do it as well as might be hoped), you can write more efficient SQL statements.
VMware Room - https://tinyurl.com/2020sqlsatla-vmware
Feedback - https://tinyurl.com/2020sqlsatla-eval
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database Administration, Deployment, and Development

Level: Advanced

Session Code:

Date: June 13

Time: 1:00 PM - 2:00 PM

Room: https://tinyurl.com/2020sqlsatla-VMware

Hopefully, you are monitoring your SQL Servers using DIY scripts or a 3rd party tool. Active monitoring is invaluable to enable the operational DBA to identify and address issues quickly. But did you know that SentryOne offers capabilities beyond just monitoring? Join me and I'll show you how SentryOne provides environment wide visibility and aids in managing cross-server activities. I'll showcase how alerting can be tuned to be effective and not noise. And you'll discover how SentryOne can give you both operational and business value to address your application challenges.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: June 13

Time: 11:30 AM - 12:30 PM

Room: https://tinyurl.com/2020sqlsatla-SentryOne

BigQuery is the data warehouse offering from Google Cloud Platform. It also has a powerful and increasingly growing machine learning integration. Using BQML, you can create, train, or import linear regression and classifier models directly into your dataset. You can then make predictions directly using SQL and integrate them into your reporting and dashboards. This session will cover BigQuery ML and a few example applications.
VMware Room - https://tinyurl.com/2020sqlsatla-vmware
Feedback - https://tinyurl.com/2020sqlsatla-eval
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Private and Public Cloud Architecture and Infrastructure

Level: Advanced

Session Code:

Date: June 13

Time: 9:00 AM - 10:00 AM

Room: https://tinyurl.com/2020sqlsatla-VMware

Do you write T-SQL for a living and want to improve its performance? Do you wish your 3rd party vendor code would magically go faster? Then you need to learn about Intelligent Query Processing in SQL Server 2019. This collection of new features is a game changer that will improve performance across the board. Come to this overview session to learn more about how these capabilities will benefit you.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Administration, Deployment, and Development

Level: Beginner

Session Code:

Date: June 13

Time: 9:00 AM - 10:00 AM

Room: https://tinyurl.com/2020sqlsatla-SentryOne

Artificial Intelligence (AI) is bringing big changes in the way people and businesses relate to technology.
As well as the arrival of the personal computer, the cloud computing, and smartphones, the AI is the artificial technology that takes you to where you're going so much faster, intuitive and smart.
In this session, we will discuss the basics of IA and how we can apply it in our business using the Azure Machine Learning Services
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data Presentation, Visualization, and Analytics

Level: Beginner

Session Code:

Date: June 13

Time: 3:30 PM - 4:30 PM

Room: https://tinyurl.com/2020sqlsatla-SentryOne

Containers are the new "virtual machines" and one of the hottest technologies in the industry. While containers compliment virtual machines and provide consistency, portability, performance, and availability, how do you deploy containers at scale? For many, Kubernetes, an open-source system for automating deployment, scaling, and management of containerized applications, is the answer. 

In this session, we will dive deep into the Kubernetes platform and how SQL Server containers can be deployed, managed, and configured. You will see how SQL Server can take advantage of Kubernetes for "built-in" high availability, easy to deploy patching, and integration with Always On Availability groups. We will discuss deploying SQL Server in various popular Kubernetes distributions including but not limited to Azure Kubernetes Service, OpenShift, and kubeadm. This session assumes a fundamental knowledge of both SQL Server and containers. We will move fast, and go deep using demos as a method to lea
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Administration, Deployment, and Development

Level: Advanced

Session Code:

Date: June 13

Time: 10:15 AM - 11:15 AM

Room: https://tinyurl.com/2020sqlsatla-Microsoft

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