Notepad++ has some great features for working with text, like macros and column editing. But what about finding information about your text, such as document length and word count? There are several ways to do this in Notepad++.
Notepad++ Word Count
If you have no plugins installed, you can use the built-in Summary function. If you are using the TextFX plugin you can use the Word Count function:
- Double-click on Status Bar (shortcut to View → Summary)
- View → Summary
- TextFX Tools → Word Count
Differences between Notepad++ and TextFX
The Notepad++ Summary only shows the total word count. If you have text selected it shows you how many characters you have selected, but not how many words are in your selection.
TextFX only works when you have text selected, and shows you how many words and characters are in your selection.
More importantly, Notepad++ and TextFX counts words differently. Notepad++ counts hyphenated words as two words, while TextFX counts hyphenated words as one word. (TextFX and Microsoft Word counts the same way.)
Continue reading →
Yay! On Tuesday, April 12th, I will present my Tools and Tips: From Accidental to Efficient Data Warehouse Developer session for the PASS Women in Technology Virtual Chapter. The webinar starts at 12:00 EDT / 18:00 CEST and you can register for it here :)
Tools and Tips: From Accidental to Efficient Data Warehouse Developer
This session is a journey through some of my “Oh wow! Why did I not know this yesterday!?” moments. (Some of them are also known as my “Ooops!” moments.) I will talk about a variety of topics, including SSMS features, tools for query analysis and tuning, free tools and scripts, Biml for SSIS and even a couple of things I used to think were only useful for those scary DBAs. There was a time when these things were completely unknown to me, and I hope that I can help other accidental Data Warehouse developers so they won’t have to spend years discovering these things one by one.
This is the first time I’m presenting this session as a webinar, so I’m currently tweaking my slide deck while re-reading my own lessons learned about presenting webinars. I usually have a rather fast-paced presentation style, but that just doesn’t work as well in a webinar with lag. I also want to make sure that everything is easy to understand without me having to explain it with gestures.
(I will still be sitting alone in a room, gesturing wildly to my computer, but I promise to make my slide deck as informative as possible as well ;) )
My session is definitely not only for women, so why am I presenting for the Women in Technology Virtual Chapter?
Continue reading →
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 14 Super SQL Tips!)
Continue reading →
YAY! We are very happy to announce that SQLSaturday Oslo is back for the third time in 2016! This full day of free training will be held on Saturday, September 3rd, and will cover a variety of topics within SQL Server, Azure, Power BI and Analytics. We will also offer a full day of paid pre-conference workshops on Friday, September 2nd.
SQLSaturday Oslo 2016 Call for Speakers is open
We are looking for all kinds of speakers, topics and levels! Whether you are a first-time speaker or an expert, with a non-technical or advanced topic – we are thrilled to see your session submitted. You can submit 60-minute Regular Sessions or 15-minute Lightning Talks in either English or Norwegian. Choose the language you are most comfortable with so you can deliver your best presentation. We are also looking for pre-conference speakers to deliver a full day of training.
The SQLSaturday Oslo 2016 team
I’m very lucky to be working with such a fantastic team of SQLSaturday organizers this year. We have already worked on this event for a couple of months, and we are going to make this the best SQLSaturday in Oslo so far! :) You can reach us on email@example.com, or get in touch with one of us directly:
Spread the word
Join us and help spread the word to make SQLSaturday Oslo 2016 a great event for everyone. If you’re on Twitter, follow @SQLSatOslo and use the hashtag #SQLSatOslo to join the conversation. The SQLSaturday team and Microsoft Data Platform User Group Norway look forward to seeing you in September! :)
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 female and the first in Europe :)
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.
This is an achievement I’m truly proud of. I worked hard for many months and spent a lot of evenings and weekends learning and experimenting…
… well, ok, I wasn’t always 100% focused on my Biml solution when I worked during weekends :) …
…and now I’m really looking forward to continue sharing my knowledge and helping more Biml users. I’m very thankful and honored I got to speak at so many events in 2015, and I’m already looking forward to some great events in 2016 – including my first full-day Biml workshop with Scott Currie! I will also continue to blog about Biml, and let me tell you… Varigence has some super exciting stuff going on that I can’t wait to dig into and share with you guys :)