Monthly Archives: December 2009

Overflow error on SQL/Oracle/DB2 Databases

Like OS’s and development frameworks, each database type out there has its own set of error codes when something goes wrong. For calculations/dates and times an Arithmetic Overflow error can be common. Error depending on Database:

Posted in Database | Tagged , , | Comments Off on Overflow error on SQL/Oracle/DB2 Databases

Debug BSOD from memory.dmp without a development platform.

The application I use and starting to love outside of just using Visual Studio or any other C++ debugger is WinDbg. One of the things that make this application great is that it is free. So if your parents are … Continue reading

Posted in Windows | Tagged , | Comments Off on Debug BSOD from memory.dmp without a development platform.

Convert text to upper case

Just a small post because this really annoyed me today when I had to use excel for the first time in a year. I had a client that used an import tool to import data into a database. Well for … Continue reading

Posted in Office | Tagged , | Comments Off on Convert text to upper case

Getting SQL Azure connected through a corporate network.

Most medium to large companies out there have some sort of high end corporate firewall. We use IAS/NPS (Internet Authentication Service/Network Policy Server), different name depending on which flavor of windows server you are running.

Posted in Azure, Database | Tagged | Comments Off on Getting SQL Azure connected through a corporate network.