Pro Members

Pro Members SQL Server Standard Members

Troubleshooting SQL Server 2017 problems on Linux

Troubleshooting SQL Server 2017 problems on Linux Starting from SQL Server 2017, Microsoft supports the Linux operating systems to install SQL Server. If you have problems when you work with SQL Server 2017 on Linux, review this troubleshooting checklist to find potential solutions. 1. You may notice that the daylight saving time (DST) changes are not determined by SQL Server…...

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

Answering Questions Programmatically with Wikipedia API and spaCy

In the modern world, artificial Intelligence (AI) is almost everywhere. We have long been accustomed to the fact that a robot picks up the phone when you call a bank, and ordering a pizza can be done without human participation. In this article, you’ll see how to create programming code that can intelligently answer user input. For example, it might…...

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 3

Currency Indicators The network’s Data Manipulation Language (DML) restores as well as updates by moving or searching database records. Therefore, it is important to keep an eye on the search. Currency indicators allow an individual to keep track of the records that an individual has accessed last as well as find set occurrences in the DATABASE MANAGEMENT SYSTEM (DBMS). They…...

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

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