Showing posts with label SQL Family. Show all posts
Showing posts with label SQL Family. Show all posts

Friday, February 21, 2020

Update: My Favorite (Data Platform) Podcasts

A tweet on the #SQLFamily hashtag triggered me last week to update an old blog post I wrote a few years back on My favorite (SQL server) podcasts.




After I switched jobs 2,5 years ago I have been doing a lot less commuting, which is good actually, but that left me also with less time to listen to podcasts. Therefore I chose to not listen to some episodes that are not that interesting to me.

Old podcasts

Here's the list I was already following since my last post:

  • .NET Rocks!
    • This is still a great podcast. I particularly like the Geek-outs.
  • Dear SQL DBA
    • The last episode is from the beginning of 2019, I always liked this very much because of the way Kendra explains things.
  • Developer On Fire
    • This was still a thing in 2019, but kinda dried up at the end of last year. The list of book recommendations is still there and huge, so do have a look there.
  • Hanselminutes
    • Still very much a thing. Good, short and fun episodes.
  • no dogma podcast
    • Still a regular flow of good episodes.
  • Office Hours Podcast: SQL Server Pain Relief
    • This one had its last episode on Jan 2 2019.
  • RunAs Radio
    • Still a constant, weekly flow of information and knowledge!
  • Simple Programmer Podcast
    • The frequency was turned down to weekly in 2019, but still regularly producing content.
  • SQL Down Under
    • The URL changed, and after 9 months of silence there was a new episode in December of last year.
  • SQL Server Radio
    • After a few months of silence there was a (re)new(ed) episode with a great announcement.
  • voiceofthedba’s podcast
    • Steve is actually on a sabbatical right now, but his short bursts of knowledge will certainly continue as he goes back to work next week.

New podcasts

These are the podcasts that are new:


Dutch podcasts

Next to the Data Platform related ones above, I also have a few Dutch podcasts that I like to listen to:


Closing

I still use the app Podcast Addict forAndroid, now the paid version without ads.
And one more pro tip before I finish: I use a podcast app that can set the speed of the podcast. I listen everything at 2 times the speed now :-) You can start at 1.5 and work your way up to what feels comfortable for you.

Are you also listening to podcasts, on your way to work, during work or somewhere else? Let me know in the comments which ones you like and if you have others not in my list!

@NickyvV

Monday, February 10, 2020

My Upcoming Speaking Engagements: Belgium and Iceland!

Before talking about my upcoming speaking engagements I would like to tell you a little story. And it goes like this.

How it all started

Back in 2018 I started my journey of getting more involved in the SQL and Power BI community. It actually all started with a Power BI User Group (the Dutch Data Dude Farewell Tour with Jeroen ter Heerdt (B | @jeroenterheerdt)) organized by PBIG (and me) at the Van Lanschot Kempen office in Den Bosch, on which I wrote about earlier last year. Jeroen Schalken (B | @JeroenSchalken) and me did a little introduction talk (around 15 minutes) about our implementation of Power BI at Van Lanschot Kempen. It was frightening and exciting at the same time. During the break of the evening Edgar Walther (B | @edgarwalther) of PBIG came to say it was a very interesting presentation and if we would like to extend that and come talk at the Power BI User Day in March 2019. It was right there that I (and Jeroen) made the decision to say YES. We still had to make a one hour presentation, but also had plenty of time left.

After that presentation I really got the feel of it and started looking for other opportunities to speak. Eventually this turned out in speaking at Power BI Days Belgium with a session and a workshop, followed by SQL Saturday Prague together with Jeroen, dataMinds Connect in Belgium, and even the Power Platform World Tour in Dublin!
It brought me so much more than I could have imagined.

The first thing is that I get the chance to share my knowledge with like-minded people. Next, it was not only amazing to travel to these venues with great speakers and people I look up to. There were also awesome social events during every trip. And that's where the real magic happens. You make contacts, chat a bit, have a beer (or drink of your choice) and make new friends. And at another event you meet even more people to connect with, but sometimes also catch up with the newly made friends from the previous conference. It's been an amazing experience so far.

Upcoming events

But now back to the title of this blog post: it was time again to update my Speaking page, because I already have a few very nice events in my calendar.

This year will start with SQL Saturday Belgium (#956) on March 7, where I will deliver (an updated version of) the presentation that started it all.
Next up is SQL Saturday Iceland (#937) on March 28, where I will deliver my new session A Form, a Flow and a Power BI Streaming Dataset Walk Into a Bar. This session is based on the lightning session I gave at the Dublin Power BI UG during the Power Platform World Tour in Dublin.
Next to those two SQL Saturday events there's also a UG meeting planned, but not officially released yet. So more info on that one later.

Teaser

And last but not least: I will have some very exciting news to share in the coming weeks hopefully. I'm currently finalizing everything, so I'll let you know when everything is signed, sealed and delivered :-)

Tuesday, March 19, 2019

Power Platform Summit Europe & Power BI UG

Power Platform Summit Europe

This year the Power Platform Summit Europe (formerly Data & BI Summit) will be held in Amsterdam in the RAI, on 27-29 March. They renamed it because the conference is focused on Power BI, Microsoft Flow and PowerApps.
I will again be attending this conference (you can read my blogs about last year about my announcement, the Day 1 keynote and the recap). While it is good to have dedicated time to learn from the sessions at the conference, I always find it very useful to get in touch and network with everybody there.
I hope I also get the time to get some blog posts out during the conference.


The tracks this year are Act, Administrator, Automate, Developer and Measure.

The mobile app for the conference is now also available (for Android and iOS), where you can:
  • Build your personal schedule
  • View session details and presentation materials
  • See who else is coming to the conference
  • Get updates or room changes
  • Give feedback on the sessions
As last year, Microsoft added the Power Series to the conference, some of which I am very interested in. There will be over 15 hours of deep dive and hands on content. A few of the topics covered in the Power Series are:
  • Data Flows
  • Power BI Admin & Performance Tuning Deep Dive
  • Power BI Embedded Deep Dive
  • Debugging DAX and Model performance issues
  • AI in the Power BI Service

Power BI User Group Day 2019

Immediately after the Power BI User Group Day 2019 will be held on Saturday March 30 in Utrecht, where my colleague Jeroen and me will be presenting about our journey of implementing Power BI (Premium) at Van Lanschot Kempen!
I assume a lot of the speakers and attendees of the Summit will also attend this UG. The keynote will for example be provided by Charles Sterling.

I think it will be a great week and it will be good to catch up with friends and make new connections in the community.
If you’re also going to one of the above events, let me know in the comments or on Twitter, I hope to see you there!
@NickyvV

Wednesday, February 28, 2018

Data & BI Summit

I have quite some good news: in April I’m going to the Data & BI Summit in Dublin, Ireland.
The Data & BI Summit is hosted by The Power BI User Group.
With tracks like Visualise, Model, Govern and Develop there’s content for a wide range of people, from Business analysts to IT admins.

I’m particularly interested in the Microsoft Power Series where members of the so-called “Power BI dream team” will give 2,5 hour long deep dive sessions on topics like Security, Story Telling and Advanced Data Visualisation with Power BI.
What can we expect at the summit? From the website:
  • Exceptional, quality content: Learn how to bring your company through the digital transformation by gaining new understandings of your data and deepening your knowledge of the Microsoft Business Intelligence tools. Products will include: Power BI, PowerApps, Flow, SQL Server, Excel, Azure, D365 and more! 
  • Answers to your questions: Network with the Microsoft Power BI team, dig-in onsite to find immediate answers with industry experts, Data MVPs, and User Group Leaders while taking advantage of the opportunity to engage in interactive sessions, workshops and labs.
  • Network with your peers: Enjoy countless opportunities to create lasting relationships by connecting and networking with user group peers, partners and Microsoft team members.
  • Stretch your skill set: Advance your career by learning the latest updates and how they can help you and your business.
If you’re also going, let me know in the comments or on Twitter, I hope to see you there!

@NickyvV

Friday, December 30, 2016

My Favorite (SQL Server) Podcasts

I’ve been listening to podcasts for quite some time now, I think I started around two years ago. I used to listen to the radio while commuting, but I thought I could spend my time better by listening to podcasts.

I first started out with downloading SQL Server Radio on my laptop, put it in Dropbox, download it on my phone and play it on the radio in my car via Bluetooth. I knew this could be done better but didn’t have the need for right then. When I heard of .NET Rocks! and other SQL Server-related podcasts I knew I had to make a change to my overly complex process of listening to podcasts. That’s when I started using Podcast Addict for Android. It took me a while to get used to, but I started with a speed of 1.3, then to 1.5, 1.7 and now I play them at 2.0 speed.

For an overview, the podcasts I listen to are:


.NET Rocks! by Carl Franklin (b | @carlfranklin) and Richard Campbell (@richcampbell)
.NET Rocks! is a weekly talk show for anyone interested in programming on the Microsoft .NET platform. The shows range from introductory information to hardcore geekiness.

This has got to be the longest running (SQL Server) podcast in the world.. It’s already at episode 1382 and started in 2002! The topics range from .NET (obviously) to Azure, mobile development to live Q&A sessions at conferences and JavaScript to coding with voice control. There’s something for everyone. So they’ve got a wide variety of topics and besides that the show is usually also a good laugh!
In addition to these topics, they also have these “Geek Outs” one in a while, with a wide variety of topics like DC Lighting, Arctic Ocean, Reusable Spacecraft and Supersonic Aircraft Geek Out.


Dear SQL DBA by Kendra Little (b | @Kendra_Little)
“Dear SQL DBA” is a free weekly podcast where I answer questions from (and about) SQL Server DBAs.

Kendra just delivered her 24th episode, she started out some 7 months ago, she has about 2-3 episodes a month ranging roughly from 15-30 minutes. An episode is centered around a question she gets from users. I only discovered this podcast a few weeks ago but I already like it very much because of the way she talks about the topic and explains things very clearly. There’s also a clear structure in every episode that makes it good to follow. If you’re not fan of podcasts you can also find the transcripts on her site, just read up on the questions listed on the site and pick the ones you’re interested in.
The topics range from How to Level Up Your DBA Career to Altering an INT Column to a BIGINT


Developer On Fire by Dave Rael (b | @raelyard)
Stories from inspiring people in and around software.

This podcast only started out in June 2015 with an introduction, but already has its 187th episode aired!
Dave started out with a good structure around his podcast: what does value mean to you, what are your greatest failure and success, a book recommendation (he keeps a whole list of all the recommendations) and 3 ways of delivering value.
He has a wide variety of topics and speakers like Troy Hunt, Jon Skeet and Linda Rising together with his daughter Kendall.


Hanselminutes by Scott Hanselmann (b | @shanselman)
Fresh Air for Developers

Currently at show #559, Scott delivers an episode once a week that normally is just over 30 minutes. Although the topics are not always to my interest, there’s something to learn every time, be it social skills, how to learn presenting or finding a tool for your todo-lists. His topics range from specific technologies (Hello Ruby, Web Animation Foundations), to teaching and learning and presenting.


no dogma podcast
by Bryan Hogan (b | @bryanjhogan)
discussions on software development

Bryan delivers 1 to 2 shows a month and started in June 2014. His topics range from DevOps to Project management and privacy. I’m not a big fan of the long music outro, but that’s just my opinion and I can easily skip that part. Nonetheless a descent podcast with good releases and quality content!


NOS op 3 Tech podcast (Dutch) by NOS (Dutch Broadcasting Foundation)
The NOS 3 Tech Podcast updates you each week about the latest news from the world of technology and social media. Every Thursday at 16:30 a new episode!

This podcast started in August of this year and has exactly 1 episode a week that takes around 30 minutes. It’s a really fun and light-weight podcast to listen to that has several changing experts around 3-4 subjects every week. The topics range from VR and Playstation Now, to going to Mars with Elon Musk and Silicon Valley and Trump.


Office Hours Podcast: SQL Server Pain Relief by (the team at) Brent Ozar Unlimited (b | @BrentOzarULTD)
Every Wednesday, we get together to answer your SQL Server questions. Every now and then, we also throw in special topical episodes where we present one of our training class sessions for free, too.

They started just over a year ago and have a webcast (almost) every Wednesday, where every episode takes around 30 minutes. They answer live questions while they are coming in, they have to be short though, otherwise they’ll send you to SO or SE. Almost every episode a question comes around where they refer to the post by Erland Sommarskog (b): Slow in the App, Fast in SSMS, which he recently revised for changes in SQL 2016. For me it’s a must-hear every week: fun, questions from the audience and packed with knowledge.


RunAs Radio by Richard Campbell (@richcampbell)
RunAs Radio is a weekly podcast for IT Professionals working with Microsoft products. Each 30-minute episode covers a specific topic in the field of IT from a Microsoft-centric viewpoint.

Launched in April 2007 it just had its 500th episode two months ago! This podcast smells knowledge and enthousiasm.
The topics range from SQL Q&A’s at SQLIntersection (2013, 2015, 2016) to Data Analytics with Jen Stirrup and The DevOps Handbook with Gene Kim.


Simple Programmer Podcast by John Sonmez (b | @jsonmez)
The Simple Programmer Podcast is a short podcast that is a mix of career advice, philosophy and soft skills.

Each episode is around 5-10 minutes long, except for interviews that usually last around 40 minutes and he has a strict release schedule of at least 3 episodes a week. As John says it, his topics range from career development, entrepreneurship, fitness, finance, productivity, personal development and more. Although 3 a week seems like a lot, they’re really short and good-to-listen-to podcasts, you can even skip the funny music and intro/ads if you like to take it down 2 minutes.
He even launched the 2016 Developer Podcast Award ending on the 31st of 2016, so if you still want to cast a vote you’d better hurry.


SQL Down Under by Greg Low (b | @greglow)
SQL Down Under is a podcast (audio show) for SQL Server professionals.

Greg started in 2005 and last month episode 70 was released, with each episode taking around 60 minutes. His release schedule is not that regular the last year, but he did release 2 episodes in the last 3 months. I hope he’s getting back to a more regular release because I really like his podcasts and he has some quite well known guests from the SQL Server world, ranging from Itzik Ben-Gan back in 2005, to Paul Randal in 2007, Jen Underwood in 2015 and Kasper De Jonge earlier this year on SSAS 2016. Up until 2014 Greg also kept the show transcripts up-to-date if you’re more into reading.


SQL Server Radio by Madeira Data Solutions (b | @Madeira_Data)
SQL Server Radio is a podcast (an internet radio show) for SQL Server DBAs, database developers, architects, system administrators, and anyone else who is interested in the SQL Server platform.

Guy Glantser (@guy_glantser) and Matan Yungman (@MatanYungman) started this podcast in August 2014 and release an episode every 2 weeks, which takes around 30-50 minutes. They also have a Hebrew edition which they started earlier. The podcast is always good and fun to listen to, sometimes they bring a guest, but usually it’s Guy and Matan talking SQL Server, conferences or recent blog posts or a mistake they made. Every now and then they have a quiz about a random term out the SQL Server Glossary, on which they have to tell an interesting(!) story. Usually it boils down to just a story.


voiceofthedba’s podcast by Steve Jones (b | @way0utwest)
A series of episodes that look at databases and the world from a data profesional’s viewpoint.

I believe this podcast started out in April 2014, though I can’t really find a website around it. These are really short (usually under 5 minutes) talks by Steve on very different topics. Although the quality seems a bit low to me, he usually got some nice views and points to consider.


 

I hope you found this list useful, if you have any additions, podcasts I should be listening to or remarks, please let me know via this blog or via Twitter!

Monday, November 7, 2016

My Takeaways For SQLSaturday 551: #SQLSatHolland

Finishing this post was on my list for quite some time now, but I gave my post last week about the Technical Preview for Power BI in SSRS priority because of the "hotness" of the topic. So without further ado, here's my SQLSatHolland write-up.

It's that time of year again: it was SQLSaturday in the Netherlands, a.k.a. SQLSatHolland!
It's always nice to meet up with SQLFamily, (Twitter) friends/old colleagues and new friends.

This year I also volunteered for the first time by being a timekeeper for the speakers and making sure the session evaluation forms were distributed before the sessions started and collecting them at the end of the session. It was a good and fun experience and I will try to keep giving back more to the community where I can.

I wrote down some notes of the following sessions:

If a machine can learn, why can't YOU learn Azure Machine Learning? by André Melancia (t)
This was an introduction into AML by André where he started out with some theory and explained what ML is not and the difference with AI. We learned how to create a free Azure subscription, set up a ML workspace and start using ML Studio, which is very much alike the Integration Services graphics of connecting processes through intermediate steps using arrows. He then walked us through the demo of creating our first model and experiment in ML.

Using PowerShell for SSIS by Joost van Rossum (b|t)
Joost used the first few minutes to explain what PowerShell (PS) is and goes right into the demo's after that. He even ignores the best practice of not typing in a demo, but all goes well fortunately :-) He showed us some neat Star Wars "song" of PS-beeps and also explains what you can actually use PS for: a.o. deploying IsPacs and environments, download packages from the catalog, search within multiple packages/projects and setting authorization.

Azure SQL Data Warehouse by James Rowland-Jones (t)
James starts with explaining what SQL DW is and is not. Analytics, aggregates and large data volumes are the key words when you want to use SQL DW. When NOT to use it: RBAR-processing, OLTP, incompatible formats like JSON and XML. You pay for the data you store and the compute you provision. You can choose between Hash and Round Robin (default) distribution, where you have to take into account that the distribution key is read only.

Continuous Integration and the Data Warehouse by John Tunicliff (b|t)
You can watch (a shorter version of) this session recorded at an earlier conference on YouTube. John talks about the problems why CI is still not a basic part of database development, the main point being the data in the database. TeamCity Build Server, PowerShell and psake is mentioned also for implementing CI, all with different use cases. Another key point to CI is a test framework, e.g. NUnit BI which is an open source framework to test BI solutions. A best practice when using SSDT for database design is not to upgrade projects, but to start over with a clean import and transfer over the pre- and post-deploy scripts.

Q&A BI with Joost van Rossum, Jan Pieter Posthuma (b|t) en Remko de Boer
These Q&A sessions were a try-out to see if we liked them and they could be a succes. Our BI session was mostly questions to the speakers but sometimes turned out to be a discussion between several attendees and speakers. It was really an open hour, and I really enjoyed it. Questions ranged from performance of Azure, Power BI, the new MS Certification paths (which I wrote about here) and the Master Data Services session from Remko, which was a very good session I heared from several people.

Introducing the SQL Server 2016 Query Store by Enrico van de Laar (b|t)
I didn't actually attend this session, but rumors say it was an exciting one so I have to share it with you. Let's start with some pictures, they say more…

It all started when he was about to begin with his session:

He even did some Windows updates that morning "to be sure". Well, that clearly didn't help…


What I heard from a lot of people (and also from Enrico himself), is that the session still was great and he turned it into a Q&A. He even turned to the whiteboard to get the picture across! Well done for the professional approach and for thinking in solutions when this happened.


If you want to know more about one of the sessions listed above or are just interested in any of the other sessions of SQLSatHolland, the session materials can be found at the SQL Saturday website, although at the time of writing not all materials have been added to the site.
I hope to also see you next year at SQLSatHolland!

Friday, July 8, 2016

My Reading Goal Journey

I created a page over here to keep track of all the books I read.

Before I start off this post I have to mention Adam Saxton (b | t), also known as Guy in a Cube, because this post, and the idea of setting a goal for reading was inspired by his post and video a few weeks back. If you don't know who Adam is, check out his blog on guyinacube.com or one of his video's on his Youtube channel.
In his post, Adam talks about his reading journey, and that he wants to get some regular reading done.
As I have followed business leaders and entrepreneurs, a common theme has come up. They all read regularly, and a lot!
Fast(er) reading
As Adam states in his post that he's a slow reader, I'm also not one of the fastest readers myself. I did start out with some (fast) reading techniques on lifehacking.nl earlier this year which already helped me in reading a little bit faster. The site is in Dutch, but you can probably find similar sources in English or translate it.
I'm currently at the stage of reading at 90 bpm and 2-3 stops per line. At that speed I can notice I stop the subvocalization (inner speech), which is a big part of slowing readers down. Sometimes it's hard to keep following the rules of speed reading, I'm having a hard time with regression (looking back in the text). So this reading goal is a good place to keep practicing those things and progressing even further.

My goal
For my goal to be SMART, I'm going to start out small and set my goal to 25 pages a day for 100 days, that will take me to October 11th, because I already started last Monday.




My Reading Journey
As time passes, I will keep you posted on how my journey progresses and update this post with new books I complete.

Updated on February 3rd, 2017
I created a new page called My Reading Journey where I'm keeping track of my progress.

Friday, March 18, 2016

The Best of PASS Summit 2015


If you haven’t been to the PASS Summit in Seattle last year (like me :(), you might want to check out the recordings of Summit 2015, as they are now available on PASStv.

Furthermore, PASS has selected the top 10 recordings (I believe based on reviews of the sessions) for you to look at over at Youtube. The links to the video’s can be found at the PASS website, go check them out!


My personal favourite is from Itzik Ben-Gan:



Have fun!

Thursday, January 8, 2015

2014 in Retrospective and Planning for 2015

Well, that's it for 2014 then, it's been a year already. And we're already on our way in 2015. I've encountered several ups and downs last year, with Niels being the best of course!

I'm actually not that good in setting or reaching my goals, so I thought of writing them down, so I (or anyone who reads this) can at least hold me to it afterwards. :-)

Blog
I wanted to do more blogging last year. Well.. that turned out differently :) I just couldn't find the time or inspiration. I did have some periods in which I was somewhat active, but I need to get a more regular schedule. So, starting realistic and achievable, my goal is to get at least 1 post per month out in 2015 and also get my first #tsql2sday post.
And looking further on the horizon, I do some have speaking intentions, I just don't know when or what to talk about yet. I would like to explore this in 2015 a bit further.

Certification
It's been a while ago that I started my learning path to MCSE BI. Due to private matters my time dedicated to learning hasn't been that high in 2013 and the first months of 2014. Starting in March I dedicated some more time and finished 70-461 in April. In December I also passed 462 and 463 and so I finally got my MCSA! My goal is to get my MCSE in 2015, preferably before September.

SQLSaturday Holland
I also attended my first SQLSaturday event in Utrecht last October, meeting a lot of nice new #sqlfamily: Catherine, Clint, Grant, Jeffrey, Julie, Pieter and also renewing the friendship with old ones: Jen and Joost. It was a great event and I had lots of good sessions to attend. I especially want to follow up on Continuous Integration by Grant Fritchey (b|t). He also wrote a good article on SQLMag on this same topic.

Running
I'm also a fan of running and am finally training more in the last months (or at least trying to..). And now, I have set my mind on running a marathon with my friend Joost. Yes, the whole nine (or actually 46145) yards. The location still has to be determined. I already completed several half marathons, with the fastest last October in 1h45m.

Enjoy the year 2015 y'all!
Nicky

Thursday, August 14, 2014

Suggested reading for August 14, 2014

After some months of being busy with my son / other things / holiday / writers block / other excuses.. I thought I'd start my blog with some useful links.

I came across some nice articles and blog posts in the last weeks I wanted to share:
Hopefully you can get something useful out of here!

@NickyvV

Wednesday, October 30, 2013

Suggested reading

I came across some nice articles and blog posts in the last weeks I wanted to share:
SQLRally Nordic and Amsterdam will be held next week, I believe you can still register.
I will be attending SQLRally Amsterdam, so I hope to see some of you over there!

Hopefully you can get somehting useful out of here!

@NickyvV

Featured Post

Fabric Quality of Life Update: No More Default Semantic Models!

Another quick post, because today is an important day for everyone working with Fabric and Power BI! Last month, Microsoft announced they ar...