Query mssql wordpress jobs

As an exper...experience in Laravel and you're familiar with Laravel 11. • You've previously developed websites using Laravel 11. • Your forte is optimizing code efficiency and database queries. • You have a strong understanding of how to improve page load times and database query speed. Your task: • Optimize my existing codes in Laravel 11, for open source project • Main areas for optimization include database queries and code efficiency • The goal is to achieve faster page load times and improved database query speed. • Test subscription and plans, if it works fine or not Please, only apply if you have the mentioned skills and experience and you're able to demonstrate evidence of past projects you've optimized for p...

I am in need of an exp...developer to create an interactive, transactional platform with the ability for information sharing, social interaction, and query resolution. This platform should be accessible both as a mobile app and a website, with seamless functionality across Android, iOS, and various web browsers. The ideal candidate for this job would have the following skills and experience: - Expertise in both app and web development, with a portfolio of interactive, transactional sites/apps. - Experience with Android & iOS app development. - Understanding of user experience, particularly in relation to e-commerce and social networking. - Proven problem-solving skills in the area of query resolution. Please provide examples of your work and detail your experience w...

It is necessary finish a project managemet application made in laravel. The change are: - make some change regard the flow, the links, the design, the ecommerce and report; - It is necessary experience in query, report charts, pivot builder and Business intelligence to change the reports that must have good design, many filter and cross. the charts must have drill down. Please answer only if have experiences in project management software and pivot-query-busienss intellegence. And show my the url of similar job made.

ASAP you need to complete all the tasks on this page, take a screenshot with an open notebook (with one text sent by me) and the program to confirm that the query has been completed. In the second word, just the text with all the queries.

...need a professional who can help me optimize my MySQL server by fixing the file and optimizing all bad queries to reduce the high CPU usage and improve the query speed. Key Responsibilities: - Review and modify the file to optimize the server configuration - Identify and optimize all bad queries to improve query speed - Reduce high CPU usage by fine-tuning the server - Provide a detailed report on the changes made and their impact Access: - You will be provided with AnyDesk access to the server for optimization. Ideal Skills and Experience: - Proven experience in MySQL server optimization - Strong knowledge of query optimization techniques - Familiarity with the file and server configuration - Ability to work remotely using tools like AnyDesk - Excellent commu...

...need a professional who can help me optimize my MySQL server by fixing the file and optimizing all bad queries to reduce the high CPU usage and improve the query speed. Key Responsibilities: - Review and modify the file to optimize the server configuration - Identify and optimize all bad queries to improve query speed - Reduce high CPU usage by fine-tuning the server - Provide a detailed report on the changes made and their impact Access: - You will be provided with AnyDesk access to the server for optimization. Ideal Skills and Experience: - Proven experience in MySQL server optimization - Strong knowledge of query optimization techniques - Familiarity with the file and server configuration - Ability to work remotely using tools like AnyDesk - Excellent commu...

I require a proficient developer to desi...project includes: The development of a lightweight css, jquery design that is simplistic but still looks ok. Static Pages - Home - Contact Us - About Us Functionality Pages - User Registration - User Login - User self management) - Password reset via email. - User Management admin The sample should show, connecting to an ms sql database. Displaying data through a non defined data source eg (a query enbeded in the code) as well as a defined Datasource. The site should use headers and footers. VS2022, has a sample site, it could be possible to simply use that and make the 'users' logging in / connecting to the database more more explanatory and functional, while at the same time adding in sample page for enbeded and non enbe...

I aim to create a music blog using WordPress, focusing on showcasing different genres and providing readers with insightful articles. Since this platform is not designed for music streaming, key elements will be centered around content curation, reader engagement, music discovery, and overall user experience. Given that the primary function is blogging, ideally, freelancers should: - Have experience designing WordPress websites, particularly blogs - Understand the music industry to some degree - Be able to incorporate engaging visuals that suit the music theme - Possess SEO understanding to optimize blog posts for search engines - Demonstrate creativity in designing user-friendly layouts and easy navigation Though I skipped the query about the main features, I’...

...in search of a skilled developer with expertise in both MsSQL and ADF to assist me in achieving the following project goals: - Database Management: Your primary responsibility will be to manage our MsSQL database. This includes designing the database and ensuring smooth data storage and retrieval operations. - Data Integration: A crucial aspect of this project would be integrating MsSQL with various other systems and databases, mainly focusing on MsSQL itself. This will involve ensuring seamless data flow between these systems. Key Skills and Experience: - Proven experience in MsSQL database management. - Strong capabilities in database design and data storage and retrieval. - Adept at data integration, specifically integrating MsSQL with oth...

We have existing wordpress woocommerce and C# MSSQL inventory win application db in azure db I am looking for a developer for backend operations and experience in MSSQL, WordPress wooCommerce and API integrations. The primary task deduct stock in azure ms sql stock table when order placed in wordpress woocommerce display item list in woocommerce based on mssql stock table create comand to generate order in inventory system when order placed in wordpress woocommerce Key Skills Required: - Strong experience with MSSQL, WordPress woocommerce, API - Expertise in inventory management system e-commerce integrations who have done same work earlier plesae bid I will share explaining video, if you are able to do than you need t...

I am in need of a MySQL expert to develop advanced queries for my database management tasks. Key Responsibilities: - Writing new queries: You'll be responsible for designing and implementing new, advanced MySQL queries. - Query Optimization: While the focus is on writing new queries, any optimization suggestions to existing queries are welcome. Ideal Skills: - Proficiency in MySQL: You should have advanced knowledge of MySQL language and its various functions. - Query Optimization: Experience in query optimization will be beneficial. This project is suitable for a MySQL developer with a proven track record in creating complex, high-performance database queries. It's important that you're able to work efficiently and effectively in order to meet the pr...

...Excel sheet. We also can’t just write code to remove the 30 columns prior to the last column, because all user files might not have the columns in the same order, so a required column might find itself in one of those locations. Based on my test results, one possible solution to the problem might be to write the code such that it only transfers the 10 columns that are needed in a subsequent mysql query. However, any solution that fixes the problem will be great. Here's what I need you to handle: - Diagnose and fix the issue. - Ensure successful creation of tables in my MySQL database from Excel data. Ideal Skills: • PHP • MySQL • Expertise with PHPSpreadsheet • Debugging • Experience with Excel-data moving projects. Informed bidding i...

I'm looking for a proficient PHP developer who can help me with parameterizing a MySQLi query in my project. Specifically, I need assistance with data retrieval operations. Key requirements: - Proficiency in PHP: You should have a strong grasp of PHP programming. - MySQLi Query Parameterization: The ideal candidate should be experienced in properly parameterizing MySQLi queries. - Data Retrieval: The primary task will be focused on data retrieval operations. The project may include: - Handling multiple parameters: You should be comfortable working with queries that handle multiple parameters at once. - Optimization: Ensuring the queries are optimized and secure. It's a relatively straightforward task for a skilled PHP developer with MySQLi experience. If you...

I’m looking for an expert with MySQL skills to help me write a query or script. This task involves calculating the sum of items across three tables.. The complexity lies in filtering the said items between a certain date range and by a specific field value. Ideal Skills & Experience: • Proficient in writing SQL queries • Knowledge on MySQL, specifically on data manipulation among multiple tables • Excellent understanding of database design and principles • Problem solving ability to handle complex programming scenarios. Please note, I didn't provide the names of the fields to be summed in each table. So, the chosen freelancer will need to work with me and understand the complex structure of my database in order to pull this off. Therefore excelle...

Hi Yusuf A., I noticed your profile and would like to offer you my project. We can discuss any details over chat. Procedure:  Upload Excel file containing Expediente Codes  Use automation and OpenCV to solve Captcha and download files  Upload files to s3 bucket  Integration with existing system query api sunat use email for login

I need an in-depth and comprehensible 2000-word report on relational databases. This should include: - A focus on normalization and handling of relational database constraints. - An E-R diagram and an SQL query. The project description doesn't specify requirements for these, so use your expert judgment to determine what is necessary. - The report should also be accompanied by a 15-slide PPT presentation summarizing the report's highlights. Ideal Skills & Experience: • In-depth knowledge of DBMS • Expert understanding of relational databases • Proficiency in E-R diagrams and SQL query • Excellent report writing skills • Experience in creating engaging PPT presentations.

I'm currently seeking a skilled database specialist who can write sql query and can give me ai free report around the entity relationship diagram and normalisation. I need a 2000-word report + 15-20 slides presentation Objective: This assignment aims to enhance your understanding of database design through the practical application of Entity-Relationship Diagrams (ERD) and normalization techniques. You will work in groups to design a database system that is both efficient and scalable, addressing a real-world problem scenario provided below. Assignment Scenario: Your team has been tasked with designing a database system for one of the scenarios listed according to your group number; if you are in group N, you must choose scenario N. For example, Group 10 must choose Scenario...

...create a chatbot whatsapp business integrated with Mikrowisp The chatbot will serve as a tool for registered companies to interact with their customers. Key Features: - Options menu: The chatbot must provide the options menu, and a limit of queries to exit the chatbot and transfer the advisor. - Invoiced amount query: The chatbot must provide users with a simple way to find out the amount owed and due date. - Consultation of the user profile: The chatbot must respond to the contracted profile. - Spanish Support: The chatbot needs to be capable of interacting with users in spanish - Company Management: The ability to enable, disable, or delete companies from using the chatbot should also be integrated. Ideal

...this metadata to construct and manage API endpoints dynamically. 4. ORM Flexibility: Any ORM tool like Entity Framework, Dapper, or SQLkata can be utilized to facilitate database operations. The choice of ORM should align to optimize performance and simplify maintainability. 5. Advanced Data Handling: Column Selection: API users should be able to specify which columns to retrieve in the query. Filtering and Sorting: Support comprehensive filtering and sorting capabilities to navigate through data efficiently. Pagination: Implement pagination to handle large datasets effectively. Aggregation and References: Enable aggregation of data from child tables and retrieval of related data from master tables (e.g., retrieving a customer's name when querying...

I'm in need of an experienced .Net developer, with solid skills in MSSQL and C#, who can effectively handle front-end development tasks in my POS terminal project. Your primary tasks will be: - Implement business logic based on defined user stories. - Develop the user interface of the POS terminal using C# and associated .NET technologies. - Integrate the POS terminal with MSSQL database for data storage and management Ideal skills and experience: - Proficiency in .Net, MSSQL, and C#. - Previous experience in front-end development. This role requires both technical expertise and keen attention to detail. I am looking forward to your innovative solutions to meet our project requirements.

It is necessary finish a project managemet application made in laravel. The change are: - make some change regard the flow, the links, the design, the ecommerce and report; - It is necessary experience in query, report charts, pivot builder and Business intelligence to change the reports that must have good design, many filter and cross. the charts must have drill down. Please answer only if have experiences in project management software and pivot-query-busienss intellegence. And show my the url of similar job made.

...Development needed to accommodate the expected volume of registrations Development to prevent IP bans Detailed feature description: Member Login Sign-up Permission assignment Individual inquiry Immediate rank crawling Tracking target management Individual input Bulk Excel upload & download Keyword-based crawling On/Off Deletion Background crawling of tracking targets Naver Place keyword (1 daily query) Rank change history Generate a shareable URL (reset every week) Display in a popup from step 3...

I am looking for a developer with a focus on backend operations and experience with C#, MSSQL, and WordPress eCommerce integrations. The primary task is deduct stock in azure ms sql stock table when order placed in wordpress e commerce create comand for performa invoice when order placed in e commerce Key Skills Required: - Strong experience with MSSQL and WordPress - Expertise in inventory management system integrations - Understands the intricacies of WordPress eCommerce platforms budget $70

I'm experiencing performance issues within my IoT-based platform, mostly coming from slow query response times, excessive storage consumption, and challenges with insert operations after compression. I'm looking for an experienced TimescaleDB expert to optimize this. - Optimize slow query response time - Reduce excessive storage consumption - Fix insert operations after compression The ideal freelancer for this project is someone who has extensive experience in TimescaleDB, particularly in query optimization and compression features. Unfortunately, I'm unable to provide the number of tables in the platform, but I need someone who is capable of handling extensive data and complex structures. If you've dealt with this before, you're the righ...

I'm in need of comprehensive and detailed Australian databases. Specifically: - Medical databases, with a key focus on medical specialties. Medical databases should preferably contain reliable and...reliable and relevant information about the different branches of medical specialties across Australia. - Business databases, encompassing detailed company profiles inclusive of industry category, phone, fax, email, physical address, etc. I'd appreciate getting more data, as in-depth as possible. The databases should be pre-existing or scraped and must be provided in Excel format, or .BAK for MSSQL server. Professionals equipped in big data collection, scrapping, and data analysis would be the most suited for this project. Knowledge about Australian medical and business sect...

...integrate a Dymo printer into my system. Here's a breakdown of the project: - **Integration**: I need the Dymo printer to work seamlessly with my Access 2013 database. The goal is to automatically print stock labels based on query results. This means you'll need to set up the system to take the query output and send it to the printer for label creation. - **Printing Specifics**: The labels I need printed are stock labels. The process should be automated, so the labels are generated and printed without manual intervention. The labels will be printed based on the results of a query in Access and some limited entry from the operator with such things as qty of labels and which of 2 labels (it's the DYMO LabelWriter 450 Turbo) with slightly different fie...

I am looking for a developer with a focus on backend operations and experience with C#, MSSQL, and WordPress eCommerce integrations. The primary task is deduct stock in azure ms sql stock table when order placed in e commerce create comand for performa invoice when order placed in e commerce Key Skills Required: - Strong experience with MSSQL and WordPress - Expertise in inventory management system integrations - Understands the intricacies of WordPress eCommerce platforms budget $70

Having an integral project already in place, I'm in need of a skilled SQL Developer to contribute towards its further development. Specifically, the tasks I require assistance with include: - Query Optimization: Tailoring and enhancing the performance of our current queries is a significant aspect of this role. - Database Maintenance: Maintaining the overall health and efficiency of our SQL Server is also a necessity. Ideal candidate must have a comprehensive understanding of SQL Server, as well as notable expertise in query optimization and database maintenance. I prefer someone with a proven track record of successfully managing and enhancing existing projects. I look forward to seeing your bids.

I'm in need of a LibreOffice Base specialist for form and report generation. Specifically, I require the creation of: - Input forms - Query forms - Output reports More specifically, I need a data entry form with a focus on a form view format. The successful candidate should demonstrate an excellent understanding of LibreOffice Base and form creation in various formats. Ideal Skills: - In-depth LibreOffice Base knowledge and experience - Expertise in form and report creation - Familiarity with form view format structures.

...including the ability to automatically hide and unhide tabs based on the selections made on the "Master Sheet. As well as pull in all needed information from the "Master Sheet" and any "Data Entry Sheet". Ideal Skills and Experience: Successful candidate should possess: - Deep understanding of advanced Excel formulas and functions. - Previous experience in designing visualization charts and custom query builders. - Strong analytical and data organizing skills. - Experience in converting independent Excel worksheets into a master file. - Knowledge in NDT industry would be beneficial but not paramount. The goal is to provide an automated and streamlined approach to handle inspection reports, making analysis and generation of summary statistics a bree...

.net .net core API Clean architecture Mssql Azure services SignalR Console application, cron job, background service Project is completed just need improving

Postgres data query system Docker across multiple servers

We are seeking a talented full stack developer to create a mobile application for a medical start up. The application will serve as a platform for patients to perform home based outdoors exercise, receive general information about their condition and communicate wit...and compatible with various devices and platforms - Conduct thorough testing and debugging to ensure high-quality and bug-free code Requirements: - Proven experience as a full stack developer - Familiarity with mobile application development, particularly in the medical industry - Strong programming skills in JavaScript, HTML, CSS, and relevant frameworks - Proficiency in database management and query optimization - Knowledge of RESTful APIs and best practices for integration - Excellent problem-solving and communicat...

Need a backend developer to implement bel...client's existing code base. 1. Feign clients 2. Request and the response interceptors 3. For opt in, only mobile number to be passed as param to the feign client's method - ("919999784665"); 3. For sending sms, only mobile number and msg to be passed as param to the feign client's method - ("919999784665", "Hey there I am using whatsapp"); 4. All other query params to be inserted via request interceptor 5. userid and password to be picked from yml file, they will be different for different environments. 6. For both the APIs we'll have response interceptors which will check if the 'id' given in 'response' corresponds to one of the error codes. If they do, then we...

I'm in need of a LibreOffice Base specialist for form and report generation. Specifically, I require the creation of: - Input forms - Query forms - Output reports More specifically, I need a data entry form with a focus on a form view format. The successful candidate should demonstrate an excellent understanding of LibreOffice Base and form creation in various formats. Ideal Skills: - In-depth LibreOffice Base knowledge and experience - Expertise in form and report creation - Familiarity with form view format structures.

i am looking for a developer to help generate 1d barcode for my existing web system in vb.net and database is mssql

I'm looking for an expert with exceptional skills in Microsoft Access/Database, Excel, and VBA coding. The main focus of the project is on Access/Database, the specific tasks include: - Data Entry - Query Building - Database Design Ideally, I need someone who can efficiently handle a database containing 10-20 tables. You should be detail-oriented, experienced in managing medium-sized databases, and proficient in maximizing the functionality of Access. Excel expertise and VBA coding skills will also be highly valuable in this project. ONLY ACCEPT TASK IF YOU CAN DELIVER WITHIN 3 HOURS

There will be additional $50 for any who completes this project fully. The aim of this project is to compare three types of databases(Any relational database, mongoBD and Neo4J) in terms design approach, implementation, query composition, and performance. The data is about texas hold em poker game The stages of the project are 1. Look at the details of the data 2. Come up with an ER diagram and a relational schema for the data 3. Create a database in any relational db and tables 4. Create a python script to read the txt files and populate the db 5. Test the queries 6. Populate the other(mongodb and neo4j) databases and test the queries Then test the queries below on the databases QUERIES 1. Separate players by their style of play/Group players with a similar style of play togethe...

Need a Windows program that logs into an account, allows the user to enter a 2FA code in a browser window, enters queries into a search from an input XLS file, and on output saves the search status for that query.

Se inicia un proceso sin fin que consume todos los recursos del servidor. Adjunto captura de la información que me brindaron desde el servidor. Mi objetivo es que mi web deje de caerse por excesivo consumo de recursos. A continuación, copio la query que genera el problema (ver captura para más información): SELECT SQL_CALC_FOUND_ROWS from vsnucam_posts left join vsnucam_term_relationships on ( = Vsnucam_term_relationships.object_id) left join vsnucam_term_relationships as tt1 on ( = tt1.object_id) left join vsnucam_term_relationships as tt2 on ( = tt2.object_id) left join vsnucam_term_relationships as tt3 on ( = tt3.object_id) left join vsnucam_term_relationships as tt4 on ( = tt4.object_id) where

...automated as much as possible. - It should have the capability to save both sent and received - The add-in should be efficient, ensuring that no emails are missed in the process - A simple yet effective interface that is easy to navigate and use is crucial The add in will: - query a SQL database and find clients linked to the sender/recipient and prompt the user to select the relevant client - Save a copy of that email to the relevant folder for the selected client - again based on a SQL query. The SQL query information can be provided to facilitate this. Ideal Skills and Experience: - Proven experience in developing Outlook add-ins. - Knowledge of Microsoft Outlook's functionality. - Strong attention to detail to ensure proper email categorizati...

I'm seeking a skilled VB.NET/MSSQL developer who have ever done simillar work in Tax and statutory compliance projects like Kenya - KRA, TIMS,UAE - FTA,India - GSTN, Angola - SAF-T, etc to integrate the Electronic Fiscal Receipting and Invoicing System (EFRIS) API into my VB.Net POS Project. The successful freelancer will have extensive experience in creating similar systems and should possess a keen eye for detail. Key Features: - E-Invoicing:

It is necessary finish a project managemet application made in laravel. The change are: - make some change regard the flow, the links, the design, the ecommerce and report; - It is necessary experience in query, report charts, pivot builder and Business intelligence to change the reports that must have good design, many filter and cross. the charts must have drill down. Please answer only if have experiences in project management software and pivot-query-busienss intellegence. And show my the url of similar job made.

script for auto replying mail with attached files

I'm looking for an expert in MS SQL databases to help me with a specific task. I’m using an MSSQL database and need to create a Param scalar. This is to store specific customer information in a structured manner. The ideal freelancer should be experienced with: - SQL, specifically MSSQL - Parameter creation within databases - Experience working with customer information In your proposal, please provide an example of a similar task you've completed in the past.

...is to develop a simple system that will help me manage following for my store, Inventory Sales Administration Inventory Inventory management and verification are the main reasons for developing this system. Each piece of inventory will be tagged with an asset barcode, so that I can track where each piece is and when it was sold at what price. Also need to be able to generate a barcode in a query and report. See Each week, inventory will be scanned, and a report generated to figure out variations between physical stock and what the system says. Inventory dashboard and reports like aging, velocity etc. Sales Should be able to create a customer from the sales order screen. Sales order will be created using customer

I am currently looking to engage an experienced Machine Learning professional for my project. I require analysis to be conducted on text data as well ...as well as numerical data. A strong understanding of Machine Learning concepts and analytical skills are vital. While I have not specified a particular focus area of Machine Learning, I am open to recommendations from the chosen freelancer based on the data provided. Key requirements include: - Proven track record in Machine Learning - Proven track record in Google Gemini and Google big Query ML - Proficient in data analysis and interpretation - Experience working with both text and numerical data Critical thinking and problem-solving skills with attention to detail will be necessary for the successful completion of thi...

MS1: Solana Data INPUT: Solana contract address OUTPUT: (These may change in time. We are looking for only the snapshot at the time of the inquiry). 1. List of wallet addresses that have a non-zero balance of the input contract token AND no buy transaction for that token, at the time of the query. 2. Percentage of the total supply that these wallets under item 1 above hold collectively (%) 3. Percentage of the total supply under AMM (%) (Only Raydium is fine). 4. Mint authority info. - Must have: Mint authority revoked? (Yes / No) - Optional but great to have: Mint authority status (Permanently revoked, time-limited etc). 5. Liquidity info. - Must have: Percentage of the liquidity locked (%) - Must have: Liquidity burned? (Yes/No) - Optional but great to have: Liquidity lock autho...

...performance of our aggregation pipeline. The focus is on improving the response time and enhancing our capability to handle large volumes of data proficiently. The goal is to reduce response time to under 100 milliseconds without compromising data accuracy or integrity. WE WILL PROVIDE A PYTHON SCRIPT THAT CONTAINS MongoDB AGGREGATION PIPELINE Key Responsibilities: - Review and enhance the query performance - Optimize our large volume data handling - Analyze and understand the existing aggregation pipeline. - Identify potential bottlenecks and areas for optimization. - Implement efficient algorithms and techniques to enhance pipeline performance. - Ensure that the script returns data in less than 100 milliseconds. - Test and validate optimizations to ensure accuracy...

...functionality of the application. Key Responsibilities: - Identify the root cause of the pagination issue - Resolve the bug to ensure the pagination system functions correctly - Test the application thoroughly to verify that the issue has been fixed Ideal Skills and Experience: - Proficiency in PHP and Laravel framework - Prior experience with Laravel's built-in pagination - Strong knowledge of Query Builder - Ability to troubleshoot and debug complex issues - Excellent problem-solving and communication skills It's crucial that the freelancer I work with has a keen eye for detail and a track record of successfully resolving similar issues. The individual should also be comfortable with working in a fast-paced, deadline-driven environment. Here is a video that expla...