Explore Databases on Experts Exchange

Expert Solutions for Your Databases Problems

Databases

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes tha...

Read more
  • 62K Content
  • 14K Contributors

Expert Spotlight
M A
Service Manager

Most Valuable Expert2017 and 2020.
O365, Exchange Server,Windows Server, Active Directory, Virtualization, Teams and Email Migration Expert.

Article

How to recover mailboxes from corrupted Exchange database- Stellar Repair for Exchange?

byM A
1
How to recover mailboxes from corrupted Exchange database- Stellar Repair for Exchange.
Article

Making your Database More User Friendly

I found that a simple "Welcome" screen/form added to a database makes it both more friendly and easier to use. Here is how I added one to a Microsoft Access database. Please see the important note at the bottom of this article regarding compatibility on operating systems other than Window
Article

Snowflake Cloud Data Warehouse as a Service: Unlocking the Power of Data

In today's data-driven world, organizations are constantly striving to extract actionable insights from their vast amounts of data. To meet this demand, cloud-based data warehousing has emerged as a game-changer.
Article

Troubleshooting MySQL Connection Attempts

Having trouble connecting to MySQL? Getting the dreaded "Access denied for user ... (using password: YES)" message? This article will help you understand the authentication steps and where to look in your troubleshooting efforts.
Article

Setting Up Oracle 23c Using Vagrant-Projects

In this article we will see to setup Oracle 23c free developer version using Vagrant project and the new features include on this version.
Article

Identity and Access Management

In this article we will see how Identity and Access Management plays a key role any enterprise-level database management system.
Article

New SQL features on Oracle 21c Database

In this article we will see what new features are been release by Oracle for making SQL much efficient .
Article

JSON In Oracle Database

In this article, we'll take a closer look at JSON in Oracle SQL and how you can use it in your applications.
Article

Ways To Load Large Tables In Oracle

In this article, we will see the options and faster ways to load large tables in Oracle database.
Article

Exchange Server Database Reseeding

byM A
2
The following article will helps you reseed the failed database copy
Article

Design a multi-region web application solution with a private database in Microsoft Azure

Today, we will look into a multi-region solution for a web application to provide redundancy. The database used by the web application will be available via a private endpoint and not accessible from the internet. This will give us a very robust, secure, and available web solution.
Article

Table data compression, a multi-valuable database feature.

Data compression is a feature offered by many modern databases like Db2, Oracle, MySQL, MariaDB and SQLServer. However, many companies do not use this feature in their database systems. Either they lack the knowledge of its existence in the application/systems design phase or due to budget issues.
Article

What to use? ORM vs Stored Procedures

1
Today we will look at a very common debate while developing the data access layer. This is to decide if we want to use stored procedures and keep our logic in the database or do we want to use an ORM like Entity Framework and keep all logic in our middle tier C# code and use the database as a store.
Article

Some database design ideas

I am not a database expert nor am I conversant with database design, but I have had a couple of run-ins with databases that are either badly designed or use a platform that doesn’t meet the needs of the end-user. I would like to think this is a "lessons-learned" synopsis.
Article

Do we always use microservices?

Today we will look at a very common question that comes up in the minds of all application designers and developers. This question is when to use the standard N-Tier architecture as opposed to the much-hyped microservices architecture for building our applications.
Article

SSMS MSSql Change the column length of a table with a primary key and retain the IDs

I was surprised on searching desperately not to find a clear answer for what would appear outwardly to be a fairly simple operation in a Microsoft SQL database server. Alter the column width of a text field from 48 to 60 and retain the primary key. So here's one for anyone facing similar issue.
Article
Configure SQL Server Log Shipping

Some Useful Tips to Configure SQL Server Log Shipping

With the introduction of AlwaysOn Availability Group (AAG) in SQL Server 2012, log shipping seems to be less widely used than before. AlwaysOn Availability Group provides real-time log shipping as transactions are committed/applied to the primary database server.
Article

Solving Outlook Address Book Download Error

byM A
This article will explain how to deal the following error in Outlook: Exchange 2013 Troubleshooting: Error 0x8004010F - The operation failed. An object cannot be found
Article

Creating a customized Access ribbon and Network Database

I wrote this article because I was unable to find an article on this here on EE. Read on for step-by-step instructions on how to create a custom command ribbon in your office applications that not only make them look more professional but also protects against the ID10T error.
Article

Union All Handling in SQL Server

The UNION ALL (or UNION) operator is used to combine different result sets. This article focuses on handling the UNION ALL operator in a better way.

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more in Databases