Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type

Sessions Found: 32
Where do the estimated rowcount values come from? We’ll look inside SQL Server’s distribution statistics to see how they are used to come up with the estimates. We’ll explore some of the new metadata that let you see more details about the statistics and the data changes. We’ll see how and when SQL Server’s distribution statistics are updated and what control you have over the updating of statistics.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Intermedia

Session Code:

Date: July 28

Time: 1:30 PM - 2:30 PM

Room: Alameda

One of the biggest challenges to successful implementation of data encryption has been the back and forth between the application and the database.  You have to overcome the obstacle of the application decrypting the data it needs.  Microsoft tried to simplify this process when it introduced Always Encrypted (AE) into SQL Server 2016 and Azure SQL Database.  In this demo intense session, you will learn about what Always Encrypted is, how it works, and the implications for your environment. By the end you will know how to now easily encrypt columns of data and just as importantly how to unencrypt. You will also learn about the current limitations of the feature and what your options are to work around them.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: July 28

Time: 9:45 AM - 10:45 AM

Room: Attunix (San Francisco)

Discover the ways Azure transforms AI and Predictive Analytics making it easier and more accessible through services like Azure Machine Learning and pre-built Cognitive Services, while also supporting custom development and deep-learning.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code: (Sponsor)

Date: July 28

Time: 12:15 PM - 1:15 PM

Room: Attunix (San Francisco)

It's not a question on whether or not the landscape for the common DBA is changing. Without a doubt, it is.  Azure offers up a new world of possibilities for DBA's and we should all strive to learn it.  In this session we'll cover some basic knowledge and terminology of Azure as well as how easy it is to incorporate Azure into your environment. We will stand up a new Azure virtual machine as well as a setup SQL DB. You will see how easy it is to accomplish this.  This new found knowledge will help propel your career into the new landscape.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: July 28

Time: 8:30 AM - 9:30 AM

Room: San Joaquin

In this session we will investigate what Big Data really means, and more importantly - what it doesn't mean. What makes Big Data different than any other data? What makes Big Data challenges different than the same old challenges we had 30 years ago? Together, we will perform an honest, inquisitive, and enlightening investigation of what Big Data really is, it's origins, and how it evolved over the last decade. We will use history, analytics and logic to dissect the beast, and expose it for what it really is. Why should you care? The Big Data hype is holding you back from doing what is really important with data - getting value out of it. Making sense of it. Vendors, organizations, and architects have become so obsessed with the 'Big Data' fad, and too many either lost sight, or no longer have the resources to pursue their real goals. In this session I will plea to your reasoning, critical thinking, and plain common sense, to wake up and shout with me "The Emperor has no cloths!!!"
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: July 28

Time: 11:00 AM - 12:00 PM

Room: Attunix (San Francisco)

Containers are taking over, changing the way systems are developed and deployed…and that’s NOT hyperbole. Just imagine if you could deploy SQL Server or even your whole application stack in just minutes. You can do that, leveraging containers! In this session, we’ll get your started on your container journey learning container fundamentals in Docker, then look at some common container scenarios and introduce deployment automation with Kubernetes.

In this session we’ll look at
	Container Fundamentals with Docker
	Common Container Scenarios
	Automation with Kubernetes
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: July 28

Time: 4:00 PM - 5:00 PM

Room: San Joaquin

This session is an introduction to the unique functionality offered by COZYROC to create integration packages that dynamically map columns at runtime. The standard SSIS Data Flow Task can only use static metadata which is defined when the package is initially designed. The mapping of columns is configured and remains unchanged until the package is re-opened and design changes are made, thus costing maintenance time and effort. Data Flow Task Plus extends the capabilities of the standard Microsoft Data Flow task in that it allows you to set up dynamic data flows, thus eliminating maintenance time and effort. Changes to tables and columns are automatically incorporated at run time without the need to change and redeploy the package. Columns and fields are mapped automatically at run time. Furthermore, the initial design time and effort may be greatly reduced when dealing with huge amounts of data in a large number of files and/or databases.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code: (Sponsor)

Date: July 28

Time: 12:15 PM - 1:15 PM

Room: CozyRoc (Placer)

CSV files come in a variety of shapes and sizes. If you’ve been working with them for a while, you will know that not all CSV’s are the same. We will cover methods to perform ETL on CSV’s file utilizing T-SQL and PowerShell. The Good- The simple, easy to load structure. The Bad- It looks good in excel, but I’m having difficulty loading it. The Ugly- You want me to load what monthly? That file it too big and it’s structure changes too often.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: July 28

Time: 4:00 PM - 5:00 PM

Room: CozyRoc (Placer)

Ensuring the ongoing protection of personally identifiable information is mandatory in today's business, helping you to guard against data breaches, and comply with the GDPR. In a climate where cyber attacks are all too frequent, and data is spread across a growing number of different environments, the challenge of protecting your data can seem daunting.  This session will address the implications of the GDPR on database management, and demonstrate a privacy-first approach to controlling and protecting data as it changes and moves through your SQL Server estate. As well as offering guidance for assessing your data estate for GDPR readiness, this session will include some great tools and tips for building data protection and privacy into your development processes, and dispel the myth that database DevOps and compliance can't go hand in hand. With the right preparation, you can build compliance into your processes, keep sensitive data safe, and deliver value quickly to your end users.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: July 28

Time: 8:30 AM - 9:30 AM

Room: CozyRoc (Placer)

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 (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: July 28

Time: 2:45 PM - 3:45 PM

Room: CozyRoc (Placer)

Every team’s goal is to deliver business value faster, the question is how do you do that? If you’re a small shop with 1 or 2 developers then writing script in test and then running them production may be okay, but for a larger team that leads to problems. Using continuous integration (CI) and deployment techniques you can make small incremental changes which then set off a chain of automation steps that validates the new code. After automated validation, the code changes are ready for any additional User Acceptance Testing (UAT) and staging environments. During this session, you will learn how to manage database schema changes in a dynamic environment and deliver code to production by utilizing continuous integration and certain development techniques in minutes with minimal risk.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: July 28

Time: 11:00 AM - 12:00 PM

Room: Sacramento

While Azure SQL Database does have built-in safety mechanisms, these are not always well understood. Further, a good architect will ensure redundancy even with an already protected system. This session will show how Azure SQL Database is built and maintained by Microsoft to provide protection for your production information. We’ll also go over methods you can employ to add additional protection to your systems. Moving to the cloud and taking advantage of all that it offers doesn’t mean your data is automatically, fully protected. The knowledge from this session will help to ensure a higher degree of safety, faster recovery, and more up-time for your Azure SQL Databases.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: July 28

Time: 1:30 PM - 2:30 PM

Room: San Joaquin

Dynamic SQL is a scripting language that helps you design flexibility into your code. It allows you to design solutions, pass parameters and allows you build a single query on values passed.  Dynamic SQL has both pros and cons to it's design, but can also be a helpful tool. This presentation will walk through the steps of building dynamic tables, aggregating data in a pivot format and give you the first steps of writing a Dynamic Query.  We will also see how to use Dynamic SQL to build multiple databases across servers, alter a single table in multiple servers and add columns to a table, all through the magic of Dynamic SQL.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: July 28

Time: 1:30 PM - 2:30 PM

Room: CozyRoc (Placer)

Once upon a time, there were 2 SQL Solutions named High Availability and Disaster Recovery. They had a love hate relationship and could never find a common ground. That is, until SQL Server 2012 brought them together in a love story built for the ages. When the dust settled, a beautiful new feature was born. It was called AlwaysON and brought with it new technologies like availability groups, read-only mirrors and listeners. It was a perfect blend of both HA and DR all wrapped up in one bundle of joy. 
SQL Server AlwaysOn provides a high-availability and Disaster-recovery solution for SQL Server 2012. Come see and learn some of the new features associated with it, how they work and why this new feature of SQL Server 2012 is so wonderful.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: July 28

Time: 9:45 AM - 10:45 AM

Room: Alameda

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 (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: July 28

Time: 11:00 AM - 12:00 PM

Room: CozyRoc (Placer)

Are you the only database person at your company? Are you both the DBA and the Developer? Being the only data professional in an environment can seem overwhelming, daunting, and darn near impossible sometimes. However, it can also be extremely rewarding and empowering.  This session will cover how you can keep your sanity, get stuff done, and still love your job. We'll cover how I have survived and thrived being a Lone DBA for 15 years and how you can too.  When you finish this session, you'll know what you can do to make your job easier, where to find help, and how to still be able to advance and enrich your career.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: July 28

Time: 1:30 PM - 2:30 PM

Room: Attunix (San Francisco)

We all love Power BI and its abilities to show data insights through its interface. But Power BI has its limits when it comes to massive data ingestion and near real time dashboards. In this presentation we will evaluate some out of the box solutions to render metrics and KPIs from massive loads that extrapolates Power BI limits.

You will learn:

•	Power BI limits for accommodate data refresh and streaming datasets
•	Develop strategies for continuous and discrete data capturing for Power BI 
•	Azure services options for near real time dashboards Power BI
•	SQL Server features to source discrete dataset for Power BI
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: July 28

Time: 1:30 PM - 2:30 PM

Room: Sacramento

We will have an introduction to ETL, ETL software landscape and Microsoft SQL Server Integration Services a.k.a. SSIS in greater details. We will also discuss what's new in SSIS 2016. For the hands-on section, we will create a simple SSIS package and test-drive some selected features, like Balance Data Distributor, Control parts, and Expression Task.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Information Delivery

Level: Beginner

Session Code:

Date: July 28

Time: 11:00 AM - 12:00 PM

Room: Alameda

Join Glenn Burnett, Dan Hess, Saru Radhakrishnan and Alex Purice for four 15-minute presentations!

1. Glenn Burnett: SQL Server Audit Quick-Start!

2. Dan Hess: A good look at SQL Operations Studio: How to manage SQL Server across multiple platforms (Windows, macOS and Linux).

3. Saru Radhakrishnan: A quick overview of migrating on-prem SQL Server environments to the Microsoft Azure cloud platform. An easy-to-understand presentation of various approaches to guide the migration!

4. Alex Purice: Temporal Tables Overview!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: July 28

Time: 4:00 PM - 5:00 PM

Room: Alameda

Lift and shift is an utopia many IT professionals have about moving on-prem resources to the cloud. The truth is we must understand how the cloud works so we adjust, design accordingly and deliver to expectations. As SQL DBAs we have options. We can choose between IaaS or PaaS, between SQL in a VM or SQL DB, NoSQL options, Azure Data Warehouse some more. In this session we will dive into these options and understand some key points on the platform through some demos. 

You will learn: 
•	Basic elements of Azure cloud ecosystem 
•	VM disks specifics for SQL 2016/2017 
•	Azure SQL Database and Elastic pools 
•	Azure Data Warehouse and Cosmos DB
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: July 28

Time: 4:00 PM - 5:00 PM

Room: Sacramento

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