AndyLeonard.blog()

The SQL Server Community is a giving community. Don’t believe me? Look at all the volunteers who facilitate SQL Server User Group meetings, organize and present at SQL Saturday events, answer #sqlhelp questions on Twitter and forums, and work behind the scenes to ensure a smooth PASS Summit, SQLBits, or other major conference. Face it, …
Continue reading #SQLGive

Introduction I am following the PASS Board Elections 2011 process, blogging about the people and events. You can find a list of all my posts on the topic here. Board Applications According to the schedule, applications are now being accepted to run for the PASS Board of Directors. The applications process will remain open until …
Continue reading PASS Elections 2011 Update: Board Applications Are Open

In my last cloud-related post – Introducing TFSPreview: Application Lifecycle Management in the Cloud! – I covered how you can create an account to use Microsoft Team Foundation Server in the cloud via a cool new service called TFSPreview. In this post, we’ll cover connecting Visual Studio 2010 to TFSPreview and adding a project to …
Continue reading Using TFSPreview: Step 1, Connecting

… and I apologize. A few weeks ago I commented on Kevin Kline’s (Blog | @kekline) blog post entitled Why I Do Not Support The Current PASS ExeCo Slate. I commented more than once, but I am apologizing for the first comment. That was wrong and I know it. I broke at least a couple/three …
Continue reading I Was Wrong…

Earlier today I tried something new: a 30-minute training session using a Google+ Hangout (with extras). The extras include screen-sharing, so I was able to show ten others some tips and tricks about SSIS Scripting. I had a blast! Community-Inspired This all grew from an idea bounced around on a test of the new features …
Continue reading Running in Circles – A Recap of My First MicroTraining Session

Earlier today Grant Fritchey, Bill Fellows, Ken Watson and I tried out the new features of Google Hangouts (with extras). Screen sharing is included and that sparked a thought: MicroTraining. So tomorrow, 22 Sep 2011 at 10:00 AM EDT I am going to present 20-30 minutes on SSIS Scripting to anyone interested. You will need …
Continue reading MicroTraining 1: SSIS Scripting

At last week’s Build conference in Anaheim California, Microsoft unveiled TFSPreview.com. I was able to score access so I set up access to the server, updated Visual Studio 2010, and began playing around with the functionality. This post describes what I needed to do to get my workstation ready for ALM (Application Lifecycle Management) in …
Continue reading Introducing TFSPreview: Application Lifecycle Management in the Cloud!

Alarmist? Perhaps. Accurate? In one sense, but not in the most important sense. The Cloud is coming. Are you ready? “Figures Don’t Lie” – Foghorn Leghorn Consider the following true story: Company A and Company B are in the same business. Company A was formed in the 1990’s and has built a successful business and …
Continue reading The Sky Is Falling

Update: If you are using the SSIS Catalog found in SSIS 2012 and later versions, you may be interested in the SSIS Framework Community Edition, an open source, Catalog-integrated execution framework. In preparation for SQL Saturday #84 – Kalamazoo,  SQLBits 9, and the PASS Summit 2011; I’ve been honing my presentation called Designing an SSIS …
Continue reading Designing an SSIS Framework

If you haven’t yet, check out the Stairways – a series of tutorial articles at SQL Server Central. They. rock. I was really excited when Steve Jones (Blog | @way0utwest | SQLPeople) contacted me to write the Stairway series of tutorials for SSIS! The third article is live this morning. Altogether, the published articles are: …
Continue reading Stairway to SSIS Step 3–Adding Rows in Incremental Loads