Jul26
Right after I published my post Analysis Services and Storage Options, I noticed one of my bookmarks that might be interesting to those of you out there looking at more frequently updated Analysis Services scenarios.
It is a whitepaper by Paul Sanders published in April of 2005 titled Real-time Business Intelligence Using Analysis Services.
For anyone considering low latency BI, particul...
Posted by Sidney Atkinson on
Saturday, 26 Jul 2008 04:58.
Jul26
I received an e-mail from a friend at one of our clients asking about storage options for their Analysis Services 2005 cube and what was the best for their scenario. Apparently he had just been to a presentation and he walked away confused over the argument for/against the ROLAP storage method and where it should be used.
His confusion lay in the fact that the speaker kept referring to the ad...
Posted by Sidney Atkinson on
Saturday, 26 Jul 2008 04:24.
Jul10
.NET makes it incredibly simple to build a site, and for new programmers, it can sometimes provide an unwarranted warm feeling that they are coding to an enterprise standard just by implementing certain aspects of the Enterprise Library, or properly tier-ing their application.
However, all is not well with the web world, as most of well know; many, many sites are exposed to basic SQL injec...
Posted by Sidney Atkinson on
Thursday, 10 Jul 2008 04:19.
Jul6
I love tools that make my job easier; I particularly love when those tools are free.
One fantastic example is ClearTrace. Though it is simple in design, its purpose and use are clear: analyzing trace output for SQL Server 2005 performance issues. I have used this application numerous times and in many different scenarios.
There have been two scenarios in particular where ClearTrace came ...
Posted by Sidney Atkinson on
Sunday, 6 Jul 2008 04:19.
Jul6
With prices for solid state media dropping seemingly month over month, it will not be long before we start seeing solid state media being used regular SQL Server implementations and not just edge cases or leading adopters.
If you subscribe to SQL Server Magazine, then you can access Levon Peters article in the June 2008 publication.
Texas Memory Systems is a professional provider of solid s...
Posted by Sidney Atkinson on
Sunday, 6 Jul 2008 04:15.