PASS Data Warehousing e Business Intelligence Virtual Chapter hanno organizzato una serie di webinar dedicati a SQL Server e alla BI, nel mese di gennaio sono stati programmati i seguenti appuntamenti live:
DW/BI VC Presents: Vertipaq vs OLAP: Change Your Data Modeling Approach
Date: 10/01/2012
Start Time: 3:00 PM
End Time: 4:00 PM
Timezone: (GMT-05:00) Eastern Time (US & Canada)
Speaker: Marco Russo
In this session we will introduce the new modeling capabilities of Vertipaq, showing how the same scenarios can be modeled in both UDM and Vertipaq. This will lead to an interesting discussion about how to develop your data warehouse in order to make it working with both UDM and Vertipaq.
http://www.sqlpass.org/Events/ctl/ViewEvent/mid/521.aspx?ID=753
DW/BI VC Presents: Security Tips and tricks for Analysis Servers 2008 R2
Date: 12/01/2012
Start Time: 12:00 PM
End Time: 1:00 PM
Timezone: (GMT-05:00) Eastern Time (US & Canada)
Speaker: Chris Webb
This session will look beyond the basics of security in Analysis Services 2008 R2, covering more advanced topics such as dynamic security and security on parent/child hierarchies and providing tips and tricks that even experienced SSAS developers may not know about.
http://www.sqlpass.org/Events/ctl/ViewEvent/mid/521.aspx?ID=754
DW/BI VC Presents: Security SSIS Tips and Tricks
Date: 17/01/2012
Start Time: 12:00 PM
End Time: 1:00 PM
Timezone: (GMT-05:00) Eastern Time (US & Canada)
Speaker: Josef Richberg
Learn some of the quirks and capabilities of SSIS. Learn about the pitfall of "parallel path choicing". Use the Script Component as a data source (to solve complex sourcing issues) and as a data destination (to get around the identity column conundrum). See how use Script Tasks to build directory scanners for efficient file import techniques. We'll also go over some the tunable properties of the Data Flow object.
http://www.sqlpass.org/Events/ctl/ViewEvent/mid/521.aspx?ID=755
DataArch VC persents: Database Makeover: Renovate Your Data Model by Audrey Hammonds
Date: 19/01/2012
Start Time: 12:00 PM
End Time: 1:00 PM
Timezone: (GMT-06:00) Central Time (US & Canada)
Speaker: Audrey Hammonds
In this session, we'll talk about how to evaluate an existing model, how to approach design when your system is up and running and how to incrementally apply database design changes in a fast-moving environment. Every database, even ones consisting of a collection of flat, unrelated tables, has the potential to become a beautiful database. All you need is an eye for design and a strategy to get you there.
http://www.sqlpass.org/Events/ctl/ViewEvent/mid/521.aspx?ID=758