I‘m Klaus Aschenbrenner, a Microsoft Certified Master for SQL Server
» I help people to bring their SQL Server
installations to a new level of excellence. «
SQLpassion Offerings
SQLpassion, a European SQL Server consulting company, provides high-quality SQL Server consulting services.
We are based in Vienna, Austria, but our client base is spread across the continent.
We provide the following SQL Server services:
You have seen my Blog Postings?
Understanding Concurrency Control in SQL Server and PostgreSQL: A Comparative Analysis
Concurrency control is a cornerstone of database management systems, ensuring data consistency and integrity when multiple users access or modify data simultaneously. SQL Server and PostgreSQL implement concurrency control differently, reflecting their distinct architectural philosophies. In this blog post, I will explore the concurrency methods used by these systems, focusing on the methods of pessimistic
Introducing My Brand-New Online Training: PostgreSQL for the SQL Server Professional!
Are you a seasoned SQL Server professional looking to broaden your horizons and step into the world of PostgreSQL? Do you want to leverage your existing SQL Server expertise while mastering the unique features of PostgreSQL? If so, I’ve got exciting news for you! I’m thrilled to announce the release of my brand-new, two-day online
How to Fix the PostgreSQL “Could Not Resize Shared Memory Segment” Error in Docker
When running PostgreSQL in Docker, encountering the error “could not resize shared memory segment” can disrupt your database operations. This issue typically arises because PostgreSQL depends heavily on shared memory for tasks such as caching and inter-process communication. The error often occurs due to insufficient shared memory allocation in the Docker container, or misconfigured PostgreSQL
