Posts Tagged ‘SQL Server Data Tools’

Tabular Model Project does not load in Visual Studio – need SSDT

May 22, 2017 Leave a comment

Today one of my colleague started got one Change Request to add few attributes to a Tabular Model already deployed from a previous project. He installed Visual Studio and connected the Repository. But when he tried to load the Project it was giving following error:

This version of Visual Studio is unable to open the following projects. The project types may not be installed or this version of Visual Studio may not support them.
For more information on enabling these project types or otherwise migrating your assets, please see the details in the “Migration Report” displayed after clicking OK.
– abcTabularCube, “D:\VSO\abcTabularCube\xyz.smproj”

No changes required
These projects can be opened in Visual Studio 2015, Visual Studio 2013, Visual Studio 2012, and Visual Studio 2010 SP1 without changing them.
– abcTabularCube, “D:\VSO\abcTabularCube\xyz.sln”


I checked his Visual studio, opened a new Project and checked if the MS BI templates for SSAS, SSRS and SSIS are showing or not. You can check them below:

If those won’t show up then you need SQL Server Data Tools (SSDT), which you can install from here.

SQL Server 2012 (a.k.a. Denali) | The Fantastic 12 of 2012

April 24, 2012 2 comments

SQL Server team has come up with a new series to promote its new product and create awareness among techies about what SQL Server 2012 is capable of and what new features it comes packed with. Check out the full series of The Fantastic 12 of SQL Server 2012 here.

The above link will provide you direct access to the technet blogs with detailed info on all 12 topics and videos.

The series will talk about 12 new features, which are as follows:

1. Required 9s Data Protection:
– Always On
– New support for Windows Server Core

2. Blazing-Fast Performance:
– New ColumnStore Index, [video]
– Improved Full Text Search
– Good Compression capabilities.

3. Organizational Security and Compliance:
– Data Protection (Encryption and Compression)
– Control Access (User-Defined Server Roles, Default Schema for Groups, Contained Database Authentication and Active Directory)
– Ensure Compliance (SQL Server Audit and Policy-Based Management)

4. Peace of Mind:
– Product Enhancements (Distributed Replay, System Center Alignment, System Center Advisor and No-fee Service Packs)
– Free Planning Tools
– Tailored Support and Licensing Programs (Mission Critical Support and Enrollment for Application Platform)

5. Rapid Data Exploration & Visualization:
– Self-Service Analytics (Power Pivot)
– Stunning, interactive data visualization (Power View)

6. Managed Self-Service BI:
– Gain insight and oversight (Power Pivot for SharePoint)
– Enable IT Efficiency (End user created, IT managed, Ease of administration through SharePoint and SQL Azure Reporting)

7. Credible, Consistent Data:
– BI Semantic Model
– Integration Services
– Data Quality Services
– Master Data Services

8. Scalable Analytics & Data Warehousing:
– Flexibility and Choice (Hardware and deployment options and Optimized Solutions)
– Massive Scale at Low Cost (Built-in Functionality, Support for Powerful Hardware and Parallel Data Warehouse)
– Complete BI Solution (Scalable OLAP)

9. Scale On Demand:
– Self-service Deployments
– SQL Azure Federation
– Contained Databases
– License Mobility
– Data Sync

10. Fast Time To Solution:
– Optimized Transaction processing and data warehousing
– Complete solutions co-engineered with hardware partners
– Agile to market from weeks and months to days

11. Optimized Productivity:
– SQL Server Data Tools
– T-SQL Enhancements
– Common tools
– SQL Server Management Studio

12. Extend Any Data, Anywhere:
– Support for Any Data
– Statistical Semantic Full-Text Search
– OData
– SQL Azure DataMarket
– Enhanced interop support

This “Fantastic 12” feature list is also available for download, and the PDF is here.

Check out the Webcast/Videos for all these 12 features, here.