Category: Software Engineering
SQL Server Single-User Mode
Sometimes you can’t get into SQL Server. Maybe you forgot a password, or something got misconfigured. You are locked out. What to do when this happens? My go-to is putting SQL Server in Single-User Mode. Doing this is pretty straightforward. First, open a command shell in administrator mode. Then stop the SQL Server Service. net…
Read more…
Designing for On-Prem
We all build everything for the cloud, right? Sometimes we get very focused on a small world, often believing that all software is some cloud-focused startup. But that isn’t accurate. Much of software development isn’t geared toward the cloud; it is geared to on-premises hosting (on-prem for short). Probably one of the big differences between…
Read more…
Automating Wordle with Cypress and GitHub Actions
Like many of you, I was introduced to the Wordle craze a few weeks ago by a peer who thought I was too focused on “actual work”. Naturally, I dropped everything to try this new game and then passed a link to the game around to my friends and family like a cursed videotape. It…
Read more…
Primitiveness
“Sufficiency, completeness, and primitiveness – Achieving sufficiency and completeness means ensuring that a software component captures all the important characteristics of an abstraction and nothing more. Primitive- ness means the design should be based on patterns that are easy to implement.” – SWEBOK V3.0, Guide to the Software Engineering Body of Knowledge Primitiveness is a…
Read more…
JavaScript Events: An Introduction
Yes, JavaScript Events. Without them, the world wide web would be a dystopian wasteland of static HTML. Without them, we’d still be relying on blink and marquee tags to jazz up our LiveJournals. Fortunately, this is not the case. The modern web runs on JavaScript, and JavaScript is driven by events. But what does it…
Read more…
CouchDB and Users
In my previous posts about CouchDB, I have used the same admin user for accessing CouchDB. Bu, CouchDB supports multiple users. we don’t have to use only one user. To create a new user, we can make a simple web call. Here is an example using “postman”. This will create a user and put a…
Read more…
How to Set Up a New Vue App
After being out of the loop for the last couple of years on advances in unit testing for component-based web frameworks, I have been pleasantly surprised at the experience and value available in unit testing my front-end code. In this blog post, I am going to walk through how to set up your first Vue…
Read more…
Saving Data With CouchDB
In my previous post, we queried some data in CouchDB. But the problem with that is we need to put some data into the database if we want to query it. Adding data to CouchDB isn’t difficult. You just need to insert another document. Doing so is pretty straightforward. If you want to insert a…
Read more…
CouchDB Using Nano NPM
In my previous blog post, I did a quick intro to CouchDB. In this post, we will dive into writing some code that uses CouchDB. We will use NodeJS for this application. You could just as easily write this in C# or any language, but for this post I thought I’d play around with NodeJS….
Read more…
Getting Started with Marten
As I wrote in my previous blog post, PostgreSQL is a very capable SQL database. But one thing very interesting about PostgreSQL is its excellent support for JSON documents. The ability to store JSON documents in a database basically allows the database to run like a NoSQL document store, effectively combining relational and non-relational into…
Read more…