Latest Articles

Live Action: Apache Hadoop and SQL Server Connector

Summary: Watch Hadoop and SQL Server in action! Here are a few quick thoughts: Hadoop is a real solution for ‘Big Data’ Cloudera is making Hadoop accessible for solution developers Microsoft’s Hadoop connector SQL Server works with minimal effort Having Hadoop and SQL Server connected offers some great prospects. For me its being able to develop solutions [...] Read more – ‘Live Action: Apache Hadoop and SQL Server Connector’.

SpeedTracePro: Debugging an ASP.Net stack trace

SpeedTracePro has saved me tremendous time. When I’m trying to debug 3rd party code and my own modules there is no substitute. Specifically, this tool has helped me develop solutions which required using entirely undocumented and unsupported libraries. The application when started, attaches to a running program (IIS) and does a full record of the [...] Read more – ‘SpeedTracePro: Debugging an ASP.Net stack trace’.

Date and Time for Multi-Dimensional Analysis

If you’re a developer building multi-dimenional databases you’ll need a good date/time dimension. Here is one I like to use when developing and had great user experiences with accountants and auditors. via SqlServerCentral.com SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS OFF GO ALTER FUNCTION fn_TimeDimension(@StartDate datetime, @EndDate datetime) RETURNS @TimeDimension TABLE ( [TimeKey] integer NOT NULL, [...] Read more – ‘Date and Time for Multi-Dimensional Analysis’.

All Articles