Mastering data storage is pivotal, no matter the tool you use. The most popular options when it comes to database server tools are MS SQL, Azure SQL Database, IBM DB2, PostgreSQL, and AWS Cloud. All these offer robust solutions for storing, managing, and retrieving data. Here’s a comprehensive guide on how to store data in…
Oracle Database is a widely-used relational database management system. Understanding the database version is crucial for users and administrators, as it helps understand functionality, assess upgrades, and ensure compatibility. This article explores 3 most used methods to determine the version of Oracle Database. Using SQL*Plus or SQLcl Firstly, we have to open our terminal or…
A size limit of only 2GB and maximum support for 255 concurrent users are enough reasons for anyone to import their Access database to an SQL server. Once you upgrade to an SQL server, you will get support for larger amounts of data, more concurrent users, and an overall better capacity. And the good news…
DB2 SQL Error SQLCODE 407 SQLSTATE 23502 means a column object specified as NOT NULL is receiving a NULL value. It usually occurs when trying to perform an INSERT, UPDATE, or SET operation on an object. However, the ALTER statement can sometimes trigger the same issue. What is SQLCODE =- 407 in DB2? The SQLCODE…
Two SQL Server instances may be running on the same server or on different ones in SQL Server database mirroring, a disaster recovery and high availability solution. One SQL Server instance serves as the principal, which is the primary instance, and the other is the mirror, which is the mirrored instance. A third SQL Server…
Database encryption in SQL Server refers to encrypting data stored in a SQL Server database to protect it from unauthorized access. Encryption gives an extra layer of assurance by changing over information into an unreadable organize, rendering it futile to unauthorized people even if they pick up and get to the database. In this article, we’ll dig into…
The role of a solutions architect – data analytics – core is to connect business problems with technical solutions. They sit in the middle of business and people and technology, working as a bridge to connect business solutions with the intricateness of data analytics. What makes them a kind of trusted adviser is their expertise…
DB2 SQL Error SQLCODE 803 SQLSTATE 23505 means that an Insert or Update operation is violating a uniqueness constraint that is already in place. It occurs either after performing Load with the identity_override modifier or when the table gets altered to add an Identity clause with existing data. What Does SQLCODE = – 803 Mean?…
I was shocked to find this article on ReadWrite: The Truth About DevOps: IT Isn’t Dead; It’s not even Dying. Wait a second, do people really think this? Truth is I have heard whispers of this before. I was at a meetup recently where the speaker claimed “With more automation, you can eliminate ops. You can…
Many of you know I publish a newsletter monthly. One thing I love about it is that after almost a decade of writing it regularly, the list has grown considerably. And I’m always surprised at how many former colleagues are actually reading it. So that is a really gratifying thing. Thanks to those who are,…