Search results matching tags 'SQL Server 2008' and 'business intelligence'

SSIS Design Patterns, the Book

andyleonard — Mon, 06 Aug 2012 16:37:43 GMT

For the past two years, I have had the honor and privilege or authoring SSIS Design Patterns 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.

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:

Deliver quality late, no one remembers.
Deliver junk on time, no one forgets.

The shared goal of everyone working on this project has been to deliver quality. Proofing the manuscripts, I believe we have achieved that goal.

:{>

It's Official - SQLSaturday is Coming to NYC!

Mike C — Sat, 06 Feb 2010 19:59:00 GMT

New Jersey SQL Server User Group (NJSQL) is bringing SQLSaturday #39 to NYC on April 24, 2010! The free all-day training event will be hosted by Microsoft at their Midtown Manhattan offices. The speaker line-up is growing fast—if you'd like to present, visit the event's open call for speakers. This is a free full-day training event, but registration is required to attend. Seating is limited.

Registration, speaker, and sponsorship details are posted at http://www.sqlsaturday.com/39/eventhome.aspx.

Presenting at the PASS Application Development Virtual Chapter 8 Sep!

andyleonard — Thu, 03 Sep 2009 11:00:00 GMT

Business Intelligence at REST
September 8th at 1:00 PM Eastern
Presenter: Andy Leonard

I am honored to present Business Intelligence at REST to the PASS Application Development Virtual Chapter on 8 Sep 2009!

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 AndyWeather 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.

I walk through the idea, the hardware, and software. Visit the website Tuesday, join the meeting, and I hope to see you there!

:{> Andy

Presenting Incremental Loads, CDC, and SSIS 2008 to Columbus SQL Server UG Tomorrow!

andyleonard — Wed, 08 Jul 2009 15:30:00 GMT

I'm honored to present Incremental Loads, Change Data Capture, and SSIS 2008 to the Columbus SQL Server Users Group tomorrow evening!

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?

:{> Andy

Speaking at Philly Code Camp 2008.2 Saturday

andyleonard — Thu, 15 May 2008 03:31:00 GMT

I will be presenting Change Data Capture, Incremental ETL, and SSIS 2008 to Philadelphia Code Camp 2008.2 Saturday, 17 May 2008!

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!

:{> Andy

SSIS 2008 Data Profiling Task

andyleonard — Thu, 13 Mar 2008 03:01:00 GMT

Jamie Thomson has posted a great series on the SSIS 2008 Data Profiling Task.

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, and functional dependencies. You can learn more in Jamie's series or at MSDN.

One very cool feature is the ability to set up a Single Table Quick Profile to quickly configure and capture desired statistical data.

Once you capture the data, you use a separate stand-alone tool for viewing the results: the Data Profile Viewer.

SQL Server 2008 CTP6 (February 2008) includes a functioning version of the Data Profiling Task in SSIS 2008.

:{> Andy