Tsql xquery jobs
...with expertise in XSLT, XQuery, and Schematron. The ideal candidate will have a strong background in XML technologies and experience in developing and maintaining complex XML-based applications. This role involves working closely with our development team to ensure the accuracy and efficiency of our XML data processing. Key Responsibilities: Develop and maintain XSLT stylesheets for transforming XML documents. Utilize XQuery to query and manipulate XML data. Implement Schematron rules for XML validation. Collaborate with the development team to integrate XML solutions into existing systems. Troubleshoot and resolve issues related to XML processing. Optimize XML workflows for performance and scalability. Document processes Qualifications: Proven experience with XSLT, XQu...
I'm looking for a certified Power BI professional with MS PL300 power BI Data Analyst certification who can train a small team over a 30 day period. The training needs to be at an intermediate level and should focus on Power BI DAX, SQL...and report generation - Proficiency in Hindi and English - Based in India - Able to provide intermediate-level training to a small group - Able to train on SQL T-SQL Ideal Skills: - Power BI DAX expertise - SQL T-SQL mastery - Report generation proficiency - Excellent communication skills in Hindi and English - Previous experience as a Power BI trainer / BI developer with SQL proficeny - SRSS / TSQL / SQL Server knowledge is beneficial - Handle session doubts effectively - independently lead the entire learning module and deliver in one mon...
I'm in need of an expert who can efficiently partition my form data, using TSQL. I'm not familiar with table partitioning and would appreciate guidance. Grouping question and answer sets is integral to this project. The data set you will be working with is less than 1GB. Required Skills and Experience: - Advanced knowledge in TSQL and data partitioning - Proven experience in handling similar projects - Comfortable with explaining complex concepts to a non-expert - High attention to detail, particularly with regards to data grouping Expectations: - Understand and implement table partitioning in TSQL - Group the question and answer sets in an efficient manner - Patience in explaining the implemented process to me as a client unfamiliar with table partitioning...
I need an experienced TSQL programmer to develop a set of complex stored procedures to read data from the transactions log in MSSQL 2017. Need to read data from tranactions log for insert, delete, update on a given tables based on the techniques in : and other related sites. need to store the information in another database server that listens to the tranactions log on a given server. Key Requirements: - Proficiency in TSQL with a focus on MSSQL 2017. - Strong experience and knowledge in working with complex databases. - Specific experience in developing stored procedures to read and interpret data from a transaction log. - Ability to understand and work with a large number of relational
I'm looking for a TSQL developer with strong knowledge in SSRS. Your main responsibilities will include writing complex queries and creating stored procedures to serve two main purposes - data analysis and reporting, and data manipulation and transformation. Ideal Skills and Experience: - Proficient in TSQL and knowledgeable about performance optimization - Strong understanding of data analysis and reporting - Experience in developing complex SSRS reports, specifically with drill-down functionality Your primary focus will be ensuring that our databases are optimized for efficient data analysis and reporting. You will also be responsible for creating and maintaining complex SSRS reports with drill-down functionality. Your work will be instrumental in enhancing our bu...
I'm in need of a SonarQube specialist for a personal project. The task is to setup, scan and analyze TSQL files. Specific tasks: - scan TSQL files - Apply SonarQube scanning to detect potential issues in the code - Primarily focus on unveiling code smells and identifying security vulnerabilities Ideal Candidate: An ideal fit for this job would be someone with vast experience in SonarQube, possessing strong attention to detail. In depth understanding of source security structures and adept at detecting potential code smells is paramount and someone who can scan TSQL files and import report and coverage in sonarqube
We are seeking a highly skilled Full-Stack Developer with extensive experience in .NET 4.5, SQL, C#, ASP.NET, JavaScript, TSQL, HTML, regular expressions, and PHP. The ideal candidate will develop and maintain web applications, write efficient SQL and TSQL queries, implement front-end features, and ensure the security and performance of our applications. Strong problem-solving skills, excellent communication, and a collaborative approach are essential.
...Developer to contribute to our team's success. Responsibilities include designing, developing, and maintaining SQL Server Analysis Services solutions for business intelligence and data analytics requirements. Tasks involve creating data models and developing multidimensional cubes. Key skills required: expertise in MS SQL Server Analysis Services (SSAS) Tabular and Multidimensional. Proficiency in TSQL for writing performant queries is essential. Experience with data visualization and reporting tools is highly valued. Additional knowledge of Excel and .Net development is advantageous. Strong problem-solving abilities, excellent communication skills, and a collaborative mindset are desired traits. Developer has to be at the ON SITE Dubai office. - Work Location -&...
I need an expert in SSRS 2019 and TSQL creation and optimization to assist in my project. Key Tasks: - Designing and developing robust SSRS reports - Writing complex, efficient TSQL queries - Ensuring optimal performance of both SSRS and TSQL You should have extensive hands-on experience with SQL Server Management Studio, Visual Studio Your background in handling complex data scenarios using these tools will be pivotal. Your role is critical in ensuring the project's success, so your proven expertise is a must.
I am in need of a skilled tutor who...am in need of a skilled tutor who can help me enhance my abilities in data integration and ETL (SSIS), reporting and visualization (SSRS), and database querying and management (TSQL). My main goal is to improve data integration processes. In this project: - You will support my learning to drive more efficient data integration operations. - In-depth knowledge and practical training on how to generate insightful reports and visualizations will be expected. - The training must cater to an intermediate level familiarity with SSIS for data integration. Ideal Skills and Experience: - Experience in SSIS, SSRS, and TSQL. - Ability to impart knowledge effectively. - Experience working with intermediate learners. - Familiarity with different...
I am in need of a TSQL developer expert to assist me with an advanced stored procedure development task. Requirements: - Advanced knowledge and experience in TSQL - Strong understanding of query optimization - Ability to create stored procedures from scratch - Attention to detail and ability to follow specific requirements Skills and Experience: - Proficient in TSQL and familiar with the latest developments and best practices - Experience in developing complex stored procedures - Ability to optimize queries for performance - Strong problem-solving skills and ability to work independently Please note that no existing documentation or examples are available, so the developer will need to create the stored procedure from scratch based on the given requirements.
I am looking for a freelancer to write a TSQL script for allocating several loans repayments on loan repayment schedules on a 'First In First Out' (FIFO) basis. Tables involved: 1. TblLoans (which contains the list of loans) 2. TblLoansRepaymentSchedules (which contains the loan repayment schedules) 3. TblReceiptsLoans (which contains the loan repayments) 4. TblReceiptsLoansSub (which will contain the result of the allocations of the loans repayments on the repayment schedule on a FIFO basis) Approach: 1. The script will iterate from the first to the last loan in TblLoans. 2. For each loan, it will iterate from the first to the last repayment in TblReceiptsLoans. 3. For each repayment, it will look up the loans repayment schedules in TblLoansRepaymentSchedules, alloca...
I'm looking for an experienced book cover designer to bring my book to life. The book is non-fiction, and I don't have any specific themes in mind. Here are my details: Title: SQL Practice and Interview Questions Subtitle: 45 Practice Problems and 15 Common Interview Questions for Your Practice. Author: Aubrey Love Published by: TSQL Basics Description: This book is filled with practice and interview questions for a DBA (Database Administrator). It also contains instructions on how to install SQL Server and other required software. It is designed for beginners as a starting point, and for intermediate and advanced DBAs to use as a desk reference guide. Size: 7.5" x 9.25" It will be published as a paperback, hardcover, and Kindle book on the Amazon KDP platf...
I am looking for a freelancer who is experienced in SQL and TSQL to assist me with query optimization. The ideal candidate should have strong skills in database design and data analysis and expert knowledge in SQL, PSQL and TSQL This is a very short project which should take no more then few hours.
I am looking for an experienced individual with advanced knowledge of Structured Query Language (SQL) and Transact-SQL (TSQL) queries to help me with my project. I need help with topics such as joins, subqueries, and indexes and need assistance with both writing the queries as well as understanding the concepts. My proficiency level in SQL and TSQL is advanced, so I am looking for someone who can provide the highest quality of work to meet my project goals. Task should only take no more then 2 hours
...am looking for an experienced IICS resource who can help me with writing xquery scripts. Specific Task: - The main task will be writing xquery scripts for my project. Existing Script: - I do not have an existing script, so the freelancer will need to create one from scratch. Complexity: - The desired complexity for the xquery scripts is basic. Ideal Skills and Experience: - Strong knowledge and experience in writing xquery scripts - Proficiency in IICS (Informatica Intelligent Cloud Services) - Ability to understand and analyze requirements to create effective xquery scripts - Attention to detail and ability to troubleshoot and debug xquery scripts If you have the necessary skills and experience in writing xquery scripts and work...
I am looking for an IICS resource who can help me with writing XQuery code. I have specific requirements for the code and need someone who can assist me in achieving my goals. The timeline for this project is flexible, allowing for more than 7 days to complete the task. Skills and Experience: - Strong knowledge and experience in writing XQuery code - Familiarity with IICS (Informatica Intelligent Cloud Services) - Ability to understand and execute specific requirements for the code
write TSQL in Microsoft sql server for 3,4,5 problems tasks as mentioned in this document Deadline: today in few hours
I need a PHP library installed on my Linux server. The library includes PHP, HTML, TSQL, and JavaScript. The specific library I need installed is the I am open to recommendations for the version to install. The operating system of my Linux server is not specified. The ideal freelancer for this project should have experience with Linux servers and PHP libraries.
Sql Developer Experience-5+ years Major experience in Sql,TSQL,SSIS and SSRS. Remote
Validate and change the start dates in startdate column of tblSchedule_Tasks by querying the enddate of the predecessor task. If the predecessor is 0 the start date remains the same. If the predecessor is 20 for example, you will ...actual start date. IE, StartDate April 19,2023 with a 2 day duration needs a end date of April 20, 2023. Also the query needs to begin with a startdate validated to a prececessor task. I would like to send you the tables in ssms format. After the queries are written I can take it from there. this is a common business use case in a scheduling program. Are you familiar with working with dates in tsql? i exported the two table using generate script in ssms. For simplicity use scheduleID = 20063 in tblSchedule_Tasks. there are several dummy jobs in th...
We are building 2 applications, and we need someone to help with optimizing the code and architecture. You should be able to identify opportunities to improve the applications, explain the improvement, and then implement the update. This is some of the required experience… Code and Architecture Optimization Best Practices and Proper Design Patterns SQL Server: TSQL, Stored Procedures, Functions .NET C# MVC Dapper ORM Vue.js / Angular.js (Nice to Have) Ongoing contract. Pay rate is negotiable
I need to create a POC to replicate data from one TSQL server on local host to a TSQL Server on AWS. It should be dummy data just need to show the process working and the data moving
According to our messages please complete the Job.
Hi! I have an python script to validate an document. There are just a few checks ( if, then, else). I want to convert this ruleset into xquery commands. Because this xml is going in database (base-x) and there i want validate this document according to the rules. The rules you can check in the attachment script.py.
...Requirements 1. Software development experience and expertise on .NET core (Dot Net Core) 2. Latest technology stack (.Net framework 4.0 or higher, ASP.Net MVC, Web API, SQL Server 2014 or higher) with best practices. 3. Hands-on experience - jQuery, Angular JS, C#, JSON and XML. 4. Knowledge of ASP.NET Web API and best practices for developing web services. 5. Strong in terms of writing complex TSQL Queries i.e. Stored Procedures and Triggers. 6. Experience working in an Agile development environment. 7. Ability to work both independently and as part of a team. 8. Experience of performing code review for Junior Stack Developers. THIS POSTING IS NOT A ONE-OFF PROJECT OR A PROBLEM SOLVER POST. EVERYDAY REGULAR WORK WILL BE PROVIDED WITH DAILY STANDUP MEETING AND EVERYTHIN...
? Very good working experience in C#, .NET 4.5, or above Framework And MVC ? Very good working experience in Web API, ASMX, and REST/SOAP services, ? Good knowledge in JSON, TSQL, SQL Server 2014, SPs, Table ? knowledge in Insurance domain will be an advantage ? Ability to handle the existing applications for enhancements individually with little help or no ? IIS Configuration and Setup in Cloud environments ? Experience building Single Page Applications (SPA) using Angular Js and or Angular (Secondary Skill) ? Excellent analytical and problem-solving skills ? Excellent verbal and written communications skills ? Experience in SDLC in Waterfall and or Agile
...Requirements 1. Software development experience and expertise on .NET core (Dot Net Core) 2. Latest technology stack (.Net framework 4.0 or higher, ASP.Net MVC, Web API, SQL Server 2014 or higher) with best practices. 3. Hands-on experience - jQuery, Angular JS, C#, JSON and XML. 4. Knowledge of ASP.NET Web API and best practices for developing web services. 5. Strong in terms of writing complex TSQL Queries i.e. Stored Procedures and Triggers. 6. Experience working in an Agile development environment. 7. Ability to work both independently and as part of a team. 8. Experience of performing code review for Junior Stack Developers. THIS POSTING IS NOT A ONE-OFF PROJECT OR A PROBLEM SOLVER POST. EVERYDAY REGULAR WORK WILL BE PROVIDED WITH DAILY STANDUP MEETING AND EVERYTHIN...
Analyze existing T-SQL code and new T-SQL, identify and document the test cases required for the DB restructure and ETL process refactoring. Perform SQL query tuning and optimization. Work with ETL developers to re-factor the existing ETL processes and create new process. Define and document test plans and test cases for the ETL refactoring and SQL changes. Develop test scripts (T-SQL) and perform data validations and verification's
...Requirements 1. Software development experience and expertise on .NET core (Dot Net Core) 2. Latest technology stack (.Net framework 4.0 or higher, ASP.Net MVC, Web API, SQL Server 2014 or higher) with best practices. 3. Hands-on experience - jQuery, Angular JS, C#, JSON and XML. 4. Knowledge of ASP.NET Web API and best practices for developing web services. 5. Strong in terms of writing complex TSQL Queries i.e. Stored Procedures and Triggers. 6. Experience working in an Agile development environment. 7. Ability to work both independently and as part of a team. 8. Experience of performing code review for Junior Stack Developers. THIS POSTING IS NOT A ONE-OFF PROJECT OR A PROBLEM SOLVER POST. EVERYDAY REGULAR WORK WILL BE PROVIDED WITH DAILY STANDUP MEETING AND EVERYTHIN...
I am looking for SQL, Tsql and SSR experts for project
...Requirements 1. Software development experience and expertise on .NET core (Dot Net Core) 2. Latest technology stack (.Net framework 4.0 or higher, ASP.Net MVC, Web API, SQL Server 2014 or higher) with best practices. 3. Hands-on experience - jQuery, Angular JS, C#, JSON and XML. 4. Knowledge of ASP.NET Web API and best practices for developing web services. 5. Strong in terms of writing complex TSQL Queries i.e. Stored Procedures and Triggers. 6. Experience working in an Agile development environment. 7. Ability to work both independently and as part of a team. 8. Experience of performing code review for Junior Stack Developers. THIS POSTING IS NOT A ONE-OFF PROJECT OR A PROBLEM SOLVER POST. EVERYDAY REGULAR WORK WILL BE PROVIDED WITH DAILY STANDUP MEETING AND EVERYTHIN...
...Requirements 1. Software development experience and expertise on .NET core (Dot Net Core) 2. Latest technology stack (.Net framework 4.0 or higher, ASP.Net MVC, Web API, SQL Server 2014 or higher) with best practices. 3. Hands-on experience - jQuery, Angular JS, C#, JSON and XML. 4. Knowledge of ASP.NET Web API and best practices for developing web services. 5. Strong in terms of writing complex TSQL Queries i.e. Stored Procedures and Triggers. 6. Experience working in an Agile development environment. 7. Ability to work both independently and as part of a team. 8. Experience of performing code review for Junior Stack Developers. THIS POSTING IS NOT A ONE-OFF PROJECT OR A PROBLEM SOLVER POST. EVERYDAY REGULAR WORK WILL BE PROVIDED WITH DAILY STANDUP MEETING AND EVERYTHIN...
I want a TSQL scalar function that obfusicates strings. I want it to loop through a string and replace all characters with a similar random character; lower with random lower, capitol with random capitol, digit with random digit, and all other characters the same. Example: INPUT: 5123 Myreal+ St, My/city, FL, 32533 OUTPUT: 8195 Uabshj+ Us, Ia/sdfh, HW, 84123
...Requirements 1. Software development experience and expertise on .NET core (Dot Net Core) 2. Latest technology stack (.Net framework 4.0 or higher, ASP.Net MVC, Web API, SQL Server 2014 or higher) with best practices. 3. Hands-on experience - jQuery, Angular JS, C#, JSON and XML. 4. Knowledge of ASP.NET Web API and best practices for developing web services. 5. Strong in terms of writing complex TSQL Queries i.e. Stored Procedures and Triggers. 6. Experience working in an Agile development environment. 7. Ability to work both independently and as part of a team. 8. Experience of performing code review for Junior Stack Developers. THIS POSTING IS NOT A ONE-OFF PROJECT OR A PROBLEM SOLVER POST. EVERYDAY REGULAR WORK WILL BE PROVIDED WITH DAILY STANDUP MEETING AND EVERYTHIN...
...Requirements 1. Software development experience and expertise on .NET core (Dot Net Core) 2. Latest technology stack (.Net framework 4.0 or higher, ASP.Net MVC, Web API, SQL Server 2014 or higher) with best practices. 3. Hands-on experience - jQuery, Angular JS, C#, JSON and XML. 4. Knowledge of ASP.NET Web API and best practices for developing web services. 5. Strong in terms of writing complex TSQL Queries i.e. Stored Procedures and Triggers. 6. Experience working in an Agile development environment. 7. Ability to work both independently and as part of a team. 8. Experience of performing code review for Junior Stack Developers. THIS POSTING IS NOT A ONE-OFF PROJECT OR A PROBLEM SOLVER POST. EVERYDAY REGULAR WORK WILL BE PROVIDED WITH DAILY STANDUP MEETING AND EVERYTHIN...
...Requirements 1. Software development experience and expertise on .NET core (Dot Net Core) 2. Latest technology stack (.Net framework 4.0 or higher, ASP.Net MVC, Web API, SQL Server 2014 or higher) with best practices. 3. Hands-on experience - jQuery, Angular JS, C#, JSON and XML. 4. Knowledge of ASP.NET Web API and best practices for developing web services. 5. Strong in terms of writing complex TSQL Queries i.e. Stored Procedures and Triggers. 6. Experience working in an Agile development environment. 7. Ability to work both independently and as part of a team. 8. Experience of performing code review for Junior Stack Developers. THIS POSTING IS NOT A ONE-OFF PROJECT OR A PROBLEM SOLVER POST. EVERYDAY REGULAR WORK WILL BE PROVIDED WITH DAILY STANDUP MEETING AND EVERYTHIN...
This work involves writing some XQuery expressions to extract helpful information from some real XML data. Topic containing a XQuery FLWOR expression, frequency with distinct-values(), find the probability from the value and sorting the top 30 from the list.
This work involves writing some XQuery expressions to extract helpful information from some real XML data. Topic containing a XQuery FLWOR expression, frequency with distinct-values(), find the probability from the list.
Hi Yierpan A., I noticed your profile and would like to offer you my project. We can discuss any details over chat.
...it to continue in 2023. Would you like to be part of a senior-level SQL Server growing team with opportunities for advancement? Job description - Design cutting-edge SQL Server solutions - on-prem and cloud - Proactively discover db issues - Find bottlenecks - Troubleshooting - Performance tuning Required skills - Verbal and written English required - SQL Server - TSQL - Attention to detail Preferred skills - Partitioning, AlwaysOn, Clustering, Indexing, Replication, extended events, baselining - Standard operating procedures Misc details - Our team works during New York EST business hours. We need at least some overlap on the timezones in order to have regular meetings and give feedback. - Knowledge of other programming langua...
Hi Geert B., I need help with Xquery already written for a task. We can discuss details over chat.
sql expert needed to complete project must know advanced sql queries Database Question 4 languages allowed: mysql, oracle, tsql, db2 Test duration 30 mins No. of questions 1 question
...extending for another 2. This will be a full time project eliciting 40 hours per week, Mon to Fri and if needed/approved, on the weekend as well. This is in the medical billing industry so the Developer has to meet the HIPA Compliance requirements. The ideal candidate should be efficient in the following technologies: Blazor, Xamarin, MAUI SQL Server TSQL queries, views and stored procedures Database functions XML Querying XML using TSQL Applying namespaces to XML queries EntityFramework Implementing EF Querying tables, views and functions Updating EF models .NET Framework Working with .NET Framework 4.5+ Asynchronous function Multithreaded development XML Serialization/Deserialization Reflection ASP.NET MVC Development using Razor Developing models Performing model v...
Hello My friend gave me your contact and said you can help me with my TSQL task I have. I am very new to the database field and would like to hire you. Please let me know. Thank you He said you charge per hour as well
...with the possibility of extending for another 2. This will be a full time project eliciting 40 hours per week, Mon to Fri and if needed/approved, on the weekend as well. This is in the medical billing industry so the Developer has to meet the HIPA Compliance requirements. The ideal candidate should be efficient in the following technologies: SQL Server TSQL queries, views and stored procedures Database functions XML Querying XML using TSQL Applying namespaces to XML queries EntityFramework Implementing EF Querying tables, views and functions Updating EF models .NET Framework Working with .NET Framework 4.5+ Asynchronous function Multithreaded development XML Serialization/Deserialization Reflection ASP.NET MVC Development using Razor Developing models Performing model ...
