Info

SQL Data Partners Podcast

Hosted by Carlos L Chacon, the SQL Data Partners Podcast focuses on Microsoft data platform related topics mixed with a sprinkling of professional development. Carlos and guests discuss new and familiar features and ideas and how you might apply them in your environments. Visit our website for episode show notes at sqldatapartners.com/podcast and leave a comment if you have a topic you think we should discuss. We’ll see YOU on the SQL Trail.
RSS Feed Subscribe in Apple Podcasts
2022
June
April
March
February
January


2021
December
November
October
September
August
July
June
May
April
March
February
January


2020
December
October
September
August
July
June
April
March
February
January


2019
December
November
October
September
July
June
May
April
March
February
January


2018
December
November
October
September
August
July
June
May
April
March
February


2017
December
November
October
September
August
July
June
May
April
March
February
January


2016
December
November
October
September
August
July
June
May
April
March
February
January


2015
December
November
October
September
August


Categories

All Episodes
Archives
Categories
Now displaying: Page 1

Hosted by Carlos L Chacon, the SQL Data Partners Podcast focuses on Microsoft data platform related topics mixed with a sprinkling of professional development. Carlos and guests discuss new and familiar features and ideas and how you might apply them in your environments. Visit our website for episode show notes at sqldatapartners.com/podcast and leave a comment if you have a topic you think we should discuss. We’ll see YOU on the SQL Trail.

Jun 15, 2022

IT workers will generally claim they like learning new technology—it is almost a required attribute.  Why then is bringing in new technology so hard?  In this episode, we explore how new technologies make their way into organizations and how we might either embrace them or how this becomes a major challenge.  There are so many new technologies now, it is very difficult to keep up with.  I would love to hear from you on this.  Please share with us your success stories on bringing in new technology and how it benefited you or your organization.

The show notes and video can be found at https://sqldatapartners.com/2022/06/15/episode-247-pushing-the-boundaries-or-pushing-your-luck. Have fun on the SQL Trail!

Jun 8, 2022

While we continue to review the new features of the CTP preview of SQL Server 2022, we turn our attention to the recent Microsoft Build conference and talk about some of the announcements made.  We try to separate the interesting technology from the marketing fluff and what pieces might trickle into the data platform space.  Defining your requirements has never been more important as the number of offerings continue to increase.  We were super excited to hear about Microsoft Intelligent Data Platform; however, a little digging into the technology makes us realize we aren’t quite ready to pay for that service tier.

The show notes and video for today's episode can be found at https://sqldatapartners.com/2022/06/08/episode-246-microsoft-build-2022-announcements. Have fun on the SQL Trail!

Apr 20, 2022

SQL Server Management Studio (SSMS) version 18 was introduced to support SQL Server 2019 and in this episode of the podcast, we discuss some of the new updates available in SSMS and Azure Data Studio.  We talk about scenarios where we use these tools and give some feedback on the new Azure services they support.

The show notes and video for today's episode can be found at https://sqldatapartners.com/2022/04/20/episode-245-tooling-updates. Have fun on the SQL Trail!

Mar 30, 2022

Who made that change?  It is one of those questions that can send chills down the spine of those responsible for databases.  In this episode, Josephine Bush talks with us about how we can use a combination of the native tools—auditing and extended events along with some custom reporting to be prepared for questions about change when more environments are subject to regulation. 

What is great about the community is their willingness to share and Josephine comes through with a set of her own scripts.  What I think is most helpful is the filtering included so you only need to capture the most pertinent changes.  This helps you feel confident you capture the most important pieces without all the extra logging you have to muck through when you actually have a question to answer.

The show notes and video for today's episode can be found at https://sqldatapartners.com/2022/03/30/episode-244-extended-events-vs-sql-server-audit. Have fun on the SQL Trail!

Mar 16, 2022

Conferences are on the uptick as COVID restrictions lift and we are excited for the upcoming year. After Eugene's return from SQLBits my thoughts revolved around what I wanted to learn this year at conferences and how you and I can go about picking the content we want to know more this year. Join us for a quick discussion on deciding what to learn as conference season picks up.

The show notes and video for today's episode can be found at https://sqldatapartners.com/2022/03/16/episode-243-choosing-what-content-to-focus-on. Have fun on the SQL Trail!

Feb 2, 2022

SQL Server 2012 is end of life later this year.  I feel too young for this to be happening—it seems like only last year SQL Server 2005 came out.  In this episode of the podcast, we talk about upgrading your SQL Server.  We share some concepts, gotchas, war stories, situations we want to avoid, how to access license keys in Azure, and a few other migration nuggets we’ve learned along the way.

The show notes and video for today's episode can be found at https://sqldatapartners.com/2022/02/02/episode-242-upgrading-your-sql-server. Have fun on the SQL Trail!

Jan 20, 2022

Do you find you need to keep SQL Server tables in sync across multiple systems?  After several projects involving syncing data, we return to the topic of Azure SQL Data Sync with some real world examples of why we choose this option and how it worked for us.  While there are some limitations, the feature is very stable, and we have had minimal, minor issues with it.  Ideal for environments where latency is flexible, Azure SQL Data Sync could be a very helpful feature to get your data moved.

The show notes and video can be found at https://sqldatapartners.com/2022/01/20/episode-241-replicating-data-with-azure-sql-data-sync. Have fun on the SQL Trail!

Jan 5, 2022

Azure Synapse Link is a feature coming to SQL Server in the next release. While there are few details on what the new feature will look like, we discuss how this same service is implemented in other Azure services.

The show notes and video for this episode can found at https://sqldatapartners.com/2022/01/05/episode-240-azure-synapse-link. Have fun on the SQL Trail!

Dec 15, 2021

SQL Server 2022 has been announced and we are excited to start unpacking the new features. For this episode, we start with a very interesting feature--Bi-directional HA/DR to Azure SQL. We have the ability to failover to the cloud now—the trick is, getting back is not as simple. Now, the on-premises version will be compatible with Azure SQL Managed Instance, and this will give move options for DR—and make setting it up even easier.

The show notes and video for this episode can be found at https://sqldatapartners.com/2021/12/15/episode-239-bi-directional-ha-dr-to-azure-sql. Have fun on the SQL Trail!

Dec 8, 2021

Part 2

Power BI has been described as a “self-service” BI platform. While that may bring to mind an image of easy-peasy, plug-and-play, there are a few things most organizations will want to address before turning users loose with Power BI. In this conversation, Brandon Michals helps us take a look at three areas of consideration: your company, your people, and your data. Spending the time to think through and take the appropriate action in each of these areas will go a long way towards helping your organization achieve a successful Power BI implementation.

The show notes and video for this episode can be found at https://sqldatapartners.com/2021/12/01/episodes-237-and-238-getting-started-with-power-bi. Have fun on the SQL Trail!

Dec 1, 2021

Part 1

Power BI has been described as a “self-service” BI platform. While that may bring to mind an image of easy-peasy, plug-and-play, there are a few things most organizations will want to address before turning users loose with Power BI. In this conversation, Brandon Michals helps us take a look at three areas of consideration: your company, your people, and your data. Spending the time to think through and take the appropriate action in each of these areas will go a long way towards helping your organization achieve a successful Power BI implementation.

The show notes and video for this episode can be found at https://sqldatapartners.com/2021/12/01/episodes-237-and-238-getting-started-with-power-bi. Have fun on the SQL Trail!

Nov 17, 2021

Building your own scripts to monitor SQL Server seems like a very reasonable thing to do. We’re smart folks and SQL Server is what we do for a living—we should be able to figure this out. Upon further inspection, we found it was easier for us to focus on what we do—database administration, and let the developers focus on what they do—build software. This episode explores our choice of SolarWinds SQL Sentry as the monitoring standard for SQL Data Partners.

The show notes for today's episode can be found at https://sqldatapartners.com/2021/11/17/episode-236-database-monitoring-with-sql-sentry. Have fun on the SQL Trail!

Nov 3, 2021

Live Podcast! We decided it was time to try and get together in person and reconnect. As we did, we pulled out the microphone and started recording. As a result, we break the single topic mode this week and opened it up for a Q&A session. We touch on database monitoring, memory grants, what we miss about being in an office, and even SharePoint (Gasp!).

The show notes for this episode can be found at https://sqldatapartners.com/2021/11/03/episode-235-sql-trail-2021-in-person-qa. Have fun on the SQL Trail!

Oct 7, 2021

As a data pro, you are negotiating and problem-solving all the time, often without knowing it. Your success as a professional as your company evolves its Data Platform depends on how well you can communicate and influence. It’s a scary thought, but your ability to negotiate with the business directly often determines if your projects get funded. Those skills are arguably as important as your T-SQL. In this episode, we chat with Blythe Morrow about strategies you can incorporate to better communicate with those around you.

The show notes for this episode can be found at https://sqldatapartners.com/2021/10/06/episode-234-communication-tips-for-the-it-pro/. Have fun on the SQL Trail!

Sep 15, 2021
Never heard of ScriptDOM? Neither had we…okay, except Kevin, who obviously knows all. Apparently, the documentation is scarce. Mala Mahadevan uses it, loves it, and graciously offered to come back to the podcast to educate us and our listeners on a product that can help us parse, process and format our SQL queries.

The show notes and video can be found at https://sqldatapartners.com/2021/09/15/episode-233-scriptdom. Have fun on the SQL Trail!

Sep 1, 2021

Public speaking is not fun for most; however, it can be very rewarding. Chris Seferlis chats with us about a few tips he has on being a speaker. Most of the tactical advice we defer to a toastmasters or public speaking group, so we give some thoughts on preparation, soliciting feedback, audience engagement, and handling criticism. I should point out that public speaking is WAY different from recording videos. We hope you find the information useful. Did we miss anything? Let us know!

The show notes and video for today's episode can be found at https://sqldatapartners.com/2021/09/01/episode-232-giving-technical-presentations. Have fun on the SQL Trail!

Aug 11, 2021

Everyone has bad days; however, how those bad days develop are unique to each of us. In a special episode, we chat with Tracy Boggiano about her experiences with Mental Health, how she has dealt with it, how each of us can work on our own mental health, and phrases we should avoid saying to those with mental health issues. Our own Eugene Meidinger shares a story on negative thinking and how damaging it can be. We hope this conversation will help foster ideas on how you can feel more comfortable talking about Mental Health and making it easier for those who struggle.

One of the core principles at SQL Data Partners is to "Act in a way that expresses care, hope, love, and joy".  As we talked during the episode, I was struck by how this principle is correlated to mental health. I had not made the connection before. While we may not be able to solve other problems, we can show support by expressing care, hope, love, and joy. If we can foster these environments, it will make it easier to get through our own bad day when they happen.

The show notes and video can be found at https://sqldatapartners.com/2021/08/11/episode-231-mental-health-and-wellness-in-it. Take care of yourself on the SQL Trail!

Aug 4, 2021

No one wants to lose data when disaster strikes; however, we need to plan for some data loss and putting all the pieces in place can be tricky. There are two metrics commonly used to measure data loss and availability when it comes to planning for disasters—Recovery Point Objective and Recovery Time Objective. In this episode, we touch on how you might come up with these metrics, how to consider the implementation cost, and how you might go about walking through a disaster situation to test your plan. 

The show notes and video can be found at https://sqldatapartners.com/2021/08/04/episode-230-rto-rpo. Have fun on the SQL Trail!

Jul 21, 2021

The scary part of upgrading SQL Server is finding out you have a problem AFTER the fact. In this episode, Mariano Kovo joins us to discuss the Data Migration Assistant tool from Microsoft. While the name can be a bit misleading, (What? Microsoft have confusing names—that's a first), the major benefit to the tool is the assessment feature to alert you of potential issues when you upgrade. Issues are broken into three major categories:

  • Breaking Changes
  • Behavior Changes
  • Deprecated Changes

While each change should be reviewed, many times we allow deprecated features to remain unresolved as they are still supported in SQL Server; however, we certainly want to put those on the backlog because one day Microsoft will finally pull the plug and we want to be ahead of the curve. 

You can find the show notes and video for today's episode at https://sqldatapartners.com/2021/07/21/episode-229-data-migration-assistant. Have fun on the SQL Trail!

Jul 14, 2021

As data practitioners, we want to get ahead of any problems that might come up and share those insights with others on our team. In this episode, Edward Pollack gives us a few scenarios we might consider as we attempt to prevent application issues. These techniques also go into the security space and could help prevent data loss. As we collect this information and make it available to others, we can also demonstrate the ROI we provide to the organization.

You can find the show notes and video for this episode at https://sqldatapartners.com/2021/07/14/episode-228-predicting-application-problems-with-database-metrics. Have fun on the SQL Trail!

Jun 23, 2021

Organizations look to constantly improve and offer better services and the application tooling has been built to accommodate the process. Database tooling has been a bit slower to develop; however, in this episode Eitan Blumin, a co-host at sqlserverradio.com, brings us up to speed on the latest features of SQL Server Data Tools with some thoughts on how to get started with continual deployment or ‘devops’.  We know this can feel like a steep learning curve for folks without a programming background and we share a few resources for you to get started.

The show notes and video can be found at https://sqldatapartners.com/2021/06/23/episode-227-ssdt-methodologies-for-db-devops/. Have fun on the SQL Trail!

Jun 9, 2021

Let’s say you have completed a lift and shift VM hosting to the cloud.  Great—you now use Iaas services.  While you don’t have to worry about the hardware, managing the software can be problematic.  The SQL Server IaaS Agent Extension can offer some PaaS-like services and make it easier to manage the database environment.  In this episode we chat with Ameena Lalani from Microsoft about this feature, why you might want to enable it, the prerequisites, and the downsides.  She also shares her daily guilty pleasure and Kevin lets it be known he doesn’t put toppings on his ice cream anymore.

The show notes and video for this episode can be found at https://sqldatapartners.com/2021/06/09/episode-226-sql-server-iaas-agent-extension/. Have fun on the SQL Trail!

May 26, 2021

Have you ever created a report in a visualization tool, spent all this time and energy creating something that looked really cool, went through more edits than you could remember only to deliver the report and have the recipient go “What am I looking at?” I don’t think I am the only one and, in this episode, we explore some of the rookie mistakes IT pros make when creating visualizations.

The show notes and video for this episode can be found at https://sqldatapartners.com/2021/05/26/episode-225-dashboard-design-principles. Have fun on the SQL Trail!

Apr 28, 2021

Carlos, Kevin, and Eugene reconnect after some time away with a new streaming time.  Long form conversation on a single topic is also the place we want to get back to in our podcast. 

The show notes and video for today's episode can be found at https://sqldatapartners.com/2021/04/28/episode-224-the-standup-meeting/. Have fun on the SQL Trail!

Apr 14, 2021

With both Kevin and Eugene busy this week, Carlos went solo to share a few changes to the podcast, including the Twitch livestream moving to Tuesday, how you can support the podcast, and podcast episodes going back to being published every other Wednesday. If you have a subject that you’d like to chat about on the podcast with us, we’d love to schedule a time with you…go to sqldatapartners.com/podcast to sign up. We invite you to submit to our Call for Speakers for SQL Trail June 2021, starting April 15th, and whether you speak or not, to attend SQL Trail on June 15th. Carlos also discusses how you can join the SQL Data Partners team as an independent contractor.

The show notes for today's episode can be found at https://sqldatapartners.com/2021/04/14/episode-223-podcast-update. Have fun on the SQL Trail!

1 2 3 4 5 6 7 Next » 10