Re:Top Reasons I like Postgres Over SQL Server
by codeulike on Monday April 08, 2013 @02:42PM
(#5513633)
A quick plug for my open-source alternative front end for SSRS - CrissCross
https://github.com/codeulike/crisscross
It uses the standard report viewer but aims to handle multi-pick parameters and reports with lots of optional parameters more intelligently.
Re:Top Reasons I like Postgres Over SQL Server
by xradionut on Monday April 08, 2013 @04:38PM
(#5514408)
"They both have their place. In SQL Server land the things that they limit to enterprise edition generally are functions that only really benefit data warehouses (partitioning and compression being two of the most obvious), and given that they know that the people who use data warehouses tend to have warehouses of cash, it comes with a cost."
Redmond could throw column level encryption into the lower tiers as a security measure, but oh, no!, that's "enterprisy".
Re:Top Reasons I like Postgres Over SQL Server
by crescentfresh on Monday April 08, 2013 @06:40PM
(#5515149)
> end users aren't hitting SSRS' interface directly
They'll hit the rendered output though. Which in HTML4.0's case is horrid (at least in 2008).
The comment about "thrown together by an intern" seems suspect (though not as much as criticizing SQL Server for defaulting to data integrity. If ever there was a non-complaint, that is it). I've been using SQL Server since 6.5, and generally find the toolset to be excellent, and anything other than "thrown together" (quite contrary, the product moves far slower than I would prefer).
They both have their place. In SQL Server land the things that they limit to enterprise edition generally are functions that only really benefit data warehouses (partitioning and compression being two of the most obvious), and given that they know that the people who use data warehouses tend to have warehouses of cash, it comes with a cost.
Worth noting that SQL Server has had clustered indexes forever -- psql still has a rather hacked variant of it -- along with materialized views. Both are of tremendous value to web developers. Far more valuable than the default transaction isolation level.