The mssql database you are currently using is slow to search You want to improve the speed of this slow search speed.
...goal is to automate daily updates of the website's database. Key Requirements: - Daily database updates: The website should automatically update its database every day. - Products and prices: The database should include technology products, such as electronics and computer hardware. - Design and layout: The website should be visually appealing and user-friendly. - Database type: The database can be either SQL or MySQL. Ideal Skills: - Proficiency in SQL or MySQL - Experience in e-commerce website development - Strong understanding of front-end design - Ability to automate database updates - Expertise in handling technology products Your proposal should include: - Your experience in similar projects - Your approach to automating da...
...professional who can smoothly transition my old database into the new one for my website. There are some extra columns in certain tables in the new database, so understanding the essence of the project is pivotal. Here's what I need assistance with: 1. Importing Data: I have a detailed list of specific tables and columns which need to be brought into the new setup. Your work will heavily rely on this list. 2. Data Combination: While importing the data, some of it requires merging. I won't be able to guide you on how this should be done, so it will fall under your professional judgment. Your proven experience and innovative strategies will come into play here. I am hoping to find someone who has extensive experience in MySQL, data merging, and database...
...than 15 minutes. Project Overview: Task: Video editing and creation, with a focus on road safety awareness Duration: Maximum 15 minutes Primary Content: Provided media includes interviews with road safety experts and drivers, hazard road videos, and scenes of dangerous driving Audience: 1000+ drivers Timeline: Completion within 3 to 4 days from task assignment Key Responsibilities: Edit and merge supplied contents seamlessly to maintain viewer engagement Strategically place and time visuals to effectively illustrate the implications of road safety Your Skills Should Include: Proficiency in video editing software Experience with editing interview-style and road safety content Ability to tell a story visually and audibly Understanding of the seriousness of the theme and conveyi...
...relational database design. The primary goal is to deepen my understanding and skills in E-R modeling, functional dependency theories, and database norms, particularly: * Identifying entities and relationships * Applying E-R modeling and normal forms for a well-designed relational database. The chosen candidate should be proficient in the aforementioned areas, plus have the capability to clarify how to use these skills to identify performance issues, validate data integrity, and evaluate scalability. The project scope encompasses E-R modeling, identifying entities and relationships, and applying normal forms. Ideal Skills: * Advanced knowledge in RDBMS * Proficiency in E-R modeling * Understanding of functional dependency theories * Experience in applying normal...
I am seeking a PHP developer who is experienced in frontend development, and an expert in PHP frameworks and MySQL database integration. The focal point of the project is database management. • Main responsibility of the PHP developer will be to build new databases, thus experience in this is essential. • A background working with PHP frameworks and MySQL is crucial for success in this role. • The role also entails some front-end development tasks. Successful applicants will illustrate these skills throughout their portfolio in relation to past projects. If you are a self-starter with a penchant for database management, I look forward to receiving your bid.
I'm requiring aid in managing and optimizing my SQL database. This database is currently handling a range of information including product details, customer details, and order details. Key Tasks: - Improve the existing SQL database - Ensure efficient handling of product, customer, and order data Ideal experience and skills: - Proficiency in SQL queries - Experience in database management - Familiarity with inventory management processes, specifically handling a limited range of 20 different products. This project will require a keen attention to detail and a comprehensive understanding of SQL database manipulation.
...areas: database design and query optimization. Key Responsibilities: - Database Design: I'm looking for assistance in designing the database to ensure it's well-structured and optimized for performance. - Query Optimization: I need an expert who can help in fine-tuning our queries to ensure they're efficient and have minimal impact on our database. Key Skills and Experience: - Proven experience in MongoDB database design and query optimization, especially for small datasets (less than 1 GB). - Solid understanding of indexing strategies and their role in improving query performance. - Ability to communicate effectively and work collaboratively to understand our specific needs and tailor solutions accordingly. - Familiarity with perfor...
I'm in need of a comprehensive business owner database specifically in Tamilnadu, Chennai. The database should include detailed information of business owners Contact number, Email ID from various industries like GST Filling Database, Distributors, Industries, Dealership and more
I need a fast turnaround to correct error messages in my PHP code and database. The main goal of my PHP application is to upload content to the database and ensure the site displays it correctly. Key Responsibilities: - Fixing error messages in PHP code - Addressing database issues - Ensuring smooth content uploading functionality - Ensuring the site can retrieve and display content from the database Ideal Skills and Experience: - Proficient in PHP - Strong understanding of database management - Prior experience in troubleshooting and fixing error messages - Ability to work fast and deliver under tight deadlines.
I'm looking for a task-oriented individual who can assist me with saving documents from an online database. Your assignment would primarily revolve around focusing on documents and seamlessly saving them off. Key responsibilities: - Download documents with my full permissions. - Make sure that all downloaded files are in audio file format and labelled correctly. The ideal candidate will have: - Relevant experience and proficiency in saving files to dropbox. - Excellent attention to detail ensuring the correct files are stored. May be 1-2 days of work.
...with superior graphic design and video editing skills. The primary focus of this project is to create engaging content for entertainment and social media purposes. Key specifics: - The core theme is based on Lifestyle and Travel. Experience in creating content in this field is preferred. - I'm enthusiastic about incorporating illustrations into the designs. A knack for renditions that seamlessly merge with photos, maintaining a strong aesthetic appeal, is appreciated. This project requires a blend of creativity, proficiency in video editing and graphic design, and a keen understanding of social media trends revolving around travel and lifestyle. A successful delivery will involve stylized, unique, and impactful visuals that would resonate with social media users and elevat...
...crucial database issue with my website built on Node.js. There are certain missing tables that cause the application to crash whenever specific buttons are clicked on the site. Key Details: • The crashing issue is experienced when the Login button, Submit form button, or the Add to cart button is clicked. • Due to these unsolved errors, the terminal indicates that a certain table name is not found. Ideal Skills and Experience: • Solid background in solving database issues in Node.js platforms. • Experience in working with missing tables and rectifying database errors. Application Requirements: Freelancers interested in this project should include detailed descriptions of their previous and related experiences in their application. The ulti...
I'm seeking a professional with a strong background in Excel to develop a keyword search tool for an Excel database. This tool will primarily be used for filtering data and linking to articles hosted on a network. Key Requirements: - Experience creating and managing Excel databases - Proficiency in implementing keyword search tools in Excel I would like the sheet to have a Main/Search Page and another page for the database. I want to be able to add new entries to the database section and have them be searchable on the main page. I want to be able to create new searchable keywords on the database page and have them populate and be searchable on the main page. I would like to be able to enter multiple search terms into the search box to narrow the results....
We are working under an expedited deadline (less than 1 month) to integrate machine learning with our unit commitment problem (UCP), specifically focusing on renewable energy sources (RES) - solar and wind energy. Key responsibilities: - Implement neural networks in the machine learning algorithm. - Expertly merge UCP with RES (both solar and wind energy). - Expert in unit commitment problems Ideal candidate: - Proven experience in machine learning - Familiarity with neural networks - Strong understanding of renewable energy systems - particularly solar and wind - Ability to meet tight deadlines Your expertise in neural networks and renewable energy is pivotal to the success of this project. Let's make the world more sustainable together!
I'm running a new PHP script on Linux and it's not pulling data correctly from an MSSQL Database. Since the script is new, I'd appreciate some help identifying what went wrong. Skillsets and Experience Needed: - Proficiency with PHP and MSSQL databases - Experience troubleshooting PHP script issues in a Linux environment - Experience with new script debugging - Knowledge of database connectivity issues and their solutions - Ability to communicate complex technical issues clearly
I'm in need of an expert in trading view pine script programming who's capable of merging two indicators in one. Your task will be: - Merge the Two indicators into a single script on the Trading View platform. - Incorporate Fibonacci (Fib) levels in the script, but specifics were not indicated. We can discuss that further. 1. **Combine Indicator Logic**: - Integrate the logic from both indicators into a single script. - Ensure that the functionality to track highs, lows, and Fibonacci levels is preserved. - Maintain separate sections for calculating highs and lows, as well as for drawing Fibonacci lines. 2. **Adjust Inputs Interface**: - Rearrange the input section to display inputs horizontally for better organization. - Add new inputs for the requested...
I'm looking for a skilled freelancer to assist with text data entry from online sources into a database. Key Responsibilities: - Inputting data from online sources into a database - Ensuring accuracy and consistency in data entry The ideal candidate should have: - Proven experience in data entry, particularly from online sources - Strong attention to detail to ensure accuracy - Proficiency in database entry methods This is a straightforward project that needs a reliable, detail-oriented individual.
I'm in need of an expert in trading view pine script programming who's capable of merging two indicators for my strategy. Your task will be: - Merge the Two indicators into a single script on the Trading View platform. - Incorporate Fibonacci (Fib) levels in the script, but specifics were not indicated. We can discuss that further. Ideal candidates should have: - Good understanding of Trading View's pine script and trading indicators. - Experience in scripting Moving averages and Bollinger Bands. - Knowledge on incorporating Fibonacci levels. Please bid with examples of similar work you've done in the past. I'm looking forward to your proposals.
I'm seeking a Laravel expert to help resolve a database connection error I'm experiencing on my website. This error occurs specifically when trying to access certain pages. Key requirements: - Experience with Laravel: You should have a strong understanding of Laravel's structure, especially concerning database connections, in order to diagnose and resolve this issue efficiently. - Troubleshooting Skills: You should be adept at identifying the root cause of the error, whether it be an issue with the code, configuration, or server setup. - Efficient Communication: As I have full access to the website's server and database configuration files, you may need to collaborate with me to access the necessary resources.
...issues with my Node.js site, I require an expert in database management to remap the database. Specifically, clicking on 4-5 specific buttons frequently crashes the site, displaying an error of "table not found". Understandably, this is impacting the usability and overall user experience of the website. The key project objectives include, but are not limited to: 1. Diagnosis and rectification of the error causing the site crash. 2. Remapping of the website database to eliminate the current recurring issue. 3. Arguably most vital, is the safe retainment and integration of the old member data within the newly rectified database. Ideal applicants should be proficient in Node.js and database management, especially handling and rectifying such ...
I'm in need of a skilled .NET developer to create a functional web application that mainly handles user registration, login, and database management. Key Requirements: - User Registration and Login: The application should have a robust system for users to sign up, log in, and manage their accounts securely. - Database Management: Proficient database management within the application is a must. This includes data storage, retrieval, and manipulation. Additional Information: - External Integrations: There is a possibility that additional integrations may be required in the future. Experience with integrating external systems and APIs would be beneficial. - User Roles and Permissions: The application may need to support multiple user roles and permissions. While th...
I'm looking for a skilled MS Access developer to create a billing and accounting database with a modern, minimalist interface. Key Requirements: - Customizable Reporting: The system should be able to generate a variety of reports on different aspects of the business, such as sales, expenses, and profit margins. These reports should be adaptable for future needs and allow for different levels of detail. - Integration with Existing Systems: The database will need to interact seamlessly with other existing systems and software used by the company, ensuring data consistency and accuracy. - User Permissions and Access Control: The system should have a robust user management system that allows for different access levels and permissions. This will ensure that sensitive financ...
I'm in need of a professional who can help me with installing the Oracle 23c database on my Ubuntu Linux system. Key Skills: - Proficiency in Oracle database installation - Specific experience with Oracle 23c - Strong understanding of Ubuntu Linux The selected candidate should be able to: - Perform a detailed installation of Oracle 23c database (enterprise version) on Ubuntu Linux - Ensure proper configuration to meet the project's requirements - Provide guidance on any post-installation tasks that may be necessary Is there any possibility to install a 23c oracle database enterprise version not free version on docker?
I'm currently seeking a skilled freelancer for a data entry job concerning primarily text data. The data to be entered will be provided in an Excel spreadsheet and will need to be accurately transferred to an online database. Ideal candidates should have: - Proficiency in Microsoft Excel - Experience with data entry into online databases - Attention to detail and accuracy Please place your bid based on the information provided, and get ready to embark on an engaging and fulfilling data entry task.
I need a developer to build a PHP app using Google Sheets as a database. I want add a text on a field it'll to fetch rest row and column data from sheet. Check attachment. I'll enter only order number. This will involve: - Implementing a User Authentication system. Note that no specific features like social media authentication, two-step verification, or forgot password functionality are required. Just a simple log-in/log-out system will suffice. - Data validation will be key in this project. Each entry must be checked to ensure that it meets certain criteria before being stored in the sheet. - Real-time data synchronization between the app and Google Sheets. This means that any changes made in the app should be instantly reflected in the sheet, and vice versa. As far...
I need a PCB designer (KiCad) for modify original design of a STM32 Nucleo64-Board(F302R8/F303RE) in order to add 2 MAX1487 on USART1 & USART3. I already have a working prototybe as a "hat" form factor for the nucleo, so the purpose of this mission is to merge our prototype schematic into the Nucleo schematic and supply a complete KiCad project ready for production (Gerger + steps to reproduce)
I'm looking for an expert in VBA and macros to help streamline my processes in Excel. Key Requirements: Shifts: Defined two shifts in the "task tap": Morning: 6:00 to 15:30 Afternoon: 14:00 to 22:30 Quality: Updated the agreed-upon columns in the "quality tap." And rem...proposal to link each task with its list of material and in case there is a lack of the material the task should be highlighted in red or yellow, Red color mean material will not be available in the scheduled time and yello means the material will be available before starting the task . 3-There is 2 Major files like this , one for morning shift and the second for Afternoon shift , its required to merge them in one file and adjust the task duration to be in hours not days Starting ...
I'm in need of a skilled database designer and manager who' is confident in English. The project involves creating and maintaining a relational database. Key Requirements: - Advanced knowledge of Relational Databases - Proven experience in database design and management - Must be be fluent in English Experience with: - Customer data management or transaction records (preferred but not mandatory) I'm looking for someone who can work on this project with no strict time limit.
I...list featuring more than 500 companies. In the details you collect for each organization, I'd like to see the following: - Company Name - Contact Person Name - Contact Person Email. The ideal candidate for this task would be someone who is proficient in data mining and possesses broad knowledge of Oracle EBS customers in the manufacturing, retail, automotive industry. Prior experience in CRM database creation would be an added advantage. It's essential that all information gathered adheres to privacy and data protection laws, ensuring a legally compliant list. So, a freelancer with a keen understanding of these laws would be highly preferred. Accuracy of data is of top importance, therefore meticulous cross-checking is needed for each entry. I'm looking for...
I'm in urgent need of a Python Django developer to help me deploy my old website files on Namecheap. Here's a rundown of the tasks and requirements: - Deploying old website files on Namecheap: I need you to swiftly and effectively set up and configure the database for my project. - No new development or integrations: You won't be tasked with front-end or API work, just the deployment of the existing files. Your experience with Django and database setup are paramount. Time is of the essence, so I need a professional who can work efficiently and effectively.
I’m seeking a data expert to scrape a specific database and transfer all available fields into an Excel (.xls) file. The database consists of approximately 150,000 entries. Each record includes data such as name, business name, contact information, date of foundation, etc. Ideal Skills: - Strong experience in Web Scraping - Proficiency in transferring data into .xls format - Attention to detail to ensure all available fields are captured Purpose and Deliverable: - The objective of this project is to use this information for data analysis. - The final output will be an Excel (.xls) formatted file containing each scraped database entry. Operation Specifics: - You would be required to locate and scrape the database by Zip codes. - A full export of all...
I have excel file where I want to clean. Merge columns and make it simple. You have to be able to fix it within 30 min not more
I have a series of brief game videos that I'd like to merge into a single dynamic and engaging advertisement for my Game. The individual videos are all under a minute in length and I'm looking for a fast-paced, energetic style of editing. Deliverables: - Primary Video of 30 seconds in Portrait and Landscape - Secondary Video of 15 seconds in Portrait Resources: 1. Videos are attached. If you do not find them interesting, I can attach more 2. Game Name: "Patterns Puzzle Game" 3. Game Platform: "Android, IOS" 4. Keywords: Relaxing, Interesting, Puzzle, Patterns, Tough 5. Ping me for more details. Key Requirements: - Combine multiple, short videos into one cohesive and engaging piece. - Fast-paced and energetic editing style to captivate the viewer. ...
I'm in need of a skilled developer to create a robust course management database for our educational institution. Key Functionalities: - Student Registration and Enrollment: The database should be able to store and manage student information. - Grades and Transcripts Management: The system should have a feature to track, store, and manage students' grades and transcripts. - Attendance Tracking: The database needs to have a reliable attendance tracking system. - Multiple Courses: The system should be designed to manage multiple courses efficiently. Expectation: - The database should be able to handle 50-100 users accessing it simultaneously. - It needs to be user-friendly, secure, and scalable for future expansion. - Preferably, a responsive design w...
I'm looking for an expert with exceptional Sequel database administration skills on a Windows environment. Your main task will be to handle executing regular exports from our Sequel Database to Excel, performing updates in Excel, and subsequently updating the Sequel Database with the altered data. Skills and Tasks; - Mastery in handling Sequel Database on Windows - Familiarity with Data Modeling and Design - Proficiency in exporting and updating database information via Excel - Being responsive and flexible as the frequency of this task may change. Initially, I will need it done daily for a week. Afterwards, it will be an as-needed basis for remote support. Experience in Performance monitoring, tuning, and database backup would be a bonus....
...specifics of the data extraction are as follows: - I require product details and price information from the site. - The main task involves capturing a comprehensive car database, including all car brands and models present on the site. The focus here is on the complete car directory, not just specific brands or models. If you have experience in web scraping, particularly in the automotive sector, this project is for you. Accuracy and completeness are key, as the success of the project hinges on the comprehensive nature of the dataset. I attached RAR file (Scraping code). by running this script, fetching yourself full database of cars. pocketbase queries to supoprt filters and run them on pocketbase server side routes, so that they can be used to feed data to views. (...
As the owner of this application, I am looking to significantly streamline its functionality and user experience. Therefore, I need a skilled professional who can accomplish the following tasks: Sub-Headings: - Login & Register Integration: The freelancer needs to merge the login and register functions for smoother navigation by users. - Feature Hiding: - Service Modification: The freelancer should modify the service that uploads data via MQTT. The primary tasks will be removing some existing filters and adding some new ones. Unfortunately, due to some constraints, I cannot provide specific details about which filters to remove, add, or modify. - Compilation: Finally, I need the freelancer to compile the revised application for TV apps as well Ideal Skills and Exper...
I am seeking an experienced graphic designer to create a logo that can enhance our professional image and stand out from our competitors that use stock standard logos. The attached examples are the two types of styles of the owners of the business that we would like to try to merge. We work on high end luxury car to muscle cars and would like this interpretation in our logo. Key details: - We want a modern, classy, yet fun design. Therefore, creativity and attention to detail are critical. - In terms of color, we prefer black and red with a possibility of some white in the mix. Ideal Candidate: - Graphic design expertise with a flair for modern aesthetics - Proven experience creating professional logos - Ability to interpret briefs accurately and deliver within deadlines. Your...
I'm looking for an experienced SQL Developer with a strong background in MS SQL and data warehousing. You'll be responsible for designing and optimizing a new database system. The project involves working with Microsoft SQL Server Analysis Services in an Azure SQL environment. Key Responsibilities: - Designing a new database system - Optimizing queries for better performance - Utilizing Microsoft SQL Server Analysis Services - Ideal Candidate: - Strong experience in database design and optimization - Proficiency in SQL, specifically with Microsoft SQL Server - Familiarity with data warehousing concepts - Experience with Microsoft SQL Server Analysis Services - Experience working in an Azure SQL environment - Expert coding skills in SQL coding - E,perince ...
I am looking for an experienced developer to set up an Airtable Database for me. This project involves creating a systematic way to handle, organize and manage our client information, employee management details, and project tracking. Key tasks include: - Setting up an Airtable Database - Enabling specific functionality such as data import/export - Custom form creation for easy data entry and extraction - Integration with other apps for streamlined operations Ideal Skills and Experience: - Proven experience in using and setting up Airtable databases - Strong understanding of data integration and manipulation - Familiarity with custom form creation - Experience with app integration for seamless data sharing - Knowledge in handling sensitive data with an emphasis on data ...
I am in need of an Excel relational database. The database should have the functionality to enter values automatically from an attached worksheet. The entry of these values will be based on specific criteria, more specifically, column values. Required Skills and Experience: - Strong knowledge and proficiency in Excel - Experience in database creation, management, and optimization - Understanding of data entry and data analysis - Proven experience in creating reporting capabilities within Excel. Using the "Reference data" tab, when the value in Column B is entered in the "Example worksheet" the corresponding values should automatically populate - Tariff code, Duty rate, CPF.
...Access developer to create a comprehensive database solution for my business needs. Key Project Details: - I require a robust database with more than 10 tables. - The database should feature data entry forms for easy information input. - It should have advanced error-checking capabilities to ensure data integrity. - Reporting and analytical functionalities are essential for tracking business performance and making informed decisions. Ideal Skills and Experience: - Proficiency in Microsoft Access and database design. - Strong track record of developing complex databases with user-friendly interfaces. - Experience in data validation, error checking, and report generation. - Excellent understanding of business processes and needs for effective database...
I'm currently in the process of creating a cost items database for residential electrical service items. I would like someone who has previous experience with similar work. I will need the database to be input into my management software called "Contractor Foreman". This database will need assemblies of materials assigned to each task. Key Requirements: - Cost estimates for lighting fixtures, electrical outlets, circuit breakers, and all other necessary items for a residential electrical service and remodel with adjustments for different types of condition that can e encountered. - A detailed breakdown of costs for each category is essential. - Extensive experience in providing accurate and reliable cost estimates for electrical systems is a must....
...reliable Python expert who can create a script that automates text extraction from specific PDF files and insert results into a PostgreSQL database. This tool is essential for a new automation process and accuracy is vital. The successful candidate will develop a script that: - Accepts a list of PDF objects (standardized format, example files will be provided) - Performs text recognition and extracts text from the listed PDFs - Inserts the extracted results into a PostgreSQL database In terms of output format, the extracted text needs to be integrated into a PostgreSQL Database. I'm open to suggestions on the specific table structure for this database. Should there be file reading errors or instances of unsuccessful text extraction, the script should...
...is flexible however the above requirements are non-negotiable. Applications that do not meet these criteria will not be considered, as well as applications that are submitted within 30 minutes of this task being posted - as this will indicate an automated response or insufficient understanding of the requirements. The Task We are in the process of creating a comprehensive English language database of literary quotations, either in native English or a reputable translation into English - from antiquity through to the 21st Century. We can supply a list of possible authors and require research into each of these authors, with the identification of key original or attributed quotations (maximum 250 words) in each case. The identification of quotation authors that lie outsid...
I'm in need of an experienced PostgreSQL Database Administrator to assist with a few key tasks. - Connecting to Database: I need assistance in establishing a connection to the database. This is a crucial task that requires a skilled professional who can set up the necessary configurations and ensure seamless communication between the database and applications. Your expertise in PostgreSQL is paramount, especially having worked with different versions (9.6, 10, 11,16). A deep understanding of database management and connectivity is essential, as well as experience in working with Windows as the operating system of the database. I need remotely to connect to database. Locally its working. is not properly set.
Scrape specfic business Email Database from google map and ther online directories
I'm launching a new fashion business and am seeking a talented freelancer to help me create and revamp both my fashion line and packaging. I have some ideas for themes and styles but need assistance in honing in on my targe...appealing to the defined target market. - Design innovative and sustainable packaging that complements the fashion items and stands out in the market. - Provide guidance on branding strategy to ensure consistency across all designs and packaging. The ideal candidate should have experience in fashion design, packaging design, and market research, with a portfolio that demonstrates an ability to merge creativity with market trends. I'm looking for someone who can not only execute my vision but also provide strategic insights to position my brand effect...
We are looking for a skilled database architect to design and manage the database architecture of our social media platform . The ideal candidate will have a deep understanding of database management systems and data modeling techniques. Feature in application : 1. User details 2. Upload a video feature like shorts and reels 3. Post a content like Linkedin 4. There are different types of video's category 5. Likes, comments, share 6. Other features Relevant skills for this role include: - Proficiency in database management systems in PostgreSQL - Expertise in data modeling and schema design - Strong understanding of database optimization techniques - Hands-on experience with SQL queries and performance tuning - Knowledge of database securit...
