The unit in unit-testing

Interpreted extremely, unit testing means testing each class separately. However, complete isolation is difficult to achieve given that a class typically interacts with other classes in most applications, and for this definition of the unit to be upheld, collaborating classes have be faked during testing. But, using mocks for this purpose, developers confront two problems …

Learning BASE64 encoding

BASE64 encoding is so prevalent that it is worth learning how it works and how to code your own implementation. The point of BASE64 is to communicate binary data as text, using only characters that are likely to exist on most computer platforms. These safe characters are known as the BASE64 alphabet and are the letters …

How we use SQL Server Data Tools

This post describes the process that we use to develop databases with SQL Server Data Tools (SSDT) in Visual Studio. For this process to work, the conventions below must be respected. Use the live database as the gold standard for schema objects (and data). Deploy only database projects that have been built successfully. Deploy to a database that matches …