Voice of the DBA

Tag: syndicated

  • Creating Empty Repos in Azure DevOps–#SQLNewBlogger

    I saw someone struggling with getting started with a Visual Studio project and Azure DevOps. They got a conflict, which I’ll show and then get you started with an empty repo.

    Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

    The Problem with Initialized Repos

    First, I’ll open VS 2019 and create a new database project. I won’ t walk through that, but once I do, then I can add my project to source control. In the lower right corner, this is an option:

    2023-08-09 12_58_07-Zoomit Zoom Window

    I’ll choose a local repository here. I see plenty of people do this if they don’t want to use GitHub.

    2023-08-09 12_58_34-

    Now, I go to Azure DevOps and create a project. I initialize that project with a Readme, which seems like a good idea. You can see my online repo below:

    2023-08-09 12_56_01-VS DB Project Test - Repos

    When I create this, I get the options to link an existing repo or push up.

    2023-08-09 12_59_54-Database2 - Microsoft Visual Studio

    However, if I try to link my existing local repo, I get an error.

    2023-08-09 13_00_19-Database2 - Microsoft Visual Studio

    Why? I have a commit in the report (initialized with a readme) and commits locally. That’s a conflict.

    Creating an Empty Repo

    The way to avoid this is make an empty repo in Azure DevOps without anything in it. When you see this screen, un check the “add a README”. No matter how much you want to have one, don’t do this.

    2023-08-25 16_35_11-VS DB Project Test - Repos

    Now, you have an empty repo for the remote. You should see this online, with the first line noting this is empty. From here, you can use the second box to push your repo from the command line.

    2023-08-25 16_36_17-Files - Repos

    SQLNewBlogger

    This post was easy for me, but I’ve been in the situation where I’ve made this mistake. It’s annoying, but it’s also confusing as you should be able to make changes in both repos. That’s why we use git.

    You can, but not when both are initialized. You need to clone one from the other.

    This post took me about 15 minutes to create, with a good portion of time spent creating the scenario twice (two repos) and the db project in VS, which is slow. You could do this same thing and show how (and why) you set up a project linked to source control. If you use a couple systems (one at work and one at home) make two posts!

  • Webinar: The Cloud, the Future, and Bob Ward at the Summit

    I’m doing a webinar next week with Bob Ward, a principal architect for Microsoft working on Azure and SQL Server. I’ve had the chance to work with Bob quite a few times over the years, and I’m honored that I get to host a webinar with him.

    He has spent the last couple years doing a number of pre-con talks on SQL Server 2022 and how it integrates into a modern application. This year he has a pre-con on Monday at the Summit that looks at how you take your skills and move them to the cloud, with some hands-on experience in Azure. It’s not designed to sway you to Azure, but help you decide if it makes sense for your situation.

    It’s a great opportunity to learn about the Cloud and how it works. In the webinar, we’ll discuss some of the concepts and rational for considering the cloud as part of your future career.

    You can register here for our webinar next week. It’s Monday, Sep 18, at noon Eastern time.

  • A New Word: Vulture Shock

    vulture shock – n. the nagging sense that no matter how many days you spend in a foreign country, you never quite manage to step foot in it – instead floating high above the culture like a diver over a reef, too dazzled by its exotic quirks to notice its problems and complexities and banalities, while drawing from the heavy tank of assumptions that you carry on your back wherever you go.

    I guess not technically a word, but two. However, as someone that has enjoyed and loves traveling, this hits home.

    My wife and I have made it a point to visit other countries, aiming to see a new one each year. In the last five years, despite the pandemic, we managed 11 countries outside the US, perhaps 5 new ones.

    As we travel, we’ve tried not to do too many tourist things. We do a few, but we’ve enjoyed renting an AirBnb in a neighborhood and living for a week like we might if we resided there. It’s been neat to walk around, to shop in groceries, to experience life in small, quiet sections of cities and towns.

    At the same time, I often feel foreign. I’ve grown up as an American for most of my life, and its culture is very ingrained in me. My habits, my languages, my preferences, my food, it’s very colored by my US upbringing. While I do try to experiment and try new things, everything I do is compared against my American-centric thoughts.

    An example. In Seattle recently, we went to a Filipino diner for breakfast, where I had Sinangag and Longganisa with eggs. I enjoyed it, and I need to make some, but it was strange not to have a more American breakfast, to not have something sweet, to not have a more salty sausage. I was in the culture, but not in it.

    I’ve felt the same thing in Greece, in France, in Portugal, in India, and other places. Even i the UK I feel somewhat immersed in and outside of the culture. Floating above it like a diver over a reef.

    From the Dictionary of Obscure Sorrows

  • Future Data Driven is Coming Sept 27 for FREE

    The Future Data Driven 2023 virtual conference is coming on September 27. Register today and save a note in your calendar.

    I have been honored to speak at this event in the past. I’m not speaking this year as I’ve been buried with work and travel and need a break. However, I see a great schedule (scroll down) with some sessions that I will try to watch. A few on my mind:

    I can get information in other ways, but a conference is a good chance to hear what someone else has learned and shares with me. Even if I listen in the background, I’m learning some new things.

    There are lots of other great sessions, so register today.