A naukri.com initiative
Databases
Dbi-Services
13h
98
Image Credit: Dbi-Services
How to: Deploying a virtual machine using Infomaniak Public Cloud
- To deploy a virtual machine in Infomaniak Public Cloud, go to Instances and click on "Launch Instance".
- Select the parameters for your virtual machine like project, name, and availability zone.
- Choose the OS and disk size in the Source tab, and select the shape (Flavor) of the virtual machine.
- Configure optional parameters such as network ports, security groups, key pair, script, server groups, scheduler hints, and metadata.
Read Full Article
5 Likes
Dev
17h
73
Image Credit: Dev
How to Get the Query Builder to Output Its Raw SQL Query as a String
- Understanding the raw SQL query can be beneficial in several cases: Debugging, Logging, Optimization.
- Laravel provides a convenient method to retrieve the SQL query with bindings.
- The toSql() method returns the raw SQL query as a string without executing it.
- There are multiple ways to retrieve the raw SQL query in Laravel, such as using toSql() method, manually replacing bindings, logging queries using query listeners, and using Laravel Debugbar.
Read Full Article
4 Likes
Dev
20h
274
Image Credit: Dev
Do Ordered Grouping and Aggregation within Groups — From SQL to SPL #1
- A certain database table describes the payment cycle for multiple projects.
- The task is to identify each payment month for each project and calculate the total amount for that payment cycle.
- SQL does not have a direct ordered grouping, it requires the use of window functions and subqueries.
- SPL (Structured Query Language Processing Language) supports convenient ordered calculations and offers straightforward code.
Read Full Article
16 Likes
Dev
2d
82
Image Credit: Dev
Automate MySQL Backups with CRON Jobs in cPanel
- Regular database backups ensure that your data is safe and easily recoverable in case of unexpected issues.
- CRON jobs allow you to schedule automated tasks at specific intervals, eliminating the need for manual backups.
- To automate MySQL database backups using CRON jobs in cPanel:
- Set up the CRON job command with the appropriate path and username.
Read Full Article
4 Likes
Discover more
- Programming News
- Software News
- Web Design
- Devops News
- Open Source News
- Cloud News
- Product Management News
- Operating Systems News
- Agile Methodology News
- Computer Engineering
- Startup News
- Cryptocurrency News
- Technology News
- Blockchain News
- Data Science News
- AR News
- Apple News
- Cyber Security News
- Leadership News
- Gaming News
- Automobiles News
Medium
2d
369
Image Credit: Medium
SQL Performance Tuning Scenario #1: Understanding Execution Plans
- An execution plan (sometimes called a query plan) shows how the database engine will (or did) execute a SQL query.
- Execution plans provide information on steps involved in retrieving data, such as indexes used, table joins, sorting, and more.
- Interpreting execution plans helps in diagnosing query problems and guiding performance optimizations.
- Understanding execution plans is a fundamental skill in SQL performance tuning.
Read Full Article
22 Likes
Dev
3d
139
Image Credit: Dev
Building a User Registration System in .NET Core & C#
- Implemented a user registration system using ASP.NET Core and C#.
- Technologies used include ASP.NET Core MVC, Entity Framework Core, SQL Server, and ASP.NET Identity.
- Steps involved in implementing the Register method are creating a RegisterViewModel, implementing the Register method in AccountController, and creating the Register view.
- Learned about user input validation, user registration using UserManager, password security with ASP.NET Identity, and connecting frontend with backend logic.
Read Full Article
8 Likes
Dev
3d
103
Image Credit: Dev
Finding Skipped Reference Numbers in DB
- For each purchase transaction, a reference number is created.
- When the server already generated the unique number, and there is an error in the creation, the reference number will be skipped.
- The solution is to analyze the patterns and find the missing reference numbers in the database.
- By using SQL queries, the missing reference numbers can be identified by comparing the current and next reference numbers.
Read Full Article
6 Likes
Cloudblog
4d
303
Image Credit: Cloudblog
Where’s the beef? For São Paulo’s agricultural ministry, it’s on Cloud SQL for SQL Server
- The Secretariat of Agriculture and Supply of the State of São Paulo (SAA-SP) plays a key role in promoting the sustainable production of food, fibers, and bioenergy in Brazil.
- SAA-SP manages critical systems like Rural Environmental Registry and GEDAVE and needed to modernize for efficiency and data security.
- Challenges with the on-premises system included difficulties in updating, performing backups, and maintaining high availability.
- SAA-SP chose to migrate its SQL Server database to Cloud SQL for SQL Server on Google Cloud for modernization.
- Benefits of the migration included simplified updates, automated backups, enhanced security, scalability, and reduced IT costs.
- The move to Cloud SQL enabled SAA-SP to focus on innovation, integrate AI for analysis, and make data-driven decisions.
- Future plans for SAA-SP include migrating to microservices, utilizing generative AI for data analysis, and managing data with Gemini.
- The migration to Cloud SQL has positioned SAA-SP as a leader in technology and innovation in the agricultural sector.
- Cloud SQL for SQL Server offers enhanced application performance, continuity, and cost efficiency for organizations like SAA-SP.
- SAA-SP's advancements in technology and data analytics are driving the development of agribusiness in São Paulo and beyond.
Read Full Article
18 Likes
Medium
5h
151
SQL Performance Tuning Scenario #3: Indexing Based on Search Patterns (SARGability)
- SARGability refers to queries where the search predicates in the WHERE clause are written in a way that allows efficient use of indexes.
- Using SARGable queries allows for index seek instead of full table scans, resulting in faster and more efficient query execution.
- Writing SARGable queries is important for optimal index utilization and query performance.
- By avoiding functions on indexed columns and following best practices, effective use of indexes can be maintained as data grows.
Read Full Article
9 Likes
Medium
5h
285
Image Credit: Medium
Setting Up a PostgreSQL Database Using GCP Cloud SQL
- This guide explains how to set up a PostgreSQL database using GCP Cloud SQL.
- It covers the process of creating a PostgreSQL instance, applying performance configurations, implementing security measures, setting up backups, and monitoring the database.
- By following the steps, users will have a fully functional PostgreSQL environment on GCP for testing, development, or small-scale production scenarios.
- The guide also emphasizes the benefits of using PostgreSQL in terms of learning best practices that can be applied to other databases.
Read Full Article
17 Likes
Mysql
1d
73
Image Credit: Mysql
The Potential of Query Attributes in MySQL
- Query Attributes in MySQL are a new feature introduced in MySQL Protocol available since version 8.0.23.
- They offer per-query metadata in the form of key/value pairs, in contrast to Connection Attributes which provide per-connection metadata.
- Connection attributes are set by connectors or applications, aiding in understanding what connects to the server, but have limitations in certain scenarios.
- Query Attributes, when the CLIENT_QUERY_ATTRIBUTES flag is set, allow setting key/value pairs on a per-query basis, distinct from connection attributes.
- Changes in network packets for COM_STMT_EXECUTE and COM_QUERY commands enable sending parameters and parameter names with queries.
- MySQL C API introduces functions like mysql_bind_param() and mysql_stmt_bind_named_param() to send query attributes with regular and prepared statements.
- MySQL Connectors like MySQL Connector/Python and MySQL Connector/J have added functions to support query attributes.
- MySQL Client now allows setting query attributes using 'query_attributes
' to enhance query metadata. - Query Attributes can be used for sending metadata like Trace ID, user info, page name, etc., improving trace linking, proxying, or web page rendering.
- Despite the benefits, query attributes still have limitations, including not being included in binlogs, general log, or slow query log.
Read Full Article
4 Likes
HRKatha
1d
127
Image Credit: HRKatha
Job opps for 3.5 lakh students in 9 months by Apna.co & AICTE
- Apna.Co, in collaboration with AICTE, facilitated job opportunities for 3.5 lakh students across 6,000 colleges in 9 months.
- AICTE Career Portal connected students with verified job opportunities from over 44,000 companies.
- Free career masterclasses guided students on resume building, interview preparation, and emerging technologies.
- The portal helped students develop industry-relevant skills and eliminated geographical barriers for equal opportunities.
Read Full Article
6 Likes
Dbi-Services
1d
1.9k
Image Credit: Dbi-Services
An introduction to Azure Database watcher
- Azure Database watcher is a managed monitoring service for Azure databases and Azure Managed Instance.
- It collects telemetry data, logs, and metrics to provide insights, diagnostics, and proactive monitoring.
- Database watcher supports monitoring Azure SQL Database and Elastic Pool, as well as Azure SQL Managed Instance.
- The service components include Database watcher, Targets (components to monitor), and Data store (Azure Data Explorer).
Read Full Article
14 Likes
Dev
3d
272
Image Credit: Dev
common pitfalls and solutions for mysqldump/xtrabackup-based SSTs
- Adjust flow control parameters to avoid overload during heavy operations. Monitor wsrep_flow_control_paused for improvements.
- Ensure uniformity of wsrep_sst_auth values and grant necessary privileges to avoid Xtrabackup authentication failures.
- Use identical xtrabackup versions and prefer the clone method for Galera 8.0.22+ to avoid version incompatibility issues.
- Verify port accessibility and whitelist SST ports to resolve network and port configuration issues.
Read Full Article
16 Likes
Alvinashcraft
4d
214
Image Credit: Alvinashcraft
Dew Drop – February 14, 2024 ❤️ (#4362)
- Announcing TypeScript 5.8 RC and new features for enhanced Razor productivity are among the top links shared.
- Web & Cloud Development updates include the launch of Interop 2025 and new features in Microsoft Edge.
- Uno Platform 5.6 released with performance enhancements, and .NET MAUI 9.0.40 received service release 4.
- In the Visual Studio & .NET section, topics cover data virtualization, weak reference pattern implementations, and keyless entity types in EF Core.
- AI-related articles discuss responsible AI culture, prompt engineering with GitHub Copilot, and using DeepSeek-R1 on Azure with JavaScript.
- Design, Methodology & Testing insights include DevOps and AI series, observability vs monitoring differences, and fostering continuous improvement mindset.
- Mobile, IoT & Game Development topics touch on building a memory game in React and Microsoft ending HoloLens development.
- Screencasts & Videos section includes content on containers, C#, testing, and WinUI layered FontIcons.
- Podcasts range from responsible AI culture discussions to ReactScan tools for identifying performance issues.
- Community & Events section highlights upcoming MySQL meetups, layoffs at Meta, and the role of male allies in empowering women in tech.
Read Full Article
12 Likes
For uninterrupted reading, download the app