Varigence, Inc.

Download the Free BIDS Helper tool to Use Biml Snippets

While Mist remains the best tool to take advantage of everything Biml has to offer, the open source BIDSHelper add-in for Business Intelligence Development Studio offers a compelling subset of Biml functionality at no cost. Build a BI solution for your organization, using snippets from the Varigence library and other sources – all for free.

Rapidly Deploy Advanced SQL Server Features

The SQL Server product family provides a rich set of capabilities, but it requires developers to spend significant amounts of time to learn new features before solving even simple problems with products such as SSIS and SSAS. Instead, use Biml to consume snippets that solve problems similar to yours, so you can focus on tweaking business logic for your scenario. Even better, Biml enables you to rapidly iterate - tweaking code to see if it produces the correct results and modifying as necessary. Biml enables you to spend more time solving problems and less time training.

Write code once and reuse it in multiple projects

Data development tends to follow common patterns. While reusing code from a previous project saves time and effort, it can be cumbersome to do with Business Intelligence Development Studio. You can build template packages and cubes, or copy/paste relevant snippets, but these approaches can be difficult to manage. Data type changes, connection changes, and other modifications can cause metadata corruption that require substantial rework. Biml enables you to start with a template that more completely describes your reuse scenario and can be easily tweaked without breaking metadata.

Be the Expert

Do you want to be the rockstar DBA who can solve hard problems with advanced SQL Server features and enable coworkers to do the same? Encapsulate your best tips and tricks in a collection of BimlScripts that you can share with others on your team, in your blog, or on public forums. You'll be more productive as you save time by not repeatedly answering similar questions, while you also increase the productivity of everyone around you. That's a recipe for career success.