sqlsathistory

Nr: 240

Back to Main list

SQLSaturday #240 - Curacao 2013

Start Time (24h)	Speaker	Track	Title
00:00:00	Jason Brimhall	Track 1	SQL 2012 Extended Events
00:00:00	Jason Brimhall	Track 1	SQL 2012 Table Compression
00:00:00	Ignacio Salom Rangel	Track 1	SQL Server Page verification option, why it is important for every DBA?
00:00:00	Rohan Joackhim	Track 1	Basics of SQL Server Parallel Query Processing
00:00:00	Roy Ernest	Track 1	Execution Plans
00:00:00	William E Pearson III	Track 1	Possible Musics: Choosing between Analysis Services 2012 Multidimensional and Tabular

SessionID: 10836

SQL 2012 Extended Events

Back to calendar

Event Date: 17-08-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: Jason Brimhall

Title: SQL 2012 Extended Events

Abstract:

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.

SessionID: 10837

SQL 2012 Table Compression

Back to calendar

Event Date: 17-08-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: Jason Brimhall

Title: SQL 2012 Table Compression

Abstract:

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.

SessionID: 15131

SQL Server Page verification option, why it is important for every DBA?

Back to calendar

Event Date: 17-08-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: Ignacio Salom Rangel

Title: SQL Server Page verification option, why it is important for every DBA?

Abstract:

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.

SessionID: 21279

Basics of SQL Server Parallel Query Processing

Back to calendar

Event Date: 17-08-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: Rohan Joackhim

Title: Basics of SQL Server Parallel Query Processing

Abstract:

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...

SessionID: 23483

Execution Plans

Back to calendar

Event Date: 17-08-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: Roy Ernest

Title: Execution Plans

Abstract:

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

SessionID: 28113

Possible Musics: Choosing between Analysis Services 2012 Multidimensional and Tabular

Back to calendar

Event Date: 17-08-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: William E Pearson III

Title: Possible Musics: Choosing between Analysis Services 2012 Multidimensional and Tabular

Abstract:

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.

This site is open source. Improve this page.