PostgreSQL

Attend my Online Training in November: 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 that I’m running again my brand-new, two-day …

Attend my Online Training in November: PostgreSQL for the SQL Server Professional + read more

From SQL Server to PostgreSQL: A Story of 5 Key SQL Differences

After spending decades working in SQL Server, getting familiar with PostgreSQL felt like traveling to a country where everyone speaks a language I mostly understand – but with a different accent and some unfamiliar slang. At first glance, SQL is SQL. But once I started writing real queries in PostgreSQL, I realized that my habits from T-SQL …

From SQL Server to PostgreSQL: A Story of 5 Key SQL Differences + read more

Understanding Text Data Types in PostgreSQL and SQL Server

When working with PostgreSQL, understanding its text data types is essential, especially for those coming from a Microsoft SQL Server background. While both database systems support text storage, they handle it in fundamentally different ways. PostgreSQL provides several text-related data types, each with its own purpose and behavior, and understanding their nuances can help avoid …

Understanding Text Data Types in PostgreSQL and SQL Server + read more

Understanding Query Plan Caching in PostgreSQL and How It Differs from SQL Server

When it comes to database performance, query execution planning is one of the most critical factors. Every time a database receives a query, it must decide how to execute it in the most efficient way possible. This decision making process – known as query planning – can be expensive in terms of computation time, especially …

Understanding Query Plan Caching in PostgreSQL and How It Differs from SQL Server + read more

Understanding Fill Factor in SQL Server and PostgreSQL

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