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,632 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
831 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
748 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
956 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,094 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,163 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
862 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,059 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,979 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
790 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers