published 11/1/2013 8:09:17 PM
There will be several Biml presentations between now and the end of 2013. If you have a presentation focusing on Biml that's not listed, please let us know on the comments below or post it at the Biml User Group on Linkedin.
published 11/1/2013 4:37:00 AM
Biml had a great showing and according to this blogger was a star of PASS Summit 2013.
Biml got started at the Summmit on Tuesday, October 15th, when Varigence and Linchpin People presented the first ever full day Biml training event. The Workshop was held at the Wake Forest University Charlotte Center and sold out with 50 plus people in attendance. Presenters included Andy Leonard and Tim Mitchell as well as the creator of Biml Scott Currie.
At the Summit itself, Biml was an integral part of at least six presentations. These presentations included:
- Automate Your ETL Infrastructure with SSIS and PowerShell - Allen White - This presentation is available on PASS TV.
- Building a Supportable ETL Framework - David Darden
- Data Cleansing in SSIS - Tim Mitchell
- Designing an SSIS Framework - Andy Leonard
- Reduce, Reuse, Recycle: Automating Your BI Framework - Stacia Misner
- Type More, Click Less: Programmatically Build SSIS Packages - Bill Fellows
published 7/19/2013 2:20:03 AM
Due to Biml's growing popularity among BI professionals, SQL ServerCentral.com has launched a stairway series on Biml. Andy Leonard from Linchpin People and and Paul Waters from Varigence will be writing the "Stairway to Biml" articles.
SQL Server Central's Stairways are designed to get a beginner up and running on SQL Server based technologies. Each Stairway is a SQL tutorial series focused on a single topic and is arranged into no more than a dozen easily-navigable tutorials. Each level is the length of a typical magazine tutorial, and emphasizes practical, hands-on learning, with just enough background theory to help you understand the topic at a deeper level.
Level One of the staircase entitled, "What is Biml" was read over 8000 times on its first day of release. Levels Two through Four of the Stairway are scheduled to be released as follows:
- Level 2 - Wednesday, July 31, 2013
- Level 3 - Wednesday, August 7, 2013
- Level 4 - Wednesday, August 14, 2013
Levels five through twelve will be released over the remainder 2013.
published 5/30/2013 6:35:13 AM
On Saturday, May 18th at SQL Saturday #220 in Atlanta, Paul Waters and Andy Leonard gave standing room only presentations on Biml. Due to the fire code several people had to be turned away once the rooms reached capacity. Later in the day the organizers let Paul give an encore presentation of his Biml talk to allow everyone the opportunity to learn about the future of BI development.
Paul Waters presenting "Automating SSIS Development with Biml."
Andy Leonard presenting "Using BIML as an SSIS Design Patterns Engine."
published 5/18/2013 12:00:00 PM
Varigence and Linchpin People will be presenting a full day workshop about Biml on Tuesday, October 15th in Charlotte, NC. Come see why BI professionals around the world think Biml is the future of data integration and BI. Registration is only $69. Register before July 15th, and receive the early bird price of just $49. Hot breakfast, lunch, breaktime refreshments, online workshop materials, and t-shirt are included. Parking at WFU parking gargage is approximately $16 for the day. Event sign-in and breakfast begins 30 minutes before workshop's start. To register go to http://bimlscript.eventbrite.com/
published 1/3/2013 2:39:05 AM
BimlScript.com would like to wish all Biml users a Happy New Year. We plan to have lots of new content posted throughout 2013 so visit BimlScript.com frequently to bring your Biml skills to the next level. And if you haven't already make sure to join the Biml Users Group on Linkedin and follow us on Twitter to network with hundreds of other Biml users.
published 12/15/2012 10:36:21 PM
Senior Microsoft consultant Argenis Fernandez (pictured above) and Denny Cherry have a great talk together on Episode 15 of People Talking Tech. They discuss Business Intelligence Markup Language (Biml) starting at 18:10 of the podcast. They also discuss the book SQL Server 2012 Integration Services Design Patterns written by Andy Leonard, Matt Masson, Tim Mitchell, Jessica Moss and Michelle Ufford. The Design Patterns book has a full chapter devoted to Biml.
published 11/5/2012 7:28:06 PM
Biml's popularity is continuing to grow with more business intelligence professionals using it everyday. Due to Biml being increasingly mentioned in technical books and blogs it has garnered its own article on Wikipedia. Check it out at Wikipedia - Biml Article.
by Steven Currie
published 10/30/2012 12:29:16 AM
Once again Biml was a hit at a SQL Saturday event. On Saturday, October 27th at SQL Saturday #174 in Charlotte Varigence associates Paul Waters and Steven Currie gave demonstrations of Biml to attendees throughout the day. Paul also gave an hour long presentation on Biml entitled, "Automating SSIS Development with Biml." Once again Paul presented to a standing room only crowd that loved learning about Biml.
This SQL Saturday was a BI Edition and had several Microsoft MVPs and industry experts speaking on various Business Intelligence topics.
Steven Currie and Paul Waters at Varigence Booth.
Paul Waters presenting, "Automating SSIS Development with Biml."
by Steven Currie
published 10/16/2012 5:07:23 PM
On Saturday, October 13th Paul Waters presented, "Automating SSIS Development with Biml" at SQl Saturday #163 in Dallas, Texas. In his presentation Paul started by showing how Biml can be used to solve common BI problems. Then after discussing the basics of BimlScript he finished by covering practical examples using the BIDS Helper add-in to automate SSIS development. The presentation was standing room only and the audience loved learning about Biml.
This SQL Saturday was a BI Edition and had several Microsoft MVPs and industry experts speaking on various Business Intelligence topics. The next SQL Saturday BI Edition will be in Charlotte, NC on Saturday, October 27 and Paul will again be presenting "Automating SSIS Development with Biml". To learn more about SQL Saturday Charlotte BI Edition go to SQL Saturday #174.
Paul Waters giving Biml presentation at SQL Saturday #163. Photo courtsey of Ryan Adams.
published 10/15/2012 8:31:09 PM
Due to the increased use use by BI professionals worldwide two recently published books discuss Biml. The first book, SQL Server 2012 Integration Services Design Patterns was released on September 8, 2012 and devotes a full chapter to Biml. This book was written by SSIS gurus Andy Leonard, Matt Masson, Tim Mitchell, Jessica Moss and Michelle Ulford. This book is a terrific resource for learning Biml. The Biml chapter begins with a brief history and then explains step by step, with several screen shots, how to:
- Build your first Biml file inside of BIDS Helper
- Build a pattern for Basic Incremental Load in a SSIS package
- Use Biml as a SSIS Design Patterns Engine
In addition to the Biml chapter, Design Patterns covers 19 additional topics related to SQL Server 2012 that will help take your SSIS skills to the next level. SQL Server 2012 Integration Services Design Patterns is available through Amazon or Apress.
The second book Microsoft SQL Server 2012 Integration Services was released on September 19, 2012 and was written by members of Microsoft’s SQL Server Integration Services team. This book briefly talks about Biml as an alternative to creating SSIS automation solutions. This book will show you how to:
- Use SSIS to extract, transform, and load data from multiple data sources
- Apply best practices to optimize package and project configuration and deployment
- Manage security settings in the SSISDB catalog and control package access
- Work with SSIS data quality features to profile, cleanse, and increase reliability
- Monitor, troubleshoot, and tune SSIS solutions with advanced features such as detailed views and data taps
- Load data incrementally to capture an easily consumable stream of insert, update, and delete activity
Both books are available for purchase through Amazon.
published 9/10/2012 6:33:13 AM
As companies collect ever increasing quantities of information about their business, efficient resources to develop business intelligence solutions are critical to keeping up with the flood of data. Thousands of users have already discovered that the Biml language makes it possible to quickly, easily, and manageably author end-to-end BI solutions. Biml is an XML-based development language that can automatically generate large amounts of assets for any version of the Microsoft SQL Server platform (e.g. T-SQL scripts, SSIS packages, SSAS cubes, and more). What some may not know is that Biml also enables you to easily share solutions to common BI problems, without having to rewrite lots of code or share proprietary details of database structure.
BimlScript.com is intended to provide a hub for sharing BimlScripts, patterns, and best practices to further accelerate the work of Biml users. It is an online community for learning Biml, developing and sharing Biml solutions to BI problems, and helping others achieve success with Biml. Users can get started learning and authoring Biml, expand their knowledge by browsing the site's walkthroughs, video tutorials, and snippets, contribute their Biml knowledge to the community, and even develop Biml directly in their own browser.
We know Biml is revolutionizing how BI is done, and we're confident that you're about to have the same jaw-dropping experience.