The content in this post has been hidden by default because ImportDB will be deprecated in a future version of Biml. Use GetDatabaseSchema instead.
I will be speaking at Deutshce SQL Server Konferenz 2015 (#SQLKonferenz). The conference is from 3-5 February in Darmstadt, near Frankfurt. The first day is a PreCon day with Power Workshops, and the two other days are MainCon days with four parallel tracks: Administration, Business Intelligence, Development and Information Management.
My Biml introduction session called “Generate SSIS Packages Automatically with Biml and BimlScript” is scheduled for Thursday, February 5th. The lineup of speakers this year is amazing! I hope I get to attend as many sessions as possible myself.
Hope to see you there! Please say hi if you see me :)
We don’t celebrate Thanksgiving in Norway, but I wanted to participate in “What Are You Thankful For?” hosted by Bob (@SQLBob) this year. Instead of posting on a day we don’t celebrate in my country, I decided to wait until the first Sunday in Advent. It marks the start of the time of year where I spend the most time with my family and feel truly thankful for so many things in my life.
I’m thankful for my closest family. My parents, my older sister, my niece, and my dad’s best friend who has been my uncle for as long as I can remember. We have and always will be there for each other, no matter what. At the age of 27 I still look forward to going home and spending time with my family, and I’m lucky to have them in my life.
I’m thankful for wonderful friends, coworkers and #SQLFamily, more than I will ever be able to explain. I had no network and have been fighting a depression and all its nasty companions for many years. Getting to know these people and having them in my life to share smiles, laughs, experiences and memories with, who challenge me to become a better person, who welcomed me from day one… They changed my life and keep me going every day. Thank you.
I’m thankful that I have the opportunity to help others. I discovered Kiva years ago and instantly fell in love with the idea of microloans and helping people create better lives for themselves. I believe it’s important for everyone to achieve something, and I hope that the borrowers are left with a feeling of “I did this! I did this!” when they’ve paid back their loan. $25 is so little to me, but it can change someone’s life. In Norway I support The Church City Mission in Oslo because they work hard for a better society for everyone.
I’m thankful I’m healthy, I have a secure job, I live in a safe country where I will get help if I need it, I get to travel and see new places, I get to experience four seasons with dark winters and the overwhelming joy when it gets lighter and warmer. I’m thankful I have so many things to be thankful for :)
Yesterday I had the pleasure of speaking at The Code Pub Oslo, a meetup for women who are interested in IT. It’s a great concept where they get together, learn about new technology, and spend the rest of the evening working on projects. It was their one-year anniversary and in just one year they have grown from 5 to over 130 members.
My presentation was an introduction to Business Intelligence and Data Warehousing, as well as how you can benefit from getting involved in a community like PASS. I like working on presentations because I learn so much from it. It was a bit of a challenge trying to sum up Business Intelligence because there is so much happening and things are changing rapidly. (And I only focused on the Microsoft world!) It was a bit of an eye-opener when I pulled out a book I bought less than two years ago and I realized it was already outdated. So many exciting things have happened in just a couple of years, things like Predictive Analytics and Machine Learning, all the Power BI tools, cloud services and real-time Big Data.
My focus was on what Business Intelligence is, why it’s important, and all the different things you can work with if you pursue a career in Business Intelligence. I explained what Data Warehousing is, and how it is evolving from the traditional to the modern Data Warehouse. I finished my presentation by telling my story of how I’ve gone from being the shy girl who didn’t know anyone to being part of the SQL community, and how life-changing it has been for me.
I hope it was interesting for the attendees, and I hope I’ve inspired some of them to get involved in their own communities. Thank you to Netlight for hosting The Code Pub and for giving me the opportunity to present!
For the past five years I’ve worked as a data warehouse and business intelligence developer. My job is all about providing high-quality data, visualizations, and make sure end users have the right data and reports to do their jobs. I don’t have to worry about performance tuning down to milliseconds, I don’t need to know anything about hardware, and administrators take care of backups and security. I don’t have to or need to know any of these things to do my job, and that is exactly why I want to learn about them.
I’ve spent five years learning and there is still so much more to learn about business intelligence. However, this year I’ve started attending sessions on topics I know close to nothing about, and it really is making me a better developer.
At SQLSaturday #337 Oregon I attended a session by Argenis Fernandez on Securing Your SQL Server Instance Without Changing Any Code. In theory it’s not relevant for me at all, and I have to admit that I hadn’t even heard about some of the things presented before that session. But do you know what I had heard about? Vendor software that requires SA accounts to run. And what did I learn? Rename the SA account, create a new account named SA, and voila! The vendor software can now use the “SA account” that you’re in total control of. It might be 101 material for many, but for me it was something new and useful.
At Redgate SQL in the City I attended another security session by Bob Pusateri, this time about Passive Security for Hostile Environments. Again, something that in theory was not really relevant for me, but it was probably the session I learned the most from! I knew about triggers, auditing and extended events, but it was the first time I saw a demo of event notifications. It was really useful to see the features compared and learn more about when they should and shouldn’t be used.
While I still feel like I have so much more to learn, I also realized that I actually know quite a lot that I can teach to others. And so do you! Share something you’ve learned recently, something you’ve known for ages, or something you think “everyone knows”. There’s always someone out there like me who will learn something from you :)