Top resource consumers in Query Store show CPU, duration, and reads by query and plan, so tuning starts with workload impact.
Object Dependencies in SSMS: SQL in Sixty Seconds #071
Object Dependencies in SSMS shows the references recorded in SQL Server metadata. This post adds T-SQL queries for both directions, tested on SQL Server 2025, and shows what the dialog cannot see: dynamic SQL, other databases and a table dropped under a view.
Getting Your Employer to Pay for Training
Ask your employer to pay for training with a short proposal that ties the course to work, shows cost, and shares the result with the team.
SQL SERVER – SSMS: Activity – All Blocking Transactions
Bengaluru traffic after a rainy day has a lot in common with blocked queries. I look at the All Blocking Transactions report in SSMS and what it shows.
SQL SERVER – Activity Reports – Dormant Sessions
A parent-teacher meeting tells me more than a report card. In the same way, the SSMS activity report on Dormant Sessions shows idle connections on your server.
AND Before OR: Operator Precedence in WHERE Clauses
A report showed closed orders even though the filter said open. The reason is how SQL Server groups AND and OR.
MySQL – How to Format Date in MySQL with DATE_FORMAT()
MySQL uses the DATE_FORMAT function to show a date or datetime value in the format you need. Here are simple, self-explanatory examples for common formats.
SSMS Code Snippets: Writing Your Own Templates
Build SSMS code snippets with editable literals, register your own snippet folder, and use Template Explorer for repeatable SQL scripts.
SQL SERVER – Beginning Contained Databases – Notes from the Field #037
Beginning contained databases: syncing users and logins is a pain with database mirroring. John Sterrett explains how a contained user needs no login.
Login vs User in SQL Server: Who Gets In, Who Can Do What
Login vs user is a question of authentication and authorization in SQL Server. A login lets you into the instance, and a user gives you rights inside one database. This post builds both on a demo database, shows the errors that appear when one is missing, and explains how they map.










