Search results matching tags 'community' and 'SQL Server Community'http://sqlblog.com/search/SearchResults.aspx?o=DateDescending&tag=community,SQL+Server+Community&orTags=0Search results matching tags 'community' and 'SQL Server Community'en-USCommunityServer 2.1 SP2 (Build: 61129.1)Precon - SSIS Design Patterns and BIML: A Day of Intelligent Data Integration–8 Jan 2016, Alpharetta Georgiahttp://sqlblog.com/blogs/andy_leonard/archive/2015/11/12/precon-ssis-design-patterns-and-biml-a-day-of-intelligent-data-integration.aspxThu, 12 Nov 2015 18:29:57 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:60004andyleonard<p align="left"><a href="http://sqlblog.com/blogs/andy_leonard/PackageSVG_3B8DB7AB.jpg"><img title="PackageSVG" style="border-top:0px;border-right:0px;background-image:none;border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;display:inline;padding-right:0px;" border="0" alt="PackageSVG" src="http://sqlblog.com/blogs/andy_leonard/PackageSVG_thumb_0F70BABA.jpg" width="150" height="158" /></a>&#160;&#160;&#160;&#160;&#160;&#160;&#160; <a href="http://sqlblog.com/blogs/andy_leonard/BimlWheel_6ADF2D35.jpg"><img title="BimlWheel" style="border-top:0px;border-right:0px;background-image:none;border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;display:inline;padding-right:0px;" border="0" alt="BimlWheel" src="http://sqlblog.com/blogs/andy_leonard/BimlWheel_thumb_11411081.jpg" width="190" height="156" /></a></p> <p align="left">I’m excited to announce I will be delivering a precon 8 Jan 2016 in Alpharetta Georgia for <a href="http://www.sqlsaturday.com/477/eventhome.aspx" target="_blank">SQL Saturday 477 – Atlanta BI Edition</a> titled <a href="http://www.eventbrite.com/e/ssis-design-patterns-and-biml-a-day-of-intelligent-data-integration-tickets-19517833365" target="_blank">SSIS Design Patterns and BIML: A Day of Intelligent Data Integration</a>! This precon is all about DILM (Data integration Lifecycle Management). </p> <p align="left"><strong>Abstract:</strong></p> <p align="left"><a href="http://www.eventbrite.com/e/ssis-design-patterns-and-biml-a-day-of-intelligent-data-integration-tickets-19517833365" target="_blank">SSIS Design Patterns and Biml: A Day of Intelligent Data Integration</a></p> <p align="left">Join <a href="http://andyleonardconsulting.com" target="_blank">Andy Leonard</a>, SSIS trainer, <a href="https://varigence.com/Blog/Post/65" target="_blank">BimlHero</a>, co-author of <a href="http://smile.amazon.com/Server-Integration-Services-Design-Patterns/dp/1484200837" target="_blank">SSIS Design Patterns</a>, the <a href="http://www.sqlservercentral.com/stairway/72494/" target="_blank">Stairway to Integration Services</a> and <a href="http://www.sqlservercentral.com/stairway/100550/" target="_blank">Stairway to Biml</a> series at <a href="http://www.sqlservercentral.com" target="_blank">SQL Server Central</a>, and <a href="http://smile.amazon.com/gp/product/1502947609" target="_blank">Managing Geeks</a>, for a day of training focused on intelligent data integration. Andy is an experienced SSIS consultant, but he also led an enterprise team of 40 ETL developers on projects that spanned 2.5 years. And delivered.</p> <p align="left">The target audience for this course is data integration developers and architects who want to learn more about SSIS performance, DevOps, execution, best practices, code reuse, and automation.</p> <p align="left">Attendees will learn: <br />&#160;&#160; - a holistic approach to data integration design. <br />&#160;&#160; - a methodology for enterprise data integration that spans development through operational support. <br />&#160;&#160; - how automation changes everything. Including data integration with SSIS.</p> <p align="left">Topics include:</p> <p align="left">1. SSIS Design Patterns <br />&#160;&#160; Data Flow Performance <br />&#160;&#160; ETL Instrumentation</p> <p align="left">2. Executing SSIS in the Enterprise <br />&#160;&#160; The SSIS Catalog - the good, the bad, and the ugly.</p> <p align="left">3. Custom SSIS Execution Frameworks</p> <p align="left">4. DevOps and SSIS <br />&#160;&#160; A (Condensed) Sprint in the Life of a Data Integration Solution <br />&#160;&#160; Version Control and SSIS</p> <p align="left">5. Business Intelligence Markup Language <br />&#160;&#160; A Brief Introduction to Biml in BimlStudio</p> <p align="left">6. SSIS Design Patterns + Biml <br />&#160;&#160; Putting the pieces together.</p> <p align="left">7. SSIS Design Patterns + Biml + Custom SSIS Execution Frameworks <br />&#160;&#160; Executing the new combinations.</p> <p align="left">8. SSIS Design Patterns + Biml + Custom SSIS Execution Frameworks + DevOps <br />&#160;&#160; Enterprise-class data integration with SSIS. </p> <p align="left">Early-bird pricing is in effect until 30 Nov 2015.</p> <p align="left"><a href="http://www.eventbrite.com/e/ssis-design-patterns-and-biml-a-day-of-intelligent-data-integration-tickets-19517833365" target="_blank">Register here today</a>!</p> <p align="left">I hope to see you there.</p> <p>:{&gt;</p>So Long, and Thanks for All the Scripts!http://sqlblog.com/blogs/andy_leonard/archive/2015/06/23/so-long-and-thanks-for-all-the-scripts.aspxTue, 23 Jun 2015 10:15:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:58913andyleonard<p>With mixed emotions, I just read <a href="http://sqlfool.com/2015/06/end-of-an-era/" target="_blank">The End of an Era – SQLFool scripts are now open-sourced</a>. After two <a href="http://smile.amazon.com/Server-Integration-Services-Patterns-Experts/dp/1430237716/" target="_blank">book</a> <a href="http://smile.amazon.com/Server-Integration-Services-Design-Patterns/dp/1484200837" target="_blank">projects</a> together, I admire Michelle (<a href="http://hadoopsie.com/" target="_blank">New Blog</a> | <a href="http://twitter.com/SQLFool" target="_blank">@SQLFool</a>) immensely. More than that, I consider her a friend. </p> <p>It’s exciting to (try to) keep up with all the cool stuff Michelle’s working on, and I am very happy for her. </p> <p>Thanks for all the cool code, ma’am!</p> <p>:{&gt;</p> <p>Learn more: </p> <p><a href="http://smile.amazon.com/Server-Integration-Services-Design-Patterns/dp/1484200837" target="_blank"><img title="SSIS2014DesignPatterns200" border="0" alt="SSIS2014DesignPatterns200" src="http://sqlblog.com/blogs/andy_leonard/SSIS2014DesignPatterns200_2A08FE52.jpg" width="163" height="204" /></a></p>Real World SSIS: A Survival Guide, 8 May, Baltimorehttp://sqlblog.com/blogs/andy_leonard/archive/2015/04/08/real-world-ssis-a-survival-guide-8-may-baltimore.aspxWed, 08 Apr 2015 12:24:05 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:58369andyleonard<p>My friend and fellow Linchpin, Tim Mitchell (<a href="http://timmitchell.net" target="_blank">blog</a> | <a href="http://twitter.com/Tim_Mitchell" target="_blank">@Tim_Mitchell</a>) will deliver a day-long seminar titled <a href="http://www.eventbrite.com/e/real-world-ssis-a-survival-guide-tickets-16494350045" target="_blank">Real World SSIS: A Survival Guide</a> the day before SQL Saturday – Baltimore (9 May). Attend and learn more about:</p> <ul> <li>Handling warnings, errors, and other bad stuff</li> <li>Data cleansing using SSIS, T-SQL, and DQS</li> <li>More than just a green box: validating the results</li> <li>Managing variables, parameters, expressions, and scripts</li> <li>Identifying and resolving performance bottlenecks</li> <li>Evaluating the new features of SSIS 2012-2014</li> <li>Choosing and using the right package deployment model</li> <li>Automating SSIS development with Biml</li> <li>When SSIS might *not* be the best choice</li> </ul> <p>Tim Mitchell is a friend and co-author of both editions of the <a href="http://smile.amazon.com/Server-Integration-Services-Design-Patterns/dp/1484200837" target="_blank">SSIS Design Patterns</a> books. Plus, he’s an awesome instructor! I encourage anyone interested in learning more about SSIS to attend Tim’s seminar.</p> <p>:{&gt;</p> <p>Learn more:&#160; <br /><a href="http://www.sqlservercentral.com/stairway/100550/" target="_blank">Stairway to Biml</a> <br /><a href="http://www.linchpinpeople.com/tag/ssis/" target="_blank">Linchpin People Blog: SSIS</a> <br /><a href="http://www.sqlservercentral.com/stairway/72494/" target="_blank">Stairway to Integration Services</a></p> <p><a href="http://smile.amazon.com/Server-Integration-Services-Design-Patterns/dp/1484200837" target="_blank"><img title="SSIS2014DesignPatterns200" border="0" alt="SSIS2014DesignPatterns200" src="http://sqlblog.com/blogs/andy_leonard/SSIS2014DesignPatterns200_2A08FE52.jpg" width="163" height="204" /></a></p>Attending the PASS Summithttp://sqlblog.com/blogs/andy_leonard/archive/2014/11/04/attending-the-pass-summit.aspxTue, 04 Nov 2014 17:02:29 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:56242andyleonard<p>The PASS Summit is an annual gathering of SQL Server professionals and others interested in learning more about SQL Server. Folks come from all over. Here’s a few suggestions for getting more out of your PASS Summit experience.</p> <p><strong>“What if I’m Not There?”</strong></p> <p>Not everyone can attend the PASS Summit. You can still enjoy a taste of the activities via PASSTV, which will be streamed from the <a href="http://www.sqlpass.org/summit/2014/Home.aspx" target="_blank">PASS Summit 2014 home page</a>.</p> <p><strong>Meet New People</strong></p> <p>If this is your first (or one of your first) PASS Summit(s), don’t be shy. If you see someone you want to meet, introduce yourself. If that person is in a conversation or appears otherwise engaged (for example, if that someone is sitting outside the Subway on the fifth level of the Washington State Convention Center furiously typing a blog post… hypothetically…) say “Hi” and, if you want to talk more or discuss some technology question or even just hang out, ask if now or later is a good time. I can speak from experience, most geeks love sharing and will stop typing their blog post or whatever they’re doing to have a chat with you.</p> <p>Old timers (like me), if you see someone wearing a First Timers ribbon, <em>you introduce yourself</em>! You remember how you felt your first Summit, break the ice. Our field is disproportionately populated by introverts, take some initiative.</p> <p><strong>Be Respectful and Tolerant</strong></p> <p>Everyone believes what they believe for a reason. You do not have to agree with what someone says or does. But unless they’re trampling on others, respect their expressions. And if they <em>are</em> trampling on others, intervene. Either personally, or by finding someone who can and will intervene. PASS leadership has gone to great lengths to define a fair and practical <a href="http://www.sqlpass.org/summit/2014/AntiHarassment.aspx" target="_blank">Anti-Harassment Policy</a>. Read it. Now. And if you see someone acting in a manner you believe inconsistent with this policy, please tell someone.</p> <p><strong>Learn</strong></p> <p>Microsoft has a habit of releasing new cool stuff during the week of the PASS Summit. You can learn about it first by attending or viewing the Keynote addresses Wednesday and Thursday morning. There are too many awesome sessions at the Summit happening at the same time – it’s a fact. But you can view the sessions and powerpoints by purchasing the downloads or USB sticks loaded with them at the <a href="http://www.passboutique.com/" target="_blank">PASS Boutique</a>. Even if you cannot attend, you can buy all the content. Plus, the PASS Boutique sells other “PASS-Wear” and data geek paraphernalia. </p> <p>I would love to meet you if you’re attending the Summit. You can find me at the Linchpin People booth in the Exhibition Hall or wandering hither and yon. I will also be presenting Wednesday morning. I hope to meet you here!</p> <p>:{&gt;</p>Presenting Using Biml as a Design Patterns Engine to Midlands PASS 9 Jan 2014!http://sqlblog.com/blogs/andy_leonard/archive/2013/12/29/presenting-using-biml-as-a-design-patterns-engine-to-midlands-pass-9-jan-2014.aspxSun, 29 Dec 2013 18:55:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:52263andyleonard<p><a href="http://www.amazon.com/Server-Integration-Services-Design-Patterns/dp/1430237716" target="_blank"><img title="image" style="border-top:0px;border-right:0px;background-image:none;border-bottom:0px;float:left;padding-top:0px;padding-left:0px;border-left:0px;display:inline;padding-right:0px;" border="0" alt="image" src="http://sqlblog.com/blogs/andy_leonard/image_143DEFAE.png" width="190" align="left" height="240" /></a>I am honored to present Using Biml as a Design Patterns Engine to the <a href="http://midlands.sqlpass.org/" target="_blank">Midlands PASS Chapter</a> Thursday 9 Jan 2014!</p> <p>Summary: Business Intelligence Markup Language provides a powerful solution for creating and managing SSIS Design Patterns. Andy Leonard, one of the authors of <a href="http://www.amazon.com/Server-Integration-Services-Design-Patterns/dp/1430237716" target="_blank">SSIS Design Patterns</a>, demonstrates the flexibility of BIML in this session.</p> <p><a href="https://www.eventbrite.com/e/using-biml-as-an-ssis-design-patterns-engine-tickets-9774803701" target="_blank">Register here</a>!</p> <p>If you will be near Columbia, SC one week from Thursday and read this blog, stop by and introduce yourself. I’m the fat guy with a fu.</p> <p>I hope to see you there!</p> <p>:{&gt;</p>SQL in the City Event Dates Announced!http://sqlblog.com/blogs/andy_leonard/archive/2013/05/18/sql-in-the-city-event-dates-announced.aspxSat, 18 May 2013 06:00:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:49103andyleonard<p><a href="http://red-gate.com/" target="_blank">Red Gate</a> rocks.</p> <p>If you didn’t know that already, you know it now. The latest evidence to support this claim is the publication of the schedule for US <a href="http://sqlinthecity.red-gate.com/" target="_blank">SQL in the City</a> events. They are:<a href="http://sqlinthecity.red-gate.com/" target="_blank"><img title="SQL in the City" style="border-top:0px;border-right:0px;background-image:none;border-bottom:0px;float:right;padding-top:0px;padding-left:0px;border-left:0px;display:inline;padding-right:0px;" border="0" alt="SQL in the City" align="right" src="http://sqlblog.com/blogs/andy_leonard/SQLInTheCityLogo_5FF59FA4.jpg" width="678" height="130" /></a></p> <ul> <li>9 Oct – Pasadena</li> <li>11 Oct – Atlanta</li> <li>14 Oct – Charlotte</li> </ul> <p>Registration for these events opens 24 May.</p> <p>:{&gt;</p>Presenting at the NJ SQL Server User Group Tuesday 21 Feb 2012!http://sqlblog.com/blogs/andy_leonard/archive/2012/02/14/presenting-at-the-nj-sql-server-user-group-tuesday-21-feb-2012.aspxTue, 14 Feb 2012 12:00:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:41724andyleonard<p>I am honored to present “Building Your First SSIS Package in SQL Server 2012” at the <a href="http://njsql.org/" target="_blank">NJ SQL Server User Group</a> Tuesday, 21 Feb 2012 starting at 6:00 PM!</p> <p>If you read this blog and will be in the area, please stop by and introduce yourself! I’m the fat guy with a fu.</p> <p>:{&gt;</p>