Just last year I was send on training in Prague – the technology I was training myself in was Parallel Data Warehouse (PDW) from Microsoft, now known as Analytics Platform System (APS). Continue reading →
Tag Archives for Performance
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.
CU 4 for SQL Server 2014 ready
It’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
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.