Sql server batch delete loop 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
I have a Windows 2019 Server acting as a Domain controller to which I have administrator privileges. My PC connects to the Domain and there are 3 users who logon to the PC/Domain. They are Michael, John and Peter. I want to set a default username for the PC in the format DomainMichael so that no matter who logged on last, whenever they logout then the logon screen will always show DomainMichael. Ideal skills & experiences: - Proficient with Windows Server 2019 Active Directory and Registry Editing - Experience in creating new user accounts with specific permissions. - Attention to detail to ensure the username is configured correctly. Looking forward to your bids.
I'm currently using a Windows server on-premises. In an effort to optimize my operational costs, I'm looking to migrate my database workloads to Microsoft Azure. Key Requirements: - Migration: The primary objective is to move my database workloads from the on-premises server to Microsoft Azure. This process should be seamless and efficient to avoid any disruption to my operations. - Cost Optimization: The main reason for this migration is to save on costs. The chosen freelancer should be able to demonstrate a clear understanding of cost-saving strategies within Azure. Post-Migration Assistance: - Azure Active Directory Setup: I'll require help in setting up Azure Active Directory to ensure smooth authentication and authorization processes. - Azure Backup and ...
I have a critical Windows Server 2019 running as a database server on-premises, and I am looking for a professional who can efficiently migrate it to Microsoft Azure. Key Requirements: - The current server is Windows Server 2019, so experience with this version is a must. - The server's primary function is as a database server, so experience with database migration and management is crucial. - The uptime of my services is critical and 24/7, so the migration process needs to be planned and executed without causing any significant downtime. Ideal Skills: - Extensive experience with Windows Server 2019 and Microsoft Azure migration. - Proficiency in database management and migration. - Understanding of critical server uptime requirements...
I'm looking for a seasoned AWS Data Engineer with over 8 years of experience to support me in handling data extraction and transformation tasks. Key Responsibilities: - Data Extraction: The engineer will be responsible for extracting structured data held in SQL databases. - Data Transformation: You will be required to transform the extracted data into a usable format for our analytics and reporting. Skills and Experience: - 8+ years of experience as an AWS Data Engineer. - Proficient in working with structured data, in particular, SQL databases. - Extensive experience in data transformation. - Expertise in AWS services, especially Amazon S3 and Glue. Your support will be essential in ensuring the smooth flow of our data processes. Please provide examples of your past ...
I'm looking for a C# developer to build an application for me. You need to make C# application (app/web/console whatever is best for you). Basically, it is POST, GET, PUT, DELETE requests against API. Problem is that there is limited documentation, so you must conclude based on swagger documentation how to implement each of functions. Swagger link will be provided. Please, apply for this job if you can do it TODAY.
server irraggiungibile per tutti i siti web. errore: Service Unavailable
I have a batch of handwritten notes that I need to be converted into digital text. Key Requirements: - The project is primarily data entry. You will be given physical copies of these notes, and your task will be to accurately transcribe them. - Attention to detail is crucial, as the notes may be difficult to read and require care to ensure that the content is correctly interpreted and entered. - This is a time-sensitive project, so meeting the deadline is essential. Ideal Skills: - Proficient in typing and data entry, ideally with experience in transcribing handwritten notes. - Attention to detail is paramount. - Time management and ability to meet deadlines.
I'm looking for an experienced NodeJS and JavaScript programmer to help me with a school project focused on exploring cybersecurity concepts. Key Requirements: - The task involves writing a client request to obtain a flag from a vulnerability site with advanced complexity (e.g., bypassing security measures). - The project involves emphasizing on Remote Code Execution (RCE) and pollution while interacting with the vulnerability site, so experience in these areas is a plus. --- Challenge Name: Emu Apothecary Category: Vulnerabilities Description has just opened up their potion brewing website for other Emus to create new potion recipes! However, they are afraid that one of the human hackers will pollute their ingredients. Can you get Remote Code Execution (RCE) on the Emu Apoth...
I am Building AWX Server on AWS EC2 Here is the method I am using: So far, I have: I have already Created an EC2 instance for this server. Cloned the AWX Repo, I have completed all installations required (installed Docker, Docker-Compose, I have used pipx to install the Ansible package) I need help with the rest of the instructions from that link. I am building this server in VS Code Ideal skills for the job include strong understanding of AWS, proficiency in AWX tasks and familiarity with Ubuntu server.
I need a React developer to build a frontend for a Student Management System. Key Project Details: - Two Types of Users: The system will have both admin and normal user functionalities. - Entities: The project involves five main entities: students, admin, class, exam, hall, and scheduling. - CRUD Operations: The system should allow for Create, Read, Update, and Delete operations for the mentioned entities. Admin User Features: - Access Control: The admin user should have the ability to control user access and manage permissions. - Reports Generation: The system should be able to generate exam scheduling reports. I will provide you with the Swaggy API list for this project. The deadline for this project is Saturday night. Ideal skills and experience: - Proficiency in React - ...
I have a large batch of text data in PDF files that needs to be copied and pasted into a specific format. Key Requirements: - Transfer text data from various PDF files - Ensure accuracy and precision in the copying - The time-sensitive nature of the task - The data must be transferred into a format that is easy to work with Ideal Candidate: - Proficient in using PDF files - Strong attention to detail - Previous experience with data entry/copy-paste tasks - Ability to work under time constraints
I need a Python script that can batch process text overlay onto images (jpg/png). All the images and all the text will be unique. Each set of text(s) (1-2 sentences) will have its own unique image. (one-to-one) I would like to have a CSV file containing all the unique sets of text. The script would reference a folder of images. The script needs to be able to handle 20-200 images. I would like to be able to change the font style, size, the position on the image, and to have the text be able to wrap to the next row on the image.
I'm experiencing an issue where my website isn't loading. Thi...where my website isn't loading. This problem has emerged recently, without me making any recent changes to the website or server configurations. I need a skilled professional to help me quickly troubleshoot this issue and get my website back online. Your role will involve: - Investigating and identifying the root cause of the website's failure to load - Resolving the issue effectively and efficiently - Ensuring the website operates smoothly post-fix Ideal candidates should have extensive experience in troubleshooting websites that run on Apache servers. Strong familiarity with PHP-FPM and Webmin will be a significant advantage. Your ability to identify and remedy server issues swiftly will ...
...database wkth the data we have in excel file (about 350 lines) To access the page we need a login page. We need 2 levels: 1 level: administrator 2nd level: agents One administrator is sufficient More agentes are necessary. ADMINISTRATOR PAGE: The administrator can add, edit or remove an agent. Just Name, Surname, phone, email, username, password The administrator can see the list of products, delete one, add another line, edit one line. AGENT PAGE: If the agent logins he can see a list of all the products with quantity bigger than 2. On each raw we want to put a simple dropdown menu where the agent can chose the quantity to order. The default value will be 0 quantity. The maximum quantity must be the quantity in stock -2 We would like to see the total amount of the order...
...users enter multiple data for each voter) Must be able to force stop entering data to all users online Must be able to upload the database (from local Microsoft Access) to web and re-enable the ability for entering data to users (online) When uploading database to web from Local MS Access, have to options. Update (update only changes. Overwrite records in web database), or Replace database on web (delete database on web and reupload from Access). Administrator must be able to import from Excel files into MS Access database (voters). When importing from excel to MS Access database (locally) then ms access database must be updated with the following rules: 1. When a record doesn’t exist in Access, but exist in Excel, create it 2. When a record exist in Excel and Access (based...
I'm seeking a Minecraft expert to help me set up a survival mode Minecraft server. Key Project Details: - **Survival Mode Setup**: The primary focus of this project is to create a distinctive survival mode suitable for a smaller player base. - **Unique Items**: I will need engaging, custom, and unique items for players to discover and utilize in the game. - **Crate Rankups Integration**: I also want to include a crate rankups system to add a layer of progression and reward for players. Ideal Skills and Experience: - **Minecraft Server Administration**: Experience in setting up and maintaining Minecraft servers is a must. - **Plugin Development**: Proficiency in developing Minecraft plugins is highly desired, specifically for creating custom items and integrati...
Ju lutemi Regjistrohuni ose Identifikohuni për të parë të dhënat.
...compromised Gmail account. - Bypass Google's second verification: My Gmail account is currently secure with two-step SMS verification. However, the difficulty is that I don't possess access to the phone where the verification code is sent via SMS. Thus, I need assistance in circumventing this verification to recover my Gmail account. - Remote data wipe: Since my phone has been stolen, I wish to delete all data stored on it remotely. I'm looking for a professional with understanding in Google’s verification systems and proficient knowledge in remotely wiping data from an Android device. Privacy and accuracy are paramount in this task along with a swift completion. Your previous experience in cyber security would be appreciated in ensuring a smooth recovery a...
We are in the middle of migrating Django to a new server. - Both servers run Ubuntu 20.04, postgres 12, python2.7 - The Django Project is already transferred over - Nginx has been configured - Postgresql has been setup Our struggle is to get the actual application up and running again. Your job will be to: - help to perform a clean export of the postgres database on old server - help to import the postgres database on the new server - ensure the Django application is coming back up smoothly The work will be done using shared tmate ssh sessions.
...issue with my IIS 8 server. Specifically, I'm unable to reflect image updates across the server. Key Requirements: - Troubleshoot IIS : You should be experienced with IIS and capable of identifying and resolving server-related issues. - Server Configuration: The problem may be related to server settings, so a deep understanding of IIS configuration and management is desirable. - File Management: The issue seems to be related to file update. You should have expertise in managing files on Windows servers and diagnosing related issues. - Image Handling: The problem specifically pertains to image updating. You should be well-versed in how servers handle image uploads and updates. Your task will involve: 1. Diagnosing the issue: Understand why new ...
I came across a minor issue on my website on Digital ocean cloud server. Refer the below error information. I need someone who can fix me immediately in an hour. Error 500 PleskExceptionDatabase DB query failed: SQLSTATE[HY000] [2002] Connection refused
I'm in need of a skilled Python developer to assist in creating a client-server application. This application will be responsible for handling data transfer and supporting information about bus and train routes. Key Requirements: - Expertise in Python and Socket Programming - Experience in creating client-server applications - Ability to work with and manipulate data Your responsibilities will mainly revolve around setting up a robust client-server architecture to support bus and train route data. I already possess the data, so the primary task will be focused on the actual programming and integration of the application. Experience in working with transport data or similar datasets would be advantageous. I'm looking for a professional who can deliver a hi...
A business-centric, data-oriented, and analytical mindset. Comprehensive knowledge of data science concepts and disciplines. Knowledge of enterprise information management processes and methodologies. Skills in database design, data security, and data lifecycle ...considerations. . Combinations of experience and education will be considered on a case-by-case basis. Experience in data warehousing and governance. Practical experience in enabling data usability, availability, and efficiency. Experience in data management, quality, metadata management, and modeling. Knowledge of database systems: MS SQL Server, Oracle, or another commercial RDBMS required, Snowflake, or other non-relational database desired. Knowledge of SQL. Experience with scripting languages, especially...
I'm looking for an expert in Microsoft Power Apps to develop a c...gathering and insertion of information into a database. Requirements: - Incorporate text inputs, dropdown menus, and date fields for gathering information. - The preferred database language is Microsoft SQL Server but SharePoint can be used as an alternative. Additional Information: - You don't need to worry about any additional features or functionalities. The main goal is to develop a basic, yet effective form for data collection. Ideal candidates should have experience in: - Microsoft Power Apps development. - Integrating Power Apps with databases, specifically Microsoft SQL Server. You should be comfortable working independently and be able to deliver a high-quality, functio...
I am in need of a seasoned SEO professional who specializes in off-page optimization, particularly link building. The specific focus of this project is to build links on educational or government websites to drive targeted traffic to my si...visitors to my site. You should understand the importance of attracting the right audience to my business. Ideal Skills and Experience: - Previous success with link building on educational and government websites. - Familiarity with SEO tools and strategies that drive targeted traffic. - Proven expertise in gaining high-quality backlinks. - Excellent communication skills: I need to be kept in the loop regarding progress and strategy. If you meet these requirements and have a passion for boosting traffic through ethical means, I'd love to...
...help with the restoration of my server. I have experienced some issues with the server and after thorough review, I believe the best approach would be to restore the server data from a full backup. Key responsibilities: - Diagnose server issue(s): The tasks require the freelancer to identify the root cause of the server malfunction. - Conduct server restoration: The main task at hand is to effectively restore the server from a full backup. The ideal candidate should: - Have extensive experience in server restoration, with a specific focus on full backups. - Demonstrate a high level of proficiency in diagnosing and solving server problems. - Be able to work quickly yet effectively to minimize downtime and data loss. - Have...
I'm in need of a skilled professional to help me set up a high availability cluster for my web servers using Nginx. The primary goal for this cluster is to ensure load balancing, allowing for optimal performance across the servers. The ideal candidate will have experience in server clustering, particularly with Nginx, and will have a deep understanding of load balancing methodologies. You should also be familiar with high availability setups and be able to ensure a seamless failover process in the event of any server failure. The project will require a methodical approach and a strong attention to detail, ensuring that the cluster is set up correctly and is able to function effectively.
...Inclusive Database: The platform should be capable of maintaining a database for recorded guards. Experience in backend database development is vital for this role. 3. User Authentication System: The website should provide a secure username and password login system. There are two different logins: admin and user. : Admin : Can make shift assignments for employees. Admin can also delete, edit and activate or deactivate them User : Can only observe the shift list and observe it through filtering. The perfect candidate for this project would have experience with multiple full-stack projects and a solid understanding of e-commerce functionalities. If you are innovative, detail-oriented with excellent problem-solving skills then you are the ideal candidate for this project. I ...
...experience • VBA sufficient so that you can develop (or source and enhance) • Create a professional app/plugin • Create coding standards including trialling GITHUB integration • Laying out elegant formatting of the sheet • JSON data access library (including CRUD, parse/stream, search etc etc) • “Areas” library to create formated spaces within Excel Sheets (formating, inserting buttons, Create/Delete/InsertRows, elegant location naming systems) • Execute/Recalc tools (e.g. when the sheet is not busy it may ping a URL every 60 seconds) • Please show any experience and work done in the above We are a startup who would like to make a significant contribution to the Excel Application space: • No website yet (until we have som...
I'm seeking a skilled individual to urgently delete misleading information from a Wikipedia account. Who has an active and old wikipedia account. To also do source analysis and vote. Key Tasks: - Identify and remove misleading content: The primary task is to review the existing content on a Wikipedia account and identify any information that is misleading. Once identified, this content must be permanently deleted. - Ensure Compliance: The successful candidate will need to ensure that the content removal process complies with Wikipedia's guidelines and policies. This includes avoiding the removal of any content that may be perceived as neutral and supported by reliable sources. This project is time-sensitive. Immediate action is required to maintain the reputation and re...
I'm in need of a skilled photo editor to work on a batch of 10 raw images initially. If the initial batch is to my satisfaction, I have more photos that will need editing. The photos are of jewellery (earrings, necklaces, bracelets), so the metal and stone colour should be clear. Requirements: - Expertise in working with RAW format (NEF to be precise) - Ability to edit photos in a natural and subtle style - Proficient in cropping and grading images The edited photos will be used for online publication, so it's important that the quality be top-notch. If this goes well, I will have more work for you in the future.
...assist with creating interactive dashboards and generating data visualizations. The selected expert will be expected to work with data from both Excel spreadsheets and SQL databases, so experience with these sources is crucial. I will be looking for an advanced level of expertise, as the job will involve complex data modeling and designing sophisticated, interactive visual reports. A strong understanding of data analysis and visualization techniques is essential. Key responsibilities and qualifications include: - Creating interactive dashboards - Generating data visualizations - Working with data from Excel spreadsheets and SQL databases - Demonstrable advanced level of Power BI experience - Advanced knowledge of data modeling - Proficient in designing sophisticated, in...
I'm in need of an experienced SQL Server data warehouse designer to help with a project of integrating and consolidating data from different sources. Key requirements: - Expertise in SQL Server: You should be able to design, implement and optimize data warehouse solutions on SQL Server. Understanding data warehouse design principles is essential. - Data Integration: You'll need to work with some of our developers / power users to source data and establish automated integration; experience with integrating relational databases and APIs from web services is crucial. - Data Consolidation: You should be able to create a cohesive, consolidated dataset from these different sources applying appropriate design principles. - Medium-sized project...
Primary tasks: Initially this is all to be done on a new Linux STAGING ONLY server. 1) Linux staging server setup -> deploy our existing project to a new VPS using gitlab 2) Woocommerce -> continue long term development work on our existing custom plugin. Transfer the existing production woocommerce to this staging server. 3) ongoing long term development of our CRM app Other components of our stack which are a HUGE ADDED BENEFIT if you can work on them -> .NET ASP, WEB API + MS SQL DETAILS HERE -> PRIORITY IS TO HAVE A DEVELOPER ON OUR TEAM (LONG TERM) THAT CAN FOR NOW ALSO WORK WEEKENDS AS WE HAVE SEVERAL EMERGENCIES TO FINISH URGENTLY. Someone who can efficiently manage Linux VPS and efficiently use GITLAB is critical. Initially we ...
I'm seeking an experienced 3D designer to create a model for a walking training dog harness. This needs to accommodate medium (30-60 lbs) and large (60+ lbs) dogs. Essential features are a front and back-leash attachment. The front leash attachment will be like a choke chain collar attachment (see attached). Fluent expertise in 3D modelling software is paramount. Previous design ...manufacturing designs. Expectations include: - Designing a multi-feature training harness - Ensuring durability for mid-large dogs - Prioritizing comfort and control in design - Incorporating both a front and back leash attachment - Showing the dinosaur skull head in white with black background. - breathable fully adjustable polyester webbing chest with integrated choke collar design with back leash lo...
...gitlab and code in ., .NET ASP, WEB API + MS SQL. We also have woocommerce and have developed and will continue to develop plugins, so PHP and understanding of woocommerce plugins is a plus but not a necessity. Prerequisites: For the long term project the *STARTING* wage will be as stated below. 1) Accept initial hourly rate of U$5.00 2) If awarded, accept and start work IMMEDIATELY 3) Have MINIMUM OF 20+ hours a week for long term ongoing support and development. 4) Work hours: predominantly 20:00 to 02:00 (UTC -3 Brazil TIME) 5) Be available to work on weekends. Our projects use: GITLAB so you need to be proficient and be able to use our existing pipelines and also create your own. Our stack: , ag-grid, C#, .NET API, MS SQL 2017 , WooCommerce digital product s...
...skilled developer to add a small module to my existing app built with PHP. The main functionality of the module will be user registration, excel upload, and assigning packages. Key Requirements: - Develop a user registration system: The module should collect the following user information: Name, Email address, Phone number, password, course, batch. - Implement an excel upload feature: Users should be able to upload excel files select of course and batch - Enable package assignment: The module should allow for the assignment of packages to users. while user registration or excel upload Ideal Skills and Experience: - Proficient in PHP: As the app is built on this platform, a strong expertise in PHP is essential. - Experience in user registration systems: The successful can...
I'm in need of a skilled video editor for my social media and YouTube channels. I have a collection of videos that need t...Indian Hindi video editor expert is needed. And the money will be 20% of the YouTube earnings. Only those who are honest and serious about the work should DM Required - Key Requirements: -Only Indian - Extensive experience in video editing, particularly for social media and YouTube - Creative flair to ensure the videos are engaging and can hold viewer's attention - Prompt turnaround time for a batch of 8-15 minute videos - Experience with Hindi language content is a big plus The ideal freelancer will be able to work with minimal supervision, understand the tone and style I'm aiming for, and deliver a polished and professional final product ...
Hello, We are F12Design, a platform where customers and designers come together and collaborate on graphic design projects. We would like to build an interactive dashboard to make the workflow simple and effective. Here are a few things on our mind: Languages - (Please free to suggest your own) Backend - PHP, jQuery, and SQL Frontend - HTML, CSS, and JavaScript For Real-time Demo/Example - Please sign up for and check their dashboard ########################################################## Social Login/Create account (Separate customer and Designer Login) ########################################################### Customer Dashboard Order Handling -------------- Past Orders Order Requirements (Quiz* and additional comments) Order Updates Order Delivery Date Order Tracking
I'm seeking a talented graphic designer with photo editing skills to work on a batch of 10-50 t-shirts. Key requirements: - Color Correction: Ensure the colors of the t-shirts are vibrant and well-balanced. - Graphic Design: Develop nature-inspired designs that reflect the theme and can be incorporated onto the t-shirts. Ideal skills and experience: - Proficient in graphic design and photo editing software. - Prior experience in t-shirt editing and design. - An eye for color and detail to ensure the final product is visually appealing.
Se requiere un profesional que pueda diseñar un reporte en "SQL Server Report Builder". Este reporte, será modelo factura o pedido. Ya se cuenta con la consulta, y los parámetros de consulta (Fecha, desde - hasta), y también por número de documento (Desde - hasta).
Necesito generar deshboard y gráficos en Power bi desde 4 bases de datos • 1 base de dato en postgresql corporativa en aws • 1 base de datos en sqlserver en un servidor local • Google Analytics • Zendesk Son aproximadamente 50 gráficos personalizados con los que necesitamos hacer algunos dashboard de gestión. Es importante dejar documentado el trabajo y respaldadas las consultas en sql. Indispensable: • Dominio de Power BI • Experiencia previa en la creación de paneles para ejecutivos • Capacidad para integrar datos de bases de datos Indicar los accesos requeridos y los requerimientos tecnológicos para desarrollar el proyecto
...application had User Authorization and Role-based Access Control. This needs to be replicated in the new application. - The following user roles were present in the old system and need to be retained: - Admin - Manager - Regular User - View - Each role had specific actions or permissions: - Admin: Full access (Create, Read, Update, Delete) - Manager: Full access (Create, Read, Update, Delete) - Regular User: Full access (Create, Read, Update, Delete) - View: View Only access Ideal Skills: - Strong experience with Spring Security. - Proficiency in Struts framework. - Understanding of Role-based Access Control. - Ability to efficiently configure permissions based on user roles. Looking for a freelancer who can set up the Spring Security module in my ...
I am in need of a skilled software engineer to develop a DICOM printer server software. This software should: - Be compatible with Windows operating system. - Have the capability to print to HP, Canon, and Epson desktop printers. - Support image printing and multiple printer use. Ideal candidates for this job should have strong experience in software engineering and a solid understanding of DICOM features. Familiarity with printer server software is a must, as is the ability to ensure compatibility with named printer brands and operating systems.
