Perl procedure 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
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'm looking for an expert to perform a multi-node deployment of Corda on AWS using Kubernetes. Skills and Experience Required: - Strong knowledge of Corda platform - Extensive experience with AWS setups specifically Kubernetes - Proven track record of deploying multipl...knowledge of Corda platform - Extensive experience with AWS setups specifically Kubernetes - Proven track record of deploying multiple nodes on Kubernetes. Responsibilities include: - Setting up and configuring Kubernetes on AWS - Deploying multiple Corda nodes onto the AWS Kubernetes setup - Testing to ensure successful deployment and addressing any issues that may arise. - Demonstrate procedure to update application source code on Corda If you have the skills and experience I'm looking for, I'...
...Umbraco (Microsoft open-source CMS). - Backend: C# coding. - Database: MySQL. - Currently hosted on a Windows server with IIS. - **New Hosting Environment:** - Hostinger VPS with Linux OS. - SQL Server installed via command line (no GUI). - No Windows server or IIS available. **Issues Encountered:** - Umbraco runs well locally on the VPS but not accessible externally. - Unable to attach the website domain. - Issues uploading the website from a local machine to the VPS. **Requirements:** - Expertise in Umbraco CMS. - Strong knowledge of C# and MySQL. - Experience with migrating websites from Windows/IIS to Linux environments. - Familiarity with configuring SQL Server on Linux. - Ability to troubleshoot and resolve issues with domai...
A website used to be a WP site. It is now remade with and the new version is hosted on a new server. I need to retrieve the old information from the DB drop. When I try to add the database entries to a freshly installed WP installation and access it (either localhost or server) it immediately throws 301 error and redirects to the new kobe-oukoku website. Please add this text in the beginning of your application so I know you've read the description: kobe animal kingdom.
I require a skilled professional to build an Asterix server on a Windows platform. The primary role of this server will be to host a communications web application. Key Responsibilities: -Build an efficient Asterix server on Windows -Make sure it's optimally configured to host a communications application Ideal Skills and Experience: -Experience in building servers on Windows -Understanding of communications application requirements -Proven expertise in handling Asterix servers This is a challenging yet rewarding opportunity, requiring a deep understanding of both Asterix servers and communication applications. Bidders with relevant experience, showcasing their capabilities at managing the requirements, will get preference.
As a business owner managing my domain hosting on a different server, I am looking for an experienced AWS specialist to help me migrate to AWS. Key Project Details: - My primary purpose for migrating to AWS is to improve my site's performance. As such, I'm looking for a freelancer with demonstrated experience in optimizing and enhancing performance on AWS. Ideal Skills & Experience: - Proficiency in AWS services, particularly Amazon EC2 and Amazon S3 - Experience with server migration, ideally from another hosting provider - Demonstrated ability to improve website performance through cloud services - Strong understanding of security measures associated with AWS - Good communication skills to ensure a smooth transition and understanding of the process Please p...
...already documented and installation procedure is explicite. Based on the App documentation, Key requirements and responsibilities include: - Setting up the necessary server and networking infrastructure. - Configuring the server to ensure optimal performance and security. - Deploying the app and ensuring it runs smoothly on the VPS. The anticipated traffic for the app is low, with a maximum of 1,000 users per day. The successful candidate should be able to not only deploy the app seamlessly, but also ensure the server can accommodate the expected traffic without issues. Ideal skills and experience for this role include: - Proficiency in deploying apps on Docker, Swarm/Kubernetes. - Solid understanding of DevOps principles and practices. - Experience wit...
I'm in need of a freelancer who can help me parse my V...me parse my VCF file and convert it to a different format. The main goal of this task is to extract the genotype information from the file. input will be VCF file (from ONT whole genome run) and csv file with columns containing rsID, chromosome number, position. output will be same as input csv file, with extra column showing genotype from VCF at the given position can run on Mac shell so either perl or python would be fine. Ideal Skills & Experience: - Proficient in parsing VCF files and understanding genotype data - Experience in converting files to various formats like CSV, TXT, and XLS - Attention to detail to ensure accurate extraction of the data - Knowledge of any data validation methods would be a plus. shou...
...that I need. The data columns listed above will be need to be automatically pulled into tables and columns and stored in Microsoft Excel. I need to be able to use SQL or a UI and ultimately easily import/embed into Microsoft Excel - the data finally must be pulled into Microsoft Excel. The freelancer must be Proficient in working with Amazon Seller Central and pulling back the relevant info for comprehensive, robust reporting purposes. Understanding of reporting data from Seller Central data and experience in data reporting and data analytics. Also ultimately this data is to be stored into a database and to where I can use SQL to create queries and tables for dashboard reporting purposes. Your work will be crucial in creating and enhancing reporting for accessing a...
As a patient who had to undergo brain surgery, I understand firsthand the anxiety and uncertainty that comes with this journey. I am seeking a skillful writer to help me create a detailed guide that will assist fellow patients in preparing for this major procedure. Key Points to Cover: - Process Explanation: Clarify the stages and details of brain surgery. - Preparation Guidelines: Guidance on what needs to be done before the operation, what to expect, what to prepare, who to speak to, processing emotions - Expectation Management: A comprehensive understanding of what to anticipate post surgery. - guide for caregiver / family: What to expect and how they can assist - Mix of Medical Advice and Personal Stories: The guide should blend medical advice with personal experiences to pr...
I require a meticulous professional, experienced in the workings of Microsoft A...Solve data type mismatch errors, ensuring seamless data integration - Add some of the small functionalities to the application. - Need the full application to run smooth without errors. Ideal Skills: - Commitment to meet tight deadlines as an immediate resolution is vital - Prior experience in troubleshooting errors in Microsoft Access 2007 - 2010 - Expert understanding of database structures and Sql syntax Ultimately, the freelancer should bring this software application back to its most optimal version in the earliest possible timeframe. If you're that hands-on problem solver with a keen eye for detail, you could be just what this project needs. *Some of the sub-application the software has t...
Se requiere un sistema diseñado en Python que trabaje en sistema operativo Wndows, el cual a través del uso del WebCam pueda hacer reconocimiento de rostros comparando el rostro en la cámara vs el rostro almacenado en formato digital en una base de datos en SQL Server 2016+. El resultados debe ser un True o False. El sistema debe trabajar localmente (No en la nube).
Mevcutta hibrit bir uygulamamız var. Sql üzerinden veri çeken bir servis mevcut Bu projeye rapor eklenecek
I'm in need of an expert server administrator with extensive experience in Plesk to assist with the configuration and troubleshooting of my server. Key Responsibilities: - Server Setup and Configuration: The server is already fully configured, but I'm facing some severe issues. Your role would be to assess the current setup, make necessary adjustments and ensure that the server is running optimally. - Troubleshooting: The primary issue I'm experiencing is a DB query failed: SQLSTATE[HY000]: General error: 1 Can't create/write to file '/var/tmp/#' (Errcode: 2), query was: DESCRIBE `sessions`. Your expertise in diagnosing and resolving such issues will be crucial. Skills and Experience Required: - Proven experience in Plesk ...
My Apache Web server is not loading pages, but there are no error messages. I have checked and it is running and accessible. All pages seem to load to the default server page. The pages are running on Apache in Docker containers I need a skilled freelancer to help me resolve this issue. Ideal Skills & Experience: - Proficient with Apache Web servers - Troubleshooting skills - Understanding of server configurations -Work done AnyDesk, no SSH! Paying $15 Please bid if you have relevant experience.
This project needs a skilled professional who is highly efficient with dbt, Databricks, Snowflake, Google Cloud Platform (GCP), Python programming, and SQL database management. Responsibilities: - Execute data transformation tasks using dbt - Process and analyze data using Databricks - Handle data storage and querying on Snowflake - Manage cloud platform setup and tasks on GCP - Implement Python programming for data manipulation - Write and manage SQL queries and database Ideal Skills and Experience: - Prior experience in the same field - Intermediate level expertise in dbt data transformation - Knowledge of Python and SQL - Understanding of cloud architectures, particularly Google Cloud Platform - Familiarity with Snowflake and Databricks Applicants with su...
Having problems with Docker and need configurations 1 - 3 current running containers need proper ports assigned to them. The containers connect be lost as they are for production. 2 - set up and configure three additional separate Docker groups, each for a different entity which would contain sql, Apache, and file storage. Key Requirements: - Configure 3 isolated Docker groups for Entity A, Entity B, and Entity C isolated from each other. - The setup should be designed for scalability, load balancing, and security although specific requirements for each are not yet defined Ideal Freelancer: - Proven experience in Docker containerization - Familiarity with setting up and managing production environments - Strong understanding of port assignment and management - Capability f...
I need a simple C# Windows Forms management project. It has three classes: Service, Tourist and Tranzactions. It's for college and supposed to be for a tourism agency wanting to keep track of its services, tourists and tranzactions. Nothing complicated, a CRUD app connected to a SQL database, simple UI and the project has to meet the requirements from the screenshot attached below.
...our Windows Server 2022 RDP server. I need an experienced professional to fix this problem and make sure it doesn't recur. Key Requirements: - Diagnose and Resolve: You should be able to diagnose the root cause of the issue and resolve it efficiently. - Windows Server 2022 Expertise: You must have proven experience working with Windows Server 2022 environments and a deep understanding of its functionalities. - Troubleshooting Skills: Your troubleshooting skills should be top-notch to identify any underlying issues that may be causing the problem. - User Profile Management: You should be skilled in managing user profiles effectively to ensure a smooth and error-free experience for all users. I've already tried restarting the server, creating...
I'm looking for a professional who can deploy IT policies with Microsoft Business Premium for less than 10 users in accordance with the ISO27001 standard. The key areas I'm looking to cover are: 1 Clear Desk & Clear Screen Policy 2 Acceptable Use Of IT Assest Policy 3 Procedure Of User Access Management 4 Procudure Of Third Party Security 5 Vulnerability Management Process 6 Password Policy 7 Management Review Process 8 Mobile Usage & Electronic Media Policy 9 Teleworking Policy 10 Archival, Retention and Disposal Policy 11 Data Protection Policy 12 Information Continuity and Application Security Measure 13 System Configuration Standard IT Procudure Documents 1 Approved Software List 2 Asset Inventory 3 Deploying Anti Virus for Desktop 4 Workstat...
I'm seeking an expert in Windows Server licensing to clarify some key points. - I have a single Windows Server, specifically Windows Server 2019 or 2022. - 5000 user accounts will need to access this server concurrently and they will use web application on Blazor Server. - I need advice on the appropriate licensing model to accommodate this level of usage. Ideal candidates for this project are professionals with: - Profound knowledge of Windows Server licensing, preferably Windows Server 2019 or 2022 - Experience with large-scale user access scenarios and concurrent usage. - Ability to explain complex licensing models in simple, user-friendly terms. What is cheapest model for me to utilize. People will connect to app using Chrome b...
I am in need of a data mining expert proficient in Python, machine learning, and Selenium to facilitate a data mining project. If you are interested, so there would be 2 contract fix rate $50/country flow, and $3-5/hr for code's maintainance. Depends on your profile’s experience. $5/script for easier works (like scrap-data transferring between GS&SQL), Purpose of the project: The primary objective is to extract valuable information from a large set of data. The specific type of data to be mined will be shared with the successful candidate. - Skills and Experience: - Proficient in Python - Hands-on experience with Selenium - Thorough understanding of machine learning algorithms - Experience in handling large sets of data - Strong knowledge of d...
DMS verfügt über drei Bereiche, die jeweils eigene Domains und Webseiten haben. Für diese Bereiche benötigen wir: a) SEO-Unterstützung, einschließlich Anpassungen für Google b) Pflege der WordPress-Webseiten sowie Aktivierung der Shop-Funktion Zusätzlich ist eine Zusammenarbeit mit externen Software-Entwicklern (Englisch) erforderlich,...benötigen wir: a) SEO-Unterstützung, einschließlich Anpassungen für Google b) Pflege der WordPress-Webseiten sowie Aktivierung der Shop-Funktion Zusätzlich ist eine Zusammenarbeit mit externen Software-Entwicklern (Englisch) erforderlich, die eine Software für die Ersatzteilverwaltung (sowohl Admin- als auch Client-Seite) betreut. Erforderlich sind auch Kenntnisse in der Software-Ins...
...dealing with customer data specifically. Tasks to be undertaken include - - Retrieving customer data from the database - Cleaning the data efficiently to ensure it is free from errors and inconsistencies - Analyzing the data to provide detailed insights - Demonstrating these insights through clear visual tools The ideal freelancer for this job would display deep understanding and experience in SQL to query and manipulate databases. Python scripting knowledge for data analysis and cleaning is a major plus. Proficiency in using data visualization tools like Tableau would also be beneficial in conveying the results of the database analysis. The ultimate goal of this project is to use data effectively to inform business decisions regarding our customer base. If you find you hav...
I'm in need of skilled SQL guru to support me with my project. Some of the tasks include handling database design, query optimization and data migration. Attributes and Experience Required: - It's essential you have advanced level SQL skills (more than 3 years experience). - Experienced in both basic and intermediate tasks, while also capable of tackling advanced tasks. - Database design and optimization expertise. - Proven track record in managing data migration. In your application, illustrate on your vast SQL experience. Share previous projects you've worked on. Proven expertise will be a determining factor for this job's selection.
I need to move my WordPress site, which is 8GB in size due to images and database, from one cPanel to another server. Key requirements: - The migration should be seamless and preserve all data, content, and functionality. - The site should be fully operational on the new server post-migration. Ideal Skills: - Expertise in WordPress site migration. - Proficiency in handling large-size migrations. - Strong understanding of cPanel and server configurations. Please provide prior experience with similar projects.
I'm in need of an experienced application developer who can build a robust database application. The application will need to provide th...application must include a secure log-in mechanism for users, and feature robust access control settings to manage their privileges within the application. As for the type of data this database application will manage, this remains to be finalized. However, skills in handling different types of data - textual, numeric and multimedia - will be considered an advantage. Understanding of standard SQL language, knowledge with various database systems and strong problem-solving skills will be ideal for this project. Strong knowledge of frontend and backend development with user interface design skills will also greatly contribute to our collabo...
I'm seeking an experienced system administrator to configure a Linux webserver that integrates Hestia Control Panel (CP). Key Deliverables: - Enable web hosting functionality for between 1 to 5 websites. - Configure email management services - specifically, the ability to setup email accounts and implement a solid spam filtering system. Ideally, the freelancers bidding on this project should have prior experience setting up and managing Linux servers and using HestiaCP. Knowledge of website and email database management, spam filtering techniques is a plus. Deliver reliable, secure, and high-performing results.
...feature into my Crystal Report PDFs within my web application. This will serve the purpose of authenticating the reports. The signed reports should be saved into a SQL Server database. Key Requirements: - Implement a digital signature feature on Crystal Report PDF files. The purpose of this is to ensure the authenticity of the reports. - The digital signing process should be automated after an approval process. - Save the signed reports into a SQL Server database. Ideal Skills and Experience: - Proficiency with ASP.NET Web Forms and C# is a must. - Experience working with Crystal Reports would be a plus. - Familiarity with SQL Server database management. - Understanding of digital signature implementation and security in web applications. I&...
Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.
I want to configure out attendance system with ZKteco Bio ADMS communicate with server 1) Send realtime attendance data from device to remove cloud server through PHP 2) Add user from server to device 3) delete user from server to device 4) finger store in DB and send to device when needed 5) Clear admin from device through api when needed Apply if you already work on such thing.
I need an in-depth analysis of Woonsocket's justice system and the Department of Children, Youth, and Families (DCYF). Specifically, it should cover: - Law enforcement practices - Court procedures - Child protective services - The observance or violation of the Supreme Court Rules of Criminal procedure - Any cases that reveal policing based on personal bias, perception, and beliefs rather than law - Instances where the power and trust Rhode Island placed in these systems have been abused without consequence. Freelancers indicating interest should demonstrate: - An understanding of the depth and breadth this project demands - Ability to proficiently navigate the legal and justice system landscapes The ideal freelancer would have a background in legal studies, journalism, or ...
Currently using .Net Framework 4.5 and looking to upgrade project. The main goal for this upgrade is to ensure compatibility with modern systems. I don't require any specific performance improvements, just upgrading the framework is the main focus. The code base is for a Web API that integrates with SQL Server. There is a separate UI front end that is not included. The current version is .Net Framework 4.5 with the following target techical Stack • ASP.NET Core 8.0 (with .NET 8.0) • ASP.NET WebApi Core • ASP.NET Identity Core • Entity Framework Core • FluentValidation • Swagger UI • GIT Key requirements: - Expertise in C# - Strong understanding of .Net architecture - Previous experience in upgrading .Net projects to ensure compatibili...
I'm in need of a proficient professional who can set up, configure, and manage a Windows-based virtualization server. The primary goal for this server is to host more than 10 virtual servers dedicated to running web applications. Key Responsibilities: - Configure and deploy a Windows-based virtualization server - Set up and manage over 10 virtual servers - Ensure all virtual servers are optimized for hosting web applications - Implement best practices for security and performance Ideal Candidate: - Proficiency in Windows Server OS - Experience with virtualization technologies (Hyper-V, VMware, etc.) - Background in managing and configuring virtual servers - Strong understanding of web hosting practices - Familiarity with security measures for virtual envi...
...of experience do u have? 2. Are you an independent freelancer? 3 do you know how to fix sql injections? - Give 2 example of how to fix sql injections in forms 4. what are the ways you can secure a payment api to protect it from spamming charges- considering that the api information is secured and spamming is not happening by any registered users but through external users 5. what are the ways you can protect smtp apis to protect from email spamming?- considering that the api information is secured and spamming is not happening by any registered users but through external users 6. What are the ways you can show thousands of data on a page? how will you implement it so that it doesn't have load on server and page doesn't hang? 7. Have you worked on any m...
I'm seeking an AWS expert to help me with configuring and optimizing my AWS server. Key Responsibilities: - Evaluate my existing AWS setup and recommend improvements for performance, security, and cost-effectiveness - Assist in configuring EC2 instances, S3 storage, and RDS databases as needed - Ensure the server is scalable, reliable, and can handle future growth Ideal Skills and Experience: - Proven experience with AWS services, particularly EC2, S3, and RDS - Deep understanding of server optimization, security, and scalability - Excellent troubleshooting skills and an ability to work proactively to prevent issues - Familiarity with best practices for cost-effective AWS usage - Strong communication skills and the ability to explain complex technical concepts ...
I'm seeking a knowledgeable writer to update an under 500-word article on Visuals SQL. Key tasks include adapting the article to a manufacturing context and replacing outdated information with the latest industry trends. The desired freelancer would have experience in technical writing, specifically within the manufacturing industry, with an in-depth understanding of Visuals SQL.
...Daily Sales Report: Display daily sales data with graphical representation. o Monthly Sales Report: Display monthly sales data with graphs. o Annual Sales Report: Display yearly sales data with graphical representation. o Data Source: Multiple MS SQL databases. 2. Collection Reports o Daily Receipt Report: Display daily receipt data with graphs. o Monthly Receipt Report: Display monthly receipt data with graphs. o Annual Receipt Report: Display annual receipt data with graphical representation. o Data Source: Multiple MS SQL databases. 3. Inventory Management o Full Inventory List: Display a comprehensive list of inventory items. o Export Functionality: Export inventory data to PDF or Excel files. 4. Customer Data Analysis o Outstanding Amount...
I'm in need of a professional Linux server expert to assist with my CentOS-based web hosting server. Requirements: - Expertise in CentOS: In-depth knowledge and experience working with CentOS as the primary operating system of the server is crucial. - Web Hosting Knowledge: Understanding of web hosting principles such as server configuration, performance optimization, and troubleshooting is highly desired. - Security Audits: The task will also include conducting a comprehensive security audit on the server to ensure it is adequately protected against potential threats. - Performance Optimization: Assistance with identifying and improving performance bottlenecks will be required. Ideal skills and experience for this job include: - Strong Linux ...
...and customize WordPress themes - Ensure all code is high quality and maintainable - Troubleshoot and debug complex technical issues - Collaborate with other teams to create successful project outcomes - Maintain a high level of awareness of industry trends and technologies Ideal Skills and Experience: - Proven work experience as a WordPress Developer - Proficient in PHP, JavaScript, HTML, CSS and SQL - Excellent knowledge of WordPress, plugins and themes - Experience with RESTful APIs - Strong problem-solving skills - Good understanding of website architecture and aesthetics - Ability to manage priorities and work in a fast-paced environment - Excellent communication skills This is a long-term project, so I'm looking for someone who is dedicated and can work well also in a...
