What are the .c, .dll, .obj and .pdb files created for Natively Compiled Stored Procedures in SQL Server 2014? A quick list of each extension and what it does.
Current Activity Section: Performance Dashboard Reports Explained
The Current Activity section of Performance Dashboard shows what is running right now, split into user requests and user sessions, taken from two DMVs.
SQL SERVER – SSMS: Resource Locking and Object Execution Statistics Report
How many times did a procedure run, and how much CPU and IO did it use? The SSMS Resource Locking and Object Execution Statistics reports answer exactly that.
Choosing a Technical Conference Worth Attending
Choose a technical conference by matching sessions and audience to your skill goals, then counting the full cost before you book.
SQL SERVER – How to Setup Delayed Durability for SQL Server 2014?
How do you setup Delayed Durability in SQL Server 2014? Here are three methods, starting at the database level with ALTER DATABASE SET DELAYED_DURABILITY.
Stale Views: Why SELECT * Breaks After ALTER TABLE
Reproduce stale views after SELECT star and ALTER TABLE, find candidate definitions, refresh with sp_refreshview, and prevent the pattern.
CE Feedback for Expressions in SQL Server 2025
Inspect CE feedback for expressions in SQL Server 2025, check compatibility and Query Store, and observe repeated execution evidence.