Tsqldela

- poslovna inteligenca na Microsoft tehnologij tako on-premise kot v Cloudu - Programski jeziki: DAX, MDX, C#, TSQL, SQL, python, spark

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

write TSQL in Microsoft sql server for 3,4,5 problems tasks as mentioned in this document Deadline: today in few hours

Prosimo, vpišite se ali se prijavite za več podrobnosti.

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.

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...

Prosimo, vpišite se ali se prijavite za več podrobnosti.

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