News and Notes on the Structured Query Language

Actual day to day job (Thu, 15 Apr 2021)
>> Read more

Introducing lexiQL: SQL visualizer and GraphQL prototyping tool (Thu, 15 Apr 2021)
>> Read more

blog – Essential SQL

Foreign and Primary Key Values – What is the Difference? (Sun, 11 Apr 2021)
This article will teach you the difference between a primary key and foreign key. This article will also teach you why both of these keys are important when it comes to the maintenance of a relational database structure. All the examples for this lesson are based on Microsoft SQL Server Management Studio and the AdventureWorks […] The post Foreign and Primary Key Values – What is the Difference? appeared first on Essential SQL.
>> Read more

How to Use SQL Variables in Queries (Sun, 07 Mar 2021)
Learning how to use SQL Variable in queries is a step in the right direction towards making your queries more flexible for you and others to use. Why “hardcode” when you can parameterize? In this video and the following article, we’ll take you step-by-step through the process of changing a query’s filter criteria into a […] The post How to Use SQL Variables in Queries appeared first on Essential SQL.
>> Read more

Database Tutorials

Oracle Data Safe (Tue, 13 Apr 2021)
What is Oracle Data Safe? Oracle Data safe is a product designed for the Oracle database on your environment or within the cloud. In this article, we will examine the wonderful unified control software Oracle Data Safe, which will help you understand the sensitivity of the data you have, make security checks and evaluate the … The post Oracle Data Safe appeared first on Database Tutorials.
>> Read more

SQL Server on Azure Kubernetes (Fri, 02 Apr 2021)
In this article, I will be explaining how to create a Kubernetes cluster in Azure Kubernetes Service, and how to install SQL server on Azure Kubernetes cluster. This topic will represent the introduction to the Azure Arc Enabled Data Services topic. What is Kubernetes? First of all, I think it would be better to start … The post SQL Server on Azure Kubernetes appeared first on Database Tutorials.
>> Read more