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 :)
Do you work on projects in Visual Studio? Are you looking for a free and simple way to source control your projects without sharing them with the whole world? Would you like to be able to manage your projects online and still be able to work on your projects offline? If so, you may want to look into using Visual Studio and Git.
As a speaker and blogger, I create projects for demos, videos and screenshots. When I only had a few projects it worked quite well to “source control” my projects: I kept them in a OneDrive folder, created copies of demo code for new presentations and maintained versions manually.
However, the projects grew in number and size and became more difficult to maintain. There were no easy ways to track how I changed and improved my code over time, and I couldn’t revert to previous code. I kept telling everyone else to use source control, so I decided it was finally time to source control my personal projects.
In this post I will show you how I added my first project to source control with Visual Studio and Git.
Continue reading →
Yay, I get to speak at a SQLSaturday… on a Friday! On April 1st at SQLSaturday Vienna, to be precise. And no, it’s not an April Fool’s joke :)
I will present my Biml for Beginners: Speed up your SSIS development session. This is one of my favorite sessions to present, and I look forward to presenting an updated version of it with a new section about BimlOnline, as well as some other new content.
The schedule looks great! I’m a little sad that Sonja Chèvre (@SonjaChevre) is speaking at the same time as me, because I really want to see her present. We met at SQLSaturday Oslo 2015, and I’m so happy to see that she is now speaking! Hopefully I’ll get to attend one of her sessions at another event :)
If you want to chat, have any Biml questions, or want me to go through some of the content from my more advanced Biml sessions – I will be available the whole day. Make sure you register now so you don’t end up on a wait list, and join the conversation on Twitter by using the hashtag #SQLSatVienna.
See you in Vienna in April!