Denormalizing dimension tables
When building a SSAS cube, you typically have a star schema containing dimension tables and fact tables. For dimension tables,...
2011-10-07
2,267 reads
The Khan Academy
It’s completely unrelated to work, though there is a computer science section.
I can’t take credit for this, that goes to...
2011-10-07
2,229 reads
SQL Server – SQL Server 2008 Service Pack 3 RTM Released
Microsoft has released Service Pack 3 for SQL Server 2008 yesterday. You can read this blog post from SQL Server...
2011-10-07
890 reads
What I Learned at #SPC11
This week, I attended the Microsoft SharePoint Conference 2011 (#SPC11) in Anaheim. Not my usual beat, to be sure, but our company is starting to use SharePoint more, and...
2011-10-07
16 reads
What I Learned at #SPC11
This week, I attended the Microsoft SharePoint Conference 2011 (#SPC11) in Anaheim. Not my usual beat, to be sure, but our company is starting to use SharePoint more, and...
2011-10-07
22 reads
NYC MSBI NYC Event - Evolved BI with SQL Server “Denali”
While many of us SQL Server enthusiasts in the community will be at PASS Summit 2011, all next week, the...
2011-10-07
1,055 reads
Follow PASS Keynote Live Feeds via Blog & Twitter
Not going to be there? No Worries
The PASS Global Summit starts next Wednesday, October 12th in Seattle. PASS is the...
2011-10-07
613 reads
Follow PASS Keynotes Live Feeds via Blog & Twitter
Not going to be there? No Worries
The PASS Global Summit starts next Wednesday, October 12th in Seattle. PASS is the...
2011-10-07
687 reads
PASS Summit is almost here
This is my second trip to Seattle for the annual bash. Last year I was a newbie. I did not...
2011-10-07
1,481 reads
What I Learned at #SPC11
This week, I attended the Microsoft SharePoint Conference 2011 (#SPC11) in Anaheim. Not my usual beat, to be sure, but...
2011-10-07
756 reads
Blogs
Paginated Reporting at Scale: Choosing the Right Microsoft Platform
By Rayis Imayev
"I've seen things you people wouldn't believe..."— Roy Batty, Nexus-6 Replicant, Blade Runner (1982)(2026-Nov-08) Yep,...
The Book of Redgate: Fun with Images
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Why companies use Palantir and how we help implement it in the Czech Republic
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
Table Partitioning in SQL Server: A Practical Guide to Managing Very Large Tables (VLDBs)
Comments posted to this topic are about the item Table Partitioning in SQL Server:...
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers