SQL Server Podcast = Expert Interviews + Professional Development +Listener Q&A
The SQL Data Partners Podcast
In this SQL Server podcast, Steve Stedman and Carlos L Chacon discuss a variety of SQL Server related topics mixed with a sprinkling of professional development. We want to introduce new and familiar topics and talk about them in a way you may have not considered. We are all on different stages as data professionals, and we can all something new. We hope you will join us on the SQL trail compañeros–you won’t regret it.
The podcast is available on ITunes, Stitcher, Google Play (must be signed in), Podbean and Feedly! Here you can listen to all the episodes! The show notes are on each episode page–use the links at the bottom to get there.
Did I miss something or not quite get it right? You can hit me up on twitter. Don’t worry, we don’t bite.
Leave a Review
If you’ve got the chance, please take a couple seconds to leave a rating and review on iTunes! Doing so helps the show climb up the iTunes rankings so more folks can enjoy the show as well.
Enjoy the podcast companeros, and have fun on the SQL trail.
Have a comment or a question for the show?
You can now record a voice message! Let us know what you are thinking and we will put you on the show! Comments are limited to 90 seconds.
Have a Topic We Should Discuss?
We would love to hear from you about topics or ideas you want us to suggest. What to be a guest on the podcast? We want to hear from you too.
Tell us about your topic
Sean brings us up to speed on the latest in index maintenance.
If you have the itch, how do you know when you should jump?
A discussion on replication, when you should use it and how best to administer it.
Steve and I talk about making mistakes, why they are important and how to recover when they happen.
We chat with the team at DBA Tools.io about the problems they are trying to solve and how you can get involved.
Get better stats from your database and tame wild processes at the same time with Resource Governor.
Not everyone had a smooth transition to SQL 2016 and Javier shares his experience.
There are lots of reporting tools out there, but how many times have you thought about what your reports actually look like?
Getting back to basics, we talk about indexes and the implications of choosing or not choosing the way your data is structured.
We talk with Andy Leonard about the SSIS catalog and some of the issues migrating packages between environments.
We kick off the new year talking with Paul Turley about why there are so many reporting tools and under what conditions you might use the new features in SSRS.
Argenis shares his thoughts on how should you be testing your data storage.
We have all been there–next, next, next–let’s just get this install done. While there are many ways to get SQL Server installed on a server, the real impact is in the way we administer the database and when we want to get good performance.
Hear from Microsoft MVPs and SQL Server consultants such as Allen White, Kevin Feasel, Jonathan Stewart, Tim McAliley and others, as they give their thoughts on setting up and testing the test environment.
Does your organization use a data warehouse? Maybe you have a cube but find it hard to maintain? This week on the SQL Trail, Steve and I chat with Jason Horner about building a good data architecture.
In Episode 59 we talked about general data availability options. In this episode we focus on the new features of Availability Groups in 2016 and how data availability options have changed with our guest John Sterrett. John shares his experience getting a large database to a highly available situation along with some other ways to use availability groups.
Have you ever experienced a post-project meeting that seemed more like a game of point-the-finger and less about lessons learned? We have! That’s why we brought Russ Thomas on the show for Episode 61, “The Debrief”.
Steve and I chat with Andy Mallon and Mariano Kovo about the differences between availability groups, mirroring, log shipping, and replication.
Steve and I take a page out of the SQL Server Radio book and talk about 10 of our least favorite features.
Jessica M. Moss drops in the studio to talk about some of the new features of SSRS and how this plays into the larger ecosystem of reporting for data professionals.
We talk storage options, LUNs, IOPs, with Argenis Fernandez and he shares why he thinks we all need to approach storage a lot differently.
How would you feel if you could automate all of your mundane, routine SQL Server tasks? If you’ve ever wondered how to get started in PowerShell, then this episode is for you.
When you code and you need to use a temporary object what do you use in SQL Server–temp tables or a table variable?
As data size expands and the way we interact with data changes, in many cases we will need more than one way to store and access that data.
Talking with Wolf about possibly one of the most underrated SQL Server features–Service Broker.
If you’ve ever thought about improving your ETL game, this episode is for you. We discuss some of the issues facing ETL folks.
Does the thought of setting up your index maintenance plan keep you up at night? Are you looking for ways to make the job easier? This episode is about the care and feeding of indexes.
Dataveloper, SET STATISTICS IO ON, Richie Rump and statisticsparser.com OH MY!
We chat about Microsoft PowerBI. PowerBI is a business intelligence tool that easily connects disparate data sources to create dashboards.
On Episode 35 of The SQL Data Partners Podcast, I talk with Philip Morgan of The Positioning Manual for Technical Firms. Philip’s book has influenced my work at SQL Data Partners, so I wanted to bring him on and share his insights with the rest of you on the SQL Trail.
In this episode of SQL Data Partners, I chat with Amy Herold about making the move from development to database administration.
As database administrators, we have to live with virtualization. As a consultant, I can’t think of a single environment I have been in that didn’t have some of the SQL Servers virtualized.
We each have our way of going about things–this is what makes us unique. When it comes to getting data out of the database, many times we might think that SQL Server would go about getting data the same way we would.
Have you ever wanted a feature to help you assess the impact of future SQL Server upgrades, the impact of hardware or operating system upgrades, and for SQL Server tuning? Well, that tool has been around since 2012, but I have found that not many people have used Distributed Replay.
SQL Server 2016 has several new features and this episode explores the stretch database feature. One of the unique attributes of this feature is that it uses both the on-premise instance and the Azure platform.
If I were a betting man, I would wager your disk IO system is probably the biggest bottleneck in your SQL Server right now. Sure, there are lots of moving pieces, but if you can tame the IO situation, you are putting yourself in the drivers seat.
As one of the newest Azure offerings, Azure Data Factory can at first thought be compared to SSIS. I don’t think we are quite there yet with the comparisons; however, I talk with MVP Reza Rad and discuss some of the similarities and differences between the two.
A hard drive is a hard drive, right? Storage has come a long way, but is probably still the biggest bottleneck in your system. Solid State Drives (ssd) have changed the rules in terms of performance and there is new technology on the horizon to allow us to access our data even faster.
Do you find you have tables and indexes that have grown really large? Are you moving around a lot more data than you used to? Are your windows for jobs and maintenance getting tighter? If you answered yes to any of these questions, partitioning may be for you!
Compañeros, today we’re going to take a look at the life of two DBAs that work at a university, and get their experiences. The release date for this episode is October 28th of 2015.
Today we’re going to talk about the APPLY operator, something that I probably am not using enough. I happened to be in Pittsburgh listening to Kevin Feasel’s talk about the APPLY operator. He kind of made me a believer.
Today were talking about statistics, with Grant Fritchey from Redgate Software. Grant is a Microsoft SQL Server MVP, and product evangelist for Redgate.
This is episode 9, and today we’re talking about automation. Interestingly enough, the September 2015 T-SQL Tuesday theme was “Strategies for Managing an Enterprise.”
I chat with Microsoft MVP Chris Bell about database security and some of the seemingly cavalier attitudes some organizations have about keeping data safe.
Robert Verell and I chat about good security practices and the principle of least privilege.
Let’s start at the very beginning–making sure you have a good backup!
I chat with Ayman Al-Ghazali and Tim McAliley about their careers at Microsoft and the impact it has made on them. We talk about keeping up with technology and the importance of mentoring.
How databases are changing and what that means for the administrator
We discuss how you can monitor and get alerts on your availability groups.
The two-time Microsoft MVP talks with us about her journey and what it takes to make the cut.
We talk with Andrew Pruski about containers in SQL Server and how he is running them in Windows environments.
Brian Carrig from ChannelAdvisor shares his experience converting to SQL Server 2016 and some of the features they are using.
Jimmy May shares his experience testing the improvements to the availability groups.
Steve and I talk about 2016 and what lays in store for 2017.
How can you automate testing for a data warehouse–we have some ideas.
Travis Wright is the program manager for the SQL Server transition to SQL Server on Linux.
For all of us working with data, we know that we work not only with SQL Server but the suite of tools around the SQL Server engine. In this episode, we share some thoughts around SSIS administration, which is the most popular ETL tool in the Microsoft stack.
In episode 66 I talk with Microsoft Training Author Graeme Malcolm. After talking with Patrick Thomas in episode 64, I was introduced to Microsoft’s newest learning curriculum, the Microsoft academy, and their first offering in data science.
In Episode 64 of the SQL Data Partners Podcast, I talk to Patrick Thomas the program manager for the Microsoft MCP and MCT programs and the role they play at Microsoft and in what way they continue to provide value, including what’s in store for data science learners and what he thinks of the Microsoft purchase of LinkedIn.
Have you heard the buzz around the Cortana Intelligence Suite? It seems like it is all the rage these days and Microsoft is coming out with lots of new features in this space.
In the never ending catalog of Azure services, we invite AZ into the studio to talk about U-SQL and where it fits into the pyramid of tools available for us to use.
With all the changes in technology, how do you stay up to date with your technical learning? This is a question we have been asking our guests the last several episodes. In this episode we, the hosts, attempt to answer this question and give some thoughts on how we stay up to date.
We are joined by Jonathan Stewart, Kevin Feasel, Mike Fal, and Microsoft employee Scott Klein to discuss our favorite SQL Server 2016 features during the Columbus SQLSaturday event in July.
We chat with CEO Andrew Rose from compare.com and Jim McCullen VP of technology with Century Distribution about how they see the role of the database administrator changing and what they would like to see DBAs bring to the table.
We talk about using Revolution Analytics or R with SQL Server: its origins, how to get started, and what to look out for as your organization starts looking at implementing R.
Microsoft has provided a few knobs for us to tweak in the Operating System, the local security policy, and in the engine itself.
The last several years have brought a myriad of new technologies for how to store and report on your data. Microsoft’s first cloud offering was all about services in the cloud and they were pitching an ‘everything in the cloud’ approach.
Have you ever looked at some tsql code and thought: How does it even run? I know I have and it can be daunting to take a piece of code and review it for performance or to make a change to it.
Episode 44 takes us into a new service in the Microsoft cloud–Azure SQL Data Warehouse.
Today’s stop on the SQL Trail is all about SQL Server auditing. We all know we should do it, but is the default setup really going to keep you covered?
Let’s squeeze ALL the data–perhaps not always the best idea.
Episode 38 of the SQL Data Partners Podcast covers a SQL 2016 case study that really shows the value of a knowledgeable SQL Server DBA using the latest SQL Server toolset.
We discuss when to use virtual machines in Azure, and the difference between Azure SQL Server and Azure VMs running SQL Server.
You’ve heard of Hekaton and in-memory OLTP before, but what does in-memory really mean for your database? Perhaps you have questions like I did, like how does in-memory OLTP differ from disk-based tables? What data types aren’t allowed in in-memory tables? Is in-memory only an “on premises” feature or does Hekaton work in Azure too? Is there a minimum amount of memory required for in-memory tables?
PowerShell, isn’t that a Windows Administration tool? This is certainly how it is positioned by Microsoft, but why should the DBA community give it more than a passing glance? My guest is Mike Fal and we chat about ways data pros can use PowerShell.
Think of one big investment that will be made this year. How will it affect you? You will make many decisions and purchase different things, but the biggest investment you should be involved in is the investment in yourself.
Have you ever had a situation where performance got worse and you were sure why? Do you keep records of when changes happen to your system? How do we know there’s a problem? If we have a baseline, this can help us out.
DevOps for the database–you have probably heard the term if you work in an organization that is deploying code on a regular basis. The developers have this down to a science, and now it is the database’s turn.
One of the new features being added to SQL Server 2016 is the Query Store which will allow for greater access to the performance history of your databases. This is going to be extremely helpful when you are approached about ‘What happened this morning?’ With the Query Store feature, you will now be able to provide some insight into that question.
If you are using SQL Server and haven’t used sp_whoisactive before, I invite you go and download it right now, then come back and listen to the program. We will wait for you.
We all start somewhere and if you can find a mentor who will help you on your way by pointing you in a direction you had not considered, you are a lucky person indeed. This episode I chat some fellow podcasters about their experience with mentors and the characteristics we think good mentors have.
I learn stuff every day. In this episode I tackle a new subject for me and one I am hearing a lot about–BIML. BIML is a markup language you can use to build your SSIS packages.
Welcome to another great edition. I’m super excited to have Mark Wilkinson on the show today. As this goes to show you, you can always learn something new. One of the great things about the SQL Server community is their willingness to share.
Today, we are talking about clustering, with Paul Popovich. Just to make sure that we’re on the same page, this is the clustering that has been around for a while. I think at least 2005, it was available. This is not the availability groups that have become a little bit more popular in SQL Server 2012.
We’re talking about corruption today. Certainly, that’s a challenge that all data professionals need to consider. Steve had a corruption challenge earlier this year and it was very heavily attended. Lots of big names threw their hat into the ring there.
Today we’re going to change things up a little bit, and talk about Test Anxiety when it comes to Certification Testing. We’re also going to discuss some preparation techniques that we can use as well. Before we get into the guest for today’s show, we do have a few changes coming, and that is, I have a new microphone.
I chat with Louis Davidson about database design and get his thoughts on some strategies on how to go about making your design and what tools are available to help you.
Steve Jones and I talk about the need to build your own brand and we share a few ideas on how to do that.
We finish up our conversation with MVP Tim Radney on backup options with discussions on advanced techniques like encryption and backing up to Azure.
I speak with Javier Villegas a 20-year veteran in the DBA world, from the beautiful country of Argentina, about extended events and what they are used for.
Today I am super happy to announce the launch of my podcast and I start with episode 00. In this episode I take some time to go through my journey in becoming a data professional and how I think the podcast will be of value to you.