Pro Members

Pro Members SQL Server Standard Members

Tips for using Snapshot Replication in SQL Server 2019 (Part 1)

Tips for using Snapshot Replication in SQL Server 2019 (Part 1) Snapshot replication is a simplest type of replication. With this kind of replication, all replicated data (replica) will be copied from the Publisher database to Subscriber/Subscribers database on a periodic basis. Snapshot replication is best used as a method for replicating data that modified infrequently and when the size…...

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 11

In this part, we’ll look at how you might intelligently reduce the sentence when preparing a phrase for a search from it. In particular, you’ll see how to reduce the sentences containing an adverbial clause modifier or an open clausal complement. Say, you have the following sentence as an input: ‘I talked to him to secure the account.’ In this…...

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

PART II: Overview of Normalization

First Normal Form (1NF) – A relation is 1NF if it contains an atomic value. It indicates that an attribute of a table cannot contain multiple values. It can only contain one attribute with a single value. The first normal form does not allow the multivalued attribute, the compound attribute as well as its combinations. Example: The EMPLOYEE relationship 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
Pro Members SQL Server Standard Members

Can my manager force me to reword my accomplishments on LinkedIn

My boss wants me to reword my accomplishments on my LinkedIn profile to share credit with the rest of the team, should I? Without knowing the workplace background, my first reaction is that your LinkedIn profile is your individual professional page.  As long as it’s not a company LinkedIn page, you have 100% control over what you elect to publish…...

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 views in SQL Server 2019

Tips for using views in SQL Server 2019 Use views instead of heavy-duty queries to reduce network traffic. Using views instead of heavy-duty queries can reduce network traffic, because your clients will send to server only a simple query, such as SELECT * FROM VIEW_NAME (perhaps with some parameters), instead of large heavy-duty queries text. Consider using stored procedures instead…...

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

PART I: Overview of Normalization

DBMS Anomalies There are three types of anomalies that occur when the database is not standardized. These are anomalies when inserting, updating as well as deleting. Let’s take an example to understand this. Example: Suppose a manufacturing company stores the employee details in a table called employees with four attributes: emp_id to save the employee ID, emp_name to save 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

How Do Product Managers Break Down Requirements into User Stories?

How do Product managers break down requirements into user stories? A good product manager doesn’t “break down” requirements into user stories, they start with good user stories and work from there. The whole point of using user stories is that they are how you communicate “requirements” to your development teams. If you’ve already got a list of “requirements” then you’re…...

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 stored procedures in SQL Server 2019

Tips for using stored procedures in SQL Server 2019 Try to avoid using temporary tables and DDL (Data Definition Language) statements inside your stored procedure. Using temporary tables or DDL statements inside stored procedure reduces the chance to reuse the execution plan. Call stored procedure using its fully qualified name. The complete name of an object consists of four identifiers:…...

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 10

In this tenth part in the series, we are continuing to discuss how you might take advantage of linguistic features available in spaCy. In particular, we’ll look at how you might obtain necessary information related to the task of meaning extraction, when it comes to understanding of user input coming in the form of request utterances. From the previous parts,…...

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

Concept of Relational Database Model – Part 2

Join Operation A join operation combines linked tuples of different relationships if and only if a particular join condition is met. It is noted ?. For example, if there are two tables: EMPLOYEE and SALARY; Evaluation: ∏EMP_NAME, SALARY (EMPLOYEES ?. For example, if there are two tables EMPLOYEE and SALARY; Evaluation: (EMPLOYEE ?. For example, if there is two tables…...

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