Monthly Archive: December 2009


Disable Digital Driver Signing in Windows 7

When you try to install some device drivers on Windows 7, you might come across a warning message that those drivers should be digitally signed. You can get disable this driver signing warning message...


Digital Photography Printing Workflow

If you have not already installed the profile(s) on your system, you need to do so before proceeding. Open the image in Photoshop. Note: If you are presented with a profile mismatch dialog, select...


Open a Delimited Text file using OPENROWSET and OPENDATASOURCE

SELECT * FROM OPENROWSET (‘MSDASQL’, ‘Driver={Microsoft Text Driver (*.txt; *.csv)}; DefaultDir=C:\Users\Kevin\Downloads\zcugoem;Extended properties=”ColNameHeader=True;Format=Delimited;”’, ‘SELECT * FROM ZCUGOEM.TXT’); or SELECT     * FROM   OPENDATASOURCE(‘Microsoft.Jet.OLEDB.4.0’, ‘Data Source=E:\SQL\;Extended Properties=”Text;HDR=No;FMT=Delimited”‘)…[ZCUGOEM#TXT]