Troubleshooting SQL Server 2017 Columnstore Indexes If you have problems with SQL Server 2017 columnstore indexes, review this troubleshooting checklist to find potential solutions. 1. You can get the error 980 when you try to load SQL Server 2017 database. This is the error message text: “SQL Server cannot load database ‘%.*ls’ because it contains a columnstore index.” This error...
SQL Server
Transaction Using ACID Properties Timestamp Protocol and Security Procedures – Part 1
Transaction – Definition A transaction is a set of modifications that must all be done together. This is a program unit whose execution may change the contents of a database or not. The transaction is implemented as a single entity. If the database was in a consistent state before a transaction, it must be in a consistent state even after...
Database Development Life Cycle, Normalization, Errors and Security of Database – Part 6
Database security Database security cannot be considered an isolated problem because it is also affected by other components of a computer system. The security requirements of a system are determined by means of a security policy, which is then enforced by various security mechanisms. For databases, security requirements can be divided into the following categories: Identification, authentication – Normally, each...
3 Things Should You Never Do on a Job Interview
This question came from a business professional. What 3 things should you never do on a job interview? Top 3 things you should never do Although there are lots of things to keep in mind, some things to consider are: Don’t be late. Plan to be at least 1 hour early to avoid any traffic or travel issues. Once there,...
Troubleshooting problems with deadlock in SQL Server 2017
Troubleshooting problems with deadlock in SQL Server 2017 If you have problems with deadlock in SQL Server 2017, review this troubleshooting checklist to find potential solutions. 1. Keep transactions as short as possible. This can be used to reduce deadlock, because problems with locking typically occurs when several long-running transactions execute concurrently in the same database. The shorter the transaction,...
Using Linguistic Features in NLP
If you had to describe what NLP is about, what would you point out as the most important thing? Is there something that is vital for many use cases and is employed in almost every NLP application? For example, what do you almost certainly need when it comes to a task of information extraction of any kind? Right. Linguistic features,...
Database Development Life Cycle, Normalization, Errors and Security of Database – Part 5
Database Security The database security means to practice a broad range of information security controls to safeguard databases (which include data, database applications or stored functions, base systems databases, database servers as well as related network connections) to breaches of their confidentiality, integrity as well as integrity. It includes different types or categories of controls, for example technical, procedural /...
How to Handle a Boss that Wants You to Continually Work Overtime
This question came from a business professional. My boss threatened to fire me because I usually leave work at 6pm and don’t stay until 8/9 like other employees. How should I handle this? My one recommendation is to not allow it to get this far. Once at this point you have a couple of options. Start One-on-One weekly manager’s meeting...
Troubleshooting SQL Server 2017 full-text search
Troubleshooting SQL Server 2017 full-text search If you have problems with SQL Server 2017 full-text search, review this troubleshooting checklist to find potential solutions. 1. Ensure the user needs to create, alter or drop the full-text catalogs have appropriate permissions. To create a full-text catalog the user must have CREATE FULLTEXT CATALOG permission on the database, or must be a...
Intelligent Text Generation with spaCy Part1
The most challenging tasks in natural language processing are natural language understanding and natural language generation. This article focuses on the latter, giving an example of how you might teach your conversational application to respond properly to its users. Of course, you will not find here a universal solution that covers all possible cases and can be implemented with just...