Project sql server jobs
I'm seeking expertise to backup and upgrade my current Asterix server for several critical reasons. This project aims for disaster recovery preparedness, system scaling capabilities, and facilitating a smooth transition into a testing and development environment with an upgrade to a newer version of the system. Real-time synchronization between the original and the newly system is a must to ensure operational continuity and data integrity. **Core Project Requirements:** - duplicate the current Asterix server. - Ensure the duplicate is upgraded to the latest system version for improved performance and features. - Implement real-time synchronization between the original and upgraded servers. - Specific data required to be backed-up and perfectly synced inclu...
I'm in urgent need of an experienced server manager who can provide monitoring services on AWS specifically. Your tasks will involve: - Monitoring server activity - Managing server security - Deploying jobs on Node.js and Angular I'm particularly interested in someone who can supervise performance metrics, system logs, and put in place alert systems as needed. The required skills for this task include: - Deep knowledge of AWS - Proficiency in Node.js and Angular - Experience in system logs and alert systems The timeline for this project is urgent, therefore I'm looking for someone who can begin immediately. Please provide examples of similar works you've completed related to AWS, Node.js, and Angular.
...into a SQL SharePoint database. The purpose of the database is to track inventory. We are looking to put into a web based format which can be searched, and have links to each category, as well as export results to excel and pdf. Each item will be able to be edited, and deleted. - Ideal Skills and Experience: - Proficiency in Excel, SharePoint, and SQL - Experience with SharePoint and database management - Strong attention to detail and ability to accurately convert data - Knowledge of inventory tracking systems is a plus SEE ATTACHED The database should have a specific structure or format as per my requirements. I have a clear idea of what I want, and I need someone who can create it accordingly. If you have the necessary skills and experience, and can comple...
...specializes in Ubuntu servers. My primary goal is to optimize my server for web hosting, ensuring it runs smoothly and securely. Here's what I need help with: - **Server Setup and Configuration:** Configure the server for optimal performance in hosting web applications, including Apache or Nginx setup, PHP configurations, and any other necessary software installations. - **User Management and Permissions:** Establish a secure and efficient user management system. This includes setting up different users for different tasks, assigning appropriate permissions, and ensuring that only authorized users can access certain files and directories. - **Security and Firewall Management:** Implement robust security measures to protect the server from unauthorized...
...with connecting a SQL view to my Access database using ODBC. Despite successfully linking tables, I'm unable to establish a connection to the view. The core of this project involves diagnosing and fixing why this connection isn't happening, ensuring that data can seamlessly flow into Access from the SQL view. **Key Requirements:** - **Diagnose Connection Issues:** Identify why the ODBC connection to the SQL view isn't established. Investigate if it's related to the view itself, the ODBC setup, or another underlying issue. - **ODBC Expertise:** Deep understanding of ODBC (Open Database Connectivity), including setup, troubleshooting, and configuration. Familiarity with the latest ODBC drivers is essential. - **SQL and Access ...
I'm seeking a freelancer with solid experience in managing and enhancing Mailcow email servers. My server is already in place, but I need expertise to improve its performance and security, focusing on a few critical areas. It's essential for my project that you have in-depth knowledge of Mailcow, email server administration, and a proven track record in handling similar tasks. **What I Need:** - **Email Traffic Monitoring:** Implement tools or practices that allow for the real-time monitoring of email traffic. This includes identifying potential threats or abnormal patterns. - **Strict Sending Policies:** Establish rules that control email sending practices to prevent abuse and ensure compliance with email sending standards. - **Feedback Loops Engagement:** ...
I am in need of an experienced SQL developer who can assist with data extraction using Microsoft SQL Server. Your job will not only involve writing advanced SQL queries, but also ensuring they pull the precise data as per our expectations. Key skills and experience desired: - Deep knowledge of SQL queries - Proven experience in data extraction - Familiarity with Microsoft SQL Server You should be able to understand the specific data we need and deliver the results efficiently and accurately. Experience in data extraction with SQL Server is a key requirement for this role.
LibreTaxi is an open-source transportation system that allows you to set up your own ride-sharing platform. Here are the basic steps to configure and install the LibreTaxi system: Step 1: Server Configuration - Choose a hosting provider or a server where you want to install LibreTaxi. - Make sure the server meets the minimum requirements to run LibreTaxi, such as Node.js version, database, etc. Step 2: Installing Node.js - Install Node.js on your server. You can follow the instructions on the official Node.js website to do this. Step 3: Download the Source Code - Download the LibreTaxi source code from the official GitHub repository. Step 4: Database Configuration - Configure the database that will be used by LibreTaxi, for example, MongoDB. Step 5: System ...
I require a skilled professional who can assist in connecting to SQL Server 2019 through an IP address specific for a testing environment. The preferred connection method is TCP/IP. Key Requirements: - Extensive knowledge on SQL Server 2019 - Proficiency in setting up TCP/IP connections - Experience in configuring server in a testing environment Your role will consist of guiding me through the process step by step, ensuring the system works correctly without causing any issues. Successful completion of this project may lead to future collaboration.
...Check-out page: 5. Create a virtual purchase page of the cart products where users have to enter their card details to make the purchase. NO NEED TO REAL CONNECTION WITH A PAYMENT GATEWAY Overall Appearance: 6. Add CSS elements for improved user experience. System Data: 7. System data (products, customers, shopping carts, purchases) will be stored in a relational database (choose from: MySQL, or SQL Lite). Dynamic content generation: 8. For dynamic content generation there is a choice between ASP and PHP. (PHP preferred) Notes: ➢ Products must be organized into categories. ➢ Add categories to the navigation menu for quick access. ➢ Make sure pages are linked correctly. ➢ Tasks will be demonstrated (operation and development). ➢ Suggested options: PHP for dynamic content,...
I urgently require a skilled Linux professional to help create links for a complete system backup from our server, enabling us to download it externally. We lost our sysadmin unexpectedly, and currently without any specific systems or software for server backups. Key Responsibilities: - Creating links for a complete system backup of our Linux server - Ensuring that we can download these backups externally Ideal Skills and Experience: - Proficient in Linux - Experience in creating complete system backups - Ability to educate us on how to access and manage these backups Whilst this role is currently a one-time task, the opportunity may present itself for more consistent work in the future.
I'm embarking on a personal project called BookHub. It will serve as a platform for avid book readers where they can explore book recommendations, create their own user profiles, and even take notes. As such, I'm seeking a web developer with solid experience in creating interactive and user-friendly websites. Key responsibilities for this role include: - Building a feature that offers book recommendations. - Developing a detailed user profile section. - Integrating a note-taking feature. Ideal skillset: - PHP, HTML, CSS, and JS. - Strong UX/UI design skills. - Fluent in SQL for managing user data. - Familiarity with note-taking software integration would certainly be a bonus.
...their session / cookies for future login so that we don’t need to relogin the ids, this can be through Curl Bash / API or through Opening Chrome Window (Chrome Driver) Task # 1 (Fetching All Order Details & Download Invoices + Packing Slip) 1. Lets say we have the session for 200 ids saved in Step#1 , we will input some 50 ids for which we want to fetch order details in Excel / Google Sheet / SQL Format ( whichever you are comfortable with), you script will fetch the order details for all these 50 ids through API / cURL (Bash) or any similar backend technique NOT USING CHROME / CHROMEDRIVER CLICK BY CLICK 2. Now we want invoices & Packing Slip for say some 100 orders , we will provide the login ids ( which are already login & session saved) the tool should dow...
I'm looking for a skilled web designer to create a sophisticated website designed to cater to the general public. The ideal candidate should be proficient in , SQL, Tailwind CSS, and Prisma, with a strong portfolio showcasing a blend of creativity and technical expertise. Key Requirements: - Extensive experience in for front-end development. - Proficiency in SQL for database management. - Mastery in Tailwind CSS for custom, responsive designs. - Familiarity with Prisma for seamless database integration. - Ability to implement interactive animations that enhance user engagement. - Expertise in creating responsive designs that adjust seamlessly to different devices, ensuring a fluid user experience across all platforms. - Capability to develop user-friendly navigation th...
...fully developed website to an Internet Information Services (IIS) server. My primary goal for this project is to test the website's functionality and performance on a different server environment before making it live for public access. I believe testing on an alternate server will provide insights into any potential issues or areas for improvement. **Requirements & Qualifications:** - Proficiency in IIS server management and deployment - Strong background in web development and understanding of web architecture - Experience with troubleshooting and resolving deployment issues - Ability to ensure the website's performance is optimized for the IIS environment **Project Overview:** - Deploy the fully developed website to an IIS ...
I'm encountering sluggish performance issues with my Linux server, primarily used for hosting web server applications. This has become a bottleneck, affecting the efficiency and reliability of the services it hosts. The problem must be addressed promptly to ensure smooth and efficient operations. **What I Need:** - Comprehensive analysis and optimization of the server to boost performance. - Effective strategies to reduce resource usage, preventing future slowdowns. - Proactive measures to minimize the risk of downtime, ensuring continuous availability. **Skills and Experience Required:** - Proficiency in Linux server management, with a focus on performance tuning. - Strong background in hosting and optimizing web server applications. - The capabil...
...in frameworks that support both iOS and Android. Experience with React Native, Flutter, or a similar technology is ideal. - **E-Commerce Expertise:** A strong understanding of e-commerce principles, including shopping carts, payment gateway integration (e.g., PayPal, Stripe), and secure checkout processes. - **Database Management:** Skills in managing extensive product catalogs. Familiarity with SQL or NoSQL databases to handle both physical and digital inventory. - **User Interface Design:** The ability to design intuitive, engaging user interfaces that enhance the shopping experience. A portfolio showcasing previous e-commerce projects is beneficial. - **Security Measures:** Knowledge of implementing robust security protocols to protect user data and transactions. **Ideal Skil...
I am looking for a proficient server engineer with specific skills in Cloudflare and IP address configuration, as well as SSL/TLS configuration. The primary objectives of this project are: - To bolster my website's security - To increase the performance of the site The ideal candidate would have: - Extensive knowledge and experience with Cloudflare configuration - Proficient in the process of IP address configuration - An understanding of SSL/TLS configuration My website is built on WordPress, so experience with this platform would be beneficial for the completion of this project. Enhancing the security and performance of my site are crucial factors, therefore a clear understanding of these areas is necessary. If you have experience in mitigating DDoS attack...
...efficient data management and report generation. Requirements: - Experience in Visual Basic and VB.NET. - Proficient in SQL for robust data management. - Skilled in designing user interfaces that are both practical for business needs and visually engaging. - Ability to implement moderate customization with some unique design elements to provide a semi-personalized user experience. - Understanding of the best practices for UI/UX design, particularly in applications intended for business professionals. Ideal Skills and Experience: - Proven track record in developing applications in VB.NET with a strong portfolio showcasing user interface design. - Strong experience with SQL database integration and management. - Experience in creating visually appealing design elements wh...
I require an expert in VPS servers to carry out the necessary DNS configurations for 2 websites. The job entails correctly configuring the DNS and ensuring that they synchronize properly with the domain administrator. We migrated the websites to the VPS, but when we changed the name servers in the domain administrator, they are not recognized because they somehow do not point to any IP address.
I'm seeking an IT expert who can assist me with transferring my small sized Wordpress website (less than 1GB), complete with a SQL database (MySql), from a shared hosting server to another shared hosting solution. The successful freelancer must be proficient in: - Wordpress and SQL (MySql) database management - Shared hosting environments - Server migration The candidate must showcase diligence and attention to detail to ensure smooth switchover with minimal downtime, retaining full website and database function. Please detail your previous experience with similar projects in your proposal.
I need an angular app to show some statistics supplied by .net api to be displayed in angular ui. I will Provide the sample JSON of how data might look like. Also I will provide a dummy sql which will provide the data so that api can use and built api. Most importantly, I need this data to be pushed to UI on periodic basis using SignalR
Project Description We are an emerging data store aiming to build the largest database in our sector. Our initial project focuses on extracting data from multiple websites, starting with Commonwealth Plywood's site in both English and French versions. This project will potentially be the first of many, as we plan to expand our database with more sites in the future, depending on the outcomes of this inaugural mandate. Technical Details - Objective: Extract all available data for each product listed on the English and French versions of the Commonwealth Plywood site. Data includes but is not limited to: Product categories and subcategories, suppliers, photos, product codes, color numbers and names, collections, descriptions, documents, etc. - Technology: No specif...
...in cybersecurity. - Solid understanding and experience in web application development. - Knowledge of common web app security threats (e.g., XSS, SQL Injection, CSRF). - Experience with implementing user authentication, data encryption, and access control in web applications. **Requirements:** - Develop and integrate TensorFlow AI models to identify and mitigate security threats in real-time. - Ensure the upgraded security measures cover, but are not limited to, user authentication, data encryption, and access control functionalities. - Propose and implement proactive security solutions to prevent common and emerging security issues such as XSS, SQL Injection, and CSRF. - Provide detailed documentation on the security enhancements for future maintenance and updates. Whil...
...Check-out page: 5. Create a virtual purchase page of the cart products where users have to enter their card details to make the purchase. NO NEED TO REAL CONNECTION WITH A PAYMENT GATEWAY Overall Appearance: 6. Add CSS elements for improved user experience. System Data: 7. System data (products, customers, shopping carts, purchases) will be stored in a relational database (choose from: MySQL, or SQL Lite). Dynamic content generation: 8. For dynamic content generation there is a choice between ASP and PHP. (PHP preferred) Notes: ➢ Products must be organized into categories. ➢ Add categories to the navigation menu for quick access. ➢ Make sure pages are linked correctly. ➢ Tasks will be demonstrated (operation and development). ➢ Suggested options: PHP for dynamic content,...
The booking API is not working on the demo because of the HTTP, so Install SSL certificate on Demo site
I am seeking a webpress developer to fix issues with our website. This issues mainly pertain to errors and performance. ...during interview/chat Applicants should come prepared with: - Examples of previous work and roles in IT. - A comprehensive project proposal and timeline. - Descriptions of relevant experiences. It's essential that applicants have proficiency in: - PHP - Java - SQL - WordPress - API - Plugins - Web server maintenance - Hosting - SEO Familiarity with JavaScript and Python will also be beneficial. This is a role for those with comprehensive tech experience looking for an exciting and challenging opportunity. Note: 1. Strictly only business within platform. 2. We are well-known NGO in globally. 3. Successful candidate will have high chance ...
In this project, we need a skilled developer experienced with jQuery and JavaScript to enhance the user interface of an application and implement form validation. They must have experience in , Microsoft core and wijmo widgets - jQuery/JavaScript Tasks: * Form Validation: Implementation of form validation to ensure precision and accuracy of data entries. We are looking for a skilled JavaScript developer who is experienced in using jQuery and Microsoft Core. The main task for this project is to set up a relational database and create tables to store data. The developer should be able to add data to the tables and ensure that the database is properly structured. The ideal candidate should have experience in creating relational databases and be familiar with JavaScript and...
I'm seeking a proficient Python programmer to optimize our current sequenced production plan. The main objective is to minimize production time. Work entails: - Und...Python script capable to conduct data manipulation using libraries. Key Requirements: - Python scripting at an intermediate level, exhibiting proficiency in library utilization and data manipulation techniques. - Prior experience working on production plan optimization or similar projects. - Familiarity in working with SQL databases as an integration will be required. The end result should be an optimized, efficient production plan that is able to synchronize with our existing SQL databases. Your expertise will contribute massively towards improving our operational efficiency. Looking forward to an ef...
I need a Laravel developer, adept at database handling, specifically to add a new text column in the "Orders" table of my application's database. This new column will be primarily used for recording special instructions associated with each order. Required Skills and Experience: - Proficient in Laravel PHP Framework - Strong understanding of database principles and SQL. - Previous experience adding new columns or modifying database structure positively looked upon. Tasks Involved: - Add a new text column in the Orders table. - Ensure that new field functions correctly for recording and reading special instructions. Please ensure your bid includes estimated time for completion and any previous experiences you have with similar tasks.
I need an experienced AWS Data Engineer to develop a robust data warehouse for moving data from Sql Server to S3 using AWS DMS. Then from S3 to Redshift. The data, which is currently in CSV files, will need to be efficiently imported into AWS. The ultimate aim is to enable seamless analytics and reporting from the data warehouse. Ideal Skills and Experience: - Proficiency in AWS data warehousing - Strong experience with CSV files - Prior experience with Sales Data highly preferred - Clear understanding of data warehouse design and architecture. - Proficiency in AWS DMS , AWS S3. - AWS Email Notification.
I'm in need of a skilled Python developer with Flask and PostgreSQL experience to expand the capacities of my current system. I'm looking to add features aimed at fortifying customer management, search capabilities, and product management. Existing code is written with Raw SQL using psycopg2 driver to integrate with Flask. Contractor should be able to do the database work without an ORM. Your responsibilities would be: Customer Management Features: * Addition of contact information feature. * Inclusion of a notes or comments system. Boosting Search Capabilities: * Must be able to implement searchability by customer name and keywords. Product Management: * Adding and managing products in the database. * matching of products and customers - Need to be able to Save Que...
We have currently an outdated Odoo installation and Ubuntu Server with 18.04 LTS, which both should been updated. We don't know the exact version of Odoo, but we think it is version 11. It seems not to be installed directly in Ubuntu, but instead installed maybe in a Docker Enviroment. The Server itself is installed in a VM with VM Ware. We are looking for a profi here, who can do the update task, for Odoo to the newest version, and Ubuntu 18.04 to the version 22.04 LTS. The work will be done with AnyDesk, so we can see, which steps will be taken.
Project require to pull the data from ZOHO Books application various table and populate in SQL database and present them into Google looker. Skills: 1. Java script 2. SQL 3. Google looker 4. Google looker analytic is an added advantage as second part of the project is creating various dashboards from ZOHO Books data.
I'm in need of a seasoned C# developer to bring a fresh perspective and new functionalities to our project's user interface. The project is focused on not just enhancing the look but also the efficiency and user interaction with our applications. Key Requirements: - Proficiency in C#: Your experience in developing new applications using C# is crucial. - Debugging Skills: The ability to quickly identify and fix bugs in existing code is essential. - SQL Knowledge: You should be well-versed in integrating and managing database systems with SQL. - UI/UX Focus: The primary goal is to update and elevate the user interface, making it more intuitive, engaging, and visually appealing. Ideal Skills and Experience: - Strong background in C# application development, wi...
I'm searching for a qualified Linux expert to set up an LLM system on my existing Ubuntu server. This will be used to facilitate local chat with various document types such as PDFs, DOCX, etc. Key Responsibilities: - Set up a system for threaded discussions. - Enable features for asking information about long docs. - Creating document summaries as needed. Ideal Candidate Skills: - Proven experience with Linux server setup, specifically Ubuntu. - Understanding of LLM systems and their features. - Ability to enable highlighting, summarizing, and direct questioning about specific points in documents. Goal: To efficiently manage documents, and encourage real-time team collaboration and effective communication. Please apply if you have requisite skills and experience. ...
I'm looking for a animator who can create short youtube videos for the IT courses , like SQL SERVER SQL,Data Science , SDET ..etc
I Am Looking For A Game Developer That Has Experience With Poker Games And Slots. I Need Him To Help Me Upload The Game To A Server And Help Me Fix It. Server Code Has Bugs And Game Keeps Stopping Also I Need Him To Help Me Build A Game For The Play store Game Its Build On Unity I Will Need The Developer Also For A Future Updates Please If You Have No Experience With Poker Games I Am Asking Kindly Not To Text Thank You
Experience in setting up Linux servers is a must, as well as an ability to work within a flexible timeline. If you're up for the challenge, please send your proposal! If you know you are expert in the said subject matter,Kindly place a bid to discuss further about the project
I am currently at an intermediate level of SQL and am hoping to find a specialist that can help me to solidify my knowledge in preparation for an interview I have on Monday. I'd particularly like to focus on: Non Academic SQL It's important that this is completed in the next 2 days. Ideally, the tutor has a deep understanding of these topics and can offer tips for presenting my knowledge and skills during the interview process.
...with the migration of my medium-sized SQL Server database, which is currently between 1 and 10 GB, to SQL Server 2022 Express. This project will require careful planning and execution to ensure a successful transition with minimal downtime and data integrity preservation. **Ideal Skills and Experience:** - Proficiency in both the source (SQL Server) and target (SQL Server 2022 Express) platforms. - Extensive experience with database migration projects, particularly those involving SQL Server. - Strong understanding of database structures, theories, principles, and best practices. - Ability to troubleshoot potential issues during the migration process. - Familiarity with data security measures to protect sensi...
I am seeking a skilled freelancer with experience in database migration, specifically with SQL Server, to help my organization reduce operational costs through the strategic movement of our large database, which is over 10GB. This project aims not just to move data, but to do so in a way that leads to a significant reduction in costs without compromising on performance or scalability. **Requirements:** - Expertise in SQL Server and knowledge of cost-effective database solutions. - Experience in migrating large databases (10GB or more) with minimal downtime. - Ability to optimize the migration process for cost without sacrificing quality or data integrity. - Capacity to provide strategic recommendations for hosting solutions that offer reduced costs. - P...
in my PHP file i have some MY SQL QUERIES and some JOINS i need to add in another JOIN (not sure if its left or right) there is one more data point from another table that needs to be considered in order to display meaningful data. URGENT JOB PLEASE HELP NO TIME WASTER
After upgrading my server's MySQL to 8.0, it has failed to start. This predicament is currently happening on a Linux-operated system. I have identified that the error might be a result of an issue in /etc...to start. This predicament is currently happening on a Linux-operated system. I have identified that the error might be a result of an issue in /etc/my.cnf. I will provide the related error messages and logs for better diagnostics. I'm looking for a professional with: * Extensive experience in Linux system administration. * Profound knowledge in MySQL server management, specifically version 8.0. * Expertise in diagnosing and rectifying server start-up errors. * Ability to review and modify MySQL configurations if necessary. Hope you could help me solve this p...
...knowledge of xAPI and LRS Server development in Moodle on a Linux server in the cloud. Here's what I need you to help me accomplish: - Integration with Moodle LMS: Your primary task will be to establish a seamless connection between our Moodle LMS and an xAPI/LRS server. Your expertise in learning management systems and server configuration is absolutely crucial in this regard. I have not installed the correct Moodle xAPI plugin yet, but I can do this. I need someone to create the LRS on a new server instance for me. I already have the server created. I have installed Node.js but I could not get MongoDB installed yet, I will need help doing that. - Data Transfer: Additionally, I require a system that can transfer learning progress data b...
in my PHP file i have some MY SQL QUERIES and some JOINS i need to add in another JOIN (not sure if its left or right) there is one more data point from another table that needs to be considered in order to display meaningful data. URGENT JOB PLEASE HELP NO TIME WASTER
...experienced systems administrator for a web server deployment on a Proxmox platform. Specific requirements are as follows: * Knowledge in setting up and configuring Proxmox. If you have any certifications, this would be a plus. * Experience in configuring web servers for scalability. You need to ensure that the server can handle an increase in traffic over time. * Experience in tracking and projecting traffic trends for forecasted capacity planning. We expect a gradual increase in traffic. This role is not just about setup, but also about ensuring the smooth running of the system, troubleshooting any issues, and maintaining the server for optimal performance. The ideal freelancer would be someone with a good understanding of Proxmox, web server deploymen...
I am in need of a comprehensive data analysis project focusing on both descriptive and diagnostic analysis methods. The goal is to derive actionable insights from various data sources, including our internal company data, social media interactions, and extensive market research. This project requires a meticulous approach to sift through data, identify trends, patterns, and underlying issues that could affect our business strategy and decision-making processes. Key Aspects of the Project: - **Descriptive Analysis**: To provide a clear picture of our current data state. This includes summarizing the data collected from our internal operations, social media, and market research to create a snapshot of our market presence and operational efficiency. - **Diagnostic Anal...
I am in search of an experienced IT professional with skills and knowledge in the deployment of Windows web server that interfaces with MySQL. The specifics include: - Proficiency in Windows Operating System: This is key as the platform of choice is Windows - Expert knowledge in MySQL: As the database to be used is MySQL, a proven knowledge in this field is required to guarantee seamless interaction between the web server and the database. - Experience in managing servers with low traffic: The web server is expected to handle low traffic (below 10,000 visitors per day). Consequently, your bid should reflect your capacity to deliver with this requirement in consideration.
