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 …
Tag Archives: Database
Optimizing PostgreSQL Performance in 5 Steps
PostgreSQL is one of the most common open-source database management systems available today. But how can you get the most from its scalable, high-performance, and extensive architecture? Read on this article to learn 5 strategies and approaches that can help you get the most from your PostgreSQL databases.
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 …
Continue reading “How SQL Server Monitoring Benefits Whole Organization”
5 Questions to ask when Designing High-Availability Databases
High-availability databases are critical for organizations that rely on 24/7 access, whether internal or customer-facing. Every second of downtime can translate to revenue loss, and worse. Read this article to learn 5 questions you should be asking when designing and developing a high-availability database.
7 Reasons to Use Managed Database Service
A few years ago, it was common to ask: “Should we really migrate to a managed database service?” Today, that’s like asking: “Do we really want a competitive advantage?” Read this white paper to learn 7 ways of switching to a managed database service can benefit your company.
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 …
Continue reading “How Database Technology Decisions Affect Customer Experience”
[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 …
Continue reading “Will Database in the Cloud (DBaaS) meet your Business Growth Needs?”
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 …
Continue reading “Keep SQL Server Estate Secure by Monitoring”
Everything You Need to Know About Database as a Service (DBaaS)
In this article, you’ll learn about different types of DBaaS services, discover the signs your company is ready for DBaaS, learn the advantages of DBaaS, and get a checklist of questions to ask while evaluating potential DBaaS vendors.