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...
SQL Server
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...
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...
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...
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...
Transaction Using ACID Properties Timestamp Protocol and Security Procedures – Part 3
Methods for Reviewing Database Management System (DBMS) Recovery Reviewing a Database Management System (DBMS) recovery should ensure that employees with specific responsibilities perform their tasks in accordance with policies as well as operating procedures. There are several useful audit techniques for Database Management System (DBMS) recovery. There are two ways to run the system again. First, any transaction that occurred...
Troubleshooting problems with MDS in SQL Server 2017
Troubleshooting problems with MDS in SQL Server 2017 If you have problems with SQL Server 2017 Master Data Services (MDS), review this troubleshooting checklist to find potential solutions. 1. When you expand the Entities folder on the Manage Groups page in MDS, you may notice that it takes a long time to display all the entities under the folder. In...
Intelligent Text Generation with spaCy Part2
Word sequence patterns based on linguistic features and introduced in the previous article in this series are not the only means of intelligent text processing and text generation. This article focuses on another common technique based on using syntactic dependency trees. This is also one of those techniques that you can use to teach your conversational application to generate meaningful...
Transaction Using ACID Properties Timestamp Protocol and Security Procedures – Part 2
How should timestamps be used? The timestamp order protocol ensures that two conflicting read / write operations are executed in the corresponding timestamp order. It is an alternative solution to the use of locks. For Reading operations: If TS (T) is < W timestamp (P), transaction T attempts to read a value of P data that has already been overwritten...
What Should I Do If My Boss Asks Me to Cover My Friend’s Shift so He Can Fire Her?
This question came from a business professional. My boss asked me to cover my coworker’s shift because he is about to fire her. She and I are good friends outside of work. Should I warn her? I can see that this is a very difficult decision for you. You can probably see it both ways: Being loyal to the company...