T Sql Projects
Looking for freelance T Sql jobs and project work? PeoplePerHour has you covered.
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.
11 days ago13 proposalsRemoteMake 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
11 days ago55 proposalsRemoteNeed 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.
a month ago18 proposalsRemoteCorrupted 2017 MS SQL database mdf,ldf files repair.
Hi, I have mdf and ldf file of ms sql database recovered from ransomware attack by paying ransom. Now the files can't be attached or openned by mssql server. Can you repair it and make it work fine?
12 days ago12 proposalsRemoteopportunity
Datatables.net (server-side), ASP.NET, VB, MS SQL
I have a requirement for a "simplified" version of an ASP.NET in VB page (default.aspx, default.vb) that: 1. Uses DATATABLES.NET with a repeater as the container for the data 2. Uses SERVER-SIDE processing in datatables.net with pagination, search, and sorting 3. Uses SQL Server to store the data (can use Northwind data as sample) 4. Uses (assuming) an .ashx Handler to manage/call/retrieve data from SQL in JSON
22 days ago19 proposalsRemoteRed Teamer in Fintech Security
Hey there, talented tech wizards! We have an incredible opportunity that's tailor-made for your skills. We're on the lookout for individuals who excel in Local SQL Injection (SQLi) and JWT (JSON Web Token) Bypass techniques. Why This Opportunity is a Game-Changer: High-Stakes Project: Successful completion of these tests opens the door to a project with serious digital security implications. Potential Earnings: Projects awarded after passing these tests will start with compensation ranging from $3000 to $5000, depending on the complexity and scope. What You Need to Do: Prove Your Skills: Demonstrate your prowess in Local SQL Injection and JWT Bypass. Secure the Bag: Upon passing, dive straight into a rewarding project with compensation ranging from $3600 to $5000. Why Choose Us? We value your expertise and commitment to excellence. We offer competitive compensation for your hard work and dedication. Projects with real-world impact await you! Note: The testing period is unpaid, serving as an assessment of your knowledge. The project will only be awarded upon successfully passing the test, ensuring top-notch digital security talent. Test repo :- https://github.com/livingsacrophagus/test-repo Ready to Rise to the Challenge? Deadline for completing 3/16/2024 5:00 PM EET
14 days ago10 proposalsRemote
Past "T-sql" Projects
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.
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
PHP Developer to Integrate Image Moderation API into site
UK based PHP developer required for photo sharing website (built in php/sql) Job is to integrate an image moderation API eg: https://deepengin.com/image-moderation https://sightengine.com/ https://www.webpurify.com/image-moderation or similar - whatever is easiest /cheapest to incorporate. API to run in the background to check photos uploaded by users, run smoothly, quickly and so that users unaware. Get in touch with estimate of quote /hourly rate/availability PS: Small family site, startup - please do not just ask for the url of site as your initial response as not important. Thanks
opportunity
Android TO-DO LIST working on LAN (REACT NATIVE / MS SQL SERVER)
I want to create an Android smartphone application that is a to-do list. The application will be installed on my smartphone and on my technicians' smartphone. I, who am the administrator, want to insert a job to be done into the application, for example "the printer in the technical office doesn't work, it needs to be repaired". I also need to be able to insert if it is an urgent job. Technicians who have the application, but are not administrators, should see the note and the time it was published. When each technician opens the note to see it, I have to see at what time they read the note. When a technician starts the job, he must tick it in the application and the start date and time must be recorded. When the technician has finished the work, he must report it in the application and the finishing date and time must be recorded. Only the administrator should be able to insert a job, modify it, or delete it. Technicians can only read the job, and report that they have started it and that they have finished it. The database that holds the application data will need to be on the company's MS SQL server. The application must only work on Android smartphones connected to the company's wireless LAN. No cloud data. The application will have to be developed with React Native. The backend will be developed with NODE.JS I attach a first draft of the screens
opportunity
PBI - Recurring Email (3)
PBI - Recurring Email (3), recurring email for payroll through SQL / Power automate We require a recurring email to be sent out to employees on a weekly basis that includes payroll information. The email should be generated using SQL or Power automate and should include the following information: Employee name Payroll period Salary Deductions Net pay The email should be visually appealing and easy to read, and should be customized with the company's logo and colors. We also require the ability to add or remove employees from the email list as needed. Please provide a proposal for the project, including a timeline and estimated cost.
opportunity
PBI - Recurring Email (2)
PBI - Recurring Email (2), recurring email for payroll through SQL / Power automate We require a recurring email to be sent out to employees on a weekly basis that includes payroll information. The email should be generated using SQL or Power automate and should include the following information: Employee name Payroll period Salary Deductions Net pay The email should be visually appealing and easy to read, and should be customized with the company's logo and colors. We also require the ability to add or remove employees from the email list as needed. Please provide a proposal for the project, including a timeline and estimated cost.
SQL Optimization
I am presently encountering performance issues with a certain SQL query, relying heavily on joins. The complexity of understanding the query also adds to it, taking away precious time and productivity. My performance measurement indicator is query execution time. The quicker the execution, the better the performance. Therefore, my project involves reconstructing this query to use Common Table Expressions (CTE) instead of joins. I would also need you to create views based on this newly optimized query. The database management system in use is PostgreSQL. Corresponding experience and knowledge in this system, along with skill in CTE implementation and optimizing SQL queries are pertinent. Skills and Experience: - PostgreSQL expertise - Proficient in SQL and CTE - Familiar with performance metrics like execution time - Experience in building SQL views The goal of this project is to have a more streamlined and efficient SQL query that uses less execution time. Your prime responsibility would be to restructure and simplify the query without disturbing its functionality.
Replicate an existing Access interactive database in SQL
I need an experienced UK based SQL programmer to build what is quite a complex and interactive database. Contract and remuneration conditional upon 1) Level of experience and qualifications of selected candidate and 2) Initial evaluation and assessment of project by selected candidate
Pardot - Sales Funnels & Campaign Implementation
Project Overview: Seeking a Salesforce professional, who’s proficient in implementing comprehensive sales funnels within Pardot, aligning with our company's Sales Qualified Leads (SQL) and Marketing Qualified Leads (MQL) activities and scores. Our goal is to develop tailored campaigns across various stages of the sales funnel, including awareness, nurture, and retention campaigns. Knowledge of Pardot is crucial for this project. Objectives: Develop top, middle, and bottom-of-funnel sales funnels within Pardot to effectively nurture leads and drive conversions. Align sales funnel stages with our company's SQL and MQL activities and scores to ensure accurate lead qualification and segmentation. Create awareness campaigns to attract and engage potential leads, showcasing the value proposition of our products or services. Implement nurture campaigns to educate and build relationships with leads, guiding them through the decision-making process. Develop retention campaigns targeting existing customers, aimed at fostering loyalty, increasing retention rates, and driving upsell opportunities. Key Requirements: Expertise in Pardot: expertise in working with Pardot, including proficiency in setting up automated campaigns, lead scoring, and segmentation. Understanding of SQL and MQL Activities: posses a deep understanding of Sales Qualified Leads (SQL) and Marketing Qualified Leads (MQL) activities and scores, and be able to translate this knowledge into effective campaign strategies. Ability to Develop Tailored Campaigns: demonstrate the ability to develop customized campaigns tailored to different stages of the sales funnel, incorporating personalized messaging and content. Track Record of Success: We seek an agency with a proven track record of successfully executing similar projects and delivering measurable results in lead generation, nurturing. Collaboration and Communication: Strong communication and collaboration skills are essential for seamless coordination between our internal team throughout the project. Deliverables: Detailed sales funnel strategies and plans for top, middle, and bottom-of-funnel campaigns. Implementation of automated campaigns within Pardot, including setup of lead scoring and segmentation rules. Training and knowledge transfer to our internal team on managing and maintaining campaigns within Pardot. Timeline: The project is expected to commence ASAP and be completed by 18th March (includes timelines for strategy development, campaign setup, testing, and optimization). Budget: Please provide a breakdown of your proposed costs for strategy development and campaign setup. Next Steps: Pls submit a proposal outlining your approach, capabilities, and pricing for this project. Please include relevant case studies or examples of past work demonstrating your expertise in Pardot campaign management and lead nurturing. Thank you for considering this opportunity. We look forward to reviewing your proposal and potentially collaborating on this exciting project.
opportunity
Mobile App with React Native / Expo / CSV file (or SQL Server)
I need a Mobile App working on an Android Phone that reads barcodes and stores them inside the cell phone (connected to a LAN) After the operator has read each barcode, he must be able to enter a quantity. When the operator has finished reading the barcodes, he must press a button and the App must send the barcodes and the quantity in a CSV file to a shared folder on a computer on the LAN (or, if it is easier, write the data on a SQL Server table, in this case, I need also the code for the server if needed) The App must be developed with React Native / Expo
Web Scraping Data in to SQL database
I'm seeking a skilled freelancer to assist with a web scraping project on a specific website and leading up to a number of websites. The specific data fields that need to be extracted will be provided. Ideally, you'll have: - Advanced skills in web scraping and python -- Knowledge of MS SQL Server databases. - A demonstrable understanding of data extraction - A fast turnaround rate as this project is high-priority and needs completing as soon as possible. Experience in extracting both structured and unstructured data would be beneficial, as it's likely our sought-after fields will vary. The end goal is for me to eventually take over the code with your ongoing support and will most likely be a long term relationship. I can provide a full specification when needed. Please place your bids following this detailed outline.
Skilled SQL Developer for Database Design
I need a proficient SQL developer who can focus on database design and creation. You will be working on a relational database project. There will be an emphasis on creating tables. Ideal freelancers will have: - Strong skills in SQL and relational database operations - Experience in database design, particularly creating tables - Knowledge of query optimization and data migration - A thorough understanding of data normalization, indexing, and data integrity constraints. Your role will involve creating a user-friendly, efficient, and robust database model. If you have the skills and experience to deliver on this, please bid
Python Expert
We need to get this information about the prices of bond securities We need the info inside the first pdf in the top left from page 3 without their corporate info (this list us updated every day) and we would like to upload it into our database sql server Can you review it and let me know if you can easily do it so it is automatic and how much time it would take you more or less? Thanks Khadimul