Build Schedule

Advanced Filters:
  • Track

    clear all







  • Speaker


  • Level


  • Session Type


Sessions Found: 33
Corruption can strike at any time. As DBAs how we alert, investigate, and respond can have profound impact on our company. In this session we will learn how to detect and respond to various types of corruption.
First we will be focus on ways to detect corruption early. This will include understanding tools available to us like DBCC CheckDB as well as the importance of testing your backups. We’ll look at some sample scripts to automate corruption checks and common alerts we should have set up on our instances.

Then we will move onto how to respond to some common example of corruption through live demos.  We’ll look at how we can analyze the situation safely as well as point out various pitfalls that trip people up. We’ll also discuss when and how we may be able to fix corruption vs restoring the database.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: July 15

Time: 11:00 AM - 12:00 PM

Room: Alameda

"As is commonly the case, all good things come to an end.  And now is as good a time as any for the use of SQL Trace and Profiler to come to an end.  Let’s face it, Trace was a good tool and had some wonderful uses.  Profiler for that matter was a good tool and was useful at times.
It is time to let those old tools retire gracefully and move into the world of XE.  This full day workshop will provide you the means to let Profiler and Trace be retired from your toolset as you discover all that XE has to offer.

This full day session on Extended Events will help prepare you to put this tool to immediate use as you walk back to your daily duties.  This workshop will teach you about Extended Events starting with the basics and moving through how to create XE sessions that will get the right data for you, while doing so with minimal impact.

You will be exposed to advanced troubleshooting techniques as we work through complex issues that are made easier through the use of XE.  Take advantage
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: July 15

Time: 2:45 PM - 3:45 PM

Room: Zerto (San Francisco)

Choosing where to store your data is far more difficult than ever. We can be paralyzed with choice! This session seeks to ease that anxiety and provide direction for application developers and DBAs. You'll learn the differences between DocumentDB, Azure Table Storage, Azure Blob Storage, Azure SQL Database, Azure SQL in a VM, Azure SQL Data Warehouse, Azure Data Lake Analytics, Azure Data Lake Store, and more. See demos and review case studies so you'll have a complete view of how data is stored in Azure and how to choose between these great tools.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: July 15

Time: 9:45 AM - 10:45 AM

Room: VMware (Placer)

Ever feel like there are just too many layers with SQL Server? You peel off a layer and behold there is yet another layer. SQL Server is rather complex. The complexities can be rather frustrating from time to time. 

Join this NSFW (not safe for whining) session as we strip SQL down to the bare bones. I will help you undress the complexities of a few of the basic SQL Server concepts. These concepts will include locks, principals, query directives and deadlocks.

In this session I will disrobe misunderstandings related to the aforementioned topics. I will show the different types of principals in SQL Server. I will also show various scenarios involving locks and deadlocks along with some of their effects with and without query directives. The goal is to better understand these topics and to hopefully stop using and perpetuating common mis-uses of terminology and common misconceptions about the technology.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: July 15

Time: 11:00 AM - 12:00 PM

Room: VMware (Placer)

Your business or organization likely has Key Performance Indicators (KPIs) to measure business performance, A KPI data warehouse solution can help you collect KPI data, store it over time, and support analytics.  You executives and management will appreciate Analytics and Reports that rollup and present KPIs.  During this session, you will see an overview of a Key Performance Indicator data warehouse architecture successfully deployed at a large California state agency.  You will learns some ways to bring parts, or all, of it into your organization to expand your Business Intelligence and Analytics offerings.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code:

Date: July 15

Time: 1:30 PM - 2:30 PM

Room: Zerto (San Francisco)

This session will review common challenges encountered when preparing new data sets for use in analytics and reporting. We will look at tools for exploring and modifying large CSV/TXT files and discuss design patterns for cleaning and repair.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: July 15

Time: 2:45 PM - 3:45 PM

Room: Alameda

Do you have trouble remembering common administrative T-SQL commands? Remember when you created a cheat sheet in school to help you study for an exam?  Use that same principle with the DBA Cheat Sheet! The DBA Cheat Sheet is a document filled with some basic administrative TSQL commands you’ll need in your daily work. During the session I’ll show you a few SSMS tricks and review some of the topics in the DBA Cheat Sheet document.  You’ll leave the session with a document that you can use as a reference every day.  This is geared for developers or Junior DBAs.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: July 15

Time: 8:30 AM - 9:30 AM

Room: Alameda

Are you looking for a high availability solution for your business critical application? You're heard about AlwaysOn Availability Groups and they seem like a good solution, but you don't know where to start. It all starts with a solid design. In this session we introduce the core concepts needed to design a Availability Group based system. Covering topics such as recovery objectives, replica placement, failover requirements, synchronization models, quorum, backup and recovery and monitoring. This session is modeled after real world client engagements conducted by Centino Systems that have lead to many successful Availability Groups based systems supporting tier 1 business critical applications.
Speaker:

Session Type:
Extended Session (90 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: July 15

Time: 8:30 AM - 10:00 AM

Room: VMware (Placer)

In this session, we'll show the power of this Azure MPP solution.  T-SQL is a great data language that makes parallelism easy.  C# is a fantastic statically typed language that taps into the power of the .NET framework, but parallelism has a big barrier to entry.  Learn how U-SQL combines the best of both worlds to clean and analyze data at incredible levels.  Azure Data Lake Analytics makes Hadoop affordable and easy by leveraging your existing knowledge of T-SQL and C#.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: July 15

Time: 2:45 PM - 3:45 PM

Room: Sacramento

This 500 level session will focus on using undocumented statements and trace flags to get insight into how the query optimizer works and show you which operations it performs during query optimization. I will use these undocumented features to explain what the query optimizer does from the moment a query is submitted to SQL Server until an execution plan is generated including operations like parsing, binding, simplification, trivial plan, and full optimization. Concepts like transformation rules, the memo structure, how the query optimizer generates possible alternative execution plans, and how the best alternative is chosen based on those costs will be explained as well.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Advanced

Session Code:

Date: July 15

Time: 4:00 PM - 5:00 PM

Room: VMware (Placer)

Self-promotion is often confused with bragging, but most of the time it is the best tool to advance your career. In this session we talk about how self-promoting is the first step to creating your brand. Many IT Professionals struggle with how to stand out in a room, be noticed in a pile of resumes or maneuver for promotions. By learning to network and communicate effectively, these hurdles are converted into advancement ladders.  Self-Promotion and Networking are skills and therefore can be taught and learned. We will discuss ways to use social media, communities and other avenues to increase your brands visibility online. Equally important is your ability to interact with co-workers, clients and management face to face.  We will discuss ways to meet and network with other individuals and give you the tools to stand out from your peers.  Building and engaging with a large network will increase your worth to both your current and future employer.  Transform into a Networking Master.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: July 15

Time: 8:30 AM - 9:30 AM

Room: Zerto (San Francisco)

This session focuses on Microsoft’s BI technologies and its abilities to make advanced easy to use, accessible, insightful, and actionable decisions, all while helping clients increase organizational performance. With the recent release of SQL Server, Microsoft dramatically enhanced the Microsoft BI platform. During this session you will explore the improvements to SQL Server reporting services and Power BI to show you how to create a blended value from your BI platform.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: July 15

Time: 4:00 PM - 5:00 PM

Room: San Joaquin

Hybrid Data and Analytics via a SQL Server 2017 & Azure-Controlled Drone

Using SQL Server 2017, we will control a drone via NodeJS.  With the help of Python and ML we will then make the drone fly in the "Safe Zone". 

Join me in a presentation on how to create your Azure environment for data and analytics using the first ever drone controlled by SQL Server 2017. 

- creating a template to make proofs of concept possible
- real world situations and lessons learned in Azure
- consumption of that data through Power BI

This presentation will include creation of a hybrid solution for operational analytics both on-prem and cloud using Azure SQL Database in-memory and temporal tables to create the ultimate data and analytics experience.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: July 15

Time: 8:30 AM - 9:30 AM

Room: Sacramento

SQLPS has been evolving since 2012 and the SQL Provider/cmdlets have been around since 2008. Have you taken advantage of the PowerShell infrastructure that is on your servers? This session takes you behind the scenes of the SQLPS and the new SqlServer module that is installed with the tools. We will cover how to get it without the tools, how to use it once you have it and why you will want to use it for simple tasks or complex ones. When you learn how to navigate SQL Server and all its services using Paths, you won't go back. Join me for a fun filled hour and learn how to keep SQLPS from becoming frustrating and a black box. You will be glad you did. Let's continue the journey to becoming a PowerShell DBA.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: July 15

Time: 9:45 AM - 10:45 AM

Room: San Joaquin

In this session, I will walk you through every steps to set up SQL Server Availability Group. After a brief introduction to the basic components of Availability Group (AG), We will set up a primary AG with 2 secondary. This session will be mostly demo with opportunity to ask questions. Come and learn how to set up AG.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: July 15

Time: 9:45 AM - 10:45 AM

Room: Zerto (San Francisco)

Head in the "cloud"? Looking for a "cloud" with a silver lining? There are many clichés that can be used when talking about "cloud" technology but really, how does Microsoft's "cloud" offering, called Azure, actually work? Let's take a look at some basics and maybe even take a dive into the deep end. We'll look at terminology ("subscriptions", "Infrastructure as a service", "resource manager" etc.), how to create various resources (virtual machines, databases, virtual networks etc.) and maybe even log into a "cloud" database. I'll present a solid foundation that will enable you to get comfortable with the technology and allow you to expand your "cloud" skills.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: July 15

Time: 1:30 PM - 2:30 PM

Room: Sacramento

The DBATools PowerShell module is the premiere open source PowerShell project designed to automate, and encourage best practices.  In this talk we will walk through setting up the module and review examples from the 180 commandlets available.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: July 15

Time: 2:45 PM - 3:45 PM

Room: VMware (Placer)

Glenn Burnett: Destroyer of Databases.  How I accidentally overwrote multiple production databases, and how you can avoid doing the same.

Caroline Ward: It's amazing how a Massive Open Online Course (MOOC) can jumpstart your learning!  MOOC tips and recommendations, and the best learning advice I have picked up from a MOOC!

Dilip Nayak: Lessons learned in hiring short-term DBA contractors.  Do your expectations match the services you're purchasing?

Robert Muir: How your database design can impact performance, what to watch out for when using Entity Framework queries, and tips for sharing this information with application and database developers.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: July 15

Time: 4:00 PM - 5:00 PM

Room: Zerto (San Francisco)

SQL Server and PowerShell are now available on Linux and management wants you to leverage this shift in technology to more effectively manage your systems, but you’re a Windows admin!  Don’t fear! It’s just an operating system! It has all the same components Windows has and in this session we’ll show you that. We will look at the Linux operating system architecture and show you how to interact with and manage Linux system. By the end of this session you’ll be ready to go back to the office and get started working with Linux with a fundamental understanding of how it works.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: July 15

Time: 1:30 PM - 2:30 PM

Room: San Joaquin

SQL Server Always On Availability Groups are all the craze. When you have a need to failover or modify a configuration there are some things that you can only do with PowerShell. Aside from these items, PowerShell can completely manage an AG. Join me for a demo filled session where we will create an Always On Availability Group from scratch to management with PowerShell, including the Windows Server Failover Cluster. From changing parameters to failover, we will have a blast using PowerShell with ease of use to make your life better. Let’s work smarter and not harder when managing this great feature of SQL Server.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: July 15

Time: 11:00 AM - 12:00 PM

Room: Zerto (San Francisco)

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