Helpful Lessons & Snippets

Finding Stuff in SQL Server

Sep 13, 2017Mark DoyleHelpful Lessons & SnippetsSQL Server, T-SQL

One of the many hats I wear as a software consultant is that of database developer. Part of that entails the discovery of where data is stored, or how it integrates with existing software systems. For example, suppose you need to find any reference to social security number in your client’s database. You’d need to […]

A Pain in the MAS

Mar 18, 2014Mark DoyleHelpful Lessons & Snippets.NET, MAS, ODBC, SQL

I recently completed a small project for a client that involves printing barcodes (easy), but required exporting sales order data from their Sage accounting software, MAS 90 (not so fun). Specifically, I had to write a .NET application to export the data, which queried the MAS 90 database with ADO.NET and ODBC. So, I am […]

Enter your email Address

Category: Helpful Lessons & Snippets

Finding Stuff in SQL Server

A Pain in the MAS