Folks Who Influenced Me (#TSql2sday)

It’s been a while since I wrote a TSql2sday post – too long, in fact. But I saw the topic trending on Twitter in the SQL Server Community and knew I needed to add my 2 cents… It’s difficult to list all the people who have inspired me. Many continue to inspire me in small …
Continue reading Folks Who Influenced Me (#TSql2sday)

Just Ship

Last week I attended the PASS Summit 2017. Almost every time I’m around that many geeks, I’m asked a question. In fact, I’d say this is the most frequently asked question I hear. What’s the question? “How do you get so much done?” My first response is half-joking, “Insomnia.” I don’t believe I suffer from …
Continue reading Just Ship

The Biml Book is Available!

The Biml Book became available last week! I’m delayed in posting this because I was at the PASS Summit 2017 last week where I had a great time catching up with old friends, making new friends, learning new stuff, and presenting. Really exciting for Biml people, Scott Currie was on-stage to present Biml and Azure Data …
Continue reading The Biml Book is Available!

AndyLeonard.blog() is Faster!

First, thank you to everyone who visits and has visited this blog. It’s been painfully slow and I am truly sorry about that. I upgraded to a managed WordPress service at GoDaddy and things move much faster now – as you probably already realized. One nice side-effect of this change is it now takes less time …
Continue reading AndyLeonard.blog() is Faster!

The Second-Best Time

I recently returned from the PASS Summit 2017 where I had an awesome time hanging out with members of the SQL Server Community, learning, and presenting. Attending a conference inspires a bunch of ideas. If you’re like me,  you might kick yourself and think, “Why didn’t I think of that sooner?!” If I had a time …
Continue reading The Second-Best Time

Lessons Learned About Community Leadership

It’s been an honor and a privilege to serve in technical community leadership at the local (Richmond Virginia) and regional level. It’s not the same as managing geeks, but there are similarities. I’ve considered serving on a national level but not taken that plunge. Over the years I’ve learned some lessons that I thought I’d …
Continue reading Lessons Learned About Community Leadership

SSIS Performance Pattern – Loading a Bajillion Records

Do you need to use SSIS to load some data from a large source? This post covers some thoughts on a couple/three patterns you may apply to help. I can hear you thinking, “Which pattern should I use, Andy?” That’s an excellent question! The answer is, “It depends.” You should test each pattern and see …
Continue reading SSIS Performance Pattern – Loading a Bajillion Records

Announcing Biml Academy v2.0

Update: See this post at Biml Academy for an opportunity to sign up for 50% off! I am pleased to announce the relaunch of Biml Academy! The site currently hosts free training from the very first Biml Academy week – way back in the Spring of 2016. I delivered that training while on the road. …
Continue reading Announcing Biml Academy v2.0