I absolutely LOVE this functionality, I wish that Microsoft provided this as a built-in option! The Problem Reporting and business intelligence have become both vital to, and distributed throughout, our businesses. The demand for new and different reports continues to climb rapidly. With SQL Server Reporting Services (SSRS) starting in version 2008R2, Microsoft attempted to […]
Tautological expressions The word tautology was used by the ancient Greeks to describe a statement that was true in every possible interpretation merely by virtue of saying the same thing twice. For instance, “tables are tables” is a tautological statement. Tautological expressions are always true, so that they can safely be short-circuited without changing the […]
I still use vb on a daily basis.. Primarily because there are three or four places in SQL server that don’t support c#. When will Microsoft provide functionality that we can write functions for reporting services in c#? Twelve years ago we had one language for asp, dhtml, office, SQL server and batch files. How […]
just a quick note.. I’m having panic attack over the implications of this Canada Getting Rid Of Pennies merchants are supposed to round up or down-so if you buy something priced at 52 cents, it will cost 50 – and if it’s 53 cents, it will now cost 55. http://www.vpr.net/news_detail/97396/canada-getting-rid-pennies/ Did I mention that I […]
I had a bit of a problem trying to get the results from an error into an email. Had to share my experience.. Please let me know if you know of a better / easier method. Finally figured out that I had to push the error values in as constants. SET @Query = ‘SELECT ‘ […]
Why would companies spend thousands of dollars on upgrading ms office when it doesn’t support SQL server any longer ? The retirement of ADP means I will still be using office 2010 ten years from now. Linked tables are dumb, sharepoint is dumb. It’s time for something better than jet, Microsoft !!
SQL Server Analysis Services / Cubes / Olap Dimensional Modeling Operational Data Store Datamart design / development