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
2023
January


2022
December
November
October
September
August
July
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: Category: SQL Server

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.

Jan 17, 2023

We kick off the new year discussing a new feature in SQL Server 2022 called Transact-SQL snapshot backups. Good luck with the Google search on this feature--we know we had fun. 😊 These are not the snapshot backups you were frustrated with in 2005. We talk a little bit about who will be interested in this feature and what scenarios it will come in handy. The hardware vendors seem particularly excited about this future as they can now introduce snapshots without needing a third-party application like Veeam to do that for them. We predict more collaboration between the database administrator and the hardware administrator with this feature. We also get a couple of use case scenarios from the community that we share in this episode. Are you looking forward to using snapshots more effectively in your environment? Please let us know your thoughts!

The show notes and video for this episode can be found at https://sqldatapartners.com/2023/01/18/episode-259-t-sql-snapshot-backups/. Have fun on the SQL Trail!

Dec 27, 2022

As we close out the year, we take a look back and think about all those SQL Server 2022 episodes we didn’t record this year—and then make the goal to increase this count in the new year. 😊 We discuss some of the Cardinality Estimation changes in this version and the scenarios in which this may affect other features. I ask Kevin and Eugene what technologies they will be focusing on in the year ahead and how many books Kevin is going to try and write. From all of us at SQL Data Partners, we wish you and yours a Happy New Year!

The show notes and video for today's episode can be found at https://sqldatapartners.com/2022/12/28/episode-258-leave-2022-enter-2023. Have fun on the SQL Trail!

Nov 30, 2022

Have you ever thought about working for yourself? It can be very enticing for some, and in this episode, we talk with John Sterrett about the pros and cons of running your own organization. We tackle some of the reasons you might get started and we share some of our experiences of working in our own organizations. Each person’s journey is going to be different and as hard as it will be, you need to ensure you don’t allow others success or failure to overly influence your decisions. As the work environment has shifted in the last two years, it may that be some of the previous ‘whys’ no longer apply. If you have thoughts around this, let us know!!

The show notes and video for today's episode can be found at https://sqldatapartners.com/2022/11/30/episode-257-the-business-of-working-for-yourself. Have fun on the SQL Trail!

Nov 3, 2022

Seven years ago, I started the SQL Data Partners Podcast. We have now arrived at Episode 256, and we dedicate this episode to you, the community. Thanks to everyone who has joined us along the way, and we hope to continue providing content you can enjoy on the go while still connecting with your SQL Server community. While we originally thought we might focus on SQL Server 2022, we really found there are just lots of great topics to be covering in the future. We hope you enjoy this special community edition of the SQL Data Partners Podcast.

The show notes and video for this episode can be found at https://sqldatapartners.com/2022/11/03/episode-256-the-community-episode/. Have fun on the SQL Trail!

Oct 5, 2022

One of the biggest challenges with developers using object-relational mapping (ORM) tools is the bad queries or procedures they create. Sure, most tools can create CRUD (Create, Read, Update, Delete, Upsert) procedures, but what about the extremely advanced safe dynamic Search stored procedures? My bet is they are super inefficient and could be improved. In this episode of the SQL Data Partners Podcast, we talk with Kevin Martin, the creator of sp_CRUDGen, about how his procedure can help your developers create better CRUD-type stored procedures. As always, we are super excited about sharing what our great community is working on, and we think there will be value in the work Kevin has put together. Have you used sp_CRUDGen? We’d love to get your thoughts.

The show notes and video for today's episode can be found at https://sqldatapartners.com/2022/10/05/episode-255-automate-complex-crud-with-sp_crudgen/. Have fun on the SQL Trail!

Sep 21, 2022

Would you be interested in a tool to help you do code review checks and provide developers guidance on best practices? In this episode of the SQL Data Partners Podcast, we talk with Kevin Martin, the creator of sp_Develop, about how his procedure can help you review naming conventions, table conventions, data type conventions, SQL code conventions, data issues, and even configuration issues. Kevin was approached about writing a best practice document but ended up writing a stored procedure you and I can use to help our environment. We love sharing what community members have done and hope you enjoy this conversation with Kevin on the tool. He is looking for folks to help him build out items, so if you have a suggestion, be sure to include it in GitHub.

The show notes and video for today's episode can be found at https://sqldatapartners.com/2022/09/21/episode-254-code-smell-checks-with-sp_develop/. Have fun on the SQL Trail!

Sep 7, 2022

In this episode, we dive into the Power Apps offering and discuss the pros and cons of using this latest Microsoft offering. Some definitions are given and hopefully this episode can orient folks on how to position Power Apps in their organizations.

The show notes and video for today's episode can be found at https://sqldatapartners.com/2022/09/07/episode-253-go-mobile-with-power-apps. Have fun on the SQL Trail!

Aug 24, 2022

Knowing your SQL Server is patched when an issue occurs is worth the effort of keeping it patched. While I don’t suggest a zero-day install for most folks, setting up a regular cadence to check is a reasonable ask if you have to manage a system. In this episode of the SQL Data Partners Podcast, we discuss the need for patching and how you might go about it. Special shoutout to Episode 112 with the late Robert Davis on the same subject. We would also like to thank the fine folks at dbatools.io for some nifty PowerShell to help us install patches and Brent Ozar for keeping up sqlserverupdates.com. If you have some additional ideas on how to best meet your patching needs, let us know via social media!

The show notes and video for today's episode can be found at https://sqldatapartners.com/2022/08/24/episode-252-the-cumulative-update-dilemma. Have fun on the SQL Trail!

Aug 10, 2022

How can you begin to integrate AI models into your environment without spending months building everything out? As we continue our march to Episode 256, we bring back our friend Sam Nasr to talk about Azure Cognitive Services. Sam walks us through a few examples of how he was able to leverage some pre-packaged voice recognition services to assist customers get to the proper area for service. We discuss scenarios where Azure Cognitive Services really shines and where you may have to develop more custom solutions or look for extensions. If you are using Azure Cognitive Services, let us know your experience!

The show notes and video for this episode can be found at https://sqldatapartners.com/2022/08/10/episode-251-azure-cognitive-services. Have fun on the SQL Trail!

Jul 27, 2022

This episode we are doing a bit of a look back and are going to air some previously buried content.  Some of the bloopers are pre-video and some of them have some physical comedy, which you’ll have to go to YouTube to see. While a few were cut out of the published episodes, they are mostly things you’ve never heard.

The show notes and video for this episode can be found at https://sqldatapartners.com/2022/07/27/episode-250-what-happens-before-companeros/. Have fun on the SQL Trail!

Jul 13, 2022

Data marts in Power BI have arrived and the words “data mart” mean something to data professionals.  In this episode of the SQL Data Partners Podcast, we introduce the latest offering in Power BI and discuss the good, the bad, and the ugly for teams looking to arrive at self-service business intelligence.

The show notes and video for this episode can be found at https://sqldatapartners.com/2022/07/12/episode-249-data-marts-in-power-bi/. Have fun on the SQL Trail!

Jun 29, 2022

How do you keep records of your SQL Server environments?  Patching levels, security accounts, configuration options, maintenance jobs and the like are some of the pieces we have to keep organized.  Are you using something besides Excel to keep up with this?  Sure, we can use the Content Management Server (CMS) to query across several instances, but we still need to organize this information somewhere.  Our guests for this episode, Sean and Jen McCown, discuss inventory challenges with us and why this information is important.  We might also get into some new features of their software, MinionWare.  If you have a suggestion we didn’t discuss, please let us know!

The show notes and video for this episode can be found at https://sqldatapartners.com/2022/06/29/episode-248-inventory-documentation. Have fun 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!

1 2 3 4 5 6 7 Next » 10