Installing Gitblit on CentOS
Gitblit is an open-source Java tool with a single-stack solution to manage Git repositories. This post will cover how to install Gitblit on CentOS.
Windows Authentication for SQL Server Connection
The Talend Studio expects a SQL Server user for connection details. An extra configuration step is required using the NTLMAuth library to use Windows Authentication (Active Directory).
Canceling FreedomPop Premier Service
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.
Bootable Windows 8 USB Drive
This article had by far the most simple process to create a bootable Windows 8 USB drive. Create Windows 8 Bootable USB
Resolving javaw.exe is not recognized With Squirrel SQL Client
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
using temporary tables inside if block with a procedure
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.
sheet name formatting for openrowset excel access
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$)SELECT * FROM OPENROWSET(‘Microsoft.ACE.OLEDB.12.0’,… Continue Reading
application vs database side filter efficiency
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.
Importing CSV with optional double quote text qualifier
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.
The case for ISNULL
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