Event Location:
University of Netherlands Antilles
Sta Maria
Willemstad, , Netherlands Antilles
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,
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,
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,
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,
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,
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,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
LinkedIn: https://www.linkedin.com/in/ignaciosalomrangel
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 - Linkedin - Twitter(@iasalom)
LinkedIn: https://www.linkedin.com/e/fpf/252170891
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
LinkedIn: https://www.linkedin.com/in/dbajbrimhall/
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.
LinkedIn: https://www.linkedin.com/in/dbajbrimhall/
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.
LinkedIn: http://ca.linkedin.com/pub/rohan-joackhim/4/76a/342
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.
LinkedIn: https://www.linkedin.com/in/royernest
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.
The following is a list of sponsors that helped fund the event.