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.
Whoaa, what a week that last one, was attending Pass Summit for the second time, so no “First Timer” ribbon for me, but I met a lot of First Timers and helped them feel comfortable at PASS Summit15. And this is what in my opinion makes this conference a special one, we all take care of each other and try to help out wherever possible, hence the twitter tag #SQLFamily ;o) Continue reading →
Today the newest CTP got released, SQL Server 2016 CTP2.4 – get it here.
Some features is in regards to Reporting Services, not much put among them is.
- Finally it is possible to re-arrange parameter input fields.
- Print from browsers
- Import to Powerpoint
Read even more here
So grab a copy and get familiarized with the newest SQL Server
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
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
Spatial data, where is it?
Today I was working on some reports for a client, where shipments should be visualized on a worldmap. That is an easy task, as the data is already in a functional cube, så I just had to define a few datasets, and I was flying.
Then I had to get some spatial data to visualize the data on a worldmap, and the first few attempts at Google gave me a few options, and I tried a few of them. But some of the shapefiles was skewed in their polygons, so when i clicked on France for instance I got US, and the like.
I googled a little more and refined my search, and ended up on MapGallery of Reporting Services in SQL Server 2008 R2 on Codeplex.com, where I found a fine collection of shapefiles, and *.rdl files with embedded spatial data.
The above map is embedded in a report, and all I had to do was copy the object to my own report.
And map the country codes from the dataset to the codes in the map.