15250
home,page-template,page-template-full_width,page-template-full_width-php,page,page-id-15250,bridge-core-2.2.3,ajax_fade,page_not_loaded,,qode-title-hidden,footer_responsive_adv,qode-theme-ver-21.0,qode-theme-bridge,disabled_footer_bottom,wpb-js-composer js-comp-ver-6.1,vc_responsive,elementor-default

Warning: getimagesize(/data/web/virtuals/229791/virtual/www/wp-content/uploads/2021/01/logo_rp.png): failed to open stream: No such file or directory in /data/web/virtuals/229791/virtual/www/domains/pijacek.io/wp-content/plugins/bridge-core/modules/shortcodes/shortcode-elements/_slider/slider.php on line 356

services

network

MICROSOFT BUSINESS
INTELLIGENCE & DATA
WAREHOUSING

Are you building a new Data Warehouse or maintaining your current Business Intelligence solution? I can provide expertise in design, development and implementation of your Business Intelligence solution, regardless of whether the solution is on-premises or hosted in the Azure cloud. Together, we can also develop best practices to achieve project objectives.

cloud-database

SQL SERVER
PERFORMANCE
TUNING

Do you suffer from unknown SQL Server performance issues or are your SQL queries running too long? Incorrect SQL Server configuration, poor database architecture and badly designed T-SQL code can degrade performance a lot. I can help you to find, tune and optimize your worst performing SQL Server queries, help you to implement the database design best practices and adjust your SQL Server settings and configuration, so your SQL Server runs faster.

cloud-computing-3

SQL SERVER
HEALTH
CHECK

Is your SQL Server installed, configured and set up properly to handle workload expectations? Are your databases configured correctly? Proactive SQL Server Health Checks can save your money, time & pain. By performing regular SQL Server Health Checks, you can identify the source of risks before they become a problem. I can perform Health Check, collect the relevant data and provide you the final Health Check report with the next steps and recommendations.

cloud-computing-2

SQL SERVER
AND T-SQL
TRAINING

Do you want to up-skill yourself and learn more about SQL Server and data querying with T-SQL? During my on-site or remote training session, you will learn how to install and configure SQL Server properly, how to maintain your SQL Server instances and databases, or how to write high performance T-SQL code, following the best practice and coding standards. Training is obviously fully adapted to your needs.

ABOUT ME

I am a Microsoft-certified Business Intelligence Consultant obsessed with the Microsoft Data Platform and Microsoft Azure Cloud. Over the past decade, I have gained extensive practical experience in this area by designing and implementing business intelligence solutions for the largest European financial services companies.

 

In my spare time, I absolutely love attending SQL Server conferences around the world (Global Azure Bootcamp, SQL Saturday, SQL Day, etc.). Doing so allows me to continuously improve my skills and stay on top of the latest technology trends.

my major skills

Microsoft Business Intelligence

Data Warehousing

Data Engineering & Reporting

Azure Cloud Solutions

T-SQL Development

Training and Education

certifications

MCSA: SQL 2016
Database Development
– Certified 2020 –

Issued by Microsoft

MCSE: Data Management
and Analytics
– Certified 2020 –

Issued by Microsoft

MCSE: Data Management
and Analytics
– Certified 2018 –

Issued by Microsoft

blog

contact

roman@pijacek.io
+420 737 121 148
Brno, Czech Republic