Sql Clr Projects
Looking for freelance Sql Clr jobs and project work? PeoplePerHour has you covered.
Selenium-based data scrape of targeted LI profiles
The creation of a SQL database by scraping data from ~345,000 records from LinkedIn. - Selenium scripts to capture multiple fields from LI profiles (including Summary, Role Descriptions, Dates in Roles) - The storing of the data in an SQL database - Detailed technical documentation about each script
12 days ago30 proposalsRemoteopportunity
Python / Machine Learning / Selenium Scrap
We need help with python. Would you want to work for us? If so, when can you start working ? If you are interested, so there would be 2 contract fix rate $50/country flow, $10/script for easier works (like scrap-data transferring between GS&SQL),
6 days ago23 proposalsRemoteWordPress developer needed to resolve some issues
I am having trouble with the media library on my WordPress website. Sometimes I receive an error when trying to delete an image from the library. Also, in certain categories - new featured thumbnails are showing as "unattached," even though they are showing up in the post fine. I believe something went wrong when I was cleaning up the SQL database months ago. I didn't notice the issue until quite a bit after the fact, making a backup restoration nearly impossible.
9 days ago65 proposalsRemoteWeb Application Deployment in the Azure Cloud
(Microsoft Azure) Web application deployment in the Azure cloud using different service (IaaS, PaaS and FaaS) models 1.1 IaaS service model: Deploying an ASP.NET web application on Azure virtual machines. 1.2 PaaS Service Model: Deploying an ASP.NET web application to Azure App Service using Azure SQL Database. 1.3 FaaS Service Model: Deploy serverless APIs with Azure Functions, Logic Apps, and Azure SQL Database Objective: To test and compare the implementation of a web application in the Azure cloud using IaaS and PaaS service models.
24 days ago5 proposalsRemoteopportunity
Read/write data via GraphQL API to MS Access/Sql Server
"read/write data via GraphQL API to MS Access/Sql Server" We're a children's nursery, in the process of moving to a Nursery management service hosted on web We are a childrens' nursery using a web-based nursery management software called Famly. They use GraphQL for their api. We currently use MS Access DB but planning to move to SQL Server or similar. I need a set up for me to pull various sets of data via their api provided as e.g. row/column data to write/update our database. I also want functionality to write key information to Famly via their API by providing row/column data etc. The work would consist of configuring API access to our data in Famly with functionality to read and write data to/from Famly from our database.
a month ago27 proposalsRemoteopportunity
Create CRUD endpoints for our UI components in .NET Core Web API
We've our Admin angular project and it requires API endpoints (CRUD) to manage the data flow. You can start with our existing project and follow the same pattern. Additionally require you to create CacheRepository pattern to manage the cache for CRUD ops. Our Database is NoSQL but the queries are written in SQL. These are quite simple and Ill provide json document and you'll need to create endpoint to manage it. (We follow flat structure and doesn't require complex joins). 1. Blog APIs 2. Home Page API's 2.1. Trending Products API's 2.2. Deal API's 2.3. Ads API's 2.4. Brands API's 2.5. Trending categories API's 3. Category Page API's 3.1. Ads 3.2. Sub-categories 4. Sale API's 5. AWS S3 bucket Image management
23 days ago26 proposalsRemoteSoftware Developer
Job description Software development for mobile and web applications Development of applications for smart watches Communication with customers Cooperation with Embedded SW colleagues Participating in the development of new and existing projects from various fields (dry cabinet unit, bus control units, airsoft gun devices, electric golf vagoons) What do we expect? Experience with development in React (JS, HTML, CSS) Experience with Flutter or Swift/Kotlin Node.js, MongoDB or SQL experience preferred Experience with RESTful APIs is an advantage! University degree in IT or Computer Science is an advantage! Independence, sense for team spirit Good communication skills Ability to get things done Diligence, positive work attitude (we are flexible and accommodating, but we expect systematic attitude) Not to be afraid of new challenges Advanced knowledge of English language If you believe that your skills and expertise align with the requirements of this position, please send us your CV for review. Additionally, if you have a portfolio or examples of previous work, we would be interested in seeing them. We are eager to assess your qualifications and establish a cooperative relationship as soon as possible. We look forward to hearing from you.
25 days ago29 proposalsRemotePower BI Developer
Key Responsibilities: Develop functional & operational reports & dashboards. Build automated reports and dashboards with the help of Power BI and other reporting tools. Understand business requirements to set functional specifications for reporting applications. Be experienced in tools and systems on MS SQL Server BI Stack, including SSRS and TSQL, Power Query, MDX, Power BI, and DAX Be able to quickly shape data into meaningful reports and analytics solutions. Have knowledge of database fundamentals such as multidimensional database design, relational database design, and more. Analyse data sources and ensure data quality and integrity. Design and develop efficient data models in Power BI, ensuring optimal performance and scalability. Transform raw data into meaningful insights by implementing appropriate data transformations. Develop visually appealing and user-friendly dashboards, reports, and interactive visualizations in Power BI. Implement complex calculations and custom measures to meet business requirements. Leverage DAX (Data Analysis Expressions) to create advanced calculations. Integrate data from various sources into Power BI, ensuring seamless connectivity and data refresh. Utilize Power Query to clean, transform, and shape data for reporting purposes. Collaborate with cross-functional teams, including business analysts, data engineers, and IT teams, to ensure alignment with overall business goals. Conduct regular stakeholder meetings to gather feedback and make necessary adjustments to BI solutions. Provide training and documentation for end-users to ensure effective use of Power BI reports and dashboards. Monitor and optimize the performance of Power BI reports and dashboards. Ability of learning new tools to enhance the data quality and visualizations. Qualifications and Skills: Bachelor’s degree in computer science, Information Systems, or a related field. Proven experience as a Power BI Developer or similar role. Strong knowledge on Azure Data Lake, Data Factory and other data services Strong proficiency in Power BI, including data modelling, DAX, and Power Query. Solid understanding of relational databases and SQL. Experience in ETL processes and data integration. Excellent analytical and problem-solving skills. Strong communication and collaboration skills. Ability to work independently and as part of a team. Preferred Qualifications: Microsoft Power BI certification. Experience with other BI tools (Tableau, QlikView, etc.). Knowledge of data warehousing concepts. Familiarity with cloud platforms (Azure, AWS) for BI solutions.
7 days ago19 proposalsRemoteWebsite Testing
Comprehensive Website Testing Services 1. Introduction: We are seeking proposals from qualified vendors to conduct comprehensive testing of our website. The purpose of this testing is to ensure the functionality, usability, compatibility, security, performance, and content accuracy of the website. The selected vendor will be responsible for executing various testing types and providing detailed reports with findings and recommendations. 2. Scope of Work: The scope of this project includes conducting comprehensive testing of the Medha Immigration Consultants website to assess its functionality, usability, compatibility, security, and performance. The testing should cover all aspects of the website, including but not limited to: Functionality testing to verify links, forms, navigation menus, search functionality, interactive elements, and dynamic content. Usability testing to evaluate ease of navigation, layout, design consistency, readability, accessibility, and responsiveness across different devices and screen sizes. Compatibility testing to ensure compatibility with various browsers, operating systems, screen resolutions, and assistive technologies. Security testing to identify and address potential vulnerabilities such as SQL injection, XSS, authentication, authorization, SSL certificate installation, secure transmission of data, error handling, and logging mechanisms. Performance testing to determine website capacity, response times under heavy load conditions, server and database performance, image and media optimization, caching mechanisms, and monitoring of performance metrics. 3. Deliverables: The testing service provider is expected to deliver the following: Detailed test plan outlining the testing approach, methodologies, tools, and schedule. Test cases and scenarios covering all aspects of the website. Test reports with findings, recommendations, and prioritized action items. Documentation of identified issues, including severity levels and sugge
17 days ago26 proposalsRemoteSenior PHP/WordPress Developer
The PHP/WordPress Developer we are seeking will be the cornerstone of our development team, responsible for creating and implementing a range of database-driven web applications with a focus on delivering innovative and user-centric solutions. Your technical expertise will drive the design, development, and deployment of projects that stand out for their quality and functionality. Your Main Responsibilities Will Include: Execute the full website design and development life cycle, from the initial concept to deployment and beyond. Seamlessly integrate third-party APIs to extend the capabilities of our web applications. Develop and manage efficient, secure databases that support the functionality of our applications. Customize WordPress installations, crafting bespoke themes and plugins tailored to project requirements. Vigilantly address, diagnose, and rectify any issues in the application, prioritizing a bug-free user experience. Conduct thorough unit testing of code to ensure robustness, usability, and general reliability under various conditions. Manage and maintain domain registrations and configurations, ensuring optimal performance and reliability. Qualifications: Degree in Computer Science, IT, or a related field, with a minimum of 5 years of relevant work experience. Proficiency in PHP and SQL, with extensive experience in WordPress, HTML, CSS, JavaScript, and Bootstrap. Familiarity with C# will be considered a valuable asset. Solid understanding of MySQL databases and UI/UX design principles. High proficiency in English, both written and spoken; knowledge of additional languages is a bonus. Exceptional attention to detail, ensuring precision in coding and design. Strong organizational skills, including effective time management, prioritization of tasks, and the ability to multitask in a dynamic work environment. If you believe that your skills and expertise align with the requirements of this position, please send us your CV for review. Additionally, if you have a portfolio or examples of previous work, we would be interested in seeing them. We are eager to assess your qualifications and establish a cooperative relationship as soon as possible. We look forward to hearing from you.
a month ago52 proposalsRemote
Past "Sql-clr" Projects
opportunity
SQL Query Needed
I have a Table within a database and I need to copy some values from A >> B (within the same table). Please see attached screenshot. Importantly, if data already exists at B, we should not overide any data but skip. From A would be From the fieldid 375. Using the relid to match the line to the B side with the fieldid of 528. If the B side value is null, we should copy the value from the corresponding row. If the B side value has data, we should not copy over any data and move onto the next row.
opportunity
Upgrade Wordpress Site to PHP8.2 Locally and provide SQL/FTP
Upgrade Wordpress Site to PHP8.2 Locally and provide SQL/FTP ~ Hello, I need some help updating a clients website to php 8.3/8.2 when i update it, the website dies sadly. Would you be able to help with this, I have identified the plugin causing the issue is called "timber". The plugin is not supported by the developers anymore and as such, manual fixes need to be made. I can't give cpanel access, however I can give you all the website files and sql to work with and then you give me back a completed sql and files of the updated site. Please could I get a quote for carrying out this task. Thanks :)
Azure Data Engineer
Requirement Azure Data Engineer Experience 6+ yrs Project Timing 2 PM – 11 PM (2 nd shift) Skills- Databricks, SQL, Pyspark Databricks Certification- Good to have Good comm's and problem solving skills o Relevant experience in Azure data engineering: 4+ years. o Relevant experience in Databricks (PySpark / Scala / SparkSQL): 2+ years. o Relevant experience in Azure Data Factory (ADF): 2+ years. o Relevant experience in SQL: 2+ years. o Experience leading a small team o Required Skills: Azure Synapse, Azure Analysis Services, Azure Data Lake Storage, and Azure SQL databases. o Good to have: Power BI, Azure IAAS services, Python, and Excel
SQL Server Database Migration
I'm in need of an experienced professional who can assist me in transferring a large-scale database. Key requirements include: - Proficiency in handling and transferring databases, specifically SQL Server. - Experience in migrating large databases, in this case, exceeding 10GB. - Demonstrated knowledge in handling data and ensuring its integrity. - Ability to ensure smooth transfer with minimal downtime. Your role will involve transferring selected data safely, efficiently and without data loss. Prior experience with similar projects is highly advantageous.
Very large WordPress website needs a more efficient database
I run a large WordPress website with 800,000 posts and 1,000 new posts added daily. I have done what I can to keep the database operating smoothly, but I've just about reached the pinnacle of what my intelligence and comfort level will allow. I'm looking for someone experienced in Wordpress SQL environments to look over our current set up and make whatever adjustments they can to keep us running smoothly as the website grows.
Make minor changes in already working web app
I need some changes in a web app that workds. Already ( php, sql, bootstrap). ie. Make some required fields to optional
Wordpress Plugin Errors
I recently upgraded the PHP on my server and now a couple of plugins have errors. I'm looking for someone with experience working with Wordpress plugins, PHP, sql and databases.
Need to create a report using SQL
I require assistance in generating a complex report from multiple data sources within a custom application. The report necessitates retrieving and aggregating information from various tables using SQL queries. It must pull and consolidate pertinent records from a range of interconnected database assets while preserving data integrity. Specifically, the report will need to extract salient fields like identifiers, values, and timestamps from several intricately related operational stores. It should then compile and organize the extracted segments to provide a holistic view of core business operations over a specified timeframe. The constituent pieces must be intelligently linked and cross-referenced to offer meaningful insights. The underlying database schema may be intricate with numerous joins and intricate relationships between entities. As such, the SQL development will require strong expertise in querying disparate sources and nesting clauses to obtain all needed attributes. Optimization will also be critical as improper queries could impact system performance. Overall, the finished report must deliver a cohesive narrative and present compiled information in a clear format that facilitates easy analysis. Requirements gathering, iterative testing, and validation against source data will be pivotal to ensure accuracy and reliability. Mobility with formatting for both onscreen and printable distribution is preferable. Key skills needed are advanced SQL, relational data modeling, report generations, and analytical problem-solving abilities. Experience extracting consolidated views from sophisticated production databases through SQL is a must.
opportunitypre-funded
FOX ESS API Interface
c# Wpf application to access retrieve and display ( graphically and table preferred ) but table as a minimum and store results in a sql lite db - Source code must be included. lowest cost will score highly - Second API interface for alternate solar array may beaded at later date - fast turn around needed - API Details can be found here https://www.foxesscloud.com/public/i18n/en/OpenApiDocument.html#get20the20number20of20public20interface20accesses0a3ca20id3dget20the20number20of20public20interface20accesses4323e203ca3e
SQL Developer
We have a platform online running with a few hundred active users which is performing poorly. We've investigated using New Relic and have determined the cause to be poorly performing SQL queries. We are seeking an expert to help diagnose and rewrite the queries with our development team. Requirements: - Excellent knowledge of SQL - Ability to diagnose issues from New Relic - Strong ability in rewriting bad SQL - Able to work during the UK timezone Nice to haves - Knowledge of PHP and codeigniter