Solved: How do I fix ORA-01502: Index or partition of such index is in unusable state error

Problem Symptom I get the below error when inserting data in the table with 1 primary key and 3 foreign keys, 1st row below is the Primary key index and I do not know the Partition. Why is this happening & How to fix this issue? The detailed error message is as below: ORA-01502: Index …

How SQL Server Monitoring Benefits Whole Organization

Whether you sit in operations, development, the executive team, or IT management, the benefits of a robust monitoring solution can be drawn at every level. In this article, we cover the ways a monitoring solution can have a positive impact across your organization, regardless of your job role. Highlighting what those benefits looks like at …

How Database Technology Decisions Affect Customer Experience

Today’s customers expect a seamless, intelligent, and personalized experience that operates at the speed of the cloud and continuously available. To deliver an optimal customer experience, enable you to stay ahead of competitors. You need a distributed, intelligent, and responsive architecture which only possible when the right database is in place. Read this article to …

[Solved] How to Enable Mixed Mode Authentication and System Administrator (sa) Login

Take the following steps to enable mixed mode authentication on the SQL Server: Open SQL Server Management Studio Express. Choose Windows Authentication from the Authentication drop down list. Click Connect to open the Microsoft SQL Server Management Studio Express window. Right-click the SQL instance and choose Properties to open Server Properties window. Click Security on …

Will Database in the Cloud (DBaaS) meet your Business Growth Needs?

The demands on enterprises to improve time to market is driving firms of all sizes to move their databases to the cloud. Even companies used to rolling their own technology solutions are drawn to cloud databases. While DBaaS cloud offerings are gaining more traction as a solution for changing workloads and environments, that need to …

Keep SQL Server Estate Secure by Monitoring

With greater risks from attacks on your data systems like SQL Server becoming increasingly creative and sophisticated, high security demands from regulation, monitoring is becoming a key part of your data security, you need a monitoring solution that doesn’t just find known attacks, but spots general signs of improper access as well. Sometimes attacks are …