May 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – Business Intelligence – Aligning Business Metrics

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Business Intelligence, Data Warehousing
Today, executive management and managers need the latest information to drive intelligent decisions for business success. More informed decisions mean more revenue, less risk, decreased cost, and improved operational control for business agility and competitiveness. Besides, in today’s fast paced, technology-driven business world, organizations are continually struggling to deal with…
Read More

SQL Server – White Paper – An Introduction to Fast Track Data Warehouse Architectures by Erik Veerman

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Business Intelligence, Data Warehousing, SQL White Papers
An Introduction to Fast Track Data Warehouse Architectures SQL Server Technical Article Writer: Erik Veerman, Solid Quality Mentors Technical Reviewer: Mark Theissen, Scotty Moran, Val Fontama Published: February 2009 The performance and stability of any application solution—whether line of business, transactional, or business intelligence (BI)—hinges on the integration between solution…
Read More

SQL SERVER – 2008 Star Join Query Optimization

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
Best Practices, Business Intelligence, Data Warehousing, SQL Joins
Business Intelligence (BI) plays a significant role in businesses nowadays. Moreover, the databases that deal with the queries related to BI are presently facing an increase in workload. At present, when queries are sent to very large databases, millions of rows are returned. Also the users have to go through…
Read More

SQLAuthority News – SQL Server 2008 Analysis Services Performance Guide

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks, SQLAuthority News
Business Intelligence, SQL Documentation, SQL Download, SQL White Papers
Because Microsoft SQL Server Analysis Services query and processing performance tuning is a fairly broad subject, this white paper organizes performance tuning techniques into the following three segments. Enhancing Query Performance – Query performance directly impacts the quality of the end user experience. As such, it is the primary benchmark…
Read More

SQLAuthority News – Best Practices for Integration Services Configurations

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Business Intelligence, SQL White Papers, SSIS
Best Practices for Integration Services Configurations by Jamie Thomson This article explains what SQL Server Integration Services configurations are used for, why you should use Integration Services configurations, and what options you have for leveraging configurations. It will also make some simple recommendations that are based on my experiences of…
Read More