Database normalization sql server työt

Usealla isolla yrityksellä on käytössään Suomessa eräänlainen heidän alansa ERP-paketti, joka on koodattu Visual Basicillä. Tarvitsisimme VB-osaajaa ylläpitämään ohjelmistossa mahdollisesti tehtäviä muutostöitä. Tekniikka lyhyesti: • Visual Basic -koodia noin 280-290 000 riviä • Integraatio taloushallintoon ja palkan maksuun • raporttipuolella n. 50 000 riviä • Crystal Reports • Microsoftin SQL Server -kanta Työmäärät vaihtelee, mutta keskimäärin 1-2 päivää/viikko. Välillä hiljaista.

Meillä on kaksi yritystä järjestelmässä, joilla on omat varastokirjanpidot ja osto-&myyntitilauksensa. Lokaalina serverinä toimii Windows 7 ympäristössä, visma Nova pro 9 (Windows sql server). Mikäli työn suoritus vaatii jonkin tietyn ympäristön niin kysele. Haluaisimme ajoitettuina tehtävinä ajaa allamainitut skriptit jotka muodostavat CSV tiedostot jotka on tarkoitus lähettää sähköpostina eteenpäin. Skriptin asetusten muokkaus skriptin alussa. Muuttujat ja funktiot kommentoituna. Lisätyönä voi tarjota näiden tiedostojen automaattista lähettämistä (Tiedosto liitteenä + leipätekstissä luettavasti muotoltuna). -------...

Webservicen luominen sql tietokannalle. Perus toiminnot webservicelle ja kehitys ympäristön pystytys. Tarkempi speksi on saatavilla NDA:n kirjoituksen jälkeen. Kehitys mielellään Eclipse ympäristössä.

Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies the Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is available and the Project needs to be done using Visual Studio. Azure SQL database management and required SQL queries are not in the scope of the Project.

Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies andthe Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is avaiable and the Project needs to be done using Visual Studio. Azure SQL database and required SQL queries are and database management is not in the scope of the Project.

Excel Add-In joka hakee ja tallentaa taulukkomuodossa olevaa dataa Azure SQL-kannasta/-taan. Lisäksi ohjelmallista Excel muokkausta ja hallintaa C#-koodilla. Osaan Excel muokkauksista valmis VBA-script, joka muutettava C#-kielelle. Visual Studio 2015 alkukoodi, SQL Azure tietokanta ja kyselyt valmiina.

Java, J2EE, JDBC, SQL, java Threading,GWT,Html,CSS

server optimisation

Moro, Mulla olisi sulle työtarjous! Jos voisit tehdä mulle simppelin tietokannan ~5 taululla, ja kerrot vähän perusjuttuja sql serverin toiminnoista jne, niin ota yhteyttä ja jutellaan tarkemmin. Arvioisin, että tässä ei montaa tuntia menisi. Riippuen toki kuinka hyvin nuo sql perusjutut osaat ;)

Moi! Osaatko kuinka hyvin sql:n perusasiat? Onnistuuko asentaa tietokannan hallintajärjestelmä, luoda ja hallinnoida tietokantoja sekä käyttäjätilejä ŠŠ ,seurata ja optimoida tietokannan toimintaa. Jos perusasiat hoidossa niin ota yhteyttä :)

Moro, Mulla olisi sulle työtarjous! Jos voisit tehdä mulle simppelin tietokannan ~5 taululla, ja kerrot vähän perusjuttuja sql serverin toiminnoista jne, niin ota yhteyttä ja jutellaan tarkemmin. Arvioisin, että tässä ei montaa tuntia menisi. Riippuen toki kuinka hyvin nuo sql perusjutut osaat ;)

I am working on React JS with Javascript Development Project. I need someone to Support me for this Project atleast 4 to 5 hours Per day. Project will Exist more than 2 years. I need support through Remotely(zoom). I am looking for Good Experienced(4+ years) Person as a Frontend Developer, Who can work on the tasks Quick...the tasks Quickly. I am looking for Long term relationship. After this Project Completed means, we will give immediately another support project. I will Give you the Sample Task on Cypress Test Cases for 30 mins, If you Completed ON TIME means we will give you the Project. Cypress Test Cases Immediately Required. Required Skills : React JS, HTML, CSS, Javascript, Cypress Test Cases(Mandatory), SQL Basics Language Speaking Person : English Note: I will pay on ho...

I am looking for an expert who can help me set up a SIP trunk server using Twilio as the SIP provider. This server will be used for both voice calling and SMS messaging. Key Responsibilities: - Establishing a SIP trunk server with configurations optimized for Twilio - Implementing call management features like Call Recording, Call Forwarding, and Interactive Voice Response (IVR) - Ensuring seamless integration of both voice and SMS capabilities - Providing recommendations for server security and performance optimization Ideal Candidate: - Extensive experience with SIP trunking, particularly with Twilio - Proficiency in configuring and customizing SIP trunk servers - Proven track record in implementing call management features such as Call Recording, Call Forw...

I'm in need of an expert who can help me with the following tasks on my existing server: - **Server Configuration:** Fine-tuning and optimizing my server settings to ensure it's running at its best. - **DNS Management:** Managing and configuring my domain's DNS settings to ensure proper functionality. - **Email Setup:** Setting up email services on the server for my domain. I will provide you with root access to the server, so you should be well-versed in security practices and able to handle the responsibilities that come with that level of access. Ideal candidates should have: - Extensive experience in managing Cpanel and WHM - Strong knowledge of DNS configuration and management - Proficiency in setting up email services - The abil...

I'm looking for an exhaustive list of Australian gym owners, with a focus on capturing between 100 to 500 individual records. The data needed includes, but not limited to: - Owner's Email Address - Gym's Name - Gym's Website Ideal candidates for this job are experienced data miners and researchers. Having a good understanding of the Fitness industry would be beneficial. Strong attention to detail is paramount, ensuring accuracy in data collection and entry. Additionally, demonstrating respect for privacy laws and guidelines, including GDPR, is essential. Experience with spreadsheets and CRM systems would be advantageous. Gyms must be privately owned only, non franchise. Offer Personal Training. Boutique Exclude: Category - Fitness Equipment Category - Community He...

1 Need to build a website monitoring program to monitor changes in sub-pages of the landing page Detailed requirements: The website needs to have SQL function because batch site monitoring needs to be uploaded. 2 Identify the link to the final sub-page login keyword such as Proxy function and mobile phone UA because mobile phone batch UA is required Multi-thread monitoring 3 Filter duplicates and monitor changes in subpages of the website Set a custom time to refresh the web page 4 Send the new URL of the subpage change to the created group through the telegram machine

...professional who can migrate the site to a new server and ensure it's correctly configured for PHP/CodeIgniter and be familiar with managing folder structures (public, app, and others). Key points: - Full site migration: Transfer all site files, databases, and ensure all links and functionalities are working without any issues. - Testing and troubleshooting: Conduct thorough testing post-migration to ensure the site is fully functional and able to handle traffic as expected. Ideal skills and experience for this job: - Extensive experience in PHP/CodeIgniter site migration - Proven track record of configuring servers for PHP/CodeIgniter applications - Strong troubleshooting and testing capabilities to ensure the site is fully operational on the new server. INSTALLAT...

...This webpage should be capable of updating a database based on the scanned QR code information. I'm not entirely sure whether an existing database can be used for this project, so your experience in setting up databases would be a plus. Key requirements and decisions to be made: - Setting up a Laravel project with QR scanner functionality - Integration of the scanner with a database to update it according to scanned QR codes - The system should handle multiple scans of the same QR code by the same user by ignoring subsequent scans - The primary action the system should take is a check-in/check-out registration process, triggered by the QR scan Ideal skills and experience for the job: - Proficiency in Laravel and PHP - Experience with database setup...

I'm looking for a Python expert who can help me preprocess and normalize a CSV dataset for a machine learning project. Key Responsibilities: - Loading the CSV dataset - Adjusting timestamps - Merging data from a single file - Normalizing the data using Min-Max scaling Ideal Skills and Experience: - Proficient in Python programming - Solid understanding of data preprocessing techniques - Experience with handling and merging large datasets - Familiarity with statistical analysis and machine learning modeling This project is crucial for setting a solid foundation for the subsequent machine learning analysis. The freelancer who takes on this role should be able to execute these tasks accurately and efficiently, with a strong eye for detail.

...skilled developer to implement DTLS in C for secure communication within a tight deadline of two weeks. Key project requirements: - Implement DTLS in C: The primary goal of this project is to introduce DTLS to an existing system for secure communication. - Tight deadline: This project needs to be completed within two weeks. Timeliness and reliability are crucial. I need the data coming from the server to the client over UDP socket to be encrypted with DTLS, and it should appear as DTLS in the protocol section of Wireshark. In addition, the code should be able to handle streaming video or live feed over the socket accordingly. This code should work in linux and windows. Ideal Skills and Experience: - Proficiency in C: Extensive experience with C language is a must. - DTLS Kno...

I urgently require a proficient SQL Server expert, particularly conversant with SQL Server 2012. My primary challenge is recovering deleted records. Ideal Skills: - Comprehensive understanding of SQL Server 2012 - Expertise in data recovery processes Experience Required: - Proven track record in database recovery - Past work with SQL Server 2012 Your immediate availability for this project is essential. Please, only serious and experienced candidates should bid.

NextGen is seeking an experienced IT professional or team to deploy a private email server on our internal infrastructure. The goal is to enhance security, ensure data privacy, reduce dependency on third-party email services, and customize the email system to meet our specific needs. The project will involve setting up the server, configuring DNS records, installing and configuring necessary software, securing the server, and ensuring seamless email access for all users. Key Deliverables: Infrastructure Setup: Set up a dedicated server or VPS with a static IP address. Configure necessary storage and network resources. DNS Configuration: Configure MX, SPF, DKIM, and DMARC records to direct email traffic to the server. Software Installation and Configur...

I am in need of a skilled developer to assist with an existing API integration between SilverStripe website and REX Software, with a focus on correcting a data issue that is causing the server to fail with backing up the website due to disk usage. The server technician said: "The disk usage is at 80% so a dump would fail as it would need more space to create a sql file to be transferred. It looks to be an issue with REX and the website framework SilverStripe. It may be that REX is not configured to remove (dump) old data." Your role will involve correct the error so the server does not continue to reach its disk usage and implementing a seamless API integration that successfully synchronizes and updates property listings between these two platforms. ...

I'm looking for a skilled professional to set up a Virtual Box on my dedicated server, running Windows OS. The primary function of this setup is to have multiple virtual terminals of Windows operational. Key requirements: - Installation of Virtual Box on a dedicated server - Configuration for simultaneous operation of 5 virtual terminals of Windows Ideal skills and experience: - Proficiency in Virtual Box and working with dedicated servers - Strong knowledge and experience in setting up and configuring Windows OS - Ability to ensure smooth and efficient operation of multiple virtual terminals

I'm running a Node.js website where the last user's data is mi...promptly. Key Responsibilities: - Investigate the current data display functionality and how it's handling user data. - Correct the code responsible for showing the last user's data to the first user. - Ensure that the correct user data is displayed to each respective user post-login. Ideal Freelancer: - Proficient in Node.js with a deep understanding of data management and display. - Experienced in SQL databases, specifically in managing user data. - Previous experience in debugging and resolving similar issues is a plus. - Deadline-oriented and able to work efficiently to resolve this issue. Please refer to the attached video for better understanding of the issue. Your prompt attention to this ...

We are seeking an experienced developer or team to create a comprehensive web software and database system for the remote monitoring and control of cathodic protection stations (SKZ) equipped with TE-RCU control units. This project involves developing web applications, database design, and integration of communication modules for real-time data acquisition, SMS/GPRS control, and SCADA system interfacing. More details will be sent in private.

...manage Azure messaging services to handle asynchronous communications, ensuring efficient and reliable data exchange across system components. SDK Development - Develop and maintain an SDK that provides third-party developers with the tools needed to integrate their AI bots or other services with our platform, including comprehensive documentation and support. Database Management - Manage and optimize MySQL database interactions within the WordPress environment, ensuring efficient data retrieval and storage. System Integration and Testing - Oversee the integration of all system components, employing best practices in continuous integration and deployment to maintain system integrity and performance. Documentation and Support - Produce detailed documenta...

I'm in need of an experienced Linux and Server Admin who can help me with the following tasks: - Linux and Server Administration: Proficient in CentOS, you'll be managing my server and ensuring its optimal performance. - Web and App Installation: You'll be responsible for installing and configuring various websites - coded in PHP, Node.js, and React - on the server. Additionally, you'll need to install Flutter and React Native apps. The ideal candidate should have advanced understanding and practical experience in Linux system administration, server administration, and web/app installation. Proficiency in PHP, Flutter, and React Native is required. --------------------------------------------------------------------------------------...

I'm in need of a talented developer who can help me with implementing server-side rendering for my website. Website not rendering html right now so need to do server-side rendering. You are good if you can do that through anydesk or teamviewer. Yes, i can work with new freelancers, Just send me github profile so i can check what you've done. Start your application with "SSR", all other will be ignored.

I need a small application prototype with the following features: Multi-Employer Job Portal/Admin app (Role Based access) User/applicant App (for Multiple applications to different employers) User Profile Document Upload (Save documents to Db and attachments to Blob Storage ) Send Emails to Employers and applicants back and forth 2 Apps in total ...features: Multi-Employer Job Portal/Admin app (Role Based access) User/applicant App (for Multiple applications to different employers) User Profile Document Upload (Save documents to Db and attachments to Blob Storage ) Send Emails to Employers and applicants back and forth 2 Apps in total ie. admin app and applicant app. job application requirements will be provided. Nodejs, angular, My SQL, ORM, Data Seeding, Migrations shoul...

Request details FOR EXPERTS WITH EXTENSIVE EXPERIENCE IN THE FIELD ONLY Objective: Scoring Algorithm for evaluating potential investments Data Source: 200+ proprietary historical records with up to 90 parameters Mentoring requested (to be worked with tech project lead and data engineer): • Data-Preprocessing (missing values, normalization, outliers) • Implementation methods for feature selection (e.g. correlation Analysis, feature importance, etc.) • Identify and run different algorithms (e.g., logistic regression, decision trees, random forests, gradient boosting, neural networks) • Details and rationale behind algorithms selection • Hyperparameter tuning and optimization • Cross-validation • Performance metrics (e.g., accuracy, precision, reca...

I am looking for a freelancer who can help me set up iRedMail on my Linux server. - My server is running on Linux. - I have less than 10 email accounts that need to be set up. Due to my lack of technical expertise, I need someone who is familiar with iRedMail and Linux server administration. The ideal candidate should have experience in configuring mail servers and be able to provide a smooth and efficient setup.

I'm looking for a skilled professional who can help me secure my Linux server and SMTP setup. Key Requirements: - Deep experience with Linux server security measures and best practices. - Proficient in securing SMTP servers and ensuring authentication is managed effectively. - Capability to implement SSL/TLS encryption for enhanced security. Your application should focus on detailing your experience in this field. Please provide relevant examples of previous projects where you've successfully secured similar systems.

I need a bash script that can import and export data from my database to CSV files. Ideal candidate should be able to: - Create a bash script that can effectively import and export data - Have experience working with database management systems such as MySQL, PostgreSQL, or MongoDB - Ensure that the script securely creates user accounts and manages their access to the database. The script will be used for daily database management tasks, so it needs to be reliable, secure, and efficient.

I am in need of an experienced Linux developer for a project that involves server configuration and also have knowledge of apache logs as well to fix some apache issue. Important : Job have to done Remotly.

I have a SQL Server that needs to be accessible over the internet. However, I'm facing connectivity issues, possibly due to closed or blocked ports on my ComCast router model CBR2-T. I need a freelancer to open the necessary ports on the router. The task involves: - Checking the current port status on the router - Identifying the SQL Server port - Opening the port on the router Please bid if you're experienced with network configuration and have dealt with ComCast routers before. Necessary Skills: - Network Configuration - Router Administration - ComCast Router Experience - SQL Server Configuration

I require someone experienced in Linux server management to help optimize the performance of my server. Linux Server Performance Optimization Plesk Obsidian, SQL, PHP Key Responsibilities: - Review the current server setup and performance - Identify areas for improvement - Implement solutions to optimize server performance - Fix the 2 errors. This is not a one-time setup; I may require ongoing management based on the initial optimization results. Your expertise in Linux server management is crucial to this project.

I need an experienced app developer to update my iPad app to fix a server connection issue. The app is currently unable to connect to the server, and this problem needs to be resolved. Once the update is complete, the app should be submitted to the Apple Store, and I require it to be compatible with iOS 12 and earlier. Key Requirements: - Fix the server connection issue preventing the app from connecting - Update the app to be compatible latest ios firmware - Submit the updated app to the Apple Store You should have: - Prior experience in iOS app development, particularly with server connection issues - Ability to navigate Apple's submission process and ensure the app meets their requirements - Proficiency in iOS 12 and earlier, and the ability to make ...

I'm in need of a professional web developer to create a platform that serves as an agent management website. The website should have an elegant interface, account logins, and a simple credit system that can be administered by an admin account. Key Features: - Agent Registration and Login: The website should allow agents to create accounts and log in securely. - Profile Manag...agent registration and login feature is not fully defined yet. The ideal candidate for this project should have experience in building similar systems, understand user account management, and have the ability to design an aesthetically pleasing interface. Requirements can be asked if you are interested, you can build with any framework, preferably javascript based frameworks. Minimal SQL is required, a...

the project is about to create a Minecraft map that faithfully replicates a GTA RP server. GTA RP (Grand Theft Auto Roleplay) is a unique gaming style where players embody a character and immerse themselves in its persona, acting as if they were that character. Key Features of GTA RP: 1. **Roleplay Dynamics**: - Players assume the identity of a self-created character and live out their life within a fictional context alongside other players. - Interaction can be via text or, preferably, voice chat for enhanced realism. - Characters can be anything from a prominent businessperson to a foreigner unfamiliar with the local language, a mafia woman, etc. The possibilities are endless. 2. **Collaborative Storytelling**: - Every player online is roleplaying their own char...

I urgently need assistance with installing a PHP application on my dedicated Linux server. Key requirements: - Expertise in server management, particularly dedicated servers - Proficiency in PHP application deployment - Strong knowledge of Linux operating systems Please only bid if you have significant experience in this area and can start immediately. Your prompt help is highly appreciated.

...work on a web project of mine. The project involves HTML, CSS, JavaScript, and some light database functions. The work will mainly focus on: - Implementing text input fields and dropdown menus: These are crucial elements for user interaction and data input. Your job would be to make them look and function as required. - Basic database functions: While the exact nature of these is yet to be decided, they will likely include retrieving and adding data. Your task will be to integrate these functions seamlessly into the site. Ideal skills for this project would include: - Proficiency in HTML, CSS, and JavaScript, with experience in creating user-friendly and responsive UIs. - Familiarity with basic database manipulation. - Good communication skills, as we'll need ...

In my project, I'm looking to set up ActiveMQ JMS messaging for our system, focusing on synchronous and asynchronous messaging. We anticipate a low scale of message traffic, not exceeding 1,000 messages per day. Key responsibilities will include: - Setting up Ac...to publish and subscribe messages to ActiveMQ queues Create queries to make sure data is published into the respective tables and assertions to validate Ideal skills and experiences for this role would include: - Proficient in ActiveMQ and JMS messaging - Previous experience in setting up asynchronous messaging systems - Familiar with SOAPUI and its capabilities for message testing - SQL developer for database queries and validations Please bid on this project if you're confident in your ability to del...

Looking for help in modifying an existing python script and related sql database table The current script - (1) scrapes company financial data from website and populates database (2) scrapes news related to keywords from google news (3)sentiment classification of news items (4)pushes data to sql database The company names and keywords are currently hardcoded in the script Requirement- (1) Company names/urls/keywords (will be provided) to be put in master table in the database (2) The script to loop through and scrape the relevant data and put in database

I'm looking for a freelancer who's great at web scraping to help with a project involving a specific website initially, with potential for more. I'll give you the specific data fields to extract. It'd be great if you: Are really good at web scraping and or Python. Know your way around MS SQL Server databases, not essential but definately an advantage. Understand how to extract data effectively. Understand the need for security and captcha integration if needed. Can work quickly since this project is a priority and needs to be done ASAP. Ultimately, I want to be able to manage the code with your ongoing help, so this could lead to a long-term partnership. I'll share the full details when needed. You will provide source code, documentation and deployme...

already we are running a page on server , on migration we are not able to up the apache and page on new server

...redesigned website onto a new server. Key Objectives: - Redesign to Improve Conversions: The primary aim of the redesign is to enhance user experience and bolster the site's conversion rates. Particularly, I'm interested in optimizing call to action buttons to boost user engagement and ultimately, conversions. - Server Deployment for Enhanced Performance: The new server deployment should prioritize faster loading times. A significant aspect of this project is to ensure that the website works seamlessly on the new server without any disruption to its functionality. Ideal Skills: - Proven experience in website redesign with a track record of increasing conversion rates. - Proficiency in UI/UX design and a strong understanding of user behavior. - T...

...Private Server. I want to redesign 2 of my website pages fully 100% 1-homepage 2- token page and other pages backgrounds and fonts. and make the site live in other server. thanks Key Requirements: - Redesign: I need the new website to have a modern and visually appealing design. This includes a seamless, user-friendly interface, engaging graphics, and intuitive navigation. - Deployment: After the redesign, you will be responsible for migrating the site to a Virtual Private Server. This requires a solid understanding of server configurations and best practices for deployment. Ideal Candidate: - Prior experience in web design and deployment, preferably for similar projects. - Proficiency in front-end technologies and design principles. - Familiarit...

Required a dot net developer. Speacialized in Microservices acrhitecture based solution. Dotnet Core, C#, SQL, Data transformation, API gateway, Auth based security.

I am seeking a full stack PHP developer to assist me with my project. I'm looki...are a skilled PHP developer with experience in full stack development and are passionate about producing high-quality applications, this project is for you. Your ability to work both independently and collaboratively will be key to our success. Ideal skills and experiences include: - Proficient in PHP and related frameworks - Strong knowledge of HTML, CSS, and JavaScript - Familiarity with SQL and database management - Experience in user authentication and payment processing - Understanding of project management and problem-solving - Excellent communication and time management skills I am looking to commence this project at the earliest convenience, so please get in touch if you'r...