Build Schedule

Advanced Filters:
  • Track

    clear all







  • Speaker


  • Level


  • Session Type

Sessions Found: 29
Head starting to explode from all the technical information you’re absorbing?  Come spend a session with us while we play games with Reporting Services…literally!  Come watch as Stacia Misner and a special guest introduce you to some  word play, all wrapped up in SQL Server Reporting Services.  She'll push the limits with what can be built in SSRS and show you how to have fun while doing it.  Board games and SQL…who could ask for more?
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI 1

Level: Beginner

Session Code:

Date: December 07

Time: 12:00 AM - 1:00 AM

Room: TBD

In this demo-heavy session, we will start by covering an overview of server and database auditing capabilities of SQL Server 2014.  The session will largely focus on the specifics of using the SQL Server 2014 Audit feature, and we will step through a demonstration on configuring, maintaining and troubleshooting SQL Serve 2014r Audit for server and database events. The demo environment will be run on a Windows Azure Virtual Machine running Windows Server 2012 R2 and SQL Server 2014 (CTP 1 or higher).
Speaker:

Session Type:
Regular Session

Track:
DBA 1

Level: Intermedia

Session Code:

Date: December 07

Time: 12:00 AM - 1:00 AM

Room: TBD

Being a specialist means you're really, really good at one thing. Being a generalist means you're good at a a lot of different things. The generalist has an advantage over the specialist because he or she can see and solve problems the specialists can't. In this session I'll cover why it's important to diversify your skill set, not only for career protection, but to be better as a database professional. We'll look at what skill sets to build on to expand your abilities around SQL Server to include the operating system, development, networks, and security. Remember, this saying isn't complete, "Jack of all trades, master of none." The full saying is, "Jack of all trades, master of none, though often times better than master of one."
Speaker:

Session Type:
Regular Session

Track:
Prof. Dev

Level: Beginner

Session Code:

Date: December 07

Time: 12:00 AM - 1:00 AM

Room: TBD

This session is mostly for junior SQL Server developers, Project Managers and Team Leads.

We will talk about how to write good SQL code, how to collaborate in a team and produce perfect documentation.
Speaker:

Session Type:
Regular Session

Track:
Dev

Level: Beginner

Session Code:

Date: December 07

Time: 12:00 AM - 1:00 AM

Room: TBD

Everyone wants a dream job that they enjoy going to each week. However finding that job, and getting yourself hired can be hard for most people. Steve Jones will give you practical tips and suggestions in this session that show you how to better market yourself, how to get the attention of employers, and help improve the chances that the job you want will get offered to you. Learn about networking, blogging, and more.
Speaker:

Session Type:
Regular Session

Track:
Prof. Dev

Level: Beginner

Session Code:

Date: December 07

Time: 12:00 AM - 1:00 AM

Room: TBD

Change Data Capture (CDC) and Change Tracking (CT) have been standard features in SQL Server for a few years now but there's not really that much useful information out in the blogosphere about how they work under the hood. Kevin Hazzard will dig deep into the implementations of CDC and CT in SQL Server 2012, showing you all of the parameters you can use to make these great features serve your organization well. This will be a highly-interactive, highly-entertaining session with lots of questions answered and mysteries revealed.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI 2

Level: Advanced

Session Code:

Date: December 07

Time: 12:00 AM - 1:00 AM

Room: TBD

Throughout my career, I've seen developers do some pretty crazy things to databases (and truth be told, I've done some of these myself!). Come to this 2 part session to learn what we do, why it's bad to the database server... and alternatives that can be used instead. Trust me... your DBA will love you for making these changes.
Speaker:

Session Type:
Regular Session

Track:
Dev

Level: Beginner

Session Code:

Date: December 07

Time: 12:00 AM - 1:00 AM

Room: TBD

In recent years Data Careers have expanded beyond the conventional role of a DBA.  This is due to the ever expanding amount of data, a larger variety of tools and the need for business to use data to drive their own performance goals. This session will provide an overview of Data Careers, a discussion of personal traits and life stages that may align with different Data Careers.  The new Career areas such as Data Science, Analytics and Data Journalism will be reviewed.  In addition, the attendees will be provided with a template that will enable them to make more strategic career-related decisions.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Prof. Dev

Level: Intermedia

Session Code:

Date: December 07

Time: 12:00 AM - 1:00 AM

Room: TBD

Loading a data warehouse can be fraught with data quality issues, data type mismatches, and failed loads. To combat these issues and load your data quickly can be a challenge.  This session will explain step-by-step how to implement an ETL rollback framework to remove any data that was loaded incorrectly.  Based on a real-world implementation, this framework can either automatically or manually load the corrected data, making your life easier.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI 2

Level: Advanced

Session Code:

Date: December 07

Time: 12:00 AM - 1:00 AM

Room: TBD

This session focuses on error handling in SQL Server Integration Services 2012.  Different techniques and strategies will be introduced for error handling in control flow, data flow, and script tasks as well as how to dynamically handle errors.  
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI 2

Level: Advanced

Session Code:

Date: December 07

Time: 12:00 AM - 1:00 AM

Room: TBD

Explore some of the mistakes and misconceptions DBAs tend to have about SSIS.  Also look at the performance and scalability of ETL vs ELT with real world examples and sample code.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI 2

Level: Advanced

Session Code:

Date: December 07

Time: 12:00 AM - 1:00 AM

Room: TBD

Are your SQL Servers Healthy? Are all the SQL Servers you manage, healthy running optimally and has the high availability that is expected? How do you know for sure? Have you checked on the health of your SQL Servers lately? Let's make sure your servers are up to its latest optimizations!

What is a HealthCheck, and how do we perform one? If you are a DBA, then you ought to know! Well Pearl Knows. Robert Pearl talks about the importance of regular health checks of your SQL Server(s). We will talk about the need to create a baseline and provide some time-tested ways to determine if your SQL Servers are healthy and prove it to your managers, clients and heaven forbid, your IT auditors. Using various tools and scripts, you will come out of this session feeling much better :-)
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA 2

Level: Beginner

Session Code:

Date: December 07

Time: 12:00 AM - 1:00 AM

Room: TBD

Another in TheSQLGuru's very popular "Deep Dive" series, this time covering indexing.  You will learn about the internal structures of heaps, clustered indexes and nonclustered indexes.  We will examine included columns and covering indexes, filtered indexes, indexed views, indexing DMVs and finding the right indexes.  There are some incredibly helpful graphics as well as some nice samples to help you transition theory to practice.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Dev

Level: Advanced

Session Code:

Date: December 07

Time: 12:00 AM - 1:00 AM

Room: TBD

One of the most talked about new features in SQL Server 2012 is AlwaysOn Availability Groups. In this session, we will cover the pros and cons of using Availability Groups as well as the basics of how to set them up and take advantage of readable secondary replicas. If you want to improve the availability and performance of your applications & databases, are currently using Database Mirroring, or if you're just curious about Availability Groups, then you won't want to miss this session.
Speaker:

Session Type:
Regular Session

Track:
DBA 2

Level: Intermedia

Session Code:

Date: December 07

Time: 12:00 AM - 1:00 AM

Room: TBD

TEMPDB is just for temporary data right? It is installed by default and gets recreated it time SQL is restarted so what does it matter right? WRONG. This session will give you great insight into what uses TEMPDB, why TEMPDB is important, what are some best practices for configuring TEMPDB, and how to determine if you have contention. If you have systems where TEMPDB hasn't been touched since the install, you need to attend this session. 
Speaker:

Session Type:
Regular Session

Track:
BI 1

Level: Intermedia

Session Code:

Date: December 07

Time: 12:00 AM - 1:00 AM

Room: TBD

When a query is run against a database, a plan is formed to do the work.  This session will serve as an introduction on how to read and interpret execution plans.  We will also take a look at the execution plan that won the 'Hairy' Execution Plan contest on SQLCruise Miami in 2013!  Take a peek at http://sqlcruise.com/winner-of-the-2013-caribbean-landlubber-sql-sentry-hairy-execution-plan/
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Dev

Level: Beginner

Session Code:

Date: December 07

Time: 12:00 AM - 1:00 AM

Room: TBD

Whether predicting customers or All Stars, the process and the tools remain the same.  Microsoft’s Analysis Services Data Mining tools enable you to quickly profile your data, identify hidden relationships and predict future outcomes based on those relationships.   Join me to see what data mining is, what data mining is not and how Microsoft's data mining tools can help you analyze your business.  During this session, I will walk us through a start-to-finish data mining prediction project.  It's easier than you might have thought.
Speaker:

Session Type:
Regular Session

Track:
BI 1

Level: Intermedia

Session Code:

Date: December 07

Time: 12:00 AM - 1:00 AM

Room: TBD

Using SSIS to load data warehouse dimensions is a common task. There are several methods available, but the best method is the one that performs well and is easy to maintain. More importantly, you should be able to automate the development of this common package.

In this session, Sam will provide:

An overview of slowly changing dimensions, Comparison between different patterns that can be used including T-SQL merge, Solutions for the common errors with merge statement, and Scripts and framework to automatically generate merge statements and SSIS packages you can readily use for loading dimensions
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI 1

Level: Intermedia

Session Code:

Date: December 07

Time: 12:00 AM - 1:00 AM

Room: TBD

December 1978: 10 people die in a commercial airliner. Why? Bad troubleshooting skills and poor maintenance – disaster-causing attitudes. As you'll learn in this session, the doomed airliner ran out of fuel while the crew of three wasted time troubleshooting a false alarm. We can draw some parallels in the database world. Poor troubleshooting, disaster-causing attitudes, and a lack of disaster preparedness lead to needless downtime and serious user impact across our environments. 

In this session, we'll look at case studies of real-life aviation disasters and production database downtime incidents. We'll see similarities in attitudes that cause disasters. Come learn about the importance of preparation, troubleshooting, and teamwork. This will be an interactive session where we’ll pick apart disasters, engage in discussion around case studies, and leave prepared to change attitudes in ourselves and our colleagues and avoid disasters at work.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Prof. Dev

Level: Beginner

Session Code:

Date: December 07

Time: 12:00 AM - 1:00 AM

Room: TBD

This topic will cover best practices when optimizing index performance in your DBMS.  This presentation is targeted for mid to senior level DBA’s.  You will learn the optimal strategy for selecting both clustered and non-clustered indexes in your database. Along the way, we will discuss how column and index statistics can affect the performance in your queries. Finally, we will take a look at the benefits and pitfalls of using filtered, full-text search and composite indexes, their best practices, and exceptions to the rules. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA 1

Level: Beginner

Session Code:

Date: December 07

Time: 12:00 AM - 1:00 AM

Room: TBD

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