SQL Server 2017 – Data Tools installation

This post to third and final part of SQL Server 2017 setup guide. We have got

1. SQL Server 2017 installed
2. SQL Server Management Studio 2018
3. Adventure Works SQL Database Sample
4. Adventure Works Multidimensional and Tabular Cube Sample

Now final piece is Tool for development of SQL Server 2017 solutions. We need BIDS (Business Intelligence Development Studio) or call it SQL Server Data Tools. Installation is quite simple.

1. Download SSDT for Visual Studio 2017 (15.9.2)
2. At installation it will ask for two things
   • Visual Studio 2017 instance if not then SSDT with Visual Studio 2017
   • All MSBI services (Integration, Analysis and Reporting)
3. Installer will do all the things for setting up Business Intelligence development setup within Visual Studio 2017, make sure Internet is connected.

That’s all, you are done with development part as well. Happy Coding!!

Comment in case of any hiccups and compliments are always welcome.

SQL Server 2017 Adventure Works Multidimensional Cube

It is easy to find Adventure Works scripts for OLTP and DW databases. But it sometimes tricky to find either solution to the Adventure Works Multidimensional Cube and Tabular or backup files.

So solve this problem for you I am sharing links to the abf files for quick access. This post is part 2 of last post on SQL Server 2017 quick setup. With SSAS and Tabular model sample databases you will be perfectly able to handle testing and development samples.

Go to : https://github.com/Microsoft/sql-server-samples/releases/tag/adventureworks-analysis-services

and at the very end of the article you will find the link for Adventure Works Analysis Services databases samples. Backups will be working for SQL Server 2016 and later versions. Tested by me.

Analysis Services database backups:

1. adventure-works-multidimensional-model-full-database-backup.zip  – You get two backups Enterprise and Standard. I have both restored.
2. adventure-works-tabular-model-1200-full-database-backup.zip  – You get only Sales data Tabular Model

 

Analysis services projects:

1. adventure-works-multidimensional-model-project.zip
2. adventure-works-tabular-model-1200-project.zip

Enjoy!! easy download then restore and you have working cubes for testing and working.

Let me know if there is any hiccup while you do all the setups from SQL Server 2017 to Adventure Works databases. Waiting for comments with appreciation or criticism.