Insights. One level above.
We know what above looks like. Explore the expertise built inside most demanding environments.
More than 9.9 million reads in the past 2 years See what readers open most
-
Reduce downtime when refreshing your non-production databases using Multitenant
Introduction You probably refresh your non-production Oracle databases with production data from time to time or on a regular basis. Without Multitenant, the most common procedure to do this refresh is a DUPLICATE FROM BACKUP with RMAN. The drawback is the unavailability of the database being refreshed during the DUPLICATE. You first need to remove the old version of the…
-
OGG-08502 Path not found error from OGG Receiver Service
Update: this bug seems to be corrected with the latest GoldenGate patch (23.26.2.0.1). If you face this error, try to patch your GoldenGate deployments. Recently, after a successful migration to GoldenGate 26ai, a customer complained that he was seeing a lot of the following error in the ggserr.log file of a GoldenGate deployment (I replaced the names for the purpose…
-
What being an external consultant really changes
When people think about consultants, they usually focus on expertise. “They bring experience, frameworks, and best practices.”That’s true, of course. However, that is not the most impactful aspect of the role.The real shift happens somewhere less visible: positioning. As an outsider, you don’t just join a team. You become something different. Over time, I’ve come to think of it as…
-
Install and configure OEM plug-in for GoldenGate
If you are licensed for the GoldenGate Management Pack, using the Enterprise Manager plug-in for GoldenGate improves monitoring and management of your deployments. And after migrating to the Microservices Architecture, you should definitely update your plug-in and rediscover all targets. Let’s see how to do all that here. In this blog, I will use the latest version of the Enterprise…
-
Customer case study – automating SQL Server TLS Encryption with Ansible and Certificates (Architecture)
When working with SQL Server environments, securing client connections can become an important requirement, especially when TLS encryption must be implemented using certificates. In this context, a customer asked us to develop an Ansible playbook and role to automate the configuration of TLS for SQL Server. The certificates are generated from the customer PKI and provided as PEM files containing…
-
How Row Goal shapes your SQL Server query strategy by hunting for pierogis
Mastering SQL Server Row Goals and how TOP, EXISTS, and FAST N influence execution plans and how to avoid performance traps in your queries
-
Let’s work together
Ready to operate at
the next level?Tell us about your challenge. We’ll bring the depth, the expertise, and the Swiss precision.
-
Most read
More than 360,000 reads in the last 30 days
The posts our readers open most: the all-time favourites, and what is trending right now.
All-time favourites
- Automate encryption-in-transit for SQL Server 124,231 reads
- SQLNET.EXPIRE_TIME and ENABLE=BROKEN 24,760 reads
- Enabling, disabling, and validating foreign key constraints in PostgreSQL 24,132 reads
Trending, last 30 days
-
When a Python driver configuration issue may cause blocking in SQL Server
One of our clients encountered blocking during their daily data load. The process loads several million rows and then performs an ALTER TABLE … SWITCH operation into a partitioned table. This operation usually takes some time, but in this case it became blocked. Context Initially, I did not have access to much information. The only element I received from the…
-
A Misleading SSAS Error in Power BI Report Server When Using DirectQuery Mode
Our client was experiencing issues after publishing a report that used Direct Query mode. Specifically, when the report was queried, the following error occurred: Error : We couldn’t connect to the Analysis Services server. Make sure you’ve entered the connection string correctly. However, this issue did not occur in Power BI Desktop. In Power BI, several data loading modes are…
-
SQLDay 2026 Workshops Overview
SQLDay 2026 offers a full-day workshop program on 11 May 2026, before the main conference scheduled for 12–13 May 2026 in Wrocław, with onsite and online participation options depending on the session. The workshops cover several areas of the modern data platform: advanced BI, AI and MLOps, SQL performance tuning, PostgreSQL adoption, and Microsoft Fabric automation. DAX – Beyond the…
Talk to an expert
Pick a topic and the right team replies personally within 2–3 business days.