Build Schedule

Advanced Filters:
  • Track

    clear all










  • Speaker


  • Level


  • Session Type

Sessions Found: 49
The 2012 release of SQL Server promise a variety of delicious new language features to solve problems. After this session, you'll have a taste for all the sweets they've packed into the language including conversions, date & time functions, windowing functions, analytic functions and sequences.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 214

Level: Intermedia

Session Code:

Date: April 26

Time: 12:00 AM - 1:00 AM

Room: TBD

Sometimes the hardest performance issues in your environment have simple solutions. One of these simple solutions is through properly indexing the database. In this session, we’ll look at five ways that performance of a database can be improved through indexing. When we finish, you’ll be armed with scripts and methodologies that you can put into place today to improve database performance.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 217

Level: Intermedia

Session Code:

Date: April 26

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:
Room 219

Level: Beginner

Session Code:

Date: April 26

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 with Database Performance Analyzer (formerly Confio Ignite). 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:
Room 219

Level: Beginner

Session Code:

Date: April 26

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:
Room 215

Level: Intermedia

Session Code:

Date: April 26

Time: 12:00 AM - 1:00 AM

Room: TBD

As businesses' data needs keep growing so do the sizes of the databases we are entrusted to manage. Faced with constant growth and the scale of multiple Terabytes, more DBA's are facing the challenges to properly tune and maintain the VLDB's in their environment. 

In this session we will go into the best practices, tips and tricks learned from helping customers in the field with this common growing pain. We will cover the best way to do integrity checks, stats updates, index maintenance, partitioned tables and more so you can to tame your Very Large Databases and keep them running in top shape.
Speaker:

Session Type:
Regular Session

Track:
Room 214

Level: Intermedia

Session Code:

Date: April 26

Time: 12:00 AM - 1:00 AM

Room: TBD

These days, I've stopped counting how many times I've been approached to help implement feature X because a customer thinks/was told it provides 24x7 for a DB/instance. These decisions often lead to more downtime and less uptme if the technology choice was not right or cannot be administered by the current staff. The secret sauce is not what gets implemented but understanding everything behind the scenes that influences the final architecture based on your actual requirements. It’s less about technology and more about understanding what it will take to keep your business going even when things seems like they are crumbling down around you. This session will cover how to approach achieving business continuity with the right amount of uptime.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 216

Level: Beginner

Session Code:

Date: April 26

Time: 12:00 AM - 1:00 AM

Room: TBD

You have geospatial data and you know that plotting it on a map will deliver insights. Or maybe you keep hearing “geospatial” as a current BI buzzword and you want to be informed about your options when you get to it. The Microsoft BI stack provides several options for visualizing location data. But how do you know which tool will best serve your purpose, or what factors are important in making this decision? We’ll identify factors to consider when choosing a tool to visualize your data in maps such as system requirements, availability and type of location data, required level of technical understanding, and more. You’ll leave the session confident in your ability to choose the best tool within Excel and SQL Server.
Speaker:

Session Type:
Regular Session

Track:
Room 218

Level: Intermedia

Session Code:

Date: April 26

Time: 12:00 AM - 1:00 AM

Room: TBD

Is there a great difference in the brain chemistry of someone fleeing a hungry mountain lion and someone presenting to a group of colleagues in a corporate board room? The answer is: NO. Over the past decade, a lot has been learned about the chemistry of the brain and why humans react the way we do to events in our environment. The concept of EQ (Emotional Intelligence) is a compelling and growing concept that applies this knowledge in a set of learnable, improvable skills for leading human beings. While EQ is often applied to corporate leadership, the parallels to presenting are fantastic. This session will explain the basics of EQ and demonstrate how you can apply it to make your presentations better in the following areas: * Crafting better slide decks * Preparing yourself for presenting * Delivering your content * Dealing with the unexpected Understanding and practicing the concepts of EQ can make your presentations a better experience for everyone in the room--including you.
Speaker:

Session Type:
Regular Session

Track:
Room 116

Level: Beginner

Session Code:

Date: April 26

Time: 12:00 AM - 1:00 AM

Room: TBD

In 2007, Microsoft introduced Data Dude for Visual Studio 2005 to help bring the processes, controls and tools for code management to Database Development that Application developers had been enjoying for ages.  It had its problems, but it mostly worked and was a welcome step in the right direction. Many versions later we have SQL Server Data Tools for Visual Studio 2013 (and 2012 and 2010...). A more mature product that finally brings database development up to par with traditional application development and has many features data geeks, like ourselves, will truly love. This talk will provide an overview of SSDT’s features and show you how to get started using it to save time, implement better code controls and be a better DBA or database developer.
Speaker:

Session Type:
Regular Session

Track:
Room 218

Level: Beginner

Session Code:

Date: April 26

Time: 12:00 AM - 1:00 AM

Room: TBD

Learn about Database Unit Testing, how it can add value to your projects, and how to do It with Microsoft Visual Studio. Brian will be speaking about the fundamentals of what database unit testing is and the Microsoft Visual Studio Tools for implementing database unit test projects. This talk is intended for audiences who are new to database unit testing and want to learn the basics behind using Visual Studio to perform automated database unit tests.
Speaker:

Session Type:
Regular Session

Track:
Room 116

Level: Beginner

Session Code:

Date: April 26

Time: 12:00 AM - 1:00 AM

Room: TBD

Database corruption is simply a fact of a DBA's life - if you haven't seen it yet, you will. Success or failure depends on having a solid plan to deal with different types of corruption.  In this session, we will discuss usage of related DBCC commands, monitoring for corruption with SQL Agent Alerts and Jobs, and when to restore versus repair. After attending this session, you will be able to check for corruption, identify different types of corruption, and take the appropriate measures for dealing with it. 
Speaker:

Session Type:
Regular Session

Track:
Room 214

Level: Beginner

Session Code:

Date: April 26

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:
Room 214

Level: Intermedia

Session Code:

Date: April 26

Time: 12:00 AM - 1:00 AM

Room: TBD

Sometimes half the battle in computing is just to see what's happening. We will take a visual tour of physical database storage structures, using live demos with the freeware application SQL Server File Layout Viewer and our old friends the DBCC commands as guides. See what happens in a data file when you convert a table from a heap to a clustered index! See fragmentation and the havoc wrought by Shrink! Marvel at the behavior of multiple files and filegroups! Index Rebuilds! Eureka!
Speaker:

Session Type:
Regular Session

Track:
Room 217

Level: Intermedia

Session Code:

Date: April 26

Time: 12:00 AM - 1:00 AM

Room: TBD

Ever encounter a table consisting only of BIGINT, CHAR(255), and NVARCHAR(MAX) columns?  Did your gut tell you that this is bad, but you had difficulty explaining why?  Did you know that these Datatype Choices can be a real performance killer?  Attend this session, learn how database records are stored within SQL Server, and why all data types are not created equal.  Armed with that knowledge, we will then explore several performance scenarios that may be impacting your systems right now!  When you leave, you should be able to explain why datatype choices matter to your colleagues, assess your own systems, and implement some best practices to mitigate these performance killers.
Speaker:

Session Type:
Regular Session

Track:
Room 219

Level: Intermedia

Session Code:

Date: April 26

Time: 12:00 AM - 1:00 AM

Room: TBD

The Microsoft SQL Server stack provides an excellent set of tools for storing, visualizing, and analyzing data, but sometimes we want to do more. In this session, we’ll take a look at the open-source statistical software R and how we can use it to connect to SQL Server, analyze data, and put the results of our analysis back into SQL Server for later use. We’ll look at examples of analyses performed by a fictional company as they segment their customers, forecast their sales, and examine interesting relationships among their product offerings. Along the way, we’ll see what some of these analyses would take if done in SQL Server itself and why R is so effective when paired with SQL Server.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 215

Level: Beginner

Session Code:

Date: April 26

Time: 12:00 AM - 1:00 AM

Room: TBD

Are you a jack of all trades?  Have you been writing application code AND designing databases?  Are you spending lots of time altering your tables knowing there has just got to be a better way?  This beginner session will take a tour through common pitfalls in database designs, discuss the repercussions of lacking standards, prove out consistency issues and help you keep your applications fast and flexible.  A properly designed database should perform at the highest levels and not require a gargantuan effort to adapt to routine application growth.
Speaker:

Session Type:
Regular Session

Track:
Room 218

Level: Beginner

Session Code:

Date: April 26

Time: 12:00 AM - 1:00 AM

Room: TBD

If you are working with Windows Azure SQL Database (WASD) then you know that the way to scale large data sets is to use federations. If you were using SSIS to move data into a federated database you know how challenging this can be. This year Microsoft released a new SSIS component that handles a lot of the federated headache. I'll give the steps you need to set up federations in your WASD database and how to use SSIS to fill the tables with data. 
Speaker:

Session Type:
Regular Session

Track:
Room 219

Level: Intermedia

Session Code:

Date: April 26

Time: 12:00 AM - 1:00 AM

Room: TBD

Optimal configuration of he I/O subsystem is critical and can ultimately be responsible for the response times of your applications.  In this session we analyze the different options that  you have for your IO subsystem, what are their pros and cons, what tools are available to baseline the performance of  the hardware that you will use for SQL Server and what numbers are important to you.
Speaker:

Session Type:
Regular Session

Track:
Room 117

Level: Intermedia

Session Code:

Date: April 26

Time: 12:00 AM - 1:00 AM

Room: TBD

We DBA´s know how important it is to collect performance data. In this session, I will show to you how to properly use the native Get-Counter PowerShell cmdlet to get all information you need from your servers. It has never been as easy to collect performance counter data and save it to a CSV file or a SQL Server table for baselining and later analysis. You may be thinking "But I don’t know nothing about PowerShell and explicitly using .NET classes in my code". Don’t worry; you don’t need to know this to collect counters. Although this is a 100-level session, you’ll be producing 400-level results and your scripts will scale as the number of servers increase, because we’ll use asynchronous collection and processing. And better yet, we’ll schedule all of it. All this using native PowerShell cmdlets and a minimal amount of script code.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 215

Level: Beginner

Session Code:

Date: April 26

Time: 12:00 AM - 1:00 AM

Room: TBD

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