Build Schedule

Advanced Filters:
  • Track

    clear all





  • Speaker


  • Level


  • Session Type



Sessions Found: 43
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:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: June 08

Time: 3:45 PM - 4:45 PM

Room: 402

In the last releases,  SQL Server development was enriched with new T-SQL features, such as CTE (common table extension), array of Ranking and Windowing functions (ROW_NUMBER, RANK, DENSE_RANK, TILE), MERGE statement, OUTPUT clause, EXCEPT and INTERSECT just to name a few. For various reasons some DBA/Developers do not utilize these new features. In this session, the audience will see demonstrations of the different practical use cases where these features can make T-SQL coding more efficient. This 100% code-based demo session highlights efficiency to utilize the latest T-SQL functions over conventional methods with the same functionality. The session will cover in depth live scenarios where these features have proven performance efficiency, code re
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: June 08

Time: 10:45 AM - 11:45 AM

Room: 403

Using the SQL setup wizard and management studio (SSMS) to install and configure a new SQL server is a time-intensive process.  PowerShell scripts can greatly reduce the time required to complete the process.  They can also ensure build standardization throughout your SQL environment.  In this session we will look at using PowerShell scripts and JSON parameter files to automate the installation and post-install configuration of a SQL Server.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: June 08

Time: 9:30 AM - 10:30 AM

Room: 411

Automating the configuration of SQL Server instances and being able to check the configuration for standard configuration is an important role for any DBA when you have lots of instances.  But how can we automate the configuration easily?  How can we check to make sure the proper configuration is in place and hasn’t changed?

In this session, we will look at how to configure your SQL Server Instances using PowerShell and the dbatools module.  Then we will look at how to use dbachecks to confirm the configuration of our instances and how to check for changes in the future of the configuration.  

Attendees will see how easy it to use PowerShell via dbatools to configure their SQL Server instances.  Attendees will see how easy it is to use PowerShell via dbachecks and PowerBI to see if their servers are configured properly.  Attendees will be given a set of scripts that take back to use to configure and test the configuration of their SQL Server instances.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: June 08

Time: 9:30 AM - 10:30 AM

Room: 353

Microsoft Cognitive Services enables developers with powerful set of APIs that can be used to develop intelligent apps with powerful algorithms, using just a few lines of code.The API enables developers to easily add intelligent features – such as emotion and video detection; facial, speech and vision recognition; and speech and language understanding – into their applications with minimum effort. This session will show case how to get started with the API and how it can be integrated with your application
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: June 08

Time: 3:45 PM - 4:45 PM

Room: 353

In this case study, I detail how I went about designing and implementing a Speaker Database for the Project Management Institute using SharePoint, Flow, 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:
Application & Database Development

Level: Beginner

Session Code:

Date: June 08

Time: 2:30 PM - 3:30 PM

Room: 353

At some point in time every DBA struggles with the concepts and implementation of a proper performance monitoring strategy. This pre-con will cover the fundamental techniques and code snippets that will help you get to the bottom of who or what may be causing you problems. At the end of the day you will feel much more confident that you have the tools and the knowledge to start implementing a fundamental performance monitoring strategy that will work well for your environment.  All the demo’s are based on actual code and techniques that anyone can use to obtain these goals. We will also cover the key aspects of SQL Server that you need to be aware of to make the right decisions regarding performance. 
•	Learn the core aspects of SQL Server that require monitoring
•	Learn how to properly capture the required performance metrics
•	Learn how to analyze and understand the metrics to maximize your time and reduce your effort
Speaker:

Accompanying Materials:

No material found.

Session Type:
Pre- Con Full Day Session (480 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: June 07

Time: 12:45 PM - 8:45 PM

Room: 403

It seems more lately than not, there are daily stories of a data breach somewhere. Data security is one of the most critical things a data professional should be aware of. Now, there are several ways of implementing data security in today's world. SQL Server comes with several native data encryption methods that you can use. In this session, we will explore the basics of data encryption, how to implement some of them, some gotchas as well as some of the newer features of data encryption in newer versions.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: June 08

Time: 2:30 PM - 3:30 PM

Room: 360

Most training for databases ignores the single most critical element for successful collection and analysis of data, the meaning of the data itself. 
This session explores how meaning affects results and why assuming a query is right just because it ran creates problems for the decision makers using the data results.a
We will look at how it impacts database design. We will examine how it affects ETL and Big Data analyses. We will look at complex reporting queries and how incorrect results can harm the business.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Extended Session (90 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: June 08

Time: 10:45 AM - 12:15 PM

Room: 411

The deployment process is frustrating; an object is missing, an object is deployed in the wrong order or an incorrect version. Deploying to multiple environments like Dev, QA, UAT, and Prod is a challenge whether on-premise or in the cloud. Source controlling database objects is paramount. Team development is required. Database code will only be deployed when changed. Proper security deployment will be repeatable per environment. Together, let us discover how using Database Project will help us with consistent releases. Deployments can cause you trouble but we will share a reliable deployment and version control process. Let’s see how Database Project can help us accomplish this goal.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: June 08

Time: 8:15 AM - 9:15 AM

Room: 353

Unless you are developing code by yourself, you face challenges of working with several team members. Different people are changing code which affects the code someone else is working on. In addition, there will be teams working on different projects at the same time.  In the middle of the projects, an emergency fix needs to be deployed to Production. So where is the code, when do you shared it with others, when do you get the code that has been shared, where is the production code branch located.  How do I branch and when do merge? How do I get a release branch? Let me share with you how we are handling this area of DevOps.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: June 08

Time: 2:30 PM - 3:30 PM

Room: 401

I was an employee of a company that had an office in the World Trade Center on Sept. 11, 2001.  Prior to that infamous date, I had written several departmental documents that ended up being critical to our recovery.  In this presentation, I provide a narrative of what happened in the weeks following 9/11, and how documentation played a role in getting the organization back on its feet.

While other disaster recovery presentations talk about strategies, plans, and techniques, this presentation focuses on the documentation itself.  We will discuss the documents we had and how they were used in our recovery.  We will also discuss what documents we didn't have, and how they could have made the process better.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: June 08

Time: 1:15 PM - 2:15 PM

Room: 353

Operating on a budget can result in some creative solutions. Recently I've come up with a creative solution for traditional on-premise client-server solutions that allows for full redundancy in the cloud, but at a budget price. This is accomplished through VMs, copying of logs to Blob Storage, automation of hydration, updates & de-allocation.  It may be a bit of a Rube Goldberg machine, but it works! The result is an extremely pro-rated and affordable DR solution that is restorable to within 1 hour or less of production. Come to this session to learn more about the hurdles faced when putting this solution together and to brainstorm together how it can even be improved.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: June 08

Time: 10:45 AM - 11:45 AM

Room: 402

Do you ever look at your data visualizations and feel that they are lackluster? Have you made a report using the latest chart types, but you still can’t gain adoption from your target audience? Lots of people feel this way, but they can’t quite identify what should be changed or how to change it. This session will help you identify signs that it’s time to give your data visualizations a makeover and provide practical tips for improving your reports and dashboards. We’ll discuss how simple changes in design choices related to color, chart types, chart formatting, and report layout can make a big difference in creating clear and engaging visualizations with common analysis tools like Power BI and Excel.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: June 08

Time: 9:30 AM - 10:30 AM

Room: 360

Many companies start off with a simple data mart for reporting. As the company grows, users become dependent on the data mart for monitoring and making decisions on Key Performance Indicators (KPI).

Unexpected information growth in your data mart may lead to a performance impacted reporting system. In short, your users will be lining up at your cube for their daily reports.

How do you reduce the size of your data mart and speed up data retrieval?  This presentation will review the following techniques to fix your woes.

Techniques:
1 – What is horizontal partitioning?
2 – Database sharding for daily information.
3 – Working with files and file groups.
3 – Partitioned views for performance.
4 – Table and Index partitions.
5 – Row Data Compression.
6 – Page Data Compression.
7 – Programming a sliding window.
8 – What is different in Azure SQL database?
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: June 08

Time: 9:30 AM - 10:30 AM

Room: 401

This session will explore how to apply the various categories and types of Machine Learning algorithms to common data science tasks, along with explaining the corresponding statistical methods being implemented by those algorithms.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: June 08

Time: 2:30 PM - 3:30 PM

Room: 402

Extended Events are an essential part of properly monitoring and every DBA should know what they are and how to use them.  This session will cover the basics of Extended events as well as an introduction to the system_health session.  This session will give someone who has never used Extended events before the skills to start using them!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: June 08

Time: 10:45 AM - 11:45 AM

Room: 353

Ever wonder why SSIS runs so slowly? Watch SSIS author Andy Leonard as he runs test loads using sample and real-world data, and shows you how to tune SQL Server 2016 Integration Services (SSIS 2016) packages.

We'll start by experimenting with SSIS design patterns to improve performance loading AdventureWorks data. We will implement different change detection patterns and compare execution performance for each. Then, we'll explain a Data Flow Task's bottleneck when loading binary large objects - or Blobs. 

Finally, we'll demonstrate a design pattern that uses a Script Component in a Data Flow to boost load performance to MySql, whether on-premises or in the cloud.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Advanced

Session Code:

Date: June 08

Time: 10:45 AM - 11:45 AM

Room: 360

Azure SQL Database offers a way quickly spin up new databases with minimal management requirements. However, the number of differences between on-premises SQL Server and Azure SQL Database can be overwhelming. Even worse, with DBaaS it’s not clear who is responsible for what anymore. In this session, we will cover all the basic steps of getting your first Azure SQL Database instance spun up. We’ll cover common gotchas, like firewall settings and resource locks. We’ll also dive into some more advanced options with templates, allowing you to make your processes reproducible. By the end of this presentation, you’ll understand if Azure SQL Database is the right choice for you and your needs. You’ll understand how it can simplify management and allow you to scale easily. Finally, you’ll have the confidence to go and create your own instance with ease.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: June 08

Time: 8:15 AM - 9:15 AM

Room: 411

One of the most common problems I have encountered as a DBA is the complaints from users that a particular query is slow, just one query.  Many times one that used to run in acceptable time, but that over time has slowed down substantially.

In this session we will show some of the causes for this, with emphasis on I/O requests being too high for the query.  

First part of the session will explain how to find these numbers, looking at a few queries with some major performance issues, including explaining why they have a problem.

The second part will focus on how to reduce I/O requests.

All of this can be done without the need for any 3rd party tools, all within the scope of what is available to SQL Server, all versions, all editions, including Azure.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: June 08

Time: 1:15 PM - 2:15 PM

Room: 411

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