Voice of the DBA

Category: Blog

  • Daily Coping 31 Jan 2022

    I started to add a daily coping tip to the SQLServerCentral 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.

    Today’s tip is to say hello to a neighbor and get to know them better.

    Tough to say hello to neighbors where I am. The nearest one is over 1/4 mile away, and they have long driveways.

    I do, however, sometimes see me neighbors walking along the road. I slowed down and stopped to chat with one recently. I wasn’t pressed for time, so I took a few minutes to say hi, ask how life was going, and caught up with someone I hadn’t talked to in over a year.

    It was a good use of my time.

  • DP-900 Preparation Guide

    This is part of a series on my preparation for the DP-900 exam. This is the Microsoft Azure Data Fundamentals, part of a number of certification paths. You can read various posts I’ve created as part of this learning experience.

    I was asked to pursue a few Azure exams as part of Redgate’s partnership with Microsoft. I’ve been slowly studying some concepts and working towards exams in spare time, but getting more focused in January. I made this a part of my goals for 2022, and it’s been an interesting experience to work towards this exam.

    I’m providing an overview of my resources, and I’ll add new posts for various detailed items I found interesting with links as well.

    Overview of Preparation

    The first thing I did was look over the exam page. This lets the reader know what is being covered as well as the purpose of the exam. There is a note that some things have changed as of Oct 2021, and there is a new PDF to look at with the various areas being tested.

    Download the PDF.

    That’s first, and then check the scope of the exam. There is a lot here, including, but not limited to:

    • data workloads
    • relational Azure services (including PostgreSQL and MySQL/MariaDB)
    • Synapse
    • security (firewall, auth)
    • deployment options
    • query tools
    • DDL and DML
    • non-relational data
    • Azure Storage, Azure Files, Azure Tables, Azure queues
    • Azure CosmosDB
    • analytic workloads, including HD Insight, Databricks, ADS, and Synapse
    • Power BI

    That’s daunting.

    I also looked over some guides from others:

    This seems like a lot, but since the exam can only cover so much, I didn’t expect to be too detailed in each area. However, you do need to know quite a bit about a number of different areas.

    I looked over these, trying to determine what I knew and didn’t know. These gave me hints about which places to spend a little time. I didn’t watch all of the Andrew Brown video, but I did look over the others.

    Prep Process

    I started looking for an overview of each area. Microsoft Learning has some free reading courses, and sandboxes for practice, that I used. I went through these learning paths:

    These each are tens of minutes, but there is a lot of information to absorb about each area. Quite a few of these areas I hadn’t spent much time working in, so I found myself dropping into the MS Docs to get a little more clarification of the area.

    I also took the MS sample question test to get an idea of what I actually knew. I learned that I had quite a few holes in small areas, though overall I knew most of what was being covered.

    I haven’t taken the exam yet, as I’ve been spending an hour every 2-3 days going over some concept and trying to learn a solid overview of what it consists of and how it might be used for data work. Lots to learn here, and the thing I do like is that this forces me to actually dig into topics at a slightly deeper level and helps me to understand a bit more about the options in Azure.

    It also helps me to have better conversations with customers, which is important for my job. I’m not an expert, but I have an idea how of what Azure Table Storage is v. CosmosDB and can understand why someone might choose one of the other in a conversation. At least I can talk basics and know where to look for more detailed information.

  • VS Live Cancelled

    I got a note this week from the organizers of VS Live. They let me know the March event in Las Vegas was being cancelled.  That was disappointing to me, as I enjoy going to Vegas for a couple days and was looking forward to the getaway.

    Their reasoning was the escalation of the Omicron variant. It was slightly surprising to me, as I think the Omicron wave is receding, as South Africa and the UK. In fact, the UK has removed some restrictions. Our Governor in Colorado has been reporting similar news, expecting the rise in cases in my state to start dropping soon.

    I’m glad, as it seems that this variant is closer to the normal flu and people are learning to live with it. Most of life is fairly normal, albeit with some minor precautions and masking, and some evidence of vaccine/negative test/past infection required in places. I think those are sensible and allow us to move forward with life.

    However, a conference is different than living life. Conferences have to make a bet on space, hotels, and more, with financial payments due before attendees pay for registration. I completely understand that the last few months likely had many attendees (and their employers) hesitant to travel to, and pay for, a large event. Despite the requirements for vaccine or negative tests, I am guessing few people were willing to take the chance.

    A few weeks ago the VS Live staff actually emailed to ask if I was still planning to attend as a speaker. I let them know I was, but apparently some speakers were asking to switch to remote presentations. That’s been offered for SQL Bits speakers as well, and I completely understand the decisions others make.

    I think that we will get back to in person conferences, or perhaps hybrid ones, but it is going to take time. Planning an event is hard, and it can be scary if you are not sure of whether or now people will come. I was luck to attend the SQL Server and Azure SQL Conference in Las Vegas in December, with plenty of others that wanted to also come. I expect that the fall will include more events, and VS Live has said their summer and fall events will go on.

    There are a few SQL Saturday events in planning, but quite a few more have pulled back with the concerns of Omicron. Understandable, but I do hope that we start to move forward as we find safe ways to do so.

    Since I now have a small hole in my schedule, I’m starting to look for a different getaway with my wife. Hopefully something in the mountains of Colorado.

  • Daily Coping 28 Jan 2022

    I started to add a daily coping tip to the SQLServerCentral 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.

    Today’s tip is to try out something new to get out of your comfort zone.

    I like my comfort zone. I’m very slow to try new things in much of my life. I like new places, and I’ll try new foods, but I often retreat into something that’s comfortable for me. I tried to change this when I put together this tip.

    In this case, my change was to do nothing. Or little. Usually, I try to get things done and push through the hours. I go from work to a second job coaching to the gym to fixing things on the weekend. If there are extra chores, I’ll tackle them.

    I typically do this even when I’m a bit run down. In fact, during the second week of the year, I was starting to feel like I’d caught cold. I took some meds, tried to sleep a bit more, but kept to my routine and working through the week. I felt OK, but constantly a bit run down. I didn’t do my best work, nor did I really get as much done as I’d like. I even did an hour bike ride (indoors), but I was slow and not sure I got as much benefit out of that work as I would have during 20 minutes.

    Finally the next Monday I decided to stop fighting and working at 2/3 speed. I took a meeting in bed and then called it a day, sleeping for most of the time.

    The next day I felt almost normal, and decided to take things slow for another day. Working, but not as much as usual and allowing myself the chance to keep healing.