Tableau – Public Edition – Installation

Background One of the Database Reporting tool we use at work is Tableau. Wanted to take another look at it. Found out that since the last time I looked at it, they have added a Free Edition; it is called Public. Artifacts The public edition is available for download here. Installation Installation is straight forward. … Continue reading Tableau – Public Edition – Installation

Microsoft – WCF/OData – Deploying Services to IIS

Introduction There are a couple of paths we can take towards deploying our web services. Prerequisite - Msdeploy Introduction I really enjoyed realizing the benefits of Microsoft MSDeploy.  It allows us to deploy to the local server and to remote hosts, as well. Here is a list of arguments that are supported:  Argument  Meaning /T … Continue reading Microsoft – WCF/OData – Deploying Services to IIS

Technical: Microsoft – SQL Server – Compare Database Object Schema / Specifically Column Types

Introduction Another Day, Another broken build courtesy of Daniel. Don't understand this ORM Life; everything has to be so nicely synced - The Database Objects, the edmx file, etc. Broken Object So what did I break today!  A database view.  What broke - One column allows null, the other does not. Stored Procedure Here is … Continue reading Technical: Microsoft – SQL Server – Compare Database Object Schema / Specifically Column Types

SQL Server / Internet Information Server (IIS) – OData – Service – Error Logging

Background As a follow-up to Technical: Microsoft - SQL Server / Internet Information Server (IIS) - OData - Service ( https://danieladeniji.wordpress.com/2013/07/30/technical-microsoft-sql-server-internet-information-server-iis-odata-service/ ) , let us discuss error logging. Impetus The impetus to explicitly address error logging was seeded by this error message: Screen Shot Text The server encountered an error processing the request. See server logs for more … Continue reading SQL Server / Internet Information Server (IIS) – OData – Service – Error Logging

Microsoft – SQL Server / Internet Information Server (IIS) – OData – Service

What is OData? Here is a buzzword compliant definition for OData http://www.odata.org/introduction The Open Data Protocol (OData) is a Web protocol for querying and updating data that provides a way to unlock your data and free it from silos that exist in applications today. OData does this by applying and building upon Web technologies such as HTTP,Atom Publishing … Continue reading Microsoft – SQL Server / Internet Information Server (IIS) – OData – Service