March 2013 Cumulative Updates – SQL Server 2012 SP1 & 2008 SP3

Aaron Bertrand, thanks to the heads up 🙂

March 2013 Cumulative Updates – SQL Server 2012 SP1 & 2008 SP3

Cumulative update package 3 for SQL Server 2012 Service Pack 1
Cumulative update package 10 for SQL Server 2008 Service Pack 3

SQL Server 2012 Service Pack 1 Cumulative Update #3
Build # 11.0.3349
KB Article: KB #2812412
38 fixes!
Relevant for builds 11.0.3000 -> 11.0.3348
NOT for SQL Server 2012 RTM (11.0.2100 -> 11.0.2999)

SQL Server 2008 Service Pack 3 Cumulative Update #10
Build # 10.00.5835
KB Article: KB #2814783
8 fixes
Relevant for builds 10.00.5500 -> 10.00.5834
NOT for SQL Server 2008 R2 (10.50.xxxx)

Advertisements

Interactive PowerPivot Dashboard (custom map visualization)

I’ve found this great example of an interactive PowerPivot worksheet by Robert Mundigl about the beer prices at Munich’s Oktoberfest.

PowerPivot-interactive-map-layout

How it works?
Actually it’s about the same technic as Kay Unkroth used earlier in one of my previous posts.
Well…here’s how Robert did it!:

PowerPivot-interactive-map-how-it-works

Have a look at Robert Mundigl‘s blogpost and his tutorial: Click here.

The example is also downloadable via this URL.



Join us at LinkedIn!
Don’t forget to join the SQL Server 2014 group on LinkedIn and stay updated!:
linkedin-microsoft-power-bi-group











How to easily check whether a @String contains Unicode characters or not

It’s easy! 😀


DECLARE @String NVARCHAR(MAX)
SET @String = N''

--How to easily check whether a @String contains Unicode characters or not (like Japanse characters) - simple method:
IF CAST(@String AS VARCHAR(MAX)) != @String
BEGIN
--String contains unicode character(s).
END

ELSE
BEGIN
--String does not contain unicode character(s).
END

SQL Scalar-valued Function – Text to Proper Case / Title Case (Unicode proof)

I was looking for an easy to use function (udf) in SQL to convert any text to ‘Proper Case’ (also known as ‘Title Case’) and found Pinal’s blogpost:
http://blog.sqlauthority.com/2007/02/01/sql-server-udf-function-to-convert-text-string-to-title-case-proper-case/

Except, it wasn’t working properly for S’s or unicode strings…so I’ve added a few lines of code and here’s the result:

IMPORTANT: This UDF wasn’t build for performance, use it with care.
In my scenarios, I used it in my ETL processes just before inserting/updating the deltas/changes and thus minimizing the performance impact.

TextToProperCase - Unicode proof - Results

You’ve be able to download the T-SQL code here (just copy&paste the code into SSMS):
TextToProperCase – Unicode proof