Supporting the #SQLFamily

Take a look at the map above. Up to the right you see Linköping, Sweden – where I’m based. To the left you see Austin, Texas – a town 5.215 miles away. I’ve never been to Austin. Heck, I’ve never even been to Texas! So how is this relevant?

Angela D. Tidwell, a budding data scientist and a good friend of mine from the States is one of the organizers of SQL Saturday #890 in Austin, Texas. She reached out on Twitter the other day and asked me if I wanted to sponsor the event.  They just opened up a “personal/blog” sponsor option. For $25 you get your logo and a link to your site among the other sponsors. I didn’t have to think about this very long at all. As you all know well by now, community is one of my main drivers. SQL Saturdays have been the bedrock of the SQL community for years, and many a speaker has started their careers in one of them. I started my speaking career at one. Therefore I jumped at the opportunity to help this event out.

What are SQL Saturdays?

Many SQL Saturdays are pretty small with less than 100 attendees. Some of the events have grown to five times that – or more. These events are completely free to attend and feature everything from local speakers to people from literally the other side of the globe . As they are free, many people who would otherwise not go to any training find a SQL Saturday to be a major boost to their technical career.

Who speak there?

Some of the speakers are known only at their own companies. Some of them are considered international rockstars. Well, at a SQL Saturday everyone is pretty much an equal.  It is an amazing opportunity to get training, meet speakers and – most important of all – network with your fellow #SQLFamily.

So what is the issue?

Unfortunately, running a free event is neither easy nor cheap. The venue costs money. Just transporting all the stuff TO the venue costs money. Therefore they rely on sponsors, and anyone who has tried organizing an event of any size knows how difficult securing sponsorship can be. Hence I’m happy to have been able to contribute to SQL Saturday Austin, even if I can’t make it there in person.

SQL Saturday #851 – A new thing in town…

“Why don’t we have a SQL Saturday in Stockholm?” a friend asked me a few years ago. “I honestly don’t know”, was my answer. “There is a lot of people in Stockholm, but for some reason they don’t seem to be able to organize one. There is one in Gothenburg that’s been working fine for a few years, maybe you could ask Mikael Wedham?”

I didn’t know the main organizer Daniel Hutmacher very well back then, but we’ve met a few times through the years and despite him being ill he made it to the last SQL Saturday Gothenburg. I think that he had already started considering a Stockholm-based SQL Saturday already, as he unveiled his idea a bit later. Here we are today, and in two days’ time – Saturday May the 4th – SQL Saturday #851 is going to happen in Stockholm! We’re close to 300 attendees and I an very excited to deliver “Arguing with myself – self-service BI from an infrastructure perspective” at 4.30. The speaker lineup is exceptional: Kevin Kline, Grant Fritchey, Matthew Roche, Pinal Dave, Ruth Pozuelo Martinez, Uwe Ricken, Mikael Wedham, Ola Hallengren and several other internationally renowned speakers are standing by.

I’ve been a (very) small part of the organizing team for SQL Saturday #851, but as my schedule has been absolutely bonkers I haven’t had much time to contribute at all. Daniel and the others have done all the heavy lifting but I am looking forward to contributing onsite during the day. The funny thing with Daniel is that he doesn’t care very much if someone says something can’t be done – yet another reason to work with him or employ his services. He gets things done like few others.

If you’re into SQL Server, like great speakers, free, amazing content, are close to Stockholm and have the Saturday unplanned – come join!


SQLSaturday #851 - Stockholm 2019

A Swede went to Finland, spoke and learned

A couple of weeks ago now, I was focused on preparing for, and speaking at, Techdays in Helsinki, Finland. I was really happy to be accepted for the conference after Alexander spoke there last year and praised the arrangement. I was also very happy that Techdays choose to accept my session on Windows Virtual Desktop, since this is one of the topics I’m most passionate about and involved in currently.

I have presented this session previously, at Igel Disrupt, but this time I had another kind of audience. With more mixed backgrounds and focused more on “regular” client management. In the end, it turned out great!

I felt that I had a very good interaction with the audience and I’ve received a number of questions during and after the event. Also, the feedback has been amazing and I’m very glad and humbled by that.

So, why do I think that WVD is such a big deal? Well, I’ve said it before and to me the first and most obvious benefit is that this till democratize the, so called, EUC (End User Compute) landscape. The technologies out there today is usually pricey and fairly complicated to configure and maintain (and yes, that includes Windows Server RDS). They usually also require you to buy a number of licenses up front, or at least do the implementation as a project.

This have prevented some, especially smaller, organizations from going down this route, even though they would like to. This is made possible with WVD. You can scale DOWN to a 1 user on 1 VM if you like, and that’s fine. You don’t have any upfront cost, you can for your consumption (even thought it actually can be cheaper to buy reserved instance and pay for it upfront). It’s a very, in the simplest configuration, an easy solution with implement and manage.

You of course get all the benefits that any, or most, EUC solutions have today in terms connect-ability, security and mobility.

One of the feedback points I received both in Munich and in Helsinki were that I almost sound overly positive and don’t present the downsides of the service. For this, I’m sorry. Its actually not intentional and therefore I would like to point out a few downsides I currently see with the service (based on publicly available fact):

  1. Its great to run apps and desktops in the cloud, but you need to consider your apps first. This will be the showstopper for many organizations. If you have systems that required connectivity to your local datacenter as an example, its perhaps not great from a performance perspective to put the client in the cloud. You can of course see this as an opportunity as well – you are moving your stuff to the cloud, but consider that first.
  2. Second, authentication. Personally, I do feel that the current solution could be highly improved, but could require more cross product group work. The RDS cant sort this out by themselves, they need help from the Windows, AD and Azure AD among others. Ill dig deeper into this in time of the public preview.
  3. Since this is some kind of hybrid if we compare it to other solutions, we need to have tools that makes it easier to manage the service, especially the VMs. You don’t need to manage and maintain the actually underlying infrastructure – but you need to configure it, secure parts of it and manage your VMs. This will also require some cross PG work, and this (as well as security) is where I see that I personally can make a difference.

There are of course other downsides as well – and I’m really looking forward to getting more information of the final decision on licensing of the service. We’ll see.

This is however feedback I’m struggling with. I do get it, I do see it as important and I do want to be better at not just look at the good sides of it, but also (in blogs or when I’m speaking) give my audience a realistic picture. Again, I’m not trying to hide anything, its just a matter of me focusing on the amazing technology.

I’ve actually had this challenge before. In the beginning of Windows 10 I did a customer presentation on Windows 10 and why that would be the best OS for this customer. They found the presentation interesting, they saw the benefits but then they asked me a question: “So, what’s bad with Windows 10? There needs to be something, or else we wont be able to trust what you are saying.” I do get that feedback, especially now a few years later. So, moving forward ill do my best to present a more nuanced picture whatever I’m presenting on.

So, we’ll for sure have reasons to get back to WVD in coming blogposts, but for now Ill be focusing a lot of my “core” technologies which is especially Windows 10 and EMS.

Take care and remember to follow the blog and listen to the Knee Deep in Tech podcast. You can find us wherever you find pods including iTunes and Spotify.

Speaking at SQL BITS!

I’m going to SQL BITS! Not only going, but also speaking – I’m very excited to be delivering “DAX for the SQL developer” at 1420 in a room called “Snake Eyes”. What could possibly go wrong? This is my first time at BITS, both as a speaker and an attendee, and I am very much looking forward to what is called the biggest and best SQL Server / data conference in Europe. There are still tickets for the paid day (Friday) left, as well as the free, community-oriented Saturday. Drop everything and come join!

Heading to Norway and NICCONF

Tomorrow I’m heading to Oslo and the Nordic Infrastructure Conference (NICCONF) – one of my favorite conferences! I’ve been invited to deliver three sessions this year:
“The force awakens – Azure SQL Server for the on-prem DBA” which is an introduction to Azure SQL Server in its different shapes,
“Azure Machine Learning for the absolute beginner” which is an introduction to Azure Machine Learning, its capabilities and what can be done with machine learning, and finally
“Learning to swim – an introduction to Azure Data Lake”, a quick overview of the what, how and when with Azure Data Lake.

Now, I’ve been running around trying to find some props for these sessions, and so far I’ve got fun stuff for two of them. Hopefully Oslo provides the third one tomorrow, and then it’ll be even more fun to attend these sessions. Let’s just say that it is surprisingly difficult to find pool toys in February…
I was invited to speak at NIC last year as well, and I was struck by the friendly feel of the conference. Not too big, not too small, plenty of great speakers, awesome attendees and very kind organizers.

I can’t wait to get there and meet all the attendees – will you join me?

Back on the road

The first month of the new year is more than half way done. Time flies, but I’ve already had time to go to SQL Saturday Linz in beautiful Austria. I delivered “Headless chicken – calming the sysadmin-turned-DBA” to a full room, and it was 60 minutes of fun, shenanigans and failing to use a flipchart properly – all while having an excellent discussion about the intricacies of waking up as a DBA. Tomorrow I’m leaving for a quick trip to Mechelen in Belgium and the first-ever Power BI Days conference! I have it on good authority that there will be a good crowd and I’m more than happy to be a part of Europe’s newest Power BI-focused event. It will be a quick in-and-out though as I’m flying home again Saturday afternoon. In Mechelen I will be delivering one of my favorite sessions: “Arguing with myself – self-service BI from an infrastructure perspective”, absolutely sure so get laughs. I mean – I’m wearing two different hats and I’m arguing with myself in three different voices – what’s not to like…?