Standard Members

Pro Members SQL Server Standard Members

I Have an Employee That Spends All Day on His Phone

This question came from a busy business owner. I have an employee that spends all day on his phone, but he always gets his work done well. Other members of the team are annoyed by him. Do I fire him? I am sure that “spends all day on his phone” is an exaggeration, but I get your point. I have…...

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

Troubleshooting Upgrading to SQL Server 2017

Troubleshooting Upgrading to SQL Server 2017 Should you have problems with upgrading to SQL Server 2017, review this troubleshooting checklist to find potential solutions. 1. Check the hardware requirements. To upgrade to SQL Server 2017, you should have the following hardware: – Intel or compatible platform with processor speed: 1.4 GHz minimum for a 64-bit x64 2.0 GHz or faster…...

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

Concepts of Network Model and Hierarchical Data Structure – Part 2

Representation of M : N Relationships by Sets The set type represents a 1 : N (one : many) relationship among two (2) types of records, which indicates that a record of the member record type can be displayed in a single specified set instance. The DATABASE MANAGEMENT SYSTEM (DBMS) automatically applies this restriction in the network model. To represent…...

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 You Handle a Disappointing Raise?

This question came from a busy business owner. How do you handle a disappointing raise at your job even though it was a productive year, all while your boss’s excuse was there were too many good employees? The best way to handle disappointment is to be prepared with the following knowledge: Knowledge of your skills, talent and expertise value in…...

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

Troubleshooting problems with SQL Server 2017 alerts

Troubleshooting problems with SQL Server 2017 alerts If you have problems with SQL Server 2017 alerts, review this troubleshooting checklist to find potential solutions. 1. Check that account, the SQL Server Agent service runs under is a member of the Domain Users group. The LocalSystem account does not have network access rights, so if your jobs require resources across 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

Concepts of Network Model and Hierarchical Data Structure – Part 1

Introduction This article delivers an overview of the network data model as well as the hierarchical data model. The network model as well as the original language were presented in the report of the CONFERENCE/COMMITTEE ON DATA SYSTEMS LANGUAGES (CODASYL) database work group of 1971. That is why it is sometimes called the DBTG model. The revised reports of 1978…...

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 You Confront a Boss Who Keeps Asking You for More Than Your Responsibilities?

This question came from a busy business owner. How do you confront a boss who keeps asking you for more than your responsibilities? There are several things you can do to take charge over your own career and professional development path. First you need to fully understand your job grade, role and responsibilities for that particular role and the role…...

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

Troubleshooting problems with views in SQL Server 2017

Troubleshooting problems with views in SQL Server 2017 If you have problems with views in SQL Server 2017, review this troubleshooting checklist to find potential solutions. 1. You can get the error 1086 when you use FOR XML clause in a view. This error indicates that the FOR XML clause is invalid in views when they contain a set operator…....

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

Data Warehousing with ORDBMS, Parallel and Distributed System – Part 7

Functions of Data Mining Data mining classifies facts or suggests conclusions based on the selection of data to discover patterns or anomalies. Data mining have five key functions: Classification: It defines the characteristics that describe a particular group for example, students who have failed in a particular subject. Clustering – It identifies sets of items that share a specific feature…....

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 You Deal with a Toxic Coworker?

This question came from a busy business owner. How do you deal with a toxic coworker? If someone at the office is making you feel consistently stressed or unmotivated, you might be dealing with a toxic coworker. Most importantly don’t take it personally and keep your interactions always profession. Don’t let this toxic behavior damage your professional, emotional and physical…...

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