Do You Still Have SSIS 2008 in Production?

Do You Still Have SSIS 2008 in Production?

In the AI-centric world I (and many data scientists) tend to live in, everything is cutting edge (or close to it). We take cloud and PaaS for granted. It’s hard for us to imagine that in 2019, many organizations are still running SQL Server 2008 and 2008 R2 in production. Further more, many of these same organizations are still using SSIS 2008 and 2008 R2 in production as well.

Yesterday, support ended for SQL Server 2008 and 2008 R2. Leaving many in a state of fear and loathing. Andy Leonard, co-host of Data Driven, has written an insight post about this very problem.

Cheer up, you’re not alone and it can only get better from here on out.

If you are reading this post and thinking or saying, “Yep. He’s writing about me,” you are not alone. If you feel bad about this, I have spoken to people who are still running DTS (Data Transformation Services) from the SQL Server 2000 days. If you’re feeling smug because you’re running SQL Server 2016 or 2017 in production, test-drive the moccasins of folks who are hampered by mission-critical third-party enterprise solutions for which later SQL Server versions have not been certified – some of whom are operating in regulation-heavy industries.

Getting SSIS to Work in Containers (and They Said It Couldn’t Be Done)

Getting SSIS to Work in Containers (and They Said It Couldn’t Be Done)

Andy has been working on a way to test SSIS package execution in Windows containers using the SSIS Catalog. That’s a lot of moving parts, which made for a lot of blog posts.

Watch the video from the Data Driven TV Facebook page:

Alternatively, press the play button below to listen here or visit the show page at DataDriven.tv

Read the related blog series at andyleonard.blog:

Andy Leonard and I Were Guests on the AI Today Podcast

Andy Leonard and I Were Guests on the AI Today Podcast

Press the play button below to listen here or visit the show page

Show Notes

AI Today Podcast #82: Interview Frank La Vigne and Andy Leonard with Data Driven Podcast

In this podcast we get the rare opportunity to interview fellow podcasters. Frank La Vigne and Andy Leonard are co-hosts of the Data Driven podcast and joined us on this episode of the AI Today podcast to discuss the important role data plays in AI, their take on how data will continue to be used into the future and the idea of pervasive knowledge.

Read more …

Data Driven at PASS 2018 Roundup

Data Driven at PASS 2018 Roundup

While I was at UVA presenting at Datapalooza, Andy was at PASS 2018 recording DataPoints for DataDriven.tv along with roving reporter Tim McAliley.

Here’s a round up of their stuff.

SQl Server Managed Instance

PASS 2018 is this week in Seattle, Washington. Andy is on site and he even has a booth for Enterprise DNA! Rumor has it that there’s even a Data Driven logo on the booth! :)We are also excited to have Timothy McAliley as our very first “roving reporter” covering events and happenings all around the conference. Be sure to like us on Facebook to stay up to date and have access to all the bloopers we make while recording DataPoints!

Press the play button below to listen here or visit the show page at DataDriven.tv

Andy at Day 2 Keynote

Andy is at PASS 2018 waiting for the Day 2 Keynote to start.

Press the play button below to listen here or visit the show page at DataDriven.tv

Tim on PASS 2018’s Last Day

In this DataPoint, roving reporter Tim McAliley explains what he’s been up to on the last day of PASS 2018.

Press the play button below to listen here or visit the show page at DataDriven.tv

Andy on PASS 2018’s Last Day

Andy catches up with what he’s been up to at the PASS 2019 Summit, SQL Server 2019, and driving late at night.

Press the play button below to listen here or visit the show page at DataDriven.tv

 

Reflecting on Data Collection in the Wake of Hurricane Florence

Reflecting on Data Collection in the Wake of Hurricane Florence

Hurricane Florence hit the US East Coast nearly seven weeks ago, yet the cleanup is on going and many people’s lives are still not back to normal.In this DataPoint, Andy talks about the importance to remembering that there are people behind the statistics and data we gather.

What prompted me to think about this was how in the first few years after 9/11, I had shared my photos of the event with a researcher at NIST. In email exchange, I remember explaining to him that I would send him more data after I “another memorial service, third one this week.” He wrote back snarkily, “you know a lot of dead people.” To which I replied, “I knew a lot of people in the Towers.” He wrote back quickly, apologizing how his excitement for data collection got the better of him and he never really thought about the people who died and that he’s not just researching a fire, but a mass murder.

That interchange stuck with me and, as I saw parallels between our excitement about “Andy Weather,” I thought it would be a teachable moment.It also helped that he was down in NC to volunteer to help the people whose lives have been upended by the storm.

Press the play button below to listen here or visit the show page at DataDriven.tv

 

SSIS Framework Community Edition Webinar

SSIS Framework Community Edition Webinar

On the podcast Andy Leonard and I create, we love experimenting around here and examining the resulting data. After all, we are Data Driven: not just in name but also in spirit.In this webinar Andy recorded, he also streamed it live on our Facebook page.

We thought it was good enough to share with our larger audience here.Let us know what you think. Both Frank and Andy have been recording/streaming their live events and we’re curious to hear what you have to say about this innovation in how we podcast.

Press the play button below to listen here or visit the show page at DataDriven.tv