SQL Server

Pro Members SQL Server Standard Members

I Accidentally Saw My Coworker’s Contract and Salary

I accidentally saw my coworker’s contract and salary, and now I feel I’m getting less than I deserve. Should I tell my boss? 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 that have been working and loyal for many years, will…...

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.
Log In Register
Pro Members SQL Server Standard Members

Troubleshooting problems with linked servers in SQL Server 2017

Troubleshooting problems with linked servers in SQL Server 2017 If you have problems with linked servers in SQL Server 2017, review this troubleshooting checklist to find potential solutions. 1. Check that you have appropriate permissions to create linked servers. To create a linked server, you must have ALTER ANY LINKED SERVER permission. So, if you have no this permission, 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.
Log In Register
Pro Members SQL Server Standard Members

Intelligent Text Generation with spaCy Part3

In this part, we’ll discuss how to convert questions into statements or vice versa. As you know, in English word order in questions differs from word order in statements. You already saw a simple example of translating a question into a statement in part 1 of this article series. In this article, we’ll take a closer look at this problem,…...

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.
Log In Register
Pro Members SQL Server Standard Members

Transaction Using ACID Properties Timestamp Protocol and Security Procedures – Part 5

Database Administrator (DBA) The database administrator is accountable for guaranteeing that the database keeps its integrity as well as is responsible for confirming that the database is under no circumstances compromised. This person has the maximum power over the scheme implemented by the organization. Any modification or addition to this schema must be approved by the database administrator. Eligibility to…...

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.
Log In Register
Pro Members SQL Server Standard Members

How Do I Quit a Terribly Managed Job When My Boss “Needs” to Have Reasons as to Why You’re Quitting?

How do I quit a terribly managed job when my boss “needs” to have reasons as to why you’re quitting? I had an exit interview and told HR why I’m quitting. The next thing I know is that the whole department knows. I was asked to leave earlier than my last day of resignation date. The manager whom I worked…...

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.
Log In Register
Pro Members SQL Server Standard Members

Troubleshooting SQL Server 2017 Roles

Troubleshooting SQL Server 2017 Roles If you have problems with SQL Server 2017 roles, review this troubleshooting checklist to find potential solutions. 1. The error 920 may occur when you modify the database script level. This error indicates that only members of the sysadmin role can modify the database script level. To resolve this problem, ensure that user, who modify…...

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.
Log In Register
Pro Members SQL Server Standard Members

Transaction Using ACID Properties Timestamp Protocol and Security Procedures – Part 4

Correcting Inconsistency Problems. The most common method to eliminating consistency issues is locking. The Database Management System (DBMS) can use the locking functions provided by the operating system so that numerous processes can synchronize their concurrent access to the shared resources. A lock can be granted to several processes, however a given object cannot be locked simultaneously in shared as…...

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.
Log In Register
Pro Members SQL Server Standard Members

Do I Fire Someone Who Demanded a Promotion?

I have an employee who asked for a promotion effective immediately and when rejected said that he is going to switch companies if I don’t comply. Do I fire him? You haven’t shared much about this employee’s performance evaluation or experience. So, it’s difficult to advise at this point. I am assuming that if you are considering firing him because…...

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.
Log In Register
Pro Members SQL Server Standard Members

Troubleshooting SQL Server 2017 Indexes

Troubleshooting SQL Server 2017 Indexes If you have problems with SQL Server 2017 indexes, review this troubleshooting checklist to find potential solutions. 1. You can get the error 602. This error indicates that SQL Server could not find an entry for index in a database. This error may occur if a stored procedure references a dropped table, or metadata 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.
Log In Register