Voice of the DBA

Steve Jones
  • 4.9 (9)
  • 科技
  • 一日一更

A series of episodes that look at databases and the world from a data professional's viewpoint. Written and recorded by Steve Jones, editor of SQLServerCentral and The Voice of the DBA.

  1. 1天前

    Multiple Deployment Processes

    We had a Simple Talks podcast recently where we discussed roll forward vs roll back. You can watch the episode and listen to our thoughts, but one interesting place was when we talked about deployments. Grant mentioned that he deployed from version control/source control at a previous employer. I asked him whether he did that for every system. His response: "Well, ..." He admitted that most, but not all, databases came from a controlled source. There were some systems that had a more ad hoc change process. I wonder how many of you have consistent processes throughout your organization. I suspect not many of you do, especially if an organization isn't small. Often, different groups and applications are in a constant state of flux, with lots of different processes and protocols. Read the rest of Multiple Deployment Processes

    3 分钟
  2. You Might Also Like: Dinner’s on Me with Jesse Tyler Ferguson

    1天前 · 附赠内容

    You Might Also Like: Dinner’s on Me with Jesse Tyler Ferguson

    Introducing Side Dish: More with Dan Bucatinsky from Dinner’s on Me with Jesse Tyler Ferguson. Follow the show: Dinner’s on Me with Jesse Tyler Ferguson More of my interview with ‘The Comeback’ star Dan Bucatinsky. We get into Dan's longtime collaboration with Lisa Kudrow and he shares hilarious behind-the-scenes stories from their comedy series Web Therapy. This episode was recorded at Louise’s Trattoria in Larchmont Village in Los Angeles, CA. Learn more about your ad choices. Visit podcastchoices.com/adchoices DISCLAIMER: Please note, this is an independent podcast episode not affiliated with, endorsed by, or produced in conjunction with the host podcast feed or any of its media entities. The views and opinions expressed in this episode are solely those of the creators and guests. For any concerns, please reach out to team@podroll.fm.

  3. 3天前

    A Full Shutdown

    I have the opportunity to work with a variety of customers on their database systems, often with the focus on how they can build and deploy changes to their databases. Often, they have a process around how and when they make changes. Some have maintenance windows, though often these are approved times for changes rather than a true window during which a system is shut down. I ran into a customer recently who scheduled a system shutdown for their deployments. This was a surprise to me in 2026, as I thought most people would have learned to deploy changes to live systems. However, I know that many teams make changes that would render portions of the database inaccessible for a period of time, so maybe that's not true. Maybe they just make changes and deal with the impact on clients. Read the rest of A Full Shutdown

    3 分钟

  4. 5天前

    Not Just an Upgrade

    Voice of the DBA

    3 分钟

  5. 3月6日

    Writing as an Art and a Job

    I remember listening to an interview with Rick Reilly in the mid 2000s. He was the back page columnist for Sports Illustrated for years as well as a writer in various pieces. He talked about how he would lay on the couch in his office sometimes, trying to think of what to write. His kids would come in looking for attention, but couldn't understand that Dad was "working". I had been writing the editorials at SQL Server Central and I could relate. Moving from 2 to 5 (eventually 6) editorials a week was a lot of work. It was stressful in a way I couldn't imagine when I started writing them. I quickly realized that if I had to produce a new one every day, I was in trouble. There would be days I'd struggle. I needed to have a queue of pieces at least partially ready if I were going to manage this job and find balance with my family. Read the rest of Writing as an Art and a Job

    4 分钟

  6. 3月4日

    Rollback vs. Roll Forward

    The Advocates at Redgate Software had an interesting discussion about deployments in databases and how you go forward or back from the point at which you discover a problem. You can watch the episode, but a few things occurred to me while we were having our discussion. The first thing is we all agree data makes things hard. A database is a stateful object, and dealing with stateful objects is hard. That is one of the things I've internalized the last few years that has tremendously changed how I work with Redgate customers. The more I consider state, the more I am able to work with the challenges that databases bring. Read the rest of Rollback vs. Roll Forward

    2 分钟

  7. 2月27日

    Having a Little Fun at SQL Server Central

    Voice of the DBA

    5 分钟

  8. 2月25日

    Testing is Becoming More Important

    Many of us know that testing our code is important. The adoption of unit testing by many software application developers as a normal course of business has dramatically improved the quality of applications. Mobile software, especially, has benefited from the requirement for most software to include, and constantly run, a suite of unit tests. For database software, I find relatively few organizations formally test their database code. A few people have adopted tSQLt or the Microsoft Unit Testing Framework, but most don't bother. In fact, many queries that are embedded in application code, or built by ORMs, aren't tested beyond a developer looking at the results from their own (limited set of) test data. That often doesn't catch errors until someone in production runs their application against a larger set of data. Read the rest of Testing is Becoming More Important

    3 分钟
查看全部 101 集

4.9
共 5 分
9 个评分

关于

A series of episodes that look at databases and the world from a data professional's viewpoint. Written and recorded by Steve Jones, editor of SQLServerCentral and The Voice of the DBA.

信息

  • 创作者
    Steve Jones
  • 活跃年份
    2007年 - 2026年
  • 单集
    101
  • 分级
    儿童适宜
  • 版权
    © Copyright 2020 Steve Jones
  • 节目网站
    Voice of the DBA