You’re sh*&ting me. No way. Man, that sucks. rocks! – Toby Lee Shavers, from XXX (2002), altered of course! And before you start, yes, I’m starting to follow the schtick of quotes from fellow PowerPivot bloggers Rob Collie (@PowerPivotPro) and Kasper de Jonge (@Kjonge). For more memorable movie quotes, check out http://www.powerpivotpro.com/ . After about [...]
Archive for the ‘Analysis Services’ Category
Analysis Services ROLAP for SQL Server Data Warehouses
Posted in Analysis Services, tagged Data Warehouse, Internals, Performance, ROLAP on August 24, 2010 | 2 Comments »
PowerPivot, Analysis Services, and TechReady….and coffee!
Posted in Analysis Services, PowerPivot, tagged Internals, Miscellaneous on July 26, 2010 | Leave a Comment »
If you’re going to TechReady 11 at the Washington State Convention Center this week in warm, sunny Seattle – first of all, welcome to the Emerald City! And if you’re a coffee snob like me (to give you background, not only am a long time Seattle resident so I pretty much breathe coffee – but [...]
Scale-Out Querying with Analysis Services…does it apply to SQL Server 2008 or 2008 R2?
Posted in Analysis Services, tagged Performance, Scale-Out on May 18, 2010 | 3 Comments »
I recently received a great question concerning the whitepaper Scale-Out Querying with Analysis Services: Question, does this also apply for SQL Server 2008? What are you experiences with the scale out? I’m in the process of recommending using this technology to a large customer of mine and want to make sure we are actually able [...]
Accelerating Microsoft adCenter with Microsoft SQL Server 2008 Analysis Services
Posted in Analysis Services, tagged Design, Partition, Performance on September 19, 2009 | Leave a Comment »
How Microsoft adCenter takes advantage of groundbreaking performance and scalability enhancements and innovative design tools available with Microsoft SQL Server 2008 Analysis Services For more information, please refer to the whitepaper Accelerating Microsoft adCenter with Microsoft SQL Server 2008 Analysis Services. Executive Summary As an Internet platform for online advertising campaigns on Microsoft® Bing™, [...]
Professional Microsoft SQL Server Analysis Services 2008 with MDX
Posted in Analysis Services, tagged Book on February 20, 2009 | Leave a Comment »
For those of you interested in reading up on the latest and greatest for SQL Server 2008 Analysis Services, coming out in March 2009 is the Professional Microsoft SQL Server Analysis Services 2008 with MDX by Sivakumar Harinath, Robert Zare, Sethu Meenakshisundaram, Matt Carroll, Denny Guang-Yeu Lee. Yes, I am back to my usual self [...]
Professional Microsoft SQL Server Analysis Services 2008 with MDX
Posted in Analysis Services on February 19, 2009 | 100 Comments »
For those of you interested in reading up on the latest and greatest for SQL Server 2008 Analysis Services, coming out in March 2009 is the Professional Microsoft SQL Server Analysis Services 2008 with MDX by Sivakumar Harinath, Robert Zare, Sethu Meenakshisundaram, Matt Carroll, Denny Guang-Yeu Lee. Yes, I am back to my usual self [...]
Reintroducing Usage-Based Optimization in SQL Server 2008 Analysis Services
Posted in Analysis Services, tagged Usage-Based Optimization on November 19, 2008 | Leave a Comment »
With the release of the SQL Server 2008 Analysis Services, there is the new and improved version of the Usage-based Optimization algorithm. The best practices and recommendations to use this feature can be found out this recently published technical note Reintroducing Usage-Based Optimization in SQL Server 2008 Analysis Services. Enjoy!
Reintroducing Usage-Based Optimization in SQL Server 2008 Analysis Services
Posted in Analysis Services on November 18, 2008 | 70 Comments »
With the release of the SQL Server 2008 Analysis Services, there is the new and improved version of the Usage-based Optimization algorithm. The best practices and recommendations to use this feature can be found out this recently published technical note Reintroducing Usage-Based Optimization in SQL Server 2008 Analysis Services. Enjoy!
The Many Benefits of Money…Data Type!
Posted in Analysis Services, tagged Data Types on October 1, 2008 | Leave a Comment »
Check out the latest technical note on the the many benefits of Money data type. Admittedly, it’s one of my dorkier papers but hopefully you can enjoy it, eh?! Check it out at: http://sqlcat.com/technicalnotes/archive/2008/09/25/the-many-benefits-of-money-data-type.aspx
Great Data Mining resource
Posted in Analysis Services on June 2, 2008 | 33 Comments »
To learn more information about Data Mining, check out the Rafal Lukawiecki’s TechNet Spotlight at: http://www.microsoft.com/emea/spotlight/event.aspx?id=99 Data Mining and Business Intelligence for Enterprises In this one-day seminar, Rafal Lukawiecki aims to show IT Professionals how data mining can be used in IT infrastructure to support real business scenarios demystifying the perception that Data Mining [...]
Hadoop on Azure
Professional Microsoft PowerPivot for Excel and SharePoint
-
Recent Posts
-
Top Posts
- Update SharePoint 2010 Farm Credentials Tips
- SQL BI at Hadoop Summit = Awesomesauce!
- How to Connect Report Builder 3.0 to a SQL Server 2012 PowerPivot workbook
- SSIS global variables and execute process task
- Troubleshooting #PowerPivot Excel Services connectivity
- Failed to provision the SharePoint Central Administration Web Application
- MDX: Count number of dimension members
- Installing Hadoop on OSX Lion (10.7)
- Connecting PowerPivot to Hadoop on Azure – Self Service BI to Big Data in the Cloud
- Create a #PowerPivot report filtered by the Top X Users by <Logic> (Part 1 of 3)
Categories
Tags
Archives
- May 2012
- March 2012
- February 2012
- January 2012
- December 2011
- November 2011
- October 2011
- September 2011
- August 2011
- July 2011
- June 2011
- May 2011
- March 2011
- January 2011
- November 2010
- October 2010
- September 2010
- August 2010
- July 2010
- June 2010
- May 2010
- April 2010
- February 2010
- January 2010
- December 2009
- November 2009
- October 2009
- September 2009
- July 2009
- May 2009
- April 2009
- February 2009
- January 2009
- December 2008
- November 2008
- October 2008
- July 2008
- June 2008
- April 2008
- February 2008
- December 2007
- November 2007
- October 2007
- September 2007
- August 2007
- July 2007
- June 2007
- May 2007
- December 2006
- November 2006
- May 2006
- April 2006
- March 2006
- February 2006
- January 2006
- November 2005
- October 2005
- September 2005
- June 2005
@dennylee
- #SQLBI at @HadoopSummit = #Awesomesauce ! wp.me/pHDEa-gH #Hadoop #BigData #SSAS 8 hours ago
- “@HuffingtonPost: Self-help lessons from a two-year-old huff.to/LtzjJi” > yes, I shall do it! 1 day ago
- wow “@mpanzarino: “@asymco: Apple sells its inventory every 5 days. Second fastest only to McDonald's. asym.co/KQnooc” That's nuts.” 2 days ago
- Thank (not evict) our soldiers! “@nytimes: The Appraisal: Afghanistan Veteran Could Lose Home Over Service Dog nyti.ms/KK7Ruc” 2 days ago
- Get it! “@tom_e_white: It's out. #Hadoop: The Definitive Guide, 3rd Edition. oreil.ly/LXTfdT What's new: bit.ly/LXTiWY” 2 days ago
Copyright
