IBM Informix 64 bit ODBC connection

›
Creating a 64-bit ODBC connection for IBM Informix is a bit tricky. By default, only the 32-bit drivers are installed, so a x64 DSN cannot b...

Raspberry Pi 2 Kodi storage on USB using UUID

›
A default OpenELEC or OSMC MMC/SD-card contains two partitions: A FAT32 partition with the kernel and system file and a cmdline.txt file t...

Videos starting slow from SMB share

›
What is written below does not work , because the function that scans for local subtitle files in the movie folder is hard-coded to always r...

Create RSS feed from Microsoft Live Calendar and Google Calendar

›
In Microsoft Calendar : Click "Share" on the top menu bar and select the calendar to share Under Share, click Get link. If this...

Create script for deploying database roles and rights

›
The script below returns the create statements for all roles in a database. It also creates the statements that add the role members to the ...

Reporting Services in SQL Server 2016

›
Installing SQL Server 2016 CTP2 (Community Technology Preview) to test Reporting Services (SSRS) is a bit of a deception: the installer does...

Analyzing string or binary data would be truncated error

›
Based on the ideas in this post, I've made an improved and dynamic version to help in determining the violating records when inserting i...

Install Epson AcuLaser AL-C900 on Windows 8

›
The Epson C900 AcuLaser can be easily installed on Windows 7 x64 and before using the Vista x64 driver available from the Epson website. In ...
1 comment:

PS3 controller on Windows 8.1 via bluetooth

›
A PS3 Sixaxis controller can be used as an input device on Windows 8.1. For this to work the free Motion In Joy (MiJ) application needs to...
7 comments:

Reporting Services dynamic multi-column parameter box

›
The Reporting Services parameter section at the top of a report is generated as a HTML table with two fixed columns. To display SSRS paramet...
2 comments:

Reinstall OEM-installed Windows 8.1

›
One of the first steps of the re-installation process of Windows 8.1 is that it asks for a Windows key. There is a "bug" that pre...

SQL Server contained database feature

›
SQL Server 2012 has a "contained database" feature. In the normal case the logins of the (SQL Server) server are coupled to the ...

PowerPivot cannot load from procedure with info messages

›
Data can be loaded into PowerPivot from a SQL Server stored procedure, but the procedure cannot contain: PRINT statements, like print ...

LISTAGG / implode solution for SQL Server

›
Group multiple records into one and concatenate the values of the string/text values of a field: ALTER view [dbo].[vcomments] as with x a...

Query Active Directory from SQL Server

›
Get active directory server and LDAP servers in a domain nltest /dclist:sub.dom.com results amongst others in: \\dcserver1.sub.dom.com -...

Create schema with separate autorization

›
Perform the following steps in SQL Server to create a schema called "bi" and give create view rights to user "domain\testuser...

Pass table-valued parameter from VB.Net

›
1) Create table type itemtabletype for a table with one, unique clustered column called "item": create type itemtabletype as t...

IsNumeric() stinks

›
Read the thoroughly insightful and funny post by Mike Teevee as a reaction to the technet documentation with regards to the useless ISNUMERI...

Silverlight not working because of font issue

›
If Silverlight is installed correctly, but still not working, check for Windows Fonts with an ampersand in the name and remove them: http:...

Uneasy way to determine proxy server

›
Open a command prompt and perform the following steps: Inspect the output of netstat -an | find "EST" (short from 'ESTAB...