Notepad++ with the TextFX plugin makes it quick and easy to do simple column editing. An application like Excel has many advanced features and might be more suitable in some cases. However, I always have Notepad++ open and it is often faster and easier to us the following approach for me.
At work we use JIRA for task management. I often have to create new or edit existing tables in task descriptions. Tables are created by using vertical line | characters. In this example I have a table where I need to change the order of the columns and sort the data. I also use this method when working with CSV files. This is how I do it in a few, simple steps.
Edit columns in Notepad++ with TextFX plugin
1. Select the character that separates “columns” and copy it to the clipboard (CTRL+C), in this example the vertical line | character is copied to the clipboard.
What day is it? It’s T-SQL Tuesday again! T-SQL Tuesday #59 is hosted by Tracy McKibben (@RealSQLGuy). Did you know that October 14th is also Ada Lovelace Day? I didn’t know that until I read about this month’s T-SQL Tuesday topic: your heroes. Who do I admire, who inspires me, who do I strive to be like?
Volunteers. The thousands of people who spend their free time organizing events, writing blogs and helping strangers. I remember watching the PASS Summit 2013 introduction video where they counted the volunteer hours and they just kept counting and counting and counting… and counting. 500000+ volunteer hours! Five hundred thousand plus hours! I was shocked. That was the first time I realized that PASS and the SQL Server community was more than just a technical conference.
Thank you, volunteers. All of you. Whether you’re a PASS board of directors member, a blogger, a SQLSaturday room attendant, a superstar speaker or a user group administrator, you’re my heroes in the SQL Server community. Without you, there would be no events, no free training, no community. Thank you for inspiring me to be a volunteer as well.
Are you interested in Biml and attending PASS Summit 2014? Join BI Over Beers (BIOB) at the Tap House Grill in Downtown Seattle on Monday, November 3rd from 6-9pm. You’ll have the opportunity to meet and talk with BI professionals from all over the world, and Varigence will provide food, drinks and even give-aways!
I’m very much looking forward to this, will I see you there? :)
I’m super excited, proud and honored to announce that I will present my session Generate SSIS packages automatically with Biml and BimlScript at SQLSaturday #341 Porto (Portugal) on October 18th, 2014!
This is the first time I have been selected to speak at a SQLSaturday, and I’m very thankful for the opportunity to share my knowledge about a topic that I believe is a huge leap forward in the world of Business Intelligence development. I was amazed the first time I saw a demonstration of Biml, and I’m so happy that I get to pay it forward and hopefully inspire others to try using Biml at work – I promise, it will save you time.
I can’t wait to meet everyone at #SQLSatPortugal. Please say hi if you see me! :)
T-SQL Tuesday #57 is hosted by Jeffrey Verheul (@DevJef) and the topic is #SQLFamily. This is a topic close to my heart and even while writing this I’m all excited to read other stories. I can go on for ages about #SQLFamily, but I’ve decided to focus on one thing: paying it forward.
One year ago I had never heard about #SQLFamily and I didn’t even know the SQL community existed. I knew people wrote blogs and forum posts, I knew some taught classes and others published books, but I was your average employee: I did my job, learned what I had to learn to do my job well, and searched online to find solutions and better ways to do things.
Then I went to PASS Summit 2013 and the experience turned my life upside-down.
What happened? People welcomed me with open arms. They invited me to join them at #SQLKaraoke, introduced me to their friends, told me stories about SQLSaturdays and taught me about the community. They didn’t tell me about #SQLFamily, they were #SQLFamily. Even before I went back home to Norway I decided that I would do whatever I could to bring the SQL community to Norway.
This is an excerpt from the blog post I wrote after PASS Summit 2013: “I hope to attend and volunteer at a SQLSaturday, maybe even help organize one in Oslo. I hope to share my new knowledge with my co-workers and help improve our solutions at work. I hope to learn even more and get to know my new connections better. Maybe I’ll even make my own presentation and be a first-time speaker some day!”
In the ten months since I wrote that, I’ve become a board member of SQL Server User Group Norway, I’ve volunteered at SQLSaturday Copenhagen, I’ve done a SQLHangout video, I’m organizing the first SQLSaturday in Norway, and for the first time I’ll speak in another country at SQLSaturday Portugal. I’ve met so many wonderful people and I’m looking forward to getting to know even more. It’s hard to believe it all started when #SQLFamily members spent a couple of minutes saying “hi” to me. So little, yet so much! The last ten months have been a whirlwind, and I’ve enjoyed every single moment of it.
I’m so thankful for everything I’ve experienced this year. Paying it forward and helping my local community has given me something meaningful to do every day, and because I have so many amazing memories I’m now even more determined to keep paying it forward, and to give back. I’ve experienced first-hand how something someone might not even think of, like a friendly smile and a “join us”, can mean to someone else.
If I can pay it forward to just one first-timer at PASS Summit 2014, to welcome someone to the #SQLFamily… it will be worth the whole trip.