Tsqlemplois
Prestation : • Maintenance et développement du logiciel Zele • Réponse aux demandes de corrections des bugs • Améliorations des modules existants et développement de nouveaux modules Compétences : Minimum requis : • Maîtrise du framework .net • Maîtrise de VB.net • Maîtrise de la gestion de base de données SQL Serveur (Structure, maintenance, performances, TSQL) Serait un plus : Connaissances ASP.net (pour faire des développements WEB) Spécificités : indépendant ou petite structure, réactivité.
write TSQL in Microsoft sql server for 3,4,5 problems tasks as mentioned in this document Deadline: today in few hours
Veuillez vous inscrire ou vous connecter pour voir les détails.
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
...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...
Programador senior con perfil full stack. Conocimientos y experiencia (1 año) en desarrollo móvil con tecnología React Native, conocimientos en desarrollo WEB .NET y API Rest, en BD relacional y programación TSQL, así como nociones de BD no relacional (COSMOSDB), también en despliegues en cloud e integración con servicios PaaS preferiblemente sobre Azure. Se valorara conocimientos en IoT. Jornada completa, flexibilidad horaria, semipresencial. Preferiblemente residente en Murcia o provincias colindantes.
...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...
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...
Need to Convert MS Access query into TSQL.
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 ...
add foreign key to a tsql table on Azure synapsys the regular code doesnt work
Need Power BI reports with DAX and TSQL code.
Looking for 1 to 1.5 years exp ASP.Net , Power Builder , Microsoft SQL Server, Database should be strong , TSQL, Stored Procedure. If you knowledge of Laravel / CI thats a plus. Contract Duration : Min 3 months (will be extended based on requirement) Time Zone : US Time shift Working Hours ; 8-8.5 hours Working Days : Mon - Friday
Dear freelancer, I have a sql server db with the following columns: Date, number1, number2, number3, number4, number5, number6 and few other columns. I need a tsql query that will create all possible combinations for numbers from 1 to 90 escluding occurences in database. For example, if there's already in db a combination such as 8, 11, 18, 46, 48, 88 then it should be excluded from the result set. Parameters to be accepted are as follows: NUMBERS TO BE EXCLUDED: set of number that should be excluded from result set CONTINUOUS NUMBERS YES/NO: Exclude from result set sequences with continuous numbers (eg. 12345 or 1, 2, 15, 16, 22, 23, etc) RANGE OF NUMBERS (FROM 1 TO 10): How many numbers to be included in result set RANGE OF NUMBERS (FROM 11 TO 20): How many numbers to be i...
Veuillez vous inscrire ou vous connecter pour voir les détails.
Requirement - Zoom Developer (DB Specialty) training wish list PAX – 15 – 20 ( Both Freshers & Laterals) Technologies to be covered 1. SQL Server Integration Services (SSIS) 2. SQL Server Analysis Services (SSAS) 3. DAX 4. Advanced TSQL – Emphasis on Stored Procedure development Expectaions: Should have some familiarity with coding in general of course. Frontend UI Developers should have the following general skillset: Net Core, ASP.NET, Web API, Microservices, C#, TSQL, AngularJS, Java Script, Linux, Azure Power Apps, Bots, RPA, Python.
Hi I need a tsql expert who is reliable and have time to do a small project. The project is about integration of slack and tsql. Slack need to be used to recover notifications from mssql regarding mssql notifications.
Experience : 4+ Years Open Positions : 06 Developers Joining: Immediate Job Type: FullTime Salary: 20-30% increment on current CTC Location : Pune / remote/WorkFromHome option available Job Description: - Excellent knowledge of coding and NET is required. - Expertise in TSQL, ASP.Net, IIS, MVC, Web API, Entity Framework, JavaScript, HTML5, CSS, jQuery and similar technologies is required. - Programming experience building Responsive Web Applications using Bootstrap or similar technologies is required. - Programming experience with SQL Server Integration Services (#SSIS), SQL Server Reporting Services(SSRS) and Microsoft Dynamics CRM is desirable. - Solid debugging, testing, and problem solving skills. Strong written and verbal communication skills.
Hi, we are looking to hire a TSQL SQL Server developer for a long term development works. The candidate should have extensive experience in SQL Server development and should be available to work with us during IST hours
...architects and support teams. So there will be no 20 hours of 'discovery' on our applications. We will point you to the pages, code and database assets we need changed. Hopefully over time you will get to know our applications. Required skills - ASP.NET (VB) - MS SQL Server - TSQL - HTML/CSS/JQuery - Visual Studio - VSO (Online Source Code) - Creation of Console App - Creation/Consumption of Web Services/APIs Ideally you will have worked with: - Large database driven websites - Integrating 3rd party Web Services/APIs - Complex TSQL to improve performance - Experience with the Metronic Admin framework The team member assigned must - Be able to follow older style code (but be up to speed with newer concepts) - Be able to follow step by step instructions. - Be ab...
We're looking for asp.net MVC core developers who have worked with. .NET Core C# .asp.net MVC .Angular TSQL. Sqlserver Rdlc Crystal reports Because this is a long-term position, the developer will be interviewed and put through a practical exam before working 40 to 60 hours per week. for the next 5 to 8 months, at a rate of 4-5 USD/h
We have several Oracle scripts that are using Oracle's dbms_aq (Advanced Queuing). We want to have an experienced SQL Server developer who can write queries based on SQL Server Service Broker
Hi, we have a project that requires a minimum of 100 hours of work. We want an experienced TSQL developer to work with us on this project.
Need a mentor for tsql and implementation of some logic
I am looking for multiple instructors experts in TSQL, PLSQL , .NET , React, Angular, JAVA, Python, SSRS/SSIS , Business Intelligent Development for my company to train my consultant. Online and Onshore are welcome to contact me. Class will start in month or month and half later in mid May. I would need instructors in M/W/F/S and Sundays ..Flexible hours on weekend. After 5 pm cst in Week Days
Hi Sk A., I noticed your profile and would like to offer you my project. We can discuss any details over chat.
Hi, I am looking for TSQL Developer, who has experience with SQL 2014,2016, 2017, Powershell, TSQL, Performance tuning. it is urgent requirement
As discussed in chat.
Develop high-quality database solutions. Use T-SQL to develop and implement procedures and functions. Review and interpret ongoing business report requirements. Research required data. Build appropriate and useful reporting deliverables. Analyze existing SQL queries for performance improvements. Suggest new queries. Develop procedures and scripts for data migration. Provide timely scheduled management reporting. Investigate exceptions with regard to asset movements.
I need someone with experience of deployment of a website in AWS EC2 or LightSail. He should also have experience with NGINX and should have deployment experience of deploying a .NET Core application in LINUX machine using a docker container and RDS. Should have experience of IIS deployment, SSL configuration, DNS configuration, FTP configuration Ability to convert TSQL queries to MySQL is an added advantage
Help collect learning / study material for data mining. Data sets and instructions for solving data mining challenges within those datasets. Focus on data wrangling (common parts), Validation, mining algorithms. In: + Excel + SQL Server (SSAS in Visual Studio) Extra plus if you involve: MDX & TSQL.
On-going development for existing projects. English a must!
