Build Schedule

Advanced Filters:
  • Track

    clear all







  • Speaker


  • Level


  • Session Type

Sessions Found: 30
The 2012 release of SQL Server introduces 14 new functions for developers. This list includes functions for conversion, date/time calculation, enhanced logic, and string manipulation. In this session we’ll cover the ins and outs of these new functions, making you a better T-SQL developer.
Speaker:

Session Type:
Regular Session

Track:
Room AB310

Level: Intermedia

Session Code:

Date: October 06

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will provide an introduction to Master Data. We will discuss what Master Data is and discuss Master Data Management. Master Data Management is the process of migrating data into a single source so that the information to be shared by multiple systems and applications in the organization.  Merging data into this single source we can remove duplicates and improve data quality.
Speaker:

Session Type:
Regular Session

Track:
Room AB308

Level: Beginner

Session Code:

Date: October 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Perfmon is a standard windows monitoring tool available on every windows deployment.  It can provide a wealth of information about the activities within your system.  We will cover the basics in this session which include how to setup/schedule perfmon to capture data as well as some basics around initial analysis.  This session will have a strong component of demos.
Speaker:

Session Type:
Regular Session

Track:
Room AB316

Level: Beginner

Session Code:

Date: October 06

Time: 12:00 AM - 1:00 AM

Room: TBD

You know what your query does, but do you know how it does it?  Do you know what type of resources your query uses?  Come to this session to find the answers to these questions and more as we walk through reading execution plans.  We will see how SQL breaks down the execution of your query and what each step tells us about the overall query.  If you are newer to Microsoft SQL or you just don’t feel totally comfortable with reading execution plans, this session is for you.
Speaker:

Session Type:
Regular Session

Track:
Room AB309

Level: Beginner

Session Code:

Date: October 06

Time: 12:00 AM - 1:00 AM

Room: TBD

With the release of SSAS 2012 Microsoft has introduced a new BI storage engine. In addition to the traditional OLAP engine you now have the option to build your BI models on top of the new Vertipaq engine (This is the same engine used by PowerPivot.) To use the new xVelocity engine you build a Tabular data model.  A new query language DAX (Data Analysis Expressions) is used to create calculations, measures, and KPI’s. DAX is similar to the expression language used in excel and it should be easier to use than MDX and appeal to a broader audience.
This session is designed to introduce you to the process of building a tabular model in SQL Server Data Tools (BIDS rebranded).
Speaker:

Session Type:
Regular Session

Track:
Room AB308

Level: Beginner

Session Code:

Date: October 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Topic will provide a more in depth look into query execution plans and is targeted for junior to senior DBA’s. You will learn how to identify what indexes are being used by the SQL optimizer, different type of index operations are performed by SQL server and what operations are generally considered as a preferred method of data retrieval. We will discuss how to determine if indexes used by the optimizer are the optimal ones and the exceptions to the rules.   Finally we will discuss the relationship between different types of index operation and different types of join types within SQL Server including how the SQL Optimizer determines which join type it will use and pros and cons of each type.  
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room AB309

Level: Beginner

Session Code:

Date: October 06

Time: 12:00 AM - 1:00 AM

Room: TBD

“No one knows what I do.” That’s a chief complaint of data professionals everywhere, and it’s a dangerous position to be in as well. Reviews may not be favorable, promotions more uncommon, and training dollars more rare. But by practicing written and verbal communication, new opportunities may present themselves. Blogging can land a book deal. In-house team lunch-and-learns can lead to community presentations. Most of all, good communication can be the skill that saves your job or opens the door to new horizons.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room AB309

Level: Beginner

Session Code:

Date: October 06

Time: 12:00 AM - 1:00 AM

Room: TBD

This is an expanded and updated version of the session I presented at the SQL Rally in Orlando. We will cover Tactical Data Governance and in detail specific code examples, using Stock and Custom SSIS Transforms ,Data Models, SSAS Cubes used to create and populate a Metadata Mart as defined by Michael Belcher(Gartner). We  will demonstrate incorporating complete custom Data Profiling capabilities (SSIS Transform Scripting, TSQL) capable of Profiling any Source and Targeting any destination. In addition we will implement Data Quality(Address Correction, Fuzzy Matching) and Visualization via PowerPivot , Excel and QlikView. Last will will demonstrate code generation.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room AB308

Level: Intermedia

Session Code:

Date: October 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Data center migrations are all the rage these days and the SQL Server DBA is one of the most important accessories. When an organization decides to change data centers, of all the very important servers that will be migrated, the ones with the company data will be the most watched. Like other projects, a good plan followed by good execution is required. In this session you’ll learn about the research, design, planning, process, and execution to migrate SQL Servers from one DC to another. I’ll go over lessons learned, whether to go it alone or brings in help, discuss pros and cons of migration techniques, big decisions like keeping the same server names, when to and not to virtualize, downtime considerations, data sync, and more.
Speaker:

Session Type:
Regular Session

Track:
Room AB310

Level: Beginner

Session Code:

Date: October 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Installing SQL Server is easy, right? You just insert the install media, click Next a bunch of times, and you'll have a working database server in just a few minutes. At least that's what many of our non-DBA colleagues think. Not so fast, says veteran DBA Mike Hillwig. SQL Server has lots of default settings that can be potential performance killers, and we'll look at a bunch of them. These include things like where data files live, data file growth, basic security settings, and the services being installed. And while we're at it, we'll look at a bunch of the good defaults and talk about why they shouldn't be touched. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room AB314

Level: Beginner

Session Code:

Date: October 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Many of our customers are either virtualizing databases or planning to do so soon. We hear from many groups that attempted running their database on VMware but went back to physical hardware because of performance issues. There are many reasons this may have happened, but quite often the decision to go back to physical was not based on hard facts. This presentation will explore the fundamentals of monitoring databases running in a VMware environment. If you are using classic O/S monitoring tools, you may be getting misleading data. Understand what metrics are important and how to get to that data.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room AB308

Level: Intermedia

Session Code:

Date: October 06

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room AB309

Level: Intermedia

Session Code:

Date: October 06

Time: 12:00 AM - 1:00 AM

Room: TBD

In the SQL Server tool box there is a great tool called SQL Server Report Services. With five different interfaces, Report Services can be a bit challenging to setup and configure. Our focus will include setup, configuration, and deployment. When you walk away from this session, you will understand terms like BIDS, SSRS, Report Builder, and Crescent. Also, as part of this session we will cover the differences between SQL 2008 R2 and SQL 2012. If you are looking for steps to start developing your repertoire of SQL Server Report Services, this is definitely a session to attend! 


Speaker:

Session Type:
Regular Session

Track:
Room AB316

Level: Beginner

Session Code:

Date: October 06

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room AB316

Level: Beginner

Session Code:

Date: October 06

Time: 12:00 AM - 1:00 AM

Room: TBD

I will share some stories, discuss the Power of PowerShell and provide some example scipts.
Speaker:

Session Type:
Regular Session

Track:
Room AB314

Level: Beginner

Session Code:

Date: October 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Data Quality Services (DQS) has been introduced as part of the Microsoft SQL Server 2012 stack. In this session, we will take a first look at DQS and how it can transform the way we enable and set data quality standards to ensure clean data.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room AB316

Level: Beginner

Session Code:

Date: October 06

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session, we'll cover the basics of setting up SQL Server Service Broker from the ground up with lots of demos. We'll discuss some pros and cons to using Service Broker, some common problems encountered when using it, and some example use cases. If you've ever been curious about Service Broker, need to send data between databases or instances, or are wondering if Service Broker is right for your organization, then you won't want to miss this session.
Speaker:

Session Type:
Regular Session

Track:
Room AB308

Level: Beginner

Session Code:

Date: October 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Developers like the reduced complexity and increased productivity that an ORM can bring while DBAs don't care for the data models that often result. Using an ORM with an existing data model is often a nightmare. But writing all of that data mapping code is such a pain! What if we could have a solution that gave us the best of both worlds and made the developers AND the DBAs happy? MicroORMs might be the answer. In this session, we’ll explore PetaPOCO, a MicroORM.
Speaker:

Session Type:
Regular Session

Track:
Room AB310

Level: Intermedia

Session Code:

Date: October 06

Time: 12:00 AM - 1:00 AM

Room: TBD

NoSQL is the buzzword of the moment, and MongoDB is the leader of the pack. Its probably running in your enterprise in production, and eventually its going to break. As a DBA its your job to fix it when it breaks, and back it up before it does.After all, there's not RELATIONAL in DBA.

On the technical side, this talk will focus on what a DBA needs to know about running MongoDB on windows. This includes setting it up as a service, importing and querying data, and of course backing up and restoring the database.

On the non-technical side, this talk will focus on when you would want to use MongoDB, and when you would not want to. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room AB309

Level: Beginner

Session Code:

Date: October 06

Time: 12:00 AM - 1:00 AM

Room: TBD

If you follow baseball you will notice that the Pittsburgh Pirates (this speaker’s favorite team) has to do more with less to be successful. This trend can also exist within IT shops. If you need to improve the performance of your SQL Server instances and cannot purchase 3rd party tools this session is for you. Learn to improve your performance tuning process by using several free tools. This session will cover wait stats, dynamic management objects, perfmon, PAL, SQL Trace, ClearTrace, SQL Nexus and SQLDiag. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room AB314

Level: Advanced

Session Code:

Date: October 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Sessions Found: 30
Back to Top