High Performance Analytics with Sunil Agarwal

At Microsoft Ignite 2017, I had planned an interview with Sunil Agarwal, and was very excited about it. Then Sunil asked if he could bring Kevin Farlee. Of course! Then he asked if he could also bring their customer, Aaron Gerdeman from FIS. Even better! :)

In this interview, we chat about SQL Server 2017, Resumable Index Builds, Adaptive Query Processing, Columnstore Indexes, High Availability, Real-time Analytics, Real-time Dashboards and the SQL Tiger Team.

High Performance Analytics with Sunil Agarwal, Kevin Farlee, Aaron Gerdeman

You can learn more in the SQL Server Database Engine Blog, follow Sunil Agarwal on Twitter @S_u_n_e_e_l and follow Kevin Farlee on Twitter @kfarlee.

I’m very happy they all managed to find time to talk to me, hope you enjoy the interview! To learn more, watch Sunil and Aaron’s session Delivering high performance analytics with columnstore index on traditional DW and HTAP workloads from Microsoft Ignite 2017:

Other interviews from Microsoft Ignite 2017

Data Science with Buck Woody
SQL Server 2017 with Bob Ward
Azure Data Factory v2 with Mike Flasko

Speaking at SQLSaturday Sacramento 2016

Speaking at SQLSaturday Sacramento 2016On July 23rd I will be speaking at SQLSaturday Sacramento 2016! This will be my first time visiting California, so I’ve planned a day of sightseeing in San Francisco before heading up to Sacramento. There’s a big chance I’ll melt in the Californian summer heat and never come back, haha! But hopefully I’ll be able to finish my sessions first :D

This will be the first time I present two sessions at one SQLSaturday. My first session is Level Up Your Biml: Best Practices and Coding Techniques. Depending on your previous experience with Biml and C#, this is an intermediate or advanced session. I’ll cover things like code management, LINQ and how to create your own C# classes and methods.

If you’re new to Biml, you can get an introduction to Biml from Bill Fellows (@billinkc) who will be presenting his
What is Biml and why are SSIS developers excited about it?
session before mine. I definitely recommend attending, Bill is a great speaker :)

My second session is Tools and Tips: From Accidental to Efficient Data Warehouse Developer. This is a fun, fast-paced session with a whole bunch of tips and tricks. I don’t really go into details on anything, but I hope that new developers can pick up a thing or two. And here’s a little secret for you: I will be giving away a free software license to one lucky attendee in this session! And maybe a book or two. And definitely some Norwegian chocolate if you want to try it.

Outside of my own sessions I really want to attend Who needs SSAS when you have SQL? and finally see Meagan Longoria (@mmarie) present live.

Hope to see you at SQLSaturday Sacramento this weekend, and please come and say hi if 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 →

Goodbye 2015, hello 2016!

Happy New Year 2016! :)

Happy New Year 2016

2015 was a year of highs and lows for me. I did so many things for the first time and really pushed myself out of my comfort zone. I made new friends and grew closer to old friends. At the same time I struggled more than ever with my old enemies depression, insomnia, migraine and impostor syndrome. All in all, I guess you can call it “life” :)

Continue reading →

Stop assuming wrongly and start assuming responsibility (T-SQL Tuesday #56)

T-SQL TuesdayT-SQL Tuesday #56 is hosted by Dev Nambi (@DevNambi) and the topic is assumptions: Your assignment for this month is to write about a big assumption you encounter at work, one that people are uncomfortable talking about. Every team has an elephant in the room. What happens if these big guesses aren’t true?

Stop assuming wrongly
“If you make an assumption, you suppose that something is true, sometimes wrongly.”

We’ve all assumed wrongly at some point. While it’s not always a big deal, sometimes the result can be disastrous. I’ve accidentally deleted all the weekly data in our production data warehouse because I assumed wrongly. (Thank goodness my assumption that we had working backups was correct!)

Most of the time I’m not aware that I make assumptions until something goes wrong, like when I realized I had deleted all that data. That’s when I stop and ask myself why I didn’t ask more questions, why I didn’t do more research, why I didn’t triple-check the logic?

The answer to why I assume wrongly is usually time. In the world of business intelligence there are just not enough hours in a day. When a business user asks for new data or a new report, their answer to “when do you need it?” is usually “yesterday”. We all want to deliver as much as possible in the shortest amount of time, which often leads to everyone making some kind of assumption without actually being aware of it. Business users assume IT knows all the business rules (“that’s supposed to be a negative amount”), IT assumes the business users have specified all requirements in detail (“that’s not in the requirements”), and we don’t take the time to sit down and go through it together.

Which leads me to my next point:

Start assuming responsibility
“If someone assumes responsibility, they begin to have responsibility.”

We need to take our time to collaborate, to ask those questions, to do that research and to triple-check that logic. Don’t assume that everyone else knows what you know, but share your knowledge. Don’t just assume that things work, but see how you can improve them. Work together.

I’ll start with me and make this a goal for me at work :)

Page 1 of 2 1 2