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

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