18 septiembre 2011

PRPASS: Fundamentos de Analysis Services Parte 2 y Mejoras para Programadores en “Denali”

Un pequeño post para comentarles que el día miércoles 5 de octubre tendremos la próxima reunión de Puerto Rico PASS Association for SQL Server (PRPASS). A continuación los detalles (en inglés):

Get the most of SQL Server with Analytics and Developer Enhancements

Come and join your Puerto Rico PASS users community group to learn and share about SQL Server.

WHEN:

Wednesday, October 5, 2011 (Registration opens at 6:15 PM)

WHERE:

Microsoft Puerto Rico (Click here for a map)
City View Plaza II Suite 107
State Road 165 Km 1.2
Guaynabo, PR  00968

TOPICS:

SQL Server Analysis Services 101 and Advanced ConceptsPart 2

Level: 100 -200 (Beginner | Intermediate)
Audience: IT Professional

This session is a continuation from our last meeting. If you missed it, watch the on-demand recording here.

Analytics enable businesses to be more competitive and proactive by allowing better decisions and actions. SQL Server Analysis Services (SSAS) is a OnLine Analytical Processing (OLAP) engine in the SQL Server family designed to answer business questions.

Join this session to learn more about how to create/configure Analysis Services dimensions, cubes, perspectives, role based security, aggregations, storage models, partitions, and more. This session assumes that the audience does not have any knowledge or very basic knowledge of SSAS.  This session will also go over more advanced topics.

Speaker: Alan Koo
Senior Consultant, Nagnoi, Inc.

Microsoft MVP

Speaker Profile: Alan Koo is a Senior Consultant at Nagnoi, Inc. performing specialized work in Performance Management and Enterprise Solutions Development.  With more than 10 years of experience, Mr. Koo has consulted for top companies in the public and private sectors in and outside of Puerto Rico. Mr. Koo is the co-founder and current President of our SQL Chapter, PRPASS. He has been awarded Microsoft Most Value Professional (MVP) in SQL Server four years in a row. Mr. Koo is also a thought leader sharing his experiences and knowledge through his blog “Microsoft Business Intelligence and more… (www.alankoo.com) and the technical users communities such as SQL PASS Latam, TechNet and MSDN.

SQL Server Denali CTP3 – Programmability Enhancements

Level: 200 (Intermediate)
Audience: Developers

SQL Server code-named “Denali” is the new version of SQL Server expected to be released in the next 3 to 6 months. SQL Server Denali will come with tons of new functionality in different areas. Come and join this session to take a look of the main new developer features and capabilities in Denali based on the latest release (CTP3), and take advantage in your applications before that anyone.

Some of the topics we will cover during the session are:.

· Transact-SQL Debugging and Intellisense

· Transact-SQL Snippets

· T-SQL New Features and Enhancements(logical functions, conversion functions, date and time functions, over clause, analytics functions)

· …and more!

Speaker: Pablo Bevegni
Infocorp

Speaker Profile: Pablo Bevegni is Lead Architect & Sales Engineer at Infocorp Caribbean. Mr. Bevegni has more than 8 years of experience designing and implementing different technology solutions. Mr. Bevegni has a bachelor degree in Information Systems from ORT University in Uruguay.