In the previous article of this series, you learned that spaCy allows you to train its parser to be specific to your domain, which can be useful if you, for example, are developing a conversational application. In the example given in the article, you were guided through the steps of preparing training examples for the parser and then training the...
Standard Members
Different Software, Data types, Index and Operators applicable in Structured Query Language (SQL) – Part 3
SQL (Structured Query Language) – Indexes Indexes are special search tables that allow the database search engine to speed up data recovery. In short, an index is a pointer to the data in a table. An index in a database is very much related to an index which is present at the end of any book. For example, if you...
Should I Fire an Employee Who Reports Sick About 2 Days Per Month?
This question came from a business professional. “I have an employee who usually reports sick about 2 days per month, but he is a good worker. Should I fire him?” You have mentioned that he is a good worker, so I am not sure I understand the real concern here. If this employee meets and exceeds expectations, then why automatically...
Troubleshooting xml problems in SQL Server 2017
Troubleshooting xml problems in SQL Server 2017 If you have problems with SQL Server 2017 XML, review this troubleshooting checklist to find potential solutions. 1. The error 432 occurs when you try to use the Xml data type methods in check constraints. This error indicates that Xml data type methods are not supported in check constraints anymore. You should drop...
Different Software, Data types, Index and Operators applicable in Structured Query Language (SQL) – Part 2
IBM DB2 Latest version 11.1. Developed in 1983. The language used is the C, C ++ assembler to write it. It is compatible with multiple versions of Windows, UNIX as well as Linux. Some functions are the following: It is very easy to install and configure, and the data is easily accessible. An individual can store the enormous amount of...
Troubleshooting problems with SQL Server 2017 triggers
Troubleshooting problems with SQL Server 2017 triggers If you have problems with SQL Server 2017 triggers, review this troubleshooting checklist to find potential solutions. 1. Access violation occurs when a DDL trigger is raised by the CREATE EXTERNAL TABLE command. Additionally, you may receive the following error messages: “Cannot continue the execution because the session is in the kill state.”...
Parsing Intents and Their Targets into SQL Queries with spaCy: Part 1
People use natural languages to communicate with each other. To efficiently interact with a machine, good knowledge of programming languages is required. Natural Language Processing (NLP) is here to enable human-machine communications through natural languages. This is however, a very general notion of what NLP is. Intuitively, it may seem that an NLP-enabled application understands human speech natively, like a...
Different Software, Data types, Index and Operators applicable in Structured Query Language (SQL) – Part 1
What is SQL (Structured Query Language)? SQL is a structured query language, a computer language in which the data stored in a relational database is stored, manipulated and retrieved. The structured query language (SQL) is the default language of the relationship database system. All relational database management systems, such as MySQL, MS Access, Oracle, Sybase, Informix, Postgres and SQL Server,...
Should I Accept a Counteroffer or Move On?
This question comes from a busy professional. I told my boss that I’m going to resign, and he offered me twice my current salary if I stay, what should I do? Congratulation on the counteroffer. It says a lot about your value to their organization. Great job! Now for the hard part: deciding your next step. What was your reason...
Troubleshooting SQL Server 2017 backup/restore problems
Troubleshooting SQL Server 2017 backup/restore problems If you have problems with SQL Server 2017 backup/restore, review this troubleshooting checklist to find potential solutions. 1. Check that you have appropriate permissions to make backup/restore. To backup database or transaction log, you should have BACKUP DATABASE or BACKUP LOG permissions granted to you, or you should be a member of the sysadmin...