Stored procedure sql server punët
Pershendetje Glen. Jam e interesuar per ndihmen tuaj ne SQL. Do te me duhet ndihma jote ne nje provim neser. A mundeni te me ndihmoni me nje shume prej 10 euro per 1 or e gjysem?
Office 365, Wordpress server admin, closed server admin
Programing in Dot Net & SQL Server. Visual Studio 2010, SQL Server 2012 Express ose më të avancuar. Modify existing modules, add modules, design interface, Reports...etc
...can be easily integrated into other websites as a microservice. Additionally, the application will support payment methods for premium features. Requirements: Website / Document Scanning Functionality: * Users should be able to input any website URL or document into the application. * The application should scan the website and extract relevant data for processing. * Extracted data should be stored in a database for future reference. AI Model Integration: * The application should integrate with an AI model capable of answering questions based on the scanned website data. * Preferably, use a free or cost-effective AI API for this purpose. * The AI model should provide accurate responses to user queries based on the scanned website data. Chatbot Integration: * Develop a chatbot...
Básicamente quiero que me ayuden a crear la base de datos para un gimnasio en SQL server
I require an expert proficient in Python, SQL, and Java to work on a Codility assessment. The assessment will be conducted at an intermediate level and will be inclusive of various tasks that I will be solving in the language of the question. Key Requirements: - Comprehensive Knowledge in Python, SQL, and Java - Proficiency in tackling Codility assessments - Understanding of the assessment's specific concepts and frameworks Remember to adhere to Codility's test format and code-writing guidelines. Your completion and success of this project will greatly depend on your ability to grasp and execute these particularities.
We are looking for a better solution than ordering shared hosting accounts for each domain. We have many woo-commerce webstores that all run off different domains on different servers. We want to move all websites to the same server, and still have them run at optimal speeds. We need someone to make proper suggestion (such as a dedi server) and have the ability to set it up, migrate websites, configure domains, etc. Please be sure to add WCMGRT1 to your bid or it will be considered spam, ignored and removed.
I need assistance to solve three coding tasks using Python, Java, and SQL. The challenge involves - Analytical problem-solving - Implementing quality checks - Code compilation The challenges require proficient skills in the aforementioned languages, while also ensuring code efficiency. Prior experience in problem-solving and understanding how to efficiently check and maintain the quality of code is a big plus.
I'm looking to create a simulate for Password Manager Web Application. The application needs to provide key features: - Strong password generation: the app must be able to generate robust passwords - Secure password storage and management: all passwords created or input into the app should be stored securely. Users should also be able to easily manage these passwords. - login - signup - another page to make GET request will provide For user authentication and access, the application should be designed to allow logging in using a username and password method. should have experience in web application development, basic encryption and security features. Knowledge in user-interface design.
Skills -core php, laravel, Codeigniter my sql database Min 1 to 5 year experience location - Mohali,Punjab, India
AWS to New cloud server migration-Django & Reactjs Server setup Code migration and setup SSL certificate - 1-year plan 50 /year
...traditional currencies, which are controlled and regulated by central authorities, Bitcoin is governed by a network of nodes that collectively validate and record transactions on a public ledger known as the blockchain. The Mechanics of Bitcoin At its core, Bitcoin is a digital asset that can be exchanged and transferred electronically. Each Bitcoin is represented by a unique cryptographic code stored on the blockchain, which ensures the integrity and security of the network. Transactions are verified through a process called mining, where miners compete to solve complex mathematical puzzles in order to add new blocks to the blockchain and receive rewards in the form of newly created Bitcoins. The Advantages of Bitcoin Bitcoin offers several advantages over traditional forms of...
Hello our company has built an online open banking payment gateway. I need people that have Lloyds, HSBC, NatWest, Barclays, Standard bank accounts. I will create a link for you with 12GBP value , i would like you to record a video of the full procedure while you are paying it and what difficulties and describe what difficulties did you face. You will get paid 25GBP for your work , (12 of your payment + 13 for your 3 precius minutes)
...traditional currencies, which are controlled and regulated by central authorities, Bitcoin is governed by a network of nodes that collectively validate and record transactions on a public ledger known as the blockchain. The Mechanics of Bitcoin At its core, Bitcoin is a digital asset that can be exchanged and transferred electronically. Each Bitcoin is represented by a unique cryptographic code stored on the blockchain, which ensures the integrity and security of the network. Transactions are verified through a process called mining, where miners compete to solve complex mathematical puzzles in order to add new blocks to the blockchain and receive rewards in the form of newly created Bitcoins. The Advantages of Bitcoin Bitcoin offers several advantages over traditional forms of...
I'm looking for someone who has very good experience in Laravel's real world situation. What Queue drivers are available in Laravel? Will ignore any ...Queue drivers are available in Laravel? Will ignore any replies without answering to the above my question. Here is my problem now. We are using Laravel project and it's running on production. It's using Queue heavily and queue driver is database now. We are getting following issue. SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction (Connection: mysql, SQL: select * from `jobs` where `id` = 111111 limit 1 for update) Let me know how to fix this then I will hire you immediately and you can be employed in our project. Please don't waste my time if you don't know...
I'm in need of assistance with Codility assessments, specifically focusing on intermediate-level problem-solving tasks. Your work should encompass: - Expertise in SQL or Python. Familiarity with both languages is advantageous. - Proficiency in algorithmic programming, capable of thinking strategically to solve intermediate-level problems. - Ability to assist in solving three different task types in Codility, including: 1. Time complexity problems 2. Sorting and searching problems 3. Counting elements problems Ideal candidates would have experience preparing or mentoring for codility assessments and a strong background in programming. Your intricate knowledge of problem-solving within the realms of algorithmic programming would be highly beneficial. A methodical appro...
I urgently need an expert Laravel developer to collaborate on a web application development project. The specific features and ...an expert Laravel developer to collaborate on a web application development project. The specific features and functionalities of the project are yet to be defined, but a vast knowledge in Laravel is key. Key skills and Experience: - Proficiency in Laravel and PHP - Understanding of MVC design patterns - Knowledge of front-end technologies, such as JavaScript, HTML5, and CSS3 - Familiarity with SQL/NoSQL databases - Excellent problem-solving skills The timeline for this project is ASAP, so the ability to work under pressure is required. If you have experience in web applications, APIs, or both, it will be advantageous. Let's collaborate on this ex...
I need a pro that can explain me how server actions work I have already a boilerplate project and a task to put a user in a user group we will work over screen share as a consultant First trial hour price
I need a pro that can explain me how server actions work I have already a boilerplate project and a task to put a user in a user group we will work over screen share as a consultant
I'm currently facing an issue with high CPU usage affecting my server. This has led to a significant slowdown in my website's performance and I am needing an experienced Laravel developer to assist in resolving this. Key responsibilities will include: - Diagnosing the root of the high CPU usage - Implementing improvements to rectify the issue Regarding server load, I've not been able to identify the precise figures. This project does not involve working with any established caching mechanisms as none are currently being used. Essential skills and experience: - Proficiency in Laravel - In-depth understanding of server operations and CPU usage - Proven record of successful server optimizations - Familiarity with CyberPanel and OpenLiteS...
...that if someone tries to read the content outside of the Raspberry Pi, it'll be unreadable. Key Requirements: - Encryption Purpose: The primary use of this encryption is to secure data storage. - Data Access Method: The encrypted data should be accessible automatically on boot, without requiring additional steps like entering a password or using a physical key. - Data Sensitivity: The data to be stored on the SD card is highly sensitive, hence the need for robust encryption. The perfect candidate for this project should be highly skilled and experienced in: - Raspberry Pi projects - Data encryption techniques - Software and hardware integration - Linux and related operating systems Applicants for this project should also have a strong background in securing sensitive dat...
I need a simple form that will look good on a small screen iPhone and also a big screen iPad. The form will collect NAME EMAIL CITY PHONE NUMBER phone number will be a formatted 10 digit max, and email will need validation for properly formatted. This will take the data and post it to our existing base and ...then auto redirect to the form page. The form page will look neat and clean and also contain a couple lines of text and our logo. You will use the existing config file to connect to our base, instead of creating a new one. This project needs completed today and should only take an hour to complete. This is to be written in php 8.2 and connected to sql dbase. You will be paid $30 when it is complete and verified to be working on our server. Ping me if you can co...
...take part in my ongoing web development projects. The main goal of the project is to enhance an existing application. Requirements: - Proficiency in .NET for backend development - Strong experience with Angular for frontend development - Excellent understanding of SQL Server and MongoDB databases - Previous work with DevExpress is essential Your responsibilities will include: - Developing APIs using .NET for enhancing the application - Integrating Angular for improving the frontend - Ensuring seamless operation with SQL Server and potentially MongoDB Ideal candidates should have a strong understanding of web development and be able to contribute effectively to enhancing the current state of the application. The ability to work with a team, meet deadline...
...during the initial login attempt in Odoo (only the first time). Upon successful validation, update the user's password in Odoo using the standard Odoo password hashing method. Ensure compatibility and seamless integration between Magento 1.9 and Odoo 16 CE. Provide documentation and support for the developed module. Note well: Magento customers are already loaded into Odoo. Magento passwords can be stored in an encrypted format in a new field in Odoo for the initial login check and subsequently deleted for security reasons. We aim to grant portal access to Magento customers without requiring them to receive invitation emails to create a user account. The ideal candidate for this project should possess: Expertise in Magento 1.9 and Odoo 16 CE, with a strong understanding o...
I need a pro that can explain me how server actions work I have already a boilerplate project and a task to put a user in a user group we will work over screen share as a consultant
Hi, Job Title: Senior Developer - SQL Server Analysis Services Experience : 5+ Mandatory Skillset:Seeking a skilled SSAS Developer to contribute to our team's success. Responsibilities include designing, developing, and maintaining SQL Server Analysis Services solutions for business intelligence and data analytics requirements. Tasks involve creating data models and developing multidimensional cubes. Key skills required: expertise in MS SQL Server Analysis Services (SSAS) Tabular and Multidimensional. Proficiency in TSQL for writing performant queries is essential. Experience with data visualization and reporting tools is highly valued. Additional knowledge of Excel and .Net development is advantageous. Strong problem-solving abilities, exce...
I need an expert to help with advanced troubleshooting and optimization for my Oracle database. The ideal candidate should have: - Proven experience in database administration. - Proficiency in Oracle database. - Expertise in database troubleshooting and performance optimization. - Adept in using SQL Developer for managing database tasks. You'll be handling tasks such as: - Identifying and resolving performance issues. - Suggesting and implementing optimizations. - Monitoring database activities to ensure smooth operations. Your role will be crucial in ensuring the efficiency and security of our Oracle database.
...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 am in need of a specialist capable of customizing a...pre-developed Pixasocial project from Evento for me. Key Tasks Involve: - Changing theme colors to align with my branding - Setting up the project on my preferred Linux VPS server - Implementing necessary third-party integrations (specifics will be discussed later on) Ideal skills needed for this project include: - Familiarity with Pixasocial - Experience in system server setup (specifically, Linux servers) my devops will help on this - Knowledge of third-party integration Please include relevant experiences in your proposal. Your expertise in these areas will be a deciding factor in my selection. Thanks!
...developer to create a simple and efficient Car Maintenance Tracker app designed for auto repair shops. The app's primary function is to streamline customer and vehicle management by utilizing RFID technology. Core Features: RFID Integration: The app will utilize an RFID reader connected to the Android tablet to scan customer vehicle tags. Scanning a tag will display the vehicle's service history and stored information. Vehicle & Customer Data Management: For new customers, the app will allow users to create profiles by entering: Customer Name Contact Information (Phone, Address) Vehicle Details (Type, Engine Type, Oil Type, Filter Types, Battery Size, etc.) Additional Notes Existing customer data can be easily accessed and updated upon subsequent visits. Service His...
we are looking for a senior experienced PHP developer with a minimum of 15 years of experience Skills and Experience MUST HAVE: - 15+ years of core PHP development experience. - Proficient in Laravel framework. - highly knowledgeable in php programming and experience SQL Injection prevention/fixing - Finding and Securing any loop holes in the system - **must be an independent developer, not an agency! - must be able to work on github - lastly making sure platform is mobile responsive Must have experience in social media or multi-user platform, chat system, ecommerce platform *******We will only hire independent freelancer. If you are an agency, if you are a marketing person or project manager and will delegate the work to someone else, meaning, will subcontract the job to someon...
...exploit vulnerabilities in our user login process. - Authorization Controls Testing: We need thorough testing on the authorization controls in place to ensure that only authorized users can access specific resources. - Input Validation Testing: We need someone who can identify any weaknesses in the input validation of our website. This is crucial in preventing common security vulnerabilities like SQL injection and cross-site scripting. Ideal Skills: - Proven experience in ethical hacking and website security testing. - Strong expertise in PHP and web application security - Familiarity with OWASP Top 10 standards - Excellent understanding of user authentication, authorization controls, and input validation - Good communication skills to report and explain findings clearly If yo...
As an online learning provider, I offer a broad range of technical courses. I'm seeking an experienced sales person with an understanding of technical courses to drive the business forward. Key courses: - Web development - Data science - Embedded systems - Cyber security - Digital marketing - Auto CAD - Adobe Photoshop - Robotics - SQL - AWS - Data structures and algorithms Ideal candidate should possess: - Proven sales experience in the e-learning or tech industry
I need assistance in setting up a Tekla Multiuser Server to enable effective work from home. My internet access at home is stable and reliable. I operate on Tekla Structures 2023 and plan to use a virtual private network (VPN) for connectivity. Key skills and expertise required: - Knowledge of setting up Tekla Multiuser server - Familiarity with Tekla Structures 2023 version - Working expertise in setting up VPN connections With the right knowledge and skills, the task should be straightforward and convenient to accomplish. Please bid accordingly.
I need an experienced developer to extend my existing PHP SQL driven platform. This project revolves around adding innovative features to the current structure. . Your job will include: - Analyzing the current structure and proposing alterations to accommodate the new functionalities robustly. - Implementing these suggestions after my approval with special emphasis on maintaining the overall performance & responsiveness of my website. To be an ideal fit for this project, you should: - Have previously worked on expanding PHP SQL based platforms. - Be capable of producing detailed project proposals. Apply with your most detailed project proposal, including your understanding of this task, estimated timeline, milestones, and why you think you're suitable for this...
I consider my self a linux user with more than 10 years of experince. I have having some issues with a linux server running mysql. From time to time it stops responding. I am unable to find the root cause. Therefor i need a linux guru to connect to my anydesk/teamviewer and debug with me till we find the error and fix it. We have various logs in the system so it will be helpful to debug
I am looking for a developer with a focus on backend operations and experience with C#, MSSQL, and WordPress eCommerce integrations. The primary task is deduct stock in azure ms sql stock table when order placed in wordpress e commerce create comand for performa invoice when order placed in e commerce Key Skills Required: - Strong experience with MSSQL and WordPress - Expertise in inventory management system integrations - Understands the intricacies of WordPress eCommerce platforms budget $70
... • Upon form submission, data should be stored securely in a database. • Automatically generate and send a registration number to the participant’s WhatsApp and email. 4. Design and Aesthetics: • The landing page should have a visually appealing dark theme. • It should feature badminton-related graphics and elements that are attractive and relevant to the event. 5. Performance: • The page must load quickly and perform well on all devices, especially mobiles. • Ensure compatibility across all major browsers and devices. Additional Specifications: • The landing page should include SEO-friendly content to aid in discoverability. • Use of modern web technologies such as HTML5, CSS3, JavaScript, and PHP is preferred. • Ex...
I am seeking a database expert who can successfully migrate mixed structured and unstructured product data from Oracle to SQL. This project requires a comprehensive understanding of database architecture, data migration best practices, and extensive knowledge of Oracle and SQL. Key Tasks: - Analyze and understand the structure of existing Oracle database - Prepare a thorough plan for data migration ensuring minimal downtime - Coherently migrate mixed structured and unstructured product data to SQL Ideal Skills and Experience: - Previous experience with Oracle to SQL data migration - Understanding of both structured and unstructured data - Deep knowledge of database architecture and design - Ability to troubleshoot any issues that arise during migration - Exc...
...Collaborate with us to design and develop the platform . Write clean, efficient, and maintainable code. Test and debug software to ensure functionality and performance. Work on constructive feedback. Stay up-to-date with emerging technologies and best practices. Requirements: Proficient in Java, J2EE, Spring MVC, Spring Core, Spring boot and JavaScript. Excellent knowledge of Relational Databases, SQL and ORM technologies (JPA, Hibernate) 5+ years of hands-on experience in designing, developing, testing and maintaining RESTful APIs and Microservices 4+ years of experience in API layer security (e.g., JWT, OATH2), API logging, API testing, creating REST API documentation using Swagger and YAML or similar tools Work on multi-threading and optimize performance for complex systems. ...
I require a professional to write a script I can run to install DUO with a main purpose as a server setup for Redhat 9.3 . The server will run the DUO Multi-Factor Authentication application. I specifically need the SSH implementation of DUO Multi-Factor Authentication. I understand there is a file that requires 3 input value from my DUO Admin which could reference a File that I add those inputs or pulls from a file? This needs to be for system wide and SSH - Also no Public Key Auth. The ideal freelancer for this project should be proficient in server setup, Redhat, and DUO Multi-Factor Authentication. Experience with SSH implementation is a must. I'm looking for someone who can provide a fast and efficient setup, as well as a walkthrough of the installatio...
I'm looking for ...operations (Create, Read, Update, Delete) features within the application. - Ensuring the application is optimized for efficient data handling and processing. Security Requirement: - The application must be able to securely access the database using username/password authentication. Ideal Candidate: - Proficient in Java and Springboot framework development. - Experienced with Oracle database SQL and JDBC connectivity. - Prior experience in implementing secure database connections. - Familiarity with various CRUD operations and database optimization techniques. If you have a solid background in these areas and are confident in your ability to deliver a robust, secure, and efficient Springboot application that connects to an Oracle 19c database, I'd lo...
I'm currently seeking an Oracle SQL developer with exceptional proficiency in creating logics. This task requires: - Writing an SQL code for data extraction purposes. - The code needs to be written as quickly as possible, with a time frame of 1-2 hours. - The solution should deal with the joining of multiple tables and creating doing some further order by, group by codes Decent knowledge of Oracle and experience in handling similar tasks would be ideal for success in this project. Your ability to deliver accurately and timely will be greatly valued. The code should be written using simple statements. I am not sure how to set up a connection to our datapool though. I can show couple of other related codes that can help
...additional information into work orders. A direct connection to our SQL server is essential. The app should have the following key features: - Access and view work orders: Our employees should be able to easily browse and access the work orders. - Update work orders: A functionality to update the status of work orders is pivotal. - Add additional information: The app must also enable employees to input further necessary information into the work orders. Minimum qualifications include: - Proficient in app development. - Familiarity with SQL for direct server connection. - Prior experience building work order or similar task management apps. Ideal candidate has worked on projects requiring direct connection to SQL server for real-time da...
I am looking for a developer with a focus on backend operations and experience with C#, MSSQL, and WordPress eCommerce integrations. The primary task is deduct stock in azure ms sql stock table when order placed in e commerce create comand for performa invoice when order placed in e commerce Key Skills Required: - Strong experience with MSSQL and WordPress - Expertise in inventory management system integrations - Understands the intricacies of WordPress eCommerce platforms budget $70
I'm looking for an experienced PostgreSQL professional capable of analyzing and generating reports from sales data. Key Responsibilities: -Analyzing sales data stored in PostgreSQL -Generating insightful reports based on analysis Ideal candidate should excel in PostgreSQL and possess strong data analysis skills. Previous experience with sales data is an advantage, however, specific functionalities required for the analysis have been left open-ended for your expertise to fill. Please outline in your proposal any relevant experience and your approach to this task.
...assist me with a combination of SQL and Python tasks. - SQL: I need help with SQL in three specific areas: 1. **SQL Syntax:** Assistance with basic SQL commands, especially in working with subqueries. 2. **SQL Queries Optimization:** You should be able to optimize SQL queries for data retrieval accuracy. Your goal should be to ensure that the data collected is as accurate as possible. 3. **SQL Database Design:** You should be able to assist with database design, ensuring proper schema design and normalization. - Python: While the primary focus is SQL, some tasks may require basic Python knowledge. If you are proficient in both SQL and Python, even better. **Ideal Skills:** - Strong understanding of SQL...
As a determined researcher, I am seeking an analytical mind to thoroughly dissect and report on various features of a specific trading platform. I am ...understanding of the processes, timings, and methods involved in both depositing and withdrawing funds from this platform. The ideal candidate will have: - Immense familiarity with online trading platforms - Mastery in financial analytics - Excellent researching ability - Knowledge about regulatory environments, and their impact on transaction processes Key research areas: - Detailed procedure for depositing and withdrawing funds - Varied modes of payments accepted by the platform - Processing time for both deposits and withdrawals - Any potential fees involved in these transactions I will pay after the projec...
