SQLDay 2019 conference Working with Legacy database – my slides and demos

Today, I had a great pleasure to speak at the SQLDay 2019 conference in Wroclaw, Poland. It’s the biggest conference in Europe that is focused on Microsoft’s Data Platform.

This year all attendees had the opportunity to meet exceptional speakers and attend full-day workshops delivered by real SQL Server gurus like Rob Farley (b|t) and Grant Fritchey (b|t) (Unfortunately Aaron Bertrand (b|t) didn’t arrive on time :)).

I had an amazing occasion to present my session titled Working with the Legacy database – how to tame the beast (in polish: “Praca z bazą daną – czyli jak okiełznać starego potwora”).

Here you can find my slide deck and materials: SQLDay2019 – Marek Masko – Working with the Legacy Database.

-Marek

Share it:
FacebooktwitterredditpinterestlinkedintumblrmailFacebooktwitterredditpinterestlinkedintumblrmail

The second birthday of my blog!

That is unbelievable! Exactly two years ago I published my first post on this blog (OK, to be 100% correct, that was the second one but we all can agree that the “Hello World” post doesn’t count). At that time, I had no idea how it would develop, but I knew one thing. I wanted to share my knowledge with others. I wanted to learn new things and then pass it to others curious and hungry for knowledge Database Specialist! Continue reading “The second birthday of my blog!”

Share it:
FacebooktwitterredditpinterestlinkedintumblrmailFacebooktwitterredditpinterestlinkedintumblrmail

I’m in the TOP 30 SQL Server Bloggers of 2018

Top 30 SQL blog 2018Today, I accidentally discovered that I’m in the TOP 30 SQL Server Bloggers of 2018 by SQLShack. This is a big surprise and I’m very happy that I received such amazing recognition. It’s a great feeling to be on such a list with all these well-known #SQLFamily members.

I couldn’t imagine more perfect timing. Speaking quite frankly, I have a hard time to get back to blogging after my vacation break and this recognition is a huge motivation for me to resume work on my posts.

I will try to publish my blog posts regularly in September, however, it may be difficult because I’m also preparing to pass the AWS Certificate exam by the end of this year. Keep fingers crossed!

-Marek

Share it:
FacebooktwitterredditpinterestlinkedintumblrmailFacebooktwitterredditpinterestlinkedintumblrmail

SQLDay2018 – Brief introduction into SQL Server Execution Plans

Last week I had a great pleasure to speak at SQLDay 2018. For those who don’t know – it is the biggest conference focused on databases, data platform, big data, advanced data analysis and business intelligence in Poland. It has been organized for 10 years already and is a great opportunity to meet many special people. This year it was a great chance to attend workshops and sessions delivered by real SQL Server experts: Itzik Ben-Gan (b|t), Kalen Delaney (b|t), and Niko Neugebauer (b|t), and many many more…

I had an amazing occasion to present my session titled Brief introduction into SQL Server Execution Plans.

Here you can find my slide deck and materials: SQLDay2018 – Brief introduction into SQL Server Execution Plans

I also posted it on my SlideShare profile.

-Marek

Share it:
FacebooktwitterredditpinterestlinkedintumblrmailFacebooktwitterredditpinterestlinkedintumblrmail

24 HoP – SQL Operations Studio – slide deck

Last Thursday I had a great pleasure to present a session during 24 Hours of PASS Cross-Platform SQL Server Management. 24HOP is an exceptional online event that provides free training for database professionals. It’s 24 back-to-back hours webinar series that features a new 60-minute webinar each hour.

I had an amazing occasion to present my session about SQL Operations Studio – a New Multi-Platform tool for SQL Server Database Development, Administration, and Monitoring.

Here you can find my slide deck: SQLOps

I also posted it on my SlideShare profile.

-Marek

Share it:
FacebooktwitterredditpinterestlinkedintumblrmailFacebooktwitterredditpinterestlinkedintumblrmail

I will speak at SQLDay 2018 conference

I am pleased to inform you that this year I will have the opportunity to speak at SQLDay conference. This is already a second time I will participate in this wonderful event as a speaker. It is a great feeling to know that I will meet some of you soon.

About SQLDay

SQLDay - I am speaking

SQLDay is a biggest Microsoft Data Platform related conference in this part of Europe. It will take place in Wrocław, Poland on May 14-16. It is a three-day event – one day of full-day workshops and two days of sessions. For 800 of participants, the organizers prepared 6 great workshops and 50 sessions in 5 different tracks. This year it will be a great opportunity to meet such industry experts like Kalen Delaney (b|t), Niko Neugebauer (b|t), and Itzik Ben-Gan (b|t). But that’s not all, it’s just beginning of a very long list of speakers. This year, you will also see a strong representation of Microsoft Azure community there.

About my session

Last year, I was presenting tSQLt framework for database unit testing. This time, I will talk about Query Execution Plans. I will explain how they are created,  how to get them, and what useful information they provide. In addition, I will discuss few most important operators and its properties. This knowledge is extremely useful when analyzing query performance problems. Of course, everything will be supported by interesting demos. I encourage you to come and see my session.

If you would like to know how it was a year ago, look at the video below.

-Marek

Share it:
FacebooktwitterredditpinterestlinkedintumblrmailFacebooktwitterredditpinterestlinkedintumblrmail

SQL Server 2017 – Oracle JRE 7 Update 51 (64-bit) or higher is required for Polybase

At the beginning of October, the SQL Server 2017 was officially released. A few days later after the official announcement I wanted to install it in my virtual environment to take a look at newest features. During SQL Server 2017 installation I faced “Oracle JRE 7 Update 51 (64-bit) or higher is required for Polybase” error and I was not able to proceed. Continue reading “SQL Server 2017 – Oracle JRE 7 Update 51 (64-bit) or higher is required for Polybase”

Share it:
FacebooktwitterredditpinterestlinkedintumblrmailFacebooktwitterredditpinterestlinkedintumblrmail

How to change configuration setting when your SQL Server instance cannot start

Recently one of my colleagues asked me for help with his SQL Server instance. He made a mistake while configuring Maximum Server Memory and his instance was not able to run because of wrong memory settings. He set it to low 10MB instead of 10GB. I was working on customer related issues which couldn’t wait, so I asked other DBA to help him with this. Of course everything was fixed in a few minutes. Later I realized that’s good topic for my next blog post.  So it is… Continue reading “How to change configuration setting when your SQL Server instance cannot start”

Share it:
FacebooktwitterredditpinterestlinkedintumblrmailFacebooktwitterredditpinterestlinkedintumblrmail

SQL Saturday #664 -Troubleshoot SQL Server performance problems like a Microsoft Engineer

This Saturday I had great pleasure to be part one of the greatest SQL Server community event: SQL Saturday 664. It is a free training event for Microsoft Data Platform professionals and those wanting to learn about SQL Server, Business Intelligence and Analytics. This time we met in Katowice in Poland.

I had an amazing occasion to present my session about Tools used by Microsoft engineers for SQL Server performance troubleshooting.

Here you can find my slide deck: SQLSaturday 664 – Troubleshoot SQL Server performance problems like a Microsoft Engineer

I also posted it on my slideshare profile.

-Marek

Share it:
FacebooktwitterredditpinterestlinkedintumblrmailFacebooktwitterredditpinterestlinkedintumblrmail

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close