Articles Archive
-
SSWUG vConf – Loading a Data Warehouse in SSIS
Posted on April 23, 2009 | No CommentsPresenter: Brian Knight bknight@pragmaticworks.com Owner, Pragmatic Works In this session, you’ll learn how to load a typical data warehouse in SSIS efficiently. You’ll start by seeing some of the strengths... -
Christian Non-Profit Seeks DBA/Developer/Report Writer
Posted on April 23, 2009 | No CommentsHey there everyone. Have I got a treat for someone out there. Are you a SQL Server DBA, Developer, Report Writer? Do you align with a desire to spread God’s... -
SSWUG vConf – SQL Server 2008 Maintenance Plans
Posted on April 23, 2009 | No CommentsPresenter: Thomas LaRock Database Administration Manager ING Investment Management In SQL 2008, Maintenance Plans create a workflow of tasks to ensure your database is optimized and backed up on a... -
SSWUG vConf – Fact Table Design 101
Posted on April 23, 2009 | No CommentsPresenter: Erik Veerman erik@solidq.com In a Business Intelligence solution, the fact tables hold the core data that you are analyzing – facts (also called measures). Therefore, fact tables are a... -
SSWUG vConf – Dimension Table Design 101
Posted on April 23, 2009 | No CommentsPresenter: Erik Veerman erik@solidq.com Dimension Tables are one of the core components in a dimensional design and it is critical to design your dimension tables correctly in order to lay... -
SSWUG vConf – Dimensional Modeling 101
Posted on April 23, 2009 | No CommentsPresenter: Erik Veerman erik@solidq.com This session focuses on the basic design patterns for building relational database structures for Business Intelligence applications on SQL Server. By laying the foundation to dimensional... -
SSWUG vConf – SQL 103 – DMV’s and T-SQL for the DBA
Posted on April 22, 2009 | No CommentsPresenter: Jeremy Lull Jeremy@datarealized.com DMV – Dynamic Management Views (and functions) Returns server state information that can be used to monitor the health of a server instance, diagnose problems, and... -
SSWUG vConf – Analysis Services End-to-End
Posted on April 22, 2009 | No CommentsPresenter: Craig Utley craig@solidq.com DB –> SSIS –> Relational Data Warehouse –> SSAS (Cubes) –> SSRS Data Sources SSAS Projects have one or more data sources that point to data...
