Build Schedule

Advanced Filters:
  • Track

    clear all







  • Speaker


  • Level


  • Session Type

Sessions Found: 24
This highly-interactive, demo-intense presentation is for beginners and developers just getting started with SSIS. Attend and learn how to build SSIS packages from the ground up. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: October 20

Time: 12:00 AM - 1:00 AM

Room: TBD

We will cover several advanced topics in Transactional Replication including how to make a ddl change to one table in the publication without reinitializing the publication; how to make a ddl change to a table without having to snapshot; creating replicated tables on file systems other than Primary – including partitioned file systems.  And hint – we will be leaving the wizard in Redmond!!  Bring a copy of SQL 2012 Developers Edition with AdventureWorks2012 if you want to play along.
Speaker:

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: October 20

Time: 12:00 AM - 1:00 AM

Room: TBD

SSRS 2012: Having just completed a PRACTICAL dashboard to answer JUST this exact question, we shall be looking at how to create a reporting tool that will provide YOUR management with all their answers. We shall be focusing on the plethora of information that may be reaped from Dynamic Managment Views (DMV) and see how KPI's may be incorporated into the mix.
Speaker:

Session Type:
Regular Session

Track:
Track 5

Level: Intermedia

Session Code:

Date: October 20

Time: 12:00 AM - 1:00 AM

Room: TBD

Whether we inherit our Analysis Services environments from predecessors or create them - learning as we go - ourselves, we often conclude that performance (processing and / or querying) and functionality can be enhanced. In this session, Microsoft BI Architect and SQL Server MVP Bill Pearson overviews ways to launch new capabilities, and to propel performance beyond its current plateau, using design best practices to better meet consumer performance and functional needs. This is the initial session of a set of detailed Best Practices presentations.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 6

Level: Intermedia

Session Code:

Date: October 20

Time: 12:00 AM - 1:00 AM

Room: TBD

While SQL Server Standard Edition ships without several advanced enterprise features, it nonetheless can be used as a cost-effective data platform for many Big Data OLTP applications.  This talk will highlight what exactly SQL Standard Edition is, discuss the scale-up vs. scale-out debate, dive into techniques for ordering, splitting and joining very large tables, and present a case study.
Speaker:

Session Type:
Regular Session

Track:
Track 5

Level: Intermedia

Session Code:

Date: October 20

Time: 12:00 AM - 1:00 AM

Room: TBD

A Dynamic Dialog session: According to research compiled by Gartner from discussions with many BI clients, a substantial disparity exists, in the implementation of BI, between theory (standard approaches, promises, claims and expectations) and practice (shortfalls, compromises and other realities). In this session, Business Intelligence Architect and Microsoft MVP Bill Pearson leads a dialog within which we will gain an understanding of the general types of discrepancies between the “ideal” approach to BI and the compromised reality that a large number of organizations experience. We’ll then share and class experiences as a group, and discuss ways to avoid these discrepancies in future projects.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 6

Level: Beginner

Session Code:

Date: October 20

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server 2012: Efficient and effective database design is so important that leaving it solely to the DBAs is simply not a solution. We as developers will more than likely have to create applications to access the data stores and as such must ensure that all application related considerations are taken into account within the database design.In this session, (aimed at software developers) we shall be touching upon several concepts of special importance to the developer. These include database development "patterns and anti-patterns", final proofing of design and creating versatile deployment scripts that can and will be utilized in future endeavors.
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: October 20

Time: 12:00 AM - 1:00 AM

Room: TBD

Transform traditional database development by using SQL Server Data Tools - a declarative, model-based experience that supports both online and offline (project-based) database development.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 5

Level: Beginner

Session Code:

Date: October 20

Time: 12:00 AM - 1:00 AM

Room: TBD

Join SQL Server MVPs and Community Speakers Aaron Betrand, Andy Kelly, Joey D'Antoni and Mike Walsh as we discuss some of the worst practices we often see bite SQL Server environments. Most of these are settings and configurations that are destined to cause headaches from the defaults shipped with SQL Server, some are misunderstandings but all will cause you heartache. This will be a VERY interactive panel discussion. We'll cover a list of worst practices, share horror stories from our own experiences and take plenty of questions from the audience. We'll try and leave time at the end for you to throw your DBA or performance questions at this panel with over 50 years of SQL Server experience.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: October 20

Time: 12:00 AM - 1:00 AM

Room: TBD

In this “demo-tastic” presentation, SSIS trainer, author, and consultant Andy Leonard explains the what, why, and how of an SSIS framework that delivers metadata-driven package execution, connections management, and centralizes logging. Key takeaways: 1) Developers can migrate packages from Development, through their lifecycle, to Production without editing SSIS Connection Managers properties. 2) A metadata-driven approach to SSIS package execution. 3) Demonstration of a centralized logging reporting application.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Advanced

Session Code:

Date: October 20

Time: 12:00 AM - 1:00 AM

Room: TBD

Every developer eventually comes against business logic that can not be handled with a single simple or complex query.  TSQL provides the developer with several constructs that can store temporary result sets that are passed to the next query in the script.


I will be covering derived tables, local temporary tables, global temporary tables, table variables, user tables in tempdb, and common table expressions in my examples using the AdventureWorks database.  The pros and cons of each contruct will be examined.  Advanced options like enabling trace flag 1118 will be explored.
Speaker:

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: October 20

Time: 12:00 AM - 1:00 AM

Room: TBD

Enterprise Information Management (EIM) is an industry term for managing your data for data integration, quality, and governance. This session revolves around a demo which brings together the EIM functionality in SQL Server, a key part of our Credible, Consistent Data story for the 2012 release. We will show you how SQL Server Integration Services (SSIS), Data Quality Services (DQS), Master Data Services (MDS) and other Microsoft technologies work together to provide a comprehensive EIM solution. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: October 20

Time: 12:00 AM - 1:00 AM

Room: TBD

Stored procedures and functions are the mainstay of SQL Server coding. This presentation will show techniques to improve their performance.  We’ll start with techniques to learn where the time is really going using standard server traces and the new Extended Events.  Once we know where the time is going we look at strategies to decrease it:
•	Managing indexes on temp tables
   -	Why heaps are often the best choice for temp tables
   -	How building non-clustered indexes on heaps is faster than building clustered indexes.
•	Rewriting scalar and multi-statement functions to as inline functions
Each technique is illustrated with examples drawn from real cases in Andy's work.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: October 20

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server 2012 brings new efficient way of processing and designing data structures for analytics and reporting. These new concepts called BI Semantic Model and Tabular Model. In this session we will take a tour of building corporate BI Semantic Model step-by step using (SSDT). We also cover what are the Tabular model and Multidimensional models. How do I build a Tabular model, measures and KPI.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: October 20

Time: 12:00 AM - 1:00 AM

Room: TBD

Provision, Create, Maintain and use SQL Azure Databases
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 5

Level: Beginner

Session Code:

Date: October 20

Time: 12:00 AM - 1:00 AM

Room: TBD

Cube space; the final frontier. In this Star Trek themed introduction to MDX, we will discuss the fundamentals of cube structure and vocabulary, including tuples, members, sets, hierarchies, and more. We will introduce and demonstrate the basic syntax of MDX with queries that include navigating hierarchies and even some time-based expressions. This session will give you the tools you need to write simple, yet meaningful, MDX queries in your own environment. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 4

Level: Beginner

Session Code:

Date: October 20

Time: 12:00 AM - 1:00 AM

Room: TBD

A Dynamic Dialog session: Whether you’re considering implementing business intelligence for the first time, have completed projects in the past (and are perhaps looking at later phases), or are somewhere in between, an investment in this session will likely pay dividends. Business Intelligence Architect and Microsoft MVP Bill Pearson leads a dialog about common pitfalls or traps that we can encounter in designing and implementing BI. We’ll discuss, as a group, environmental and other challenges we have experienced, and share ways to avoid or minimize them, in our ongoing efforts with BI.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 6

Level: Beginner

Session Code:

Date: October 20

Time: 12:00 AM - 1:00 AM

Room: TBD

Are you confused where to start when it comes to performance monitoring? If so then come learn the essentials of daily performance monitoring using readily available TSQL scripts, stored procedures and utilities. You will see how easy it is to identify potential bottlenecks and poor performing queries without requiring an extensive infrastructure.  Most DBA’s these days are overworked and under budgeted. You will walk away with a solid grasp on how to approach the seemingly daunting task of performance monitoring.  
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: October 20

Time: 12:00 AM - 1:00 AM

Room: TBD

Microsoft SQL Server 2012 PowerPivot and Power View provide a way for you to create impressive and dynamic reports for data analysts, business decision makers, and information workers. You can easily create and interact with large amount of data from multiple sources and publish & share these reports & views.     In this session I will give you an overview of the key features of PowerPivot and Power View.  
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 6

Level: Beginner

Session Code:

Date: October 20

Time: 12:00 AM - 1:00 AM

Room: TBD

Have you heard about all of the new Availability Group features in SQL 2012? Thinking about implementing a DR solution, but don't know where to start. In this presentation you'll learn all about the new DR features in SQL Server 2012 and see them in practice.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: October 20

Time: 12:00 AM - 1:00 AM

Room: TBD

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