Category Archives: SQL

Case of the SQL vs Access Sort Order

A legacy ACCESS database had data migrated from an Access 2000 database application into SQL Server, I needed to migrate some code outside Access to .NET platform. However I came across an issue when executing certain SQL Queries from .NET … Continue reading

Posted in .NET, Microsoft Access, SQL | Tagged , | Leave a comment

Case of the SCCM 2012 Application Catalog Communication Breakdown

Installing SCCM 2012 SP1 and Application Catalog feature in test environment went without a hitch. However when installed into production server the catalog site was throwing an error Cannot connect to the application server The webserver cannot communicate with the … Continue reading

Posted in IIS, SCCM, SQL | Tagged | 2 Comments