The recording of SQLHangout #36 is now available! :) In this episode, Koen Verbeeck (@Ko_Ver), Boris Hristov (@brshristov) and I chatted about presentation design, why design matters in your SSIS projects, about new features in SQL Server 2016, and why it is a fun time to be working with Microsoft technologies. It is also a special episode, since it is my first and Boris’ last episode as a host.
SQLHangout #36 – Why Design Matters with Koen Verbeeck and Boris Hristov
Do you want to participate in a SQLHangout some day? Let me know! :) If you don’t want to participate in a SQLHangout yourself, but you have an idea for a topic or speaker, use this form or tweet and use the #SQLHangout hashtag.
I also want to say a huge thank you to Boris for everything he has done so far, and for trusting me to take over the SQLHangouts! I’m going to miss you as a host and promise to do my best to keep the SQLHangouts interesting :)
I have some bad news and some good news. The bad news is that Boris Hristov (@brshristov) 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.
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!
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 View → Summary
Double-click on Length / Lines on the Status Bar (shortcut to Summary)
Use TextFX → TextFX Tools → Word Count
Differences between Notepad++ and TextFX
The Notepad++ Summary only shows the total word count, not the selected 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.
The TextFX Word Count shows the total and selected word count. It only works when you have text selected. It 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.
Fun fact: TextFX and Microsoft Word counts words the same way :)
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?
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!?