SQLSaturday #240 - Curacao 2013
Event Date: 08/17/2013 00:00:00
Event Location:
- University of Netherlands Antilles
- Sta Maria
- Willemstad, , Netherlands Antilles
This event has completed. All data shown below is from the historical XML public data available.
If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).
Sessions
This is a list of sessions from the event, based on the schedule in the XML files.
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.
Speaker(s):
- William E Pearson III
Track and Room: Track 1 - N/A
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.
Speaker(s):
- Jason Brimhall
Track and Room: Track 1 - N/A
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.
Speaker(s):
- Jason Brimhall
Track and Room: Track 1 - N/A
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.
Speaker(s):
- Ignacio Salom Rangel
Track and Room: Track 1 - N/A
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…
Speaker(s):
- Rohan Joackhim
Track and Room: Track 1 - N/A
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
Speaker(s):
- Roy Ernest
Track and Room: Track 1 - N/A
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Ignacio Salom Rangel
Twitter: - @iasalom
LinkedIn: Ignacio Salom Rangel
Contact: http://ignaciosalom.com/
Ignacio Salom is a Senior SQL Server DBA and the CEO of Cenlinea Online Education He has over 15 years of experience in IT and in 2006 he turned his focus to SQL Server. Ignacio holds MCITP Database Administrator certifications for SQL Server 2005 and SQL Server 2008. His online presence includes:
- Writing for Confio Software’s LogicalRead
- His blog
- The SQL Server Central forums
- MSDN forums
- Twitter(@iasalom)
William E Pearson III
Twitter: - @Bill_Pearson
LinkedIn: William E Pearson III
Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E
Bill Pearson created Island Technologies Inc. in 1997, and has developed a large and diverse customer base since. Bill#39;s background as a CPA, Internal Auditor, Management Accountant, and SQL Server MVP (BI) enables him to provide value to clients as a liaison between Accounting / Finance and Information Services. Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies and focuses his practice upon the integrated Microsoft Business Intelligence
Jason Brimhall
Twitter: - sqlrnnr
LinkedIn: Jason Brimhall
Contact: http://jasonbrimhall.info
Jason Brimhall has more than 20 years of experience and has worked with SQL Server 6.5 through SQL Server 2019. He has experience in performance tuning, high transaction environments, and large environments. He is currently a consultant specializing in performance tuning, server analysis, and problem resolution. Jason is a Microsoft Certified Master (MCM) and a Data Platform MVP.
Jason Brimhall
Twitter: - sqlrnnr
LinkedIn: Jason Brimhall
Contact: http://jasonbrimhall.info
Jason Brimhall has more than 20 years of experience and has worked with SQL Server 6.5 through SQL Server 2019. He has experience in performance tuning, high transaction environments, and large environments. He is currently a consultant specializing in performance tuning, server analysis, and problem resolution. Jason is a Microsoft Certified Master (MCM) and a Data Platform MVP.
Rohan Joackhim
Twitter: - @rohanjoackhim
LinkedIn: Rohan Joackhim
Rohan has been working with SQL Server since 2001. His experience includes SQL Server projects dealing with HP Europe, financial institutions in Canada and data centers in the Dutch Caribbean. He is currently dealing with databases in 24/7 high availability environments . He was an active member and a presenter of the PASS chapter Toronto. Rohan holds a Bachelor of Computer Engineering degree and he is MCDBA SQL Server 2008 and ITIL V3 certified.
Roy Ernest
Twitter: - @RumblingDBA
LinkedIn: Roy Ernest
Contact: http://www.sqlservercentral.com/blogs/dba_rumblings/
Roy Ernest (Twitter: @RumblingDBA) currently works as the Manager of the IT-DBA Department for Zarb Corporation. He is the Leader of the Curacao SQL Server User group. Roy is very active in the SQL Server community and volunteers his time for the PASS organization. You can read his blog at http://www.sqlservercentral.com/blogs/dba_rumblings/default.aspx.
Sponsors
The following is a list of sponsors that helped fund the event: