Sql server 2005 stored procedures jobs
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 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...
Wordpress website. is showing error , need to resolve it. We ll give putty ftp credentials. But we don't have AWS credentials
I'm seeking a seasoned Data Scientist/Data Engineer for an ambitious project that unites SQL data modeling, natural language understanding (NLU), and data standardization. Your expertise with key technologies such as Streamlit, Langchain, LLM, Python Data Faker, and SQL will be essential. If you have experience with AI agents, that's a bonus! The main focus of the project will be on NLU, specifically: - Entity recognition - SQL generation - Data model reasoning Prototyping will be done in Python on a private GitHub repository I will set up. Payment will be milestone-based, not hourly. A PhD in Data Science or a related field from a top university is preferred, as well as a minimum of 5 years' experience in data science and data engineering.
I'm looking for an experienced Firebase developer to help design a document storage system. The system will require: - Uploading and downloading of documents - Searching and retrieving stored documents All of these operations need to be done with public access. The ideal candidate for this project must have a deep understanding of Firebase's capabilities and security measures. Experience in creating similar systems will be a significant advantage.
I am facing performance issues with my Laravel-based photo stoc...performance issues with my Laravel-based photo stock website when uploading bulk images. Here's an overview of the problem: Issue Description: Bulk uploads of images (both AI-generated JPGs and regular camera photos) cause the server to slow down significantly. When images reach 99% upload, other pages and requests become unresponsive. The issue occurs regardless of the type of image file, but it is more noticeable during bulk uploads. Environment Details: VPS Specifications: 16GB RAM 8-Core CPU CyberPanel Installed Tried stripping metadata using ExifTool. Adjusted server settings for LiteSpeed and PHP. Tested with different types of images, including AI-generated and regular camera photos. The scrip...
I'm seeking a professional to set up a mixed PvP/PvE, cross-platform, custom hunts Tibia server from scratch. The server should include: - Various custom hunts - Premium account features - Mounts - All relevant game details The ideal freelancer should have extensive experience with setting up online game servers, particularly Tibia, and a deep understanding of both PvP and PvE elements. The project offers a potential for a mutually beneficial long-term agreement based on the quality of work and expertise demonstrated.
I'm encountering certificate validation errors with a simple TLS server using the sample given in the OpenSSL wiki. The server is set up using OpenSSL and is using self-signed certificates. Although the clients are configured to trust these self-signed certificates, the validation errors persist. The current error says that the Certificate Authority is invalid. I have set up the environment for the project. It is running on Windows. The ideal freelancer for this project should have extensive experience with OpenSSL, TLS servers, and self-signed certificate configurations. Please include details of your relevant experience in your bid. I am attaching the code. I will pay a maximum of $50 for this.
We are seeking highly motivated and experienced D...Time Management & Organization: Excellent time management and organizational skills. Ability to manage multiple deliveries efficiently and prioritize tasks. Technology Proficiency: Comfortable using a smartphone and navigation apps. Basic understanding of GPS and mobile technology. Professionalism: Maintain a professional appearance and demeanor at all times. Adhere to all company policies and procedures. Benefits: Flexible Schedule: Control your own schedule and work when it suits you best. Opportunity to earn income on your own terms. Competitive Earnings: Earn competitive delivery fees and tips. Potential for bonuses and incentives based on performance. Growth Opportunities: Opportunity to increase earnings and expand your ...
I'm facing a database connection issue on my ASP.NET web page after installing an SSL certificate. The site, built around 10-12 years ago, uses an SQL Server database. Key Requirements: - Troubleshoot and resolve the database connection error - Ensure the site's overall functionality post-fix Ideal Skills: - Proficient in ASP.NET and SQL Server - Experienced with SSL certificate installations and their implications on database connectivity - Strong problem-solving skills to diagnose and fix the issue efficiently
...Offers a user-friendly dashboard to view all key vehicle data at a glance. 4. Live Streaming Enables real-time video streaming from the vehicle cameras. Supports switching between cameras (e.g., front, rear, left, and right views) during live streaming. Includes playback controls for pausing or taking screenshots during the live stream. 5. Recorded Video Access Access previously recorded videos stored on the vehicle DVR or external storage. Search and filter videos based on: Date and time. Camera location (front, rear, left, right). Event type (e.g., AI-detected, normal driving). Download selected videos to the mobile device for offline access or sharing. 6. Settings Synchronization Remotely manage and sync system settings with the in-vehicle DVR system, including: Video recor...
I need assistance with the AA02 form for my UK LLP. The task includes: - Submitting the completed form to Companies House - Help with understanding and filling how make it online Ideal candidates should have experience with UK Companies House procedures and be familiar with the AA02 form. Prompt communication and attention to detail are crucial for this task.
I am looking for an expert to help me automate my lead tracking and follow-ups. Currently, I am primarily working with contact information stored in Excel. Key Requirements: - Experience with lead data management - Proficiency in Excel - Skills in automation tools and scripts The ideal freelancer for this project should be able to streamline my lead management process, making it more efficient and less time-consuming. Prior experience with CRM software is a plus, though not a necessity. Your understanding of tracking systems and automation will be crucial for the success of this project.
...practices Focus Areas: Robust functionality, seamless user experience, and scalable architecture Key Responsibilities: Develop and maintain both the front-end and back-end of the web and mobile applications. Collaborate with UX/UI designers to implement intuitive and engaging user interfaces. Ensure the performance, quality, and responsiveness of applications. Integrate user-facing elements with server-side logic. Optimize applications for maximum speed and scalability. Implement security and data protection measures. Troubleshoot and debug issues across platforms. Stay updated with emerging technologies and incorporate them into the development process as needed. Required Skills and Qualifications: Full-Stack Development: Proven experience with both front-end and back-end tech...
I'm looking for an experienced backend developer to set up a TUS Protocol Server on my Linux server. This server should be configured to work seamlessly with my main application that runs on Node.js and utilizes Uppy for file uploads. Key requirements: - Expertise in Node.js and server management - Experience with TUS Protocol Server - Familiarity with Uppy - Linux OS proficiency Please note, I did not specify any custom configurations for the TUS Protocol Server, so the default settings should suffice. However, the server must be capable of handling the demands of my main application and Uppy concurrently.
I currently have significant query performance issues with my Microsoft SQL Server Database hosted on Azure. The system is built with .Net and I need a skilled developer to enhance its performance, specifically focused on improving the speed of database queries. Key Tasks: - Troubleshoot and resolve query performance issues with the Azure SQL server - Configure and performance tune Rabbit MQ for optimal system efficiency - Improve the overall system response time - Eliminate any existing delays in the system Ideal candidates will have proven experience with Azure, .Net programming, Microsoft SQL server, and Rabbit MQ. Your goal will be to enhance the performance of the system to ensure smooth and efficient operation.
I'm seeking a professional to install a Domain Validated (DV) SSL certificate on my Linux server, specifically running on Fastboot. The installation needs to be done using remote access via the Fastboot console. Ideal Skills: - Extensive experience with SSL certificate installations - Proficient in Linux system operations - Familiarity with Fastboot console - Remote access tools expertise - Attention to detail for security compliance
Discord developer to create a state-of-the-art Discord server tailored for a basketball league community (True2Hoops League). This server will be professionally organized, highly automated, and feature unique functionalities that go beyond basic bots, incorporating custom programming and integrations for an elite-level experience.
I need support with integrating SQL Server Reporting Services (SSRS) with my Azure Virtual Machine (VM). Details: - The primary focus is on establishing communication between SSRS and Internet Information Services (IIS). - While I mainly need help with SSRS integration, I have an ASP.NET application that may require some debugging, so skills in ASP.NET are a plus. - Experience with Azure VM, SQL and SSRS is essential. Im getting Asp.net session expired Please let me know if you can assist with this.
...currently sitting on a Windows server but was originally running on an Ubuntu 20 server. My preference is to deploy it on a Linux server, specifically Ubuntu. Key Requirements: - Deploy the project on a Linux server (Ubuntu preferred) - Configure Nginx and PM2 for the server - Connect my registered domain to the backend - Provide instructions for future self-deployment My frontend is hosted on a different domain, so the backend needs to be connected to my registered domain. Post-deployment, I would need clear instructions on how to deploy the server myself in the future. Ideal Skills: - Extensive experience with Node.js, React.js, GoLang, and PostgreSQL - Proficiency in setting up and configuring Nginx and PM2 - Familiarity with domain connec...