Sql server 2008 query latitude longitude radius trabalhos
We are going to move a server which today has Windows 2016 x64 STD installed to new hardware and in that connection, maybe a newer version of windows is an idea? You must be responsible for the entire process and ensure it works after the move.
Job Title: Senior Full Stack .NET Developer Monday to Friday 2-3 hours/day IST Night (7am to 11am IST) Salary: 25,000 INR per month J...Salary: 25,000 INR per month Job Description: We are seeking a highly skilled and experienced Senior .NET Developer to join our team. The ideal candidate should have strong proficiency in C#, ASP.NET MVC, and the .NET Framework, along with expertise in various web-related technologies such as HTML, CSS3, JavaScript, and jQuery. Additionally, familiarity with database technologies including SQL Server and T-SQL is essential for this role. One needs to be available in the mentioned timings and willing to work by screen share and remote control via Zoom. Skills Required: C# ASP.NET MVC .NET Framework Entity Framework HTML CSS3 JavaS...
...approval process for time submissions** where hours submitted by employees must be approved by an administrator before being finalized. ## **Technical Specifications:** - **Frontend:** Responsive design using Bootstrap for the web dashboard and adaptive layouts for iOS and Android apps. - **Backend:** Python (with frameworks such as Flask or Django) to handle server-side logic, API endpoints, and database integration. - **Database:** SQL (e.g., PostgreSQL) for storing user data, time entries, projects, and tasks. - **Security:** Implementation of essential security measures including HTTPS, data encryption, and secure authentication processes. - **Mobile Development:** Native apps for both iOS and Android to ensure optimal performance and user experience. ## **Features:*...
I'm seeking a proficient developer to produce a sophisticated AI ChatBot that can easily interact with students in my Discord server. Majorly, it should aid students with inquiries, supply study resources, and present quizzes across various GCSE subjects. It needs to have the capability to explain and summarize topics well. The ideal specialist for this task should possess the following key skills: - Good understanding of AI and chatbot development - Familiarity with Discord APIs - Proficiency in natural language processing - Strong skill on basic text-based responses Our AI ChatBot doesn't need to interact via voice responses, but it should have a natural language processing ability for text-based responses. The overall goal is to enhance our student's learning ex...
...skilled professional to help me set up a Tekkit 2 server. I'm currently undecided between using a server gamepanel or setting up a dedicated Linux server. Key Requirements: - Comprehensive understanding of setting up Tekkit 2 servers. - Proficiency in configuring server gamepanels. - Flexibility to work with any server gamepanel, as I haven't decided on one yet. Your role will include: - Assisting me in deciding between a dedicated Linux server or a server gamepanel. - Setting up the chosen platform. - Ensuring smooth operation and functionality of the Tekkit 2 server. - Arranging plugins and configuration of permissions. Ideal Skills: - Experience with server gamepanels like Multicraft, Pterodactyl, or TCAdmin...
As a business with a medium-sized SQL database, my aim is to enhance data interpretation and decision making by utilizing Microsoft Power BI for data visualization, interactive dashboards, and comprehensive reporting. Key Requirements: - Expertise in Microsoft Power BI to analyze database. - Experience with SQL and understanding of data volume (1GB - 10GB). - Ability to visualize data through charts and graphs, create interactive dashboards, and generate comprehensive reports using Power BI. - Familiarity with implementing security measures, including data encryption, user authentication, and permission-based access control. Please bid if you have the ideal skills and proven experience. Your bid will be evaluated based on your expertise, client feedback, and cost-effective...
I have a AWS Infrastructure setup project requiring expertise in Cloudfront NLB and protection using WAF. As the goal is targeted at content distribution and load balancing, proficiency in these areas ...to access website on EC2 IIS with custom ports like 8080, 5440 etc and not standard 80 or 443. User will be providing url with port number and on IIS different website is binded with different port number. For WAF, protective measures against DDoS attacks, SQL injections, and XSS attacks are necessary. Thus, an understanding of these areas is also needed. Skills and experience: - Proficient in AWS services (Amazon EC2, ELB, Cloudfront and Amazon S3) - Knowledge of Cloudfront NLB - Experience with WAF - Understanding of DDoS attacks, SQL injections, and XSS attacks protecti...
I'm currently seeking an experienced Linux system administrator to connect my Ubuntu-based Digital Ocean server to a Pterodactyl panel. Your tasks for this project, ideally completed within a short timeframe, will include but are not limited to: - Seamless connection of the server to the Pterodactyl panel. - Full preservation of existing user profiles on Pterodactyl during the process. What you should ideally have: - Proven experience in Linux System Administration, particularly with Ubuntu. - A solid understanding and hands-on experience with Pterodactyl panels. - Capability to process tasks with full root access. It's crucial that you know exactly what is required to ensure a secure and functional connection. Also, you should be able to solve any unforeseen is...
I've been struggling with getting the internet up and running on my physical RockyLinux server. I chose this OS for its stability and compatibility with CentOS, but I'm unable to activate the internet on it. I need help from a Linux expert who can guide me through this process. Key Tasks: - Troubleshoot and identify the root cause of the internet connectivity issue - Provide step-by-step guidance to activate Wired Ethernet connection Skills and Experience: - Extensive experience with Linux server administration, particularly with RockyLinux, CentOS or Debian. - Solid understanding of networking concepts, especially with regard to Wired Ethernet connections. - Proven track record of resolving connectivity issues on Linux servers.
...project involves handling an intermediate scale server system consisting of 6 to 24 servers. Key Requirements: - Expertise in cooling systems for electronics, specifically hydro cooling - Experience handling data server cooling Ideal Skills: - Knowledge of electronic thermal management - Previous work with server infrastructures - Fluid dynamics understanding Specifications of the machine: - Power consumption is 5.5kw and water flow rate is 8L per minute per machine. - Inlet water going into the machine should be between 27 C up to 30 C - Outlet water coming out of the machine should be between 30 C up to 35 C and should be cooled down to 25-27 before re entering the machine. This project requires a precise, efficient solution for managing server heat....
I need an expert who can swi...who can swiftly and efficiently upgrade my existing Windows Server 2012 to Windows 11. Considering the urgency of the project, I'd prefer professionals who can get started immediately and complete the task at their earliest. Though the primary function of the server is unknown, the professional should be well-versed with handling and preserving all potential features of the server. Ideal Skills: * Experience in computer systems networking and IT server management * Proficiency in Windows Server 2012 and Windows 11 * Ability to work under strict deadlines Please note the project needs to be completed ASAP. Before getting started, kindly provide some references or past work evidence of similar migrations and ensure min...
Hi Mohammad Jahirul I., I noticed your profile and would like to offer you my project. We can discuss any details over chat.
...vibrant, knowledgeable Microsoft SQL trainer for my client who can help me elevate skills to an intermediate level. Fluent Tamil communication is a must as I feel most comfortable learning in this language. Key Learnings Expected: - Database Creation: Learn how to build an efficient and well-structured database from scratch. - Querying and Managing Data: Gain expertise in extracting, manipulating, and managing data. - Advanced SQL Concepts: Explore more sophisticated SQL concepts to comprehend the language's full capabilities. Ideal Freelancer's Profile: - Experienced MS SQL tutor with a strong understanding of database creation, handling data, and advanced SQL topics. - Proficiency in teaching in Tamil. - Proven experience in educating a...
Installing and configuring dante-server on ubuntu alongside squid.
...that sends messages to customers when they enter or leave a location using geofence notifications: App Name: GeoNotify Features: 1. User Authentication: Allow users to sign up or log in to the app. Implement authentication using email/password or social media accounts. 2. Geofence Management: Provide functionality for users to create geofences by specifying a location on the map and setting a radius. Allow users to name the geofence and customize notifications for entry and exit events. 3. Message Composition: Enable users to compose messages that will be sent to customers when they enter or leave a geofence. Include options for formatting messages and adding dynamic variables such as customer name or location name. 4. Customer Management: Allow users to manage their customer li...
Seeking a SQL specialist (4-5 hr/day part time remote job) excelling in data partitioning, indexing, complex query calculations, and impeccable SQL design. Here's a snapshot of what my project entails: - Enhancement of a medium-scale database (1,000 - 10,000 records) using best practices - Expertise in SQL Design for efficient data management - Aptitude for complex query calculation to enhance speed and accuracy - Proficiency in data partitioning and indexing - Equally prioritizing both query optimization and database design - Excellent communication skills for steady project updates Ideal candidates must have a knack for balancing database design and query optimization. Let's push the boundaries of what SQL databases can ...
write a query in the attached database that copies the last record created in the customer table and copies it to the merge table overwriting any record that exists in the merge table. There should only ever be one record in the merge table. Return the testdb access database to me with the query that performs the above action. Piece of cake for access DB guru
I'm seeking an experienced WordPress developer to handle the migration of my current website to a new server. I also require a redesign of the website's layout and SEO optimization. Key Responsibilities: - Moving WordPress site from current server to a new one. - Implementing a fresh, modern layout. Desired Skills and Experience: - Proficient in WordPress and server migration. - Experience with website layout design. - Expertise in SEO optimization.
I'm looking for an expert to quickly upgrade my existing Windows server to Windows 11. The main reason for this transition is to ensure compatibility with new software, even though the specific software necessitating the upgrade hasn't been specified. The ideal freelancer for this task should have the following qualifications: - Extensive experience with Windows server upgrades - Knowledge of compatibility issues and tactics to resolve them - Ability to work under tight timelines as this project needs to be concluded ASAP. Your proposal would be more favorably considered if you can detail similar past projects you've completed, and their outcomes.
I am seeking a skilled programming expert, proficient in either Ruby or Python, with intermediate-level ElasticSearch querying capabilities. The primary task involves intelligently executing aggregations and nested queries in ElasticSearch, extracting data, in JSON format, and then transposing it into Excel or CSV format. I'm open to whichever format you are more comfortable with, so long as it is either of the two mentioned. In addition to this, having familiarity with job automation via GitHub is critical for this project role. This background should include understanding how to automate and schedule tasks to regularly extract, convert, and save this data. Ideal Skills: - Proficiency in Ruby or Python - Intermediate level ElasticSearch querying - Experience with JSON to Excel/CSV...
I'm in need of a skilled developer to create an Android application with ASP.NET C# backend and SQL SERVER database. Key Features: - The app should primarily function as an e-commerce platform, allowing users to browse through products and services. - I require the app to have a chat functionality where users can communicate with the sellers. - Users should also be able to leave reviews for products. Specific Chat Features: - The chat functionality should support text messaging, image sharing, and voice messages. Skills and Experience: - Proficiency in Android app development - Strong experience with ASP.NET C# and SQL SERVER - Previous experience in developing e-commerce apps - Proven track record in integrating chat functionalities within an app - Fami...
I'm currently seeking an experienced Linux system administrator to connect my Ubuntu-based Digital Ocean server to a Pterodactyl panel. Your tasks for this project, ideally completed within a short timeframe, will include but are not limited to: - Seamless connection of the server to the Pterodactyl panel. - Full preservation of existing user profiles on Pterodactyl during the process. What you should ideally have: - Proven experience in Linux System Administration, particularly with Ubuntu. - A solid understanding and hands-on experience with Pterodactyl panels. - Capability to process tasks with full root access. It's crucial that you know exactly what is required to ensure a secure and functional connection. Also, you should be able to solve any unforeseen is...
I'm currently undecided about whether to upgrade my existing hardware from Windows Server 2012 to Windows 11 or to implement the upgrade on a new system. Uncertain factors include the advantages of Windows 11 and the requisite technical skills for a successful upgrade. Key Requirements: - Expertise in Windows Server 2012 and Windows 11 conversions - Ability to provide guidance on whether an existing system upgrade or a new system would be more advantageous - High degree of flexibility in project delivery as the completion date remains undetermined Desirable Skills and Experience: - Extensive experience in Windows system upgrades - Demonstrated knowledge of Windows Server 2012 and Windows 11 features - Excellent problem-solving skills and adaptability - Strong...
I am in need of expert assistance to help set up my Apache Tomcat 7.061 server on a Windows 2019 machine, compile a War file and get it up and running. The War file serves as a dashboard to an app previously functional before migration to a new server. Encountered issues include server configuration and deployment errors. The ultimate goal is to have the file accessible here: Ideal candidate should have: • Proficiency in Windows server management • Extensive experience with Apache Tomcat server setup • Proficiency in War file compilation • Ability to debug and fix server configuration and deployment errors Knowledge of the app/dashboard's functionality or code changes made post-migration may not be necessary, as specif...
I need an experienced IT expert to install SQL Server 2019 and the Landmark Compass software on a Windows Server 2019 based system. Key Responsibilities: - Install SQL Server 2019 on Windows Server 2019 - Setup Landmark Compass on the same server Key Skills: - Familiarity with Windows Server 2019 operations and configurations - Extensive experience in SQL Server 2019 installation and setup - Working knowledge of Landmark Compass software The ideal freelancer should have a proven track record of managing and adjusting settings in Windows Server 2019 and a firm understanding of SQL Server 2019 installation. Your role is primarily installation and setup, so no coding or SQL development is ...
I'm currently seeking an experienced Linux system administrator to connect my Ubuntu-based Digital Ocean server to a Pterodactyl panel. Your tasks for this project, ideally completed within a short timeframe, will include but are not limited to: - Seamless connection of the server to the Pterodactyl panel. - Full preservation of existing user profiles on Pterodactyl during the process. What you should ideally have: - Proven experience in Linux System Administration, particularly with Ubuntu. - A solid understanding and hands-on experience with Pterodactyl panels. - Capability to process tasks with full root access. It's crucial that you know exactly what is required to ensure a secure and functional connection. Also, you should be able to solve any unforeseen is...
I'm currently seeking an experienced Linux system administrator to connect my Ubuntu-based Digital Ocean server to a Pterodactyl panel. Your tasks for this project, ideally completed within a short timeframe, will include but are not limited to: - Seamless connection of the server to the Pterodactyl panel. - Full preservation of existing user profiles on Pterodactyl during the process. What you should ideally have: - Proven experience in Linux System Administration, particularly with Ubuntu. - A solid understanding and hands-on experience with Pterodactyl panels. - Capability to process tasks with full root access. It's crucial that you know exactly what is required to ensure a secure and functional connection. Also, you should be able to solve any unforeseen is...
...improvements to my existing Laravel application. The selected freelancer will be responsible for: - Backend Development: Your skills should allow you to work efficiently on my application's backend, ensuring all new integrations are seamless. - Database Optimization: I am specifically looking for you to boost the performance of my existing application by optimizing the database, which includes indexing, query optimization, and normalization wherever necessary. - API Integration: Your experience integrating APIs will be crucial, as a key part of this project will involve utilizing various APIs to extend the functionality of the application. - User Interface Improvement: The right candidate will not solely focus on the technical side, they must also be able to make necessa...
I require a proficient Pl/SQL programmer to assist me in writing stored procedures for my database. Your primary goal is to focus on the programming aspect of Pl/SQL, specifically in creating stored procedures. This is key to the project and will require a deep understanding of both database management principles and the syntax of Pl/SQL. Key skills and experience needed: - Proficiency in Pl/SQL programming - Proven experience in writing stored procedures - Strong understanding of database management and architecture - Excellent problem-solving skills - Attention to detail and accuracy in coding Your work will contribute significantly to the efficiency and effectiveness of my database system. Please be sure to have a portfolio or examples of your previous Pl/...
I'm seeking a savvy IT professional to establish a large-scale business email server with over 500 accounts. Furthermore, successful integration with Mailchimp for cohesive email marketing purposes is paramount. Essential aspects of this project include: - Setting up 500+ accounts flawlessly - Ensuring the potential for analytics and reporting Ideal candidates should have: - Extensive experience with email server setups - Profound understanding of Mailchimp integration - Previous experience in working with Google Mail Server - Capacity to provide detailed analytics/reporting tools I am looking forward to working closely with you to achieve streamlined email systems. Your expertise will drive email marketing success within my organization.
I'm in need of a skilled professional who can help manage my Woocommerce, Wordpress, and Linux server. Ideal Skills: - Proficiency in Woocommerce and Wordpress - Experience in Linux server management - Knowledge of SEO and site optimization - Ability to work on a weekly basis, maintaining and updating the website Key Tasks: - Weekly website updates and maintenance - Plugin and theme installations - Server optimization and security updates - Critical optimization for website speed and performance Your work will be essential in keeping my website running smoothly, secure, and optimized for speed and search engine visibility.
...a Linux operating system. The aim of this project is to ensure a sophisticated and smoothly running CRM solution at the earliest. Specifically, here's what I'm looking for: - Speed: The project should be completed ASAP. Please only bid if you're able to deliver within a short time frame. - Expertise: You should have past experience installing SuiteCRM, particularly on Linux. We will: Set up SQL database Provide database username and password. Provide cPanel access The project is to install SuiteCRM v. 7.10.4 No modifications or importing of data is needed Set up one Admin account – we will provide a username and password When your installation is complete we will (within one business day) test your installation by creating a Lead, and converting the Lead...
...Laravel based SaaS systems. The purpose of this staging server would be to test changes to the system before deploying them live. It's crucial that it accurately simulates the live environment to ensure a smooth transition and minimize potential issues. I've been running into licensing error with the SaaS when attempting to setup the testing environment so I would like try to do the following: a. I need a backup taken of the Production server. b. Then I need to have it restored to a subdirectory on the new server c. I need all the passwords, FTP logins, admin logins or any other sensitive information changed, and any URL’s updated. I'm also open to other suggestions on how I can have a restore my prod environment on a separate cloud se...
I'm...Azure expert to help me enhance the remote desktop services (RDS) on my Windows Server 2019 Datacentre. Key tasks involve: - Increasing the concurrent RDS remote sessions from 2 to 5. - Users are already configured and operational- it is just concurrent sessions that are the issue beyond 2. - Ensuring the transition is seamless for users and does not disrupt existing services. Ideal skills and experience for this project include: - Proficiency in Azure and Windows Server 2019, with a proven track record of successful RDS configuration. - Strong understanding of user access control and permissions, particularly in a business context. - Familiarity with accounting applications and their configuration on a server. - Excellent communication skills and the abi...
Looking for skilled programer to create for me a server based bot which use my twitter account and monitors people i follow to instantly create a reply when they create a new tweet. Should have limitations on -replies per hour -replies per day -reply max x time per week on single specific account
Create a database and CREATE TABLE statements for all tables in your ERD (Part A) including primary and foreign keys. 2. INSERT INTO statements for populating the database i. Insert five rows of (made-up) data into each table. Make sure that the data you enter in these tables should be sufficient to return at least one row for each query in Task 3. AL should hold at least 5 bottles of Penfold Grange 2010 in some branch or other
I'm looking for a proficient Codeigniter developer who can urgently dive into my project and rectify unspecified bugs/errors. The details of the issues...properly working The exact pages or functionalities affected are not clearly pinpointed yet. It's a task that requires you to have an in-depth understanding of Codeigniter, and the ability to quickly identify and resolve problems within the project. Key Skills and Experience: - Strong experience with PHP and Codeigniter framework - Advanced troubleshooting and debugging skills - Proficient in SQL and server/database connections - Ability to detect and fix broken code rapidly Kindly note, this work is time-sensitive and needs to be completed ASAP. Please bid if you are immediately available and can dedicate e...
...need expert assistance with my live server running on Linux. I have specific tasks related to Plesk web admin configuration that I need to get done. - Email Server Configuration: I require help with server email send and receive settings. You should know how to work with Plesk to ensure seamless email transmission. - Security Settings: Solid experience in configuring security settings in Plesk is important. You should be aware of best practices to secure a linux server running Plesk. - Backups: I also need help in setting up backups. Previous experience in backup configurations in Plesk on Linux Server is ideal. A proven track record in handling Plesk Administration, specifically on Linux servers, along with an in-depth understanding of email ...
...require: Features: - User Registration and Authentication: Proficiency in handling user data securely and maintaining user privacy is necessary. - Search Functionality: The website should include essential features such as Full-Text Search, Faceted Search, and Auto-complete/Suggestions powered through Elastic Search. The capacity to execute comprehensive indexation, accurate retrieval, and fast query processing is crucial. - Responsive Design: The site must be mobile-friendly and capable of rearranging its layout based on the user device screen size. Design Style: - Modern: The web design should align with the modern style. Minimalism, adaptive grids, and scalable graphics are what I'm looking for. The design should be functional yet aesthetically pleasing and user-friend...
I urgently need a server expert to bring my CentOS server back to life. The server stopped working after I messed up the iptables. I have rescue mode enabled , I need someone work over any disk and solve this and fire the server again now
Dear developers, I am looking for a skilled python engineer that is able to create a ML engine which is capable to extract specific datapoints from the pdf files and save them as per set of rules to sql table. system has to run offline, so no online solutions will be accepted as they cannot be used for this project. current problems: 1. large part of documents are scanned, but data is digital. essentially form was printed and scanned upon completion. 2. scanned files are tilted. 3. scanned files have noise which require removal of it. 4. few scanned documents require quality enhancement. 5. some scanned documents have different zoom. 6. all files have checkboxes. 7. specific datapoints can change location within the file, so engine must search for it and find it. there is maste...
I'm looking for someone who can help me set up a dedicated game server on my Windows PC specifically for V Rising. Here are more details of the project: - **Purpose**: The dedicated server will be used solely to run the game V Rising. - **Player Anticipation**: The server should be able to accommodate up to 10 players simultaneously. **Skills and Experience Needed**: - Experience in setting up game servers, especially for V Rising. - Proficiency in working with Windows operating system and related server configurations. I am seeking someone who is reliable and can commit to delivering a functional game server in a timely manner.
As a thriving business, we're seeking an experienced Laravel and SQL developer for our upcoming web development project. The developer's main task will be to bring to life our concept of designing and implementing a responsive, user-friendly web application. We're in need of: - Laravel Web Development: Building a robust, intuitive web application using Laravel PHP framework. Utilising Laravel's features to their maximum potential. - SQL Database Management: This includes maintaining and optimizing our SQL database for this upcoming project, ensuring the data structures are well-designed and functional. - Backend API Development: We have several third-party services which need to be integrated into our application through backend API Developmen...
I am looking for an experienced professional who can assist me in purchasing and setting up RDP on a dedicated server. Here are my specific requirements for this project: - Set up RDP on a dedicated server with Windows - Must include remote access software in the set up - Anticipating more than 20 simultaneous connections for the RDP, the system needs to be optimized for this high volume - Prioritize strong security measures for the setup Ideal candidate should have experience with Remote Desktop Services, Windows server management, and understanding of proper security protocols. A strong understanding of networking and high connection environments will also be highly desirable for this project.
More details: What specific website(s) do you want to scrape data from? Website 1, Website 2 What specific data do you want to scrape from the selected websites? Text content, Tables What information would you like to extract from the text content and tables? Product names, Prices, Descriptions, reviews, size and color, occasion, return and country of origin, category, fabric, weartype
Skills Required Python Aws services-S3, glue, athena, sagemaker, feature store Sql UI/ API/SWAGGER PAGE Good in ML 5 days in a week Remote support role You will have to help developer for completing the task Timings - 9 to 11 am IST (or evening IST) Payment - You will be paid for those hours while you will be working, You will be informed in advance if there is no work and for those hours you will not be paid. Budget = 400 INR /h
We are urgently looking for very good system admins with many years experience handling linux servers to solve a boot issue where installing Grub is corrupted. A very good Freelancer has been working on it already but even with his very high score and good skills he hasnt been abkle yet to get it done. So, please do not react if you are not very good in solving...where installing Grub is corrupted. A very good Freelancer has been working on it already but even with his very high score and good skills he hasnt been abkle yet to get it done. So, please do not react if you are not very good in solving these kind of things as you need to work with the freelancer who works on it now and he has done already the basic things. So we need someone who can help him. Server is linux/ubuntu and...
