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.
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
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
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 …
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 …
Understanding PostgreSQL’s $PGDATA Folder in comparison 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.
