Build Schedule

Advanced Filters:
  • Track

    clear all









  • Speaker


  • Level


  • Session Type

Sessions Found: 38
We have all come across those great developers in our careers. They seem to fall into the right answer and make it look so easy to deliver great quality software so quickly. The true is though it is not an innate ability but the application of many deliberate practices. Practices that help to avoid distraction, staying blocked to long, break down problems, and many others. In many years of developing software in teams I have realized that we can learn new practices from just about everyone. In this talk we will look at the 7 most important practices I have found and adopted. This talk with have a technical tilt and some code, but will have value for anyone working with developers. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (70 minutes) (70 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: October 10

Time: 11:20 AM - 12:30 PM

Room: S316

When Chief Brody first sees the shark in Jaws, he carefully backs away from the stern of the Orca and quietly, but certainly, tells Quint, “You’re gonna need a bigger boat.” That one line, combined with a terrific delivery by Roy Sheider, packs a great deal of contextual information into six words.

Making efficient use of space to convey meaning is a vital part of good Data Visualization.

In this session, we will discuss the fundamentals of human visual perception, including the important distinction between Pre-Attentive and Attentive Processing. We will use examples from feature films like Jaws, Alien, and Sneakers to show important aspects of visual analysis around Color, Form, Position, and Motion. We will then put these concepts into practice via demos in Excel and Power BI. By the end of this session, you will have a solid understanding of the importance of data visualization and how to use it to enable better decisions.
Speaker:

Session Type:
Regular Session (70 minutes) (70 minutes)

Track:
BI Data Presentation & Visualization

Level: Beginner

Session Code:

Date: October 10

Time: 10:00 AM - 11:10 AM

Room: L235

Window functions and the OVER() clause are an underused feature in T-SQL. These functions can help you solve complex business problems such as running totals and ranking. If you have never used these functions or are looking to solve ranking and aggregate types of calculations without using GROUP BY, join us for a demo filled session on SQL window functions. We will also look at some of the performance implications of using these functions.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (70 minutes) (70 minutes)

Track:
Database Development & Tuning

Level: Beginner

Session Code:

Date: October 10

Time: 8:40 AM - 9:50 AM

Room: L238

This session is designed to be useful to two different audiences:
1.Those implementing Ola Hallengren’s Maintenance Solution for the first time
2.Those that have been using it for awhile, but might have a hole in their DR plan – what to restore when a resource goes offline

We will do an overview of the maintenance solution to start, then get down and dirty quickly with the guts of the extension. What I am presenting is a custom extension that works out of the box for those of you that have created jobs using the maintenance solution. The scripts will add an additional job step to all DatabaseBackup jobs which will output a text file that contains the most current restore scripts for each database in the instance.
Speaker:

Session Type:
Regular Session (70 minutes) (70 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: October 10

Time: 10:00 AM - 11:10 AM

Room: S316

Your boss comes up to you and asks you why the system is slow, unless you know how your system is supposed to respond you are stuck scrambling to answer those questions. With a few free quires and some SSIS magic you can capture a Baseline of your systems. With this you will be able to know exactly where to look and what might be amiss. Before you can say what is wrong with your system you need to know how it reacts under normal circumstances. This session will provide the tools you need to start collection of your systems baselines and give you a great deal of information.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (70 minutes) (70 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 10

Time: 1:35 PM - 2:45 PM

Room: S316

The role of data and IT professionals is evolving from simply responding to requests about business to one of helping shape the business strategy. The integration of these professionals into the strategy process is a transformation that presents communication challenges and requires more visibility by people typically known to be introverts. In this session we will discuss some of the barriers causing relationship pains as well as some techniques and strategies to begin building stronger relationships with the managers and end users so data can thrive and customer satisfaction can proliferate.
Speaker:

Session Type:
Regular Session (70 minutes) (70 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: October 10

Time: 8:40 AM - 9:50 AM

Room: S301

The content is purposefully casual and based around EPL Fantasy Football and sports metrics (for the English premier League). We will explore the use of great new tools such as Power Query, Power Pivot, and subsequently Power BI in order to create the perfect fantasy football team. 

Power BI does not just have to be for the Corporate world. John and Jane should be loving this too.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (70 minutes) (70 minutes)

Track:
BI Data Presentation & Visualization

Level: Intermedia

Session Code:

Date: October 10

Time: 3:25 PM - 4:35 PM

Room: S302

Want to off load some of that reporting workload, make an emergency rollback during a production upgrade faster, or make managing your test databases easier?  If any of these appeal to you, then you should be familiar with database snapshots within SQL Server.  Available since SQL Server 2005, use of this feature can make your life a lot easier.We'll spend the first part of this session taking an in depth look at how database snapshots work. We’ll look at what exactly is happening behind the scenes when you create a snapshot and when you query a snapshot.  Once we've covered the basics, we'll spend the rest of our time analyzing and discussing a number of real world use cases where snapshots can be very beneficial and save you a great deal of time.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (70 minutes) (70 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: October 10

Time: 8:40 AM - 9:50 AM

Room: S421

Deadlocks can be very tricky, unpredictable and generally nasty. Is all hope lost? This demo-intensive session will explore several types of deadlocks and give you some insight into how to track them down and prevent them. We wil start with a quick review of locking and blocking concepts, then take a deep-dive into deadlock demos.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (70 minutes) (70 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 10

Time: 3:25 PM - 4:35 PM

Room: L238

Dimensional modeling is one of cornerstones of successful business intelligence (BI) initiatives. Even with new technologies such as PowerPivot and SQL Server Analysis Services (SSAS) 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 can also help to ensure that your data warehouse or data mart is responsive and can accommodate emerging requirements.

This session dives deeper into the art of dimensional modeling. We look at how and when to create different types of fact and dimension tables, including patterns for enriching dimensional data, creating usable hierarchies for efficient navigation, and tracking historical changes. After 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 this interactive and engaging session.
Speaker:

Session Type:
Regular Session (70 minutes) (70 minutes)

Track:
BI Architecture, Development & Administration

Level: Beginner

Session Code:

Date: October 10

Time: 1:35 PM - 2:45 PM

Room: L235

Effective reporting is not simply the output of data, but the meaningful presentation of that data in a manner that informs the user. SQL Server Reporting Services provides a myriad of features to create a clear, instructive, and interactive experience. This session will demonstrate techniques to utilize SSRS advanced authoring features to facilitate more informative communication. These features include: nesting data regions, leveraging scope, geographic/geometric reporting, complex charting, rich formatting, incorporating managed code assemblies, intuitive drilldown, data from multiple datasets in a single data region, datasets that update source data, and more.
Speaker:

Session Type:
Regular Session (70 minutes) (70 minutes)

Track:
BI Data Presentation & Visualization

Level: Advanced

Session Code:

Date: October 10

Time: 11:20 AM - 12:30 PM

Room: L238

Are you new to Hadoop?  In this beginner-friendly technical session you'll learn about  the Hortonworks Data Platform (HDP) and Microsoft HDInsight from the ground up with a focus on what SQL Server professionals like yourself need to know.  

We will go into technical detail about what HDFS, MapReduce and YARN/Tez actually are & how they work. Then you'll discover the Hadoop ecosystem and the myriad of projects within. We'll see how Hadoop complements the traditional relational database world, and discuss real-world data tasks/use cases that Hadoop can accomplish. 
Speaker:

Session Type:
Regular Session (70 minutes) (70 minutes)

Track:
BI Architecture, Development & Administration

Level: Beginner

Session Code:

Date: October 10

Time: 8:40 AM - 9:50 AM

Room: L235

After spending the last decade or so completely devoted to the Microsoft stack, I spent the last year supporting the SQL Server instance for a team of Java developers. Yes, sure, Java is just another language so there aren't really and issues that are absolutely unique to the Java world. I did find, however, that there were cultural differences which made my biggest challenges different from what I was used to dealing with in the .Net world. Come hear about my misadventures with JBoss, server side cursors, and NOCOUNT settings.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (70 minutes) (70 minutes)

Track:
Database Development & Tuning

Level: Intermedia

Session Code:

Date: October 10

Time: 11:20 AM - 12:30 PM

Room: S302

I know I should be archiving some of this data.  My boss wants me to archive some of this data.  But the database is so complicated.  It has so many foreign keys. There are so many level of hierarchy.  When could I ever schedule an outage or how can I do this without impacting production.  It’s so risky.  What if I mess up?  

Learn how to design and implement a “Database Archiving Strategy” in a graceful, almost unnoticed manner I call “Stealth Mode”. The method is this. Reverse engineer your database so you know the hierarchy levels of your database.  Determine the sequence order in which tables must  be archive. Use transaction code, include simple double checks. Use indexed temp tables to minimize impact on other tables and to increase performance and speed.  Archive in very small batches that run in 1 to 5 seconds, repeat many times during the lowest activity part of the night.  Never drop and reapply foreign keys.  Minimize locking and blocking and yield to more important tasks.
Speaker:

Session Type:
Regular Session (70 minutes) (70 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: October 10

Time: 1:35 PM - 2:45 PM

Room: S301

Do you ever hear about a database hack and think “Wow, whoever pulled this off must be some super-smart hacker type with access to advanced technology and supercomputers?” Well in reality nothing could be further from the truth. Database hacks are accomplished with a combination of readily available tools, a dash of readily available know-how, a large helping of blind luck, and a heaping helping of laziness on the part of the folks who are responsible for securing their systems. It's so easy even I can do it!

In this presentation I will teach you how to hack a database so you can defend your systems against the hackers who want to get at your assets. 
Speaker:

Session Type:
Regular Session (70 minutes) (70 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: October 10

Time: 11:20 AM - 12:30 PM

Room: S301

This is a introductory session on how a DBA and developers can use Execution plans to find performance bottlenecks. This will cover the fundamentals and cover some of the basic techniques that can be used to find hidden performance problems.  This session is intended for individuals who don't have a great deal of experience working with execution plans or someone who just wants a learn more about the basics.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (70 minutes) (70 minutes)

Track:
Database Development & Tuning

Level: Beginner

Session Code:

Date: October 10

Time: 10:00 AM - 11:10 AM

Room: S301

Without temporal tables (AKA history tables), we can only see the current version of data. We can’t see rows that have been deleted or rows as they existed before the latest update. The temporal table support in SQL Server 2016 gives us the ability to create system maintained “history” tables to track all changes to the table data.

In this session, we’ll discuss why you may need temporal support in your tables, how to implement temporal support without a true period data type (since SQL Server doesn’t yet have one), and how to query such a table using the new FOR SYSTEM_TIME clause in a SELECT statement. We will also discuss and demonstrate bi-temporal design, where both system time and application time are supported.
Speaker:

Session Type:
Regular Session (70 minutes) (70 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 10

Time: 8:40 AM - 9:50 AM

Room: S302

One of a DBA's primary responsibilities is managing the performance of a SQL Server environment. When performance problems arise, DBAs need to have the correct tools in place to be able to dig in and discover the issues that are occurring. Although it's one of the newer tools in the DBA toolbox, Extended Events is one of the most powerful tools available. In this session, we will discuss performance management responsibilities for DBAs and provide a foundation, through Extended Events, to understand and resolve performance issues.
Speaker:

Session Type:
Regular Session (70 minutes) (70 minutes)

Track:
Database Development & Tuning

Level: Intermedia

Session Code:

Date: October 10

Time: 10:00 AM - 11:10 AM

Room: S127

AlwaysOn is SQL Server 2012/2014’s High Availability solution. It provides a new standard for mission critical databases and end-to-end business intelligence at a lower total cost of ownership. It provides the required 9S of availability without the total cost and complexity. In this session, we’ll specifically explore high availability databases – Availability Groups. AG is a new feature that enhances and combines database mirroring and log shipping. We’ll demonstrate the setup and failover of multiple databases simultaneously. 
Speaker:

Session Type:
Regular Session (70 minutes) (70 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 10

Time: 10:00 AM - 11:10 AM

Room: L238

Is your brain mush from too much technical content, but you just need a break before the next session? Come share your IT war stories with the group and laugh for an hour. This open panel session is guaranteed to at least get a chuckle as we all relax and share our experiences.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (70 minutes) (70 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: October 10

Time: 3:25 PM - 4:35 PM

Room: S127

Sessions Found: 38
Back to Top