Transact-SQL Server – Transposing a table

The Problem A client sent me an excel sheet with financial information classified in columns where each column header was a date and the values associated with that date were listed below I needed to insert the information to a normalized table with the following columns: Client Account EntryDate Value The Solution Step 1 Loaded … More Transact-SQL Server – Transposing a table

Books every software developer should read in 2016 – if you have not done so

The obligatory reflection on what have we accomplished in 2015 … always a sticky question. But if keep it to my book, training and research, it does not look that bad, I managed to keep the momentum going. Software Development Cracking the coding Interview – Gayle Laakman This is a great book with brain teasers and … More Books every software developer should read in 2016 – if you have not done so

Registering .Net DLLS’ for use in VB6 32bit Applications

Registering .Net Dlls’ for use in VB6 32  or VBA applications You have that legacy application that is not willing to go away and you need to use functionality from code you created in .Net. or you need to build extra functionality on a .Net classYou need to register the dll for VB6/VBA  to be … More Registering .Net DLLS’ for use in VB6 32bit Applications