Build Schedule

Advanced Filters:
  • Track

    clear all



  • Speaker


  • Level


  • Session Type

Sessions Found: 6
During query optimization, SQL Server is looking for queries or index operations that might benefit from parallel execution. This session will discuss the basics of parallelism in SQL Server.  How you can avoid or benefit from parallelism in OLTP or OLAP environment.What basic factors within the SQL Server can be helpful to deal with parallel queries.And more...
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: August 17

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session we start from basics on how to read an execution plan and what can be done to get better performance for your queries
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: August 17

Time: 12:00 AM - 1:00 AM

Room: TBD

The Analysis Services 2012 Business Intelligence Semantic Model (BISM) unifies Multidimensional (OLAP) and Tabular (relational) options for organizational BI.  BI professionals can implement Multidimensional cubes, or they can deploy Tabular models, developed by business users, to a dedicated server.  Those new to Tabular, or those embarking upon BI for the first time with Analysis Services 2012, may find it difficult to choose between the two paths.  In this session, BI Architect, SSAS Maestro and MVP Bill Pearson overviews the nature and design goals of each option, comparing Multidimensional and Tabular features.  He then offers guidance on selecting the appropriate model, providing real world examples to illustrate approaches for given scenarios.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: August 17

Time: 12:00 AM - 1:00 AM

Room: TBD

Extended Events were introduced in SQL Server 2008.  With SQL 2012, we have seen a significant upgrade to this feature.  Join me for a little adventure into what extended events are.  We will discuss how to use extended events to aid in performance tuning and in day to day administration.  We will also explore some background and the architecture of extended events.  
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Advanced

Session Code:

Date: August 17

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server 2008 has introduced Table compression to the DBA toolkit.  We all know there are different kinds of compression available in SQL Server.  What some may not know is the subtleties of compression.  Such subtleties include that not all Page Compressed tables are entirely page compressed.  This session will show you how to reach into the database and discover compression states at the page level.  At the lower level, this session will also show how to determine compression settings of objects in the database.  Participants will be able to use undocumented commands as well as commands such as PIVOT to derive some interesting information from the database engine.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Advanced

Session Code:

Date: August 17

Time: 12:00 AM - 1:00 AM

Room: TBD

Are you 100% sure that your databases are corruption free? Do you know what page verification means? In this Level 300 session you will learn what page verification options are available to SQL Server and what each option does. You will also get some scripts you can run in your environment to find out if your databases can currently identify corrupt pages. 
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Advanced

Session Code:

Date: August 17

Time: 12:00 AM - 1:00 AM

Room: TBD

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