SQL Server

Pro Members SQL Server Standard Members

Troubleshooting SQL Server 2017 Indexes

Troubleshooting SQL Server 2017 Indexes If you have problems with SQL Server 2017 indexes, review this troubleshooting checklist to find potential solutions. 1. You can get the error 602. This error indicates that SQL Server could not find an entry for index in a database. This error may occur if a stored procedure references a dropped table, or metadata 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

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

Methods for Reviewing Database Management System (DBMS) Recovery Reviewing a Database Management System (DBMS) recovery should ensure that employees with specific responsibilities perform their tasks in accordance with policies as well as operating procedures. There are several useful audit techniques for Database Management System (DBMS) recovery. There are two ways to run the system again. First, any transaction that occurred…...

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 MDS in SQL Server 2017

Troubleshooting problems with MDS in SQL Server 2017 If you have problems with SQL Server 2017 Master Data Services (MDS), review this troubleshooting checklist to find potential solutions. 1. When you expand the Entities folder on the Manage Groups page in MDS, you may notice that it takes a long time to display all the entities under the folder. 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

Intelligent Text Generation with spaCy Part2

Word sequence patterns based on linguistic features and introduced in the previous article in this series are not the only means of intelligent text processing and text generation. This article focuses on another common technique based on using syntactic dependency trees. This is also one of those techniques that you can use to teach your conversational application to generate meaningful…...

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 2

How should timestamps be used? The timestamp order protocol ensures that two conflicting read / write operations are executed in the corresponding timestamp order. It is an alternative solution to the use of locks. For Reading operations: If TS (T) is < W timestamp (P), transaction T attempts to read a value of P data that has already been overwritten......

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 Should I Do If My Boss Asks Me to Cover My Friend’s Shift so He Can Fire Her?

This question came from a business professional. My boss asked me to cover my coworker’s shift because he is about to fire her. She and I are good friends outside of work. Should I warn her? I can see that this is a very difficult decision for you. You can probably see it both ways: Being loyal to the company…...

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

Troubleshooting SQL Server 2017 Columnstore Indexes If you have problems with SQL Server 2017 columnstore indexes, review this troubleshooting checklist to find potential solutions. 1. You can get the error 980 when you try to load SQL Server 2017 database. This is the error message text: “SQL Server cannot load database ‘%.*ls’ because it contains a columnstore index.” This error…...

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 1

Transaction – Definition A transaction is a set of modifications that must all be done together. This is a program unit whose execution may change the contents of a database or not. The transaction is implemented as a single entity. If the database was in a consistent state before a transaction, it must be in a consistent state even after…...

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

Database Development Life Cycle, Normalization, Errors and Security of Database – Part 6

Database security Database security cannot be considered an isolated problem because it is also affected by other components of a computer system. The security requirements of a system are determined by means of a security policy, which is then enforced by various security mechanisms. For databases, security requirements can be divided into the following categories: Identification, authentication – Normally, each…...

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

3 Things Should You Never Do on a Job Interview

This question came from a business professional. What 3 things should you never do on a job interview? Top 3 things you should never do Although there are lots of things to keep in mind, some things to consider are: Don’t be late. Plan to be at least 1 hour early to avoid any traffic or travel issues. Once there,…...

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