Build Schedule

Advanced Filters:
  • Track

    clear all









  • Speaker


  • Level


  • Session Type

Sessions Found: 40
SSRS 2008 R2 has been a game changer for SQL Server in terms of visualization techniques. With a wide range of available options for charting, BI professionals struggle to get familiar with even the basic functionalities of most charts.
This session will talk about the basic functionalities of all the charts as well as some tips and tricks around them. Come to this session and take your charting skills to the next level. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: April 13

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 5

Level: Intermedia

Session Code:

Date: April 13

Time: 12:00 AM - 1:00 AM

Room: TBD

One of the hottest trends in analytics right now is geospatial reporting. Long gone are the days of viewing region based data in a grid. Now it is possible to provide users with additional insight on the regional performance of business.

In this session, Julie will show you three options for creating and delivering these analytics. First SQL Server Reporting Services 2012 will be presented to show how we can create custom shape objects to conform with business defined regions. Secondly, using the power of Excel 2013, Bing Maps and GeoFlow, learn how to build captivating visualizations directly in Excel. Finally, we'll show how easy it is to build interactive maps using Power View.
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: April 13

Time: 12:00 AM - 1:00 AM

Room: TBD

A lot of database professionals today  do not have a Computer-Science Degree  so they never attended a  “Introduction to Databases” course. In this session we are trying to fix at least one thing and we’ll look in depth at the three types of join operations, visualize how their algorithms work in order to understand how query plans are computed, explain why these join operations have very different performance characteristics and why the optimizer chooses a specific  join operator to use in a query plan. Will demonstrate that empirical cost calculations are similar to what Query Optimizer actually outputs. Good understanding of join algorithms is vital in order to diagnose and remedy issues related to bad query plans.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Track 7

Level: Intermedia

Session Code:

Date: April 13

Time: 12:00 AM - 1:00 AM

Room: TBD

You’re a DBA, and your boss asks you to determine if a data warehouse would help the company. So many questions pop into your head: Why use a data warehouse? What’s the best methodology to use when creating a data warehouse? Should I use a normalized or dimensional approach? What’s the difference between the Kimball and Inmon methodologies? Does the new Tabular Model change things? What’s the difference between a data warehouse and a data mart? Is there any hardware that is optimized for a data warehouse? Join this session for the answers to all these questions. You’ll leave with information that will amaze your boss and lead to a big raise… – or at least lead you down the correct path to adding business value to your organization!
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: April 13

Time: 12:00 AM - 1:00 AM

Room: TBD

Ted Krueger will join Hope in presenting this session. Consulting is a mystical career path that is often questioned: should I do it, can I do it and why should I do it? Come join us on a discussion of the pros and cons to consulting with an emphasis on SQL Server and Microsoft Technologies. We'll field questions with real world experiences. Once you leave this open floor session, you'll be able to make better choices in your own professional development and how consulting may or may not effect it.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 8

Level: Beginner

Session Code:

Date: April 13

Time: 12:00 AM - 1:00 AM

Room: TBD

SharePoint makes it easy for users to create their own dashboards but there's more to dashboards than just fast and easy set-up. This session will explore not only the characteristics of an effective BI dashboard using SharePoint 2013, but also the design flaws to avoid. Attend this session and learn how to perform a dashboard makeover. Starting with a review of a dashboard that uses technology correctly but not as effectively as it could, you’ll explore common problems found in dashboards, learn the characteristics of good dashboard design and discover how to implement a dashboard that communicates information clearly and concisely. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 8

Level: Beginner

Session Code:

Date: April 13

Time: 12:00 AM - 1:00 AM

Room: TBD

Learn about Microsoft’s Data Quality Services (DQS), what it is and how it works. You will discover how DQS sets itself apart from conventional data cleansing routines and go through examples on how to begin your own Data Quality Project. What really makes DQS unique and powerful is its ability to access shared knowledge, so we will show you how to access and use this shared knowledge to your benefit.

Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: April 13

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 by David Klee (@kleegeek) 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 5

Level: Intermedia

Session Code:

Date: April 13

Time: 12:00 AM - 1:00 AM

Room: TBD

Though most developers agree that unit testing plays an important role in software development, to ensure quality & meet milestones, most developers write unit tests only as an afterthought. VSTS helps to mainstream Test Driven Development methodology (TDD) into world of database development. In this session, we will not only cover the basis of unit testing concepts and terminology, but also discuss how unit testing helps ensure and document the quality and accuracy of database deliverables. We will run through a demo of creating and running database unit tests using VSTS 2012, as well as upgrading from VSTS2010 database and unit test projects.
Speaker:

Session Type:
Regular Session

Track:
Track 7

Level: Beginner

Session Code:

Date: April 13

Time: 12:00 AM - 1:00 AM

Room: TBD

Availability Groups, a feature of SQL Server 2012 delivers mission critical high availability and disaster recovery in the same solution.  This session covers capabilities, deployment architecutes, how to install, configure, manage and troubleshoot this new feature with best practices of customers who have deployed and are using Availability Groups. 
Speaker:

Session Type:
Regular Session

Track:
Track 5

Level: Beginner

Session Code:

Date: April 13

Time: 12:00 AM - 1:00 AM

Room: TBD

With the release of SQL 2012, Analysis Services (SSAS) has seen some major changes.  An entire new method of modelling analytic data has emerged and it's called Tabular Mode Analysis Services.  In addition to that, a new semantic layer has been added to the tool, the Business Intelligence Semantic Model (BISM), which will help to bring the two modes -- Multidimensional and Tabular -- into one level playing arena.

In this session, attendees will gain understanding of what Multidimensional and Tabular modelling IS, as well as how the BISM layer helps to translate user requests to ensure no confusion is made. Attendees will also learn how to BUILD a Tabular model, and will help design a solution live during the presentation. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: April 13

Time: 12:00 AM - 1:00 AM

Room: TBD

The word cluster is used a lot in the IT world, especially when it comes to SQL Server. We have clustered instances of SQL Server, availability groups that require Windows failover clustering ... but how does a DBA make sense of it all? Wonder no more! This session will explain all the forms of clustering as they relate to SQL Server (including how Windows fits into the picture) and give you some of the top keys to success whether you are using an older version of Windows and SQL Server, or you're looking to deploy the latest and greatest.
Speaker:

Session Type:
Regular Session

Track:
Track 5

Level: Intermedia

Session Code:

Date: April 13

Time: 12:00 AM - 1:00 AM

Room: TBD

Database statistics are not made up numbers, like the statistics you may hear on TV or read in a news article. They are critical metadata used by SQL Server’s query optimizer. In this session, we will look at statistics from the ground up and remove the mystery that surrounds them. Demos and real-world examples will be used to explain what statistics are, why you should care about them, and what you can control. 

By the end of the session, you will understand: 
• How to view statistics and interpret the histogram 
• How and when to update statistics 
• How statistics affect the query optimizer 
• When you can let SQL Server manage statistics, and when you need to step in 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: April 13

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 2

Level: Intermedia

Session Code:

Date: April 13

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 8

Level: Intermedia

Session Code:

Date: April 13

Time: 12:00 AM - 1:00 AM

Room: TBD

Power View is a visual data exploration tool that comes built into Excel 2013. With it you can build charts that seamlessly interact with each other and quickly map your data using Bing maps. In this session, you will learn how to get the most out of Power View: what it does well and what it doesn't so you can maximize the value you get out of it in a minimum amount of time.
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: April 13

Time: 12:00 AM - 1:00 AM

Room: TBD

In this Star Trek-themed presentation, we will explain the terms and concepts important to understand when participating in projects involving SQL Server Analysis Services (SSAS).

You’ll learn the key differences between SSAS Multidimensional Model (Cubes) and SSAS Tabular Model. You’ll also learn the definitions and examples of key terms for each model, including but not limited to: measure groups, measures, dimensions, attributes, and hierarchies in the SSAS Multidimensional Model and tables, columns, and calculated measures in the SSAS Tabular Model. We will also demonstrate the basics of browsing of both Multidimensional and Tabular models using Excel 2013.
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: April 13

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 8

Level: Beginner

Session Code:

Date: April 13

Time: 12:00 AM - 1:00 AM

Room: TBD

These terms seem to be thrown around all the time – but what do they all mean? In this session we’ll explore the different isolation levels in SQL Server and how they affect the way that blocking and locking behave within the database engine. We’ll dive into the most common locks and how they can be leveraged and avoided to improve your application experience. Once locks are explored, we’ll discuss the dreaded deadlock and discuss techniques to detect and mitigate this troublemaker in your environment.
Speaker:

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: April 13

Time: 12:00 AM - 1:00 AM

Room: TBD

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