SQL Server Business Intelligence (BI) and Data Warehousing

MUST READ Tutorial: SQL Server Integration Services (SSIS) best practices TUTORIAL - Learn the best practices for SQL Server Integration Services (SSIS) in this tutorial, from migrating DTS packages to SSIS debugging, maintenance and programming in SQL Server. 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. Tips for tuning SQL Server 2005 to improve reporting performance EXPERT ANSWER - We are required to report from our SQL Server 2005 database. There are five or six tables regularly used for holding the reporting data, but these tables have five-to-seven million rows of data in them already. We need to use ... 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. Managing permissions in SQL Server Reporting Services TIP - Protect data by managing permissions in SQL Server Reporting Services. Assign user roles and tasks in the SSRS security model.

EXPERT TECHNICAL ADVICE: 1 - 3 of 96

	Sharing SSAS cube data in SharePoint with PerformancePoint Server 2007 Submitted By: SearchSQLServer.com | 23 Mar 2009 TIP - Microsoft PerformancePoint Server 2007 turns data into scorecards and dashboards that can be read enterprise-wide in Microsoft SharePoint.

	New data profiling tools in SQL Server 2008 26 Jan 2009 TIP - New data-profiling tools native to SQL Server 2008 Integration Services such as the Data Profiling task and the Data Profiler Viewer help manage a business intelligence strategy.

	Utilize SSAS for data predictions and classification using Excel 23 Dec 2008 TIP - Using Excel as a tool for data mining and predictions is very powerful. Learn how to take advantage of SSAS in SQL Server 2005 with Microsoft Office Excel 2007.

	VIEW ALL EXPERT TECHNICAL ADVICE ON SQL SERVER BUSINESS INTELLIGENCE (BI) AND DATA WAREHOUSING

REFERENCE & LEARNING: 1 - 3 of 52

	An overview of SQL Server Report Builder 2.0 Jayaram Krishnaswamy | 01 May 2009 BOOK EXCERPT - In this chapter excerpt from "Learning SQL Server 2008 Reporting Services", find out about the interface details and controls available in Report Builder 2.0.

	A short history of SQL Server Integration Services Kirk Haselden | 02 Mar 2009 BOOK EXCERPT - In this chapter excerpt from "SQL Server 2008 Integration Services Unleashed", learn more about the history of SQL Server Integration Services.

	Microsoft SQL Server Integration Services primer Kirk Haselden | 02 Mar 2009 BOOK EXCERPT - In this chapter excerpt from "SQL Server 2008 Integration Services Unleashed", learn more about the new features included with SSIS 2008 and what they mean to you.

	VIEW ALL REFERENCE & LEARNING ON SQL SERVER BUSINESS INTELLIGENCE (BI) AND DATA WAREHOUSING

NEWS: 1 - 3 of 29

	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 BUSINESS INTELLIGENCE (BI) AND DATA WAREHOUSING

VIDEO: 1 - 3 of 3

	Ensuring high availability of SSAS databases SearchSQLServer.com | 17 Jun 2009 VIDEO - In part three of this series, Baya Dewald hones in on the administrative side of SQL Server Analysis Services, with details on the various methods on high availability for SSAS.

	Building a data warehousing and BI solution SearchSQLServer.com | 15 May 2009 VIDEO - In part two of his series, Baya Dewald breaks down the process of creating a data warehousing and business intelligence solution, with details on the SSAS objects and processing options involved.

	An introduction to SQL Server data warehousing concepts SearchSQLServer.com | 24 Apr 2009 VIDEO - New to data warehousing? In this short webcast, SQL Server expert Baya Dewald offers an introduction to the basic components of data warehousing, with details on relational and multi-dimensional concepts for SQL Server ...

	VIEW ALL VIDEO ON SQL SERVER BUSINESS INTELLIGENCE (BI) AND DATA WAREHOUSING

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 BUSINESS INTELLIGENCE (BI) AND DATA WAREHOUSING

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 BUSINESS INTELLIGENCE (BI) AND DATA WAREHOUSING

	SEE ALSO - Topics Related to SQL Server Business Intelligence (BI) and Data Warehousing:  Web Services/SOA, SQL Server Database Modeling and Design, SQL Server Stored Procedures, XML in SQL Server, SQL/Transact SQL (T-SQL), .NET Development for SQL Server