Build Schedule

Advanced Filters:
  • Track

    clear all








  • Speaker


  • Level


  • Session Type




Sessions Found: 34
AWS Command Line and Working with RDS
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: July 23

Time: 2:45 PM - 3:45 PM

Room: Dell

TSQL is a necessity when interacting with SQL Server so knowing can be half the battle. Performance is always good as the database starts to grow, but building in resilience when you begin is a greater advantage than refactoring. I will go over 5 key things to know when you write TSQL, use DataTypes and/or variables in comparisons and you will also learn about the procedure cache and how to avoid pitfalls there. This is a beginners session but the concepts in this session are a great foundation to begin with. If you are looking for a solid foundation to build on and need the basics to start, this session is definitely for you.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: July 23

Time: 9:45 AM - 10:45 AM

Room: Microsoft

Are you tired of creating and updating the same SSIS packages again and again? Is your wrist hurting from all that clicking, dragging, dropping, connecting and aligning? Do you want to take the next step and really speed up your SSIS development?

Say goodbye to repetitive work and hello to Biml, the markup language for Business Intelligence projects.

In this session we will look at the basics of Biml. First learn how to use Biml to generate SSIS packages from database metadata. Then see how you can reuse code to implement changes in multiple SSIS packages and projects with just a few clicks. Finally, we will create an example project that you can download and start with to speed up your SSIS development from day one.

Stop wasting your valuable time on doing the same things over and over and over again, and see how you can complete in a day what once took more than a week!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: July 23

Time: 11:00 AM - 12:00 PM

Room: Dell

This session is designed to teach DBAs and developers the best strategy to transfer large data. 

We will first analyze how data gets accessed from the source and how data gets updated or inserted to the target server: index access patterns in read operation and minimal logging in wring operation. I will introduce TF610 and cover its benefit for minimal logging even in full recovery mode. 
Speaker:

Session Type:
Extended Session (90 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: July 23

Time: 8:30 AM - 10:00 AM

Room: Dell

Do you dread handing your t-SQL over for code review? Do your queries run slower than you expect? Does the DBA always want to tweak your t-SQL? In this demo heavy session, we’ll take a look at various ways to improve your t-SQL. You’ll learn why top down design is not always the best pattern as well as why implicit conversions can slow down your queries. You’ll learn how to rewrite most cursors as well as finding out how user defined functions affect performance. You’ll learn some simple ways to troubleshoot these types of issues using execution plans and extended events. Finally we’ll take a look at how standards can help quicken turnaround time when refactoring t-SQL. By changing some of your t-SQL writing habits you can improve performance of queries from the very beginning.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: July 23

Time: 2:45 PM - 3:45 PM

Room: Microsoft

Standardizing essential performance health check is the key in responding quickly to production issues and can cut down initial evaluation phase to 1/3rd of the time, whether you have been requested to do health check or you may want to run these due to an alert. These sets of essential checks can be the first major checkpoint for a DBA, they can look quickly on consolidated email stats first to decide if any further action is required to fix an issue or is it feasible to jump into in-depth troubleshooting. This will cut down on time and effort while responding to Production issues.

First part of the email shares some key observations about SQL Server performance which can be the key to quick resolution of the issue. Rest of the email shows different set of stats regarding CPU/Disk IO/Disk Space/Memory/Network/Blocking and database performance which could lead to the slowness observed in the application. This consolidated email can be shared with technical stakeholders to give a snaps
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: July 23

Time: 9:45 AM - 10:45 AM

Room: Tintri

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:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: July 23

Time: 11:00 AM - 12:00 PM

Room: San Joaquin

Grab your lunch and join Trent Mera of Dell Software in the Dell room for an informative presentation while you eat!

Trent will show you to get real-time notification and rapid diagnoses of your SQL Server performance problems using Dell Software’s Spotlight on SQL Server. Spotlight on SQL Server gives real-time alerts and brings together all of your critical SQL Server metrics onto a single dashboard-type screen, color-coded for problem severity and clickable for drilling down to the details and root causes of problems.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Sponsored Lunch Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: July 23

Time: 12:15 PM - 1:15 PM

Room: Dell

Dimensional modeling is one of cornerstones of successful Business Intelligence initiatives. Even with new technologies like PowerPivot and Analysis Services Tabular models, you need to represent your organization’s data in a way that is accessible for end users and IT staff alike. An effective dimensional model will also ensure that your data warehouse or data mart will be responsive and capable of accommodating emerging requirements.
In this session, we will dive deeper into the art of dimensional modeling. We will look at how and when to create the different types of fact and dimension tables, Including patterns for enriching dimensional data, creating usable hierarchies for efficient navigation, and tracking historical changes. After attending this session you will be able to confidently assess the quality of your organization’s dimensional model and recommend and implement changes. Bring your toughest quandaries to help make this an interactive and engaging session.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: July 23

Time: 2:45 PM - 3:45 PM

Room: San Mateo

Whether you are an Excel Pro, BI Developer, or Data Architect, sooner or later you're going to find it helpful to know a little DAX and a few DAX Patterns. DAX, the Data Analysis Expression Language is the future of insight development in tools such as: Excel, Analysis Services Tabular, and the Power BI Desktop. Using DAX and these DAX Patterns, you'll be able to define both centralized and ad hoc metrics for blazing fast data analysis!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: July 23

Time: 2:45 PM - 3:45 PM

Room: San Joaquin

Data Science is the gaining popularity but what does it really mean? 
Discovering useful patterns and insight in the enterprise has become more challenging without a new set of tools. Big data has taken center stage in the data warehouse community and with data sets so large and complex that traditional data processing applications are becoming inadequate. Learn about the R language that is at the center of most advanced analytics conversations. R is an open source statistical language that is rapidly gaining popularity due to a robust set of machine learning functionality and a never-ending set of R packages that are used to increase functionality of the core R language.
In this session, we will introduce the R language and review some of the features of the highly interactive environment that are available with just the base install. We will also review some of the upcoming features in the SQL Server 2016.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: July 23

Time: 8:30 AM - 9:30 AM

Room: San Mateo

Is your Biml solution starting to remind you of a bowl of tangled spaghetti code? Good! That means you are solving real problems while saving a lot of time. The next step is to make sure that your solution does not grow too complex and confusing - you do not want to waste all that saved time on future maintenance!

Attend this session for an overview of Biml best practices and coding techniques. Learn how to centralize and reuse code with include files and the CallBimlScript method. Make your code easier to read and write by utilizing LINQ (Language-Integrated Queries). Share code between files by using Annotations and ObjectTags. And finally, if standard Biml is not enough to solve your problems, you can create your own C# helper classes and extension methods to implement custom logic.

Start improving your code today and level up your Biml in no time!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: July 23

Time: 11:00 AM - 12:00 PM

Room: Dell

When you are a lead Database Administrator, you can almost be guaranteed that your boss will not know more about databases then you do.  

It will be your job to explain to your boss (customers, clients, etc.) what it takes to operate and maintain a well-running database environment.  You have to justify why there is work and spending necessary for *reactive* support and maintenance.  No organization can stand still, so you will also need to demonstrate the need for *proactive* work: research, training and planning for new architecture.  By doing so, you can demonstrate the value you are adding as a Lead DBA.

In this session, you will see some frameworks and templates for explaining your responsibilities to your boss.   Get some ideas reporting your workload in business terms, and presenting your database environment and concepts to non-technical audiences.  
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Intermedia

Session Code:

Date: July 23

Time: 11:00 AM - 12:00 PM

Room: Microsoft

You have heard a lot about NOSQL databases. In this session you will learn about MongoDB database from a SQL Server DBA's perspective. Come see the commonalities and differences between the two.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: July 23

Time: 1:30 PM - 2:30 PM

Room: San Mateo

Do reports in your organization consist mostly of giant tables of data? Perhaps you have gotten as far as adding KPI indicators or conditional highlighting to the tables. Maybe you have charts, but they are hideous and distracting. Although tables of data presented as reports are commonly found in many organizations, they may be doing you and your users a disservice. We'll discuss why cognitive psychological studies tell us that graphs and pictures are more effective at communicating trends and comparisons and how to prepare to create good data visualizations. Then we'll explore how to employ purposeful data viz designs to help users achieve their goal of making informed decisions, using a fun and useful Power BI dashboard. You'll leave with guidance on how to take boring or unreadable tables of data and turn them into useful and visually appealing reports. 
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: July 23

Time: 11:00 AM - 12:00 PM

Room: San Mateo

In this session, you will learn how to setup and implement Central Management Server (CMS) to run queries against multiple SQL servers in your environment. Mitch will also cover Policy Based Management (PBM) and how to use out of the box best practices and create custom policies to maintain your environment. He will then look at using both CMS and PBM in conjunction with each other to monitor your environment.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: July 23

Time: 9:45 AM - 10:45 AM

Room: San Mateo

Do you have tables and indexes that have grown really large? Are you moving around a lot more data than you used to? Are your windows for jobs and maintenance getting tighter? If you answered yes to any of these questions, partitioning may be for you!

With partitioning, you can break a table or index down into smaller more manageable chunks. It can help you perform maintenance on just part of a table or index. You can even move data in and out of tables with quick and easy metadata only operations. We’ll go over basic partitioning concepts such as horizontal vs. vertical partitioning, and techniques like partitioned views and full blown table partitioning. We’ll  also look at how partitioning affects things under the hood. Finally you'll see some cool demos/tricks around index maintenance and data movement. At the end of this session you’ll have a firm understanding of how partitioning works and know how to make decisions on how and when to implement.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: July 23

Time: 8:30 AM - 9:30 AM

Room: San Joaquin

Have you deployed Availability Groups in your data center? Are you monitoring your Availability Groups to ensure you can meet your recovery objectives? If you haven’t this is the session for you. We will discuss the importance of monitoring and trending Availability Group Replication, how AGs move data between replicas and the impact replication latency can have on the availability of your systems. We’ll also give you the tools and techniques to go back to the office and get started monitoring and trending right away!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: July 23

Time: 8:30 AM - 9:30 AM

Room: Microsoft

This session will cover real world functions that are used for real DBA work. There will be a few slides but mostly demos with actual scripts to help you do your job. I will also introduce some outside modules created to assist as well. Things like Reading/Changing the following: Permissions, DB Owner maintenance and database space management. We all could use a few standard things in our DBA world of ever changing roles and "I have to have it now" stuff, that Management Studio can get in the way of getting it done faster. Join me for a fun PowerShell hour and never try to reuse a click again. 
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: July 23

Time: 1:30 PM - 2:30 PM

Room: Tintri

Power BI Desktop is the new self-service entry in the Microsoft BI development landscape but what does it offer the professional BI developer?
This session will explore Power BI Desktop features for data accusation and manipulation, sample some of the visualization provided and review the deployment options. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: July 23

Time: 4:00 PM - 5:00 PM

Room: Microsoft

Sessions Found: 34
Back to Top