Build Schedule

Advanced Filters:
  • Track

    clear all







  • Speaker


  • Level


  • Session Type

Sessions Found: 29
Does your data sit around mocking your best attempts to support good data practices?  Databases are also bound by the GIGO rule: Garbage In is Garbage Out.  In this presentation, Karen shows you examples of the types of mistakes, misunderstandings and outright cheats that lead to poor data quality, mistrust in IT systems and overall smelliness in our IT solutions.  Using real-life evidence of her own data in your systems.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: May 11

Time: 12:00 AM - 1:00 AM

Room: TBD

As a SQL Server DBA I see my role having 2 main focuses. First is to protect the data and second is to ensure performance is maximized. More often than not companies forget about data security when they focus on performance tuning. In this presentation I will mention a few cases where encryption could have saved a lot of hassle. I will then demo a method that can be used to "index" commonly searched on encrypted values (ex: SSNs, Credit Card, etc) helping reduce the impact on the performance of a query.
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: May 11

Time: 12:00 AM - 1:00 AM

Room: TBD

XEvents were introduced with SQL Server 2008 and enhanced in SQL Server 2012 and with the announcement that SQL Trace/Profiler is being deprecated now is the time to begin learningXEvents.  We will look at why you should start working with Extended Events, when you should start, and how to start.  What you will learn:

1.  How to investigate XEvents objects using the DMV's
2.  How to create an XEvents Session
3.  How to transition an existing Trace to an XEvents Session.

What you should know coming in:

1.  Basic use of SSMS  
2.  Familiarity with Trace/Profiler
Speaker:

Session Type:
Regular Session

Track:
Track 4

Level: Beginner

Session Code:

Date: May 11

Time: 12:00 AM - 1:00 AM

Room: TBD

Becoming certified in SQL Server is a great career enhancement for a database professional.  This session will provide you with an overview of the SQL Server Certification program, including the numerous changes made to the program for SQL 2012.  You'll discover several reasons why you should become certified, and some of the best ways in which to do so.  You'll also leave the session armed with some tips and tricks for passing the exams that the presenter has used over the last twelve years.
Speaker:

Session Type:
Regular Session

Track:
Track 6

Level: Beginner

Session Code:

Date: May 11

Time: 12:00 AM - 1:00 AM

Room: TBD

We are going to examine a variety of oopsies MANY developers fall prey too - some obvious, some pretty subtle and some down right sneaky! Lots of code examples with the bad AND good code presented. I GUARANTEE that you will find things here that will either prevent you from getting bad data, throwing unwanted errors or vastly improving your database application's performance.  I have given this talk over FORTY times now and it is always very highly rated!
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: May 11

Time: 12:00 AM - 1:00 AM

Room: TBD

You've fallen into a job that requires you to manage a SQL Server Database Management System. Now you have to keep these databases on their feet. You've heard of this concept called a backup, and it sounds great, but you sure don't know what it is. This session is for you. We're going to go over backups, right from the beginning, so that when you come out of this session you can go back to your systems and set up backups, log backups, differentials, and anything else you might need. Further, you'll know how to recover your database in the event of an actual failure. The fundamentals you need to get a good backup in place and then be able to restore it will be covered in this session.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 6

Level: Beginner

Session Code:

Date: May 11

Time: 12:00 AM - 1:00 AM

Room: TBD

A highly interactive and popular session where attendees evaluate the options and best practices of common and advanced design issues, such as: * Natural vs. Surrogate keys * Classwords and other Naming Standards * Varchar Minimums *Identity Crisis * Who Calls the Shots and Who Does What? ...and others. Bring your votes, your debates, and your opinions.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: May 11

Time: 12:00 AM - 1:00 AM

Room: TBD

In today's economic times, we are being asked to do more with less. Less budget, less hardware and yet our data needs keep growing! So how do we keep our database infrastructure humming along given these restrictions? In this session we will talk about different options of consolidation including: database-level consolidation, instance-level consolidation, and virtualization. Additionally we will also talk about some of the tools and methods you can use today to help you consolidate your SQL Server environment and do more with less!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 6

Level: Beginner

Session Code:

Date: May 11

Time: 12:00 AM - 1:00 AM

Room: TBD

More and more companies are virtualizing with VMWare, and databases are the next logical step. This presentation will explore the fundamentals of monitoring databases running in a VMWare environment because it can be much different than when running on a physical machine. You will learn business and technical benefits of virtualization, master new terms and concepts, pick up useful planning tips and tricks, and cover best practices for maintaining optimum performance in a VMWare environment. 
Speaker:

Session Type:
Regular Session

Track:
Track 6

Level: Intermedia

Session Code:

Date: May 11

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server Extended Events can be used to gather a wide range of performance information, and in troubleshooting in SQL Server.  Extended Events use less system resources and provide better information than SQL Profiler and they allow for correlation of SQL Server event data along side of OS or Application event data. This presentation will explore what Extended Events are, how to set them up and use them in several case studies.

Speaker:

Session Type:
Regular Session

Track:
Track 5

Level: Beginner

Session Code:

Date: May 11

Time: 12:00 AM - 1:00 AM

Room: TBD

Full-text search is an often overlooked feature of SQL Server that can be used for more than searching documents. This session will cover setting up and using full-text search to handle some of those dirty data situations we've all inherited without using the dreaded "LIKE '%text%'". As an example, we will demonstrate how full-text search can be used to find names in poorly formatted data like 'mailing address' or 'billing address' fields. It will also cover how to handle noise words that may match some names and synonyms for first names to create a really robust solution that goes beyond what could be done with plain old SQL.
Speaker:

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: May 11

Time: 12:00 AM - 1:00 AM

Room: TBD

Mike Hillwig is known as the Cranky DBA. You probably have pain points in your environment that make you cranky, too. Mike has lots of horror stories to tell about bad SQL Server implementations and practices. More importantly, he has developed a list of 12 key tips for managing your SQL Server environment. By following these tips, you’ll make your DBAs, developers, and system administrators a little less cranky.
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: May 11

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session we will review some example code of ways I use PowerShell to help me as a DBA.  Together we will learn how PowerShell can be the "Super Glue" that can be used to solve some of your problems.
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: May 11

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:
Track 5

Level: Advanced

Session Code:

Date: May 11

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will give a brief overview of the different types of triggers available in SQL Server (DDL & DML) and then go into more detail on how and when to use DML triggers. This session will cover misconceptions about how triggers work, when triggers should and shouldn't be used (we will discuss options), common mistakes, and how to fix the most common mistakes. After attending this session a person will: 1. Identify different types of triggers and when to use them. 2. Be able to identify when a trigger is the right solution 3. Be able to write triggers that perform well 
Speaker:

Session Type:
Regular Session

Track:
Track 4

Level: Beginner

Session Code:

Date: May 11

Time: 12:00 AM - 1:00 AM

Room: TBD

You’re just starting out as a DBA, but you’ve just been given a tight deadline to install and configure a new SQL Server 2012 instance.  In this session you’ll learn process of installing an instance of SQL Server 2012 so that you have the knowledge to confidently perform the install (and get it right the first time).   You’ll also learn some of the out-of-the box SQL Server settings that need to be tweaked to ensure performance and resilience.
Speaker:

Session Type:
Regular Session

Track:
Track 6

Level: Beginner

Session Code:

Date: May 11

Time: 12:00 AM - 1:00 AM

Room: TBD

What are cubes? What is all this talk about BI? Why is it important, anyway? If you have asked these questions recently, then this session is for you. We'll discuss the fundamentals of designing a Data Warehouse and building a Cube as well as When and Where you would need them.
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: May 11

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will investigate some of the tables and views of the reporting services database in SQL Server 2008 & 2008 R2.  We will then go on to demonstrate how to build a long term reporting repository for tracking report performance, report use, and subscription results.  Finally we will review a few reports that can be built from this data to make the whole process a bit easier.
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: May 11

Time: 12:00 AM - 1:00 AM

Room: TBD

Dynamic Management Views are a beautiful gift from Microsoft.  With them you can gather immense amounts of information about your SQL environment, optimize performance problems, and solve problems you didn't even know you had!
We will dig into some of the most useful DMVs available and review some real-world code examples that illustrate what they can do for you.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: May 11

Time: 12:00 AM - 1:00 AM

Room: TBD

We will be learning an overview of this powerful feature and how you can leverage it to help manage your existing SQL environment. This will include plenty of demos, best practices and Q&A so by the end you should be able to walk away ready to take control of your SQL Server environment using this awesome feature!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 5

Level: Beginner

Session Code:

Date: May 11

Time: 12:00 AM - 1:00 AM

Room: TBD

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