Shiv IyerProshiviyer.hashnode.dev·Mar 9, 2024Guide to Importing Data from Spreadsheets into PostgreSQL ServerLoading data from a spreadsheet into a PostgreSQL server can be accomplished through several methods, depending on the format of your spreadsheet and your working environment. Here's a guide to help you with this task, assuming your spreadsheet is in...Discuss·37 readsPostgreSQL
ReadySetreadyset.hashnode.dev·Jan 26, 2024Stateful Property Testing in RustMost developers have written unit tests: you feed your code some inputs and verify the outputs. Property tests automate this process. Instead of manually creating inputs, your test generates them for you and validates the input/output pairs against a...DiscussRust
Matej Zamecnikdatalisk.hashnode.dev·Jan 23, 2024Oracle Database Redo Logs StoryFrom time to time, I am called to check DB performance for various clients, and quite often, I observe a similar pattern: - The DB can’t handle higher traffic.- There is currently no DBA, and maybe never was.- It has been an issue from the start, b...DiscussOracle
Travis Horntravishorn.com·Dec 20, 2023Getting Started with MariaDBMariaDB is a great open-source relational database management system. This article will walk you through the process of installing and configuring MariaDB, creating database users, granting appropriate privileges, and enabling remote connections. Wit...Discuss·117 readsMariaDB
Ian Carsoniancarson.hashnode.dev·Dec 13, 2023Database Roadmap.The database is a wide field yet very important. Every application and system uses some sort of database. Below are concepts and topics that one should be familiar with. Data Modelling- This concept refers to how data is curated and handled and the ...Discussdatabase design
Richmond Damaghateryx.hashnode.dev·Sep 12, 2023Fundamental Snippet: Database Backup and RecoveryDatabase backups are crucial for safeguarding data, ensuring business continuity, and meeting regulatory requirements. They provide a safety net to recover from various types of data loss scenarios, helping organizations maintain data integrity and o...Discussdata-engineering
Data Senseisihan.hashnode.dev·Jun 16, 2023SQL: Scalar Subquery with Case When... Else...Lets first create a table: Create database blog_port; use blog_portal; -- Create the Employee table CREATE TABLE Employee ( employee_id INT, team_id INT, PRIMARY KEY (employee_id) ); -- Insert the data into the Employee table INSERT INTO ...Discuss·58 readsSQL
Ishaan Adarshreqi3m.hashnode.dev·May 11, 2023Day 3 - ImprovementToday was a better day than yesterday, as I was able to resolve an issue that had been troubling me. I had been trying to create a sample extension using SQL, but had been stuck on the makefile part. I spent an hour browsing through Stack Exchange an...DiscussPostgreSQL
Sneh Bhattmytwocents.hashnode.dev·Jan 25, 2023Azure SQL Database query ideas - finding queries currently running on the DBThis post is part of the blog series created primarily for database engineers, with the hope that it might help you get a head start on your development tasks. With that being said, let us dive in... Finding queries currently running on the database...Discuss·55 readsAzure SQL Database Query IdeasAzure SQL Database
Yatheesh Nagellayatheeshnagellablog.hashnode.dev·Jan 6, 2023Database migrationsA database migration is the process of transferring data from one database to another, or from one version of a database to another. This can involve moving the data to a new server, changing the structure of the database, or updating the database so...Discuss·26 readsdatabase administration