Browsed by
Category: Uncategorized

Notes from SQLBits Conference Day 1

Notes from SQLBits Conference Day 1

I’ll try to highlight the top takeaways per session from my side. Keynote – Level Up with Azure Data This was an entertaining show by Microsoft’s Bob Ward and Buck Woody . They pretended that Bob has a dream about presenting and could do everything. Great consequence was that they had a lot of great people from the Microsoft Team invited presented including Pedro Lopes, Anna Hoffmann, Patrick Leblanc (Guy in a cube) and much more. Demos were given with…

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)

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)

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

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

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

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

Bertelsmann AI Hackdays: What made my team successful

Bertelsmann AI Hackdays: What made my team successful

TLDR Dear potential reader: I realize that this blog post is quite long and everyone’s time is limited nowadays. I am still excited about the result of the Hackdays and the solution I helped to build. So I tried to share as much as possible with you. Feel free to skip over some headings faster and delve into details in other paragraphs. My message is that contributing successfully to a hacking event is absolutely doable even if you are not…

Read More Read More

Pass Summit 2019 Precon Day 1: Performance Tuning With Query Store in SQL Server (Erin Stellato)

Pass Summit 2019 Precon Day 1: Performance Tuning With Query Store in SQL Server (Erin Stellato)

I am currently at the PASS Summit in Seattle, USA. This is a great conference for data professionals. Actually I am already fast asleep as it is like 2:40am in Germany by now. However I would like to use the chance to write up some quick learnings. The day was terrific. Erin Stellato  delivered a great workshop. Here’s a picture of me with Erin Stellato: I would like to share two (rather easy) things which were new to me: Query Store…

Read More Read More

What I like about PowerShell

What I like about PowerShell

Introduction First of all, I do not consider myself a professional let alone an expert on PowerShell. However, I think the learning curve of PowerShell is very appealing especially if you have got some background in programming. The first programming language I learned was Java…way back in 2005 at University. Well, frankly speaking my first programming language was Basic on a Commodore C128 computer…but that time as a teen I didn’t really get a deep understanding and ended up retyping…

Read More Read More

Creating a report with a custom shapefile in Cubeware Cockpit

Creating a report with a custom shapefile in Cubeware Cockpit

Earlier I described how to create the custom shapefile. Now I show you how to create some sample data for the report. Now let’s create a report based on that shapefile. You can grab my shapefile here if you didn’t create your own. First of all we need some sample data. Take the following script to create a database with the relevant data. The script should be compatible with at least SQL Server 2008 (nothing special there). If you are…

Read More Read More