Microsoft Cloud Roadshow – Hits Copenhagen

The Microsoft Cloud Roadshow is coming to Copenhagen March 3-4, 2016. Space is limited, so register today!

The Microsoft Cloud Roadshow is a free, two-day technical training event for IT Professionals and Developers that provides best practices and insight directly from the experts who build and run the cloud services across Office 365, Microsoft Azure and Windows 10.

PASS Summit 2015 and SSIS on SQL 2016

2015-11-02 20_28_22-sql server 2016 - Google-SucheThere was one session in particular that was interesting, and as part of the SQL Server 2016 TAP  program, I was looking forward to see if we would get more that we already knew. The session was by Jimmy Wong ( B) Program Manager for the SSIS team, he had a good session and there was a few golden nuggets. Continue reading →

SQLSaturday Denmark precon registration is live

We’re proud to announce that the registration for precons at SQLSaturday Denmark is now live – we have managed to get some great speakers – and the topics they each talk about, are all really interesting and something that we all use or should use in our daily work with Business Intelligence and Microsoft SQL Server.precons-1024x543

Continue reading →

CU 4 for SQL Server 2014 ready

sql-server-2014It’s a good day today, the release of Cumulative Update 4 for SQL Server 2014 will fix a lot of small and larger bugs.

Including the painfull one that task would shift to upper left corner in SSIS when resized.

Cumulative update package 4 for SQL Server 2014 (including update for SSIS) is available at http://support.microsoft.com/kb/2999197/en-us

This CU release contains a list of bug fixes for SQL in general, SSRS, SSAS and SSIS.

For SSIS fixes:

FIX: Tasks shift to upper-left corner when you move or resize them while designing a maintenance plan in SSMS 2014

FIX: Error in SQL task with IsQueryStoredProcedure set to True when you use .NET Data Provider for Teradata in SSIS

FIX: SSIS 2012 or SSIS 2014 XML Source task cannot load data from URI

For SSAS Fixes:

FIX: MDX query returns no result when the cache is not cleared after you run a previous query in OLAP or tabular model

FIX: User obtains incorrect data when two users in the same security role run a client report in SSAS 2012 or SSAS 2014

SQL Performance Fixes:

FIX: A severe error occurs when you run a query that uses CTEs against the partitioned tables in SQL Server

SSRS Fixes:

FIX: Error when you print, print preview, or export the report to PDF in SSRS 2012 or SSRS 2014

For the full list look here

Microsoft Exam 70-457/58 Passed

Amidst all the talk about the death of MCM certification from Microsoft, i’ve 

been reading and catching up on my SQL 2012 knowledge.

So that I could transition my current MCITP 2008 Business Intelligence to SQL server 2012 MCSE, I took the 70-457 exam last friday and passed with well over 800 points.

This morning I took the 70-458 exam and passed that as well, this time the administration of SQL server bumped the overall score down a little, but I passed.

Now in 14 days time I’ll have the last one, the 70-460 exam and after that i’ll med certified SQL Server 2012 MCSE ;O)

Great way to start my friday, and the weekend.

SSIS Tip of the day

I’ve just learned a new tip about SSIS that I was not aware of. A tip that I think you all should know about,

When retrieving data via the OLE_DB connection, there are several options to how the data should be retreived. Often we just select “Table or View” option, mostly because we’re to lazy to write up the SQL that is needed for the operation.

 

Just be aware that when you do that, the SSIS engine will use the command OPENROWSET to get the data, but when you’re typing up the correct SQL to get the data and using the “SQL command” the SSIS engine will use the faster and more optimized SP_Executesql.