Livingstone Del Montelivimonte.hashnode.dev·16 minutes agoSecure Database Connection on AWS using RDS, SSM and EC2When operating in a cloud environment, there are various ways to establish a connection with a database. Ensuring security is essential, which is why we often opt for using an EC2 instance as a bastion host in a public subnet. This allows authenticat...DiscussAWS
Constantin Lungudatawise.dev·4 hours agoDELETE + INSERT vs MERGE in BigQueryHow do you merge changes from staging tables into target tables in BigQuery? I've previously covered swapping out partitions using bq command and using constant false predicate "MERGE on FALSE", but I've learned that you can now DELETE entire parti...DiscussPractical BigQuerybigquery
Shiv Iyerfor#AzureSQL #SQLServer #Azure #SQLazuresql.hashnode.dev·7 hours agoHow to Minimize LCK_M_I[xx] Wait Events in Azure SQL EasilyLCK_M_I[xx] waits in Azure SQL Database indicate that a session is waiting on a lock of some type (indicated by [xx]) to be released before it can proceed. These waits are often symptoms of concurrency issues where multiple transactions are trying to...DiscussSQL
Viraj Sabhayavirajsabhaya23.hashnode.dev·8 hours agoDatabase Developer Interview Questions1. What is the difference between PL SQL and SQL? ComparisonPL/SQLSQL ExecutionSingle command at a timeBlock of code ApplicationSource of data to be displayedApplication created using the data from SQL Structures includeDDL and DML based que...DiscussSQL
Akash Rajvanshihacstac.hashnode.dev·9 hours ago🚀 Day 38/100 🚀In the lab "Modernize .NET Applications – Infrastructure as Code and CI/CD," the infrastructure code is ready and working. However, I am currently experiencing some issues when attempting to run the sample .NET application. I am still encountering th...Discuss#100DaysOfDevOpsAWS
Giuseppe Santorocloudnativeengineer.hashnode.dev·12 hours agoUnlock SQLite: Easy Data Analysis for Busy Software EngineersRead my latest article Unlock SQLite: Easy Data Analysis for Busy Software Engineers. Topics: 🧰 SQLite for Engineers: Simplified data analysis tool for small datasets. 📚 Easy Setup: Less complex than big data tools, suitable for quick projects. ...DiscussSQLite
Jamey Bartondbajamey.hashnode.dev·19 hours agoHow to import text files to MySQL/MariaDB databasesData import is one of the basic yet important operations in database management. What you need here is a selection of formats to choose from, flexible settings for each format, and a handy GUI tool that will help you make the process smooth and effic...DiscussMySQL
Himanshu Chauhanhimanshuchauhan.hashnode.dev·Mar 17, 2024Day 31: Introduction of FastAPIThis blog is part of my Python learning series, specifically focusing on FastAPI, a new web framework. We will delve into building an e-commerce site project using FastAPI, providing hands-on experience in developing APIs with Python. Additionally, w...DiscussPython Python
linhvuquachlinhvuquach.hashnode.dev·Mar 17, 2024How to save datetime data that is relevant to multiple countries or time zones?Solution When you need to save datetime data that is relevant to multiple countries or time zones, it’s important to follow best practices for handling time zones and storing datetime information. Here are the steps you can take to achieve this: 1. U...DiscussJavaScript
Lionel Owonoblog.esperluet.xyz·Mar 16, 2024Dive into Table Fragmentation and Optimization Techniques in MariaDB, and PostgreSQLIntroduction Fragmentation refers to the state of being broken into fragments. In the realm of computer science, it involves storing a file or data in multiple separate areas across memory. This concept extends to databases, where data is stored on h...Discuss·10 likesSQL