Speaking at SQLSaturday #413 Denmark

Speaking at SQLSaturday Copenhagen, DenmarkCopenhagen is one of my favorite cities and I’m so happy that I get to visit it again for SQLSaturday #413 Denmark on September 19th! This is the third SQLSaturday in Denmark and it is bigger than ever with two days of pre-conference workshops and one day with regular sessions. I will present one of my newest sessions: Upgrading from SSIS Package Deployment to Project Deployment.

Thursday, September 17th
Self-Service BI – Power BI by Dandy Weyn (@ilikesql)
From 0 to DAX by Alberto Ferrari (@FerrariAlberto)

Friday, September 18th
Analyze and document your SQL Server like a professional / consultant by Uwe Ricken (@dbBerater)
Inside SQL Server Plan caching and parameterization by Margarita Naumova
Data Mining Algorithms in SQL Server, Excel, R and Azure ML by Dejan Sarka (@DejanSarka)
New Index technologies: Clustered ColumnStore and In-Memory OLTP: the good and the bad by Andreas Wolter (@AndreasWolter)

Saturday, September 19th
A whole day of great 1-hour sessions, including a SharePoint track, an academic track and hands-on sessions. And don’t forget to visit the Ask the Experts corner for personal help from the speakers!

See you in Copenhagen in September! :)

SQLSaturday #414 Oslo 2015 is live and Call for Speakers is open!

SQLSaturday #414 Oslo 2015We’ve been waiting for this since last year, and today I’m happy to announce that SQLSaturday #414 Oslo 2015 is live! This full day of free training will be held on Saturday, August 29th at Westerdals in central Oslo. New this year is that we will also offer a full day of paid Pre-Conference workshops on Friday, August 28th.

Pre-conference Call for Speakers was open until March 31st
Call for Speakers was open until May 31st

Whether you’re 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 sessions in either English or Norwegian, choose the language you’re most comfortable with so you can deliver your best presentation.

Join us and help spread the word to make this SQLSaturday a great event for everyone. If you’re on Twitter, follow @SQLSatOslo and use the hash tag #SQLSatOslo to join the conversation. SQL Server User Group Norway and the SQLSaturday team look forward to seeing you in August! :)

Speaking at SQLSaturday #369 Lisbon

Speaking at SQLSaturday #369 Lisbon, PortugalPortugal will always be special to me because they were the first to give me a chance as a brand new speaker. That’s why I’m so happy and honored that I get to come back and speak for a second time at SQLSaturday #369 Lisbon on May 16th!

I will present my Tools and Tips: From accidental to efficient Data Warehouse developer session. It’s a fast-paced walkthrough of things that make me more productive: from keyboard shortcuts, to tools and scripts, to how you can use Biml for SSIS development. There was a time when these things were completely unknown to me, and I hope that I can help other developers work even better.

Don’t forget to register for one of the two great pre-conference workshops!
Mastering Execution Plan Analysis by Paul White (@SQL_Kiwi)
Data Mining Algorithms in SQL Server, Excel, R and Azure ML by Dejan Sarka (@DejanSarka)

Speaking at SQLSaturday #372 Exeter

SQLSaturday #372 ExeterAhoy SQL mateys! SQLSaturday be comin’ back t’ Exeter on April 25th. Get ready fer an amazin’ day ‘o learnin’!

I’ll present Biml for Beginners: Generating SSIS packages with BimlScript, an introduction session for SSIS developers who are new to Biml. It’s even more fun to see that Rasmus Reinholdt (@RasmusReinholdt) will present his Building a meta-driven near realtime ETL solution with BIML and SSIS right after my session. How cool is that? If you’re new to Biml you can start with my introduction session and move on to a more advanced session :D

If the regular sessions aren’t enough learning for you, register for one of the pre-cons on the April 24th training day:
SQL Server: An Introduction – William Durkin (@sql_williamd)
Understanding SSIS internals and performance tuning – David Peter Hansen (@DPHansen)
R: from analysis to integration – Steph Locke (@SteffLocke)
Optimising Reporting Services for MDX Data Sources – Bob Duffy (@bob_duffy)
Performance Troubleshooting for the (Accidental) DBA – Mark Pryce-Maher (@tsqltidy) / Richard Douglas (@SQLRich)

Hope to see you there! :)

Volunteering at SQLSaturday #337 Oregon

SQLSaturday #337 Oregon Volunteer Name BadgeSQLSaturday #337 Oregon was a great event, and I’m so happy I could be there and help out as a volunteer! Arnie, Paul, Vern, Sopheap, Rob, Theresa and everyone else who spent time working on this event, thank you so much. There were 52 volunteers helping out at this event. 52! That’s amazing. I hope you had a great time and I look forward to seeing you again next year!

Isn’t this one of the coolest name badges you’ve seen? Staff, speakers and volunteers all had name badges like this. Each group had a different color with their own pictures and text on it. The QR code takes you to a website where you can get in touch with the person. They were laminated and the same on both sides, so you didn’t have to worry about it flipping over. You didn’t have to worry about people not seeing it either, because it was large and very visible. I may have to borrow a few ideas from this name badge for our next SQLSaturday :)

My first and last assignment of the day was being a room proctor, but I didn’t actually get to see the session. There were quite a few people who arrived during the first session, so I stayed outside my room guiding them to where they wanted to go. It was nice that the organizers had put up maps of all the session rooms in the hallways, I could help attendees or just show them the map. A quick tip if you’re volunteering like this: don’t be afraid to walk up to people! A simple “hi, how can I help you?” if they look lost, or “hi, which room are you looking for?” if they’re staring at the schedule is all it takes. Most people are happy to ask when you approach them first, but they might not want to bother anyone or they might not even know you’re there to help.

Another tip is to hand out evaluation forms when people walk in and let them know that you’ll collect them at the end of the session. We noticed in Oslo that we got a lot more evaluation forms when we handed them out instead of placing them on the chairs, and it was the same in Portland. Feedback means a lot to speakers, so make sure you get them as much feedback as possible.

In the middle of the day I was assigned to monitor the speaker room, but speakers usually know how to take care of themselves :) I got to attend a session I wanted to see, and also tried to help out where needed. There was a great effort during multiple sessions and breaks to get all the SpeedPASSes printed, sorted and distributed. SpeedPASSes are a great idea, but they have been a major cause of headache at all the SQLSaturdays I’ve attended so far. Many people don’t know about them, many people forget them, and many people don’t have a printer available.

That means you will need a printer and scissors on-site and a dedicated volunteer to manage printing. The SpeedPASS files are named based on the registration number instead of the attendee name, so you will need to cross-check with your registration list to find the right SpeedPASS. There will most likely be a queue and attendees will spend time cutting their SpeedPASS instead of talking to sponsors or attending sessions. In Oslo we printed and cut the SpeedPASSes for all the attendees before the event. Unless I, PASS or SQLSaturday organizers come up with a better idea than SpeedPASSes, I will gladly spend hours next year getting blisters from cutting more SpeedPASSes – if that means that attendees get a better experience.

Speaking at SQLSaturday #337 OregonTurns out I wasn’t just going to be a volunteer that day. When we arrived a friend of mine was asked to do a SQL Excite presentation since they had open slots. These are 5-minute, fast-paced presentations with 20 slides set to advance every 15 seconds. I jokingly told my friend that it would be fun to do a Biml presentation, then I happily walked off to do my volunteer tasks and didn’t think much more of it… until I got a message that he had asked the organizers if I could present instead of him, they had said yes, and I would be speaking in 30 minutes.

O_O

I spent all 30 minutes creating a 5-minute introduction to Biml, and had literally just finished the last slide in the auditorium as I was called up on stage. The presentation was based on my 1-hour Biml session so I knew most of the content, but I had not prepared at all what to say to each slide until I was actually on stage. My timing was off on several slides, and it certainly was a challenge not being able to advance my slides myself, but it was so fun! I absolutely loved it.

Thank you to the organizers for giving me the opportunity to speak. Thank you to my friend who didn’t give me the option to say no, and who also filmed so I could watch my presentation after I had finished. And thank you to the attendees who gave me evaluation forms! My cats seem to be popular.

I hope to see you next year, Portland! Maybe with a proper, prepared session :)

Page 3 of 4 1 2 3 4