Voice of the DBA

Tag: syndicated

  • T-SQL Tuesday #159– Resolutions

    tsqltuesdayI missed T-SQL Tuesday last month. I got busy and distracted with some travel. For #159, Deepthi Goguri hosted. I’ve enjoyed watching her blog and grow her knowledge the last few years and I was honored to meet her in person at the 2022 Summit. Hopefully the first of more meetings.

    She had two choices: SQL Server 2022 new features or New resolutions. Both are tempting. I’m actually in a SQL Server 2022 class with Bob Ward as I start this post, taking a break from overload.

    Hmmm, what do I write about?

    Note: You can always fill in your blog later with T-SQL Tuesday topics. Just pick one and link to it. That’s what I’m doing here.

    A Neat SQL Server 2022 Feature

    I’ve sometimes been excited by new features in SQL Server, sometimes not. In this case, one of the interesting things I learned from Bob Ward was on the new contained AGs in SQL Server 2022. This is a neat implementation that essentially creates a new master and msdb database for the AG that contains the server level objects needed by the AG databases. This gets logins, jobs, etc. into these extra dbs.

    There might be some holes in here, but being able to have these objects automatically synched is huge. The downside is you need to add these objects while connecting to the AG databases, so I can see some admins making mistakes and connecting to the instance rather than the AG, but I’m also hoping some automation, some scripting, etc. is used to ensure this works smoothly in your environment.

  • Daily Coping 8 Mar 2023

    Today’s coping tip is ask someone how their day is going and really listen to them.

    I had the chance to do this with one of the kids I coach recently. This athlete seemed a little distracted and annoyed by things, without great body language one day. It wasn’t busy, so I asked a few questions, wanting to know about this person, what was good, bad, what went well, not well, what was bothering them.

    Not a deep discussion, but one where I could listen to them, express sympathies, but not solve their issues.

    I enjoy getting to know someone I care about better, even when I can’t do anything for them at the moment.

    I started to add a daily coping tip to the SQL Server Central newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m adding my responses for each day here. All my coping tips are under this tag.

  • Daily Coping 7 Mar 2023

    Today’s coping tip is give positive comments to as many people as possible today.

    On a travel day, I made an effort here. Those are always better for me, when I see a lot of people and can brighten their days.

    • Thanking the bus driver at the airport
    • Greeting the cashier at my favorite restaurant kindly
    • Complementing the flight attendants on their look and service
    • Chatting with the Uber driver and expressing gratitude for recommendations
    • Taking a few minutes with the hotel receptionist
    • Being positive and thanking a waiter at a restaurant

    I started to add a daily coping tip to the SQL Server Central newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m adding my responses for each day here. All my coping tips are under this tag.

  • Daily Coping 6 Mar 2023

    Today’s coping tip is to make plans with a friend and catch up with them.

    I decided to reach out to a friend and make time to catch up. This is someone I’ve known a long time and really appreciate in my life, but I let time get away from me and don’t always make time.

    I set up a lunch and we had the chance to catch up on our lives, family, etc. It went well, though a bit short as I had some meetings in the early afternoon. We did, however, set up a second lunch to meet again in a few weeks.

    I started to add a daily coping tip to the SQL Server Central newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m adding my responses for each day here. All my coping tips are under this tag.