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.
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. The idea of deploying code and having a certainty it will run correctly instead of crossing your fingers and hoping you don't see the red error messages has a certain appeal. There are lots of tools out there now to help with this, but it seems like we still drag our feet.
I know I did. When I chatted with Cindy Bean from DBMaestro, I didn't have much database change automation experience. I had exposure to source control, but DevOps seemed more than that. After speaking with Cindy I created my first database project in Visual Studio. I definitely get the idea and hope to implement it fully in my environment. This episode is an introduction to the idea of database change automation and how you might get started.
You can see the shownotes from today's episode at http://sqldatapartners.com/2016/01/12/devops/
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.
I chat with Anthony van Gemert, one of the product managers for stretch, about how the features works and under what scenarios organizations might use stretch technology.
Are you planning to use stretch database? Let me know via twitter. I am @CarlosLChacon. You can check out the show notes at http://sqldatapartners.com/2016/01/06/episode-25/