June 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 – Fix : Error : Invalid object name ‘sys.configurations’. (Microsoft SQL Server, Error: 208)

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Azure, SQL Error Messages
As you all know that SQL Azure CTP has been released; here, I have included a step-by-step guide for how to configure the CTP: SQL SERVER – Azure Start Guide – Step by Step Installation Guide. For pricing and introduction, please read SQLAuthority News – SQL Azure – Microsoft SQL…
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 – White Papers – Consolidation Guidance for SQL Server – Consolidation Using SQL Server 2008

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Database, SQL White Papers
Consolidation Using SQL Server 2008 Writer: Allan Hirt, Megahirtz LLC (allan@sqlha.com) Technical Reviewers: Lindsey Allen, Madhan Arumugam, Ben DeBow, Sung Hsueh, Rebecca Laszlo, Claude Lorenson, Prem Mehra, Mark Pohto, Sambit Samal, and Buck Woody Published: October 2009 What are the considerations when creating a consolidation plan for my environment? What…
Read More

SQLAuthority News – Notes from TechDays 2009 at Infosys, Bangalore

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
MVP, SQL Scripts, SQLAuthority Author Visit
I recently had opportunity to attend TechDays 2009 Infosys. The dates of the event was Nov 16-17, 2009. This event was the largest technology conference by Microsoft in Infosys. Microsoft Tech Days focused on positioning Microsoft as the company to bet on for future technology investments by businesses and consumers…
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