Versions 2000, 2005, 2008
T-SQL programming, stored procedures, indexed views
Partitions, replication and managing infrastructure, setup and system health
Integration and ETL
SSIS and DTS development. Crafting
robust, scalable enterprise packages.
Data Warehouse (OLAP)
Analysis Services architecture, development, security, remote HTTP access.
SQL Server Reporting Services 2005/2008
Dashboards, integration with SharePoint and advanced charting.
MDX, KPIs and Datamining