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:
Facebooktwittergoogle_plusredditpinterestlinkedinmailFacebooktwittergoogle_plusredditpinterestlinkedinmail

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:
Facebooktwittergoogle_plusredditpinterestlinkedinmailFacebooktwittergoogle_plusredditpinterestlinkedinmail

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:
Facebooktwittergoogle_plusredditpinterestlinkedinmailFacebooktwittergoogle_plusredditpinterestlinkedinmail

SQLDay2017 – Database Unit Tests with tSQLt

SQLDay2017 logoLast week I had great pleasure to speak at SQLDay 2017. It is the biggest conference focused on databases, data platform, big data, advanced data analysis and business intelligence in Poland. This year we had an opportunity to attend workshops and sessions delivered by real SQL Server stars: Brent Ozar (b|t) and Greg Low (b|t).

I had an amazing occasion to present my session about Database Unit Tests with tSQLt.

Here you can find my slide deck and materials: SQLDay2017 – Database Testing with tSQLt

I also posted it on my slideshare profile.

-Marek

Share it:
Facebooktwittergoogle_plusredditpinterestlinkedinmailFacebooktwittergoogle_plusredditpinterestlinkedinmail

DevOps and Databases

codeeurope

This week I had a great pleasure of speaking at Code Europe conference – the largest programming conference in Poland. I had opportunity to present my session in two cities: Cracow and Warsaw. I was talking about DevOps, databases, and how to implement DevOps for Databases.

Here you can find my slide deck: DevOps-and-Databases.pdf

It is also posted on my slideshare profile.

-Marek

Share it:
Facebooktwittergoogle_plusredditpinterestlinkedinmailFacebooktwittergoogle_plusredditpinterestlinkedinmail

Hello SQL World…

This my first blog post ever. Now, it is the only post on this page, but I hope it will change soon.

I work with Microsoft SQL Server for few years already and I really enjoy it. I was going to create my own SQL Server related blog for a long time. I wanted to have a place where I could share my database knowledge and experience. Last year I read about #SQLNewBlogger challenge. I thought it is something exactly for me. That was very motivating, so I bought this domain already one year ago and… that’s it. Since then I didn’t wrote a single post. It’s not so easy to start writing. I can even say it is much harder than I was thinking. But enough! It is the time to stop being so lazy. Starting from now I will try to write posts regularly. It’s some kind of new adventure for me. Wish me determination… and a little bit of good luck.

-Marek

Share it:
Facebooktwittergoogle_plusredditpinterestlinkedinmailFacebooktwittergoogle_plusredditpinterestlinkedinmail