Monthly Archives: June 2013

Version Control for SSRS

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 … Continue reading

Posted in SQL Server | Tagged | Comments Off on Version Control for SSRS

Tautological expressions

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. … Continue reading

Posted in SQL Server | Tagged | Comments Off on Tautological expressions

When will reporting services support c#?

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 … Continue reading

Posted in SQL Server | Tagged | Comments Off on When will reporting services support c#?

Canada is retiring the penny

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 … Continue reading

Posted in SQL Server | Tagged | Comments Off on Canada is retiring the penny

TSQL – how to send try catch errors through sp_send_dbmail

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 … Continue reading

Posted in SQL Server | Tagged | Comments Off on TSQL – how to send try catch errors through sp_send_dbmail

Why upgrade office?

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, … Continue reading

Posted in SQL Server | Tagged | 3 Comments

Data Warehouse Developer | Gorge Networks – Jun 2013 – Present

SQL Server Analysis Services / Cubes / Olap Dimensional Modeling Operational Data Store Datamart design / development

Data Warehouse Developer | Gorge Networks – Jun 2013 – Present was originally published on CareerDba.com

Continue reading

Posted in DataMart, ETL, Experience, OLAP, SSAS, SSIS | Tagged , , , , | Comments Off on Data Warehouse Developer | Gorge Networks – Jun 2013 – Present