Dino’s Journal 📖

A glimpse into the life of a sleep deprived software developer, husband, dad and gamer.

If you're trying to publish a SQL Server database project using Visual Studio, but you're not seeing the Publish dialog box show up, check your other Desktop in Windows. I've noticed that every once in a while, the Publish dialog box shows up in another virtual desktop, instead of showing up on the one you're currently working on.

#SQL #VisualStudio #SoftwareDevelopment


Links to this page: Weeknotes – 012

For questions, comments and concerns, you can leave me a comment below. You can also find more ways to contact me on this page.

Just a week after officially declaring that I will stop posting on my dev blog and instead publish software developments posts on this journal, I am starting to see a problem with this setup. The problem mainly revolves around retrieving software development content.

I actually use my dev blog to store answers to problems I've encountered before. And every once in a while, I use it to retrieve scripts or pieces of code that I need to re-use. That's easy to do with a dedicated software development blog. It's not so easy to do with this journal. And that's because these bits and pieces of software development content, are buried inside one big Weeknotes post. And that makes it hard for me to quickly get to the information I need. It is inefficient as far as searching for information goes.

For instance, to retrieve the notes I had about the basics of using Git from a command line. I have to sift through the content of Weeknotes-011.

Read more...

I was looking for the shortest tutorial on the basics of using Git from the command line. This one, Git Tutorial 4: Basic Commands: add, commit, push from YouTube was pretty good.

Here are some notes I made from watching that video:

  • The git status command will show you files and folders that have changes. It also shows you files that you've already committed into your local repository, but haven't pushed yet into a remote server.
  • The git add command adds files that have changes into a staging area on your local computer.
  • The git commit command will commit those changes into your local repository. Emphasis on local. At this point your changes are not saved to a remote server like Github just yet. The committed changes are still on your local Git repository.
  • The git push command is the one that will send your changes up to your remote Github repository.

This next tip is not something I learned from the video, but from someplace else that I don't remember.

  • To get out of a long results screen from using the git log command, you can type q.

#Git #SoftwareDevelopment


Links to this page: Weeknotes – 011

For questions, comments and concerns, you can leave me a comment below. You can also find more ways to contact me on this page.

So, 340 grams of Watermelon is around 109 calories. On the other hand, 85 grams of Butter Pound Cake (which I have to say taste so good) is around 337 calories! It's easy to see why snacking on pastries/baked goods makes it so hard to lose weight.


Last week I remembered why I chose to go with pen and paper for my bullet journal — it was to give my eyes a break from staring at screens all day long.

My only issue with this analog approach to journals, is how to digitize the text that I wrote so that they can be searchable in the future. Sure, bullet journals have an index for tracking down specific topics. But let's face it, that doesn't even come close to being able to search text digitally.

I previously tried to get around this by publishing journal entries on this site. As part of writing those posts, the content from my bullet journal would end up in a text (markdown) file when I download a backup of this site. This benefit went away when I decided to stop writing journal entries.

Now, I'm doing a similar thing with these Weeknotes posts. This time around though, my journal entries end up in my Obsidian vault. I still have to manually type them in though. This is the part I'm trying to streamline. But I'm not sure that's even possible. It's either I ditch my analog bullet journal and go straight to digital journal apps, or just continue what I'm doing — write on my bullet journal then migrate (type up) my notes into Obsidian sometime later in the day or week.

Read more...

Most of the time, using display: none; is all you need to hide an HTML element. But every once in awhile, doing so will hide the element, but would not reclaim the space the element would have been occupying.

To hide an HTML element and not have it take up space, you can do something like this:

#post-signature-hidden {
    max-height: 0;
    margin-top: -3em;
    visibility: hidden;
}

In case you're wondering, that's the CSS I use to stop my Post Signatures from showing up on my pinned pages.

#CSS #WebDevelopment #SoftwareDevelopment


Links to this page: Weeknotes – 010

For questions, comments and concerns, you can leave me a comment below. You can also find more ways to contact me on this page.

When working with a Windows Forms TextBox, yes I was working with a Windows Forms TextBox 😀, and you want to display updates periodically while a long task is running, you can make use of the Application.DoEvents() method.

I think a better solution is to use a BackgroundWorker class for this. But, if you're working on an unimportant utility tool or a throwaway app, using Application.DoEvents() should be good enough.

#WindowsForms #SoftwareDevelopment


Links to this page: Weeknotes – 010

For questions, comments and concerns, you can leave me a comment below. You can also find more ways to contact me on this page.

I've decided to start publishing software development specific posts on this journal. Previously, they would go into my dev blog. But nowadays, I feel like that's too much work — maintaining multiple websites that is. So, in the interest of simplifying things, for 2021 at least, software development posts will start showing up here.

While I've already had this idea in my head for the past few months, I was also inspired by this post from Angelo.


Content moved to... Update Contents of Windows Form TextBox Periodically

Read more...

There are two ways that I know of to customize the footer on a Write.as website. The first one is through CSS and the second one is through JavaScript. I'll go through those two options in this post.

Option 1: CSS

I got this idea of customizing the footer via CSS after looking at Robert Xu's Write.as powered site. It puzzled me that I could not highlight the text in the footer. After viewing the page source, I finally figured out that it was CSS trickery.

So, anyway here we are. To customize the footer using CSS, all you need to do is modify the following CSS script, then add it to the Custom CSS settings for your website.

footer nav::before {
    content: "Copyright © 2020 - 2021 by Your Name \A";
    white-space: pre-wrap;
}
Read more...

Recently had need of a SQL Server script that can tell me if there are open transactions on the database. The script below worked for me:

USE MASTER
GO
SELECT spid,
       PROGRAM_NAME,
       nt_userName,
       loginame,
       DB_NAME(s.dbid) AS DatabaseName,
       CR.TEXT AS Query
FROM   sysprocesses s
       CROSS apply sys.Dm_exec_sql_text(sql_handle) CR
WHERE  open_tran = 1

Source: Welcome To TechBrothersIT: DBA – How To Find Open Transactions In SQL Server

#Database #SQL #SoftwareDevelopment


Links to this page: Weeknotes – 009

For questions, comments and concerns, you can leave me a comment below. You can also find more ways to contact me on this page.

So, it turns out subscribing to a Write.as blog via an Outlook email address, means you might run into issues with Markdown formatting in the emails. I tested it by subscribing to this site using two different email providers. The email that I received in Outlook had formatting issues. But the same email in Protonmail did not have issues.


Helped Davin build a makeshift house using Lego blocks. I can now see why the wife likes helping Davin with his Lego blocks; it is fun.


Last week, the Dallas Mavericks won a game that I watched on TV. I guess I’m not cursed after all haha. They just suck this early in the season.

After that win, they went on to play an excellent game against the Denver Nuggets. Jokic hit the buzzer beater to send the game to overtime. But unlike the previous seasons, the Dallas Mavericks were able to close this game out. They need more games and wins like this, to develop their ability to close out games.

Read more...

Enter your email to subscribe to updates.