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?
Master SQL Server Performance Tuning – Black Friday Sale: 60% Off All Online Trainings!
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
Optimizing Query Performance with Statistics Updates in PostgreSQL and Microsoft SQL Server
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
Understanding PostgreSQL’s $PGDATA Folder in comparison to SQL Server
In the world of databases, the efficiency and reliability of how data is stored and managed are critical factors that can determine the performance, scalability, and ease of administration for any system. PostgreSQL and Microsoft SQL Server take slightly different approaches to data storage. A key concept in PostgreSQL that database administrators often encounter is
