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.
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).
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