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
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
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
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
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
Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.
