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

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