(Jon Skeet) This is a blog post I’ve intended to write for a very long time. (Other blog posts in that category include a recipe for tiramisu ice cream, and “knights and allies”.)
Community
ERROR 1040 (HY000): Too many connections
(abhinav prasad gupta) An application might face this issue when all the defined max_connections parameter value is exhausted.
Find files with errors
(Michael McLaughlin) My students wanted a quick solution on how to find the log files that contain errors.
Quicktip: Don’t grant access to a synonym
(Mathias) I’ve seen this in a few places lately. When I ask the database gays there about it, they think this DDL would never work or “it does nothing but does not return an error”.
SQL SERVER – FIX: Msg 15274 – Access to the Remote Server is Denied Because the Current Security Context is not Trusted
(Pinal Dave) While working with a client, I encountered few errors while using linked server and I am going to share my solutions via a few blog posts.
REST Services now available for Oracle Autonomous Database
(Jeff Smith) The Autonomous Database is offered via two services in our Oracle Cloud, Autonomous Data Warehouse and Autonomous Transaction Processing.
ASP.NET CORE Token Authentication and Authorization using JWT (No Cookies) – Part 1
(Joseph Rozario) This article explains how to implement Token Authentication and Authorization using JWT in ASP.NET CORE.
Why you should cleverly name Database Objects for SQL Unit Testing
(Haroon Ashraf) This article is focussed on clever database object naming from both development and SQL unit testing point of view.
How SQL Server DevOps processes help break down data silos
(Lindsay Moore) DevOps can help organizations dismantle data silos in SQL Server and other database systems — and replace organizational silos with cross-functional teams.
Advice from a successful ITERGO migration to Db2 12 for z/OS
(Ann Hernandez) ITERGO is an affiliate of its holding company ERGO AG, which is a major insurance group that operates in Germany, throughout Europe, and worldwide. Headquartered in Düsseldorf Germany, ITERGO is the company’s IT service provider and employs about 1700 people at four locations in Germ