[EN} BIDS Helper version 1.6.5 released

BIDSHelperSmallLogoTwo days ago (January 7th) new version of BIDS (Business Intelligence Development Studio) Helper has been released /and yesterday Jan. 8th files has been updated/. This fantastic feature is an add-in using for Business Intelligence projects with:

  • Visual Studio 2005 and SQL Server 2005
  • Visual Studio 2008 and SQL Server 2008 and SQL Server 2008 R2
  • Visual Studio 2010 and Visual Studio 2012 for SQL Server 2012

When You get file from CodePlex, unzipping, and installing, You will get access for many features:

  • Analysis Services Multidimensional:

Aggregation Manager Calculation Helpers Column Usage Reports Delete Unused Aggregations Delete Unused Indexes Deploy Aggregation Designs Deploy MDX Script Deploy Perspectives Dimension Data Type Discrepancy Check Dimension Health Check Dimension Optimization Report Duplicate Role Many-to-Many Matrix Compression Measure Group Health Check Non-Default Properties Report Parent-Child Dimension Naturalizer Printer Friendly Aggregations Printer Friendly Dimension Usage Roles Report Similar Aggregations Smart Diff Show Extra Properties Sync Descriptions Test Aggregation Performance Tri-State Perspectives Update Estimated Counts Validate Aggregations Visualize Attribute Lattice

  • Analysis Services Tabular:

 Roles Report Smart Diff Tabular Actions Editor Tabular Display Folders Tabular HideMemberIf Tabular Pre-Build Tabular Sync Descriptions Tabular Translations Editor Tabular Annotation Workaround Unused Columns Report 

  • Integration Services:

Batch Property Update Biml Package Generator Create Fixed Width Columns Deploy SSIS Packages Design Warnings dtsConfig File Formatter Expression and Configuration Highlighter Expression List Fix Relative Paths Non-Default Properties Report Pipeline Component Performance Breakdown Reset GUIDs Smart Diff Sort Project Files Sortable Package Properties Report SSIS Performance Visualization Variables Window Extensions

  • Reporting Services:

 Dataset Usage Reports Delete Dataset Cache Files Smart Diff

  • General:

Enable/Disable features Preferences Version Notification

From add-in’s download page You can choose from few versions:

  • BIDSHelper2012Setup(1.6.5.0).exe | application, 1743K, uploaded Tue – 141 downloads
  • BIDSHelper2012_1_6_5_0.zip | application, 2317K, uploaded Tue – 17 downloads
  • BIDSHelper2008Setup(1.6.5.0).exe | application, 1711K, uploaded Tue – 80 downloads
  • BIDSHelper2008_1_6_5_0.zip | application, 2277K, uploaded Tue – 16 downloads
  • BIDSHelper2005Setup(1.6.5.0).exe | application, 1711K, uploaded Tue – 16 downloads
  • BIDSHelper2005_1_6_5_0.zip | application, 2276K, uploaded Tue – 5 downloads

And when You get Your favorite… let’s play.

[EN] SQL Server Data Tools – September 2013 update

Few days ago Microsoft released September’s Update of SQL Server Data Tools for Visual Studio (2010 and 2012).  SSDT Team blogged: “The September 2013 release has a targeted fix for the Schema Compare error when working with large display text or high DPI.”  If You already use Visual Studio 2012, You can get notifications about this update directly from application:

Captura_SSDT_Sept13_01

Pic.01 – SSDT update notification in VS 2012

But, even You click update, You will be redirecting to update page:

Captura_SSDT_Sept13_02

Pic.02 – redirection for SSDT update page: http://msdn.microsoft.com/en-us/jj650015 

At this page You can find information about software requirements {like operating systems Windows 7 SP1 (x86 and x64), Windows 8 (x86 and x64), Windows Server 2008 R2 SP1 (x64), Windows Server 2012 (x64)}, direct link for downlading installer, and links for application which give You possibility for installation without internet acces “Administrative Install Point” in few other languages: Portuguese (Brazil), Chinese (PRC), German, English, Spanish, French, Italian, Japanese, Korean, Russian, Chinese (Taiwan). You will need approximately 1.8GB of free space at for the full install point because it includes all possible components that might be required.

Captura_SSDT_Sept13_03

Pic.03 – After running setup, You must accept agreements.

Captura_SSDT_Sept13_04

Pic.04 – and downloading and installing proces starting.

Captura_SSDT_Sept13_05

Pic.05 – after all, restart (hopefully not immediatelly and not forced) is required.

Final view:

image

Pic.06Visual Studio 2012 > SQL Menu > Check for Update

 

On SQL Server Data Tools site {HERE} You can find more information what SSDT is:

Microsoft SQL Server Data Tools provides an integrated environment for database developers to carry out all their database design work for any SQL Server platform (both on and off premise) within Visual Studio. Database developers can use the SQL Server Object Explorer in VS to easily create or edit database objects and data, or execute queries. Developers will also appreciate the familiar VS tools we bring to database development, specifically; code navigation, IntelliSense, language support that parallels what is available for C# and VB, platform-specific validation, debugging and declarative editing in the TSQL Editor, as well as a visual Table Designer for both database projects and online database instances.

image