Press "Enter" to skip to content

Category: Learning

Tips for Technical Writing

Mike Robbins shares some guidance:

Passive voice hides the actor, making instructions vague or more difficult to follow. Instead, use active voice to clarify who performs the action. Active voice includes any sentence where the subject performs the action (e.g., You run the script).

  • Incorrect: When the font size is adjusted, the code becomes easier to read.
  • Correct: If you adjust the font size, your code becomes easier to read.

Active voice makes instructions direct and actionable.

I hate passive voice enough that I would link to this post even if it were the only piece of advice on there. There are very specific good uses for passive voice in English, particularly when you do not know who the actor was and the actor does not matter. The rest of the time, people primarily use passive voice when they want to weasel out of something or avoid assigning blame. And most of the time, even when you think this you have a good use case for passive voice, you probably don’t.

Case in point: “Archduke Franz Ferdinand’s assassination was a primary inciting factor for the Great War.” This is passive voice—we swapped a verb (assassinate) to a noun (assassination) in order to focus on the direct object at the expense of the subject. The general rule of thumb is that if you can ask “By whom?” when reading a sentence, there is a very good chance that the author used passive voice. And we may think at first that the actor does not matter, but I chose this example precisely because he does. In order to understand why the Austro-Hungarian government reacted the way it did, you have to know that the assassin was a Serbian nationalist, that the Russian government had a particularly close connection with Serbia, and that the Austro-Hungarian government had a very contentious relationship with the Balkans at that point (and I’m being kind by using the word “contentious” here). Granted, it’s not critical to fit all of this into the one sentence, but removing the subject turns into a game of “hide the ball” way too quickly.

In active tense, I’d rewrite the sentence to be something like: “A primary inciting factor for the Great War occurred when a Serbian nationalist assassinated Archduke Franz Ferdinand.”

Leave a Comment

Copilots, MCP Servers, and Connection Strings

Chad Baldwin shares a warning:

Well, a few days ago, I ran into the result of one of those awkward pieces when combining the MSSQL extension for VS Code, MSSQL MCP Server and Copilot.

The short of it is…I asked Copilot to change the connection used by the MSSQL extension to use a particular database. I later asked Copilot to describe a table in the database (which uses the MSSQL MCP server), only for it to claim the table didn’t exist. I realized right away it was due to competing connections between the MSSQL extension and the MSSQL MCP Server configuration. It was also at that moment where I realized this situation could potentially be SO MUCH worse than simply not finding a table…

So let’s set up a worst case scenario and see what happens.

This is basically the equivalent of “Wait, that SSMS window was production? Uh-oh.” Not that this has ever happened to me, of course. Or any of you. Nope.

Comments closed

Justifying Costs to Management

Kevin Hill broaches a challenging topic:

Your systems, your data, your customer experience – they all rely on that “invisible” database engine humming along behind the scenes. And if you’re responsible for keeping it running, you need the budget to do it right.

Here’s how to make your case without getting buried in tech jargon or glazed-over stares.

Dave Wentzel has a very solid response to this in the comments. My point of emphasis is working in business terms. Think in terms of return on investment, especially if you can calculate it. That’s a real challenge for technical people because we think in terms of capabilities and don’t have much information on the practical effects of whatever it is we do all day, but figure out what your company uses for cost analysis and try to work in those terms.

Comments closed

SQL Server Book Recommendations

Erik Darling has a list:

They are organized by author, and in no particular order of importance, quality, or anything other than how they appear on my bookshelf.

I am saddened that the $20 I sent Erik did not make it in time for my glorious book on PolyBase in SQL Server 2019 to make it on his recommendations list.

Jokes aside, you could do a lot worse than starting off with the list Erik has. There are quite a few books I’d add to that list, but the idea is not to scare people away by recommending a stack of books as tall as they are.

Comments closed

Finding Oracle Blogs

Brendan Tierney theoretically makes my life easier:

A regular question I get asked is, “is there a list of Oracle-related Blogs?” and “what people/blogs should I follow to learn more about Oracle Database?” This typically gets asked by people in the early stages of their careers and even by those who have been around for a while.

You could ask these questions to twenty different (experienced) people, and you’d get largely the same answers with some variations. These variations would be down to their preferences on how certain people cover certain topics. This comes down to experience of following lots of people and learning over time.

Click through for a list of top Oracle blogs. I should probably check out some of them, though I don’t tend to do much with Oracle here. But if you do, there’s a starting point with 100 separate blogs to check out.

Comments closed

T-SQL Tuesday 184 Round-Up

Deborah Melkin casts a wide net:

There were a lot of themes that I noticed throughout everyone’s posts. First were the number of people who mentioned that mentoring doesn’t have to be formal or even a 1:1 relationship. Mentoring isn’t just for adults and careers, but for the next generation too. Mentoring has helped their careers or become part of a core tenant in their company and how they run their business. It’s a place to grow our community, and not just for those who look like us. We all talked about how we have grown from mentoring, not just as mentees but as mentors.

Click through for a dozen-and-a-half responses to the T-SQL Tuesday call.

Comments closed

Learn from Developer Edition rather than Express Edition

Vlad Drumea learns the right way:

It’s free for non-production use

Just like SQL Server Express Edition, Developer Edition is free, but, unlike Express, it’s only free for non-production purposes (developing, testing, demoing, learning).

If you want to learn more about this, Bob Ward has a blog post that covers this in-depth and answers some questions that people tend to have about Developer Edition.

Back in the day, Developer Edition used to cost money—something like $50, so not much, but just enough to make people prefer Express Edition. Those days are long gone, however.

Comments closed