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

Openrowset fails with "network access was interruped"

›
A SQL Server openrowset query using ODBC to retrieve data from an Excel spreadsheet fails with the error: "Your network access was in...

Packing intervals

›
Solution to the "packing intervals" problem by Itzik Ben-Gan: http://www.solidq.com/sqj/Pages/2011-March-Issue/Packing-Intervals....

Execute query under cursor

›
There is no way in SQL Server Management Studio (SSMS) to execute the query under the cursor. There is the option to execute the entire scri...

Count of weekend days in date range

›
Use the formula in "calc_name" or "calc_df" to calculate the number of inclusive weekend dates in a date range. Inclusiv...

Quipu JDBC connection to MS Access

›
There are several ways to connect to a MS Access database from Java, like the low-level MS Access library called Jackcess: http://jackcess.s...

Uninstall Microsoft Security Essentials

›
Microsoft Security Essentials can be uninstalled from Windows 7 as follows: Download the installer from the Microsoft website (currently: ...

Flash 11.4 in SRWare IronPortable v22

›
To get Flash support in the portable version of Iron v22: Start IronPortable and type "about:plugins" in the URL bar Scroll to ...

Stop Outlook from reformatting telephone numbers

›
A telephone number gets reformatted when adding it to a contact in Outlook, e.g. "+31.." becomes "31". This behaviour ...

Epson AL-C900 with empty color toner

›
The Epson AL-C900 Aculaser has a default setting that makes it impossible to continue printing if one of the color toners/consumables is e...

MS Access DSN-less connection

›
It is possible to create a DSN less linked table and/or pass-through query from Microsoft Access to SQL Server Express without deleting th...

PALO backend is unavailable

›
You might get an "backend is unavailable" error when connecting to the PALO server from an internet page. Check the %SYSTEMDRIVE...

Bamboo Pen & Touch supported driver not found

›
If you try to start the Wacom Bamboo Preferences application, but get an error message displaying "a supported tablet could not be foun...

Oracle OLE DB source in SSIS

›
An OLE DB source to Oracle can be added to a SSIS package. Example data Server : locksnlatches.mydomain.com Oracle instance/SID : dwh ...

Reference SQL Server table with spaces from Oracle

›
It is possible to select data from a SQL Server table that contains spaces by using a database link from Oracle. The syntax is as follows:...

Query Oracle from SQL Server

›
Start with the following steps: Install the Oracle Instant Client (OIC) on the machine where SQL Server is running and add the ...

Power view on analysis services tabular

›
How to create a Power View report using Sharepoint 2010 and Analysis Services 2012 Tabular as the data source? 0) Prerequisites A server ...

Annoying search engine abroad question

›
Google Chrome asks you if you would like to use another omnibox search engine when you move from one country to another. When you move acros...

Quipu connections

›
Several ways to create a database connection in the open source data warehouse generator Quipu . SQL Express SQL Server configuration mana...
1 comment:

Live calendar displays incorrectly in Chrome

›
At last the Windows Live calendar displays appointments correctly again in the latest Google Chrome beta release, 14.0.835.2. They fixed the...