Monthly Archives: October 2012

I think that most logic should live in the database

http://programmers.stackexchange.com/questions/171024/never-do-in-code-what-you-can-get-the-sql-server-to-do-well-for-you-is-this   “Never do in code what you can get the SQL server to do well for you” – Is this a recipe for a bad design? It’s an idea I’ve heard repeated in a handful of places. Some more … Continue reading

Posted in SQL Server | Tagged | Comments Off on I think that most logic should live in the database

Office 2013 looks like a worthless upgrade!

Not so good – Still no PowerView for Multidimensional? As far as I can see there’s still no way of connecting PowerView to SSAS multidimensional cubes. I have an unpleasant gut feeling tickling me that all hope is lost on … Continue reading

Posted in SQL Server | Tagged | Comments Off on Office 2013 looks like a worthless upgrade!

ReportServerTempDb should live on www.amd.com/ramdrive

I have long been amazed how slow Reporting Services runs. It’s just ‘not greedy enough’ when it comes to Ram. I read about amd.com/ramdrive the other day.. I was pretty interested in it when I first found out about it. … Continue reading

Posted in SQL Server | Tagged | Comments Off on ReportServerTempDb should live on www.amd.com/ramdrive

Advanced MDX

http://msdn.microsoft.com/en-us/library/windows/desktop/ms709821(v=vs.85).aspx   The sections described in the following table explain MDX statements in detail. Topic Description The MDX Statement Contains a complete description of the construct. Retrieving Member Properties and Retrieving Cell Properties Dimension members and cells both have associated … Continue reading

Posted in SQL Server | Tagged | Comments Off on Advanced MDX

http://www.wired.com/wiredenterprise/2012/10/salesforce-oracle/

I detest Oracle, it is a halfwit database for morons. My first job outta college, I had six Oracle dev/dba at this HP funded startup, and they couldn’t do simple ecommerce. I just think that Microsoft olap owns the market, … Continue reading

Posted in Access, SQL Server | Tagged | Comments Off on http://www.wired.com/wiredenterprise/2012/10/salesforce-oracle/

Integrating Analysis Services with Reporting Services

http://msdn.microsoft.com/en-us/library/aa902647(v=sql.80).aspx SQL Server 2000 9 out of 19 rated this helpful – Rate this topic Sean BoonMicrosoft Corporation June 2004 Applies to:Microsoft SQL Server 2000 Summary: Create a compelling solution for your customer that defines and manages great-looking Analysis Services … Continue reading

Posted in SQL Server, Visual Basic | Tagged | Comments Off on Integrating Analysis Services with Reporting Services

UltraFast ASP.net

I have a chapter in my book about integrating SSAS with web sites as a way of offloading SQL Server: Ultra-Fast ASP.NET. My code examples use ADOMD; I also walk through building a simple cube, configuring automatic updates with SSIS, … Continue reading

Posted in SQL Server | Tagged | Comments Off on UltraFast ASP.net

Why I pay extra for "business-class" broadband at home

http://arstechnica.com/information-technology/2012/10/why-i-pay-extra-for-business-class-broadband-at-home/   No data caps, no blocked ports, and better support are pretty darn compelling. by Lee Hutchinson– Oct 15 2012, 5:00am PDT Information Technology Productivity 159 Why I use business class Internet—a pic of my home server closet. Lee … Continue reading

Posted in SQL Server | Tagged | Comments Off on Why I pay extra for "business-class" broadband at home

Ramdisk

I’ve been playing around with this RAMDISK product from AMD.. I absolutely love it!! www.amd.com/ramdisk

Posted in SQL Server | Tagged | Comments Off on Ramdisk

Escaping The Walled Garden of Enterprise Analytics: Using R and Python For Data Analysis

http://www.marginhound.com/escaping-the-walled-garden-of-enterprise-analytics-using-r-and-python-for-data-analysis/

Posted in SQL Server | Tagged | Comments Off on Escaping The Walled Garden of Enterprise Analytics: Using R and Python For Data Analysis