April 5, 2016

Black box vs. White box Testing

When building, developing and troubleshooting complex systems everybody agrees that modularity is the way to go. Different parts or components need to interact only through well-defined interfaces. This way the complexity of each component can be reduced to its inputs and outputs. That’s the theory. In practice, this is extremely

White House Proposal Promotes Open Source Software

The White House has published a new proposal titled “Federal Source Code Policy ? Achieving Efficiency, Transparency, and Innovation through Reusable and Open Source Software,” which calls on government agencies to publish their internally developed software under open source licenses. More specifically, agencies covered by the policy will need to

Importing Data from Excel into SQL Server

A very quick way to import data from Excel into SQL Server through code is to execute the following query: SELECT * FROM OPENROWSET(‘Microsoft.ACE.OLEDB.12.0′,’Excel 12.0;Database=C:ExcelFileToImport.xlsx’, [SheetWhereDataIsLocated$]) This is known as a Distributed Query where the connection is not persistent but rather only a quick ad hoc way of obtaining access