(Jeremy Kadlec) Users are reporting issues accessing one of our critical production databases. I see that the database is not loading properly in the application and in SQL Server Management Studio.
Other News
Datatables Plugin In Angular 7 Using .NET Core Web API – Part One
(Faisal Pathan) In this article, we will learn how we can integrate the datatable plugin with server-side pagination, sorting, and searching.
How to Turn a Manual Excel Workflow Into an Automated Web App Using the Java Client API
(Matthieu Duchemin) You can now automate your manual Excel workflow with the Java Client API.
Write Better Code Faster with Roslyn Analyzers
(Rika) Roslyn, the .NET compiler platform, helps you catch bugs even before you run your code. One example is Roslyn’s spellcheck analyzer that is built into Visual Studio.
Perl & MySQL 8.0
(Frederic Descamps) If you just migrated to MySQL 8.0, you may have seen that the default authentication plugin has been changed to a more secure one: caching_sha2_password and I’ve already written some articles about it.
ORADEBUG DOC 19.3
(Martin Berger) this is the output of ORADEBUG DOC for Version 19c.
Impact of CHECKPOINT On Memory – SQL in Sixty Seconds #084
(Pinal Dave) Some concepts are so good in SQL Server, they keep on coming back to me one way or another way. After reading my recent blog posts about CHECKPOINTS lots of people wanted to see the demonstration of the same.
The Great Hack, The Creepy Line, and Our Job
These are some really intriguing movies (Netflix, etc.) – they’re finally talking about data, data use, data ownership, privacy, customization (sort of) and all sorts of things that have significant implications on our career ethics and responsibilities. When you watch these, they can quickly lead to a rabbit hole of TED talks, blog posts and more. Probably result in some […]
T-SQL Performance Tip: NOT IN vs NOT EXISTS
(Hannes du Preez) Avoid using NOT IN whilst comparing nullable columns.
Understanding the SQL Server CASE statement
(Ben Richardson) SQL Server CASE statement is equivalent to the IF-THEN statement in Excel.