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

Configure Reporting Services proxy for Bing maps

›
Add the following XML element to the web.config of both folders: ...\MSSQL\MSRS11.MSSQLSERVER\Reporting Services\ReportManager\ ...\MSSQL\...

Change records per page in Master Data Services

›
To change the number of records/rows per page in the Explorer view of Microsoft Master Data Services (MDS), do the following: Select an en...

Cannot map network drive to Sharepoint library

›
Example error: "Your client does not support opening this list with Windows Explorer" Steps to check beforehand: Add Sharepoin...

Unable to read exported Excel workbook because of illegal character

›
After exporting from reporting services, Excel opens the workbook with one of the following errors: "Replaced Part: /xl/worksheets/sh...
1 comment:

OCR a (region of a) PDF using C# and "freeware"

›
Perform the following steps: 1) Install Ghostscript to make conversion of PDF possible: https://code.google.com/p/ghostscript/downloads/l...

Analysis Services fails with "attribute key cannot be found" on Unicode field

›
ERROR The attribute key cannot be found when processing: Table: 'dbo_viu_isb', Column: 'city', Value: '　'. The attr...