Skip to content

Speaking at SQLSaturday Iceland 2016

Speaking at SQLSaturday Iceland 2016On June 18th I will be speaking at SQLSaturday Iceland! This is my first time visiting Iceland (and not just the airport in Reykjavik), and I’m really looking forward to spending a couple of days there. I get to celebrate Iceland’s national day on June 17th, and it’s also right before the summer solstice so the days will be looooong and bright :)

I will present my Biml for Beginners: Speed up your SSIS development session. This is one of my favorite sessions to present, and I will also be around the rest of the day if you want to chat, have any questions, or if you just want me to go through some of the content from my advanced Biml sessions.

If you want more hands-on Biml experience, check out Rasmus Reinholdt’s pre-conference workshop Building tomorrows ETL architecture with BIML and MDS today. You’ll get a full day of training for a very reasonable price. Just note that the SQLSaturday Iceland pre-conference workshops are on Thursday, June 16th, because Friday is Iceland’s national day.

Also, last week I started working for Advania, an Icelandic company. I hope to meet some of my new coworkers there! :D

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 #SQLSatIceland. Hope to see you in a couple of weeks! Come and say hi when you see me :)

Goodbye Comfort Zone! – Starting a New Job

Right now, as I write this, I’m between jobs. Earlier today I finished my last day as an in-house data warehouse solutions architect and business intelligence developer. Tomorrow I’m starting my new job as a technical architect in a consulting company. It’s sad to say goodbye to wonderful coworkers, but it’s also very exciting (and scary!) to start a new chapter in my life.

Continue reading →

Why can’t I create SSIS Project Parameters from Biml?

Biml (Business Intelligence Markup Language) - Why can't I create SSIS Project Parameters from Biml in BimlExpress or BIDS Helper?BIDS Helper and BimlExpress does not support creating SSIS project parameters from Biml out of the box. There are workarounds (and I have previously blogged about my solution for creating project parameters from Biml), but why is this not a standard feature in BIDS Helper or BimlExpress? Many people have asked about this, so I sat down with Biml creator Scott Currie (@ScottCurrie) to get the full story.

Why doesn’t BIDS Helper or BimlExpress emit SSIS project parameters from Biml?

Well, technically it could, but it shouldn’t. The user experience would have serious issues, leading to confusion, frequent errors, and the potential for data loss. How can that be?

Continue reading →

Published: Last Updated: Categories: BimlTags: ,

SQLSaturday Oslo 2016 Pre-Conference Workshops

SQLSaturday Oslo 2016 Pre-Conference WorkshopsSQLSaturday Oslo is back for the third time in 2016, and this year we are offering four amazing pre-conference workshops! We are very happy to welcome Microsoft Data Platform MVPs Grant Fritchey, Dejan Sarka, André Kamman and Mladen Prajdic to Norway :)

Early Bird Tickets

Early Bird tickets are available until July 1st. For as little as 1200 NOK you can attend a full day of high-quality training with some of the best experts in the world. (That’s less than 1/3 of what you usually pay for high-quality courses like these!) After July 1st the price goes up to 1600 NOK, so make sure you register soon – and bring your coworkers :)

SQLSaturday Oslo 2016 Pre-Conference Workshops

These four pre-conference workshops will be held on Friday, September 2nd in Oslo:

Grant FritcheyQuery Tuning with Execution Plans
by Grant Fritchey (@GFritchey)
Level 200 – Intermediate
At least 80% of all database performance problems can be related directly to your T-SQL code and your data structures. This full-day workshop gets right to the heart of that issue and shows you how to identify common performance problems using the tools available to you within SQL Server.
(…read more and register)

Dejan SarkaData Mining Algorithms in SSAS, Excel, R, and Azure ML
by Dejan Sarka (@DejanSarka)
Level 400 – Expert
Data mining as the most advanced data analysis technique is gaining popularity. With modern data mining engines, products and packages, like SQL Server Analysis Services (SSAS), Excel, R, and Azure ML, data mining has become a black box. This course explains how the most popular data mining algorithms work, when to use which algorithm, and advantages and drawbacks of each algorithm.
(…read more and register)

Andre KammanPowerShell for DBAs
by André Kamman (@AndreKamman)
Level 300 – Advanced – Half-day
DBAs will learn all they need to know today to start using Powershell as their main tool to deploy, manage and monitor their whole environment. We will talk about error handling, creating modules, building in pipeline support, whatif support, logging, parameters and more general Powershell concepts.
(…read more and register)

Mladen PrajdicSecurity Best Practices for SQL Server and Application Developers
by Mladen Prajdic (@MladenPrajdic)
Level 300 – Advanced – Half-day
In this precon we’ll look at how to implement security conscious patterns and practices for SQL and .Net application development like multilayer security architecture and the pessimistic approach. Demo attacks will include SQL Injection (SQLi), Cross Site Scripting (XSS), Cross-Site Request Forgery (CSRF), Distributed Denial of Service (DDOS), Social Engineering (SE) and respective protective measures. We’ll try to blow your mind with what malicious attackers can do to your organization and how to protect against it.
(…read more and register)

Spread the word

We hope you want to help us make SQLSaturday Oslo 2016 a great event for everyone, so tell your friends and coworkers about these pre-conference workshops! If you’re on Twitter, follow @SQLSatOslo and use the hashtag #SQLSatOslo. The SQLSaturday Oslo team and Microsoft Data Platform User Group Norway look forward to seeing you in September! :)

Get Started with BimlExpress

Say welcome to BimlExpress – the newest, shiniest and completely free Biml toy! :) I first mentioned this at SQLSaturday Vienna 2016 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 Extension!

What is BimlExpress?

BimlExpress is a free Visual Studio add-in for working with Biml in your SSIS projects. You can add and edit Biml files, and generate SSIS packages from Biml. The code editor has syntax coloring, error highlighting, Intellisense and a preview pane.

If you are already using BI Developer Extensions (previously known as BIDS Helper), you will see that BimlExpress is similar. You will find all the same Biml features as in BI Developer Extensions – just with a new and improved code editor. No more squiggly red lines, yay!

Which versions of Visual Studio does BimlExpress work with?

  • BimlExpress 2019 was released in May 2019. It works with Visual Studio 2010 – 2019.
  • BimlExpress 2018 was released in June 2018. It worked with Visual Studio 2010 – 2017.
  • BimlExpress 2017 was released in July 2017. It worked with Visual Studio 2010 – 2015.
Continue reading →

Published: Last Updated: Categories: BimlTags: