You can use Notepad++ to quickly insert, edit, or delete text in multiple locations in one file – at the same time! All you have to do is enable Multi-Editing, and then hold CTRL while you click or select text. This is a fast and easy way to edit parts of your document in just a few seconds.Continue reading →
If you are using BIDS Helper or BimlExpress to generate SSIS packages in the Project Deployment model, you have probably noticed that it is not possible to create project parameters from Biml. You can write Biml for the project and project parameters, but BIDS Helper / BimlExpress will only generate the SSIS packages for you and not the SSIS project parameters. The recommended solution is that you create the project parameters manually before you generate your SSIS packages from Biml.
(Want to know why? Read Scott Currie’s explanation in my blog post Why can’t I create SSIS Project Parameters from Biml?)
However, if you are a lazy developer like me, you probably don’t want to create and update project parameters manually. Perhaps you want to automatically create or update project parameters based on some metadata? You can do that!
Let’s take a look at a (semi-hardcoded, semi-hack) solution for creating SSIS project parameters from Biml in BIDS Helper / BimlExpress :)Continue reading →
The content in this post is outdated and has been hidden by default
I was a volunteer at SQLSaturday #337 Oregon last year, but to my surprise I also ended up doing a 5-minute SQL Excite session about Biml. It was the first time I spoke in the US, I had so much fun, and I ended my summary blog post with: “I hope to see you next year, Portland! Maybe with a proper, prepared session :)”
And Portland, I’m so happy to announce that I will see you again in just a few days, yay! :D
On Saturday, October 24th I will present my new Biml session called S.M.A.R.T. Biml: Standardize, Model, Automate, Reuse and Transform. It’s a session for those who are already familiar with Biml where I will talk about the more advanced features of Biml and Mist, such as metadata modeling, C# development and transformers.
If you’re not already familiar with Biml, don’t worry! The organizers have done a fantastic job with the schedule so you can attend the What is Biml and why are SSIS people talking about it? session by Bill Fellows (@billinkc) right before mine. Double Biml fun!
I will also spend an hour in the Performance Clinic from 15:30 to 16:30 where I will be happy to answer your questions, chat about Biml or go through code or demos in more detail.
Looking forward to seeing you in Portland! :)
There are only a few weeks left until PASS Summit 2015! Are you as excited as I am!? :D
Tips for PASS Summit First-Timers
First of all: Hi to you! :) PASS Summit is a fun, crazy and amazing event and I hope you get as much out of the week as you possibly can. It can all seem very overwhelming at first, especially if you’re new to the SQL Server community. But don’t worry! The SQL Server community is the best community in the world, and we’re happy to welcome you to the #SQLFamily.
Tip #1: Twitter
If you don’t already have a Twitter account, get one! It’s a great way to get the latest news about what’s happening, connect with attendees, and keep in touch with everyone when you get back home. Follow @sqlpass and use the hashtags #SQLPass, #Summit15 and #SQLFirstTimers to make sure everyone can see your tweets. I recommend using Tweetdeck to organize content into columns, for example a column just for the hashtags mentioned above. It makes it so much easier to use Twitter.
Tip #2: Say “hi!”
I know, I know, I know. People are scary. It can be terrifying to look up from your phone, step out of your comfort zone and approach someone you don’t know. Do it anyway! You will meet so many interesting people, and you will get so much more out of your PASS Summit experience. Maybe it will become a life-changing experience like it did for me and so many others? You won’t know unless you go for it :)
A tip is to look at people’s name badges and ribbons. It will tell you where they’re from, if they’re first-timers, if they’re speaking, if they’re chapter leaders and so on. If you get completely stuck and feel completely awkward and feel like running away, like I have on many occasions, just point at the name badge and read something on it with a question mark at the end. “Summit Volunteer…?” “BimlUser…?” “MVP…?” – and off you go! ;)
Here’s a short list of questions to get you started:
And so on. I’m sure you can add a hundred more to the list! :)
Tip #3: Attend the evening events and don’t eat alone
I know, I’m really pushing this whole “network and be social” thing, aren’t I? :) We all need some quiet time, but try to join someone for breakfast, lunch and dinner. There are always someone who are too shy to sit down at a table and introduce themselves, why don’t you join them instead? The Women In Technology and Birds of a Feather luncheons are great events where you can learn and eat at the same time. Finally, attend the Welcome Reception, Exhibitor Reception and Community Appreciation Party where there’s more food, drinks and lots of people having fun. If you’re not done for the night, there are plenty of after hour events organized by and for the community. Have you heard of #SQLKaraoke? It’s a thing. You must experience it once during PASS Summit ;)
Tip #4: Hang out in the Community Zone
There are comfortable bean bags, power outlets and always something going on. You’ll usually find a bunch of people who are active in the community running user groups, SQLSaturdays and virtual chapters. This is the best place to hear how you can keep learning when you get back from PASS Summit. Also, did I mention fun? This year there will be a TeaSQL event for tea lovers, you might spot some crazy costumes and kilts, or you can try juggling said bean bags :)
Tip #5: Get even more tips for first-timers
Attend the PASS Summit first-timers events to get even more tips and meet other first-timers. Read Edwin Sarmiento’s great first-timers guide and read all the blog posts by other members of the SQL Server community. And don’t forget to use Twitter. There are some great #PASSAdvice for all attendees, and just ask if you have any questions!
See you in Seattle!
Enjoy your week, make new friends and learn lots of cool new things. I hope you have a fantastic time in Seattle, and I hope to talk to you there! Please come and say hi if you see me, and I hope to read your tweets :) See you soon!