Build Schedule

Advanced Filters:
  • Track

    clear all







  • Speaker


  • Level


  • Session Type


Sessions Found: 37
Microsoft report authors work in several tools, including T-SQL, SSMS, SSRS, and Power BI.  Come to this session to learn 60 rapid fire tips that will make you not only be better, but increase you enjoyment working with those tools.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Business Intelligence and Analytics Platforms

Level: Intermedia

Session Code:

Date: June 09

Time: 3:45 PM - 5:00 PM

Room: #246 - DELL/EMC

Even with the increased simplicity of plan forcing using Query Data Store in SQL Server 2016 and above, plan guides remain a very powerful but often overlooked feature of SQL server. There is a misconception in the community that plan guides are really only useful for situations where the DBA "cannot change the code" but actually plan guides have much broader applicability than simply fixing problems with poorly designed ISV code. However, for the DBA, working with plan guides can often be a confusing and frustrating experience. 

In this session we will cover what plan guides are, how they work and demonstrate scenarios where they can be successfully used to solve a number of problems DBAs experience on a day to day basis.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Database Administration, Performance Tuning Optimization, and De

Level: Intermedia

Session Code:

Date: June 09

Time: 2:00 PM - 3:15 PM

Room: #233 - VMware

Performance troubleshooting is a required skill for every DBA. Knowing the deep internals of how a query functions and why SQL Server chose to run it in a certain way is important. Knowing how to design a table or configure a database to squeeze every ounce of performance is our lifeblood. 

What if I told you that you may be doing this all wrong? What if all the work and laborious effort put into design or configuration don't improve the situation because the issue was never in SQL to begin with? Truth be told, the biggest differentiator between a good DBA and a great DBA is knowing the hardware and O/S; not just SQL.

Join me as I guide you through troubleshooting SQL Server performance from tip to toe to demonstrate the common performance problems you never knew you had.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Database Administration, Performance Tuning Optimization, and De

Level: Advanced

Session Code:

Date: June 09

Time: 9:00 AM - 10:15 AM

Room: #234 - Microsoft

Take a dive into SQL on Linux and take on some sea monsters that are lurking in your bathtub.  We'll take on the biblical Leviathan and answer: Why learn SQL on Linux anyway?  We'll hunt down Moby Dick by sharpening our harpoons, by using tools you're probably already using with on Windows.  After getting our feet wet, we'll go after the legendary beast, The Kraken, by leveraging your existing skills with Linux.  Don't be eaten alive by Jaws and all the new fast-paced piranha-like features of SQL 2017.  You can sail safely into the sunset by making SQL on Linux fun, memorable and learning lasting skills that will future proof your career.  If you can install, backup, and restore SQL on Windows in your sleep, then perhaps now is the time to jump in.  Be careful, you might get wet in the splash zones so dress accordingly or at least bring weather proof gear.  Anchors Away!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Database Administration, Performance Tuning Optimization, and De

Level: Intermedia

Session Code:

Date: June 09

Time: 10:45 AM - 12:00 PM

Room: #233 - VMware

The way you tune your SQL Server workloads are changing.  In the past, you would rely on dynamic management views, execution plan cache, and server-side traces or extend events.  In SQL Server 2012 we were introduced to Columnstore indexes; In SQL 2014 the cardinality estimator got a huge overhaul. With SQL Server 2016 we were given query store to allow us to get more insight into our performance pains and execution plan changes. SQL Server 2017 gave us Automatic Tuning and Adaptive Query Processing to help automate performance improvements. In this session, we will harness the ways you improve performance into the new so you can automate the pain away and spend more time identifying and tuning pain points that cannot be automated.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Database Administration, Performance Tuning Optimization, and De

Level: Intermedia

Session Code:

Date: June 09

Time: 3:45 PM - 5:00 PM

Room: #234 - Microsoft

Learn about Azure SQL Data Warehouse (SQL DW) which is a fully managed elastic database built for data warehouse workloads supporting up to petabytes of data. It has unique features like disaggregated compute and storage allowing customers to be able to utilize the service to match their diverse needs. In this session, we take a look at the architecture of SQL DW and features such as elastic scale (grow, shrink, and pause) and Polybase and how you take advantage of them for your data warehousing solution.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Cloud Infrastructure (SaaS, PaaS, IaaS, DRaaS)

Level: Beginner

Session Code:

Date: June 09

Time: 3:45 PM - 5:00 PM

Room: #249 - AWS Marketplace

If you are going to do anything with data you are going to need to learn how to query data. And the language to query the majority of those systems is through SQL (Structured Query Language). The pull data from any systems you are going to be relying on the Select statement. The features in the statement may vary slightly from platform to platform, but the core capabilities are the same.

In this session, we will dive deep in to the SELECT statement as the window to getting your data. In this session, we will be using one platform, but the lessons learned here will be applicable to querying any system that supports a SQL language interface. This session will cover things like querying, joins, functions, aggregation, sub queries, and much more. This session will give you the foundation to start analyzing data in any database system.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Database and Application Development

Level: Beginner

Session Code:

Date: June 09

Time: 10:45 AM - 12:00 PM

Room: #237 - LMU

Everyone wants a great job that they enjoy, but few of us know how to take charge of our career. Learn why it's important to raise your profile in today's highly competitive world where there are often more candidates than positions for great jobs. This session will help you build a strong brand that allows you to attract potential employers or clients and start to convince them ahead of time that you are the person they want to hire.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: June 09

Time: 10:45 AM - 12:00 PM

Room: #242 - DesignMind

Many organizations have over- or under-utilized assets in their cloud infrastructure. While running infrastructure in the cloud can yield many benefits in terms of agility and innovation, it can also lead to increased costs. In this session we will walk you through the process of rightsizing, as well as how to take advantage of Reserved Instances once your infrastructure is running efficiently. This session will be beneficial for anyone using AWS, Azure, or both!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Sponsor Session (60 minutes) (60 minutes)

Track:
Cloud Infrastructure (SaaS, PaaS, IaaS, DRaaS)

Level: Beginner

Session Code:

Date: June 09

Time: 12:45 PM - 1:45 PM

Room: #249 - AWS Marketplace

Have you ever had a manager standing over your shoulder, wanting to know why a server is running slowly? Or if a server can handle additional workload? What information would you use to answer these questions? How would you share this information with your manager? If only you had performance metrics from your existing servers to answer these questions. 

In this session, we will be combining three open source tools (Telegraf, InfluxDB, and Grafana) into an inexpensive system that collects performance metrics you can use to troubleshoot and answer important questions about your SQL Server instances, including your SQL Server on Linux instances. We will learn what data to collect, how to use the tools mentioned to collect that data and then we'll put it all together in an interactive dashboard for easy visualization.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Database Administration, Performance Tuning Optimization, and De

Level: Intermedia

Session Code:

Date: June 09

Time: 9:00 AM - 10:15 AM

Room: #235 - Pure Storage

In today’s world reporting and analytics are no longer focused exclusively on internal data from transactional systems and the data warehouse. 
Mashups using data from partners, commercial and public sources are fast becoming the new normal.
Do you have a csv file too big to open, is a non-windows format or generates errors on import or opening?
Need to determine the quality of a file downloaded from the internet or supplied by another party?
In this presentation we will review tools to examine/repair schema issues and explore Power BI Desktop features that provide insights into your datasets along with the M language for building mashups and data models.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Business Intelligence and Analytics Platforms

Level: Beginner

Session Code:

Date: June 09

Time: 3:45 PM - 5:00 PM

Room: #248 - Quest

TBD
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Database and Application Development

Level: Beginner

Session Code:

Date: June 09

Time: 12:45 PM - 2:00 PM

Room: #237 - LMU

When called in to diagnose a performance issue what are the 1st things you review? Many DBAs and developers make the mistake of diving straight into the code looking for an answer. However, often times the solution is not in the code but rather in the overall environment. Environmental troubleshooting is often a quick and overlooked method for discovering and configuring SQL Server to perform at a higher level without the need for application change controls.

In this session we will discuss both performance pitfalls and optimizations that can be made to the system outside of code changes. We will diagnose configurations commonly misapplied and review best practices in SQL Server, Windows Server, and VMware!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Database Administration, Performance Tuning Optimization, and De

Level: Beginner

Session Code:

Date: June 09

Time: 2:00 PM - 3:15 PM

Room: #235 - Pure Storage

Powershell wants to be your friend - your very powerful friend. In this session we will go over some Powershell basics that will help get you started as well as some known "gotchas" when working in Powershell. This is a beginner session - no Powershell experience necessary. WARNING: You may get warm-fuzzies about Powershell by attending this session.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Database Administration, Performance Tuning Optimization, and De

Level: Beginner

Session Code:

Date: June 09

Time: 2:00 PM - 3:15 PM

Room: #234 - Microsoft

A general discussion about storage and how it affects DBA's. We will discuss how to monitor for performance as well. We will also discuss what DBA's need to consider when talking to their storage administrators.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Database Administration, Performance Tuning Optimization, and De

Level: Intermedia

Session Code:

Date: June 09

Time: 10:45 AM - 12:00 PM

Room: #235 - Pure Storage

In a cloudy, virtualized world where we have less physical deployments of SQL Server, those responsible for SQL Server still need to understand basic infrastructure concepts whether you are deploying on Windows Server or Linux. Without them, your VMs and IaaS deployments will not scale, will underperform, and most likely will have poor availability. This session will cover the basics of what you need to know whether you are deploying SQL Server on premises or in the public cloud to go from SQL Server zero to SQL Server hero and be able to have better working relationships with the other administrators in your organization.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Database Administration, Performance Tuning Optimization, and De

Level: Beginner

Session Code:

Date: June 09

Time: 10:45 AM - 12:00 PM

Room: #234 - Microsoft

SQL Server is now available on Linux but you only know Windows, now what? During this session we'll introduce the Linux version of Windows commands you use on a daily basis for administering SQL Server. We'll look at updating Linux, updating SQL Server, moving files between Windows and Linux, and backing up and restoring databases from one system to another. We'll also look at default file locations for SQL Server and what can be moved and how to accomplish that.

NOTE: This is an intro to Linux for Windows users, only brief references to SQL Server on Linux will be made.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Database Administration, Performance Tuning Optimization, and De

Level: Beginner

Session Code:

Date: June 09

Time: 3:45 PM - 5:00 PM

Room: #233 - VMware

This session will discuss the trials and tribulations encountered when shifting from on-premise databases into AWS. We will cover topics such as: permissions, EC2 & RDS setup, Database Migration Services, using Amazon S3 to transfer and restore databases, and cost analysis.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Cloud Infrastructure (SaaS, PaaS, IaaS, DRaaS)

Level: Beginner

Session Code:

Date: June 09

Time: 2:00 PM - 3:15 PM

Room: #249 - AWS Marketplace

Analysis Services have become a major part of upper management daily decision making activities.  However, with our DW sizes reaching multiple terabytes minimizing time required to process our data has become our top priority. In this session, we will cover the options we have as DBA’s to improve the performance of our DW processing time. We will look at features and general best practices available to us within SSAS and the database engine to ensure optimal performance, as well as enterprise level features within the database engine and SSAS available to us and how aligning those to work side by side would yield us significant improvement in our processing time.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Business Intelligence and Analytics Platforms

Level: Intermedia

Session Code:

Date: June 09

Time: 2:00 PM - 3:15 PM

Room: #248 - Quest

One of the most critical areas of any application is Adoption. Power BI is no exception. In this session, I'll speak about some of the strategies, best practices, and experiences to increase adoption
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Business Intelligence and Analytics Platforms

Level: Intermedia

Session Code:

Date: June 09

Time: 10:45 AM - 12:00 PM

Room: #248 - Quest

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