In this part, we”ll take a look at how you might conduct an AI-powered search to extract a quick answer from a set of news article titles, using the syntax-driven sentence segmentation and syntactic dependency parsing features of spaCy. In particular, you’ll learn how you can get an answer to your business question immediately using news headlines analysis and natural...
SQL Server
PART I: File Organization in DBMS
Introduction A database consists of a large amount of data. The data is grouped in a table of the RDBMS and data records are assigned to each table. A user can see that the data is stored in tabular form, but in reality this large amount of data is stored in the form of files in physical memory. Overview of...
Is it considered bad etiquette to ask when to leave work?
A busy professional asked me this question: Why is it considered bad etiquette to ask when to leave work? I wouldn’t call it “bad etiquette”. But there are different ways to get the information that you need. One way, that is more professional and business goal oriented, is to simply ask about the policies and expectations. Ask about the...
SQL Server 2019 Transact-SQL optimization tips (Part 2)
SQL Server 2019 Transact-SQL optimization tips (Part 2) Try to avoid using the DISTINCT clause, whenever possible. The DISTINCT clause should only be used if you know that duplicate returned rows are a possibility. Because using the DISTINCT clause will result in some performance degradation, you should use this clause only when it is necessary. Consider using a MAXDOP option...
PART II: Deadlock and Starvation in DBMS
Deadlock Avoidance If a database is in a deadlock, it is always better to avoid the deadlock than to restart or abandon the database. The blocking prevention method is suitable for small databases, while the blocking prevention method is suitable for large databases. One way to avoid deadlocks is to use logic that is consistent with the application. In the...
4 Job Skills Needed to Rebound from COVID-19
As most of us are in lockdown at home, we wonder what a post-coronavirus-world might look like. It is extremely unlikely that things will just go back to exactly the way they were before. Our workplaces are likely to change, and with it, the skills companies will require. Here are 4 job skills that are likely to be in high...
SQL Server 2019 Transact-SQL optimization tips (Part 1)
SQL Server 2019 Transact-SQL optimization tips (Part 1) Use table variables instead of temporary tables. Table variables require less locking and logging resources than temporary tables, so table variables should be used whenever possible. Try to avoid using SQL Server cursors, whenever possible. SQL Server cursors can result in some performance degradation in comparison with select statements. Try to use...
AI-powered Search with spaCy — Part 15
In this part, we’ll continue with the discussion on how you might conduct an AI-powered search to discover phrases (certain sequence of tokens in a sentence) that satisfy a certain syntactic dependency pattern or several patterns at once. In the previous parts, you learned how this concept can be implemented when you are given a set of words describing a...
PART I: Deadlock and Starvation in DBMS
Deadlock Definition A deadlock is a condition in which two or more transactions wait indefinitely to unlock the lock. Deadlock is considered one of the most feared complications from DBMS, as no task is complete and is pending forever. Example: The T1 transaction blocks certain rows in the student table and has to update certain rows in the classification table....
Coronavirus: Is job hunting totally pointless during the coronavirus outbreak?
I go back and forth on this. There is no “logical” reason why anyone should stop interviewing and searching for a job during this coronavirus outbreak. We have the technology for individual and group virtual interviews. There are various positions and ways to conduct roles, responsibilities and performance evaluations remotely. We are in a global economy and everything that we...