Sql server 2008 project jobs
Task Description: Develop a small software script or tool that allows a user without administrator privileges to check who has write access to a specific file on a shared file server within a Windows Server 2019 domain environment. Current Process: When a file on the shared server is open in "read-only" mode (indicating another user has it open with write access), I currently have to ask our IT administrator (who has full permissions) to identify the user with write access. The administrator uses Remote Desktop to connect to the server, then navigates to "Computer Management," selects "Shared Folders," and checks "Open Files." Based on the file path I provide, he can see which user currently has write access to the file....
installation of server and transfer of 44 sites
I'm looking for an experienced professional to install WinSCP as my FTP server software on a Windows VPS hosted on Amazon Web Services. The main requirements for this project are: - Installation of WinSCP FTP Server software: I Dont a preference , so the successful candidate will need to have experience with this specific software. - Configuration of FTP Accounts: I need a single FTP account set up with 'Read and Write' access control. This account will not be full administrative, but it will need to be able to both read from and write to the server. Ideal skills and experience for this job include: - Extensive knowledge of AWS and Windows VPS - Proven experience with FTP Server software - Strong understanding of FTP protocols and config...
Please read the project description carefully before applying Hello everyone, I'm seeking a developer to work with on setting up a Multimodal RAG (Retrieval-Augmented Generation) server using LangChain, with SharePoint integration for real-time data access. This project should include thorough documentation, as my goal is to understand the process so I can do it myself. The Multimodal RAG server should support reading and storing PDFs and DOCX files (including embedded images) for future use. Here’s a helpful guide for multimodal RAG with LangChain: @shravankoninti/multimodal-rag-with-gpt-4-vision-and-langchain-60a6a13a92e4
...user-friendly, and scalable. Key Responsibilities: MVP Development: Lead the design and development of our AI collaboration and governance platform MVP. Translate product requirements into functional, high-quality code. Full Stack Development: Work on both front-end (React, JavaScript) and back-end (Node.js, Python) development tasks. Develop and maintain robust APIs and database systems using SQL. Technical Leadership: Contribute to architectural decisions and technology choices that will shape the platform's future. Implement best practices for security, performance, and scalability. Collaboration: Work closely with the product manager to brainstorm ideas and implement new features. Communicate effectively with senior executives to align technical solutions with busines...
I'm looking for a skilled UI developer to create a web-based interface for our existing business's SQL Server database. The main emphasis of this project is on real-time data visualization. Key Project Requirements: - Design a user-friendly web interface: The interface should be well-structured, easy to navigate, and visually appealing. - User can select from multiple input fields as show in the attached image, all of these are optional. - SQL will be provided, but you will need to convert it in python or any other language you are using. - Develop real-time data visualization tools: The primary goal of the interface is to provide real-time data visualization. This means that data should be presented in a way that allows users to quickly and ...
Our ERP application, built on .NET Windows and SQL Server, requires immediate maintenance and bug fixing. The primary focus will be on database procedures and code modifications. We are facing daily stored procedure errors and performance slowness, impacting our operations. Key Responsibilities: - Troubleshoot and resolve stored procedure errors - Enhance the performance of the database procedures - Make necessary code modifications in the application and database level Ideal Skills and Experience: - Strong expertise in .NET Windows and SQL Server - Proven experience in ERP application maintenance - Proficient in troubleshooting database procedures - Ability to enhance performance of SQL databases - Strong coding skills for .NET applications - Ab...
My Linux based web application is currently down due to a revoked server side certificate. I need an expert who can quickly download and install a free server side certificate to get my application back online. The server runs Apache. This task should be straightforward and swift. Further details will be provided once we agree on the terms. Ideal Skills and Experience: - Expertise in Linux and Apache - Proven experience in server-side certificate installation - Quick problem-solving skills - Ability to work under pressure - In-depth knowledge of SSL/TLS protocols Please use Let's Encrypt for the certificate.
...I'm looking for a detailed, realistic Discord server logo, with a fantasy theme. The design should include a Hytale Void Dragon and the name of my server, "Ketera". Ideal skills and experience for the job: - Strong graphic design skills, particularly in creating detailed and realistic images - Experience with designing logos, specifically for Discord servers - A good understanding of the fantasy genre and its visual elements - Ability to incorporate specific elements into a cohesive and appealing design - Strong typographic skills to effectively integrate the server name into the logo. The logo should have a dark and moody color scheme. The dark and moody color scheme should primarily use dark blues and purples. The typography for the server...
...need of a professional who can set up a Remote Desktop Services (RDS) on a Windows server for a group of remote users. Key Requirements: - Server Configuration: The RDS server should be configured to support 11-50 concurrent users, with optimal performance and security measures. - Application & Desktop Access: The server needs to provide access to both specific applications and a general desktop environment. - User Management: Ability to set up user accounts and manage permissions. Ideal Skills: - Extensive experience with Windows server and RDS setup. - Knowledge of network security protocols. - Proficiency in user account management and permissions setting. - Ability to troubleshoot and optimize server performance. Please bid only if y...
You must speak english clearly, on phone, meetings, and available during EST. I have a team of 3 other devs, but I am looking for a full time developer. Our system is very complex - it will require some learning. But I need someone to help me make sure progress is made, and to make sure I have full control of my system. As we have grown to over 100+ customers and 200+ users on our desktop app.
I'm looking for a SQL expert to help me with querying and reporting on my sales data. Specifically, I need assistance with product performance analysis. I am able to get all the information I need with 2 queries but cannot get the two queries to work together. Your tasks will primarily involve: - Utilizing SQL to analyze product performance based on sales data - Generating insightful reports that can help guide business decisions Ideal candidates for this project should have: - Extensive experience with SQL, particularly in data querying and reporting - A strong analytical mindset, capable of deriving insights from complex datasets - Prior experience with sales data is a plus
My SQL Server 2016 database is suffering from storage overuse, which is causing slow performance and potential crashes. I need to have the bloat removed, and the database converted to SQL Server 2019. Please apply the following optimization techniques during the process: - Indexing - Normalization - Partitioning I need all data preserved during the conversion, apart from the bloat. This includes: - Customer data - Transaction history - Reports/Logs The ideal freelancer for this project should have extensive experience with SQL Server, database optimization techniques, and data migration. They should be able to ensure the integrity and security of all data during the process. Please provide examples of similar projects you've complet...
We need a communicative, collaborative, and people-oriented senior Power BI Developer with a very good SQL background to support our Data Analytics and BI Team. This is a long-term project, and your consultant and service approach, along with your technical prowess, is not just important but integral to the success of this position. Speaking German is an added advantage.
My Ubuntu server has crashed and I urgently need it to be restored. The highest priority is to recover the hosting files first. Following that, I need all my dynamic websites with databases to be restored. Finally, the PHP and MySQL based websites need to be recovered along with their respective databases. The ideal freelancer for this project should have: - Extensive experience with Ubuntu server recovery - Proficient in PHP and MySQL - Skilled in restoring dynamic websites and databases - Able to recover hosting files efficiently Time is of the essence and your prompt assistance in this matter would be greatly appreciated. Please provide daily updates on the recovery progress. There are no existing backups available. All websites and databases are hosted on the sa...
I'm experiencing various errors while trying to connect to an SQL Server ODBC data source on Linux. I'm using the Microsoft ODBC Driver for SQL Server, and all necessary dependencies have been installed. Ideal Skills and Experience: - Expertise in SQL Server and ODBC - Extensive experience with Linux systems - Proficient in troubleshooting connectivity issues - Familiarity with Microsoft ODBC Driver for SQL Server - Strong problem-solving skills
I'm looking for an expert in cloud migration, specifically to Microsoft Azure. The current server primarily hosts documents and spreadsheets, and I need a seamless transition with minimal downtime. Your responsibilities will include: - Assessing the current storage needs and planning for future growth. - Ensuring all data is securely transferred. - Implementing necessary performance improvements during the migration. Skills in Azure, data security, and performance optimization are crucial for this project. Experience with migrating file servers is highly desirable.
I need help fixing my Python script. It stopped working after a recent website update. The ideal freelancer for this project should have a strong background in Python programming,web scraping and MS SQL Server. I don't think it will be a huge job but we don't have the expertise here to overcome it. However you can advise once you see the project I will supply the existing script and details of the issue once we connect.
Project Title: HR Data Analytics and Visualization Using SQL and Power BI Project Overview: The HR Analytics project aims to provide comprehensive insights into employee data to support HR teams in data-driven decision-making. By analyzing various metrics related to employee performance, demographics, attrition, and satisfaction, the project seeks to identify trends and patterns that can help improve employee retention, engagement, and productivity. Key Objectives: Employee Attrition Analysis Description: Analyze employee turnover rates and identify factors contributing to attrition, such as tenure, age, department, and performance ratings. Goal: To reduce attrition by identifying at-risk employees and formulating retention strategies. Performance Evalu...
I'm looking for an experienced Linux system administrator to set up a 24.4 Ubuntu server for me. This server will need to be configured with a firewall that supports NAT configuration to communicate with a third-party via REST API. Key Responsibilities: - Configure the Ubuntu server and firewall for necessary NAT support - Set up the server for REST API integration - Ensure the server is secure and functions correctly Ideal Skills: - Extensive experience with Linux, particularly Ubuntu - Deep understanding of server configuration and firewall setup - Proven expertise in REST API integration - Knowledge of NAT configuration - Ability to ensure system security Looking forward to your bids!
I am experiencing slow loading times and high CPU usage on my server, which is managed via WHM/Cpanel. I am looking for an experienced professional who can optimize the performance and speed of my WHM/Cpanel system. Key tasks: - Optimizing the performance settings in WHM/Cpanel - Implementing necessary tweaks in Apache and MySQL - Using caching mechanisms effectively - Optimizing SQL queries to reduce server load Ideal candidates for this project will be well-versed in WHM/Cpanel, Apache, MySQL, and have a track record of using these tools to improve server performance.
I need assistance in installing Windows 10 on my Ubuntu 22.04 LTS ssh. No data backup is required as I have no data to back up. Ideal skills and experience for the job: - Proficiency in Ubuntu and Windows operating systems. - Previous experience with dual-boot setups or installing Windows on Ubuntu systems. - Knowledgeable about potential post-installation issues and solutions. Note: The project does not currently require data backup or driver installation assistance. However, the ideal candidate should be prepared to assist with driver installations if needed.
I am about to start a new .NET project at work, and I would like to propose an architecture with the following specifications: ASP.NET 5 MVC for the frontend (because we only have a Visual Studio 2019 license) and Web API for the backend, with exception handling, basic authentication, logging and consumming stored procedures using a SQL Server database. I only need the project template with 1 or 2 CRUD examples (products and categories for example) ready to run in Visual Studio 2019. Key Responsibilities: - Build a robust and user-friendly ASP.NET 5 MVC project and REST API's Requirements: - Proficiency in ASP.NET MVC and Web API. Ideal Candidate: - Previous experience with ASP.NET MVC projects. - Solid skills in developing and managing Web APIs (...
...foundation in regression analysis, hypothesis testing, and multivariate statistics. - Time-Series Analysis: Proficient in ARIMA, SARIMA, Prophet, and exponential smoothing models for long-term forecasting. - Predictive Modelling: Expertise in supervised and unsupervised learning algorithms like Random Forests, Gradient Boosting Machines, and Neural Networks. - Extended knowledge in the Data Stack: SQL, Python, Spark, GCP Soft Skills - Stakeholder Engagement: Skilled at presenting technical concepts to non-technical audiences, including C-level. - Problem-Solving: Exceptional ability to break down complex problems and develop data-driven solutions. - Documentation: Proficient in documenting methodologies, processes, and model assumptions. - Flexibility: Comfortable working in a f...
I'm seeking a proficient Flutter developer capable of handling both UI design and backend integration tasks. Key...functional and stylish interfaces that enhance user experience. - Integrating the designed UI with backend systems powered by SQL Server. You should be able to create seamless interactions between the frontend and backend of the app, ensuring reliable data exchange. Ideal skills and experience: - Extensive experience in Flutter development. - Proven competency in UI design and development - particularly Material design. - Profound understanding of SQL Server for successful backend integration. - Ability to conduct thorough testing and perform necessary bug fixing operations. Please bid only if you are comfortable handling these tasks and ...
I'm looking for a Data Analyst with strong SQL and Python skills to help me identify trends in my sales data. The data is readily available, and the main goal is to uncover underlying patterns and insights that can inform future business strategies. Ideal Skills and Experience: - Proficiency in Python and SQL - Strong background in data analysis - Experience working with sales data - Ability to identify trends and patterns in data - Excellent reporting skills - Strong understanding of statistical methods and their applications - Proficiency in data visualization tools such as Tableau, Power BI, or Matplotlib The final report should be in Excel format. Focus on analyzing sales data from the last year.
I need a seasoned Ruby on Rails developer with extensive experience in server migrations from legacy systems. The project involves transitioning from an outdated Ruby on Rails version to a more modern infrastructure. Your expertise will be pivotal in ensuring a seamless and efficient migration process. Ideal skills and experience include: - Proficient in Ruby on Rails - Extensive server migration experience - Familiarity with legacy systems - Excellent problem-solving skills - Strong understanding of modern Ruby on Rails infrastructure
I'm seekin...installation of my Laravel project. I've downloaded the necessary files and set up the SQL database, but I'm hitting a roadblock with updating PHPMyAdmin and MySQL versions for compatibility. The tasks I need assistance with include: - Downloading and configuring Laravel files. - Creating the MySQL database and configuring it in the .env file. - Running migrations if necessary. - Verifying system functionality. The main challenge is ensuring PHPMyAdmin is updated for compatibility, so any assistance with this would be greatly appreciated. Ideal candidate should have: - Solid experience with Laravel and MySQL databases. - Proficient in handling basic .env configurations. - Knowledge of PHPMyAdmin updates preferred. I'm currently using a Lin...
Job Title: Urgent Developer Needed for Server Migration on DigitalOcean Job Description: We are urgently seeking an experienced developer to assist with migrating our server on DigitalOcean. We encountered an issue with our current droplet after a recent maintenance update from DigitalOcean, and despite multiple attempts to resolve it, the droplet remains non-functional. Our current plan is to migrate our droplet to a new server within DigitalOcean to restore full functionality. Requirements: Proven experience working with DigitalOcean, especially with managing and migrating droplets. Strong knowledge of server migrations, configurations, and troubleshooting within cloud environments. Ability to work under tight deadlines and effectively manage ...
...automation to design and implement for self service server provisioning. Key Requirements: - Design and implement Aria automation for self service portal - Conduct a comprehensive analysis of current workflow processes to identify areas for automation. - Develop custom scripts and tools to facilitate seamless Aria integration. - Ideal Skills: - Proven experience with Aria automation. - Strong knowledge of work flow system - Excellent system analysis and design capabilities. The project should be completed within 2 weeks. The solution should be focused on provisioning Windows, linux servers. The self-service portal should support basic customization for users. The self-service portal should support basic customization for users such as server configurations. The s...
I'm in need of a s...FastAPI for backend development - Strong understanding of AWS services - Prior experience in the derivatives market is a plus - Proficiency in managing and optimizing databases, including SQL and NoSQL options - Expertise in containerization technologies such as Docker and Kubernetes - Experience in designing and implementing microservices architecture - Understanding of security best practices and experience in implementing them in both frontend and backend environments - Experience with managing API gateways on AWS like AWS API Gateway We also need IP hopping for this project. The goal of this project is to streamline data processing and workflow automation to enhance efficiency and productivity. If you have the right skills and experience...
Looking for some one familiar with banner/push ads. And operating the actual ad software similar to plugrush. Need help do to not having time to analyze and ajust as needed. Must be familiar with adult/dating site advertisers for USA. Need conversion server to server experience. More details: Is this project for business or personal use? For an existing business What information should successful freelancers include in their application? Experience How soon do you need your project completed? ASAP We are targeting a high click-through rate for the banner/push ads. Please include animated graphics in the banner/push ads. The primary goal is sales conversions. Success will be defined by the number of sales conversions generated. We will be using Plugrush for ou...
I'm looking for a Python script that calls a REST API, processes the JSON response into a DataFrame, and then writes the results to a Microsoft SQL Server database. Requirements: - Experience with Python and REST APIs - Proficient in data manipulation with pandas - Skilled in SQL Server database operations Please include examples of similar projects you've completed in your bid.
I'm in need of an experienced developer to create a local server application or form for me that builds an editable, interactive form similar to the one found at (). Key Requirements: - The application should run on a Windows operating system, as that is where my local server is hosted. - It must allow users to fill in information at the top, click check boxes, and then generate a more detailed PDF from their inputs. - Unlike the web-based example, this must be a local application because the data being handled is private and sensitive. - The form needs to have a name field that draws from and auto-fills using a pre-existing database stored in an Excel spreadsheet. - When a user starts typing a name, they should be able to
...Windows Server 2019 environment, particularly with the Domain Controller and user profiles. The problems are obstructing user authentication and access to resources. Error Messages Encountered: - "The system cannot contact a domain controller to service the authentication request" while mapping drives. - "The processing of the group policy failed because of lack of network connectivity to the domain controller" during group policy updates. The primary focus should be on restoring Domain Controller connectivity. I am uncertain about any recent changes or updates to the server or network configuration. Troubleshooting Steps Taken: - Restarted the Domain Controller - Checked network connections The ideal freelancer for this project should have ...
I'm in need of a multi-level deep database that effectively manages my contacts and tracks the results of calls made. This database will have multiple levels, starting from Level 1 which is the initia...easy navigation within the database. - Property Management: I need the ability to find properties, add property owners, and call property owners. - Result Tracking: I want to see results from calls made. The choice of database technology is yet undecided, so I am open to suggestions. The ideal candidate for this job should have extensive experience in database development, preferably with both SQL and NoSQL technologies, and a solid understanding of call tracking systems. They should also possess the ability to implement the necessary features to make the database user-friendly...
Server Maintaince: Take entire backup of your website Then format the existing server os and resetup it with new panel secure panel alsor estore the backup and live the website
1. Data Processing and Analysis for E-commerce Description: Processed and analyzed large datasets from an e-commerce platform to extract insights into customer behaviour. Tools Used: Excel, Python (Pandas), SQL Outcome: Provided a dashboard with actionable insights on customer preferences and buying trends, helping clients optimize their inventory and marketing strategies. 2. Secure Code Review for Fintech Application Description: Conducted a security audit of a fintech application, identifying potential vulnerabilities and securing the codebase. Tools Used: Static analysis tools, C++, and secure coding practices. Outcome: Delivered a secure, optimized codebase emphasising encryption and secure data handling practices, greatly reducing security risks. 3. Article Series on Emerging C...
...additional security features like CAPTCHA or 2FA. User Management: The admin panel will have options to manage users, verify payments, change banking details, view active sessions, and track earnings. Color Winner Selection: Allow the admin to set the winning color for each game round, and ensure it updates on the user interface. Server-side Logic: No SQL Database: If using a NoSQL setup, Firebase or a similar service can be used for real-time data handling without SQL. Real-Time Updates: Use WebSockets for real-time dashboard updates, allowing users and admin to see fund status, session activity, and game results instantly. Security and Compliance: Use HTTPS, data encryption, and secure authentication methods to protect user data. Comply with gaming regulations, ...
...in loading and compiling the Wazuh Server, agent (Windows), and Dashboard projects within Visual Studio 2022. - Primary Focus: I anticipate needing the most help with the Server component. It’s crucial that the compiled Server supports Windows, as this is the operating system we’ll be working with. - Task Overview: You'll be helping me compile the server, agent, and dashboard components in VS2022. Once we have the compiled projects, we'll need to extract data from a Windows system into the Server. After that, we’ll display the data via the WUI reporting and dashboard tools. Ideal skills and experience include: - Proficiency in C++ - Intermediate experience with Visual Studio 2022 - Familiarity with Wazuh and its component...
...in loading and compiling the Wazuh Server, agent (Windows), and Dashboard projects within Visual Studio 2022. - Primary Focus: I anticipate needing the most help with the Server component. It’s crucial that the compiled Server supports Windows, as this is the operating system we’ll be working with. - Task Overview: You'll be helping me compile the server, agent, and dashboard components in VS2022. Once we have the compiled projects, we'll need to extract data from a Windows system into the Server. After that, we’ll display the data via the WUI reporting and dashboard tools. Ideal skills and experience include: - Proficiency in C++ - Intermediate experience with Visual Studio 2022 - Familiarity with Wazuh and its component...
I'm looking to develop a Survival Minecraft Server with specific features. Key components include: - An Economy System: This will help create a sense of progression and achievement for players. - Player Ranks: This feature will add an element of status and recognition within the game. The primary target audience for this server will be family-friendly gamers. Therefore, the server should be designed to promote a fun, inclusive, and safe gaming environment for players of all ages. Ideal skills and experience for the job include: - Proficiency in Minecraft server setup and administration - Experience with implementing and customizing Minecraft plugins - Understanding of game design principles for creating a family-friendly environment. Looking forward to...
...loading and compiling the Wazuh Server, agent (Windows), and Dashboard projects within Visual Studio 2022. - Primary Focus: I anticipate needing the most help with the Server component. It’s crucial that the compiled Server supports Windows, as this is the operating system we’ll be working with. - Task Overview: You'll be helping me compile the server, agent, and dashboard components in VS2022. Once we have the compiled projects, we'll need to extract data from a Windows system into the Server. After that, we’ll display the data via the WUI reporting and dashboard tools. Ideal skills and experience include: - Proficiency in C++ - Intermediate experience with Visual Studio 2022 - Familiarity with Wazuh and its components ...
Job Title: Full-Stack Developer (Remote) Job Description: We are seeking an experienced Full-Stack Developer to join our team on a project basis. The ideal candidate is skilled in both front-end and back-end development, with a strong understanding of web and mobile application development and experience working with APIs. This role involves developing, integrating, and optimizing scalable solutions for a seamless user experience. Responsibilities: Design, develop, and maintain front-end and back-end components of web and mobile applications. Collaborate with cross-functional teams to define, design, and ship new features. Integrate APIs from various service providers and optimize performance. Develop and maintain database architecture and ensure data integrity and security. ...
...Understands WordPress: Familiarity with themes, plugins, and core WordPress functionalities is essential. - Has server management experience: The right candidate should be able to check the server configuration if necessary and performance to identify any potential issues affecting website performance or uptime. - Has solid SEO expertise: Understanding of search engine optimization to review and optimize the site for better rankings and organic traffic. Project Scope: - Check analytics setup and reports - Conduct a comprehensive audit of the website, including performance, SEO, content, and technical aspects. - Analyze potential issues such as broken links, poor loading speed, server-related problems, or recent changes in search algorithms that could be affe...
I have completed SQL coding I believe to be correct. I need this SQL code implemented into tables with specific relationships as defined in my provided schema. All necessary information is available. Ideal Skills and Experience: - Proficient in MySQL - Experience with SQL coding - Ability to set up specific table relationships (foreign keys, etc.) - Familiarity with working from a schema or ER diagram - Attention to detail No additional optimizations or indexing is required.
I'm seeking a skilled PL/SQL developer with a strong Oracle background. The primary purpose of the program will be to assist with reporting and analytics on financial data. Ideal skills and experience include: - Proficiency in PL/SQL - Extensive experience with Oracle DBMS - Strong background in financial data analytics - Previous project experience focused on reporting and analytics Your role will be creating a PL/SQL program that can effectively handle and analyze financial data for reporting purposes.
I am looking for a seasoned Cybersecurity Consultant to fortify our cloud-oriented Windows server environment, which is accessed remotely by our team. This role is crucial in formulating, executing, and supervising robust cybersecurity measures to ensure the confidentiality, integrity, and availability of our digital resources. Key Responsibilities: - Training one of our staff members in several critical areas of cybersecurity. Specific Areas of Focus: - Evaluating our existing security protocols and pinpointing potential vulnerabilities within our remote desktop setup. - Creating and putting into action comprehensive security strategies that encompass endpoint protection, network security, and threat detection. Essential Requirements: - Extensive experience in cloud security, pa...