MSSQL Select Not Null

I mainly use MySQL these days, so get screwed over for a few minutes when I have to do something in MSSQL that is slightly different when it comes to it’s custom syntax. If you want to show all entries in a specific column and where it is not Null Read more…

By Andrew Odendaal, ago

ODBC SQL Server Memory General Network Error

Microsoft OLE DB Provider for ODBC Drivers error ‘80004005’ [Microsoft][ODBC SQL Server Driver][Shared Memory]General network error. Check your network documentation. /site/path/to/script/aspfile.asp, line # ..and that’s what it throws you! At about this point you may want to scream, or just be a tad annoyed by that damn machine running your Read more…

By Andrew Odendaal, ago

Why we don't choose MSSQL!

Everybody always raves how great Microsoft SQL Server is, and how much data it can hold, and how much bigger it’s “package” is than your own. But the truth is that I hate it with a passion! I use RDBMS‘ on a daily basis and never used to hate MSSQL Read more…

By Andrew Odendaal, ago