Prior to Introduction of Database Management Systems (DBMS) The way computers manage data has changed dramatically in the last few decades. Today’s end users take the many advantages of a database system for granted. Not so long ago, computers used a less elegant as well as expensive approach to data management called a file-based system. File-Based System One way to...
SQL Server
How Do I Thank My Boss for a Pay Raise?
This question came from a busy professional. How do I thank my boss for a pay raise? I received a good raise because of my excellent performance over the years, but I wasn’t gushing over it. I had been with the company for about 8 years, and was the manager of two teams: the test and documentation groups. I received...
Troubleshooting SQL Server 2017 installation
Troubleshooting SQL Server 2017 installation If you have problems with SQL Server 2017 installation, review this troubleshooting checklist to find potential solutions. 1. Check the hardware requirements. To install SQL Server 2017, you should have the following hardware: – Intel or compatible platform with processor speed: 1.4 GHz minimum for a 64-bit x64 2.0 GHz or faster recommended – Memory...
AI-powered Search with spaCy — Part 1
One of those tasks AI powered application usually faces is the ability to understand what the user is asking about or what he/she wants to know. Actually, it’s a big challenge to make your code “understand’ user questions. In this article, you’ll see an example of how you can create “smart” code that can process a certain type of user...
What Are the Signs Indicating That an Employee Is About to Quit?
This question came from a busy business owner. What are the signs indicating that an employee is about to quit? Keeping a good employee It’s hard to tell if an employee is thinking of quitting, but to avoid losing good employees and performers, do the following: Setup one-on-one twice monthly meetings to discuss career opportunities and advancement options Identify each...
Troubleshooting security problems in SQL Server 2017
Troubleshooting security problems in SQL Server 2017 If you have security problems in SQL Server 2017, review this troubleshooting checklist to find potential solutions. 1. Dimension security is ignored by Power BI Desktop in SQL Server Analysis Services Multidimensional model. In this case, when you open the dimension, all the measures become visible, and even those that you have denied...
Concepts of Network Model and Hierarchical Data Structure – Part 4
Properties of a Hierarchical Schema The hierarchical schema of record types as well as Parent Child Relationship (PCR) types should have the subsequent properties: A record type, known as a root of the hierarchical schema, do not take part in any type of Parent Child Relationship (PCR) as a child record type. Each and every single record type excluding the...
Should I Stop Contacting a Customer Who Isn’t Responding to My Emails or Phone Calls?
This question came from a busy business owner. Should I stop contacting a customer who isn’t responding to my emails or phone calls? Two months ago, we sent our response to a bid. I’ve been trying to get feedback and follow up with the customer, but they have gone silent. I’ve tried reaching them by email and phone. How long...
Troubleshooting SQL Server 2017 problems on Linux
Troubleshooting SQL Server 2017 problems on Linux Starting from SQL Server 2017, Microsoft supports the Linux operating systems to install SQL Server. If you have problems when you work with SQL Server 2017 on Linux, review this troubleshooting checklist to find potential solutions. 1. You may notice that the daylight saving time (DST) changes are not determined by SQL Server...
Answering Questions Programmatically with Wikipedia API and spaCy
In the modern world, artificial Intelligence (AI) is almost everywhere. We have long been accustomed to the fact that a robot picks up the phone when you call a bank, and ordering a pizza can be done without human participation. In this article, you’ll see how to create programming code that can intelligently answer user input. For example, it might...