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

2015-11-02 13_26_18-MailWhoaa, 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 →

SQL Server 2016 CTP2.4 released

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

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

Spatial data, where can I download it

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.