Tag: Databases

How to Install and Configure Apache Cassandra on Linux Server

Posted on Raphael Gab-Momoh By Raphael Gab-Momoh No Comments on How to Install and Configure Apache Cassandra on Linux Server
How to Install and Configure Apache Cassandra on Linux Server

Apache Cassandra is an open-source NoSQL database engine with fault tolerance, linear scalability, and consistency across multiple nodes. Apache Cassandra’s distributed architecture allows it to manage massive amounts of data with dynamo-style replication. When replicas are kept on several nodes in a cluster, you’ll achieve high availability and zero points of failure. Please see how…

Read More “How to Install and Configure Apache Cassandra on Linux Server” »

Linux

How to manually check and update SQL Server Management Studio

Posted on IT Expert By IT Expert 6 Comments on How to manually check and update SQL Server Management Studio
How to manually check and update SQL Server Management Studio

SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database. SSMS provides tools to configure, monitor, and administer instances of SQL Server and databases. Here are some guides on how to download and install Microsoft SQL Server 2019 Express Edition and Microsoft Management Studio…

Read More “How to manually check and update SQL Server Management Studio” »

Oracle/MSSQL/MySQL

How to delete ADFS Windows Internal Database without access credentials

Posted on IT Expert By IT Expert No Comments on How to delete ADFS Windows Internal Database without access credentials
How to delete ADFS Windows Internal Database without access credentials

Windows Internal Database (codenamed WYukon, sometimes referred to as SQL Server Embedded Edition) is a varient of Microsoft SQL Server Express 2005, and is included with Windows Server 2008 and Windows Server 2008 R2. It is also included in Windows Sharepoint 3.0 and Windows Server Update Services (WSUS) 3.0, where a full version of Microsoft SQL Server may…

Read More “How to delete ADFS Windows Internal Database without access credentials” »

Oracle/MSSQL/MySQL

Differences between Directory Services and Databases

Posted on IT Expert By IT Expert No Comments on Differences between Directory Services and Databases
Differences between Directory Services and Databases

A Directory Service and a database fundamentally work differently. For this reason, they tend to be used for different types of applications. Directory Services are hierarchical based, allowing security to be applied to an object. In this article, we shall discuss the differences between directory services and databases. Please see how to install Gradle on Ubuntu, how…

Read More “Differences between Directory Services and Databases” »

Windows

Editions of MSSQL Server: What are the differences between various Editions of Microsoft SQL Server

Posted on IT Expert By IT Expert No Comments on Editions of MSSQL Server: What are the differences between various Editions of Microsoft SQL Server
Editions of MSSQL Server: What are the differences between various Editions of Microsoft SQL Server

When asked to run projects that utilize MSSQL as the database engine with the least cost, then you should be able to select from the various Editions of MSSQL that serves your need. This decision is based on your environment and what the project (task entails). See the following explanations below for the right Edition…

Read More “Editions of MSSQL Server: What are the differences between various Editions of Microsoft SQL Server” »

Oracle/MSSQL/MySQL

How to use a dedicated MsSQL Db for Pleasant Password

Posted on IT Expert By IT Expert No Comments on How to use a dedicated MsSQL Db for Pleasant Password
How to use a dedicated MsSQL Db for Pleasant Password

In this article, we will discuss How to use a dedicated MsSQL Db for Pleasant Password. Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications. Pleasant Password Server…

Read More “How to use a dedicated MsSQL Db for Pleasant Password” »

Oracle/MSSQL/MySQL

How to export passwords from KeePass Database to Pleasant Password Server

Posted on IT Expert By IT Expert No Comments on How to export passwords from KeePass Database to Pleasant Password Server
How to export passwords from KeePass Database to Pleasant Password Server

Since we have a compatible (existing password system which Pleasant Password Server Supports), migrating or importing Passwords from KeePass Database is relatively easy. Please see “What to note before assigning Multiple IPs’ to an Instance“, and how to perform Microsoft Account Password Reset via Web and Windows. Password Exports Here are the supported formats available…

Read More “How to export passwords from KeePass Database to Pleasant Password Server” »

Password Manager

How to access MySQL Server from command Prompt

Posted on IT Expert By IT Expert No Comments on How to access MySQL Server from command Prompt
How to access MySQL Server from command Prompt

How to access MySQL Server is a crucial skill for streamlined database management. This guide enables efficient navigation, interaction, and execution of SQL commands, ensuring smooth data operations via the command line. However, Explore the art of command prompt access to unveil the full potential of your MySQL Server with this guide on How to…

Read More “How to access MySQL Server from command Prompt” »

Oracle/MSSQL/MySQL