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 or less acknowledging that once trying to solve a problem purely in SQL exceeds a […]

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. So I decided to try it on ReportServerTempDB. I used amd.com/ramdrive and setup a 4gb […]

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 properties. These sections explain how to retrieve those properties. Join Compatibility Explains compatibility issues when […]

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, and any company not using olap is stupid. I just wish that Microsoft would include […]

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 reports, and quickly answers analytical questions to improve traditional reporting scenarios. (33 printed pages) Download […]

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 Hutchinson Compared to other advanced countries, high-speed Internet access in the US is in notoriously […]