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 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 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 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
