Notepad++ Word Count

Notepad++ logo.

In Notepad++, you can quickly find information about your text. For example, what is the document length and total word count? You can do this by using a built-in feature or by using the TextFX plugin. They count words differently, though, so be aware! Make sure you use the one that is right for you 🙂

Word Count in Notepad++

If you have no plugins installed, you can use the built-in Summary feature. If you are using the TextFX plugin you can use the Word Count feature:

  • Click ViewSummary
  • Double-click on Length / Lines on the Status Bar (shortcut to Summary)
  • Use TextFXTextFX ToolsWord Count

Redgate SQL Prompt 7.1 Results Grid Features

Redgate SQL Prompt Logo.

Redgate recently released SQL Prompt 7.1. I try to be an efficient developer (read: I’m a lazy and often impatient developer), so I’m a huge fan of any feature that can save me some clicks here and some time there. In this version, SQL Prompt comes with new Results Grid Features. And let me tell you… I rarely hear so many business users and business analysts ask me: How did you do that!?

Well, let me show you 🤓

(Like this video? Check out the other Super SQL Tips!)

I'm a BimlHero Certified Expert

BimlHero Logo.

In April 2015 I set a goal to become a Certified Expert in Biml. On February 1st, 2016, I became the second BimlHero in the world - the first woman and the first in Europe 🤓

Cathrine Wilhelmsen wearing a BimlHero Certified Expert t-shirt.

It has been a long journey, and I have loved every part of it! Varigence announced the certification program in March 2015, and in April I decided to go for it. I was accepted into the program, and in June I attended 8 hours of advanced training. I spent the next six months working on my Biml solution. I was unable to work full-time on it due to other tasks and responsibilities at work, so I spent quite a lot of time on it at home as well. In November I completed the BimlHero Certified Expert Test, and in December I submitted my Biml solution and my case study of how I implemented the solution at work. In January Varigence reviewed my test, solution and case study, and in February I had the final code review with Scott Currie. It was very nerve-wracking having the creator of Biml go through my code! 😅 But I received lots of useful feedback and finally a congratulations on passing and becoming a BimlHero.

Don't Repeat Your Biml - C#/VB Code Files

Biml Wheel.

Do you use C#/VB classes and methods in your Biml projects? One solution is to create class nuggets <#+ … #>, but they can only be used in their containing Biml file. You can move class nuggets to separate files and include those files, but a more elegant solution is to use C#/VB Code Files.

In addition to using C#/VB Code Files, there are four other main ways you can avoid repeating your Biml code:

In this post, we will look at how to use C#/VB Code Files.

Don't Repeat Your Biml - Include Files

Biml Wheel.

Are you using Biml so you won’t have to do the same tasks over and over and over again in multiple SSIS packages? If so, you probably don’t want to write the same Biml code over and over and over again either. Instead, you can move common code to separate files, centralize and reuse these files in many projects, and update code in one file to make changes to all projects. One of the ways to apply this Don’t Repeat Yourself software engineering principle in Biml is to use Include Files.

In addition to using Include Files, there are four other main ways you can avoid repeating your Biml code:

In this post we will look at how to use Include Files.