Why use a SSAS cube?
What are the advantages of using SSAS Cubes over a regular data warehouse for reporting? Note I’m not asking why...
2013-08-06
1,601 reads
James Serra's Blog
Best Practices to Deliver BI Solutions Presentation
I will be presenting a brand new session entitled “Best Practices to Deliver BI Solutions” tomorrow, August 6th, at 11am...
2013-08-05
828 reads
Presentation Slides for Building an Effective Data Warehouse Architecture
Thanks to everyone who attended my session “Building an Effective Data Warehouse Architecture” for 24 hours of PASS, PASS Summit Preview. The abstract...
2013-08-02
744 reads
PerformancePoint: Show Details greyed out
In PerformancePoint, when using a analytic grid or chart or a scorecard, if you are not able to use the...
2013-08-01
949 reads
SQL Server 2014: Columnstore Index improvements
In SQL Server 2012, a new feature was added called Columnstore Indexes that resulted in huge query performance improvements. In SQL...
2013-07-30
3,082 reads
Building an Effective Data Warehouse Architecture Presentation
I will be presenting the session “Building an Effective Data Warehouse Architecture” this Wednesday, July 31st, at 10pm EST for...
2013-07-29
1,159 reads
TechEd Europe 2013 videos online
Microsoft has posted ALL the session videos for TechEd Europe 2013 and they are available for free! Some great videos...
2013-07-25
858 reads
SQL Server 2014: In-memory OLTP Engine, code-name: Hekaton
What looks to be the biggest and best new feature in SQL Server 2014 is called the “In-memory OLTP Engine”,...
2013-07-23
2,056 reads
Why You Need a Data Warehouse
Introduction
You likely have heard about data warehousing, but are unsure exactly what it is and if your company needs one....
2013-07-25 (first published: 2013-07-18)
5,966 reads
The benefit of placement firms
Why do companies use placement firms to find IT contractors instead of using internal recruiters?
Who better to answer that question...
2013-07-16
784 reads
Blogs
A New Word: Lilo
By Steve Jones
lilo– n. a friendship that can lie dormant for years only to pick right...
Learning Database Design and Power BI Performance
I spend my days working on and managing SQL Server instances—working days at least,...
Free SQL Training: Dive into Databases This December!
Want to learn SQL and get some real practice this December? Check out the...
Forums
Subscribing to a Great New Year
Comments posted to this topic are about the item Subscribing to a Great New...
dont want pkg to abort if someone is in excel source document
Hi, is there a way when using excel as a flat file source in...
Database Archive missing FK
Bonjour à tous, je vais bientôt démarrer un projet d'archivage de données pour alléger...
Question of the Day
The Funny Dynamic SQL
What happens when I run this code:
EXEC sp_executesql N'PRINT 1; GO';See possible answers