Pro Members

Pro Members SQL Server Standard Members

PART III: Overview of Normalization

Fifth Normal Form (5NF) If a relation is in 4NF as well as does not contain any join dependency as well as joining is lossless then the relation is in 5th normal form. When the tables are broken into as many tables as possible in order to avoid redundancy then it can be said that 5NF is satisfied. 5th Normal…...

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

Confronting your manager at performance review

The yearly evaluations at my company are being held next week, should I confront my manager and tell him that I think he’s unprofessional and quite lazy at work or should I shove it in to avoid damaging my career and role at work? It may be prudent to remember who this evaluation is about. Your evaluation is all about…...

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 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