(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”.)
Other News
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.
Troubleshooting SQL Server 2017 Indexes
Troubleshooting SQL Server 2017 Indexes If you have problems with SQL Server 2017 indexes, review this troubleshooting checklist to find potential solutions. 1. You can get the error 602. This error indicates that SQL Server could not find an entry for index in a database. This error may occur if a stored procedure references a dropped table, or metadata is...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
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.