Sql server 2005 stored procedures jobs

...project requires setting up separate server instances for various domains, ensuring secure and reliable developer access, and delivering thorough documentation for ongoing maintenance. ————— Scope of Work 1. Website Instances and Hosting Setup The project involves configuring the following websites. Each domain will have its own server instance, except one instance hosting two websites: • Instance 1: , (Maintenance page) • Instance 2: • Instance 3: • Instance 4: (currently hosted at ) • Instance 5: • Instance 6: • Instance 7: • Instance 8: • Instance 9: • Instance 10: Build server for MERN stack websites ————— 2.

...GraphQL integration for data exchange. Database: Use WordPress’s default database for backend operations. Development Workflow: Code versioning using Git. Pair programming mode with real-time collaboration. Strict adherence to coding standards and best practices. Security: Implement robust security measures to protect user data. Prevent SQL injection, XSS, and other vulnerabilities. Performance: Optimize for fast load times and minimal server response times. Who Should Apply Experience: Minimum 3 years of hands-on experience in JavaScript and building headless CMS solutions. Skills: Proficient in JavaScript, WordPress REST API/GraphQL, and modern frontend frameworks. Work Ethic: Committed to delivering high-quality code with no shortcuts. Availability...

I'm looking for an experienced freelancer to help clean up my Ubuntu server. The project involves optimizing disk space, so it's crucial to have a good understanding of Ubuntu system management. The ideal candidate should have: - Extensive experience with Ubuntu server management - Strong skills in identifying and removing unnecessary files - Ability to organize files and directories efficiently - Familiarity with disk management tools Please note, while I haven't specified crucial data or applications, some files and applications will need to be preserved during the cleanup. I have no automatic disk management tools currently in place.

I'm looking for an expert in World of Warcraft server creation to set up a PvE server based on the Wrath of the Lich King expansion. The server should closely mirror the original Blizzard experience, hence the term 'Blizzlike'. Key requirements: - Proficient in creating and managing WoW servers, especially PvE ones. - In-depth understanding and experience with the Wrath of the Lich King expansion. - Ability to customize the server for a 'Blizzlike' experience without extensive modifications or custom content. - Knowledge of server maintenance and troubleshooting. The goal is to create a server that delivers the authentic WoW experience, appealing to players seeking a nostalgic journey through Azeroth. Please provide exam...

I'm looking for a professional animator who can create an engaging 3D onboarding video for new employees. The video should cover several key components of our company, including: - Company Culture - Policies and Procedures - Our Mission, Vision, and Values - A warm "Welcome to the Team" - An explanation of "Our Why" - An emphasis on "Safety Is Our Foundation" - A discussion on "Diversity, Equity, and Respect" The ideal freelancer for this project should have a strong portfolio in 3D animation and a knack for storytelling through animation. Experience with creating corporate training materials is a plus. The goal is to create a video that not only educates but also makes new hires feel welcomed and valued.

I have a android app and need to use FireStoreUI and recyclerView to show data , and data in firestore is stored in Map data type.

I'm in need of a mobile Android application that records and saves user interactions, specifically phone calls and in-app messages, to a remote server. Key Components: - The app primarily serves for user monitoring - It should be capable of tracking in-app messages and phone calls - All recorded data should be stored remotely on a server Ideal Skills: - Proficient in Android app development - Experience in implementing call recording functionalities - Knowledge of server integration for data storage - Understanding of user monitoring applications - Ability to ensure data privacy and compliance with regulations Please note, the focus of this application is on monitoring user interactions for quality assurance and research analytics purposes. Your experti...

I'm looking for a Postgres server expert to assist with my database. Please reach out if you have the necessary skills and experience.

Hello! I use HubSpot CRM to manage patients and surgeries in my medical practice, and I’m looking for a skilled freelancer who can: Provide comprehensive training on using HubSpot (contacts, deals, pipelines, reports, etc.). Customize HubSpot to suit my specific needs, including: Building pipelines for surgical procedures. Adding custom fields (e.g., surgery date, type of surgery). Setting up automation workflows for reminders and processes. Integrating HubSpot with Google Calendar or other tools. What I’m looking for: Proven experience with HubSpot CRM. Ability to provide tailored solutions for healthcare or similar industries. Online training capability. A friendly, communicative approach. What I offer: Immediate collaboration. Clear requirements and objectives. Com...

...price later. 2. This is a fixed-cost project. 3. We will make the full payment on completion as we have burnt our hands before as developers were unable to create projects and we had wasted time I need assistance installing the git library on my cPanel. The task includes converting the Postgres SQL to a fresh MySQL database. Key Requirements: - Install from the provided git repository on cPanel. () BRANCH - MAIN - Convert the Postgres SQL to a new MySQL database. You can use the suggested tool or any similar one for this task. (Use this or any similar library - ) - Ensure the MySQL database is set up using the default configuration. Ideal Skills and Experience: - Proficient with cPanel

I'm looking for a well-structured, comprehensive weekly schedule template for my dental office. This template will help manage patient appointments and coordinate our dental procedures. Key Features: - Appointment Times and Durations: The template should allow for precise scheduling of each patient's appointment. - Dental Procedures Type: There should be a section to denote the specific procedure each patient will be undergoing and the monetary production associated with each appointment type, with calculations of daily and weekly production. - Provider Designation: It needs to include space to designate where providers are used during appointments, to keep providers efficiently moving from patient to patient. - Procedure Difficulty/Stress Level: It should have a...

Looking for someone that given DB access with different tables is able to provide a mysql query for some conditions with different tables and rows result. If task well done there'll be more sql queries to perform.

I need assistance troubleshooting my Webmin installation on a fresh Ubuntu 24.04 server. After following a guide to set up Webmin and install a free Let's Encrypt SSL certificate, I am unable to access my domain due to an SSL certificate error. I have confirmed that the SSL certificate is active and have double-checked the file paths in Webmin. What I need: - A freelancer to identify the issue and guide me on how to fix it. - A detailed document outlining what I did wrong, to assist if I need to start from scratch again. Ideal skills and experience include: - Proficiency with Ubuntu 24.04 and Webmin - Experience troubleshooting SSL certificate issues - Ability to provide clear, understandable documentation

I'm in need of a seasoned Playwright expert with a strong Java background. The task involves creating a Playwright script to conduct end-to-end testing on the Chrome browser. Key Requirements: - The script should automate the full testing cycle, ensuring every aspect of the application is thoroughly examined. - The testing process needs to incorporate all authentication procedures, specifically login and logout sequences. Ideal Skills: - Proficient in Java with substantial Playwright experience. - Previous experience in creating end-to-end testing scripts. - Comfortability and familiarity with Chrome browser. - Understanding of authentication processes in web applications.

...wearing standard OHS gear (e.g., hard hat, safety vest, goggles, gloves, etc.). The design should be professional and visually aligned with our branding, focusing on trustworthiness and clarity. Functionality & Interaction Interaction with users will be structured and guided, rather than open-ended or conversational. The avatar will deliver step-by-step instructions related to the app’s safety procedures, training modules, and user tasks. The goal is to enhance user experience by providing engaging, clear, and concise prompts or guidance. Integration with AI-Driven App Our application utilizes AI for industrial safety processes; however, the avatar will primarily function as a UI/UX element that presents instructions. We want the avatar to reflect an “AI presenc...

I need someone to help me increase a raid1 disk on a linux server, I would like to increase the storage space

...implementation: --- ### **1. Customer Management** - **Create Customer**: - When a new customer is added to the `customers` table in the MySQL database, automatically create the corresponding customer in Paystack using the `/customer` API endpoint. - Set the customer's risk action to `'allow'` via the `/customer/set_risk_action` endpoint. - Ensure the customer's unique Paystack ID is stored in the database for future reference. - **Deactivate Customer**: - When a customer is deactivated in the system, update their risk action to `'disallow'` using the `/customer/set_risk_action` endpoint. --- ### **2. Payment Page** - **Endpoint**: - Create a payment page at `/paymentrequest` where logged-in users can initiate payments. - **Imp...

Objective: To develop a Windows-based program that automates the collection of specific information (phone numbers, business names, addresses) from a target website requiring login. The program will also compare newly extracted data with previously stored data to identify additions, updates, and deletions. It should handle dynamic content loading (e.g., infinite scrolling) and provide effective management and export of data. The user interface will primarily be in Korean. Key Features: Web Scraping: Automates login and data extraction from a specified website. Handles dynamic content loading (e.g., infinite scrolling). Extracts structured data: phone numbers, business names, and addresses. Data Management: Displays extracted data in a table format within the program. Saves data ...

...structured around it, making the centre of the screen a point with coordinates (0,0) The camera frame wont be moving with the character, it will be a classic 2d game with fixed borders Now there will be a timer for every level too, starting from time: t=0, until the character dies ofcourse. now another thing, as soon as the timer starts, the position of the character (playable dot) starts being stored for every 1.5 seconds. this is done by taking and recording the coordinates of the dot after this time interval as it moves across the screen in that time period due to the player controlling kt ofcourse while all of this is happening, the y coordinates of each point is considered and at that moment an arrow type thing is fired at the y level from the left of the screen, which has...

Hello, I am looking to integrate WalletConnect into my Toke...the TokenLite script and ability to develop solutions that fit its Laravel-based architecture. Knowledge of WalletConnect’s QR code connection system and transaction signing processes. Deliverables: A fully functional WalletConnect integration with the TokenLite platform. Users can securely connect their wallets and complete payment transactions. Wallet information and transaction statuses are stored and managed within the Laravel backend. The entire process is smooth and secure, offering a great user experience. Additional Information: The TokenLite script is built on the Laravel framework, so expertise in Laravel is essential for this project. Blockchain knowledge and experience with WalletConnect integration are...

I'm in need of a PHP script that will be hosted on a web server. Its primary role will be to download backup files from a ftp server to a specific folder on the CPanel installation. Description: The php site should be under The script should show following messages when running: Login Password on site(a static login to be able to run the script) Login to FTP Server Extract all files in the specific folder and show them in a drop down list Be able to chose in the drop down list which file to download Click on button Download Showing in realtime % how much has been downloaded. Confirming when the download is done Log out All steps should follow with an acknowledgement that it is done or if an error occurs it should explain what has gone wrong. Ideal Skills:

I'm looking for a web scraper who can scrape some sites for me on a daily basis using a script. The specific data to be scraped will be discussed further. Ideal candidates for this project should: - Have experience with web scraping, especially in selenium and python - work on ms sql server

I'm looking for a developer to create a Telegram bot that allows users to pay with cryptocurrency for a set number of searches. Each search involves submitting a photo, name, city, and age. The data is sent to the admin's Telegram account, where the admin can respond with results and mark the request as complete. The data is stored temporarily on Google Cloud for one week and automatically deleted afterward. The system also tracks usage statistics and generates insights. Prefer python. User Workflow 1. Payment Integration: Users pay with cryptocurrency through an integrated payment system (e.g., CoinPayments, Binance Pay). After payment confirmation, the bot updates the user's account with a balance of searches (e.g., 5 searches). 2. Data Submission: Users sub...

I'm in need of a proficient SQL database specialist who can help with optimizing and scaling my current SQL database. Key Tasks: - Improve query performance - Data indexing - Storage management Goals: - Enhance data retrieval speed - Expand data capacity - Ensure the database scales effectively Ideal candidates should have extensive experience with SQL databases, particularly in query optimization, data indexing and storage management. Skills in improving database retrieval speed, increasing data capacity and effective scaling are crucial.

Hi I'm using Oracle 19c database. I created a new user/schema called MM_UAT and given the required grants. I want the MM_UAT user only to see the DB_OBJECTS of other schemas or specific schema. My required DB_OBJECTS like tables, views, functions and procedures seems OK. but there's a problem. If I right click and open a package like PRODN.PKG_REPORTS and i click "view spec & body", i cannot see the body i see only the specs. I have given extra permissions as well to check if they work: GRANT EXECUTE ANY PROCEDURE TO MM_UAT; GRANT DEBUG CONNECT SESSION TO MM_UAT; GRANT SELECT ANY DICTIONARY TO MM_UAT; GRANT SELECT_CATALOG_ROLE TO MM_UAT; GRANT SELECT ON DBA_SOURCE TO MM_UAT; GRANT EXECUTE ON PRODN.PKG_REPORTS TO MM_UAT; CREATE OR REPLACE VIEW SYS.PRODN_P...

...Architecture**: - Employed **Node.js** for efficient server-side JavaScript execution, accommodating numerous concurrent users. - Integrated **Express** framework to manage HTTP requests and routing, ensuring smooth user interaction. - **Routing and Navigation**: - Implemented **HTTP GET** method for navigating between different routes/pages linked in the website's navigation bar. - **User Interaction**: - Created a **Contact Page** enabling users to submit their information, facilitating future engagement. - Ensured submitted data is stored in a database, enhancing user registration and involvement. - **Database Management**: - Leveraged **Mongoose** as an Object Data Modeling (ODM) tool for **MongoDB**, a NoSQL database. - Stored data in a JS...

I am looking for someone who can take on the task of porting the online MMORPG game *MU Online* to mobile. The idea is that players can log into their accounts from either a PC or a mobile device. The game was originally released in 2003. I am available to discuss the details in a private conversation.

I'm looking for a professional who can assist in launching my fully developed Android application onto the Google Play Store. Key Requirements: - Expertise in Android app deployment - Familiarity with Google Play Store's release procedures Please note, I do not require assistance with app testing prior to the release. The app has been tested thoroughly and is ready for the market. Your task will primarily involve helping to navigate the release process smoothly and efficiently on play store

I'm looking for a skilled developer to create an integration for UPPY with TUS (Resumable File Uploads) on my Plesk server. The endpoint should be a subdomain on the same server. Key Project Details: - The main purpose of this integration is to facilitate the upload of documents with uppy in my APP. - There is no need for user authentication for uploading files. - i give you acess t all code to understand the final goal Ideal Skills: - Proficiency in server management, particularly Plesk. - Extensive experience with UPPY and TUS. - Strong understanding of document handling in server environments.

I require a professional with experience in Linux server management and Matrix installation for a single-user setup. Key Requirements: - Proficiency in Linux server management - Prior experience with Matrix installation () - Capability to set up a single-user environment I have root access to the server, so you will have full control over the installation process. Please note that this is a single-user setup, so the installation should be tailored accordingly.

I have an Microsoft MVC Web App with a target framework of .NET 8.0 that accesses a Microsoft SQL Database on my local machine. I am using Entityframework as well as Dapper to access the database. Everything runs successfully on the local machine. I have uploaded the local Web App to an Azure Web App using a compressed *.zip file. I have uploaded the local SQL Database to an Azure SQL Database using a *.bacpac file and restored the database. I have added the correct secrets to an Azure Key Vault. Everything works on my local machine. From Azure the Web App opens as expected and I can view all static pages correctly. I am unable to connect from the Azure Web App to the Azure SQL Database. I keep getting the following error .......[03:29:46 ERR] An exception ...

So I am studying early childhood education. And did my final prac and we were given 20 reflective journals to complete. Such as doing collaboration and finding issues in our centre. I did my tasks, and teacher giving remarks which make no sense such as this is my centre policy any procedures and any way I have to do it. Further told me I used ai, but I already got Turnitin Ai report, in that it told false positive, and no paragraph were highlighted as Ai out of 13K words of assignment. When i asked to share their proof. They were sharing non official third part ai detectators reports instead of official Turnitin reports. I showed them the official Turnitin report for the specific paragraph they showed me. Were there was no ai, and like them I shared 3 other ai detectors for...

...password during registration or use the OTP system. 3. Forgot Password Workflow: - Customers can request a new password. - A reset link or OTP is sent to their email or phone number for verification. 4. Security Enhancements: - Two-factor authentication (optional): Extra layer of security using an OTP in addition to a password. - Encrypted Data: All passwords and sensitive information are securely stored using encryption....

I am seeking a developer with prior experience in creating RFID apps for Zebra devices. The app should primarily focus on inventory management and must be able to connect to a local SQL/MySQL server via Wifi and zebra device using bluetooth. Key Features: - Real-time inventory updates: The app should reflect inventory changes in real time to ensure accurate tracking and management. Ideal Skills: - Extensive experience in RFID Zebra app development - Proficient in Android app development - Knowledgeable in SQL/MySQL server connectivity - Experienced in Bluetooth interfacing

...over the past month. This website is built in PHP, with a SQL database and the Smarty framework. Many features are currently non-functional including: - Filters: The Location filter, Subject filter, and Experience filter are all down. - Job Vacancies: These are not displaying properly. - Search Functionality: This feature is also not working. We are receiving the following error messages: "Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, bool given in /home/teachers/public_html/ on line 290" "Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, bool given in /home/teachers/public_html/ on line 460" Please note, there have been no recent changes to the website or server that could have caused these issues. I am loo...

Instalation and configuration of a multi tenant JavaScript/Type script application on docker. Stack used is Javascript/Maria DB/SQL on docker containers. We need setup along with payment gateway integration Lemon Sqeezy

I require a skilled professional to facilitate the integration of SQL Server with my Unity project. This involves setting up a periodic data sync specifically for game state data. Key Responsibilities: - Establish seamless periodic syncing of game state data between Unity and SQL Server. - Ensure data integrity and timeliness during the syncing process. Ideal Skills: - Proficiency with SQL Server and Unity. - Experience in game development and data management. - Strong problem-solving skills to troubleshoot any potential issues during the setup.

I'm seeking a skilled penetration tester for my web application. The primary objective of this test is to identify any potential vulnerabilities, with a specific focus on SQL injection risks. Ideal Skills and Experience: - Proficient in penetration testing for web applications - Expertise in identifying and mitigating SQL injection vulnerabilities - Familiarity with various penetration testing tools and methodologies - Strong understanding of web application security standards and practices - Excellent communication skills for reporting findings in a clear and actionable manner

Please Sign Up or Login to see details.

...integrity under various load conditions, including full load, transportation, and operational stresses. • Regulatory Compliance: Ensure designs comply with relevant industry standards and regulations, including safety and environmental guidelines. 5. Prototyping and Testing (Optional): • Prototype Development: Assist in the development of prototypes for physical testing and validation. • Testing Procedures: Design testing protocols to evaluate performance, durability, and safety of the prototypes. Deliverables: • Comprehensive design reports outlining improvement strategies and design rationale. • 3D CAD models in editable formats (e.g., .STEP, .IGES) and high-resolution renderings. • Detailed technical drawings and cutting lists ready for ma...

I'm looking for a skilled developer to create an AI that can perform facial recognition from pictures, primarily for personal use. Key Requirements: - The AI should help identify people in home photos. - It needs to be able to analyze pictures stored in albums and picture frames. - The AI must be designed to run primarily on a smartphone. Ideal Skills: - Proficiency in AI and machine learning. - Experience in developing smartphone applications. - Understanding of facial recognition technology. Please note that the intended use of this AI is strictly personal and non-commercial.

I need to install cPanel on my dedicated server running Nginx. I have root access to the server. Ideal Skills: - Extensive experience in cPanel installations - Proficient in Nginx server configurations - Dedicated server management expertise Please be prepared to demonstrate prior successful projects of a similar nature. Thank you.

I'm looking for a gaming streamer who can bring my brand new FiveM ESX server to life. The focus will be on live role-playing sessions, delivering content that is not just entertaining, but also engaging and interactive. Ideally, you should have a strong presence on Twitch, as that is the platform we'll be utilizing. Key Requirements: - Experience with live role-playing gaming content - Proven track record on Twitch - Ability to create engaging, interactive streams - Familiarity with FiveM ESX servers is a plus but not mandatory - Excellent communication skills Your role would be to lead the stream, interact with viewers, and create a sense of community around our server. If you have a casual and humorous style that's also professional and informative when n...

I am starting a new project and need an expert in Google Cloud's Compute Engine. Key Tasks: -Create a VPC in google cloud . -Create postgres sql DB in gcp . - Instance Management: Creating, configuring, and managing virtual machines. - Load Balancers: Setting up load balancers to ensure optimal distribution of traffic and resources. - Security Configurations: Implementing necessary security measures to protect the instances and data. Ideal skills and experience: - Profound knowledge and experience with Google Cloud's Compute Engine. - Proven track record in instance management and load balancer setup. - Strong background in security configurations. - Excellent problem-solving skills and attention to detail. - This needs to done on a remote machine . - Should be availab...

أحتاج لمطور واجهات خلفية ذو خبرة لتطوير البنية التحتية لموقع تجاري إلكتروني. على المطور بناء الوظائف الأساسية للموقع مثل تسجيل الدخول، السجلات، ومعالجة البيانات. المهارات المطلوبة: - اتقان لغات البرمجة الأساسية، خصوصا JavaScript (Node.js) - خبرة بقواعد البيانات مثل MySQL أو MongoDB - القدرة على تأمين البيانات باستخدام HTTPS - مهارات في منع الثغرات مثل SQL Injection وXSS الموقع سيحتوي على: - نظام إدارة المنتجات - نظام الدفع الأونلاين - تتبع الطلبات

I'm looking for a skilled professional to upgrade my server 2008, 2012, and 2016 Virtual Machines to Server 2025. - The primary goal of this upgrade is compliance. - Post-upgrade, these servers need to support business software. While there's no immediate need for specific business software to be installed after the upgrade, the server should be capable of running accounting software, Customer Relationship Management (CRM) software, and Project Management software in the future. Ideal candidates for this project should have: - Extensive experience with server upgrades. - In-depth understanding of various business software. - Excellent problem-solving skills to ensure seamless transition and compliance post-upgrade. Please note, the upgrade need...

I need a skilled professional who can encrypt 6 of my database tables using AES 256 with IV via openssl. The encryption should cover personal information as this is paramount for enhancing the data privacy for my users. Furthermore, I require the SQL queries to be updated for the PHP front end. Key Requirements: - Proficient in database encryption, particularly using AES 256 with IV and openssl. - Strong skills in SQL and PHP. - Experience with personal data encryption for enhancing data privacy. If you're able to meet these requirements and help with this project, I look forward to your bid.

I'm looking for assistance in setting up a manual transfer system for my paycheck from the USA to India via PayPal. The goal is to facilitate seamless, timely transfers that can support my needs. Ideal Skills and Experience: - Proficient understanding and experience with PayPal - Knowledge of international money transfer regulations and procedures - Experience in setting up manual transfer systems - Excellent communication skills for updates and clarifications. Please note, this project does not require automation, but a keen attention to detail and reliability is essential. I am open to discussing strategies for optimizing the transfer process.

I need assistance in migrating my websites from my current dedicated server to a new one. Here's the Work Checklist: 1. Install CPanel on new server 2. Move all my sites from the old server to the new server (both servers have CPanel/WHM) 3. Make sure one of my websites has it's own 2TB hard drive dedicated to it 4. Assign dedicated ip address to each website (super simple thru WHM) 5. Make sure mx records pass every test, if not, please make it so it passes every test. 6. Make sure there are no errors on the websites (I'll help in checking this), if there is errors, let's fix it (maybe we have to update php, etc.) That's all! I have all the login info for both servers and domain register. We are using Centos 8 by the way.

Need some consulting on the best method to get the raw schema from dynamics business central cloud in either json, SQL DDL or some other format so that it can be visualized in a database modelling software. Looking to get: table name, field id, field name, field type, primary keys, foreign keys and relate table names. Through VS code you can download all the symbol .al files where each file contain the complete raw schema of each table but I have only been able to use parsing in python to get this information and its very error prone. There is also the 3rd part site but I'm looking for full control of the output to put into stand alone data modeler. There's also some vs code plugins like AZ AL Dev Tools but there is no export options. Just looking for advice on best s...