
SQLpassion Blog
145 FOLLOWERS
Hi! I'm Klaus Aschenbrenner. With my company, SQLpassion, I provide high-quality SQL Server consulting services across Europe. I'm specialized in optimizing SQL Server installations, implementing performance improvements and high availability options, and provide consulting services across the whole SQL Server platform. I help people around the world to understand, implement, and run SQL..
SQLpassion Blog
1w ago
When it comes to fine-tuning database performance, small settings often make a big difference. One such setting – frequently discussed but not always fully understood—is the fill factor. Both SQL Server and PostgreSQL support this concept, yet they approach it differently. If you’re managing databases in either of these systems, understanding how fill factor works can …
Understanding Fill Factor in SQL Server and PostgreSQL + read more ..read more
SQLpassion Blog
2w ago
On January 9 I have done an online presentation about Exploring PostgreSQL for the SQL Server Developers and DBAs for the Cloud Data Driven User Group. You can find the recording of the whole session (around 105 minutes) here to watch: If you’d like to explore the differences between SQL Server and PostgreSQL in greater depth, …
Online Recording: Exploring PostgreSQL for SQL Server Developers and DBAs + read more ..read more
SQLpassion Blog
3w ago
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 …
Understanding Concurrency Control in SQL Server and PostgreSQL: A Comparative Analysis + read more ..read more
SQLpassion Blog
1M ago
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 …
Introducing My Brand-New Online Training: PostgreSQL for the SQL Server Professional! + read more ..read more
SQLpassion Blog
2M ago
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 …
How to Fix the PostgreSQL “Could Not Resize Shared Memory Segment” Error in Docker + read more ..read more
SQLpassion Blog
2M ago
Efficient data retrieval is a cornerstone of database management, and both PostgreSQL and SQL Server excel in offering robust data access methods to support diverse workloads. However, their approaches differ in significant ways, reflecting their unique design philosophies and use cases. In this blog posting, I will cover the various data access methods PostgreSQL provides, …
Exploring Data Access Methods in PostgreSQL and How They Compare to SQL Server + read more ..read more
SQLpassion Blog
2M ago
Today I have uploaded SQL Server Quickie #48 to YouTube. This time I’m talking about Azure SQL Managed Instance. If you are interested in learning more about this very interestingh topic, I highly recommend to check-out my live training about it that I run from November 27 – 28, 2024 ..read more
SQLpassion Blog
3M ago
Yesterday, Microsoft released the highly anticipated Windows 11 ARM ISO image, marking a major milestone for ARM-powered devices. This new release opens the door for users to install Windows 11 on their own ARM-based hardware. About a year ago, I invested in the Windows Dev Kit, which runs on the ARM Snapdragon Compute Platform. However, …
Microsoft Releases Windows 11 ARM ISO – A Game Changer for ARM-Powered Devices + read more ..read more
SQLpassion Blog
3M ago
Struggling with slow queries? Facing performance bottlenecks? Tired of troubleshooting SQL Server issues without a clear roadmap? With this Black Friday Sale, take control of your SQL Server performance with a powerful learning opportunity: 60% off all my SQL Server online trainings – exclusively available until November 30, 2024! For a limited time, you can …
Master SQL Server Performance Tuning – Black Friday Sale: 60% Off All Online Trainings! + read more ..read more
SQLpassion Blog
3M ago
In database systems, query optimization plays a crucial role in determining application performance. Efficient queries rely on up-to-date statistics that help the database’s query optimizer decide on the best execution plan. In PostgreSQL, the ANALYZE command is a key tool for collecting these statistics, especially when data is modified. This blog post delves into how …
Optimizing Query Performance with Statistics Updates in PostgreSQL and Microsoft SQL Server + read more ..read more