Community Events & Trainings
Explore a Diverse Range of Community Events & Training Opportunities, and join us! Whether you're seeking professional development, networking opportunities, or simply looking to engage with like-minded individuals, there's something here for everyone!
Community events:
Live session: ???????????????? ?? ???????????? ?????????????????? ?????????? ?????????????????? ???????????????????????? ????????????
30 April, 2024 | 2:00 PM - 3:30 PM (UTC)
Do you know about Microsoft Reactor ? Reactors are community spaces where startups and developers from all over 150 countries meet, learn, and connect with experts industry-leading ideas, and AI technology from Microsoft, partners, and the open-source community.
So, what's the latest buzz? Expert-led walkthroughs of Microsoft Fabric Learn modules. Yes, you read that right, 9 live sessions, absolutely FREE! Check out the full lineup of episodes here: https://bit.ly/fabreact
But wait, there's more! We're beyond thrilled to announce that we're joining forces with you, the incredible community, to share knowledge. Our CEO, Margarita Naumova , Inspirit alongside Mohammed Adnan from RADACAD will cover: Organize a Fabric lakehouse using medallion architecture design
Curious about the potential of medallion architecture design in Microsoft Fabric? Wondering how to organize and transform your data across Bronze, Silver, and Gold layers of a lakehouse for optimized analytics? Look no further!
Mark your calendars for the live session on April 30th
Free registration: https://bit.ly/fabriclakehouse
Webinar: OPTIMIZING ETL on SQL SERVER SIDE
15 May, 2024 | 5:00 PM - 6:30 PM (EEST)
Organized by Azure Analytics User Group and SQL&BI UG Bulgaria
Speaker: Dejan Sarka
When you try to optimize Power BI, the first advice you get is to push the data processing as far upstream as possible.
Query folding in Power Query tries to enforce this logic as much as possible. But what is going on SQL Server side? What if the daily extract – transform - load (ETL) process is too slow? The real optimization of the ETL process starts with finding what has changed on the source, finding the delta. In SQL Server, you have many methods for this. You can use the Change Tracking (CT), Change Data Capture (CDC), system-versioned tables, ROWVERSION data type, triggers…
Which method might be the fastest? In the next step, how do you optimize staging tables? Do you use regular tables, temporary tables, memory-optimized tables? Can you leverage minimally logged operations? Does it make sense to pre-aggregate the data? Disable indexes and constraints or not? What about table partitioning?
This presentation will help you answer these questions and help to find the most suitable solution for you. Parts:
REGISTRATION: https://bit.ly/optimizingETL
Conference: DATA SATURDAY STOCKHOLM
MAY 25, 2024
Attend this free, one-day conference in Stockholm to sharpen your skills on the Microsoft data platform, and to connect to other professionals in your space! Sessions from leading world-class international and local speakers, across data management, cloud and hybrid architecture, analytics and BI, and so much more.
We will be there :)
Upcoming Trainings:
PL-300: Microsoft Power BI Data Analyst
8-10 May with Dian Gospodinov
Delivery language: Bulgarian
领英推荐
Start guaranteed, limited spots available: www.sqlmasteracademy.com
This course will discuss the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI.
The course will also show how to access and process data from a range of data sources including both relational and non-relational data. This course will also explore how to implement proper security standards and policies across the Power BI spectrum including datasets and groups. The course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution.
Finally, this course will show how to build paginated reports within the Power BI service and publish them to a workspace for inclusion within Power BI.
SQL Server High Availability and Disaster Recovery Solutions
13-15 May with Margarita Naumova
Delivery language: English
Start guaranteed, limited spots available: www.sqlmasteracademy.com
The course goal is to dive into SQL Server Technologies and solutions that support and provide service and database availability, to understand, maintain and support them in real environments.
It is very important to know the way availability solutions work to design, implement, and maintain critical production systems and align to SLAs. Developing an overall understanding and familiarity of the basic features and different implementations is relatively simple. What is trickier to develop however, is an understanding of the mechanics (or internals) of Clustering, Availability Groups and Log Shipping and gaining experience of how to manage large scale and critical systems.
This training gives you the important aspects to gain a good understanding of how the Clustering, Log Shipping and Availability group technology works so that you can design, build, and manage a reliable availability solution. It covers HADR in hybrid and cloud environments.
SQL Server Development Fundamentals – new format
Starting May 27 with Krasi Donchev
Delivery language: Bulgarian
This five-day instructor-led course provides students with the knowledge and skills to develop a Microsoft SQL Server database. It includes the T-SQL language constructs, programming modules and data layer objects creating. This is the main class for DBAs and DB Developers, who want to have a good foundation of their T-SQL skills.
What’s Changing? Instead of our traditional one-week intensive format, we’re transitioning to a more flexible and extended schedule. Starting 27th of MAY, the class will now be delivered over five weeks with one full-day session per week – every Monday. Each session will run from 9:30 AM to 5:00 PM.
Why the Change? We’ve made this adjustment to provide you with a more manageable and immersive learning experience. By spreading the content across five weeks, we aim to give you the opportunity to absorb and apply the material at a pace that suits your schedule. This approach also allows for better retention of information through spaced learning, ultimately enhancing your skills in SQL Server development.
Key Benefits:
Important Details:
Master class: SQL Server Performance Tuning and Optimization
May 27-31 with Margarita Naumova
Delivery language: Bulgarian
Start guaranteed, limited spots available: www.sqlmasteracademy.com
This Masterclass suits Database administrators who are responsible for the proper and reliable operation of one or more SQL Servers. It also suits to Database Developers who want to know how to optimize their code or to isolate performance issues in the data access layer. Participants will learn how to search and detect problems raising in SQL database, the QP and code Execution. This class includes solid theoretical material, part of which comes directly from the programme team, who develops SQL Server in Microsoft, and unpublished tuning techniques for increasing of SQL Server performance.
See full list of trainings at: www.sqlmasteracademy.com
This is a schedule packed with opportunities – we're expecting you!