Standard Members

Pro Members SQL Server Standard Members

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 /…...

This content is for Pro, Pro Member, Standard and Standard Member members only.
Log In Register
Pro Members SQL Server Standard Members

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…...

This content is for Pro, Pro Member, Standard and Standard Member members only.
Log In Register
Pro Members SQL Server Standard Members

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…...

This content is for Pro, Pro Member, Standard and Standard Member members only.
Log In Register
Pro Members SQL Server Standard Members

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…...

This content is for Pro, Pro Member, Standard and Standard Member members only.
Log In Register
Pro Members SQL Server Standard Members

Database Development Life Cycle, Normalization, Errors and Security of Database – Part 4

f execution database processor then executes the database access routines. The results are returned to the application that first made the request. All runtime errors are also returned. Query Optimization Allow the system to obtain (or improve) acceptable performance by choosing a better (if not the best) strategy during the query process. One of the great strengths to the relational…...

This content is for Pro, Pro Member, Standard and Standard Member members only.
Log In Register
Pro Members SQL Server Standard Members

How Do I Tell My Boss That My Resignation Letter Was Just a Way to Push for More Salary?

This question came from a busy professional. How do I tell my boss that my resignation letter was just a way to push for more salary and not actually resigning? They’re taking it seriously. Sadly, if you had asked me my opinion before you sent the letter, I would have advised NOT TO LIE about your intentions. Your boss and…...

This content is for Pro, Pro Member, Standard and Standard Member members only.
Log In Register
Pro Members SQL Server Standard Members

Troubleshooting SQL Server 2017 Merge Replication

Troubleshooting SQL Server 2017 Merge Replication If you have problems with SQL Server 2017 merge replication, review this troubleshooting checklist to find potential solutions. 1. Check that account the SQL Server and SQL Server Agent services runs under belongs to the Administrators local group and is a member of the Domain Users group. The LocalSystem account does not have network…...

This content is for Pro, Pro Member, Standard and Standard Member members only.
Log In Register
Pro Members SQL Server Standard Members

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,…...

This content is for Pro, Pro Member, Standard and Standard Member members only.
Log In Register
Pro Members SQL Server Standard Members

Database Development Life Cycle, Normalization, Errors and Security of Database – Part 3

First Normal Form (1NF) A relationship is said in first normal form (1NF) if it does not contain a non-atomic value as well as each and every row or tuple can offer an exclusive combination of values. As you can see, each and every row or tuple has an exclusive combination of values. In contrast to un-normal form (UNF), this…...

This content is for Pro, Pro Member, Standard and Standard Member members only.
Log In Register
Pro Members SQL Server Standard Members

How to Handle Employees that are Committed to Work Hours Only

This question came from a busy professional. I have two employees that usually leave work at 6 pm. They are good, but I don’t like that their commitment lasts for work hours only. What should I do as a CEO? Resetting expectations One thing that I would recommend is to reset your business expectations. As a CEO, you are naturally…...

This content is for Pro, Pro Member, Standard and Standard Member members only.
Log In Register