Sql server 2005 primavera jobs

I need a power BI expert with deep knowledge of DAX query to help me retrieve specific metrics about product inventory. Key Requirements: -Retrieve product ID, Quantity and Location -Gather specific production data includin...production number. Ideal skills: -Proficient in DAX query language -Comprehensive experience with Power Bi -Excellent attention to detail -Previous experience in inventory data management will be a plus. What to do: I need to get a query in DAX (Power Bi) that gives me the same result as what I show in the excel file ( table ( column in yellow)). The excel file was obtained from the attached SQL query () The two screenshots show the power bi tables. I need to get a new column in power bi that shows me the results like in the yellow column in Excel.

I am looking for a skilled developer to create a Windows-based application that can interact with a remote database. The application should primarily focus on retrieving and generating website sitemaps based on different criteria. The ideal candidate should have: - Proficiency in Windows application development - Strong experience in working with databases, particularly...working with databases, particularly remote databases - Knowledge in data retrieval and data update functionalities - Ability to understand and incorporate additional requirements as the project progresses Please note that the selected freelancer may need to provide examples of past work and project proposals. Note: Application should be able to connect different type of databases such as MS SQL Server, M...

I have the SQL file and main images of my current Wordpress site, and am looking for a professional to migrate and set it up on the new hosting account. We have the hosting account set up and will share the files with a dropbox link. Key Requirements: - Migrate current Wordpress site to a new hosting account - Setup and configure Wordpress in the new hosting environment - Ensure all site functionalities are working post migration - Provide login credentials for the access to Wordpress Please note: - There are no custom changes or updates needed during the migration - The new hosting environment is fully compatible with Wordpress Ideal Skills: - Proficient in Wordpress migration and setup - Knowledgeable in SQL databases and file handling - Experience in configuring hostin...

As the developer of an existing project written in Python, SQL Server, and MongoDB, I am currently facing a challenge. A logical error in the code is causing a bug, and I need an expert to fix it. High-level summary of the code- 1. Fetch records from SQL server ( total 680000 records) 2. Apply face recognition on each record 3. Insert the response from step 2 in MongoDB along with other data from the SQL server Issue- The existing code is currently doing steps 1 & 2 and performing step 3 at last when face recognition is applied on all records. Due to this it step 3 is waiting to complete the step 1 & 2. Expectation- After fetching each record from SQL server, the code should apply face recognition and then store the data in...

As a business user, I need assistance with the configuration of SSRS Reporting Service on a staging environment. I have configured the WebPortal using Report Server Configuration manager and I am able to run SSRS reports from the Web UI. The project requires the following: 1. Automatically Scheduling of SSRS reports with default parameters. 2. Exporting the outcome of SSRS reports in a given folder every time a scheduled report runs I am experiencing the following issue while scheduling: Error: The SQL Agent service is not running. This operation requires the SQL Agent Service. You will need to help get rid of this error and set up scheduling and exporting of reports as mentioned. You will be required to get on a video call and help me set up the above over the ...

... we're seeking a talented freelancer who can design an effective Power BI Dashboard to integrate various data sources including Excel spreadsheets, CSV files, and SQL databases. The ideal freelancer would: - Have extensive experience with Power BI and DAX language integration. - Demonstrate an excellent grasp of designing dashboards that report on KPIs. - Be well-versed with creating DAX calculations in the Power BI environment. We require the dashboard to focus on specific metrics, therefore, a strong understanding of reporting on KPIs using DAX language is a must. Additional Skills: - Proficient in Microsoft Excel and SQL databases. - Understanding of data integration and reporting. - High attention to detail. We're excited to collaborate with a dedicate...

I need a Power BI expert with deep knowledge of DAX query to help me retrieve specific metrics about product inventory. Key Requirements: - Retrieve Product ID, Quantity and Location. - Gather Specific Production Data including t...number. Ideal Skills: - Proficient in DAX query language - Comprehensive experience with Power BI - Excellent attention to detail - Previous experience in inventory data management will be a plus What to do: I need to get a query in DAX (Power BI) that gives me the same result as what I show in the excel file ( table (column in yellow)). The Excel file was obtained from the attached SQL query ( ) The two screenshots show the Power BI tables. I need to get a new column in Power BI that shows me the results like in the yellow column in Excel.

...for the Snipepay Payment Plugin: WooCommerce Integration: Develop a payment plugin to integrate Snipepay into WooCommerce, allowing users to choose Snipepay along with existing options like PayPal and GoUrl for payments. Deliverables: A fully functional WordPress plugin for hosting management. A Snipepay payment gateway plugin for WooCommerce. Skills Required: Proficient in PHP, JavaScript, and SQL. Experience with WordPress and WooCommerce plugin development. Strong understanding of RESTful API integration. Knowledge in payment gateway integration, specifically Snipepay, PayPal, and GoUrl. Excellent problem-solving skills and attention to detail. Project Timeline: Please provide an estimated timeline for completion with your bid. Budget: Your bid should include the total cos...

Hi Yasar W., I noticed you posted a following project ( https://www.freelancer.com/projects/sql/SQL-Expert-Needed-for-Data/details )

I need a script to automate server updates. It should be able to handle operating system updates, software updates, and security patches. Key Requirements: - The script should be able to automate server updates - It needs to handle operating system updates, software updates, and security patches Ideal Skills: - Proficiency in scripting languages - Experience with server management and updates - Understanding of cybersecurity and best practices - Strong problem-solving skills and attention to detail.

I'm seeking a highly skilled system administrator capable of installing CloudLinux with LVE and cPanel support on my server. - Purpose: The key goal behind this project is to optimize resource allocation for my server. I intend to host multiple websites on this server, making resource optimization crucial to seamless performance. - Websites: The server will host a diverse range of websites including e-commerce, blogging, and corporate websites. - Volume: The server should comfortably accommodate between 10 to 50 websites simultaneously. The ideal candidate for this project should have strong CloudLinux and cPanel working knowledge. An in-depth understanding of server management, specifically for resource management in high-traffic env...

...from backup Activate 2. change the name of to 3. add the alias domain 4. Add the prt for and cname record for @ cloudfare , now i do manually 5. create the ssl for and have to do some sql sql command to change the Admin name , Instance name -- now i do manually 7. env file need to be updated 50% mile stone will be created at the time of awarding the project, All payment will be released as soon as satisfied with your work and fit to my requirements. If you are interested, please send me a message so that we can discuss... Thanks...

I am seeking a knowledgeable AWS specialist to provide server support including the maintenance of an Application Load Balancer. The project also uses Git CD/CI, and support on GIt is required as well. Ideal freelancer skills and experience: - Deep knowledge of AWS services, particularly EC2 and RDS - Experience in setting up and managing Application Load Balancer - Familiarity with Git & CD/CI To make a successful application, please include: - Details of past work experience particularly related to AWS EC2, RDS and load balancer configurations. Looking forward to your applications.

I'm looking for a developer who's proficient in C#, MS SQL Server, Dot Net, and XAMARIN to work on an already existing application. Need to improvise and add amend few things. Pls note we can pay maximum INR 4,000 for the work.

I am seeking an experienced Dynamics CRM 365 developer with Virtual Entity expirence. I have got few virtual entity tables link to Azure SQL database. One table has got 1:M relationship with another. In my form, I am trying to populate custom view in lookup field of this virtual entity lookup. I tried it in two different ways but it doesn't work. Method 1: I created fetchXML and link two tables, I get the result but issue is records don't filter in query. I tried this method with advance find as well, and again records don't filter according to criteria for virtual entity. in Advance find, if I try to select the columns from second table then I get error. Methos 2: I tried to create Fetch XML query and use addCustomView method. This method works if filter criter...

...from backup Activate 2. change the name of to 3. add the alias domain 4. Add the prt for and cname record for @ cloudfare , now i do manually 5. create the ssl for and have to do some sql sql command to change the Admin name , Instance name -- now i do manually 7. env file need to be updated 50% mile stone will be created at the time of awarding the project, All payment will be released as soon as satisfied with your work and fit to my requirements. If you are interested, please send me a message so that we can discuss... Thanks...

Are you a Vesta Panel expert? Ok Then help me upload a simple 1-page WordPress site to my server & connect to the domain name Hosting is Digital Ocean with Vesta Panel

We need Oracle resource who are expert in below skills and having 8+ years of exp. Mandatory Skills: *• Need candidates with extensive experience in data migration across CRP, SIT, UAT, and GoLive phases in Oracle Fusion ERP implementation, utilizing ETL tools. * Experience in SQL Server, T-SQL, and SSIS Job Responsibilities: Data Extraction: * Extract data from various source systems, including flat files, spreadsheets, legacy databases, and external APIs. * Develop and optimize SQL queries and scripts for efficient data retrieval. Data Transformation: * Perform data cleansing, validation, and transformation to ensure data quality. * Convert data from source formats to Oracle-compatible formats. * Apply business rules and data mapping for aligning sourc...

I'm looking for an experienced cloud engineer who can resolve a server downtime issue I'm experiencing with my OVH Public Cloud. Key Responsibilities: - Analyze and troubleshoot the root cause downtime - Implement a robust solution to prevent future occurrences - Ensure that during downtime, website and database access functionality is restored promptly Ideal Skills and Experience: - Proven expertise in OVH Public Cloud management - Strong troubleshooting and problem-solving skills - Understanding of website and database access best practices - Excellent communication and teamwork abilities I'm open to suggestions on how we can best approach and solve this issue, so if you have ideas, I'd love to hear them.

...need of a professional with expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Products, and Orders. - Write queries: I need you to write SQL queries that will allow me to seamlessly interact with the database. Specifically, I'm looking for someone who can: - Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficiency. Ideal skills and experience for this job include: - Proficiency in ...

...need of a professional with expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Products, and Orders. - Write queries: I need you to write SQL queries that will allow me to seamlessly interact with the database. Specifically, I'm looking for someone who can: - Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficiency. Ideal skills and experience for this job include: - Proficiency in ...

...current developers have answered the below questions (their responses are in Yellow) 1. What are the current versions of software being used? OpenCart, PHP, MySQL etc in the various systems used?  Opencart V1.52 PHP Version 5.6.40 (any other newer version won’t be supported by the platform) MySQL - 10.4.28-MariaDB Laravel V5 … custom interface Active cron jobs running   2. What is the server spec & software versions? RAM, CPU, disk space etc. Full Software list here:  https://xxxxxxxxx/ We run a dedicated machine and resources can be allocated on demand… as minimal requirements: 4Gb RAM, OctaCore 3.2Gb CPU, 100Gb space (bkp included)   3. Any APIs integrated & Any Data grabs between and other 3rd parties including any internal ...

For this crucial project, I’m searching for a seasoned AWS developer experienced in setting up advanced server security. Key Responsibilities: - As I've got an EC2 server in place, I am seeking to fortify the security measures associated with it. - Although I've not finalized the specific measures, your expertise and suggestions in IAM, Security Groups, or Network Access Control Lists (NACLs) would be greatly appreciated. - Emphasis on ‘Advanced Security Setup’ – a step beyond basic security – to comprehensively protect server's integrity. Ideal Skills: - Proven experience in AWS server security, specifically EC2. - Proficiency with IAM, Security Groups, NACLs. - In-depth AWS server security acumen. I'm exci...

Need help with a simple task that involves writing simple SQL statements and completion of the relevant ER diagrams. This task is in the context of simple data analysis. To be completed within 2-3 days.

I have a running Python file, who parse data from xml and insert it into sql server. Currently it isnt working. need an expert in python, who can fix it and upgrade few things as well.

I'm in urgent need of skilled professionals with experience in MySQL and Digital Ocean recovery console. My MySQL server is locked and I require assistance in exporting a SQL file. The exact cause of the server lock is not currently known but it might be due to server resource overload or a potential security breach. Required Skills: - MySQL - Knowledge of Digital Ocean's recovery console - Server management The main objective of the task is: - Successfully export the locked SQL file for further analysis and resolution - Provide insights on the potential cause of the server lock for future prevention. Experience in server management, specifically in handling locked servers, will be a great plus. Thanks.

I am seeking a skilled database developer to convert my .frm and .idb files into a SQL file. The original files are in MySQL format. Key tasks will include: - Conversion of .frm and .idb files to SQL format. - Exporting these converted files to mysql server. I did not specify any special properties or features of the .frm and .idb files that need to be preserved, but will appreciate a careful and diligent conversion to ensure no data loss. The ideal candidate for this job would have: - Extensive experience with MySQL 5.7. - Proficiency in SQL file conversion. - Strong knowledge of database export practices. - Keen attention to detail to ensure data integrity.

...calculate the hourly rate and the time needed to complete different task documents, on an agreed fixed price. The best offers with the right experience will have the opportunity to work with us on a long-term basis. Also, Good prospects for the right developers, based on the performances evaluated over a period of time, once you established your skills. Need to provide the changed code details and sql queries if any at the end of each sub-task, with the changed code line numbers. Unlimited Revisions are needed. Any bugs created due to your own developments are to be fixed on free of Charge. Recruitment is for a long-term big project as such, all the developers are subject to practical skill test for which not paid. Please send your details for the below-mentioned questions....

I need a ...time, drop off location - Every day 3 buses are departing to airport. Say morning 8am, 1pm and 8pm. We need to get auto emails based on this bus timings of scheduled pax list and they take manually report with date/time filter. Ideal Skills: - Strong background in web application development - Experience in booking system or related is a huge plus - Fluency in database management, preferably SQL - Proficiency in PHP or a similar back-end programming language - Strategic problem-solving skills and attention to detail The success of this project requires not just technical expertise, but also a clear understanding of travel agency operations and the importance of efficient booking management. If you have relevant experience and the right skill set, I look forward to...

...setting up Rocket Chat Servers. This project involves creating a cloud-based server with capacity for 10 users mainly focusing on real-time messaging capabilities of Rocket Chat. I am open to other chat messaging services. I want a private, cloud based instant messaging service with end to end encryption. This will include you setting up the cloud service on Building the services, and providing instructions on how to add users. I will provide accounts and give access. Key Responsibilities: - Building a cloud-based Rocket Chat server - Ensuring the server supports Real-time messaging feature Ideal Skills: - Familiarity with Rocket Chat or similar messaging platforms - Experience in server setup and management - Knowledge in cloud-based systems I hope to s...

I'm currently in need of an experienced full stack developer who is proficient in both JavaScript and PHP. Key requirements: - Strong skills in front-end development, specifically using JavaScript. - Proven experience in handling backend development with PHP. - Knowledge of SQL is also important. - While not a strict requirement, familiarity with JavaScript frameworks such as React, Angular, or Vue and PHP frameworks like Laravel or CodeIgniter would be a big plus. - Experience with SSL implementation is a must, but there are no strict preferences as to the type of SSL to be used (Wildcard or EV SSL). Being able to pick the right SSL depending on the project’s needs will be part of your responsibility. If you're the kind of developer who is adept at managing the f...

As an IT professional, I'm looking for an expert in Microsoft's Exchange Server 2019, as I need it set up for several organizations. The server setup must allow client access through Outlook on the web, Exchange ActiveSync, and Outlook Anywhere (RPC over HTTP). Ideal Skills and Experience: - Proficiency in Microsoft Exchange Server 2019 - Previous experience setting up servers for multiple organizations - Familiarity with various client access setups including Outlook on the web, Exchange ActiveSync, and Outlook Anywhere (RPC over HTTP) This task involves complex server configuration so only those with corresponding expertise should apply. This job would entail making sure that setup and client access is seamless for each organization.

...changes to said settings. - Sending an email alert every time a change is detected. Freelancers with experience in creating similar systems or possessing a deep understanding of the workings of Windows OS will be preferred. Additional Details: Monitor Regedit for the changes related to the policies applied through Service. Send notification to server, send mail to a group, in case of change not applied through Service. 7. Logs needs to be updated to SQL via a API POST call (this endpoint is developed you need to call this Only) and keep a backup at local database. POST JSON - { "Username": "", "MachineName": "ABC", "Timestamp": "", "appliedPolicies": [ { "Policy1": "0", "Pol...

I am looking for a graphic designer to create a bold and colorful YouTube thumbnail for a podcast. The thumbnail should include a catchy phrase related to the main theme of the podcast, which is real estate and business. Skills and experience required for this project: Graphic design expertise, with a strong understanding of color theory and composition Ability to create eye-catching and visually appealing designs Experience in creating thumbnails for YouTube or other social media platforms Understanding of the real estate and business industry to accurately represent the podcast theme The ideal candidate should be able to create a thumbnail that grabs attention, communicates the podcast's theme, and entices viewers to click and listen. The name of the podcast is "Inner Wealth...

I need a top-notch video editor to create a visually stunning, cinematic trailer for my Fivem Server game. The trailer should be between 1-2 minutes in length. The focus should be on highlighting the unique server features that distinguish the game. The ideal freelancer for this project would possess: - Skills in creating high-quality, cinematic trailers - Experience in promoting game server features effectively - Ability to tell a compelling story within limited time Your mastery of visual storytelling will help in capturing the unique aspects of the server, ensuring that every second of the trailer engages viewers.

Im seeking a skilled Full Stack Developer to join our team in building a local freelancer platform. The platform will connect job seekers and posters, facilitating the posting and bidding of jobs, as well as managing project progress and payments. The ideal candidate will have expertise in both front-end and back-end development, with experience in TypeScript frameworks for server-side rendering and React.js or Vue.js for web development, as well as React Native or Flutter for mobile app development. Responsibilities: - Develop user authentication and profiling features, including sign up, basic details collection, and user categorization. - Implement job posting functionalities, allowing users to create detailed job listings with prompts and boilerplate templates. - Design and...

I'm currently in need of a freelancer who can assist me in switching my email server from its current service to Gmail on my FreePBX13. Key Responsibilities: - Change email server from current "other" service to Gmail - Ensure successful delivery and reception of emails on new server - Maintain FreePBX13 system integrity while making modifications Ideal Candidate: - Experienced with FreePBX13 and Gmail - Has past work examples related to changing email servers - Has superior troubleshooting skills in case of unexpected issues During your bid, please detail your relevant experience. Experience with FreePBX13 and Gmail is essential to carry out this task effectively.

I need to integrate Tableau with my SQL database, and I'm looking for a skilled freelancer to handle this. Key Responsibilities: - Setup Tableau integration with SQL database - Ensure seamless connection and data flow between the two - Deliver a functional, user-friendly interface for data visualization Ideal Skills: - Strong experience with Tableau and SQL - Excellent understanding of database management and integration - Ability to create interactive dashboards - Proficiency in optimizing data for Tableau visualization This project will require a keen eye for detail and a commitment to delivering a quality, tailored solution.

I'm currently facing some installation issues with Tableau Server. I'm looking for an experienced freelancer who can resolve these issues for me.

I need an IT engineer to install ThingsBoard Community Edition on my Windows server. Key Responsibilities: - Install ThingsBoard Community Edition on my Windows server. Ideal Skills and Experience: - Proven experience in server administration, especially Windows. - Familiarity with ThingsBoard platform or similar IoT platforms. - Ability to troubleshoot and resolve software installation issues. - Strong problem-solving skills and attention to detail. Please apply if you have the right skill set and availability for this project.

For your quote to be considered please start with "I am a Cisco Professional" I'm looking for a professional who can assist me in installing Windows Server OS on my Cisco UCS C220 server as soon as possible. We have the server and have configured the LSI Virtual Drives when we try to install the OS we get Driver IRQL error with "What Failed " For someone who is experiences this should be a quick one

Project: Development of a server and API for integration with an external distributor API and providing functionality to partners through a proprietary API. Objective: To create a reliable API gateway integrated with an external distributor's API, automating the processes of topping up gaming accounts, retrieving information about available games and pricing, and offering services to partners for their own use. Main Tasks and Requirements: Server Development: Setup and support of a server to handle API requests. Ensure continuous operation of the server and fast processing of requests. API Development and Implementation: Integration with the distributor's API to perform top-up operations, retrieve information about available games, prices, and deno...

I'm currently experiencing some problems with SQL Server 2019 regarding a synchronization error in my Snapshot Replication model. Present issue: - Synchronization process follows an error. Desired solution: - Ability to correct the synchronization errors to allow for smooth data replication. Ideal Skills: - SQL Server 2019 expertise - Solid understanding of Snapshot Replication model - Proven experience in troubleshooting synchronization errors. I'm seeking assistance from someone with these expertise, who can provide a quick and efficient resolution to this problem.

Hello, I host a game and I would like to send an email to all my old members. There are more than 1 million emails, some are very old from 2005 to 2024, so there will be many bounce emails in between, but I still want to reach out to my old players. I am looking for someone to set up a VPS with a mail server for me. Regards

I'm in need of an experienced Vue.js developer to assist with front-end development and implementing dynamic components. The project specifically involves working with Vue 2 and does not require integration with external APIs. Key Responsibilities: - Front-end Development: You'll be tasked with designing and developing the user-facing aspects of the application. - Dynamic Components: Implementing dynamic components to enhance user experience and application functionality. Ideal Skills and Experience: - Proficient in Vue.js: Extensive experience with Vue 2 is a must. - Front-end Expertise: Strong background in front-end development, with a focus on user interface design and development. - Dynamic Component Implementation: Proven experience in implementing dynamic components in V...

I am looking for a Magento 2 developer who can help me fix a specific cron job error I've been experiencing. The error states "SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'entity_id' in". Ideal Skills and Experience: - Proven experience with Magento 2 development - Strong understanding of cron jobs and how they work within Magento 2 - Familiarity with debugging and resolving SQL integrity constraint violations Please note that the specific table causing the error was not identified. Your expertise in this area will be crucial. I am using Magento 2.4.6-p4 CE and I get the following error after every order. The job indexer_update_all_views scheduled at 2024-04-15 10:31:03 failed with the following error message: SQLSTATE[23000]: Integrity ...

I'm seeking a talented full stack developer for initial software development for a pathology lab. The software must be responsive, user-friendly, and robust, catering to patients, staff, and referring doctors. Here's what we need: 1. **Choice of Platform**: As the client, I am open to using Angular, React or PHP for the development along with SQL Server/MySQL for the database. Feel free to recommend a platform when you apply. 2. **Essential Modules**: - Building Patient Database (From existing Lab Software - Which will remain as is). This database will be used for Whatsapp , email , SMS Marketing (This also is part of scope) and also For Patient Web App interface. Whatsapp API interfacing will be required for sending and interacting with Patients. - Patient...

I am in need of an experienced Linux server expert who can assist me in setting up a robust and functional Linux server. Your responsibilities would include: - Installation of the server, ensuring it's in proper working condition. - Configuration of both LiteSpeed and Apache web server softwares. Experience in these is essential. - Facilitating user management across the server. - Installing Plesk control panel on the server. Familiarity with this control panel will be a major advantage. Please reach out if you have a proven track record in Linux server management, installation, and configuration.

...my SQL Server database. Key Features: - Property Search: Users should be able to search for properties in my database - Property Details: Users should be able to view detailed information about the properties - Favorites List: Users should be able to save properties to a favorites list User Authentication: - The app should allow users to sign in using their Email and Password. Property Search: - The property search feature should integrate a map view for a better user experience. Users should be able to visualize the location of the properties they are interested in. - It should also include the option to save searches, which will be a convenient feature for users who are actively looking for properties. Ideal Skills: - Proficiency in Xamarin development - Experience w...

I need a developer to create a proctoring exam application using Python and SQL Server. The primary role of this app is to monitor candidate behavior during online exams. Key features include: 1. Online Registration Of Candidates: A feature for students to easily register for exams. 2. Password-Based Authentication: To authenticate candidates before they can access the exams. Prior experience in implementing secure login mechanisms is preferred. 3. Advanced Browser Disablement: Unfortunately, there will be instances when candidates try to cheat the system. I need to prevent this by disabling browsing other tabs, accessing other applications, and the copy-paste function during the exam period. 4. Random Image Capturing & Video Monitoring: To further deter any cheating, t...