SQL Server data warehousing/business intelligence

MUST READ Export SQL Server data to an Excel file using SSIS and Visual Studio TUTORIAL - Here are seven steps for designing a SQL Server Integration Services package using Visual Studio and exporting data from your SQL Server table to Excel. Top 10 SQL Server Integration Services (SSIS) and DTS tips TOP 10 TIPS - Top SQL Server Integration Services (SSIS) tips from migrating and running DTS packages, to SSIS debugging, maintenance and programming in SQL Server 2005. Migrating SQL Server 2000 DTS packages to SSIS TIP - SSIS is more than a replacement for DTS packages. Migrate to this new powerful ETL platform with the transitional tools of Upgrade Advisor and Package Migration Wizard. Five steps to event handlers in SQL Server Integration Services (SSIS) TIP - Construct event handlers in SQL Server Integration Services (SSIS) for executables. Get the flexibility of Control Flow and Data Flow tabs in Event Handler. Tutorial: SQL Server 2005 Analysis Services TUTORIAL - Want to learn about Analysis Services 2005 in SQL Server? These tips outline helpful features and give examples of this BI tool's functionality.

EXPERT TECHNICAL ADVICE: 1 - 3 of 92

SQL SERVER DATA WAREHOUSING/BUSINESS INTELLIGENCE EXPERTS
			Mark Kromer Technical Product Manager ASK A QUESTION		Roman Rehak Senior Database Architect ASK A QUESTION

	Tips for tuning SQL Server 2005 to improve reporting performance 02 Oct 2008 EXPERT ANSWER - There are a few things you can do to tune SQL Server for improved reporting performance. Here are some generic and Reporting Services-specific techniques.

	Parent-child dimensions in SQL Server 2005 with Analysis Services MDX Submitted By: SearchSQLServer.com | 23 Sep 2008 TIP - Retrieving a hierarchy with recursive relationships can be difficult in SQL. Easily implement these relationships with a parent-child dimension using Analysis Services MDX.

	Configuring SQL Server with a changed computer name 03 Sep 2008 EXPERT ANSWER - Find out how to reconfigure all aspects of your SQL Server after your computer name has been changed.

	VIEW ALL EXPERT TECHNICAL ADVICE ON SQL SERVER DATA WAREHOUSING/BUSINESS INTELLIGENCE

REFERENCE & LEARNING: 1 - 3 of 55

	Tutorial: SQL Server 2005 Analysis Services SearchSQLServer.com | 02 Jul 2008 TUTORIAL - Want to learn about Analysis Services 2005 in SQL Server? These tips outline helpful features and give examples of this BI tool's functionality.

	Top 10 SQL Server Integration Services (SSIS) and DTS tips SearchSQLServer.com | 15 Jun 2008 TOP 10 TIPS - Top SQL Server Integration Services (SSIS) tips from migrating and running DTS packages, to SSIS debugging, maintenance and programming in SQL Server 2005.

	Export SQL Server data to an Excel file using SSIS and Visual Studio Jayaram Krishnaswamy | 08 Apr 2008 TUTORIAL - Here are seven steps for designing a SQL Server Integration Services package using Visual Studio and exporting data from your SQL Server table to Excel.

	VIEW ALL REFERENCE & LEARNING ON SQL SERVER DATA WAREHOUSING/BUSINESS INTELLIGENCE

NEWS: 1 - 3 of 30

	Manageability and business analytics with SQL Server 2005 SearchDatabase.com | 01 Oct 2004 ARTICLE - Although it's not scheduled to ship until early next year, attendees at the 2004 PASS Community Summit are eager to get closer glimpse at SQL Server 2005.

	Microsoft hypes BI, adds reporting tools for end users SearchDatabase.com | 30 Sep 2004 ARTICLE - Microsoft is putting reporting tools into the hands of end users by adding features from newly acquired BI software vendor ActiveViews. But some DBAs say giving more power to the end users could cause problems.

	Web services, BI fuel DBA job market SearchDatabase.com | 14 Jun 2004 ARTICLE - SearchDatabase.com has the scoop on a group of highly specialized areas that are breathing some new life into a tired DBA job market.

	VIEW ALL NEWS ON SQL SERVER DATA WAREHOUSING/BUSINESS INTELLIGENCE

WEBCASTS: 1 - 1 of 1

	Overview of Microsoft Business Intelligence Solution on the HP Windows Integrity Platform - Vendor Webcast VIEW WEBCAST PREMIERED:   08 NOV 2006, 02:00 EST (07:00, GMT) SUMMARY:   View this Webcast to learn how to combine and optimize SQL technology and BI initiatives to meet the needs and increasing complexity of your crucial data.

	VIEW ALL WEBCASTS ON SQL SERVER DATA WAREHOUSING/BUSINESS INTELLIGENCE

BEST WEB LINKS: 1 - 1 of 1

	SQL Server 2000 Survival Guide http://www.akadia.com/services/sqlsrv_programming.html | 22 Jul 2005 BEST WEB LINK - Here you find step-by-step resources for architecting, administering and managing SQL Server 2000.

	VIEW ALL BEST WEB LINKS ON SQL SERVER DATA WAREHOUSING/BUSINESS INTELLIGENCE

DEFINITIONS: 1 - 3 of 16

	Quiz: SQL Server 2000 30 Sep 2003 WORD - DIRECTIONS: Match the SQL Server statement in the right-hand column with its description in the left-hand column. How to take the quiz:After reading the question, write down the letter of your answer choice. Check your ...

	MOLAP 12 May 2003 WORD - MOLAP (multidimensional online analytical processing) is online analytical processing (OLAP) that indexes directly into a multidimensional database. In general, an OLAP application treats data multidimensionally; the user is ...

	pivot table 24 Jan 2003 WORD - A pivot table is a program tool that allows you to reorganize and summarize selected columns and rows of data in a spreadsheet or database table to obtain a desired report. A pivot table doesn't actually change the ...

	VIEW ALL DEFINITIONS ON SQL SERVER DATA WAREHOUSING/BUSINESS INTELLIGENCE

	SEE ALSO - Topics Related to SQL Server data warehousing/business intelligence:  SQL Server installation, SQL Server integration/interoperability, SQL Server replication, SQL Server database design and modeling, SQL Server performance and tuning, SQL Server Online Transaction Processing (OLTP), SQL Server backup and recovery, SQL Server clustering, SQL Server security, SQL Server availability