Press "Enter" to skip to content

Author: Kevin Feasel

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.”

Comments closed

SQL Firewall in Oracle

Brendan Tierney tries out the SQL Firewall feature in Oracle:

SQL Firewall allows you to implement a firewall within the database to control what commands are allowed to be run on the data. With SQL Firewall you can:

  • Monitor the SQL (and PL/SQL) activity to learn what the normal or typical SQL commands are being run on the data
  • Captures all commands and logs them
  • Manage a list of allowed commands, etc, using Policies
  • Block and log all commands that are not allowed. Some commands might be allowed to run

Read on to see how it works. It’s an interesting approach that can supplement traditional firewall and web application firewall systems.

Comments closed

Organizational Themes in Power BI

Boniface Muchendu takes a peek at a fairly new feature:

Keeping your Power BI reports consistent, clean, and on-brand just got a lot easier. With the new Organizational Themes feature released in June 2025, Power BI now allows organizations to centrally manage and distribute custom report themes across all users. No more manual theme imports or scattered design standards.

Read on to see how it works, and hopefully your organization does not have terrible standards.

Comments closed

Connecting to SQL Server when TempDB Transaction Log is Full

Garry Bargsley makes a connection:

Oh no.. my number one troubleshooting tool is not usable. Time to fire up a command prompt and connect via DAC, right?

Well, not so fast.

During a recent technical interview, I was introduced to a clever workaround that lets you connect to a distressed SQL Server using SSMS, even when it seems unresponsive.

Read on to see how you can connect without SSMS performing a bunch of background queries to retrieve data that end up using tempdb, and then resolve the issue.

Comments closed

Ingesting IoT Data into SQL Server via Python

Hristo Hristov builds an app:

MQTT is a lightweight Industrial IoT communications protocol allowing efficient communication to and from edge devices such as machines, sensors, and actuators. How can we get data from an MQTT on-premises or cloud broker and persist them in an SQL Server database? How can we leverage the newest features in SQL Server 2025 to make efficient query compilations and build a scalable solution for a data pipeline for permanently storing IoT data?

Read on for the code, most of which is in Python.

Comments closed

The Readability Benefit of Splatting in Powershell

David Seis simplifies the code a bit:

Have you ever written a PowerShell command so long that it stretched across the screen? Or had to update a script and hunt through a long parameter list to change a single value? Splatting solves that problem by letting you pass multiple parameters to a command using a single variable.

Read on for some examples, including a good example of how to make similar cmdlet calls easier to read.

Comments closed

Finding Row Counts in Tables

Andy Brownsword wants a quick answer:

A question I ask myself often when exploring unfamiliar data sets. So here’s a quickie:

Click through for the script. This is a lot faster than SELECT COUNT(*), something that can really burn you when there are a few trillion rows in a table and your index scan interferes with ongoing operations. I’ve noticed that reading these counts from statistics is usually pretty solid, but generally, we’re interested in orders of magnitude, in which case 39,308,149 and 39,308,206 are close enough for purposes of understanding which tables are heftier.

Comments closed

Responding to “The Server is Slow”

Kevin Hill shares some consulting advice:

Stop. Don’t Open SSMS Yet.

You’ve heard it before: “The server is slow.”

What does that actually mean?

If you jump straight into SQL Server looking for blocking, bad queries, or a missing index, you’re working with bad input. And bad input = wasted time.

The real work starts before you ever connect to SQL Server.

Click through for some guidance on how to frame the conversation. Even if you aren’t a consultant, I think it’s a good idea to scope and triage the problem in a similar fashion before trying to dive in and see what you can find.

Comments closed

Regular Expression Counts and Positions in SQL Server 2025

Louis Davidson wraps up a series on regular expressions:

I am only combining them into a short version because they are, in how they work, very similar to all the other functions. I certainly will demonstrate all the functionality for each function, but not to the extra level I have in previous blogs.

This time, I will cover:

  • REGEXP_INSTR Returns the starting or ending position of the matched substring, depending on the option supplied.
  • REGEXP_COUNT Returns a count of the number of times that regex pattern occurs in a string.

Read on to see how these work in SQL Server 2025.

Comments closed

Types of Window Functions in SQL Server

I have the first of a two-part video up:

In this video, I walk through four categories of window function, plus a somewhat-related type of function in SQL Server. From there, I demonstrate how aggregate window functions and ranking window functions work.

The second part will come out next week and will cover the other types of window function. Otherwise, this was shaping up to be a 40-minute video and that’s a bit too long.

Comments closed