Crosstab query sql server 2008 jobs

...Azure Cloud Infra/Azure APIs/Connectors/3rd Party AI Model/AI Tools required for Hosting, Processing, and Training of Models, etc. End Users – Website Users Development Timelines- 30 Working Days. Access: Secure Login Part C: Development and Implementation of Virtual Learning Assistance. • We will provide access to Existing learning Databases (Videos, Books, PDFs). • Bidders must develop API Query to enable Virtual Learning Assistance to Website Users. End Users- Website Users Development Timelines- 30 Working Days. Access: Secure Login AMC Requirement: • The bidder must create, set up, and configure a new cloud infrastructure under the name GCC Law Help and may also require creating and setting up third-party generative Accounts under the name GC...

I'm in need of an experienced Python developer to assist with the development of critical web security tools. While specific tools aren't outlined below - Subdomain Enumeration: Subdomains to be listed and categorized. - Directory Enumeration - Sensitive Parameter Detection - XSS Testing - SQL Testing

I'm in need of an experienced Python developer to assist with the development of critical web security tools. While specific tools aren't outlined below - Subdomain Enumeration: Subdomains to be listed and categorized. - Directory Enumeration - Sensitive Parameter Detection - XSS Testing - SQL Testing

...seeking a highly skilled data engineer with a strong proficiency in Apache Kafka to work on a data integration project. The main objectives of this project are: - Integrate various data sources: structured (SQL database), semi-structured (XML, JSON), and unstructured (emails, documents) - Develop a robust data flow architecture - Ensure efficient data transmission across systems The perfect freelancer for this job should possess the following characteristics: - In-depth knowledge and practical expertise with Apache Kafka - Experience with integrating diverse data sources, such as SQL databases, XML, JSON and unstructured data (emails, documents) - Proven track record of successful data integration projects Feel free to schedule a meeting using this link.

... Non-functional Requirements: 1. Security:  Implement HTTPS for secure communication.  Apply role-based access controls to restrict unauthorized access to sensitive data.  Regularly update and patch software components to address security vulnerabilities. 2. Performance:  Ensure fast loading times and responsiveness of the website, even under heavy traffic.  Optimize database queries and server-side processing for efficient performance. 3. Scalability:  Design the system to handle a growing number of users and transactions over time.  Employ cloud-based infrastructure to scale resources dynamically as needed. 4. Compatibility:  Ensure compatibility with popular web browsers (e.g., Chrome, Firefox, Safari).  Support responsive design for seamless user experience acros...

I have C# MVC Web App that works using SQL Server Database & using APIs at the same time. For the functions that use the database, I want to replace them with the APIs 1- Error message appear with no details, need to make the error message has Show More to display the details of the error. 2- Load Codes from APIs instead of loading from JSON file. (1 API) require updating treeview to load on demand 3- Packages Load from APIs instead of loading from DB (2 APIs) 4- SubscribedPackages Call API instead of inserting into a DB (1 API) 5- Schemes Load from APIs instead of loading from DB (1 API) 6- Uploads Call API instead of inserting into a DB (1 API) 7- Users Call API instead of inserting and reading from a DB (5 APIs) you must have C# MVC experience. -----------...

can you help me with pass ookla host-tester PFA

...client’s needs. We’re primarily building web-based applications but have opportunities for mobile development as well. You’ll need: In-depth working knowledge of functional React, preferably 16.8+ In-depth knowledge of ES6 syntax Fluent in Typescript Experience using a 3rd party component library (e.g. MaterialUI) and/or CSS frameworks Experience working with state management tools (e.g. React Query) Familiar with Git, including standard development lifecycle (feature branching, pull requests, CI/CD) Experience with React testing methodologies, or a strong desire to write testing An interest in all aspects of the SDLC, including talking to clients is ideal When you work for us, you’ll enjoy: Rapid career advancement based on initiative and performance ...

Hello, I have android app (check attachment), i need to send and request data to it's server by using Postman instead of using the app. I was able to do it before the app's developer using HTTPS on their API call to it's server. This new app version seems like it's encrypting the data, but i believe the encryption/decryption key hidden inside the app it self. If you think can work on this project and achieve my goal, please bid on it. Any further question should you ask me so i can explain more detail. Thanks

I'm in need of a specialist in MongoDB who can effectively troubleshoot and resolve configuration errors that I've encountered during its reinstallation on my Ubuntu Apache server. I'd appreciate bids from candidates who, at a minimum, possess the following qualifications: - Expertise in MongoDB installation, setup, and troubleshooting - In-depth knowledge of Ubuntu Apache server management - Strong experience in handling configuration-related issues - Bonus: Understanding of file path, authorization, and networking issues, as the specific type of configuration error wasn't determined Please be ready to detail your relevant experience and strategies for resolution. Thanks!

My Laravel project is causing CPU usage to spike to 100% due to complex queries. I need an expert to optimize the project's performance. Key Responsibilities: - Diagnose the root cause of the perf...handling complex queries - Provide recommendations and implement changes to optimize the project's performance Ideal Skills and Experience: - Proven experience in optimizing Laravel projects - Solid understanding of database indexing and query optimization - Familiarity with caching strategies and how to implement them in a Laravel project This is a high-priority task. Immediate availability and quick turnaround will be highly appreciated. Duevto cpu usage website is not accessible. It require experience. Beginners please do not bid as you will be ignored Server is...

I'm seeking a skilled developer experienced in mail server setup particularly focusing on SMTP configuration and the deployment of Mailwizz. This setup will be used to automate the sending of large numbers of email. The key requirements for this project include: - Expertise in SMTP configuration; your task will involve configuring a mail server that allows seamless sending of less than 10,000 bulk emails per day with the possible adjustment in the future. - Proficiency in Mailwizz setup; a wider experience in the integration of this with SMTP for my bulk email requirements is a must. This project is best suited for a freelancer with a strong background in mail server setup, SMTP, and Mailwizz, who understands the importance of a reliable and efficient mailing sy...

I'm seeking an experienced Google Script specialist to automate tasks and manage data for my project. Here are the specifics: Automating tasks: Your main responsibility will...Script specialist to automate tasks and manage data for my project. Here are the specifics: Automating tasks: Your main responsibility will be to automate data import/export processes using Google Script. I need to take the data attahed to a daily email in excel format, upload this data (and historic) to a data base and then allow to consult that data from different spreadsheet in google with a query. Ideal skills and experience include: - Proficiency in Google Scripts and automation - Experience in data management - Google spreadsheet analisis reports If you have the needed expertise, I'm excit...

...skilled developer who can create a chat client-server program . The focus should be specifically on enabling text messaging and group chat functionality. The Language for this project is Python 3 You should write a client program and hence a client process should be running. Also. You should write a server program and hence a server process should be running. Specifically, you must implement two independent applications. One, called chatClient, implements the client component. The other one, called chatServer, implements the server component. You must design your own protocol for the communication between the client and the server. Key Features: Basic Functionalities • Administration Capabilities o A client will start by contacting the serve...

...Existing Environments. Maintain Documentation For System Processes And Procedures. Participate In Code Reviews, Contribute To Team Knowledge, And Mentor Junior Developers. Required Skills: Strong Proficiency In Perl Scripting And Python Programming. Experience With XML Technologies, Including XML Parsing And XSLT Transformations. Good Understanding Of Relational Database Management Systems And SQL. Excellent Problem-Solving Skills And Ability To Think Analytically. Strong Communication And Interpersonal Skills, With An Ability To Communicate Complex Concepts To Non-Technical Stakeholders. Additional Qualifications: Experience With Web Technologies (HTML, CSS, JavaScript) Is A Plus. Familiarity With Software Development Methodologies Such As Agile/Scrum. Perks And Benefits:...

I'm in need of a skilled freelancer to set up and install Primavera P6 EPPM 21.12 locally on Windows. This is a single user setup, with SQL database configuration included. Key Tasks: - Install Primavera P6 EPPM 21.12 on a Windows system - Complete and configure the SQL database for the software Ideal Freelancer: - Experienced with Primavera P6 EPPM installations - Proficient in SQL database setup and configuration - Understands the intricacies of Windows OS - Prompt and clear in communication

...address and make a payment. Rating page. Users will be prompted to login before accessing this. Star ratings will be filled in here, and the welcome text will have each users [first_name]. Generate a custom QR code to a rating page with pre-filled order number (unique identifier from above) Order confirmation email. With animated banner and QR code. SQL database. All data from the users, questionnaires, orders, and ratings will be stored in a postgres SQL. I have specified the database design (see below). Currently there is no API to warehouse/shipping (postage of orders are handled manually, but please set up the database with the future API integrations in mind). Manual order (in backend). Basically, I want to be able to look at the sample ratings for each sample order a...

I'm in need of a skilled .NET developer to create...additional integrations may be required in the future. Experience with integrating external systems and APIs would be beneficial. - User Roles and Permissions: The application may need to support multiple user roles and permissions. While this is currently marked as 'unsure', the ability to handle this efficiently would be a plus. Ideal Skills: - Proficiency in .NET development - Strong knowledge of SQL databases and data management - Experience in user authentication and registration systems - Previous work involving user role and permission management - Flexible to adapt and integrate external systems when required If you're a skilled .NET developer with a track record of creating user-centric web applicatio...

Dears, my hostinger Ubuntu Server with cloud panel Down on Hostinger. Need your quick support.

I'm in need of an experienced developer to bring my SQL codes with the triggers to life with a well-designed Apex Oracle application. The app is expected to have the following features: - Implementing data entry forms that are intuitive and user-friendly. - Developing robust data analysis reports that provide valuable insights in an easy-to-understand format. - Setting up a comprehensive user authentication and security system. - Creating a visual design that aligns with my company's corporate branding while also being colorful and vibrant. - Ensuring the application is responsive and works seamlessly on both desktop and mobile devices. - Implementing an efficient navigation and information architecture to enhance user experience. The ideal candidate for this project sho...

I'm in need of a skilled web developer highly experienced in both Angular and Javascript. The primary objective for this project is to create a website with a responsive design that aligns with my provided brand guidelines. Key Qualifications: - Proficient in Angular and Javascript - Extensive experience in responsive design - Extensive experience in .Net Core and SQL Responsibilities: - Adhere to design and branding guidelines during web development - Create a website that is user-friendly on all devices. Please ensure to provide examples of past work with responsive web design during your application.

...Remove the "//const MongoClient = require("mongodb").MongoClient;” line 2 - Run ‘docker compose up’ to start the code 3 - Fix the code so it does not crash 4 - Demonstrate a working connection between the application and a remote Mongo Atlas database (you will need to create one yourself or point to one). The data does not matter, I just need to see examples of: a) A READ query, b) An UPDATE query, c) A CREATE new record query Error See this file for a description of the error which needs to be fixed - Debugging The application connects to a remote Mongo Atlas database correctly if the code is run outside the container. I’ve developed a simple Mongo connection js file which tests this. The output is shown here - h...

...applications, with the aim to identify and eradicate any potential vulnerabilities. Key Tasks: - Perform Open Source Intelligence (OSINT) - Port scanning - Man-in-the-middle (MiTM) attack simulation - Focus intensively on injection attacks (SQL, XSS) - Authentication and session management puncturing - Cross-Site Scripting (XSS) evaluation The ideal freelancer will have: - Strong experience in cybersecurity and penetration testing - Excellent knowledge and experience with Linux-based systems - Proven experience in web application security testing - Firm understanding of SQL, XSS and authentication vulnerabilities Your final deliverable will be a complete penetration testing report, detailing vulnerabilities found, their potential impact, and recommended remediation step...

I'm in need of an experienced Python developer to assist with the development of critical web security tools. While specific tools aren't outlined below - Subdomain Enumeration: Subdomains to be listed and categorized. - Directory Enumeration - Sensitive Parameter Detection - XSS Testing - SQL Testing

We are currently extending our Java Spring application and are searching for support within the area of Spring Authorization Server and Security. We want to use Spring Authorization server within our multi-tenancy approach. We need to provide different logon mechanisms starting from OAUTH2 (Azure, Google, ..), over Social Logins, API Tokens and regular JWT Tokens. We are searching for somebody who can support our development team in this area.

I'm currently running on Windows Server 2019 and am in need of a certified TruNAS professional to manage my network and join the Truenas to the domain. Your responsibilities will include the following: - Configuring and managing AD and/or the Truenas server side. - Ensuring seamless integration with existing infrastructure. You need to have hands-on experience with Windows Server 2019 and proficient skills with managing TruNAS networks. Full understanding AD protocols is paramount. Understanding the importance of system availability and data protection will be crucial to this role.

I am in need of an expert who can set up a Windows Server Virtual Machine in Azure for me. The VM will need to be configured with 4 CPUs and 8GB of RAM. Skills and Experience Required: 1. Azure Expertise: You should have a deep understanding of Azure services and be able to navigate the Azure portal with ease. 2. Windows Server Administration: Proficiency in Windows Server operating system is crucial for this project. 3. Virtual Machine Configuration: Experience in setting up Virtual Machines, specifically with the requirements of 4 CPUs and 8GB RAM. 4. Networking: Proficiency in networking, particularly the ability to configure my Virtual Meraki to the Azure VM.

...own URL. As you can see, the link pushes all data to This is the script that can be found on the file server that ultimately receives the data and processes it in Wordpress. The Incremental link makes a POST request to this script containing the data. In the script you see 3 types of actions in a switch: Add (new vehicle) Change (vehicle exists, adjustment is being pushed) Delete (vehicle is deleted) Below is a brief explanation of the three functions involved: add_post Here I build a Wordpress Query containing data from the POST request. Then I run a "wp_inset_post" function with this query. From that Wordpress function you will then receive a "post_id" with which I will add photos to the post. change_post Same as "add_post" but ...

...already converted 50-60% to ) and also transfering our .NET to .NET CORE and our MS SQL to PostgreSQL Details of our current project STACK can be seen here -> Prerequisites: For this optimization task you can bid your normal hourly rate but for the long term project the starting wage will be as stated below. 1) Accept initial hourly rate of U$5.00 2) Accept and start work immediatly 3) Have 20+ hours a week for long term ongoing support and development. 4) If you are awarded the project accept IMMEDIATELY 5) Work hours: predominantly 20:00 to 03:00 (UTC -3 Brazil TIME) 6) Be available to work on weekends. Our projects use: GITLAB -> , ag-grid, C#, .NET API, MS SQL 2017 , WooCommerce digital product sales This is for ongoing long term development and

I am needing a professional to address a critical issue involving my VPS Server, on Ubuntu 22.04. It has become increasingly unstable, crashing and requiring manual restarts every 10 minutes. I would appreciate assistance in investigating and resolving this. While I have personally reviewed the server logs, I have not been able to identify any specific error messages that may be causing this issue. Your task will be to conduct a comprehensive review of the problem, deducing the underlying issues from the server logs, even if no specific errors have been identified. Ideal Skills: - Expert knowledge of Ubuntu 22.04 - Robust experience in managing VPS servers - Troubleshooting and problem-solving skills in identifying and fixing software glitches - Capability to wor...

...not receive any pre-existing design templates such as Figma, but you may refer to a competitor's website for inspiration. The goal is to build a platform that efficiently categorizes Telegram channels and groups by country and category, facilitating easy navigation. This website will be developed using React, Node.js, and PostgreSQL. It must be fast, secure against common web threats including SQL injections, Cross-Site Scripting, and IDOR's. It should also be optimized for search engines to achieve high visibility online. Key Features of the Website: * Channel and Group Organization: Separate listings for channels and groups, categorized by countries and specific categories. * Search Functionality: Advanced search options allowing users to find channels and groups...

I'm in need of an experienced Python developer to assist with the development of critical web security tools. While specific tools aren't outlined below - Subdomain Enumeration: Subdomains to be listed and categorized. - Directory Enumeration - Sensitive Parameter Detection - XSS Testing - SQL Testing

Good I am making a script for a client in python, where I am building a program where the program will generate me 100 weekly emails at most, these emails must have a phone number associated with each of them a number, ie emails have to be valid, the customer wants to receive and send mails, I am looking for creation of server to receive and send mails with emails created by the python app. emails are created randomly and just like passwords with a custom domain. I speak a little English so if you know Spanish we would understand each other better.

I'm in need of a Spark Developer who has a good, intermediate level competence in Scala. Your primary task will include: - Processing and analyzing structured data similar to SQL databases. Given the nature of this project, prior experience with data processing and working with SQL databases would be a huge advantage. While performing machine learning algorithm implementation or real-time data streaming isn't explicitly required, any exposure to these areas would be beneficial.

I'm looking for a skilled ASP .NET web developer to work on a small project. Key requirements: - Fullstack development: The project involves both front-end and back-end development. The ideal candidate should be proficient in C# and ASP .NET. - Database Integration: The project will be using SQL Server, so experience with this database type is needed. Skills required: - Proficiency in C#, ASP .NET, and SQL Server - Experience in fullstack web development - Strong understanding of database integration and management Your role will be to take the project from concept to completion, ensuring that all elements are well-integrated and functioning smoothly. If you are a reliable, detail-oriented developer with a strong track record in ASP .NET web projects, I&...

...secure authentication practices, such as password hashing and the use of access tokens, to prevent unauthorized access. 5. Input Validation and Sanitization: To mitigate the risk of security vulnerabilities, the application will implement strict input validation and sanitization techniques. This section emphasizes the importance of validating user input to prevent common vulnerabilities, such as SQL injection and cross-site scripting (XSS) attacks. 6. Secure Transaction Processing: The application will incorporate secure transaction processing mechanisms to ensure the integrity and confidentiality of financial transactions. This section discusses the implementation of secure communication protocols, such as HTTPS, to protect sensitive data during transit. It also highligh...

...factors like project complexity, team expertise, and desired features. Back-end: Select a server-side technology (Node.js, Python with Django/Flask, PHP with Laravel) based on performance requirements, scalability needs, and developer familiarity. Database: Choose a suitable database (MySQL, PostgreSQL, MongoDB) based on data structure, query complexity, and scalability requirements. Other Considerations: Authentication/authorization, payment processing (if applicable), CMS (if needed). 3. Development Process: Front-end Development: Implement the user interface and user experience using your chosen framework, following component-based architecture for maintainability. Back-end Development: Build your server-side APIs using the chosen back-end technology, ensuring p...

I'm looking for a freelancer who can help me set up a VPN server on Google Cloud using Linux as the operating system and OpenVPN as the VPN protocol. We need an IPSec-ready end device on our side (or hosted somewhere), where the data traffic should terminate. The service will route all the data traffic through the tunnel. Need to have an US based breakout then. So, when we are receiving the traffic on one central address, and there we can do the breakout and the NATing into the world wide web on our side.

It is necessary finish a project managemet application made in laravel. The change are: - make some change regard the flow, the links, the design, the ecommerce and report; - It is necessary experience in query, report charts, pivot builder and Business intelligence to change the reports that must have good design, many filter and cross. the charts must have drill down. Please answer only if have experiences in project management software and pivot-query-busienss intellegence. And show my the url of similar job made.

I'm looking for an expert in Linux administration who is specialized in server setup. My project requires: - Setting up a LAMP on a Ubuntu server with MariaDB. - Configuring the server to respond to a specific domain name, empty folder mapping. - FTP and account mapping to the webserver's folder. Necessary skills: Ubuntu, LAMP setup (Linux, Apache, MySQL, PHP), FTP setup. Experience in managing and setting up servers is a must. This are a very easy setup so maximum 2 hours. Please add the word "Light" in your quote so I now you are not a bot...

I am looking for someone who can create a custom Minecraft survival server for me. Here are my ideas: - A group system where the initial group is predefined but can be changed by me at any time. - Players start in a spawn world where they can read and accept the rules through a fun animation before being allowed to enter the game. - Players can explore the area, buy and sell items, with NPCs distributed throughout the game world. - An in-game menu that allows users to teleport to different positions. This menu should also allow players to visit other players, enter their protected homes, and interact with them. - Different worlds: spawn world, farm world, and build world. The farm world is regularly reset, while the build world also has a protected spawn. - The spawn world and buil...

I am currently experiencing issues with my Moodle server database. Specifically, I'm encountering a persistent Cloudways error 524 and server timeouts. I am therefore looking for an expert with: - Deep knowledge in Moodle server databases who can troubleshoot and fix the error - Proficiency in server optimization to prevent future error occurrences and ensure seamless server performance - Familiarity with Cloudways would be a great plus, as I plan on reaching out to their support soon DO NOT put a Placeholder BID. Your role will involve diagnosing the issue, implementing a solution, and possibly optimizing the server to prevent this from reoccurring. Please confirm your relevant experience when bidding.

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...

I'm looking for a talented developer who can create a server for the old game Crossgate. The server should be accessible for casual gamers. Key Features: - Player Matchmaking: The server should facilitate the process of players finding and joining games. - In-game Chat Support: Implement a robust chat system to enhance player interaction. - Buy/Sell Special Items: Enable players to trade special in-game items. - Event Creation: Develop a feature that allows for the creation and management of in-game events. Ideal Skills and Experience: - Proficiency in server-side programming languages like Java, C++ or Python. - Previous experience in developing game servers and a solid understanding of networking protocols. - Familiarity with creating matchma...

I'm looking for a proficient SQL professional with notable expertise in SQL Server 2019. Key tasks will involve: - Query optimization - Database design - Data migration The ideal candidate should have a solid understanding of SQL Server tools and a proven track record in handling similar projects. Your previous experience and knowledge of SQL Server 2019 will be pivotal in this role. Your task will be primarily centered around maximizing the efficiency and effectiveness of the SQL Server. Preference will be given to professionals with certifications in SQL Server 2019 or related fields. Solid written and verbal communication skills are desirable.

I need someone skilled in WordPress migration to move my old wordpress website to a new server. Ideal skills would certainly include WordPress expertise, familiarity with different hosting platforms, and a problem-solving approach to unforeseen challenges. Experience in crisis management would also be desirable as not all the necessary information is available at this stage.

I have a whm server with multiple wp blogs using wp automatic, a plug-in that has had multiple backdoors over the years, the plug-in is updated but the server probably has shell scripts or malware running

...understand and implement complex backend features in my apps. - Firebase rules: A good understanding of how to set secure and efficient rules in Firebase is essential. - State management: I need to understand advanced state management techniques in FlutterFlow. - Data handling: I need to learn how to efficiently handle data within my applications and understand the best practices. I am a veteran PHP SQL developer and I find it difficult to wrap my mind around nosql and mobile app development in general. I am looking for: - An individual with advanced knowledge and experience in FlutterFlow. - Someone who can teach effectively in a one-on-one setting. - A patient mentor who can break down complex ideas into easily digestible concepts. - IMPORTANT: we need to understand each othe...

As an exper...experience in Laravel and you're familiar with Laravel 11. • You've previously developed websites using Laravel 11. • Your forte is optimizing code efficiency and database queries. • You have a strong understanding of how to improve page load times and database query speed. Your task: • Optimize my existing codes in Laravel 11, for open source project • Main areas for optimization include database queries and code efficiency • The goal is to achieve faster page load times and improved database query speed. • Test subscription and plans, if it works fine or not Please, only apply if you have the mentioned skills and experience and you're able to demonstrate evidence of past projects you've optimized for p...

I am looking for someone who can effectively install a simple server on Ubuntu and configure Wireguard / WG admin panel along with pihole. Your tasks will be; - Configuration of a fully accessible Wireguard WG admin panel - Setting up pihole on the server About 10/20 mins work depends Full access will be given Those who have prior experience in Linux server installation, Ubuntu system management and Wireguard configuration are highly desirable. An understanding of pihole configuration will be a plus. Complete details will be shared once I identify the right professional.