SQL Server 2012 – SQL Server Data Tools (SSDT) – A New IDE – Learning Resources

SQL Server 2012 – High Availability Enhancements – Learning Resources
SQL Server 2012 – Database Engine Enhancements – Learning Resources
SQL Server 2012 – Transact-SQL Enhancements – Learning Resources
SQL Server 2012 – Data Quality Services (DQS) – Learning Resources
SQL Server 2012 – Integration Services (SSIS) Enhancements – Learning Resources
SQL Server 2012 – Analysis Services (SSAS) Enhancements – Learning Resources
SQL Server 2012 – Reporting Services (SSRS) Enhancements – Learning Resources
SQL Server 2012 – Power View – A New Self Service BI Tool – Learning Resources
SQL Server 2012 – PowerPivot – Enhanced Self Service BI Tool – Learning Resources
SQL Server 2012 – SQL Server Management Studio (SSMS) Enhancements – Learning Resources
SQL Server 2012 – SQL Server Data Tools (SSDT) – A New IDE – Learning Resources
SQL Server 2012 – Other Features & Enhancements – Learning Resources


SQL Server Data Tools (SSDT) is a brand new Integrated Development Environment (IDE) released as part of SQL Server 2012 Release of SQL Server. It is basically a replacement for Business Intelligence Development Studio (BIDS) which was used in earlier versions of SQL Server for development of ETL Packages, OLAP Cubes, and SSRS Reports etc. Following are some of the salient features of this brand new IDE:

  • It uses Visual Studio 2010 Shell and hence, you no more need Visual Studio 2010 and BIDS running side by side as you can create all types of projects in SSDT.
  • Comes with Visual Studio Database Project Template (with quite a few enhancements).
  • Comes with Business Intelligence Development Studio (BIDS) Templates like SSIS, SSAS, and SSRS Project Templates etc.
  • Contains some functionality of SQL Server Management Studio or SSMS (Mostly development related). This can be accessed/viewed in a dedicated window called SQL Server Object Explorer.

Following are some of the links, references, and learning resources for SQL Server Data Tools (SSDT).

Articles/FAQs/Case Studies

Blogs/Sites/Forums

Videos

Advertisements

About Dattatrey Sindol (Datta)

Datta is a Microsoft BI Enthusiast, passionate developer, and a blogger. View Full Profile

Posted on December 6, 2012, in BIDS, SQL Client Tools, SQL Server, SQL Server 2012, SSDT and tagged , , , , , . Bookmark the permalink. Leave a comment.

What are your thoughts?

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: