SQL Data Partners Podcast

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.

Mike says there are two reasons why PowerShell is valuable for SQL Server folks.  I hope you will join us for the conversation.  We promise not to bore you with syntax. 

Are you using PowerShell?  I would love to hear your stories in the comments at the bottom of the show notes page at http://sqldatapartners.com/2016/02/23/powershell/

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. Troubleshooting issues in a virtual environment can be a bit tricky and in today's episode I chat with David Klee about his experience and how you might learn from his experience.

What has been your experience with virtualization? I would love to hear from you in the comments on the show notes page http://sqldatapartners.com/2016/02/16/virtualization/.

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.  Troubleshooting issues in a virtual environment can be a bit tricky and in today's episode I chat with David Klee about his experience and how you might learn from his experience. 

What has been your experience with virtualization?  I would love to hear from you in the comments on the show notes page http://sqldatapartners.com/2016/02/16/virtualization/.

Think of one big investment that will be made this year. How will it affect you? Perhaps there is a large server migration project or move to Azure on the books this year. Maybe you have been given the ok to try some new feature or have been promoted and have different responsibilities. You will make many decisions and purchase different things, but the biggest investment you should be involved in is the investment in yourself.

I am joined by Bruce Van Horn, host of the Life is a marathon podcast and the person that introduced me to the E to E ratio. The Entertainment to Education ratio is a gauge for how much of your time is spent entertaining yourself versus how much you education yourself. We discuss how this affects your future opportunities but also how it affects your happiness.

How do you keep yourself educated? I would love to hear about it. You can leave your comments and see the show notes for today's episode at http://sqldatapartners.com/2016/02/09/e2eratio/.

Think of one big investment that will be made this year.  How will it affect you?  Perhaps there is a large server migration project or move to Azure on the books this year.  Maybe you have been given the ok to try some new feature or have been promoted and have different responsibilities.  You will make many decisions and purchase different things, but the biggest investment you should be involved in is the investment in yourself.

I am joined by Bruce Van Horn, host of the Life is a marathon podcast and the person that introduced me to the E to E ratio.  The Entertainment to Education ratio is a gauge for how much of your time is spent entertaining yourself versus how much you education yourself.  We discuss how this affects your future opportunities but also how it affects your happiness.

How do you keep yourself educated?  I would love to hear about it.  You can leave your comments and see the show notes for today's episode at http://sqldatapartners.com/2016/02/09/e2eratio/.

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. If you think about scanning a Microsoft Excel document, how would you find the record you are looking for? How does that differ from SQL Server?

My guest for this episode is Brent Ozar and we chat about internals and how SQL Server processes your request and what you need to consider as SQL Server returns your result.

Our show notes for today's episode are available at http://sqldatapartners.com/2016/02/03/sqlserverthinks/

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.  If you think about scanning a Microsoft Excel document, how would you find the record you are looking for?  How does that differ from SQL Server?

My guest for this episode is Brent Ozar and we chat about internals and how SQL Server processes your request and what you need to consider as SQL Server returns your result.

Our show notes for today's episode are available at http://sqldatapartners.com/2016/02/03/sqlserverthinks/

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? Baselines can help us out. More often than not, tribal knowledge rules the day and if you weren't part of the tribe when the on-call pager goes off, things can be tough to figure out.

My guest this episode is Erin Stellato of SQLskills and we discuss what your baseline should consist of and how you might go about capturing some of that data. I am always interested to see how people monitor their servers and I know this episode will give you a few things to think about in your baselines.

Get the show notes for today's episode at http://sqldatapartners.com/2016/01/27/baselines and I'll see you on the SQL trail.

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?  Baselines can help us out.  More often than not, tribal knowledge rules the day and if you weren't part of the tribe when the on-call pager goes off, things can be tough to figure out.

My guest this episode is Erin Stellato of SQLskills and we discuss what your baseline should consist of and how you might go about capturing some of that data.  I am always interested to see how people monitor their servers and I know this episode will give you a few things to think about in your baselines.

Get the show notes for today's episode at http://sqldatapartners.com/2016/01/27/baselines and I'll see you on the SQL trail.

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. The level of difficulty to get this feature set up lends to the small adoption rate, but I chat with Melody Zacharias about her experience with the tools and I think it is time to give this feature a spin.

You can see the show notes from today's episode at http://sqldatapartners.com/2016/01/19/distributedreplay/. You can also let me know if you are you using Distribute Replay What do you think the best feature is? What is the worst thing about it? Leave your thoughts in the comments below the show notes. I look forward to hearing from you.