Search results matching tags 'SQL Server 2008' and 'Business Intelligence'http://sqlblog.com/search/SearchResults.aspx?o=DateDescending&tag=SQL+Server+2008,Business+Intelligence&orTags=0Search results matching tags 'SQL Server 2008' and 'Business Intelligence'en-USCommunityServer 2.1 SP2 (Build: 61129.1)SSIS Design Patterns, the Bookhttp://sqlblog.com/blogs/andy_leonard/archive/2012/08/06/ssis-design-patterns-the-book.aspxMon, 06 Aug 2012 16:37:43 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:44587andyleonard<p>For the past two years, I have had the honor and privilege or authoring <a href="http://www.amazon.com/SSIS-Design-Patterns-Matt-Masson/dp/1430237716" target="_blank">SSIS Design Patterns</a> alongside Jessica Moss, Michelle Ufford, Tim Mitchell, and Matt Masson. Publication of the book – like many projects of this scope – has been delayed. The current publication date is 27 Aug 2012 and I have high confidence in this date. </p> <p>I take responsibility for publication delays and apologize to those who pre-ordered the book. The reasons for the delays are not important. I have built a career as a software developer and architect based on the following maxim:</p> <blockquote> <p><em>Deliver quality late, no one remembers. <br />Deliver junk on time, no one forgets.</em></p> </blockquote> <p>The shared goal of everyone working on this project has been to deliver quality. Proofing the manuscripts, I believe we have achieved that goal. </p> <p>:{&gt;</p>It's Official - SQLSaturday is Coming to NYC!http://sqlblog.com/blogs/michael_coles/archive/2010/02/06/it-s-official-sqlsaturday-is-coming-to-nyc.aspxSat, 06 Feb 2010 19:59:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:21916Mike C<P><A title="NJSQL Home Page" href="http://www.njsql.org/" target=_blank>New Jersey SQL Server User Group (NJSQL)</A> is bringing <A title="SQLSaturday #39 Home Page" href="http://www.sqlsaturday.com/39/eventhome.aspx" target=_blank>SQLSaturday #39</A>&nbsp;to NYC on April 24, 2010!&nbsp; The free all-day training event will be hosted by Microsoft at their Midtown Manhattan offices.&nbsp; The speaker line-up is growing fast—if you'd like to present, visit the event's open <A title="SQLSaturday #39 Call for Speakers" href="http://www.sqlsaturday.com/39/callforspeakers.aspx" target=_blank>call for speakers</A>.&nbsp;&nbsp;This is a free full-day training&nbsp;event, but <A title="SQLSaturday #39 Registration Page" href="http://www.sqlsaturday.com/39/register.aspx" target=_blank>registration is required</A>&nbsp;to attend.&nbsp; Seating is limited.</P>
<P>Registration, speaker, and sponsorship details are posted at <A href="http://www.sqlsaturday.com/39/eventhome.aspx">http://www.sqlsaturday.com/39/eventhome.aspx</A>.</P>Presenting at the PASS Application Development Virtual Chapter 8 Sep!http://sqlblog.com/blogs/andy_leonard/archive/2009/09/03/presenting-at-the-pass-application-development-virtual-chapter-8-sep.aspxThu, 03 Sep 2009 11:00:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:16544andyleonard<P><STRONG>Business Intelligence at REST<BR>September 8th at 1:00 PM Eastern<BR>Presenter: Andy Leonard</STRONG>&nbsp;</P>
<P>I am honored to present Business Intelligence at REST to the <A href="http://appdev.sqlpass.org/" target=_blank>PASS Application Development Virtual Chapter</A> on 8 Sep 2009!</P>
<P>This is going to be a fun presentation for me. I'm going to talk about my weather station and some business intelligence I've wrapped around the weather data collected from it. It doesn't stop there, I've turned <A href="http://twitter.com/AndyWeather" target=_blank>AndyWeather</A> into a bit of a social bot! I'll talk about my application that interfaces with the Twitter API - a REpresentational State Transfer (REST) interface.</P>
<P>I walk through the idea, the hardware, and software. Visit the <A href="http://appdev.sqlpass.org/" target=_blank>website</A> Tuesday, join the meeting, and I hope to see you there!</P>
<P>:{&gt; Andy</P>Presenting Incremental Loads, CDC, and SSIS 2008 to Columbus SQL Server UG Tomorrow!http://sqlblog.com/blogs/andy_leonard/archive/2009/07/08/presenting-incremental-loads-cdc-and-ssis-2008-to-columbus-sql-server-ug-tomorrow.aspxWed, 08 Jul 2009 15:30:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:15168andyleonard<P>I'm honored to present Incremental Loads, Change Data Capture, and SSIS 2008 to the <A href="http://columbus.sqlpass.org/" target=_blank>Columbus SQL Server Users Group</A> tomorrow evening! </P>
<P>This is the first remote presentation I've attempted in a while. I won't be in physical attendance, only virtually. I'll be in my office in Farmville, VA. Isn't technology cool?</P>
<P>:{&gt; Andy</P>Speaking at Philly Code Camp 2008.2 Saturdayhttp://sqlblog.com/blogs/andy_leonard/archive/2008/05/14/speaking-at-philly-code-camp-2008-2-saturday.aspxThu, 15 May 2008 03:31:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:6796andyleonard<P>I will be presenting Change Data Capture, Incremental ETL, and SSIS 2008&nbsp;to <A class="" href="http://www.phillydotnet.org/Meetings/MeetingEmails/2008/May172008/tabid/677/Default.aspx" target=_blank>Philadelphia Code Camp</A> 2008.2 Saturday, 17 May 2008! </P>
<P>The good folks in Philadelphia always do a great job with Code Camps and the attendance numbers are growing to reflect that! They're sold out again. Great job!</P>
<P>:{&gt; Andy</P>SSIS 2008 Data Profiling Taskhttp://sqlblog.com/blogs/andy_leonard/archive/2008/03/12/ssis-2008-data-profiling-task.aspxThu, 13 Mar 2008 03:01:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:5551andyleonard<P><A class="" href="http://blogs.conchango.com/jamiethomson/default.aspx" target=_blank>Jamie Thomson</A> has posted a great series on the <A class="" href="http://blogs.conchango.com/tags/SQL+Server+Integration+Services/Data+Profiling/default.aspx" target=_blank>SSIS 2008 Data Profiling Task</A>.</P>
<P>The Data Profiling Task allows developers to quickly assess key statistics about data in a database table. When I say "statistics" I mean things like column value and length distribution, column null ratio, column patterns,&nbsp;and&nbsp;functional dependencies. You can learn more in Jamie's series or at <A class="" href="http://msdn2.microsoft.com/en-us/library/bb895322(SQL.100).aspx" target=_blank>MSDN</A>.</P>
<P>One very cool feature is the ability to set up a <A class="" href="http://msdn2.microsoft.com/en-us/library/bb934046(SQL.100).aspx" target=_blank>Single Table Quick Profile</A>&nbsp;to quickly configure and capture desired statistical data.</P>
<P>Once you capture the data, you use a separate stand-alone tool for viewing the results: the <A class="" href="http://msdn2.microsoft.com/en-us/library/bb895313(SQL.100).aspx" target=_blank>Data Profile Viewer</A>.</P>
<P>SQL Server 2008 CTP6 (February 2008) includes a functioning version of the Data Profiling Task in SSIS 2008. </P>
<P>:{&gt; Andy</P>