June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – Designing SQL Server 2005 Analysis Services Cubes for Excel 2007 PivotTables

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Business Intelligence, SQL Documentation, SQL Download, SQL White Papers, SQLAuthority Author Visit
In my recent Business Intelligence Training Roadshow August September 2009 I quite often get request to provide more details about Analysis Service Cubes for Excel 2007 PivotTable. Here is the white paper on the same subject. Microsoft Office Excel 2007 takes advantage of most of the features in Microsoft SQL…
Read More

SQL SERVER – What is Data Mining – A Simple Introductory Note

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Business Intelligence, Data Warehousing
According to MacLennan et al. (2009), data mining is defined as “the process of analyzing data to find hidden patterns using automatic methodologies.” Consider the following simple example that explains this concept. By analyzing the data on the items purchased from a supermarket or a chain of such stores, information…
Read More

SQLAuthority News – Application and Multi-Server Management

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Business Intelligence, Data Warehousing, SQL Documentation, SQL Download, SQL White Papers
SQL Server 2008 R2 – Application and Multi-Server Management SQL Server Technical Article Title: SQL Server 2008 R2Application and Multi-Server Management Introduction Writers: Geoff Allix Technical Reviewers: Joanne Hodgins, Omri Bahat, Morgan Oslake Published: February 2010 SQL Server 2008 R2 introduces new management tools to help improve IT efficiency and…
Read More