Convert string values to title case with a corrected function, ordered SQL Server aggregation, and clear limits for personal names.
SQL SERVER – Quiz with DATEADD Function – SQL Puzzle
The DATEADD function returns the last day of the month when the day does not exist, so one month after January 31 is February 28. This post keeps the quiz, runs every query on SQL Server 2025 and explains the month rule and the Msg 517 overflow with the real results.
SQL SERVER – Msg 8152, Level 16, State 14 – String or Binary Data Would be Truncated
Msg 8152, String or binary data would be truncated, is an error most developers have seen. Here is what causes it and why the setting that hides it needs care.
SQL SERVER – One Trick of Handling Dynamic SQL to Avoid SQL Injection Attack?
SQL Injection is not a SQL Server problem, it comes from coding habits. Here is one trick of handling dynamic SQL to avoid SQL injection attack on a search page.
SQL SERVER – Invoking a Stored Procedure from Azure Mobile Services – Notes from the Field #066
Can you call a SQL stored procedure from Azure Mobile Services? In Notes from the Field #066, Kevin Hazzard shows how, with a bit of humor along the way.
SQL SERVER – FIX – Error 3201 – Cannot open backup device. Operating system error 3
BACKUP DATABASE failed with Error 3201, cannot open backup device, operating system error 3. The cause was a missing default folder. Here is the fix.
Top N per Group: Three Ways and Which Is Fastest
Compare top N per group with ROW_NUMBER, APPLY and a correlated subquery, define tie behavior, and measure plans with a supporting index.