I have some bad news and some good news. The bad news is that Boris Hristov (@BorisHristov) will no longer be hosting SQLHangouts. He came up with the idea back in 2013 and have recorded 35 interesting videos, but he will now be focusing on his design agency 356labs.com.
The good news is that SQLHangouts are not dead! Boris has decided to hand it over to me. I must admit that it is a little intimidating to take over a project like this, but I am also really excited and looking forward to chatting with a bunch of wonderful and interesting people in the #SQLFamily :)
SQLHangouts – The Next Generation
The concept is simple – short 30-minute video chats with Microsoft Data Platform and SQL Server experts from all around the world. The videos are streamed live on YouTube and are also recorded and saved for later viewing. Fun!
All the recorded videos are available on the Facebook page and in my YouTube playlist. I have added the first 35 videos to the playlist already, and will add all new videos to it as soon as they are recorded and published.
(You can also find the first 35 videos in Boris’ YouTube playlist, and read all about them on his blog.)
What happens next?
The next SQLHangout is already scheduled for March 30th! In this episode, Koen Verbeeck (@Ko_Ver) and I will chat about why design matters in your Business Intelligence projects. We all know that report design is important, but do we need to care about the layout of our SSIS packages? We will also be joined by Boris, the special guest of the day. We can’t have a SQLHangout about why design matters without chatting about presentation design!
Watch the live stream on YouTube on March 30th at 22:00 CEST (UTC+2), and join the conversation on Twitter by using the hashtag #SQLHangout :)
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 firstname.lastname@example.org, 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! :)