SQL Server

Pro Members SQL Server Standard Members

Troubleshooting SQL Server 2017 Snapshot Replication

Troubleshooting SQL Server 2017 Snapshot Replication If you have problems with SQL Server 2017 snapshot replication, review this troubleshooting checklist to find potential solutions. 1. Check that you have sysadmin permissions on the SQL Server. Only members of the sysadmin server role can configure replication, so if you have not these permissions you cannot setting up or configure snapshot replication....

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Pro Members SQL Server Standard Members

What Should I Do if I Am Getting the Least Salary Among My Teammates?

This question came from a business professional. I recently joined a new company and I’m getting the least salary among my teammates while I have more related working experience. What should I do? This is why people are discouraged from discussing salary amongst your teammates. Not many people feel they are getting paid what they are actually worth. The people...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Pro Members SQL Server Standard Members

Troubleshooting SQL Server 2017 Bulk Copy Problems

Troubleshooting SQL Server 2017 Bulk Copy Problems If you have problems with SQL Server 2017 bulk copy, review this troubleshooting checklist to find potential solutions. 1. You may receive error 595 when you bulk insert with another outstanding result set. To work around this problem, you should run bulk insert statement with XACT_ABORT on. 2. The error 674 may occur...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Pro Members SQL Server Standard Members

What Computational Linguistic Is About

To this point, humanity has a huge amount of data that can be used to automate many repeatable tasks, thus allowing us, humans to switch to more interesting work. One approach to take advantage of large amounts of data – which has become very popular recently – is based on using machine learning algorithms. This is when a machine is...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Pro Members SQL Server Standard Members

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

DATABASE DEVELOPMENT LIFE CYCLE (DDLC) The Database Development Cycle (DDLC) is a process of planning, applying, as well as preserving a database system to meet the tactical or operative information necessities of an enterprise or organization like – • Enhanced customer support as well as customer fulfillment. • Enhanced production managing. • Enhanced inventory managing. • More precise sales predictions....

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Pro Members SQL Server Standard Members

Should I Lie About the Reason I Got Fired?

This question came from a business professional. I got fired for poor performance. Should I lie about the reason of it in my next job interviews? Firstly – I would not recommend “lying” in a job interview. The truth will most likely be discovered. And then you will be “caught in a lie” and therefore, seen as untrustworthy and unreliable....

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Pro Members SQL Server Standard Members

Troubleshooting SQL Server 2017 CLR Problems

Troubleshooting SQL Server 2017 CLR Problems If you have problems with SQL Server 2017 Common Language Runtime (CLR) objects, review this troubleshooting checklist to find potential solutions. 1. You may receive error 701 when you use a CLR table-valued function (TVF) together with the CROSS APPLY operator in a query. The error 701 indicates that there is insufficient system memory...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Pro Members SQL Server Standard Members

Parsing Intents and Their Targets into SQL Queries with spaCy: Part 2

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

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Pro Members SQL Server 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...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Pro Members SQL Server Standard Members

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

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here