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.
SQL SERVER – SSMS: Memory Consumption Report
‘My SQL Server eats RAM and never gives it back’ is a common complaint. The SSMS Memory Consumption report shows where that memory goes and why.