Episode 215: Azure Data Factory
We have been moving data for years with technologies like DTS and SSIS; however, these were very much designed for on-premises moves in mind. As more cloud services were being offered Microsoft needed a service to help customers using those services move data around. Azure Data Factory was born with the initial premise of moving data between cloud services; however, it has added the ability to connect with on-premises systems and continues to add a variety of connectors it can now natively support. In this episode, we chat with our friend Andy Leonard about Azure Data Factory, his experience working with the product team, and how customers can leverage the cloud to get business done faster. The show notes for today's episode can be found at https://sqldatapartners.com/2021/01/27/episode-215-azure-data-factory/. Have fun on the SQL Trail!
27 Tammi 20211h 7min
Episode 213: New Goals for 2021
We open this year with a few updates on the podcast, a change to SQL Trail, and we invite you to give us some feedback on writing a book for 2021. The show notes for today's episode can be found at https://sqldatapartners.com/2021/01/13/episode-213-new-goals-for-2021/. Have fun on the SQL Trail!
13 Tammi 202132min
Episode 212: 10 Things You Need to Know About Data Security
20 years ago, the objection to implementing security on the basis of performance had validity—especially for smaller organizations. Security was a pain in the neck; however, how many of us are still hanging on to some of those old biases. Even worse, some of us IT pros seem to put up objections to doing the most basic security procedures—sending usernames and passwords in unencrypted emails for example. In this episode we hear from Karen Lopez, a long time speaker on data architecture and security about 10 things she thinks those of us with data stewardship responsibilities should consider. The show notes for today's episode can be found at https://sqldatapartners.com/2020/12/31/episode-212-10-things-you-need-to-know-about-data-security/. Have fun on the SQL Trail!
31 Joulu 202059min
Episode 211: Solorigate
Microsoft released a lengthy white paper on the SolarWinds hack affecting thousands of computers. This is scary stuff, and the details continue to come out slowly and you wonder how it all will play out. Many IT pros rely on SolarWinds for monitoring and in this episode, we discuss the exploit, how mere mortals like us might feel a bit overwhelmed at the prospect, and what our due diligence is in a scenario like this. The show notes for today's episode can be found at https://sqldatapartners.com/2020/12/23/episode-211-solorigate/. Have fun on the SQL Trail!
23 Joulu 202046min
Episode 210: The Elephant in the Room
It was sad news to hear PASS plans to dissolve in January of 2021. So much good has come of the community and it is sad to see it go. In this episode, we explore the why behind the collapse and what we think may emerge in the aftermath. The show notes for today's episode can be found at https://sqldatapartners.com/2020/12/18/episode-210-the-elephant-in-the-room/. Have fun on the SQL Trail!
18 Joulu 202052min
Episode 209: Career Ready: Advice to New Graduates
Finding your first full time job is incredibly difficult—and that was before we were in a worldwide pandemic. In this episode, we discuss some strategies and share some experiences about how we got our first jobs and hopefully give you some inspiration as you try to find your first experience. The show notes for today's episode can be found at https://sqldatapartners.com/2020/12/14/episode-209-career-ready-advice-to-new-graduates/. Have fun on the SQL Trail!
14 Joulu 202050min
Episode 208: SQL Server and Graph Data
There is a growing list of formats to store data and Graph is one of the newer trends. It is becoming so popular SQL Server has created ways to implement graph structures. Mala Mahadevan joins us in this episode, and we revisit some of the origins of Graph, what it is good at, and why you may not want to rush to move all your data to Graph storage. The show notes for today's episode can be found at https://sqldatapartners.com/2020/10/28/episode-208-sql-server-and-graph-data/. Have fun on the SQL Trail!
28 Loka 202032min
Episode 207: SQL Trail 2020 Retrospective
SQL Trail 2020 was a success! There was a time I was unconvinced this would be the case. This is not to say we didn't have issues; however, talking with others helped us avoid some common pitfalls and make our event unique. Although we were virtual, I sent all the attendees a conference t-shirt, some swag, and cookies! I wanted everyone to feel some excitement and a connection that I was not sure would be possible in a virtual setting. The show notes for today's episode can be found at https://sqldatapartners.com/2020/10/15/episode-207-sql-trail-2020-retrospective/. Have fun on the SQL Trail!
15 Loka 202025min
