If you aren’t going to be using the FreedomPop Premier Service, or you’re done with the trial, you can easily cancel this service through your online account.
This article had by far the most simple process to create a bootable Windows 8 USB drive. Create Windows 8 Bootable USB
I recently downloaded and installed SQuirreL SQL Client 3.5.0. The client would not launch through the shortcut created by the installer. A command prompt window would flash briefly. I tried running squirrel-sql.bat through command prompt and was receiving the error:… Continue Reading
In a procedure I wrote, I wanted to allow the flexibility to support various types for a flat-file. This required an IF…ELSE block. Inside the block, the data would be imported, scrubbed, and loaded into a temporary table.
I had difficulty finding any documentation for formatting the sheet name when using the OLEDB ACE engine to access an Excel file. I had originally attempted the following query: SELECT * FROM OPENROWSET(’Microsoft.ACE.OLEDB.12.0′, ‘Excel 12.0;HDR=YES;Database=C:\Report Output.xlsx’, sheet1$) This raised the… Continue Reading
Built-in database functions allow for efficient filtering. This post will demonstrate that a simple date filter on the database side is almost twice as fast as filtering the result set on the application side.
In this post, I hope to show how to load in a CSV (comma-separated values) flat-file with an optional double quote (“) text qualifier and a XML format file using BULK INSERT and OPENROWSET.
Recently I wrote a function for a report with a CASE block to take in a start and end date, and if the end date was NULL, to use the start date. WHERE theDate BETWEEN @dateStart AND CASE WHEN @dateEnd… Continue Reading
This post will explain the process of copying a virtual machine instance from one host computer to another using Oracle’s VM VirtualBox with Windows 7.
One of the most common problems I come across is users not being able to resolve a basic SQL syntax error thrown in MySQL. You have an error in your SQL syntax; check the manual that corresponds to your MySQL… Continue Reading