Reference parameter values in a text box without parameter fields.

You can add the parameter value of a parameter to a text field in you report but after adding you get next content in the text box:

[ERVCountries].[Country].&[Netherlands]

You only want to have: Netherlands

Solution: Change the reference expression to use .Label instead of .Value.
In this example use:

=Parameters!ERVCountriesCountry.Label(0)

To display multiple parameter values you an use next syntax:

="My own text: " + Join(Parameters!Country.Label,", ")
For more details about displaying multi value parameters click here for a more detailed blog post

The selected Subscriber does not satisfy the minimum version compatibility level of the selected publication

The error message as mentioned in the title: 'The selected Subscriber does not satisfy the minimum version compatibility level of the selected publication' , can occur when you are setting up a subscription from a SQL 2008 R2 publisher to a SQL 2012 subscriber using SQL Server Management Studio (SSMS) version of SQL 2008 R2.
This error is caused by SSMS.

Solution:
Use the SSMS version of SQL 2012, now you are able to setup the Subscription from a SQL2008 R2 publisher to a SQL 2012 subscription.

TSQL statement of running queries

In a SQL production environment it can happen that you see heavy transactions. With next query you can retrieve the TSQL statement of a process you see in master..sysprocesses.

SELECT Text,hostname, program_name, nt_username,*
FROM Master..sysprocesses
CROSS APPLY sys.dm_exec_sql_text (sql_handle)
WHERE Spid > 50

You can extend the WHERE clause with SPID = XX or something else you wnat to filter on.

What is the server mode of an Analysis Services instance?

In SQL Analysis Service  2012 (SSAS) a new server mode is introduced, the tabular mode. This mode is available when you are installing SQL 2012 Enterprise edition or Business Intelligence edition. More details about edition features click here. To deploy a tabular model, for instance a Power Pivot tabular model which you have converted to an SSAS tabular model, you need to have a SSAS server which is running in tabular model. In this blog I will describe how you can detect the mode in which your SSAS server is running.
The model in which the SSAS server is running is determined during the installation of the SSAS server. The model can't be changed afterwards.

To retrieve the Server mode on a running server, Start SQL Management Studio 2012. You can't use a lower version of SSMS like 2008 R2. These lower versions are not aware of this new SSAS modes.
Connect to Analysis Server. Retrieve the Analysis Server properties.