Distinguish ROWS_PER_BATCH estimates from BULK INSERT commit batches, then review logging, locks, rejected rows, and atomic loading.
Why ‘Max Server Memory’ Isn’t Always the Limit
What if I told you that setting a limit with “max server memory (MB)” doesn’t always mean SQL Server will stick to that limit?
Logging Agent Jobs That Call Stored Procedures
Improve logging Agent jobs with procedure run records, start and end events, captured errors, step output, and history correlation.
Detailed Summary of “Selling the Invisible: A Field Guide to Modern Marketing” by Harry Beckwith
Let me tell you about a book that seriously changed the way I think about marketing services. It’s called “Selling the Invisible” by Harry Beckwith.
Cleaning Currency Strings Into decimal Values
Convert currency strings into decimal amounts using known symbols, explicit parsing cultures, conversion checks, and rejection evidence.
Capturing Stored Procedure Executions with Extended Events in SQL Server
Capturing stored procedure executions with Extended Events: set up a session with module_end, run a sample procedure, and query the captured data.
A Walkthrough – DATETRUNC Function in SQL Server
One such tool is the DATETRUNC function, introduced in SQL Server 2022. Let’s take a journey to understand how this function can simplify date handling.