A reader asked about sp_user_counter1 to 10 for debugging. I show how sp_trace_generateevent raises events you can watch as User Configurable info.
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 – 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.
Gaps and Islands: Finding Missing Ranges in a Sequence
Solve gaps and islands with LEAD, ROW_NUMBER, and GENERATE_SERIES, then apply the same date patterns to missing days and login streaks.
Insufficient System Memory: Msg 701 in a Resource Pool
Msg 701 reports insufficient system memory in a resource pool. This post reproduces it safely with a memory-optimized table on SQL Server 2025, shows the second message you get when the rows fill the pool, and lists the fixes that worked.
Interview Question of the Week #004 – List All Columns and Their Data Type for a View
Inspect a view’s columns and their data type with SQL Server catalogs, result-set metadata, and checks for stale view definitions.
Bind Resource Governor to a Memory-Optimized Database
To bind Resource Governor to a memory-optimized database, you create a pool, bind it with one stored procedure and restart the database. This post runs each step on SQL Server 2025, proves the binding with the pool memory, and restores the server.