Add column sql server boolean null defaultfalse jobs

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'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 ...

...wants to sell. The excel file has 5 columns: 1st columns is for Brand 2nd column is for Model 3rd column is for Color 4th column is for Price 5th colums is for Quantity in Stock We want to realize a simple php page with a form to send an email with the chosen products. We need that someone just fill the 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 ...

...but exist in Excel, create it 2. When a record exist in Excel and Access (based on field: EL_NO, UPDATED ALL FIELDS FROM EXCEL AND OVERWRITE ACCESS FIELDS except THOSE FIELDS IN Access starting with FINAL_ and user data entries. 3. In excel files there it is possible to exist duplicate entries (based on field EL_NO). In that case remove duplicated and leave the record which has a value (<>NULL) in column TEL1. If none has, then leave any of those. In Microsoft Access will exist the following tables: 1. Voters (the subscribers – this will be the main database) (ID is autonumber, EL_NO is unique – no duplicates. See access file attached). 2. User (usernames and passwords, for the users to be able to login locally) 3. User_data (the data that each user will...

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 in...

Please Sign Up or Login to see details.

I need a skilled Web Scraping specialist to write code in Python (preferably) that scrapes a specific table from a website for me (Website: ). The table contains WNBA player statistics, The goal is to extract all columns of this table, which is approximately 7 columns and write it to a CSV file (in the same column format). I'm a beginner level coder, and noticed that the table was created with that looks like a Shiny App in R. (I'm not even sure if extracting the table is possible). If it was only possible to use R, then I could potentially work with that. Website: I would like the data to go from the year 2020 to current. Regular Season data. Key Requirements: - Scraping Tables on websites If you're

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 ...

...to search for the "Business Directory" URL on 342 websites. The websites are in the following sheet (I have added business directory URLs for the first four entries, as a sample): You will search for the business directory URL on each website, then enter the URL in the "Business Directory" column of that Google Sheet. (Note: some websites don't use the exact term "business directory". What I'm looking for is the web page on each site that contains the list of businesses in each city, so the business directory could be called something else, for example "business listings".) The task is a one-time search. My budget is $20. This is an excellent project for a new freelancer who is looking

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...

I have two images of vans, I want to add my logo to both vans on the side of each van and put both vans on one image (adjust the brightness so it looks like they are on same location. And then put them both on a background of a British street location.

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...

...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.

...(Solidity/ERC721) to specifics cryptocurrency markets; I think of a good system and its subsequent easy management; a lot of material needs to be reorganized, offered in English, with a sober and professional style, similar on every website, with the option of being available in every language (Wordpress); the basic contents and plan in matrix at the bottom in (first column general info, each others column basic contents on specific websites/patent); ...not need easy migration (traslation) !!! Please: present clearly your offer better; ...how many days do you need ? ...what kind of trace/flow do you think ? *all my easy action, now start from === old asset - new asset; Aruba / Italia ...next to Hostinger / Lituania .

...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 ...

...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...

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

Please collect product information on cars that are equipped with the technology described in the [2. Technology Description] column below. ※Note Please do not collect information based only on the information listed in [1. Background] [3. Reference information] ([1] and [3] are for reference only) 【1　Background】 This technology pertains to a system that utilizes mobile devices in vehicles. Specifically, it combines a smart key system with Ultra-Wideband (UWB) wireless communication to authenticate the mobile device with the vehicle and precisely detect the location of the device. Based on this location, the system determines whether to allow or deny vehicle operations. This aims to enhance security and service quality. However, since UWB communication uses high-frequency bands, co...

Please collect product information on cars that are equipped with the technology described in the [2. Technology Description] column below. ※Note Please do not collect information based only on the information listed in [1. Background] [3. Reference information] ([1] and [3] are for reference only) 【1　Background】 This technology pertains to a vehicle control system designed to enable specific operations on a vehicle. Traditionally, there has been a smart system utilizing electronically authenticated keys through wireless communication with the vehicle. However, a new method using sound authentication with a device worn on the user's ear has been proposed. While this device offers a novel way to authenticate with the vehicle, using standard communication protocols allows authen...

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.

I'm searching for a professional who is proficient in SQL coding specifically for MySQL database design. PowerShell scripting or similar would also be beneficial. This is a basic level project taking existing Local government procedures and converting them into SQL based processes. An example of which would be creating a import procedure for traffic count data that is presented in a text format (example attached) Ideal Skills: - Experienced with MySQL Database Design - Well-versed in SQL coding - Ability to simplify complex instructions - PowerShell for anything not possible in SQL This project will demand creativity and intelligence to design procedures that simplify data entry processes. Please only bid if you can offer solutions according to the...

Hello, I need mapping a CSV that contains many information and put all words in each column

...email inbox in order to geocode the addresses present in the file via the Google Maps API and insert the geographic coordinates into an SQL table. You can follow these steps: 1. Retrieve the xls file from the mailbox - cron every hour 2. Normalize the xls file for integration into a MySQL table 3. Configure access to SQL database from JavaScript. 4. Insert data into table via SQL query 5. Retrieve addresses to be geocoded from the SQL table. 6. Use Google Maps API to geocode each address. 7. Insert the geographical coordinates (latitude and longitude) in the SQL table. Each line in the xls file corresponds to a delivery. The file has 15 columns. The column names are, in order: Shipment, Rush order, Mode of delivery, Drop sequence, PP number...

I'm in need of a SOCKS Proxy server as my ISP has closed port 25, which is essential for email services. Key requirements: - Set up a SOCKS Proxy server: The server's primary function will be to support email services. - Implementation: The server should be configured to support my email client. - Security: Ensure the server is secure and reliable. Ideal skills and experience: - Proficient in setting up SOCKS proxies. - Expertise in configuring services for email clients. - Knowledge of network security standards. The project might involve more tasks depending on the specific needs of the proxy server.

I need assistance with scraping data from a website and delivering it in an Excel file. The specifics of the project are as follows: I am looking for a person who will conduct scraping sessions for our business on a regular basis. Desired skills are knowledge of screen-scraper software, sql, Someone with Python knowledge will be better. Willing to follow instructions. Not cramped up with other jobs or other side hustles. Need to have solid internet connection. Expected work takes 5-10 hours per week, once fully trained. Must be responsible. Able to accept PayPal. - The source of the data is a website. This means the freelancer needs to have experience in web scraping. - The data should be delivered in an Excel file. Proficiency in handling and formatting data into Excel is a mu...

I'm looking for an expert to take the text from my Word document and incorporate it into my Canva slides. The slides are for a presentation, so it's crucial that the information is presented clearly and with a professional touch. Key Tasks: - Transferring text from a Word document to Canva slides - Ensuring all text is appropriately sized, formatted and positioned within each slide - Adapting the text to fit the existing layout and design of the slides - Keeping the information clear and engaging for a presentation audience Ideal Skills and Experience: - Proficiency with Canva - Excellent attention to detail - Prior experience with creating or modifying presentations - Ability to adapt existing layouts to fit new content - Strong communication skills to understand any addition...

Data Specialist: The Data Specialist is responsible for pr...information that is in databases, organizing and assembling the information so that teams can make decisions using data. Responsabilities: > Access database. > Create dashboards and analysis according to the demand of the business areas. > Update and automate dashboards that need frequent updating. > Provide suggestions of improvements in business areas. Requirements: > Mandarim is a must > SQL > Office Package > Database usage At Shein, we believe that diversity is the force that drives innovation. We are committed to creating an environment where all voices are heard, valued and respected. All our vacancies are inclusive for people with disabilities, women, black people, LGBTQIAPN+ com...

Hello, I need a quick fix for my DNS server running on a 2012 R2 system. The major problem encountered is that I'm unable to access my shared files. However, I can ping the IP addresses of the devices hosting these shared files. An RPC Error is shown and some Group Policy issues occur when trying to access these files. • I need someone who understands DNS thoroughly. • Experience with Server 2012 R2 is necessary. • Knowledge of RPC errors and Group Policy is required. Would appreciate quick and effective troubleshooting. Thank you!

I need a skilled professional who's an expert in Azure Data Factory (ADF) development, SQL, Power BI, and ADF monitoring. Key Tasks: - Creating data pipelines - Building data transformation workflows - Integrating with SQL databases Power BI Usage: - Visualizing data through interactive dashboards - Creating data reports and analytics - Real-time monitoring and alerts ADF Monitoring: - Tracking data pipeline performance - Monitoring data integration processes - Setting up alerts and notifications for job failures. Ideal Skills and Experience: - Expertise in Azure Data Factory (ADF) development - Proficiency in SQL, Power BI, and data visualization - Strong background in monitoring ADF performance - Experience setting up real-time alerts and notifications - Pr...

I'm seeking an independent ASP.NET developer based in India with at least 5 years of experience, strong C# programming skills, and familiarity with SQL Server and Asp.net core. Your English skills will be crucial as direct communication with me is required. Key Responsibilities: - Develop a robust business management system leveraging ASP.NET - Implement user authentication and authorization features - Integrate appropriate APIs to enhance system functionality Ideal Candidate: - Minimum 5 years experience in ASP.NET development - Proficient in C# programming and SQL Server - Familiarity with Asp.net core - Experience in developing business management systems preferred - Strong communication skills for client call Please note that this project is only ope...

I'm looking for an experienced individual to help me set up a VPN server on my TP Link Omega E707, running Windows OS. The primary goal of this is to allow secure remote access to my home network. Key Requirements: - Set up a VPN server on a TP Link Omega E707 running Windows - VPN server must be accessible outside my network - Ensure security and privacy in the VPN configuration - Establish a reliable connection method for remote access The ideal candidate should have: - Proven experience in setting up VPN servers on TP Link routers - Extensive knowledge of Windows OS - Understanding of network security and remote access protocols. Please note that my TP Link Omega E707 has a dynamic IP address.

... The role may also involve programming. Key points: - Coaching: I need 1/1 coaching via Teams on Data Analysis & Data Visualization within Azure Analytics - Programming: If the opportunity arises, the candidate could get involved in programming using SQL - Proficiency: I consider myself at an Intermediate level with Azure Analytics Ideal Skills and Experience: - Proficient in Azure Analytics: You should have a strong understanding of Azure Analytics, specifically in Data Analysis and Data Visualization - SQL Programming: Experience with SQL is a must as you may be involved in programming for this project - Teaching or Coaching Experience: Prior experience in teaching or coaching Azure Analytics would be advantageous - Strong Communication: The ability to clear...

I'm currently using a Python scraping bot for my project, but I need to make some adjustments. Key Requirements: - The primary modification involves segmenting the scraped data by day. To achieve this, I would like to have a timestamp column added that differentiates data on a daily basis. This will allow me to have a better understanding of the data collected each day. Your Proposal: In your application, please provide a detailed project proposal. I'm interested in freelancers who can clearly articulate how they will approach this task and ensure its successful implementation. Ideal Skills and Experience: - Proven experience in Python scraping bot modification - Familiarity with data segmentation and timestamping

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 in need of a skilled developer who is experienced with inventory management systems, report production, analytics, user access control, and Windows-based applications. This job involves maintenance of a warranty return tracking software, with specific attention to: - Inventory ...a plus. The overriding purpose of this software is to track and manage warranty returns effectively. Ideally, you should have previous experience in software creation and maintenance for tracking and managing products. The purpose of this project would be Bug fixing and improvement of the software tool already existing. Required: Experience with ER Models architecture Experience with MS SQL server 2017 express as DBMS Experience with Python 3.8.3 and Tkinter GUI toolkit Experience wi...

I'm in need of a professional developer to handle the architecture implementation of an IOT server. Key Responsibilities: - Connecting sensors and GPS based Telematics devices to the server. - Handling data collection and storage. - Managing device commands. - Setting up real-time monitoring and alerts. Your expertise in setting up a NoSQL database is essential for this project. I'm looking for someone who can not only execute this task but also provide valuable insights and inputs to enhance the overall performance of the server.

Need to convert text file to a clean page and remove the colums showing passwords.

I have a STEP file of a PCB that includes submodels of various components. Each submodel is named by the component, e.g., resistor 0402. I need someone experienced to identify and accurately place components (e.g., resistors) in the STEP file. Attention to detail and precision are crucial for this job. Start comment with fustion3

I need an adept SQL developer proficient in crafting SQL queries for various tables within our database. The task entails generating four queries, each encompassing approximately 20 conditions that must be met. Utilizing ChatGPT, could you assist in devising these queries?

I'm seeking an experienced Excel guru to help create / identify two specific formulas on my spreadsheet. This project is URGENT. The right excel Guru can probably figure this out in less than an hour. Easy money. The first formula is related to searching a cell for one of four words and populating an adjacent column with a correlating value, based on the word found. The four words to be searched for are "Low", "Medium", "High", and "Not currently a priority". The adjacent cells are to be populated with correlating values 1, 2, 3, and 0 (to generate a Score). The cells are currently blank, and users of the spreadsheet will fill these cells by selecting from a drop-down list (of these 4 words). The objective is to create a formula that co...

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...

I need a simple, single-column WordPress site set up with the following requirements: - The site will need to be built from a provided WP demo content folder, including plugins and theme. - The main content will be of a standard, text and image-based nature. - The site design should be a straightforward single column layout. For this project, you would need: - Proficient skills in WordPress - Experience with SCSS - The ability to set up a local site - Familiarity with migrating WordPress sites Please ensure you can work with the provided WP demo content folder as the basis for the site.

...focus is on expenses. Here is what I require: - Just the expenses data extracted from the Excel file and made available for the creation of a pivot table. - You'll need to determine the format of the data in the Expenses column. Your skills and experience: - Advanced knowledge of Microsoft Excel, especially in working with different types of data. - Proven experience in handling financial data, specifically expenses. - Ability to interpret varying formats of data on Excel. - Good problem-solving abilities, given that the specific format of the data in the Expenses column wasn't provided. If interested, please provide a portfolio showcasing your past work relating to Excel and financial data management. Your ability to deliver quality and accurate work will b...

DEFININTIONS local environment: developers laptop client: Wayne contractor: Faisal and his team PROBLEM STATEMENT Due to missing connection to database, the website on clients local machine is generating errors thus preventing development. SOLUTION: Create a replica of RDS production server (to be called "dev") on AWS, that can be used for development on local environment and for staging testing later on. CONTRACTORS ANTICIPATED TASKS (high level) 1. Take backup of production database on AWS 2. Create new RDS instance (server) using the backup and restore the backup. 3. Configure and verify the network settings to make connections over internet. 4. Test connection of new dev database with web application on local environment. DELIVERABLES 1. Demo showing the we...