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 and great ways. I will mention as many as I can here, but please know there are dozens of people who inspire me in our awesome community.

Years ago, I wrote – in a post called Things I Know Now – about meeting Ken Henderson and Kalen Delaney (@sqlqueen) at the PASS Summit 2004. They helped me keep my first data-focused job (“Application DBA”) while working to tune my very first data warehouse. Both were inspiring in person and through their training and writing.

I’ve been blessed to work in vocational and community capacities with others who have and continue to inspire me: Scott Currie (@scottcurrie), Steve Jones (@way0utwest), Brian Knight (@brianknight), Andy Warren (@sqlandy), Brian Moran (@briancmoran), Bennett McEwan; all of whom stretched my understanding, all of whom taught me (some continue to teach me). I’ve been honored to work alongside two dozen authors on a dozen book projects. I’m a proud member of the Richmond Technology Community – an eclectic collection of philosophical geeks in .Net, SQL Server, and other technologies. I get to communicate often (and occasionally work with) with people I consider masters of this trade: Brent Ozar (@brento) and Kimberly Tripp (@kimberlyltripp) and Grant Fritchey (@GFritchey) and Kendra Little (@Kendra_Little) and Paul Randal (@paulrandal) and Adam Machanic (@adammachanic) and Andrew Kelly (@GunneyK) and Brian Kelley (@kbriankelley) and Jimmy May (@aspiringgeek) … and so many others.

And, of course, this awesome community inspires me.

Who inspires me today?

Tom Roush (@GEEQL) inspires me each time we interact. I often refer to Tom as “the best unpublished writer I know.” Tom has an inner strength hidden beneath his calm, cool exterior. He’s wise and kind and “in him there is no guile.”

Frank La Vigne (@Tableteer) – my partner in crime at Data Driven. Frank and Brent are tied for the most productive people I know personally. Whenever people ask me how I get so much done, I immediately think, “I’m not Frank or Brent.” Frank is a survivor. He delivers. He gets things done. He’s a voracious reader and learner. I could say the same things about Brent Ozar.

I am surrounded, assisted, and (sometimes) carried by two men at Enterprise Data & Analytics: Kent Bradshaw and Nick Harris. Every day these gentlemen encourage me to be better than Yesterday-Andy.

:{>

Presenting Faster SSIS at SQL Saturday 683 – Charlotte 14 Oct

I’m honored and excited to deliver a brand new presentation at SQL Saturday 683 – Charlotte on 14 Oct: Faster SSIS!

Abstract:

Ever wonder why SSIS runs so slow? Watch SSIS author Andy Leonard as he runs test loads using sample and real-world data and shows you how to tune SQL Server 2016 Integration Services (SSIS 2016) packages.

We’ll start by experimenting with SSIS design patterns to improve performance loading AdventureWorks data. We will implement different change detection patterns and compare execution performance for each. Then, we’ll explain a Data Flow Task’s bottleneck when loading binary large objects – or Blobs.

Finally, we’ll demonstrate a design pattern that uses a Script Component in a Data Flow to boost load performance to MySql, whether on-premises or in the cloud.

I hope to see you there!

Register today!

:{>

New Article: Help for DBAs Who Support SSIS at SQL Server Central

My latest article, Help for DBAs Who Support SSIS… is now live at SQL Server Central!

In this article I share some tips and tricks for using SSIS Catalog Compare for surfacing SSIS Catalog metadata, comparing SSIS projects deployed to different SSIS Catalog, and Scripting SSIS Catalog configurations metadata (such as Environments, Environment Variables, References, and Reference Mappings).

SSIS Catalog Compare is part of the DILM Suite (or Data Integration Lifecycle Management Suite) which is designed to support data integration automation. Although SSIS Catalog Compare is not free, most of the tools and utilities at DILM Suite are free – and some are open source.

I invite you to check out the tools and utilities at DILM Suite. I’d love your feedback, and please use the Contact page to send us your questions.

:{>

Learn More:

Designing an SSIS Framework (recorded webinar, registration required)
Biml in the Enterprise Data Integration Lifecycle (recorded webinar, registration required)
Enterprise SSIS, Biml, and DILM – 18 Jul 1:00 PM EDT – free webinar

Need Help or Training?

Enterprise Data & Analytics is here to help!
We provide SSIS and Biml training, and
SSIS Consulting and Performance Tuning.

New Data Driven Episode: Rimma Nehme on CosmosDB, Planet-Scale Applications, and Selling Door-to-Door

rimma

This week on Data Driven, Frank and I are honored to interview Rimma Nehme, CosmosDB Architect at Microsoft. We had a fantastic time chatting about CosmosDB, open-source, reading, and what (or whom, rather) Dr. Nehme finds really important. As always there are movie references: Blues Brothers and Spiderman are quoted this week.

Notable Quotes

Submitting to the PASS Summit 2017 (1:10)
Blues Brothers movie reference (3:50)
Data needs to be Everywhere (11:00)
Planet scale (16:00)
Spiderman reference (17:30)
Is this science fiction? (24:24)
Battle-tested. (25:30)
Open-source software analytics (27:30)
The CosmosDB simulator (32:44)
A little startup inside Microsoft (35:30)
Rimma found query optimization really, really boring. (37:45)
On family… (40:45)
CosmosDB is truly out of this world. (48:00)
On reading… (42:00)
Selling door-to-door (44:45)

The Data Driver weekly newsletter is your only source for future guest information prior to episode release. Sign up today!

Frank posts Data Science Daily each weekday. Check it out!

:{>

Follow Data Driven
iTunes
YouTube
Twitter
Facebook
LinkedIn
RSS Feed

Learn More About Data Driven
Data Driven website
Episodes
Data Science Daily
Blog
Data Driver mailing list
About the Show

We Are Part of an Awesome Community

As I type, SQL Saturday-Dublin 2017 is winding down for me. There’s a Viking Splash Tour planned for tomorrow but I’m off to London to deliver some Biml Training and will have to miss the fun.

Reflecting on my first trip to Ireland, it occurs to me that we are part of an awesome community. #SqlFamily is often used to describe the SQL Server Community and I believe that’s an apt description. It’s an honor to be part of #SqlFamily with you!

Missing out on the fun? Find a nearby SQL Server User Group or SQL Saturday. Then jump in!

:{>

PS – If you’re interested in learning more about my day at SQL Saturday-Dublin 2017, please check out the Data Driven podcast mini-shows tagged SqlSaturdayDublin!

Announcing Data Science Daily

At Data Driven we’re experimenting with new show formats – especially what we call “mini-shows.” Earlier this week we started a new feature called Data Science Daily. Frank has done an outstanding job on these first three installments!

We’d love your feedback. What do you think of the shows so far? If you’re so inclined, please leave a review at iTunes!

:{>

Follow Data Driven
iTunes
YouTube
Twitter
Facebook
LinkedIn
RSS Feed

Learn More About Data Driven
Data Driven website
Episodes
Blog
Data Driver mailing list
About the Show

New Data Driven Episode: Mark Tabladillo on Data Science Teams, Bots, Personhood, and Dancing

This week on Data Driven, Frank and I are honored to interview Mark Tabladillo, Lead Data Scientist for Microsoft Services: Data Insights Domain Center of Excellence. We talked about lots of stuff including Data Science teams, bots, personhood, and dancing.

Notable Quotes

No brakes on the F train. (2:10)
On data munging (15:00)
On MS certifications (20:00)
Team Data Science (a github project) (23:45)
The importance of math, engineering, and physics education (26:00)
Frank, on math: “Kaboom” (29:30)
On dancing (36:30)
Digital Immigrants vs. Digital Natives (39:30)
Rise of the Data Science bots (42:45)
I, Robot movie reference (44:30)
Passengers movie reference (44:55)

The Data Driver weekly newsletter is your only source for future guest information prior to episode release. Sign up today!

:{>

Follow Data Driven
iTunes
YouTube
Twitter
Facebook
LinkedIn
RSS Feed

Learn More About Data Driven
Data Driven website
Episodes
Blog
Data Driver mailing list
About the Show