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...
SQL Server
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...
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...
How to Reject a Job Offer After Accepting It
This question comes from a busy professional. I accepted a job offer, but then received a much better one two weeks later. What is the right thing to do? 2nd company offered me 20% better pay with OT, closer to home, and better benefits. Congratulations on your great job offers! You did an amazing job attracting both companies. Please take...
Troubleshooting SQL Server 2017 Reporting Services
Troubleshooting SQL Server 2017 Reporting Services If you have problems with SQL Server 2017 Reporting Services (SSRS 2017), review this troubleshooting checklist to find potential solutions. 1. Check the SSRS logs if you have problem with Reporting Services. SSRS records many internal and external events to log files that record data about specific reports, debugging information, HTTP requests and responses,...