Build Schedule

Advanced Filters:
  • Track

    clear all





  • Speaker


  • Level


  • Session Type

Sessions Found: 20
In this presentation Aaron will cover how to collect data from multiple sources using SQL Server 2012 Integration Services (SSIS). Then he will use SQL Server Reporting Services (SSRS) to report detail on that data. After that he will use SQL Server Analysis Services (SSAS) to create a KPI. Finally he’ll present that KPI on a dashboard via a web page. The goal of this presentation is to show how seamless the Microsoft Business Intelligence products are. If you’ve only used a few of these products, you’ll appreciate seeing them together all at once. Code will be provided.
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

Until 2005, SQL Server was a very pessimistic RDBMS.  However with the introduction of the Read Committed Snapshot database option and the new Snapshot Isolation level, that is no longer the case.

After a high level look at all SQL Server isolation levels, we’ll spend the majority of this session discussing the implementation of optimistic concurrency control in SQL Server.  We’ll look at the benefits and drawbacks of using an optimistic isolation level and discuss use cases where it may or may not be appropriate.

Come learn how to put one of the more powerful, but least understood, aspects of SQL Server to work for you!
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

If you have not experienced building BI solutions with Excel 2010, be amazed at what you can do in Excel 2013.  In this session we will use PowerPivot, Power View, Quick Explorer, and other great features in Excel to build an Excel 2013 BI solution.  Microsoft has went "all-in" with Excel as their primary BI client.  If you want to get a first hand look at using it more fully, you will be amazed.  I know I was.
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

Microsoft SQL Server makes it simple to apply data mining algorithms to a wide variety of data.  Applying the results to business decisions without a thorough understanding of how the algorithms work is dangerous to the bottom line of the business, though.  This session will take one of the algorithms, the Microsoft Clustering Algorithm, and do a deep dive into the mechanics of how it works.  The algorithm is valuable for analyzing data in the fields of marketing, social networks and many others.  The session will also examine the types of data that are valid for clustering.  A demonstration of building a clustering model using SQL Server Analysis Services and viewing the model using the Excel Data Mining Add-In will be given.
Speaker:

Session Type:
Regular Session

Track:
Track 4

Level: Advanced

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

As the old adage goes, 'Garbage in, garbage out.' Stop spending hours manually cleansing your data, and start using DQS! DQS is the new data 
quality tool provided with SQL Server 2012. By leveraging knowledge bases, you can correct invalid data and improve the quality of your data.

In this session we will cover creating a knowledge base, data cleansing, data matching, and using 3rd party knowledge bases (Reference Data). We will talk about installation, show how to use the DQS tool, and how to integrate DQS into your SSIS packages. After this session you should have a good understanding of what DQS is, how to use it, and how to get started with your own Data Quality initiative.
Speaker:

Session Type:
Regular Session

Track:
Track 4

Level: Beginner

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

Sure, your SQL Server is up and running. Is it healthy? Is it performing the best that it can? Where are your performance bottlenecks? In an emergency, can you objectively demonstrate where a performance problem lies? This dynamic dialog session will present a solid process for checking your environment's overall health and performance levels as well as solutions for common problems. Some of the items focused on include dynamic management views (DMVs), Windows Perfmon, and disk performance tools such as IOMeter and SQLIO.
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

Deadlocks can be very tricky, unpredictable and generally nasty. Is all hope lost? This demo-intensive session will explore several types of deadlocks and give you some insight into how to track them down and prevent them. We wil start with a quick review of locking and blocking concepts, then take a deep-dive into deadlock demos.
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will provide a deeper dive into the art of dimensional modeling. We will look at the different types of fact tables and dimension tables, how and when to use them. We will also some approaches to creating rich hierarchies that make reporting a snap. This session promises to be very interactive and engaging, bring your toughest Dimensional Modeling quandaries.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

Execution plans are stored after execution in the plan cache. This metadata about how queries are executed can provide insight into how your SQL Server environment is functioning. By using XQuery to browse and search the plan cache you can find potential performance issues and opportunities to tune your queries. This information can be used to help reduce issues related to parallelism, shift queries from using scans to using seek operations, or discover exactly which queries are using what indexes. All of this and more is readily available through the plan cache. In this session we will explore the plan cache and start you on the road to discovery.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

Begin using F# for Data Analysis.  Learn how to take advantage of this function-based language to tackle advanced analysis.  I will walk through what F# is, and why it is a great tool for data analysis.  This presentation will be full of demonstrations on how to use F# with data sets, analysis models, and data visualization.   Supplement your SQL data analysis with the F# functional language, which is ideal for solving complex analytical problems.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

With the release of SQL Server 2012 one of the biggest changes for SSIS Administration was the addition of the Integration Services Catalog and using parameters. The Catalog is the storage and logging location for SSIS 2012. Parameters are the new configurations in SSIS 2012 and once you start using them you will never go back. Package Variables, Configuration Strings, Package properties can all be configured using Parameters. You will learn how to create the catalog, use parameters to deploy packages through different environments and use the built in reporting to monitor packages as they run.
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

Come to this session and learn how easy it is to install an SQL Server Reporting Services (SSRS) Environment with a SharePoint Foundation environment. Terry will share his lessons learned on how to install and configure an SSRS/Sharepoint environment. Terry will also share the lessons learned about what the books don't tell you and how to set up your SharePoint sites and security to lessen future grief. Terry will even cover some more detailed topics like how to configure Visual Studio to be able to deploy from within Visual Studio right to Sharepoint and how to call an SSRS report from Java.
Speaker:

Session Type:
Regular Session

Track:
Track 4

Level: Beginner

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

There are index options in SQL Server that can enhance the performance of your queries - but most likely, you aren't using them! If you have a solid knowledge of index basics and want to add to your collection, this is the session for you! I'll show you how filtered indexes, compressed indexes, and indexed views work and can improve performance! 
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

With PowerShell and SQLPSX your DBA life can be a lot simpler.
SMO is powerful, but can be difficult to use.  Enter SQLPSX.  Chad Miller put together a set of PowerShell functions that
streamline the use of SMO, easing management of a multi-server environment. 
Come learn when and how the addition of PowerShell and SQLPSX can benefit you.
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

Have you heard about all the great new T-SQL features? Attend this session to learn about new functions, OVER clause enhancements, the Sequence Object and more!
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

What is Table Partitioning?  How can it be used to enhance performance?  How can it be used with a data archiving strategy to quickly and easily drop archived data from a table?  We will discuss the practical applications of table partitioning using scripts to generate new table partitions, move a partition to another table and discussion on how this can benefit you. 
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

Learn the options for encryption in SQL Server, covering hashing, symmetric keys, asymmetric keys, and encrypted communications.
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

What will the DBA role look like in 10 years? 20 years?  Will a DBA still be necessary?  We'll explore a number of scenarios in an forum as we try6 to determine how, as DBAs, we can position ourselves for a bright and productive future.  I'll talk about trends I'm seeing in companies of all shapes and sizes.  This presentation isn't about concensus, but about tackling tough issues facing the future of our profession.
Speaker:

Session Type:
Regular Session

Track:
Track 4

Level: Beginner

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

Having multiple database files and filegroups is one of many strategies to improve performance and make administration easier. What are filegroups, and how do you use them? In this session, I'll show you how to create filegroups, create objects in them or move objects to them, and discuss how they can help performance. I'll also cover Enterprise-level features like piecemeal restores. 
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

You have been writing T-SQL for years but just haven't had time to learn about the new features. Attend this session to take your T-SQL skills to the next level. We'll cover the new analytic functions that can help you write highly performing queries with less effort than the old techniques. 
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

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