Say welcome to BimlExpress – the newest, shiniest and completely free Biml toy! :) I first mentioned BimlExpress at SQLSaturday Vienna and have been waiting for the official release since then. I’m very happy that I can now send you all over to Varigence’s website to download the Visual Studio Add-in!
What is BimlExpress?
BimlExpress is a free Visual Studio add-in for working with Biml in your SSIS projects. It allows you to add and edit Biml files, generate SSIS packages from Biml, and the code editor is fully featured with syntax coloring, error highlighting and intellisense.
If you are already using BIDS Helper, you will see that BimlExpress works the same way and includes all the same Biml features as in BIDS Helper – just with a new and improved code editor. No more squiggly red lines, yay!
Should I use BimlExpress or BIDS Helper?
Both! :) BIDS Helper is a fantastic, free add-in with a ton of useful features for your Business Intelligence projects. The release of BimlExpress simply means that Varigence can update the add-in and the Biml engine with new features more frequently and separately from BIDS Helper. When BIDS Helper is updated it will include the latest Biml engine. Keep using BIDS Helper, and install BimlExpress as well for the latest Biml features.
And all of you Biml fans agree with me that the new code editor is worth it, right? Right!? :)
Continue reading →
The recording of SQLHangout #36 is now available! :) In this episode, Koen Verbeeck (@Ko_Ver), Boris Hristov (@BorisHristov) 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
Check out Koen’s blog Under the Kover of Business Intelligence, take a look at all the great articles he has written for MSSQLTips and make sure you follow him on Twitter @Ko_Ver :)
All the recorded videos are available in the YouTube playlist and on the SQLHangouts Facebook page. You can find all of Boris’ previous blog posts in his SQLHangout archive, including his latest blog post about SQLHangout #36.
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 (@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 →