Jamey Bartondbajamey.hashnode.dev·an hour agoDatabase Migration Software: Best PracticesIn general terms, database migration is transferring data from its source environment to a new destination. This could involve thorough planning, creating backups, moving data and database objects across different servers (such as Oracle, MySQL, SQL ...Discussdatabase
OBULIPURUSOTHAMAN Kobulipurusothaman.hashnode.dev·13 hours agoStructured Query Language(sql)STRUCTURED QUERY LANGUAGE(SQL) Table of Contents 1 Introduction to SQL 1.1 Data Definition Language (DDL) 1.2 Data Manipulation Language (DML) 2 Introduction to SQL Server 2.1 SQL Server Management Studio 2.1.1 Create a new Database 2.1.2 Queries 3 ...Discuss·18 likesSQL
Jamey Bartondbajamey.hashnode.dev·Apr 15, 2024TOP 10 IDEs for SQL Database Management & Administration [2024]Modern organizations heavily rely on databases, with SQL databases being the predominant option. Daily workflows involve numerous database-related tasks, which database specialists must handle using specialized tools. Typically, it requires not just ...DiscussSQL
Rendy Anantarendyananta.my.id·Apr 12, 2024Installing TimescaleDB PostgreSQL Extension On Apple SiliconTimescale DB is a PostgreSQL extension that suitable for the time-series, event storing and data-aggregation workloads. This enable the PostgresSQL weaknesses on heavy query data read like an aggregation such as sum, avg, min, and max. Time-series da...Discussdatabase
Awaisawaisdev.dev·Apr 12, 2024A Quickstart Guide to the Prisma ORMIntroduction This post explores Prisma, an ORM, which stands for Object Relational Mapper. If you're not familiar with ORMs the idea is you can communicate with your database using JavaScript objects and function calls rather than having to write raw...Discuss·1 like·311 readsDatabases
Jamey Bartondbajamey.hashnode.dev·Apr 12, 2024How to Remove Duplicate Rows in MySQLCan it happen that the data stored in databases include identical records? Yes, it happens frequently. However, having duplicate records in databases is a scenario that should be avoided. Duplicates pose an ongoing risk to the data consistency and th...DiscussMySQL
Jamey Bartondbajamey.hashnode.dev·Apr 10, 2024How to Use the CREATE SEQUENCE Statement in OracleIn this article, we are going to talk about the Oracle CREATE SEQUENCE statement, the primary purpose of which is to offer a reliable means of generating unique and sequential numeric values, often utilized for primary key fields within database tabl...DiscussOracle
Ashwin Sharma Pashwinsharmap.hashnode.dev·Apr 10, 2024SAP Basis snippets #4Sybase DB start/stop commands First switch to the syb<sid> user su - syb<sid> Logon to the isql interface isql -U <username> -P <password -S <SID> To stop the sybase db, use the below command shutdown Execute ‘go’ after ‘shutdown’ command, which c...DiscussSAP Basis SnippetsSAP
Jamey Bartondbajamey.hashnode.dev·Apr 9, 2024How to Show Indexes in MySQL Tables & DatabaseManaging data from small or large databases is a daily task of database administrators and developers. Frequently, they need to search for specific data processing thousands of rows. This can be complicated with large databases and may lead to potent...DiscussMySQL
Ashwin Sharma Pashwinsharmap.hashnode.dev·Apr 8, 2024SAP Basis snippets #3Start/Stop commands for MaxDB First switch to the sqd<sid> user su - sqd<sid> Then logon to database manager command line interface dbmcli -d <SID> -u <username>,<password> Once logged in to dbmcli using your details execute the below commands Stop...DiscussSAP Basis Snippetsmaxdb