Notes, explanations & scripts
Technical articles
I blog on LinkedIn about SQL Server, database development and lessons from my work. Browse my articles below.
Articles on LinkedIn
- Confused, locking, blocking, timeouts, deadlocks?!
https://www.linkedin.com/pulse/confused-locking-blocking-timeouts-deadlocks-peter-kruis-dbede - Decoding KEY and PAGE waitresource values in SQL Server
https://www.linkedin.com/pulse/decoding-key-page-waitresource-values-sql-server-peter-kruis-vuzyf - Tracking data changes with SQL Server Temporal Tables
https://www.linkedin.com/pulse/tracking-data-changes-sql-server-temporal-tables-peter-kruis-ucg3e - A precision issue in the new SQL Server JSON data type?
https://www.linkedin.com/pulse/precision-issue-new-sql-server-json-data-type-peter-kruis-hmeze - Favorite SSMS additions lately
https://www.linkedin.com/pulse/favorite-ssms-additions-lately-peter-kruis-ldtpe - Query Store – Open Source
https://www.linkedin.com/pulse/query-store-open-source-peter-kruis-njiee - Query Store: Catalog views
https://www.linkedin.com/pulse/query-store-catalog-views-peter-kruis-surxe - Query Store: SQL Server 2025
https://www.linkedin.com/pulse/query-store-sql-server-2025-peter-kruis-wncme - Query Store: Forcing and Hinting
https://www.linkedin.com/pulse/query-store-forcing-hinting-peter-kruis-gel1e - Query Store: GUI, Part II
https://www.linkedin.com/pulse/query-store-gui-part-ii-peter-kruis-narte - Query Store: GUI, Part I
https://www.linkedin.com/pulse/query-store-gui-part-i-peter-kruis-vxc8e - Query Store: Configuration
https://www.linkedin.com/pulse/query-store-configuration-peter-kruis-vtwoe - Query Store: Introduction
https://www.linkedin.com/pulse/query-store-introduction-peter-kruis-jte7e - Differences of SQL Server 2025 and SQL Server 2022 installations
https://www.linkedin.com/pulse/differences-sql-server-2025-2022-installations-peter-kruis-77ike - Who grew my log file? Extended Events to the rescue
https://www.linkedin.com/pulse/who-grew-my-log-file-extended-events-rescue-peter-kruis-0przc - Using DBATools to copy data between servers
https://www.linkedin.com/pulse/using-dbatools-copy-data-between-servers-peter-kruis-1gawe - Using DBATools to import a CSV to your database
https://www.linkedin.com/pulse/using-dbatools-import-csv-your-database-peter-kruis-w8mve - Monin goes USA
https://www.linkedin.com/pulse/monin-goes-usa-peter-kruis-wu18e - Configure the application name in the connection string of your applications
https://www.linkedin.com/pulse/configure-application-name-connection-string-your-peter-kruis-qxs4e - SQLBits 2024
https://www.linkedin.com/pulse/sqlbits-2024-peter-kruis-h46pe
Technical articles are being prepared. Check back for practical explanations and scripts.