Build Schedule

Advanced Filters:
  • Track

    clear all






  • Speaker


  • Level


  • Session Type

Sessions Found: 32
You're a new DBA, want to be a DBA or you've been declared an "Accidental DBA" and the phone rings.  Someone tells you that they believe SQL Server is having a performance issue, what now?  Their query or stored procedure took a very long time to run.  Can you help them?  Do you even know where to begin to help them?  Most sessions I've attended on performance tuning seem to start in the middle.  They take the approach that the audience has some understanding on how or where to start.  In this session we'll cover how to handle performance tuning from the very beginning, when the user says "The database is slow".  
Speaker:

Session Type:
Regular Session

Track:
Track 1 - DBA

Level: Beginner

Session Code:

Date: June 21

Time: 12:00 AM - 1:00 AM

Room: TBD

Have you ever felt like an extra in Office Space? You've got the skills. You've got the big brain. You feel like you have a higher calling, but those other guys get picked instead. What's the deal?

In this session, you'll learn how to promote yourself, how to speak confidently, how to build your personal brand, how to demonstrate value, and how to interview.
Speaker:

Session Type:
Regular Session

Track:
Track 4 - Dev

Level: Beginner

Session Code:

Date: June 21

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server query tuning is often more art than science and it can quickly eat up a lot of DBA and/or Developer time. This presentation will outline a method for determining the best approach for tuning queries by utilizing response time analysis. Regardless of the complexity of the statement, this quick, systematic approach will lead you down the correct tuning path.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2 - Adv.DBA

Level: Beginner

Session Code:

Date: June 21

Time: 12:00 AM - 1:00 AM

Room: TBD

The easiest part of any deployment is running the deployment script on production. But what have you done to prepare that script for production? Was the script tested? Is the script tightly coupled with the application code? The difference between a successful deployment and a failed or problematic deployment is all the preparation work you've done to ensure that you're deploying the right script, the right way to your production environment. This session will explore best practices that you can implement to ensure that your deployments are as successful as they can be.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1 - DBA

Level: Intermedia

Session Code:

Date: June 21

Time: 12:00 AM - 1:00 AM

Room: TBD

You always have more report requests than you can possibly fulfill. Wouldn't it be great if you could speed up the generation of reports? Templates can streamline the life cycle of a report for the whole team. In this session, you'll learn how templates in your tool belt can help you efficiently gather requirements, quickly design mock-ups, and standardize the look and feel of your SSRS reports. 
Reports don't stop changing once they're released into production, and some reports are phased out over time. Wouldn't it be great to have a way to keep track of the changes a report takes on in production over time? We'll talk about how to keep track of change requests, how to analyze the utilization of existing reports, and how to track changes in users for the reports in production.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3 - BI

Level: Beginner

Session Code:

Date: June 21

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

Level: Beginner

Session Code:

Date: June 21

Time: 12:00 AM - 1:00 AM

Room: TBD

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 about formatting T-SQL for readability and why top down design is not the best solution for writing T-SQL. You’ll learn why implicit conversions slow queries down and how to leverage simple techniques for minimizing the performance impact of explicit conversions. 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

Track:
Track 4 - Dev

Level: Beginner

Session Code:

Date: June 21

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server 2012 introduced columnstore indexing but with one major drawback -- columnstore indexes were not updateable.  Thus, adopting them to improve data warehousing (or other) query patterns took careful planning and quite a bit of management.  SQL Server 2014 introduces clustered columnstore indexes that are now fully updateable!  During this session, we'll take a look at how clustered columnstore indexes work, what implications exist for using them, and how the update process is handled.  We'll also take a look at what management and maintenance operations are required to keep clustered columnstore indexes performing optimally.  Anyone with a large data warehouse environment (or even an OLTP or ODS database with very large tables) will definitely want to attend!  
Speaker:

Session Type:
Regular Session

Track:
Track 3 - BI

Level: Advanced

Session Code:

Date: June 21

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 session to learn what we do (from opening up the database to SQL Injection attacks, how SQL can use Referential Integrity to optimze queries, and the pitfalls of using NOLOCK), why it's bad to the database server (or your career)... and alternatives that can be used instead. Trust me... your DBA will love you for making these changes.
Speaker:

Session Type:
Regular Session

Track:
Track 1 - DBA

Level: Beginner

Session Code:

Date: June 21

Time: 12:00 AM - 1:00 AM

Room: TBD

During this session, learn features which integrate SQL Server to the Cloud and also learn about Relational Data Services in the Cloud
Speaker:

Session Type:
Regular Session

Track:
Track 3 - BI

Level: Beginner

Session Code:

Date: June 21

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session I will give an overview of how to design a database, including the common normal forms and why they should matter to you if you are creating or modifying SQL Server databases. Data should be easy to work with in SQL Server if the database has been organized as close as possible to the standards of normalization that have been proven for many years. Many common T-SQL programming "difficulties" are the result of struggling against the way data should be structured and can be avoided by applying the basic normalization techniques and are obvious things that you find yourself struggling with time and again (i.e. using the SUBSTRING function in a WHERE clause meaning you can't use an index efficiently).
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 4 - Dev

Level: Beginner

Session Code:

Date: June 21

Time: 12:00 AM - 1:00 AM

Room: TBD

Do you back up your databases? If the answer is yes (and I really hope it is), do you test your restores? If a table gets dropped at 1:53PM, can you restore the database to 1:52PM using log backups? Can you use the WITH STANDBY parm to apply log backups to a read-only copy of a database?

For the answers to these questions and a whole lot more about database restores, plus some nifty scripts, join me for this presentation.
Speaker:

Session Type:
Regular Session

Track:
Track 2 - Adv.DBA

Level: Intermedia

Session Code:

Date: June 21

Time: 12:00 AM - 1:00 AM

Room: TBD

You've got your data, but accessing it means using one application among dozens, which can be difficult for once-in-a-while users. Alternatively, you can make the data to SharePoint where it can be easily searched, related, and even (securely) exposed for integration via the SharePoint native OData, REST, and WCF interfaces.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 4 - Dev

Level: Beginner

Session Code:

Date: June 21

Time: 12:00 AM - 1:00 AM

Room: TBD

Are you frequently frustrated by managers and other non-technical business leaders that just don’t seem to get it?  Do they frequently glaze over when you try to explain a great new business opportunity or efficiency improvement that you just know will enhance the bottom line?  In this session we will explore some strategies and techniques for engaging decision makers in terms that they understand.  Improving communications with decision makers and crystallizing their buy-in will enhance your value to the organization and give your career significant lift
Speaker:

Session Type:
Regular Session

Track:
Track 3 - BI

Level: Beginner

Session Code:

Date: June 21

Time: 12:00 AM - 1:00 AM

Room: TBD

Triggers are extremely powerful and useful (if somewhat rarely needed) objects that are coded very similar to a common stored procedure. Yet for their similarity, there are some very important differences that need to be understood. In this session, I will walk through what goes into writing a robust DML trigger, starting with a simple version of a trigger, and working through some very useful applications of DML Triggers..
Speaker:

Session Type:
Regular Session

Track:
Track 1 - DBA

Level: Intermedia

Session Code:

Date: June 21

Time: 12:00 AM - 1:00 AM

Room: TBD

Without the transaction log, SQL Server would have no way of maintaining a consistent and durable view of its data.  It would be pandaemonium!!!  Think of the Stay-Puft Marshmallow Man!  

Thankfully the transaction log is there and we can all breathe easier.
In this session, you will learn how SQL Server uses the transaction log to maintain the durability and consistency of its data, along with methods for reading the transaction log and identifying active transactions.
Speaker:

Session Type:
Regular Session

Track:
Track 2 - Adv.DBA

Level: Intermedia

Session Code:

Date: June 21

Time: 12:00 AM - 1:00 AM

Room: TBD

What are FileTables?  How do they work?  What are their limitations?  These questions and more will be answered in this demo filled presentation.  We will walkthrough the configuration and implementation of this feature.  We will show you some use cases on how this functionality can help you manage your data in whatever forms it exists.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 5 - Misc.

Level: Intermedia

Session Code:

Date: June 21

Time: 12:00 AM - 1:00 AM

Room: TBD

The geography data type allows for pinpoint accuracy of locations (0-D), routes (1-D), areas (2-D), and isometric power maps (3-D). SQL 2014 has broken through to the time.  barrier (4-D). Watch your data change over time, and even export it into movie format with an appropriate soundtrack. Turn your data into a compelling story in geospace, the final frontier.

Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3 - BI

Level: Beginner

Session Code:

Date: June 21

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2 - Adv.DBA

Level: Intermedia

Session Code:

Date: June 21

Time: 12:00 AM - 1:00 AM

Room: TBD

Ever been in a meeting that drones on and on? It starts late, runs long, and doesn’t really accomplish anything. It’s a complete waste of everyone’s time. Worse yet, since nothing was resolved you’ll have to have a follow up meeting. Argh! In this session you’ll learn some of the keys to conducting an effective meeting. You’ll gain practical tips for making your meetings more productive and dramatically improving one of the most inefficient parts of your day. You’ll also learn how to make the meetings that you attend more effective by subtly influencing the meeting organizer
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 5 - Misc.

Level: Beginner

Session Code:

Date: June 21

Time: 12:00 AM - 1:00 AM

Room: TBD

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