Month: June 2024

Performance tuning in SQL Server is an essential aspect of database management that focuses on optimizing database performance and efficiency. This includes activities such as query optimization, indexing strategies, and server configuration. The Performance Tuning Course from Steve Stedman can help you as the student learn how to performance tune your SQL Server. Find out more about this Performance Tuning …

SQL School: The Importance of Performance Tuning in SQL Server Read more »

Foreign keys are a fundamental aspect of relational databases, as they enforce referential integrity between related tables. However, foreign key relationships can also cause performance issues, particularly if the foreign key is untrusted. An untrusted foreign key occurs when SQL Server is unable to verify the relationship between two tables, potentially leading to performance issues and data inconsistencies. The Database …

Database Health: Untrusted Foreign Keys Read more »

At Stedman Solutions we have done many corruption repairs since 2015. When I talk about corruption, most of this information comes from real world scenarios that actually happened at different businesses that we were part of recovering… or not part of recovering if things were completely gone. Transcribed from a presentation on Database Corruption by Steve Stedman and Derrick Bovenkamp. …

SQL Server Corruption: Corruption vs Drive Failure Read more »