Standard Members

Pro Members SQL Server Standard Members

Prior to DBMS, Database Approach, Data Model — Part 2

Necessary Concepts of Database What is a Database? A database is a set of related data used to support the events of a given company. A database can be considered as a data warehouse once defined as well as accessible by several users. Database Properties The database has the subsequent features: It is an illustration of few aspect of 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.
Log In Register
Pro Members SQL Server Standard Members

Three Things Missing From Your Job Search

This question came from a job seeker. I was recently fired from a company. What things do I need for a job search? Everyone realizes the need for a resume and they may even remember to update their LinkedIn profiles and contacts. They may even meet with recruiters for assistance. But rarely to people take all the necessary steps 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

Some tips for using SQL Server 2019 triggers

Some tips for using SQL Server 2019 triggers Try to minimize the number of rows affected in a trigger. The more number of rows affected in a trigger, the more time a trigger takes to run. So, try to reduce the number of rows affected in a trigger. Consider disabling trigger’s recursion. Triggers are said to be recursive when a…...

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

AI-powered Search with spaCy – Part 5

So far, you have seen examples that rely on linguistic features associated with individual words in a sentence, when extracting the most descriptive phrase from that sentence. Very often however, you might need to extract the entire chunks to work with. For example, in the following sentence: “How to use Oracle Database 19c from a Python script.”, you might want…...

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

What’s the Simplest Way to Do Market Research?

This question came from a busy business owner. What’s the simplest way to do market research? Hello, I want to sell certain electronic devices and I just want know the basics steps if I do market research before launching them. Appreciate if someone could share the best practices on how to get started doing market research. We will guide 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

Tips for using constraints in SQL Server 2019

Tips for using constraints in SQL Server 2019 Avoid using CHECK_CONSTRAINTS hint with bulk copy program. Using this hint can significantly degrade performance of the bulk copy operation, because for each row loaded the CHECK constraints defined on the destination table will be executed. Without the CHECK_CONSTRAINTS hint, any CHECK constraints will be ignored. Consider using the NOT FOR 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.
Log In Register
Pro Members SQL Server Standard Members

Prior to DBMS, Database Approach, Data Model — Part 6

Organisation Based on Number of Users A DATABASE MANAGEMENT SYSTEM (DBMS) can be organisation based on the user number it can support. It can be a single-user database system, that assists only one user at a time, or a multi-user database system, that can assists several users simultaneously. Organisation Based on Database Distribution There are four key distribution systems for…...

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

After Firing Me, My Old Boss Contacted Me Asking Work-Related Questions.

This question came from a job seeker. I was recently fired from a company. My old boss just contacted me asking work-related questions. Should I respond? Absolutely. But it’s the way you respond that is critical. Answer them as a consultant, only. You want to stay professional at all time Since you were fired, you should not be speaking 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

Tips for using backup and restore in SQL Server 2019

Tips for using backup and restore in SQL Server 2019 Use separate storage for the database backups. Ensure that you place your database backups on a separate physical location or device from the database files. You can use backup/restore of memory-optimized files on Azure Storage. In SQL Server 2019 memory-optimized filegroup files can be stored on Azure Storage. Backup/Restore of…...

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

AI-powered Search with spaCy — Part 4

In the previous articles in this series, you learned how interrogative sentences of the most common types can be parsed, allowing you to extract the most descriptive words from a sentence to be used then for a search for a relevant answer. In other words, you learned to implement the ability to understand what the user is asking about or…...

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