Pro Members

Pro Members SQL Server Standard Members

Troubleshooting security problems in SQL Server 2017

Troubleshooting security problems in SQL Server 2017 If you have security problems in SQL Server 2017, review this troubleshooting checklist to find potential solutions. 1. Dimension security is ignored by Power BI Desktop in SQL Server Analysis Services Multidimensional model. In this case, when you open the dimension, all the measures become visible, and even those that you have denied…...

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 4

Properties of a Hierarchical Schema The hierarchical schema of record types as well as Parent Child Relationship (PCR) types should have the subsequent properties: A record type, known as a root of the hierarchical schema, do not take part in any type of Parent Child Relationship (PCR) as a child record type. Each and every single record type excluding 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

Should I Stop Contacting a Customer Who Isn’t Responding to My Emails or Phone Calls?

This question came from a busy business owner. Should I stop contacting a customer who isn’t responding to my emails or phone calls? Two months ago, we sent our response to a bid. I’ve been trying to get feedback and follow up with the customer, but they have gone silent. I’ve tried reaching them by email and phone. How long…...

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