(Tapas Pal) A Palindromic number or string can be read in both directions. It’s a form of word puzzle. A numeral Palindrome is a number which remains the same when its digits are reversed.
Community
STATUS_STACK_BUFFER_OVERRUN doesn’t mean that there was a stack buffer overrun
(Raymond Chen) A category of dubious security vulnerability is people who recently discovered the STATUS_STACK_BUFFER_OVERRUN status code.
Compression options in MySQL (part 1)
(Yves Trudeau) Over the last year, I have been pursuing a part time hobby project exploring ways to squeeze as much data as possible in MySQL.
ALTER SESSION RESET parameter works but doesn’t work
(Flavio Casetta) I was wondering why it’s not possible to reset a session modifiable parameter to its default value (that is the system wide current value), then just out of curiosity I tried to execute the following:
A setup to test backup and restore options
(John Hallas) A couple of years my team put together some procedures and the underlying databases to allow testing of as many RMAN recovery options as we could think of. We had two databases which gave us a Dataguard capability and we secured both databases using Commvault backups so we always had a
Ranges with NULLs 06: Overlaps with Conflicting Data
(stewashton) In 2014 I attacked the problem of “Overlapping ranges with priorities”. This time I’ll deal with NULLs and propose an improved solution.
Introduction to SQL Server Query Optimization with Database Engine Tuning Advisor
(Diogo Souza) Most of the times that we need to optimize a SQL Server query, a lot of questions and uncertainties come to our minds, just like if we could use any tool that would help with this type of improvement not only regarding the performance itself, but also in structural terms like with inde
Azure SQL Database DTU Versus vCore
(blobeater) I wrote a guest article for an IT consultancy on Azure SQL Database, more specifically DTUs and vCore options. At a high level I discuss what both options are, the differences and what you should select.
The Functional Style – Part 9
(Richard Wild) In this series we’ve taken a whirlwind tour through the topics related to functional programming that I think are most important to know, plus some extra that I think are good to know.
The transaction log for database is full due to LOG_BACKUP
(Jack Vamvas) Question: I’m getting the The transaction log for database is full due to LOG BACKUP Error 9002 Severity 17 State 2 error message .