This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
SQLAuthority News - Download Whitepaper - Choosing a Tabular or Multidimensional Modeling Experience in SQL Server 2012 Analysis Services

SQLAuthority News – Download Whitepaper – Choosing a Tabular or Multidimensional Modeling Experience in SQL Server 2012 Analysis Services

May 13, 2012
Pinal Dave
SQL Tips and Tricks
Business Intelligence, SQL White Papers

SQL Server 2012 Analysis Services offers two modeling experiences. This Microsoft whitepaper helps you choose tabular or multidimensional for your BI needs.

Read More
SQLAuthority News - Business Intelligence features of SQL Server 2012 RC0 - Download Virtual Machine

SQLAuthority News – Business Intelligence features of SQL Server 2012 RC0 – Download Virtual Machine

February 12, 2012
Pinal Dave
SQL Tips and Tricks
Business Intelligence, SQL Download

Microsoft built a ready virtual machine with the Business Intelligence features of SQL Server 2012 RC0, including Power View and PowerPivot.

Read More
SQL SERVER 2012 Editions - Highlights of The Cloud-Ready Information Platform

SQL SERVER 2012 Editions – Highlights of The Cloud-Ready Information Platform

November 4, 2011
Pinal Dave
SQL Tips and Tricks
Business Intelligence

SQL Server 2012 editions at a glance: Enterprise, Business Intelligence and Standard, plus Web, Developer and Express, with highlights of each one.

Read More
A wide reading table with one large ledger open at the centre and reference volumes arranged around it

What Is a Data Warehouse?

September 5, 2011
Pinal Dave
SQL Tips and Tricks
Best Practices, Business Intelligence, Data Warehousing, Database

A data warehouse is built for questions, not transactions. Facts and dimensions in plain words, why the star schema reads the way people talk, what a date dimension is for, and when you do not need one.

Read More
SQL SERVER - BI Quiz Hint - Performance Tuning Cubes - Hints

SQL SERVER – BI Quiz Hint – Performance Tuning Cubes – Hints

June 24, 2011
Pinal Dave
SQL Puzzle
Business Intelligence, SQL Server

Hints for my SQL BI Quiz on performance tuning cubes: what would you check first when a cube that was fast suddenly returns data very slowly?

Read More
SQL SERVER - SSAS - Multidimensional Space Terms and Explanation

SQL SERVER – SSAS – Multidimensional Space Terms and Explanation

June 22, 2011
Pinal Dave
SQL Tips and Tricks
Business Intelligence

At a Tech Ed On Road session I was asked to explain multidimensional space in simple words. Here are dimension, member, value, attribute and size.

Read More
SQL SERVER - BI Quiz - Troubleshooting Cube Performance

SQL SERVER – BI Quiz – Troubleshooting Cube Performance

June 6, 2011
Pinal Dave
SQL Performance
Business Intelligence

My SQL BI Quiz question: your cube suddenly returns data very slowly. What three things would you check first when troubleshooting cube performance?

Read More
Previous 1 2 3 4 5 … 7 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com