Pro Members

Pro Members SQL Server Standard Members

Troubleshooting problems with DBCC commands in SQL Server 2017

Troubleshooting problems with DBCC commands in SQL Server 2017 If you have problems with SQL Server 2017 DBCC commands, review this troubleshooting checklist to find potential solutions. 1. The error 2509 occurs when you run DBCC CHECKCONSTRAINTS command. This is the error message text: “DBCC CHECKCONSTRAINTS failed due to an internal query error”. To work around this problem, you can…...

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 2

Architecture of Distributed Database A distributed database system permits systems to access data from local as well as remote databases. In a homogeneous distributed database system, every single database is an Oracle database. In a heterogeneous distributed database system, at least a single databases is not an Oracle database. Distributed databases make use of a client / server architecture to…...

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

What To Do of Someone Lied On Their Resume

Hello, this is Laura Lee Rose – author of the business and time management books TimePeace: Making peace with time – The Book of Answers: 105 Career Critical Situations – and I am a business and efficiency coach that specializes in time management, project management, and work-life balance strategies. This question came from a business professional. I have an employee…...

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 Analysis Services problems (Part 2)

Troubleshooting SQL Server 2017 Analysis Services problems (Part 2) If you have problems with SQL Server 2017 Analysis Services (SSAS 2017), review this troubleshooting checklist to find potential solutions. 1. If you cannot connect to SQL Server 2017 Analysis Services, ensure that SQL Server Browser service is started and was running under the account that has local administrator rights. 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

Using spaCy to Find Sequences of Words Based on Pattern Rules – Part 1

spaCy’s rule-based matcher engines are much powerful than just using regular expressions, since those engines allow you to find not only particular words in a submitted text, but also discover their relationships. spaCy provides you with the ability to match sequences of tokens based on both pattern rules and documents. In the first case, you use spaCy’s Matcher object. For…...

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 1

Object Relational Database Management System (ORDBMS) Relational Database Management System (DBMS) is currently the leading database technology. Object Oriented Database Management System (OODBMS) has also become the preferred system for financial as well as telecommunications systems. Although the Object Oriented Database Management System (OODBMS) market remains the same. The Object Oriented Database Management System (OODBMS) continues to find new uses,…...

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

What To Do If Your Boss Wants to Decrease Your Salary

My boss wants to decrease my salary because the others found out and requested an increase (25–30%) to my level and she cannot give them all the increase. What should I do? At the minimum, you need to review your situation objectively: Your boss knew what her employees were earning when she hired you and agreed to your salary. Your…...

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 Analysis Services problems (Part 1)

Troubleshooting SQL Server 2017 Analysis Services problems (Part 1) If you have problems with SQL Server 2017 Analysis Services (SSAS 2017), review this troubleshooting checklist to find potential solutions. 1. The Analysis Services service may stop unexpectedly and Event ID 22 is logged in the Application log when you process an object in a database. This problem occurs when Analysis…...

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

Transaction Using ACID Properties Timestamp Protocol and Security Procedures – Part 6

Object Oriented Database (OODB) The object oriented database (OODB) delivers all the functions related with the object oriented paradigm. In this way, we can organize objects, create classes, structure an inheritance hierarchy, as well as call methods from other classes. In addition, the functions associated with the standard database systems are provided. On the other hand, object oriented database systems…...

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 Accidentally Saw My Coworker’s Contract and Salary

I accidentally saw my coworker’s contract and salary, and now I feel I’m getting less than I deserve. Should I tell my boss? This is why people are discouraged from discussing salary amongst your teammates. Not many people feel they are getting paid what they are actually worth. The people that have been working and loyal for many years, will…...

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