SQL Data Partners Podcast = Expert Interviews + Professional Development +Listener Q&A
The SQL Data Partners Podcast
In this podcast, I discuss a variety of SQL Server related topics mixed with a sprinkling of professional development and I talk with some of the biggest names in the industry. I 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. I hope you will join me 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, I 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.
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 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.
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 no 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.
In Episode 59 we talked about general data availability options and 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 book 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 eco system of reporting for data professionals.
We talk storage options, LUNs, IOPs, with Argenis Fernandez and he share 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 care and feeding of Indexes.
Dataveloper, SET STATISTICS IO ON, Richie Rump and statisticsparser.com OH MY!http://sqldatapartners.com/wp-admin/post.php?post=730&action=edit#
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!
This is Episode 15. 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 happen 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 Red gate software. Grant is a Microsoft SQL Server MVP, and product evangelist for Red gate.
This is episode 9, and today we’re talking about automation.Interestingly enough, this September 2015 T-SQL Tuesday theme was, “Strategies for Managing an Enterprise.”
I chat with Microsoft MVP Chris Bell about database security and some 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 to them. We talk about keeping up with Technology and the importance of mentoring.
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 and talk about U-SQL and where it fits into the pyramid of tools available for use 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 and in this episode we, the hosts, attempt to answer this question and Carlos and Steve 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.
Episode 52: R in SQL Server
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 a ‘everything in the cloud’ approach.
Have you ever looked at some tsql code and thought–How does 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?
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, 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.
Have fun on the SQL trail compañeros.
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. This is 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 will Louis Davidson about database design and get his thoughts on some strategies about 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.