Sql server 2008 query latitude longitude radiusงาน

I have a Microsoft SQL Server installed and in operation, however, I am currently experiencing issues with slow query execution that ideally require rectification. I am seeking an experienced professional with specialization in performance tuning for Microsoft SQL Server. Skills & Experience Required: - Proven expertise in Performance Tuning and Query Optimization - In-depth understanding of SQL Server's underlying architecture, metadata and statistics to optimize queries - Solid experience in system analysis, profiling and tracing to diagnose and resolve performance problems - Ability to translate findings into actionable strategies to improve performance - Strong communication skills to effectively relay steps taken and results ...

...maintainable code on open-source (Linux based) web platforms (Example: Wordpress) • Creation of custom plugins/widgets written to conform with the WordPress coding standards • Experienced in both front-end and back-end website development. • Build websites with a responsive and fluid front-end mobile design. Experience with at least 1 SQL and NoSQL database. Able to grasp the key essentials and marketing concepts after discussion with management. • Manage database and server integration. • Troubleshoot, debug and upgrade existing website. • Adhere to project timelines. • Create security and data protection settings that are compliance with PDPA policy. Job Responsibilities for Web Designer: • Take ownership of design projects. &bull...

I need an SQL and SSIS developer for my personal project. My primary goal is to optimize my SQL database, which is currently facing several performance issues. Key Problems: - Slow query execution - High resource consumption - Inefficient indexing The ideal candidate should have a strong background in SQL and SSIS for database optimization. A thorough knowledge of SQL query optimization, resource management, and indexing is essential. I am seeking an expert who can effectively address these specific issues and enhance the overall efficiency of my SQL Server development. Any suggestions for further improvements are also welcome.

I need an experienced C programmer to improve the functionality of my web server code. Key Tasks: • Implement Incremental Analysis feature. Skills required: • Deep knowledge of C. • Prior experience in web server code enhancement. • Understanding of Incremental Analysis feature and how it can be incorporated into a web server. • Ability to work without database integration, as this is not needed for this project. Please ensure your bid includes examples of similar C projects you've completed, as well as a brief description of how you'd approach adding Incremental Analysis capability to my web server.

...owner, I urgently need a skilled SQL Server and SSIS (SQL Server Integration Services) Developer to propel my database optimization objectives. Your primary tasks will focus on: - Fine-tuning SQL queries - Carrying out schema optimizations - Development using SQL I'm currently dealing with several performance issues, including slow query execution, high disk I/O, and index fragmentation. Therefore, for this task, the ideal candidate should possess a sharp understanding of query tuning and optimization, as well as practical experience with complex SQL Server and SSIS development projects. If you have proven experience in eliminating these types of issues and know how to implement effective optimizations, I am...

I'm in need of an expert developer who is highly skill...using the power platform. - Workflow Automation: We want to streamline our processes and increase efficiency with automation. - Power App Development: The developed app should have a user-friendly interface, provide real-time data updates, and intensive integration with existing systems. Specific Data Sources: For this project, we'll need to integrate Excel spreadsheets, SharePoint lists, and SQL databases. You should have prior experience working with these data sources. The ideal candidate is proficient in MS Power Platform, excellent in data analysis and has experiences in workflow automation and App development, with a knack of creating intuitive interfaces and integrating diverse data sources. Let's con...

I am seeking an ICT consultant with deep understanding of network and server setup. Additionally, a solid grasp on information security is crucial to ensure effective operation of the server. Key responsibilities: - consult on Hardware setup from vendor - consult on Network configuration - lead the Colo server setup to host my websites and apps - Carry out a comprehensive security assessment for the system The preferred server operating environment is Windows Server. A candidate with significant experience in Windows-based server environments would be ideal. I also value a meticulous, detail-oriented approach, as well as strong communication skills.

I am in need of an experienced SQL database expert to assist me with setting up a Failover Cluster on a Windows Server 2019 system. We have setup two servers, setup as a windows cluster then setup SQL High Availability failover cluster, however the second database will not sync

...proposition of through proposals and presentations to the prospects. Lead nurturing, engagement, and closing sales. Persuade clients to sign search contracts on an exclusive and/or retainer basis. Provide accurate and detailed forecasts on weekly/ monthly funnel of identified and proposed customers to meet and exceed sales requirements. Email coordination/timely update on whatsapp group by managing query flow of calls/emails/messages from candidate/internal team/clients. Stakeholder Management and Negotiation Requirements 2-4 years of business development experience in a recruitment agency/staffing firm. Proven track record in Client Acquisition and winning new business. Proven track record of increasing revenue through the generation of leads and placements. Lead and ...

Seeking a dynamic web developer to assist me with finalizing my website via enhancements in the JetEngine features. Need help with the following but not limited to: - Create queries in Query Builder that call from existing data. - Create tables in Table Builder based upon the Queries - Tie the tables into display on the front end pages that call for the inventory item.

...For example the headlines on the pages would be Plastic drinking bottles blue Manchester, plastic drinking bottles red manchester, etc. along with the blog posts at the bottom. On each page would be a form and one of the fields would be postcode. On the backend I would want to add in distributors. For these distributors I would put their postcode, and a radius, and anybody who filled the forms in with a postcode in that radius, the forms would automatically be emailed to them. I would want a master area, where I can see stats etc for each distributor. Please give me some examples of similar sites. Key Skills and Experience: - Proven experience in web development - Familiarity with creating platforms that auto-generate content - Ability to adapt to new speci...

I'm in need of a professional who can install and configure Microsoft Exchange Server 2019 on our server. I'm looking for: - Basic installation with minor customizations - Adjustments to user mailbox properties - Setting allocation of default storage quotas - Arrangement of email address policies Ideal candidates should have extensive experience with Microsoft Exchange Server 2019 and strong knowledge of server configuration. Proven expertise in customizing the aforementioned properties and settings is essential. Please provide examples of previous similar projects you've successfully completed.

...admin panel. The backend will be developed using FastAPI, a high-performance web framework for building APIs with Python, and MongoDB for data storage. Requirements: Expertise in FastAPI and MongoDB is essential. In-depth understanding of RESTful APIs, CRUD operations, and web security best practices. Ability to implement robust security measures to protect against common vulnerabilities such as SQL injection, cross-site scripting (XSS), and cross-site request forgery (CSRF). Experience with user authentication and authorization mechanisms, including token-based authentication and role-based access control (RBAC). Strong communication skills and the ability to collaborate effectively with our team. Deliverables: Develop a FastAPI backend with CRUD endpoints for managing admin ...

I'm currently using a Windows operating system and urgently require assistance with a task related to Putty and MySQL Server. Key Responsibilities: - Troubleshoot and maintain my setup as and when required. - Handle remote server management effectively. - Participate in database development and updating. Ideal Candidate: - Should be proficient in the use of Putty and MySQL Server. - Possesses good experience with Windows operating system. - Must be able to deliver results promptly. Please bid if you can fulfill these requirements urgently.

Wordpres Wordpress, elementor and other plugins as specified.

... font-weight: bold; /* Bold text */ } .button-container { text-align: center; /* Center-align button */ margin-top: 20px; /* Add margin between button and additional text */ } .button-container a { background-color: #E64034; /* Button color */ color: white; padding: 10px 20px; border-radius: 5px; text-decoration: none; /* Remove underline */ display: inline-block; font-weight: bold; /* Bold text */ } .button-container a:hover { text-decoration: none; /* Remove underline on hover */ } .additional-text { margin-top: 20px; /* Add margin between button and additional text */ ...

I'm looking for a MySQL expert who can create a complex query to retrieve data from multiple tables (Table A, Table B, and Table C) of my database. These tables are interconnected, and the goal is to join data from all these tables, perform necessary calculations, then save the result into another table. Excel file with explanation is attached. Required Skills: - Experience in MySQL query writing - Ability to handle multi-table complex join operations

I require a highly skilled Node.js developer to help build an advanced web application with social network functionalities. Key responsibilities will include: • Backend Development: Implement server-side logic that governs how our website behaves. The candidate should have a deep understanding of Node.js and its frameworks. • Database Management: You will be tasked with designing, implementing, and managing a database system to store, manipulate, and retrieve data. Knowledge in SQL or NoSQL databases will be a strong asset. The ideal candidate would have experience in developing advanced web applications and a strong understanding of database systems. You will be a perfect fit if you thrive on complexity and have built rich, dynamic, and robust applications befor...

I'm looking to engage a professional to help with setting up a 389 Directory Server Winsync. This will be implemented on a Linux system, with synchronization happening one-way from Windows Server 2022 to the 389 Directory. Key Requirements: - Proficiency with Linux operating system - In-depth knowledge of 389 Directory Server - Familiarity with Windows Server 2022 - Experience setting up one-way data synchronization If you have the necessary skills and experience, please consider bidding on this project.

...needs to support), leveraging GraphQL's introspection capabilities. We do not expect you to start from scratch - please see: Responsibilities: 1) Provide a bespoke GraphQL adapter for Apache Superset, ensuring it can dynamically introspect the provided GraphQL schema and translate SQL queries into GraphQL queries. 2) Implement logic to handle both Relay-style connections and standard GraphQL schemas, including advanced query translation for filtering, sorting, and pagination. 3) Map GraphQL responses to a format that can be consumed by Apache Superset, ensuring data integrity and compatibility. 4) Write comprehensive unit and integration tests to validate the functionality of the adapter across various scenarios. 5) Prepare detailed documentation

Project Deadline: Within 1 Day Project Budget: $50 Project Type: Web Scrape Number of Records/Pages: 18,512 Number of Data Points to Scrape Per Page: 6 Output Format: CSV & SQL 5* FEEDBACK WILL BE LEFT FOR YOU

I got a web stresser source code i need it to be edited to match the look of another stresser website which will be given in messages, it also has some small backend problems which will need to be fixed . Need a freelancer with good knowledge in HTML,CSS,JS,SQL And PHP

I am in need of a SQL Server expert to grant specific permissions for database access on my system. The primary role would involve enabling access controls and assigning user permissions for various actions, including: - Select - Insert - Update - Delete Ideally, the successful bidder will have considerable experience handling SQL Server and any relevant certifications would be a bonus - the complexity of the system requires high expertise. Your attention to detail is paramount, as well as being able to provide proof of your work. This project offers potential for future work, should the results prove satisfactory. Please account for communication time in your bid, as clear, understandable reporting is part of the task.

Hi Bestsolz, I noticed your profile and would like to offer you my project. We can discuss any details over chat.

Η HellasFin είναι μια από τις μεγαλύτερες και πιο δυναμικές εταιρείες επενδυτικών υπηρεσιών στην Ελλάδα. Αυτήν τη στιγμή αναζητούμε έναν Back End Developer που μπορεί να βοηθήσει σ&epsil...

I'm looking for a talented Python developer with a solid understanding of Django and MySQL. The purpose of this project is to develop a robust database management system. These are some key features that the application should have: - Integration with Django's ORM (Object-Relational Mapping) library. - Custom SQL query functionality for advanced data operations. - A system for data backup and recovery to prevent data loss. You should have a proven track record with both Django and MySQL, and be able to show examples of similar projects you have worked on. A strong understanding of database design and management is a must.

I'm seeking a proficient FlutterFlow deve...these kind of applications will be greatly beneficial to this project. Specifically I am looking to debug my VoiceFlow Bot integration. I have copied over to a new FlutterFlow project just a test chat page to debug, then impliment into my main app. Here is the link to the page - click on the purple button in the app to launch the chat. You will see a "NULL" value returned when entering in a text query. My API Call in the backend of FlutterFlow works fine in the API Section but is not in the front end chat. I believe my issues are as follows: 1. API JSON paths, incorrect payload 2. Custom Code - JSON Return paths 3. Incorrect Launch Request upon chat page load Respond with your favorite food

I need an expert in Windows Server 2022 to set up a new service account for our organization. This service account should be able to: • Control access and permissions • Manage the COM system configuration Actually, when php tries to start word from COM Application, it only starts if some user account is started. Your skills should include Windows Server 2022 management and experience with creating service accounts with similar requirements. Also, we need you to configure the Microsoft Office Word to start with this particular service account. A strong understanding of access control, permissions management, and COM system configuration is essential for this job. A proven record of managing similar server environments will be a plus.

I have magento as the base API when we run the stored procedures the SP works fine When we then run the SP in loops to cover all areas via PHP that calls the SP then the issue throws SQL error: "SQLSTATE[HY000]: General error (0)" I am not sure why. I suspect it it is locking processes but I am not sure. This is affecting several APIs so it must be resolved immediately But it seems to be possible to resolve it locally in he phpo code also I have seen on tickets. The work requires: - In-depth understanding of MySQL stored procedures - Extensive knowledge of Magento interface - Experience in API error troubleshooting - Expertise in handling 'data missing in response' type errors The ideal freelancer is one who is meticulous in bug detection and correction, ...

I am seeking a freelancer with experience in hosting .NET Core web applications on AWS. Although I have not decided on the specific AWS service to utilize, candidates with know-how in Elastic Beanstalk, EC2, or Lambda will be greatly appreciated. Key Requirements: - Experience in hosting .NET Core web applications on AWS. - Familiarity with Entity Framework Core and ASP.NET Core. - Proven track record in developing and deploying .NET Core applications. Past work examples will be highly valued during the selection process. As the perfect candidate, you must demonstrate your expertise in these areas and be able to contribute strategically to the decision-making process regarding the ideal AWS service for my project.

As a holder of a Drupal website with an Access/MS SQL database, I need to directly update Drupal tables using data from our database. We can transfer data from our Access database to the MySQL database, but need to update Drupal content from this data seamlessly. We would like to be able to create content directly from our database that can then be viewed as Drupal content. The timelines are strict and the project should ideally be completed within a month. Needed Skills: - Strong PHP programming with profound Drupal knowledge. - An understanding of SQL server and Microsoft Access although we have our own MS Access developer, so this will be to support them. - Previous experience with a similar project will be a plus. Please note, the scope of what information w...

Hi Santosh Kumar P., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

I'm looking for a seasoned programmer, skilled in working with MIFOS (Fineract) software. The project primarily revolves around two key tasks:...looking for a seasoned programmer, skilled in working with MIFOS (Fineract) software. The project primarily revolves around two key tasks: 1. **Platform Customization and Enhancement** - Your role will involve optimizing our MIFOS platform to meet our unique needs and implementing minor enhancements for better functionality. 2. **Report Generation** - You will be needed to generate two types of SQL reports - sales and financial reports. Immediate availability is preferable as I'm keen on having the project completed ASAP. If you have a background in fintech and have previously worked on these tasks, you're likely the perf...

Hello, I have a simple php page and a complex database. My database size is very high and when I query a data I don't get a response for a very long time. I created a basic API and I have complex data in my database. I need a system that will delete repeated data in the database, destroy all unnecessary data and work with a proper, reliable api.

...patching, database performance tuning, sizing and capacity planning, database backup and recovery in a Unix O/S using RMAN and Oracle export/import utilities, administration, and maintenance to provide backup and disaster recovery. • Knowledge of installation, configuration, and maintenance of multi-node Oracle RAC enabled databases, including Oracle ASM and Oracle CRS management. Knowledge of PL/SQL packages, shell, and Perl scripts for task automation, and proactive database monitoring and notification using Oracle OEM Grid Control. • Demonstrated written and oral communication skills reviewing and editing established database policies and procedures and developing new SOPs for database software installation and configuration. • Experience with Cloud(AWS/Azure/OC...

As an experienced .NET Developer, I am looking for assistance with code optimization and feature development in both .NET 8 and Visual Studio 2019. My specific areas of concern are: - Improving execution speed - Enhancing scalability - Adding new functions to the software The development scope includes: - Microsoft SQL Database integration The ideal partner for this project would be proficient in .NET 8, Visual Studio 2019, Fluent in database integration and experienced in optimizing software for improved speed and scalability. Your track record in enhancing software functionality will also be invaluable.

I'm urgently seeking a skilled individual to assist with setting up and configuring a Windows Server. Unfortunately, I was unable to provide the specific Windows Server version, but I'm looking forward to discussing this with the potential freelancer during the selection stage. Key Tasks: - Lead the setup and configuration of a Windows Server. The ideal candidate for this job: - Has extensive experience and knowledge with Windows Server setup and configurations. - Can accurately recommend a suitable Windows Server version based on my unique business needs. - Has exceptional problem-solving skills, with the ability to troubleshoot during setup or configuration stages. Please note, I am looking to have this project completed ASAP. Serious in...

Project Deadline: Within 1 Day Budget: $75 Server Type: Linux Ubuntu Project Type: Optimization & Performance Enhancement Project Overview: We have started to see our website pages load extremely slowly, especially when multiple pages (5-10) are opened at once. We need the server to have extremely high performance & deliver pages very quickly 5* FEEDBACK WILL BE LEFT FOR YOU

I'm in need of a proficient expert in Excel, SQL, and Python for data analysis, data visualization, and automation. The data complexity is moderate, so a good understanding of data manipulation and cleansing techniques is required. IT IS A TIMED TASK - please only reach out if it’s okay Main Responsibilities Include: - Analyzing the given data - Visualizing analyzed data - Automating tasks that involve data manipulation

1. We have 32 backups from the same database as .sql-files. From one table of this database we need all instances in one csv-file (with the same codepage as stated in the sql-file ). So basicly you must: - import 1st backup on your sql-server - export the table "contracts" to "csv for Excel" - repeat for all 31 other backups - put everything together in one big csv-file that is readable in Excel (pls maintain german umlaute) 2. There should be a menu-item (i.e. "Report"); clicking this asks for the date "Welches Datum?"; the current date is proposed but can be changed by choosing a date in a calendar. The report should consist of: 1. All customers that have been added at the given date. 2. All contracts that have ...

For our enterprise SaaS system, we need an experienced analyst/CRM specialist proficient in Salesforce, HubSpot, or similar platforms. Our focus is on customer data integration and setting up optimal data structures and workflows. A successful candidate must demonstrate: - Expe...workflows. - Ability to train and support a medium-scale user base. There will be multiple projects on an ongoing basis and may require you to attend online meetings once every few days, so please let us know if you have availability during the day. Must be U.S. resident and at least permanent resident. Some project will require background checks. We have a separate project for an individual with SQL, data analysis and Dashboard experience as well. If you have those skills you can work on both projects.

I require a talented and experienced database architect to efficiently design and establish an SQL database for my project. Key Functions: - The database should proficiently support data storage and retrieval. Key Details: - Unfortunately, I can't provide specifics about the type of data to be stored. Understanding of a broad range of data types and versality is crucial. Ideal Skills: - Advanced knowledge of SQL - Expertise in database architecture - Excellent problem-solving skills - Ability to work without specific data requirements Time Frame: - This project is urgent. I need it completed as soon as possible, so efficiency and dedication are essential. I look forward to working with a meticulous and dedicated professional who can meet these requirements ...

I need to deploy a rust application on a linux server If you can start now plas tart your bid with NOW

My server reportedly is being used to initiate attacks on other servers using bruteforcelogin, please see attached file for more details. The strange thing is that everything seems normal; there's no unusual server behavior or unresponsive services. Existing on my server are several security measures, including a firewall and antivirus software. ImmunifyAV shows NO malware. Here's what you need to do for this project: * Inspect the server for possible vulnerabilities or breaches * Identify the source of the problem * Implement necessary corrections or improvements on the current security configuration * Get my IP unblocked Preferably, the selected freelancer should have: * Extensive experience in server security management * Proficiency in ...

...if it falls within the bounds of the core message. We are a post Construction Cleaning Company, as we do final clean, exterior debris clean and rough clean. We are seeking more cleaning agreements with commercial and residential construction companies, builders, and real estate agents/brokers. We are located in Houston, Texas and are only seeking new clients for our metropolitan area (50-mile radius). Our Desired Salesperson Can Do The Following: 1. To contact potential client (Project Managers) and determine their projects that are nearing completing and needing: a final clean, or exterior debris removal, or both. 2. To contact potential clients (Project Managers) and request invitations to bid on upcoming projects. 3. Generate leads from LinkedIn, Instagram, Google, Google Ma...

Hi Developers I need a node js programmer who aware of this package to install on our company’s website server Please note that the server runs on the AlmaLinux system and the web server used on the site is Apache I need you to let me know how can I call the library using the API you will create in nodeJs, or what the right way should we follow to communicate with the package, in our custom plugin code on our wordpress website so I can get the results through it and be able to send the content and keyphrase through it and get results later. Thank you.

I own an IT consulting firm which is recently extending its offerings to trainings in tech. The tech trainings offered are mainly focused on data analytics/science, BI and cloud computing. The courses are mainly given to people who have no prior tech or coding experienc...mainly given to people who have no prior tech or coding experience but those who want to break into tech career. I am looking to hire a skilled BI developer with extensive experience with Tableau, Power BI and other BI tools. The freelancer will be helping me design the curriculum and also teach BI and data visualization Must have skills: 1) Power BI-DAX, M Language, Data Modeling, Power Query 2) SQL 3) Good teaching skills. 4) Great command of English PLEASE SUBMIT YOUR PROPOSAL WITH YOUR RANGE OF EXPE...

I'm in need of a proficient Azure SQL developer skilled in query optimization and stored procedure. The purpose of this project is to automate certain tasks within our existing system. This will involve: - Optimizing my existing SQL scripts to ensure smoother operations - Developing new SQL scripts as required, to further enhance automation I expect candidates for this project to have robust experience in Azure SQL, particularly in developing efficient procedures and scripts. Proven problem-solving abilities and a keen eye for the fine-tuning of processes will significantly benefit this assignment. Familiarity with task automation will also be highly regarded.

I am looking for a proficient developer who can successfully integrate our Phone system API with our SQL server. The purpose of this task is mainly: - To fetch specific data fields from the call logs which include: 1. Caller ID 2. Call duration 3. Time of call 4. Call outcome 5. Call type 6. Caller's location 7. Internal/External Flag 8. Recipient Name/Internal Extension - Store this information in the SQL server. About the Database: - The storage should be in raw format. - Importantly, the call logs should be segmented by the call type. - A strong emphasis must be put on timestamps while storing data. Necessary Skills: - Proficiency in working with APIs, SQL servers - Knowledge and experience in data extraction and storage - Strong understanding...

...strong experience in .Net and Angular, one who is comfortable with server deployment, and can handle a variety of tasks including code maintenance, server-related tasks, and developing features. I'm seeking someone who can promptly and efficiently move through our Trello board. You will be paid per task completed, ensuring fair compensation for your hard work. To ensure smooth collaboration: - All code will be shared on our Github account - Deadlines are task-specific; we need someone who can start ASAP. Key Skills needed: - Proficiency in .Net and Angular - Experience with server deployment - Familiarity with Trello and Github. Responsibility highlights: - Coding and developing features - Maintenance tasks - Server-related tasks By handlin...