Search results matching tags 'Professional Development' and 'Presentations'http://sqlblog.com/search/SearchResults.aspx?o=DateDescending&tag=Professional+Development,Presentations&orTags=0Search results matching tags 'Professional Development' and 'Presentations'en-USCommunityServer 2.1 SP2 (Build: 61129.1)A Biml Case Studyhttp://sqlblog.com/blogs/andy_leonard/archive/2014/11/26/a-biml-case-study.aspxThu, 27 Nov 2014 00:37:22 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:56821andyleonard<p><a href="http://varigence.com/Products/Biml/Capabilities" target="_blank">Business Intelligence Markup Language</a> (Biml) is a <a href="http://en.wikipedia.org/wiki/SQL_Server_Integration_Services" target="_blank">SQL Server Integration Services</a> (SSIS) <a href="http://smile.amazon.com/Server-Integration-Services-Patterns-Experts/dp/1430237716/" target="_blank">design patterns</a> engine. </p> <p><strong>A Story of Productivity</strong></p> <p>A while back I was contacted by a client experiencing a familiar issue. The Production SQL Server instance was experiencing performance issues due to conflicts between customers and enterprise reporting needs. They contacted a friend who contacted me. When we spoke they asked, “Can you help?” “Yes,” I replied, “I can help.” </p> <p>We scheduled a three-day visit. On Day 1 I installed a Linchpin People SSIS Framework and gathered information about the Production databases. The Framework facilitates execution and logging and supports my preference of building a single SSIS package per table. I counted over 700 tables in over 30 databases. I determined an incremental load pattern would serve the customer best for their largest and most active tables. For the smaller tables, a truncate-and-load – whack ‘n’ load – pattern would suffice. </p> <p>I fired up <a href="http://www.varigence.com/Mist" target="_blank">Mist</a>, the Biml development environment from <a href="http://www.varigence.com/Mist" target="_blank">Varigence</a>, and started customizing our version of a staging application. </p> <blockquote> <p><em>I need to pause here and let you know that it takes me about an hour to build and test a typical truncate-and-load SSIS package, and two hours to build and test a typical incremental load SSIS package. I was looking at roughly 4.5 months of work with these tables.</em></p> </blockquote> <p>I spent Days 2 and 3 building and deploying SSIS packages using Mist. In the 16 hours that comprised these days, I completed building over 700 SSIS packages, loaded the Framework execution metadata (I used Biml to auto-generate approximately 25,000 lines of T-SQL at approximately 2,000 lines of code per second…), and performed a test load of Production data to the new enterprise reporting instance of SQL Server. When I ran the numbers, I did <em>not</em> do the work of 100 SSIS developers.</p> <p><em>Only 50.</em></p> <p><em>You</em> can do this, too.</p> <p><strong>How?</strong></p> <p>Biml and Mist are the secrets to my productivity. I not only drastically cut development time and effort, I <em>improved</em> code quality. SSIS packages are generated from tried-and-true templates. If one executes my tests successfully, then all the SSIS packages will execute my tests successfully.</p> <p><strong>Learn Biml NOW!</strong></p> <p>Would you like to multiply your SSIS productivity <em>while</em> improving code quality? Tim Mitchell and Reeves Smith are delivering an excellent one-day workshop titled <a href="http://www.eventbrite.com/e/getting-started-with-biml-tickets-13980635457" target="_blank">Getting Started With Biml</a> 5 Dec 2014 in Vienna, Virginia. The cost for this event is only $129. </p> <p>Details:</p> <p>For ETL developers, Biml (Business Intelligence Markup Language) is a game changer. This is a great new tool for Microsoft business intelligence developers who want to make the most of their development efforts. In short, it’s an XML-based language that will allow you to programmatically create SSIS packages. Even better, it can be enhanced with VB.NET or C# scripting to create BimlScript, which allows you to dynamically build and modify a few, dozens, or even hundreds of packages with minimal effort. Best of all, you don’t need budget approval – if you already have Visual Studio, you can use Biml and BimlScript for free! <br />In this full-day presentation, we’ll introduce you to dynamic package generation through Biml. Business intelligence consultants Tim Mitchell and Reeves Smith will walk you through the essentials of Biml – getting started, syntax, and common uses – followed by dozens of design patterns to improve your efficiency as an ETL developer.</p> <p>Among the topics that we’ll cover:</p> <ul> <li>Overview of Biml – What is it? Where do I use it? </li> <li>Introduction to Biml syntax </li> <li>Biml in the Visual Studio environment </li> <li>Introduction to BimlScript syntax </li> <li>Dynamic package generation with BimlScript </li> <li>Metadata management with Biml </li> <li>Create a simple staging package project with dozens of packages in less than an hour </li> <li>Package (re)generation </li> <li>Source control </li> <li>Common design patterns for Biml in the enterprise </li> <li>Taking Biml to the next level with Mist</li> </ul> <p>By the end of this full-day presentation, you should be equipped to get started immediately using Biml. It’s a revolutionary technology, and we hope that you’ll be as excited about Biml as we are.</p> <p><a href="http://www.eventbrite.com/e/getting-started-with-biml-tickets-13980635457" target="_blank">Register today</a>!</p> <p>:{&gt;</p>Presenting Managing Teams to PASS Professional Development Virtual Chapterhttp://sqlblog.com/blogs/andy_leonard/archive/2010/07/12/presenting-managing-teams-to-pass-professional-development-virtual-chapter.aspxMon, 12 Jul 2010 11:00:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:26917andyleonard<P>I am honored to present Managing Teams to the <A href="http://prof-dev.sqlpass.org/" target=_blank>PASS Professional Development VC Tuesday 13 Jul 2010 at 1:00 PM EDT</A>!</P>
<P><SPAN style="FONT-FAMILY:'Arial','sans-serif';FONT-SIZE:9.5pt;mso-bidi-font-size:11.0pt;mso-fareast-font-family:'Times New Roman';">Are you a member of a team of database professionals? Are you part of a developer&nbsp;team? Do you manage or lead a team? This presentation is for you. Andy Leonard shares experiences, war stories, and lessons learned from years of managing and leading teams.</SPAN></P>
<P><SPAN style="FONT-FAMILY:'Arial','sans-serif';FONT-SIZE:9.5pt;mso-bidi-font-size:11.0pt;mso-fareast-font-family:'Times New Roman';">:{&gt;</SPAN></P>