Proud to be an instructor in the Code First Girl’s class on Data & SQL

Proud to be an instructor in the Code First Girl’s class on Data & SQL

Comments 0 Comment

I have the great pleasure and honor to be a volunteer for Code First Girls. This is a UK based non profit organization with the mission to encourage young women to pursue a job in the Tech sector by giving them foundamentals in relevant skills such as programming or (in my case) SQL and Databases. I have been given the opportunity by Experian to volunteer in that course and share my expertise as a data professional. What does that mean…

Read More Read More

SQLdays 2021 Erding: Zusammenfassung

SQLdays 2021 Erding: Zusammenfassung

Comments 0 Comment

Note: This blog post is in German as it is about a German conference and I expect mainly German readers. Moreover I have to admit it is easier to write German early in the morning than english :-P. Anyway feel free to run it through google translate if you are non-german-speaking and interested in the content. Wow…endlich mal wieder ein Blogeintrag nach langer Zeit. Ich finds zwar ganz gut, wenn man nicht immer was zu sagen haben muss aber zugegen…

Read More Read More

Exporting to Excel from PowerShell without having Excel installed

Exporting to Excel from PowerShell without having Excel installed

Comments 0 Comment

TLDR In case you don’t have time reading my writing about PowerShell and the coding process and just would like to have a script up and running feel free to jump right to the end of the blog post where the final scripts are provided. What’s this all about? As a BI/Analytics Practitioner my most common tool for communicating data to business users is Excel. I have been working to build a modern analytics infrastructure leveraging OLAP cubes for a…

Read More Read More

Azure Data Studio: Reset settings

Azure Data Studio: Reset settings

Comments 0 Comment

I had a weird behaviour yesterday with Azure Data Studio. A tab with a SQL Query kept coming up. If I tried to close it a save-changes-dialogue popped up but then nothing happend. Even after I closed Azure Data Studio and deleted the respective file the tab was still magically reopened after a restart. Even uninstall/reinstall did not help. Finally I reported the issue on Github and a Microsoft Employee suggested dumping the profile in %appdata%.  So I renamed the profile…

Read More Read More

Pass Summit 2019: Conference Day 2

Pass Summit 2019: Conference Day 2

Comments 2 comments

I already did a quite extensive write-up on some sessions from Conference Day 2 at PASS Summit 2019. Cybersecurity is everyone’s problem: An extract from the Keynote of Day 2 at Pass Summit Survival Techniques for the lone DBA (Pass Summit 2019 Conference Day 2) Successfully communicating with your customers (Pass Summit 2019: Conference Day 2) Here I would like to share the remaining sessions I went to. Design Strategies and Advanced Data Visualization This was quite an interesting session…

Read More Read More

Successfully communicating with your customers (Pass Summit 2019: Conference Day 2)

Successfully communicating with your customers (Pass Summit 2019: Conference Day 2)

Comments 0 Comment

Wow: PASS Summit is so diverse regarding sessions! It’s not just about geeks enjoying the latest new things in tech. Of course tech is the foundation for what we do and we all love it but everyone needs soft skills as well and Pass Summit is a great place to learn from other data experts about that topic. So I went to Denise McInerney‘s session on how to successfully communicate with customers. Denise had some excercises for the group which…

Read More Read More

Survival Techniques for the lone DBA (Pass Summit 2019 Conference Day 2)

Survival Techniques for the lone DBA (Pass Summit 2019 Conference Day 2)

Comments 0 Comment

On Thursday morning at PASS Summit I went to Monica Rathbun’s session about survival strategies for the lone DBA. This was one of the best sessions I have been to at the Summit and definitely struck a nerve. Many things Monica talked about were well resonating with me as I already went down the same path like leveraged free tools, sucked in as much online training as I could regarding SQL server, went to SQLSaturdays and usergroup meetings and regularly…

Read More Read More

Cybersecurity is everyone’s problem: An extract from the Keynote of Day 2 at Pass Summit

Cybersecurity is everyone’s problem: An extract from the Keynote of Day 2 at Pass Summit

Comments 0 Comment

Wow it’s getting a habit now to write a blog in the later evening about the great PASS Summit currently taking place in Seattle. I simply hope that what I write up here can be useful for anybody else as well…so please give me a short feedback if you like these kind of blog posts or let me know what I could do better. Note: I have just got to know that Kenneth Fisher has a far more extensive writeup…

Read More Read More

Pass Summit 2019: Conference Day 1

Pass Summit 2019: Conference Day 1

Comments 0 Comment

Today was the first conference day at PASS Summit. Originally I expected the venue to be much more crowded and that there would be some sessions packed with people standing in the back. Most surprisingly it was quite a nice experience and no session I visited had people standing but instead a good share of free seats left. However Markus Ehrenmüller-Jensen told me that he has been to really packed sessions and it often is difficult for the organizers to…

Read More Read More

Pass Summit 2019 PreCon Day 2: The SQL Server 2019 Workshop with Bob Ward

Pass Summit 2019 PreCon Day 2: The SQL Server 2019 Workshop with Bob Ward

Comments 2 comments

I am still at PASS Summit in Seattle, USA and today was the second day of preconference sessions. I took the SQL Server 2019 Workshop by Bob Ward and would like to share a few things. As with my previous post on Day 1 please be kind in your judgement…it has been a long day and I am just gonna write about some short and most impressive takeaways. So first of all, what was that all about? It was nothing…

Read More Read More