Sql server on r jobs

I am currently using R, specifically the ppcor package, to conduct partial correlations on a sizable dataset. Unfortunately, the process is slow and fails to address all columns efficiently. I'm seeking assistance to: - Improve the computation speed - Enhance the handling of columns within my dataset The ideal freelancer for this task should be proficient in R programming, with specific experience in working with the ppcor package or similar tools for statistical analysis. A background in optimizing code for large datasets would be highly beneficial.

I'm experiencing an issue where my website isn't loading. Thi...where my website isn't loading. This problem has emerged recently, without me making any recent changes to the website or server configurations. I need a skilled professional to help me quickly troubleshoot this issue and get my website back online. Your role will involve: - Investigating and identifying the root cause of the website's failure to load - Resolving the issue effectively and efficiently - Ensuring the website operates smoothly post-fix Ideal candidates should have extensive experience in troubleshooting websites that run on Apache servers. Strong familiarity with PHP-FPM and Webmin will be a significant advantage. Your ability to identify and remedy server issues swiftl...

Hi Raquel R., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

I'm looking for a talented 2D animator who can create 3 engaging and entertaining videos, each lasting between 45-60 seconds. The primary goal of these videos is to captivate and entertain the audience. Key Responsibilities: - Develop 3 separate videos in a minimalist animation style - Ensure the videos are engaging and entertaining throughout - Incorporate the ready-made s...usp=sharing Video 3 - What happens when the MYGA guaranteed period ends: This is an excellent opportunity to showcase your creativity and animation skills. If you're confident in your ability to produce high-quality, engaging content in this style, then I'd love to hear from you. This could lead to on going work with us.

I'm seeking a Minecraft expert to help me set up a survival mode Minecraft server. Key Project Details: - **Survival Mode Setup**: The primary focus of this project is to create a distinctive survival mode suitable for a smaller player base. - **Unique Items**: I will need engaging, custom, and unique items for players to discover and utilize in the game. - **Crate Rankups Integration**: I also want to include a crate rankups system to add a layer of progression and reward for players. Ideal Skills and Experience: - **Minecraft Server Administration**: Experience in setting up and maintaining Minecraft servers is a must. - **Plugin Development**: Proficiency in developing Minecraft plugins is highly desired, specifically for creating custom items and integrati...

Please Sign Up or Login to see details.

I need a skilled Web Scraping specialist to write code in Python (preferably) that scrapes a specific table fro...write it to a CSV file (in the same column format). I'm a beginner level coder, and noticed that the table was created with that looks like a Shiny App in R. (I'm not even sure if extracting the table is possible). If it was only possible to use R, then I could potentially work with that. Website: I would like the data to go from the year 2020 to current. Regular Season data. Key Requirements: - Scraping Tables on websites If you're confident in your web scraping abilities, have good experience with Python, and can ensure accurate extraction of the specified player statistics from the table on the website, I'd love to hear fr...

We are in the middle of migrating Django to a new server. - Both servers run Ubuntu 20.04, postgres 12, python2.7 - The Django Project is already transferred over - Nginx has been configured - Postgresql has been setup Our struggle is to get the actual application up and running again. Your job will be to: - help to perform a clean export of the postgres database on old server - help to import the postgres database on the new server - ensure the Django application is coming back up smoothly The work will be done using shared tmate ssh sessions.

Hi Souvik R., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

I'm looking for an experienced developer to create a new cryptocurrency based on the Bitcoin blockchain platform. The ideal candidate should have a strong understanding of blockchain technology and the ability to develop a secure, scalable, and fast transaction processing system. Key features and functionalities: - Secure transactions: The new cryptocurrency should prioritize and ensure secure transactions to protect the interests of users. - Scalability: The network should be designed to handle a growing number of transactions without compromising its performance. - Fast Transaction Processing: To enhance user experience, the new cryptocurrency should be capable of processing transactions quickly and efficiently. Kindly note that I have no specific design or branding require...

I need a talented designer who can help me create a visually appealing home page on Shopify. My key focus is to showcase my brand identity. Required Skills & Experience: - Proficient in Shopify - Excellent design skills - Experience in creating a brand-centric homepage - Understanding of user experience principles I have a mockup created in Canva. I need it designed in Shopify for the home page Please include "I am a shopify expert and can do this" to be considered.

...issue with my IIS 8 server. Specifically, I'm unable to reflect image updates across the server. Key Requirements: - Troubleshoot IIS : You should be experienced with IIS and capable of identifying and resolving server-related issues. - Server Configuration: The problem may be related to server settings, so a deep understanding of IIS configuration and management is desirable. - File Management: The issue seems to be related to file update. You should have expertise in managing files on Windows servers and diagnosing related issues. - Image Handling: The problem specifically pertains to image updating. You should be well-versed in how servers handle image uploads and updates. Your task will involve: 1. Diagnosing the issue: Understand w...

I came across a minor issue on my website on Digital ocean cloud server. Refer the below error information. I need someone who can fix me immediately in an hour. Error 500 PleskExceptionDatabase DB query failed: SQLSTATE[HY000] [2002] Connection refused

I'm in need of a skilled Python developer to assist in creating a client-server application. This application will be responsible for handling data transfer and supporting information about bus and train routes. Key Requirements: - Expertise in Python and Socket Programming - Experience in creating client-server applications - Ability to work with and manipulate data Your responsibilities will mainly revolve around setting up a robust client-server architecture to support bus and train route data. I already possess the data, so the primary task will be focused on the actual programming and integration of the application. Experience in working with transport data or similar datasets would be advantageous. I'm looking for a professional who can deliv...

A business-centric, data-oriented, and analytical mindset. Comprehensive knowledge of data science concepts and disciplines. Knowl...technical architecture. Knowledge of database management systems, metadata management tools, cloud storage, and associated security considerations. . Combinations of experience and education will be considered on a case-by-case basis. Experience in data warehousing and governance. Practical experience in enabling data usability, availability, and efficiency. Experience in data management, quality, metadata management, and modeling. Knowledge of database systems: MS SQL Server, Oracle, or another commercial RDBMS required, Snowflake, or other non-relational database desired. Knowledge of SQL. Experience with scripting languages, esp...

I'm looking for an expert in Microsoft Power Apps to develop a c...gathering and insertion of information into a database. Requirements: - Incorporate text inputs, dropdown menus, and date fields for gathering information. - The preferred database language is Microsoft SQL Server but SharePoint can be used as an alternative. Additional Information: - You don't need to worry about any additional features or functionalities. The main goal is to develop a basic, yet effective form for data collection. Ideal candidates should have experience in: - Microsoft Power Apps development. - Integrating Power Apps with databases, specifically Microsoft SQL Server. You should be comfortable working independently and be able to deliver a high-quality, functio...

I need help to build Events based website, more details via chat

...help with the restoration of my server. I have experienced some issues with the server and after thorough review, I believe the best approach would be to restore the server data from a full backup. Key responsibilities: - Diagnose server issue(s): The tasks require the freelancer to identify the root cause of the server malfunction. - Conduct server restoration: The main task at hand is to effectively restore the server from a full backup. The ideal candidate should: - Have extensive experience in server restoration, with a specific focus on full backups. - Demonstrate a high level of proficiency in diagnosing and solving server problems. - Be able to work quickly yet effectively to minimize downtime and data loss....

I'm looking for an experienced Senior VLSI Backend Engineer to join our team. You’ll need to have extensive experience with RTL Design and Coding, and a strong handle on Logic Synthesis and Optimization, as well as Physical Design and Floorplanning. Key Requirements: - At least 5 years of experience as a VLSI Backend Engineer - Strong knowledge in scripting using TCL and Python - Hands-on experience with full RTL to GDS-II flow for complex designs - In-depth knowledge of Synthesis, P&R, and STA flows - B.Sc. / M.Sc. in Electrical Engineering from a leading institute Your role will involve collaborating extensively with our team, so strong collaboration skills are a must. Your role will be crucial in our overall product development and we need someone ...

I'm in need of a skilled professional to help me set up a high availability cluster for my web servers using Nginx. The primary goal for this cluster is to ensure load balancing, allowing for optimal performance across the servers. The ideal candidate will have experience in server clustering, particularly with Nginx, and will have a deep understanding of load balancing methodologies. You should also be familiar with high availability setups and be able to ensure a seamless failover process in the event of any server failure. The project will require a methodical approach and a strong attention to detail, ensuring that the cluster is set up correctly and is able to function effectively.

Hi Ahmad R., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

I am in need of a skilled animator to create a 3D promotional animation for my locker product. The target audience for this video is adults, so the animation should be informative and visually appealing to a mature audience. Key requirements and responsibilities include: - Creating a 3D animation styled video - Crafting the video with a primary focus on promoting the benefits and features of the locker product - Ensuring the video is engaging and attractive to adults Ideal skills and experience for this project: - Proficiency in 3D animation - Prior experience in creating promotional content - Understanding of adult audience preferences and visual aesthetics - Ability to deliver high-quality work within a specified timeframe If you have a portfolio that showcases your previous 3D...

...assist with creating interactive dashboards and generating data visualizations. The selected expert will be expected to work with data from both Excel spreadsheets and SQL databases, so experience with these sources is crucial. I will be looking for an advanced level of expertise, as the job will involve complex data modeling and designing sophisticated, interactive visual reports. A strong understanding of data analysis and visualization techniques is essential. Key responsibilities and qualifications include: - Creating interactive dashboards - Generating data visualizations - Working with data from Excel spreadsheets and SQL databases - Demonstrable advanced level of Power BI experience - Advanced knowledge of data modeling - Proficient in designing sophisticated, in...

I'm in need of an experienced SQL Server data warehouse designer to help with a project of integrating and consolidating data from different sources. Key requirements: - Expertise in SQL Server: You should be able to design, implement and optimize data warehouse solutions on SQL Server. Understanding data warehouse design principles is essential. - Data Integration: You'll need to work with some of our developers / power users to source data and establish automated integration; experience with integrating relational databases and APIs from web services is crucial. - Data Consolidation: You should be able to create a cohesive, consolidated dataset from these different sources applying appropriate design principles. - Medium-sized ...

Primary tasks: Initially this is all to be done on a new Linux STAGING ONLY server. 1) Linux staging server setup -> deploy our existing project to a new VPS using gitlab 2) Woocommerce -> continue long term development work on our existing custom plugin. Transfer the existing production woocommerce to this staging server. 3) ongoing long term development of our CRM app Other components of our stack which are a HUGE ADDED BENEFIT if you can work on them -> .NET ASP, WEB API + MS SQL DETAILS HERE -> PRIORITY IS TO HAVE A DEVELOPER ON OUR TEAM (LONG TERM) THAT CAN FOR NOW ALSO WORK WEEKENDS AS WE HAVE SEVERAL EMERGENCIES TO FINISH URGENTLY. Someone who can efficiently manage Linux VPS and efficiently use GITLAB...

...IS TO HAVE A DEVELOPER ON OUR TEAM (LONG TERM) THAT CAN FOR NOW ALSO WORK WEEKENDS AS WE HAVE SEVERAL EMERGENCIES TO FINISH URGENTLY. We will start with 5-10 small task in and then go to some smaller .NET tasks all with 1 day sprints for you to become familiar with the software and then our main goal will be to integrate another B2B API for our MVNO. Initially we need part of the hours to be worked in the first weeks from 8:00PM- 2:00am UTC -3 (Brazil Time) later you can work on your time zone. If you are awarded the task we expect you to accept IMMEDIATELY and if the project is not accepted immediatly we will award it to another developer. To qualify you must be full stack and work PROFICIENTLY with gitlab and code in ., .NET ASP, WEB API + MS SQL. We also ...

...is why I require your help/ Key requirements include: - Utilizing Fast Fourier Transformation and/or Wavelet Analysis to transform the raw temperature data. (Data is in the form of multiple .csv files with temperature readings and time stamps). Ideal skills for this project include: - Proficiency in Fast Fourier Transformation and Wavelet Analysis. - Strong command of R programming language for generating the output in R code. Maximum budget for this project is $100 USD. Required turn around will be approximately one week (the sooner, the better). Unfortunately I have had a lot of bad luck with people not completing the requirements/promised end result, so please only contact me if you fit the above brief and have the required skillset. Any automatic bids will be imm...

Background: King Faisal Hospital Rwanda (KFH-R) is a leading healthcare institution in Rwanda, renowned for its commitment to providing quality healthcare services to the community. In line with its vision for growth and expansion, KFH-R is transforming into an academic health sciences institution with a global impact, Africa Health Sciences University (AHSU). AHSU is an accredited institution that will train the next generation of health professionals across medicine, pharmacy, nursing and midwifery, laboratory technology, radiography, and other allied health professionals. Objectives The primary objective of this project is to develop a comprehensive branding strategy and implementation plan for Africa Health Sciences University (AHSU). The key objectives include: Develo...

Hi Moshiur R., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

Hello, We are F12Design, a platform where customers and designers come together and collaborate on graphic design projects. We would like to build an interactive dashboard to make the workflow simple and effective. Here are a few things on our mind: Languages - (Please free to suggest your own) Backend - PHP, jQuery, and SQL Frontend - HTML, CSS, and JavaScript For Real-time Demo/Example - Please sign up for and check their dashboard ########################################################## Social Login/Create account (Separate customer and Designer Login) ########################################################### Customer Dashboard Order Handling -------------- Past Orders Order Requirements (Quiz* and additional comments) Order Updates Order Delivery Date ...

I am in need of a skilled software engineer to develop a DICOM printer server software. This software should: - Be compatible with Windows operating system. - Have the capability to print to HP, Canon, and Epson desktop printers. - Support image printing and multiple printer use. Ideal candidates for this job should have strong experience in software engineering and a solid understanding of DICOM features. Familiarity with printer server software is a must, as is the ability to ensure compatibility with named printer brands and operating systems.

I'm searching for a professional who is proficient in SQL coding specifically for MySQL database design. PowerShell scripting or similar would also be beneficial. This is a basic level project taking existing Local government procedures and converting them into SQL based processes. An example of which would be creating a import procedure for traffic count data that is presented in a text format (example attached) Ideal Skills: - Experienced with MySQL Database Design - Well-versed in SQL coding - Ability to simplify complex instructions - PowerShell for anything not possible in SQL This project will demand creativity and intelligence to design procedures that simplify data entry processes. Please only bid if you can offer solutions according to the...

I'm looking for a detailed guide on how to get tweets using the RTweet library in R. Key points include: - Explaining the setup process of the Twitter Developer Account since I'm facing issues with access - A detailed, step-by-step guide on how to leverage the RTweet library for tweet lookup and analysis - Troubleshooting guidance for known issues Ideal skills: - Proficient in R programming language - Strong understanding of the RTweet library - Experience with Twitter Developer account setup - Ability to explain complex concepts in a simple manner - Troubleshooting experience with the Twitter API

I'm seeking a skilled SEO professional who specialises in on-page SEO to improve my website's performance. The primary focus of your role will be on keyword research and analysis, title tag optimization, and meta description optimization. As the website is catering to a B2B audience, having experience in this domain will be advantageous. Ideal Skills and Experience: - Demonstrated expertise in on-page SEO - Deep knowledge of keyword research and analysis - Ability to optimize title tags and meta descriptions - Proven experience in enhancing B2B digital presence Although the key objectives haven't been specified, you should have a clear understanding of how on-page SEO can assist in raising organic search rankings, web traffic, and conversion rat...

I'm looking for an experienced developer to integrate a payment plan feature to my website. Currently, I accept credit card and PayPal payments through PayPal gateway. The website is running on Shift4Shop. Key Requirements: - Implement a payment plan feature on the website that allows customers to choose 2 or 3 payment installments. - Ensure the payment plan is processed smoothly and securely, utilizing the existing PayPal payment gateway. The ideal freelancer for this project should have: - Proven experience in integrating payment plan features on e-commerce websites. - Proficiency in working with Shift4Shop and the PayPal payment gateway. - Strong understanding of e-commerce user experience and security considerations.

...program that will retrieve an xls file from an email inbox in order to geocode the addresses present in the file via the Google Maps API and insert the geographic coordinates into an SQL table. You can follow these steps: 1. Retrieve the xls file from the mailbox - cron every hour 2. Normalize the xls file for integration into a MySQL table 3. Configure access to SQL database from JavaScript. 4. Insert data into table via SQL query 5. Retrieve addresses to be geocoded from the SQL table. 6. Use Google Maps API to geocode each address. 7. Insert the geographical coordinates (latitude and longitude) in the SQL table. Each line in the xls file corresponds to a delivery. The file has 15 columns. The column names are, in order: Shipment, Rush order, Mo...

...Ability to upload, categorize, and access waivers as needed. • Invoices: Streamlined processing of invoices with links to respective contracts and project phases. • Material Receipts: Tracking of all materials received, including quantities, costs, and suppliers. • Miscellaneous Documents: Space to store and manage other project-related documents. 2. Year-To-Date (YTD) Tracker This module focuses on providing a comprehensive overview of the company's profit and loss by incorporating all projects and back-office expenses. Features: • Consolidated P/L Dashboard: Aggregates data from all projects and expenses to display a real-time profit and loss statement. • Expense Tracking: Management of back-office expenses including rent, insurance, advertising, ...

I need an expert in data entry, cleaning, and data visualization in RStudio. The primary goal of this project is to identify trends in a small dataset (less than 1,000 rows). Ideal Skills and Experience: - Expertise in data entry, cleaning, and visualization in RStudio - Strong understanding of R Programming - Proven experience working with small datasets with missing data - Ability to identify trends through data analysis Please only apply if you have demonstrable experience with RStudio and data analysis. The ideal candidate should be able to extract meaningful insights from data and present them in a clear and concise manner.

I'm in need of a SOCKS Proxy server as my ISP has closed port 25, which is essential for email services. Key requirements: - Set up a SOCKS Proxy server: The server's primary function will be to support email services. - Implementation: The server should be configured to support my email client. - Security: Ensure the server is secure and reliable. Ideal skills and experience: - Proficient in setting up SOCKS proxies. - Expertise in configuring services for email clients. - Knowledge of network security standards. The project might involve more tasks depending on the specific needs of the proxy server.

I need assistance with scraping data from a website and delivering it in an Excel file. The specifics of the project are as follows: I am looking for a person who will conduct scraping sessions for our business on a regular basis. Desired skills are knowledge of screen-scraper software, sql, Someone with Python knowledge will be better. Willing to follow instructions. Not cramped up with other jobs or other side hustles. Need to have solid internet connection. Expected work takes 5-10 hours per week, once fully trained. Must be responsible. Able to accept PayPal. - The source of the data is a website. This means the freelancer needs to have experience in web scraping. - The data should be delivered in an Excel file. Proficiency in handling and formatting data into Excel ...

Data Specialist: The Data Specialist is responsible for pr...information that is in databases, organizing and assembling the information so that teams can make decisions using data. Responsabilities: > Access database. > Create dashboards and analysis according to the demand of the business areas. > Update and automate dashboards that need frequent updating. > Provide suggestions of improvements in business areas. Requirements: > Mandarim is a must > SQL > Office Package > Database usage At Shein, we believe that diversity is the force that drives innovation. We are committed to creating an environment where all voices are heard, valued and respected. All our vacancies are inclusive for people with disabilities, women, black people, LGBTQIAPN+ com...

Hello, I need a quick fix for my DNS server running on a 2012 R2 system. The major problem encountered is that I'm unable to access my shared files. However, I can ping the IP addresses of the devices hosting these shared files. An RPC Error is shown and some Group Policy issues occur when trying to access these files. • I need someone who understands DNS thoroughly. • Experience with Server 2012 R2 is necessary. • Knowledge of RPC errors and Group Policy is required. Would appreciate quick and effective troubleshooting. Thank you!

...in Azure Data Factory (ADF) development, SQL, Power BI, and ADF monitoring. Key Tasks: - Creating data pipelines - Building data transformation workflows - Integrating with SQL databases Power BI Usage: - Visualizing data through interactive dashboards - Creating data reports and analytics - Real-time monitoring and alerts ADF Monitoring: - Tracking data pipeline performance - Monitoring data integration processes - Setting up alerts and notifications for job failures. Ideal Skills and Experience: - Expertise in Azure Data Factory (ADF) development - Proficiency in SQL, Power BI, and data visualization - Strong background in monitoring ADF performance - Experience setting up real-time alerts and notifications - Proven track record in working on data tran...

I'm seeking an independent ASP.NET developer based in India with at least 5 years of experience, strong C# programming skills, and familiarity with SQL Server and Asp.net core. Your English skills will be crucial as direct communication with me is required. Key Responsibilities: - Develop a robust business management system leveraging ASP.NET - Implement user authentication and authorization features - Integrate appropriate APIs to enhance system functionality Ideal Candidate: - Minimum 5 years experience in ASP.NET development - Proficient in C# programming and SQL Server - Familiarity with Asp.net core - Experience in developing business management systems preferred - Strong communication skills for client call Please note that this project is only ope...

...clutter-free, and highly informative website in the agricultural bio-chemical industry. The website will consist of 5 pages and must include information on crop protection, soil health, research and development, news timeline and crop yield. Key Features: - Infographics: aesthetically pleasing and informative - Video on landing page: showcasing the beginning of an exciting journey. The option to view the video must be available. - Press release Timeline: this will serve as the news timeline. Key Sections: - About Us: this section should introduce our company and its mission. - Services: a comprehensive list of services that we offer. - R&D / USF Connect: this is our research and development section, providing insight into our ongoing projects and collaboration...

I'm looking for an experienced individual to help me set up a VPN server on my TP Link Omega E707, running Windows OS. The primary goal of this is to allow secure remote access to my home network. Key Requirements: - Set up a VPN server on a TP Link Omega E707 running Windows - VPN server must be accessible outside my network - Ensure security and privacy in the VPN configuration - Establish a reliable connection method for remote access The ideal candidate should have: - Proven experience in setting up VPN servers on TP Link routers - Extensive knowledge of Windows OS - Understanding of network security and remote access protocols. Please note that my TP Link Omega E707 has a dynamic IP address.

I need a professional SEO expert to optimize my website in order to improve our search engine rankings on Google. - The main goal for the project is to increase organic traffic and visibility on Google. - I have a list of specific keywords and phrases that I would like to target. - The work is urgent, so quick and effective execution is essential. Ideal Skills and Experience: - Proven track record of successful SEO projects, especially on Google - Expertise in keyword research and optimization - Ability to implement and execute strategies quickly, with a focus on achieving results in a timely manner. Please include any relevant past projects or case studies in your application.

...this integration is to offer users the ability to make voice calls directly through the platform. Key Requirements: - Implementing Telegram VoIP for seamless voice communication - Focused on making the feature user-friendly - Web-based platform The project's primary goal is to introduce a voice calling feature that is both easy to use and reliable. Hence, your expertise in Node.js and experience with TDLib will be vital. The ideal consultant will understand the nuances of VoIP technology and be able to seamlessly integrate it with our existing web application. Your role will be to provide guidance on the integration process, ensuring that the end product meets the needs of our users. Any prior experience in similar projects or a strong understanding of VoIP and ...

...specialist who could coach me in the areas of Data Analysis and Data Visualization. The role may also involve programming. Key points: - Coaching: I need 1/1 coaching via Teams on Data Analysis & Data Visualization within Azure Analytics - Programming: If the opportunity arises, the candidate could get involved in programming using SQL - Proficiency: I consider myself at an Intermediate level with Azure Analytics Ideal Skills and Experience: - Proficient in Azure Analytics: You should have a strong understanding of Azure Analytics, specifically in Data Analysis and Data Visualization - SQL Programming: Experience with SQL is a must as you may be involved in programming for this project - Teaching or Coaching Experience: Prior experience in teaching or c...

Hi Yuriy R., I noticed your profile and would like to offer you my project. We can discuss any details over chat.