Tsql jobs
Hi, I am looking for TSQL Developer, who has experience with SQL 2014,2016, 2017, Powershell, TSQL, Performance tuning. it is urgent requirement
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!
Require a state of the art training content for Power BI. It should cover SQL,TSQL, SSIS and Power BI modules from beginner to advanced level. Looking to have a content which is very easy to understand with real time datasets, problem statements and scenarios. Need one major project with real time data for SQL, one small project for SSIS and One major project for Power BI to fulfil hands-on requirements of the course content with devised assignments as course progresses.
Hello, We have a working Django, Graphene GraphQL backend for almost all our models. At the front we use TypeScript, React, Material-UI, GraphQL Code Generator, React-Query. The layout (login handling, menu, etc.) is working OK. All the code is on GitLab, and we use gts (google typescript standard), lint-staged, and husky. We would like to hire an expert on that stack to create CRUD pages ...React, Material-UI, GraphQL Code Generator, React-Query. The layout (login handling, menu, etc.) is working OK. All the code is on GitLab, and we use gts (google typescript standard), lint-staged, and husky. We would like to hire an expert on that stack to create CRUD pages and form handling on those pages (we use Formik so far but we are open to recommendations) Please start your bid with &quo...
• University degree in Computer Science or other related fields preferred; equivalent experience will be considered; • Over 5 years’ experience in .NET Stack; • Strong knowledge in C#, ASP.NET, .NET Core, Entity Framework, Web API, Web Services, MVC; • SQL, TSQL, MSSQL (Microsoft SQL Server); • Knockout or Vue.js; • Knowledge of OOP patterns and best practices; • Written and verbal skills in English; • Dedicated, reliable team player with a high sense of responsibility;
• Responsible for different Software Development Life Cycle (SDLC) processes included Analysis, Design, Programming, Testing (Unit & System) and Documentation • Responsible for Data Analysis, Data Mapping between multiple applications as part of integration process, analyze data between m...modules and make changes to the code improve the performance and prepare SQL Scripts to fix production data issues. • Develop and maintain technical architecture for the application. • Participate in Vision, Stakeholders, User story, Sprint review and scrum meetings for Design and Analysis of new projects. • Developing data model Diagrams, Microsoft SQL server database design including PLSQL / TSQL packages and Stored Procedures (Using MS SQL Server 13) for execut...
Looking for someone who has knowledge for Power BI and TSQL.
What I need to do is find the Day of the Week and the Month within the Date Range of the data and return to me that value. I have the first part of the procedure; USE [Test-DB] GO /****** Object: StoredProcedure [dbo].[proc_parseXLRule] Script Date: 7/7/2021 9:08:01 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[proc_parseXLRule]( @OldRule varchar(1000), @NewRule varchar(1000) output ) AS BEGIN SET NOCOUNT ON; --SET @OldRule= '10JAN-31JUL/XR:P$100|90 DR:P$50~01AUG-20NOV/XR:P%50 DR:P%25~21NOV-09JAN/XR:NR' DECLARE @NowDay VARCHAR(2) DECLARE @Today DateTime DECLARE @NowMonth VARCHAR(3) SET @NowDay = RIGHT('00' + CONVERT(NVARCHAR(2), DATEPART(DAY, GETDATE())), 2) SET @Today=getdate() SET @NowMonth=UPPER(FORMAT(@Today,'MM...
The existing stored procedure needs to be modified with additional conditions.
Hi All Looking for expert in below skillset Tech Stack: Java Full Stack; Testing, CICD pipeline, AWS, microservice architecture, general backed development, JS frameworks, node.JS/react.JS, Mobile - react native Backend DB: PostGres, Redis, DocumentDB (similar to Mongo), DynamoDB, Kafka, Clojure, PL/Sql, TSQL, PLpgSQL Let me know if you have experience in it
a. Stored procedure for loading all the databases directly from a csv/text file from a folder by date timestamp. So assuming there are multiple files the stored procedure will only load the most current file by table b. Stored procedure to load incremental/delta load .. So assuming the changes are minor the job will only load that part and ensure the changes is properly tracked. So the job will load a staging table before the final table c. Stored procedure that capture all changes. d. SQL to create an aggregate table on the diagram - Derived table from all tables.
I have a ASP.NET - MVC project created in C# / TSQL / Bootstrap The project works as required, no problems, BUT i need to make some modifications to some areas Some data entry popups need modifications Some data PDL created with itext sharp also need modifications We need to have online meeting with anydesk and work on my computer to see and modify the issues
Apriso Flexnet training I need a training for config / admin at Flexnet Apriso MES. This is something I want to pay myself to expand my knowledge; I don't really need at this time. I don't need an official certification, but if possible a place to practice; documentation, or any material. Please share your training plan with me, what do you know that can be shared with me. Customization, TSQL/PLSQL, Orders management, etc
Technical consultant who is proficient in .NET Core API & SQL datab...hand-coding using Visual Studio Code, test them via Postman tool, implement and optimize stored procedures and functions using T-SQL • Customize API development using .Net Core considering re-use & caching for optimized performance • Database designing and ensuring their stability, reliability, and performance. • Debugging API issues by taking SQL Trace & fix the root cause of the issue in .Net / TSQL • Development of Integration touch points using API / Web services • Would require to learn in-house development tools for development of APIs • Profile server resource usage and optimize and tweak as necessary • Prepare documentations and specifications • Collabor...
Knowledge in TSQL on conversion of stored procedures(ascii) to unicode. This might include the field, String , conversion testing. what we need : Train a resource on this Task. what you get : Compensation of whole project(5k-10k)
we are searching C# asp.net webforms developer to support existing hospital management software and adding new features skills required 1.C# winfors including TSQL reports Protocol
...Applications. Have hands on experience in CRM domain. Experience in Software Development Life Cycle (like Analyzing Designing, coding, testing, bug fixing and customizing) and Implementation of Client/Server applications using C# and SQL Server with N - tier development environment. Experience in SQL Database design, maintenance and performance tuning, developing SQL queries/scripts, stored procedures, TSQL using SQL Server 2008. Strong hands on experience in manual testing and unit testing. Experienced working in Azure environment. Good understanding and basic experience on jQuery and JavaScript. Experience in creating Rest Services using ASP.NET Web API and C#. Experience inWeb internet languages like XML, HTML and CSS. Expertise in developing Multi-Tier Application Development...
I am looking for a experienced ASP.NET COREdeveloper who can develop the UI & connectivity to POSTGRES db in ASP.NET core for 6 screens with CRUD facility ,Business logic layer is already there in the form of TSQL .
Hi Looking for some expertise in TSQL SP . I have the SP ready but need to get results in the email. ASAP
need help regarding tsql script fix and do changes accordingly for creation of sql job.
I need a Azure SQL server DBA and developer to write some tSQL codes and send alert on my email. and also helping with some DBA and developer on day to day basis.
I am searching asp.net webforms developer with 3 experience in webforms report Tsql,stored procs,triggers must work on remote for the first 10 hours
...by the supervisor supporting enterprise infrastructure. Handle daily maintenance tasks of supported platforms to ensure contract performance requirements for availability and support is met/exceeded. Deliver quality products across multiple technical disciplines when working with cross functional group requirements. SKILLS Must have strong troubleshooting skills Proficient with ASP.NET, C#, SQL/TSQL, HTML/XHTML, CSS, jQuery and similar web application technologies. Proficient in JavaScript, VBScript, PowerShell and the Windows Scripting environment in support of system level operation maintenance and workflow tasks. Proficient in Microsoft Visual Studio and familiar with Microsoft Team Foundation Server for development. Experienced working with Microsoft Active Directory, Inter...
...Responsibilities: • Responsible for design, development, and implementation of solutions to exchange data using the required ETL tool, Informatica Powercenter. • Strong verbal and written communication and shall be able to work directly with client and business to understand the domain/requirements. • Strong in DWH concepts and good understanding of modern analytics tools and processes. • Strong in SQL/ TSQL/PL/SQL, writing effective SQL codes and stored procedures. • Experience in DBMS like SQL Server and knowledge of know-hows of the same and troubleshooting experience. • Develop new code and/or support operations, maintenance, and enhancements of existing code • Conduct multiple levels of testing including unit, system, integration and perf...
...racehorse) will have its parents, grandparents, and so on through to 10-12 generations of its ancestry. We require some processes that will allow us to create calculations on these relationships and the family pedigrees. Most of these calculations already have some source code, but it is in Fortran or Python. I am unsure if it is best to rewrite this code for computational efficiency, or create C#/tSQL bindings to the code and use that. A freelancer with good knowledge of FORTRAN would be preferred. If you can have a look at the detailed description below and give me an idea of what your approach would be in terms of development and what the hours required would be, it would be appreciated. A full description of what is required can be found here -
I need you to develop some TSQL Script. I would like this software to be developed for Windows using SQL.
Thoughtspot ( connections with servers, pinbords, TSQL, pentaho jobs) Asg rochade Becubic
just very small project write code with C# , HTML, TSQL, MySQL, within 1 day small budget If you interested, Pls contact
TSQL procedure will accept a birthday date and display the age of the person. If the date is in the future or date format is incorrect, your procedure should display an error message.
Project Objective: 1. Build a data processing command line application. The application will scan a large collection of json files, read information and store the information in a database (the database provided (not built by the developer)). 2. Maintain a windows C# .NET web scrapping windows app to conform to changes in the target websites. Skills needed: - C# .NET, Entity Framework 6, TSQL (Sql Server) - Well versed in object oriented programming - Good technical English. Working conditions: - The developer will be working in our environment (a developer VM) remotely and will have to upload changes to CVS daily. - Advice and guidance will be provided. Upon successful completion further projects will be assigned. Please send a description of your relevant skills/experience.
Write a tsql to read data in json format from API and Write it sql table 2008 version
We require a document transmittal history report to record the versions of document despatched and the recipients they were despatched to. The report is to be produced using Microsoft Report builder (SSRS). Core to the report are the Document and Recipient cross tab matrix. The document matrix shows the vers...The Recipient records the method used to despatch a document for any particular document i.e. “e”=email. Visually, It’s important that unpopulated columns are still printered to fill the page out. See example The number of documents, transmittals and recipients may exceed 1 sheet so page breaks are required to accommodate all 3 scenarios. We have attached a SQL backup database with sample data + tsql for the header document and recipient matrix together with...
Exp level 5-7 Yrs Extensive experience in QuickBooks integration Experience in the repair database with Quickbooks system Familiarity with QuickBooks Online and QuickBooks Desktop, multiple versions Foremost - Advanced SQL database experience, so you can fully understand tables and business logic/ More importantly - proper TSQL so we do not impact the Database Server. API Development experience needed for QuickBooks Online. QBXML Experience needed for QuickBooks Desktop CFML Scripting if you keep on the platform we built it on. JavaScript would be beneficial as well.
CLARIFICATION: This project is pure JS using the package, html (for proof of work only) and TSQL. NO server side development is required aside from the SQL query itself and the output should have no other dependencies. We are a small business implementing an internal SAAS app with Highcharts. We require a Highchart Organisation chart as per the example at: Other chart properties required: 1. Responsive to allow full page expansion 2. Two box types: Unit and Position 3. Drill Down by Unit level (Co and Division with Departments Listed-->Dept Detail with Sections Listed-->Sect Detail) 4. Unit Box content: unit name, person in charge name, total positions/ filled positions/vacant positions 5. Position Box content: position name
...contractors, 8-15 USD/hour rate, depending of the project. Responsibilities: ● Design and develop high performing dynamic end-to-end web applications ● Collaborate with the CTO/product manager, and other software developers to implement solutions ● Help write, verify, and modify procedures and documentation Required Skills: ● Programming : Java || Python || C# || PHP ● Relational Database: SQL && (TSQL || PL-SQL) && (Oracle || MySQL || Postgres || MS SQL ) ● Other: NoSQL || Elastic Search || DeepLearning || …. ● Web : HTML5 && CSS && JavaScript && (Angular || Vue|| React ) ● Web : HTML5 && CSS && JavaScript && jQuery && (Angular || Vue|| React ) ● Tools : Git && Jenkins && (Maven ||...
I'm looking for tsql developper to help me with conversion between database ,link server, utility to improve it s not one shot project
...system and user documentation • Input into strategy and standards around the Business Intelligence portfolio • Documenting systems to high standards in English • Experience in MS Azure Data Factory, Data Lake Store, Databricks, and Analytic Services; which is the focus of a new Data Warehouse implementation project • Design and implement Data Warehouse data modelling with old and new techniques TSQL, Extract, Transform, and Load (ETL) , SSIS, Extract, Load, and Transform (ELT) , PolyBase , Hadoop, Cloud PaaS. Azure Cloud MSSQL, On prem MSSQL • BI & Analytic Tools (Cognos, PowerBI, SSAS) • Web base programming skill HTML, client scripting (Java script), Server scripting (.Net C#) basic level. • Experience of data analysis • Experience of...
I setup SQL audit and dumping data into this location: O:AuditData1. Now I need to load data into SQL table, AuditInfo. I need to run the following query in SQL job everyday. The following script works fine. Modification needed, so when it runs every day, it will load only the previous day data into SQL table. SELECT distinct * FROM sys.fn_get_audit_file('O:AuditData1*.*', DEFAULT, DEFAULT) INSERT INTO Test.[dbo].[AuditInfo] ( event_time ,action_id ,server_principal_name ,server_instance_name ,database_name ,schema_name ,object_name ,statement ) SELECT event_time ,action_id ,server_principal_name ,server_instance_name ,database_name ,sc...
Hi! I need to make a query and stored procedures with about 12 parameters. Thank you!
goal, -to create a query to query a sql-server backend table -to create a ssis job to export the data in the query result to a csv file for the query, the goal to pivot/flatten a table column values, reference a lookup values, to rows. As shown in the picture, with the table and configuration, to produce the csv file as export. Urgent requirement, sooner the better.
...technologies and tools, as well as a love of testing solutions from the ground up as well as a potential of becoming a Tech Leader in our company in the future. Responsibilities & Requirements: - 5 years of experience with C#, Versions 3.5+ - 5 years of experience with web development including ASP.NET. - 3+ years of experience with WCF & LinQ - Proven knowledge of SQL (Version 2008) with TSQL. - 5 years of knowledge of a broad range technologies and practices from different companies. - Experience with Large scale Databases as a plus. - Аbility to write read speak English in a good level - Background working in software gaming company- Advantage. - Deep understanding with Enterprise Library, Entity Framework, HTML5- Advantage. - Experience with ...
Need to hire 3 freelancers. There is no limit to how involved you can be in the deve...finding new ways of improving, so your opinions and innovations will always be welcome. Essential Technical Skills: • Cloud based application development • JavaScript ES6+ • Angular 2 - 9 architecture, Design Patterns and Best Practices • Application State Management (Redux) • Angular Material • TypeScript • Visual Studio Code • HTML/CSS • TDD Relevant Technical Skills: • agGrid • SQL Server/tSQL • C#.Net • HighCharts • Jira/Confluence • Gulp • NPM • Karma • Jasmine • Pug • Jest • Angular CLI A standard week is 40 hours over 5 full-time professional days (normally 9am to 6pm GMT including ...
