[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( | application, 1743K, uploaded Tue – 141 downloads
  • BIDSHelper2012_1_6_5_0.zip | application, 2317K, uploaded Tue – 17 downloads
  • BIDSHelper2008Setup( | application, 1711K, uploaded Tue – 80 downloads
  • BIDSHelper2008_1_6_5_0.zip | application, 2277K, uploaded Tue – 16 downloads
  • BIDSHelper2005Setup( | 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]/[ES] Windows Azure SDK v.2.2 is available

LOGO__WindowsAzureNewfullOn 17th October Microsoft released new version of Windows Azure SDK for .NET (both for Visual Studio 2012 and 2013). What is WASDK?  It’a spesial package which can help developers for using Windows Azure Services, such as Windows Azure Storage, Service Bus, Caching, Web Sites, Cloud Services and more. What’s new with this version? Full information You can find on site, but here is “the snapshot” from this site:

The Windows Azure SDK for .NET version number (2.2) is determined by the core Windows Azure service runtime assembly using semantic versioning. Other client libraries packaged inside the Windows Azure SDK for .NET, along with their respective NuGet packages, follow independent versioning based on the semantic versioning scheme. The Windows Azure SDK for .NET 2.2 includes Windows Azure Storage, Windows Azure Service Bus 2.1.3, Windows Azure Caching 2.1.0, and Windows Azure Configuration Manager 2.0.1 libraries. You can also download these libraries from their respective NuGet packages.

You can use the tools in the Windows Azure SDK to run, test, debug, and fine-tune your application before you deploy it as a cloud service to Windows Azure. The Windows Azure SDK includes the following tools:

  • Windows Azure compute emulator – A tool that locally emulates the environment in which cloud services run.
  • Windows Azure storage emulator – A tool that locally emulates the services of Windows Azure storage.
  • CSPack – A tool that creates an application package that can be deployed to Windows Azure.
  • CSUpload – A tool that is used to upload VHD files and service certificates to Windows Azure.
  • CSEncrypt – A tool that is used to encrypt the password for remote desktop connections.
  • CSRun – A tool that is used to start the compute emulator with the appropriate application package.
  • DSinit – initializes Windows Azure storage emulator in the local environment.

How You can install it? In few simple steps:

Firstly You should go to Windows Azure SDK Download site {http://www.windowsazure.com/en-us/downloads/}, next download and run Microsoft Web Platform Installer file for VS2012 or VC2013.



Pic. 01 | Executing Microsoft Web Platform Installer.


Pic. 02 | If You using different location than English, should be prepared for messages located in Your language {on my systems in Spanish)


Pic. 03 | Here are basic information about this release with links for more information


Pic. 04 | Basic configuration, at this moment we can leave this with default settings, but we should stop at sixth line, where we can choose default language for installed software, even in this case Spanish (Español) is not good choice. Always English wis better in dev environment…


Pic. 05 | Especialmente, oops sorry. Especially that next screens are in “location language” and we can be surprise – and always we can say ‘challenge accepted’. First part of summary what we wil install: package for SQL Server 2012, Web Deploy 3.5, Authoring Tools and Tools for Visual Studio 2012, and Azure Emulator.


Pic. 06 | Installation begin


Pic. 07 | Installed Database for WASDK for Visual Studio 2012 is… SQL Server 2012 SP 1


Pic. 08 | Finito, that means final screen for this part, now after click on Continuar {Continue}


Pic.09 | … we jump to Windows Azure site for easy way to create account (if You don’t have one)


Pic. 10 | But it’s not the end. Behing the web site, instalator giving us full summery of oftallation, and another button Finalizar {Finish}.


Pic. 11 | After click we jump to anothe menu where we canchoose axtre tools for WASDK, such as cross-platform Command Line Tool, PowerShell Tools, and libraries for PHP, Node.js and Ruby.


Pic. 12 | I choose two of five for installation


Pic. 13 | Pre-Installation summary – with license links and size of files.


Pic. 14 | Installation process


Pic. 15 | And final of final summary.


A little more information about this edition (again just in snapshot):

New Features in the SDK

  • Visual Studio 2013 is supported in SDK Version 2.2
  • Sign in to connect to Windows Azure
  • Windows Azure Web Sites support in Visual Studio
  • Remote debugging for Windows Azure Cloud Services (preview)
  • TopologyBlast
  • Windows Azure Service Bus

Known Issues

  • Remote debugging may fail to attach to an existing Cloud Service
  • Side-by-Side Cloud Service Debugging works with projects built with 1.7 and later versions of the SDK
  • CSRun requires an elevated command prompt
  • Integrated Sign In to Windows Azure Using the Windows Azure Tools for Visual Studio 2.2
  •           No Windows Azure Subscriptions were added
  •           Databases and Mobile Services not listed in Server Explorer
  •           Unable to view multiple accounts in Multi-account sign in
  •           Duplicate web sites listed in Server Explorer
  •           Unable to sign out after signing in with a federated account
  •           Account-based access subject to expiration

For more information go HERE and HERE. End ENJOY!!

[EN] New instalation versus existing feature: SQL Connect in VS2012

sql_connect_270x220My environment is not very complicated: just windows platform, some sql server instances, recording stuff, bloggers kit, visual studio installation and some third party (vendors) tools. One of them, installed ‘by default’ in my Visual Studio 2012 instance is SQL Connect by RedGate {LINK}.  Ingeniously simple database development in Visual Studio.  Connected, source-controlled database development in Visual Studio:

  • Develop databases in Visual Studio alongside application code
  • Query databases and execute stored procedures directly from Visual Studio
  • Track and share changes using your source control system

Very useful tool, especially when You think abou controlling your code, and data. I had installed, and fully updated Visual Studio 2012 environment, and tried install my RedGate’s SQL Developer Bundle (more about this ingeniously awesome pack in next posts). And I got an error:


Pict. 1 | in the process of installing full package, received error from SQL Connect 1.1 (MSI Error 1603)

On Microsoft Support page we can find information about cause of this error – KB834484:

You may receive this error message if any one of the following conditions is true:

  • The folder that you are trying to install the Windows Installer package to is encrypted.
  • The drive that contains the folder that you are trying to install the Windows Installer package to is accessed as a substitute drive.
  • The SYSTEM account does not have Full Control permissions on the folder that you are trying to install the Windows Installer package to. You notice the error message because the Windows Installer service uses the SYSTEM account to install software.

Because nothing of that is my cause I decided to skip this software in installation process, and installing all others software.


Pict.2 | result is green for me.

Next I back to problematic package, using both paths with installation: default by vendor (c:\… I never use partition C for any of files if I really needn’t it), and default by me (somewhere else).


Pict.3 | installation folder by default for this installation…


Pict.4 | cannot help me. Still got an error.

I checked my Visual Studio 2012 installation and I discovered that SQL Connect 1.1. has been installed. Hmmm.. maybe conflict? I de-istalled this feature from my Visual Studio {Menu/Tools/Extentions and Updates}. And run RedGate setup again.


Pict.5 | Got You. Finally green light.


It is a little strange for me. just installer crashed – better solution should be show me my mistake, like: “You have installed version. please delete other versions before you install this software”. Well, maybe Redgater’s could repair this installer, because this dependiences are important.