Episode 118: How has index maintenance changed?
After having attended PASS Summit and seeing all the new features coming it out, it can be very easy to overlook the basics--they are boring. These features have been around forever. This may be true, but they still play an important role and ignoring them won't help get you those fancy new features any time soon. In this episode, our topic is index maintenance, with an emphasis on what has changed or what might change. Is the query store feature going to impact the way we maintain our indexes? We invite one our favorite guests, Sean McCown back to talk with us and give some of his thoughts. The show notes from today's episode can be found at http://sqldatapartners.com/2017/11/24/index-maintenance. Have fun on the SQL Trail!
24 Marras 20171h 5min
Episode 117: PASS Summit Retrospective
Have you ever had a week without a Wednesday? Me neither, so for this episode, we recap our experience at PASS Summit and talk about all the amazing compañeros we met and give some thoughts around our very first meetup. It was so much fun to meet everyone and both Steve and I gave sessions, which was a great experience--and a first for me. One, we both realized after the fact is, we are not good at social media or taking pictures! We apologize we don't have a bit more to share on that front, but hey--we do have faces for radio. The show notes from today's episode can be found at http://sqldatapartners.com/2017/11/15/episode-117-pass-summit-retrospective/. Have fun on the SQL Trail!
15 Marras 201741min
Episode 116: Are people still using PSSDiag?
If you have ever worked with Microsoft support, you probably came across the PssDiag tool they use to collect information about your environment. My experience with the tool is it always seemed, well--a bit clunky. Now, it does collect lots of information and seemed to be a bit overwhelming when I was first a DBA. Fast forward a few years and PssDiag was not a tool I use anymore and was not sure if anyone outside of Microsoft was using it. I run into Jared Poche in Raleigh and he mentions he really likes the tool and mentions some of the improvements they have made over the years. Well, you can guess where this is heading. We talk with Jared about his experience with the tool and cover some of the basics about how you might go about using this tool in your environment. There are two pieces to this tool, the first is the utility that collects the data and the second is the reporting piece SQL Nexus. Are you using PssDiag? Let us know if the comments below. The show notes for today's episode can be found at http://sqldatapartners.com/2017/11/07/episode-116-are-people-still-using-pssdiag. Have fun on the SQL trail!
8 Marras 201737min
Episode 115: The Companero Conference Retrospective
It was a beautiful idea. Gather together with a group of our podcast listeners in a conference type format and find ways for us to connect and help each grow. I had seen it down in other events; however, I wanted to add my own flavor. I wanted this to be different. While the event turned out great and we got good marks from the attendees, we didn't have the response we were hoping for. In this episode of the podcast, we have our companero conference retrospective. We try to give our honest feedback about what we did well, what could have been improved, and what the attendees reported. I can't say enough about the help I got from our speakers--Jonathan Stewart, Kevin Feasel, Randolph West, Tracy Boggiano, and Doug Purnell. They were awesome and the event was much simpler because of them and their commitment. They are truly my companeros on the SQL trail. The show notes for today's episode can be found at http://sqldatapartners.com/2017/10/31/episode-115-the-companero-conference-retrospective. Have fun on the SQL trail!
1 Marras 201744min
Episode 114: How do you start consulting?
One of the advantages to a small conference is the ability to take attendee feedback and put it in place during the conference. We actually made time for the attendees to pick topics they wanted to discuss and this episodes comes from one of our attendees Aaron Hayes. It can be very tempting to think of the good life of consulting. I almost liken it to playing the lottery--what am I going to do with all that time and money? While the odds on successful consulting are a bit higher than the lottery, just saying you are a consultant won't automatically bring in the clients. The reasons data professionals get into consulting are varied and in this episode we are joined by Randolph West and Jonathan Stewart, former podcast guests, to talk about the reasons we started consulting and some of the challenges along with our decision. From my own personal experience, working for yourself--whether you consider yourself a contractor or a consultant--is very rewarding but demanding work. There is no one to tell you want to do, but there are very few security nets as well. One of the most important ideas I can suggest for those who want to own their own business is--forget the technology, how are you going to help other people? If you are ok with the idea of focusing on others, then there are great opportunities in store. Do you have thoughts about jumping into technology? Let us know in the comments below. The show notes from today's episode can be found at http://sqldatapartners.com/2017/10/20/episode-114-how-do-you-start-consulting. Have fun on the SQL trail!
25 Loka 201724min
Episode 113: Standing on the shoulders of giants
"If I have seen further, it is by standing on the shoulders of giants." Those words are attributed to Issac Newton and they are fitting for the way I was feeling recently as I thought back to those who have helped me in my career. While we might always want things to be better, as technologies we have it pretty good. There are unnumbered people who have dedicated untold amounts of time so we can have the tech available to us. We take a moment to think about those who have paved the way for us to be where we are now. Whose shoulders are you standing on? Let us know in the comments below. The show notes for today's episode can be found at http://sqldatapartners.com/2017/10/11/giants/. Have fun on the SQL trail!
11 Loka 201723min
Episode 112: Keeping up with patching
When listener Mel Vargas first suggested the topic of patching, I was not sure this would work as a topic; however, the Equifax story had just developed and there are many other security related issues that could be prevented with patching. Match that with our guest, Robert Davis, who just happened to publish some articles on patching and I decided we needed to do this episode. I should never have doubted this as topic. While we are a bit more protected in SQL Server than others, the security threat is still real and this is something everyone has to go through. Robert presents us with some interesting details on how he goes about patching and we think you will find the episode compelling. The shownotes for today’s episode is found at http://sqldatapartners.com/2017/10/04/episode-112-keeping-up-with-patching/ and have fun on the SQL trail.
4 Loka 201748min
Episode 111: How do you prepare for conferences?
Sometimes just getting approval to attend a conference is a challenge, but getting the green light isn't the only thing you should plan for. Sure, you want to learn some things--but a google search can teach you too. In fact this week we are hearing about new features and functionality from the Ignite event--and I am catching all of it in my bunny slippers. Why attend a conference then? Conference season is upon us and Steve and I share some thoughts on why we attend conferences and some of the strategies we have used in the past. The show notes from today's episode can be found at http://sqldatapartners.com/2017/09/28/episode-111-how-do-you-prepare-for-conferences/. Have fun on the SQL Trail!
27 Syys 201733min
