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

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

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