SQL Jobs

Actualmente en la empresa tenemos una Base de datos la cual se utiliza para insertar datos y realizar consultas desde Excel. La misma se encuentra alojada en un servidor con Windows Server 2008. ¿Que buscamos? * Optimizar la BD y las consultas que sea realizan a esta mediante excel. * Migrar la BD a alguna instancia en algun servidor Cloud (No poseo ninguna instancia contratada, necesitamos asistencia en esto también). * Necesito que los archivos de consulta en excel puedan consultar a la nueva ubicación sin problemas (ver temas de usuarios y seguridad). Es por esto que entiendo la persona además de tener conocimientos en SQL también necesitaria en Windows Server y Servidores. La forma de pago puede ser en $ o Criptomonedas.

Need help with working on sql server commvault backups.

Looking for a software developer who can develop a Patient management system for a small scale ayurvedic clinic. We have been using paper records till date. Following are the basic requirements - Should be secure and able to upload daily back up to our Gdrive - Functionality of PDF and email generation incase of prescription and case history - API from our website to the software in case of new query from site - Local data storage capacity - possible patient dashboard and reminders Brief would be provided to the selected bidder. All the best. Please send any demos if you have. Thanks

I have two tables, Sales and Revenue, which are the sales and revenue for each city. please see the screenshot of the tables I need a SQL Server query that gives today and MTD values: * Total number of sales in each city- Today * Total number of sales in each city- MTD * Total Amount in each city - Today * Total Amount in each city - MTD I need these 4 columns in one table with the city column. please see the screenshot of the result table I appreciate your help.

I have two tables, Sales and Revenue, which are the sales and revenue for each city. please see the screenshot of the tables I need a SQL Server query that gives today and MTD values: * Total number of sales in each city- Today * Total number of sales in each city- MTD * Total Amount in each city - Today * Total Amount in each city - MTD I need these 4 columns in one table with the city column: please see the screenshot of the result table I appreciate your help.

Database SQL developer needed urgently

My Sql Specialist for urgent task Small Task Budget 20AUD

We want to do logshipping between two of our Database server which are hosing few databases sized somewhere near to 1Tb. The sync between two server should be 30 min and not more than that.

Need a editable Web based Grid View/ HTML table/ Data table which can handle 50000+ records at a time with 10 columns and should be able to export to Excel/ PDF.

Create Power bi reports from ETL mssql with DAX query .

need to update one my sql table(feed) based on penname data and get id of table pens (id,penname)and update feed table with idenid

I want a one software which can get data from SQL or Access and generate data in selected format in excel and PDF. 1) Need a daily Report means every hour data can generate and store it in separate folder in excel or PDF 2) Report will generate automatically at night 12 am and save in separate folder 3) Report will also generate manually by select date to and from. Sample format and database is attached here.

I have two tables, Sales and Revenue, which are the sales and revenue for each city. please see the screenshot of the tables I need a SQL Server query that gives today and MTD values: * Total number of sales in each city- Today * Total number of sales in each city- MTD * Total Amount in each city - Today * Total Amount in each city - MTD I need these 4 columns in one table with the city column: please see the screenshot of the result table I appreciate your help.

I have two tables, Sales and Revenue, which are the sales and revenue for each city. please see the screenshot of the tables I need a SQL Server query that gives today and MTD values: * Total number of sales in each city- Today * Total number of sales in each city- MTD * Total Amount in each city - Today * Total Amount in each city - MTD I need these 4 columns in one table with the city column: please see the screenshot of the result table I appreciate your help.

Building power Bi report as per our specifications

I have an SQL code that need to be simplified. If you have any idea how to do it, hit me up.

Hola estoy buscando personas serias con experiencia en migraciones en sql server (QUE HABLEN ESPAÑOL) para realizar proceso de migración de una base de datos de origen a una de destino en sql server 2019. Parte de la data debe ser extraida de la base de datos y parte de archivos de excel. Adicionalmente por cada registro master existen un archivos (word, pdf, excel, xml) que deben ser organizados en carpetas predefinidas de acuerdo al tipo de documento. Los productos a entregar son: 1. Informe del proceso de migración, 2. SQL con los inserts a las tablas respectivas 3. Carpeta de documentos a las carpetas respectivas. Se entregara copia de la base de datos origen (3.3 GB), base de datos destino y archivos de excel. Adicionalmente copia a la carpeta donde se encuentran...

I am trying to compare budget numbers to actuals. I can get the NZ to pull the zero for the budget but I am missing some budget categories that have a value but actuals are currently zero. I am not sure how to fix the NZ expression in the query to pull all budget categories even when the actuals equal zero?

We're looking for a Timescale DB expert to initially provide some consultancy / advice for an internal project to migrate from SQL server to Timescale / Postgres. Afterwards we will need support with the migration itself.

Necesito una base de datos de venta simple en microsoft acces para alimentar informacion de clientes

Required back-end developer who has knowledge in asp.net core + swagger and web api. also has experience in entity framwork design

We need an expert in customizing iTop (). We have various small to medium tasks pending with an ongoing government project/client. The candidate should have at least 5 years of experience in customizing iTop and can work at least 4 hours a day to meet urgent deadlines. the budget expected is up to $25 depending on the candidate's experience, rating, and reviews. Knowing the Arabic language is preferred for the translation related tasks. Thank you

You will create a python file which inserts the SQL code in the attached .sql file () into a SQL Server table. The python code should be parametrized where in I can change the DB name, table name and the sql file name.

Quienes Somos Enjoy Be Digital es una compañía que proporciona servicios y soluciones digitales y que ayuda a compañías e instituciones a aprovechar al máximo el mundo digital en el que estamos inmersos. Hay que ver si ponemos algo más o lo dejamos así En Enjoy Be Digital, estamos un/a AZURE DATA ENGINEEER, con las siguientes tareas y requisitos: ¿QUÉ TAREAS VAS A REALIZAR?: Interacciones con clientes y análisis de requisitos. Modelado de datos y persistencia de la información en base de datos, utilizando herramientas ETL, para su posterior consumo utilizando la herramienta de visualización Generación de prototipos y presentación. Recogida y documentación de requisitos. Elaborac...

Need a senior developer with knowledge of mysql, azure, and angular to support the continued improvement and maintenance of a web application that’s in market.

I need a someone who can teach me and prepare me for Databricks Certified Data Engineer Associate Exam.

php .net sql related application

Walmart sales and inventory database setup using Walmart API

Necesito migrar una base de datos hecha en access 2003 .mdb , y sus relaciones a sql server. en la cual deben crearse el odbc y las credenciales para poder conectar. La base de datos estará en azure SQL . Se adjunta la Base de datos

No auto-bid!! I'm looking for a Laravel and Docker Expert. We need a developer to help get this project running. The developer must have the skills to lead this project successfully. At least 2 years of experience, proficient in Docker. UTC -3,+3available in time zone I am happy to have found a passionate freelancer.

Please write "I know SmartConnect and Magento 2" in beginning of the proposal for consideration for this project Hi We are looking for an individual or company knows how to build an integration between 2 platforms: SmartConnect and Magento 2 This projects will get the source data from SQL Server and write back data to Magento 2 using its Rest API. Knowledge of 2 platforms required.

Buscamos a un CONSULTOR DYNAMICS 365 CRM, con experiencia de al menos 2 años en puestos similares, para incorporarse en proyecto estable. Con estudios mínimos en Ingeniería informática o experiencia equivalente. Responsabilidades: - Análisis de requerimientos. - Participación en la elaboración de documentación funcional y técnica. - Parametrización y configuración de Dynamics CRM. - Desarrollos de Addons y personalizaciones en .Net Requisitos deseables: - Desarrolladores con al menos 1 año de experiencia en .Net o desarrollo Web. - Conocimientos basados en la WebAPI, C#, Reporting Services, Consultas SQL, Azure. - Experiencia en SQL Server Integration Server - Gestión de relaciones con ...

Hi I need someone with Mysql DB expertise of expert level and good experience.

Need MS SQL Project Query Updation and c# reporting

can you help me with our customer portal One of our developer was working on it but he is little it bit tied up with other projects so we need someone to finish few pending our portal was created on below firleds Sql backend Dot net Language C#

i am looking for a threat modeling tool based on django and sqlite DB, the tool shoud provide below requirments: - login/signup system based on a unique user and organization - collect information about business services and its criticality based on each organization/user. - generate a diagram showing all collected services and its criticality in a table and a chart. - collect infrastructure assets per each service, and assign each asset to a predefined category - Generate a DFD diagram per service based on collected assets at previous stage.

Need to developMulti platform (Windows, Android / IOS) Point of Sale RMS application which can be easily used by choosing the industry, such as supermarket, restaurant, salon, laundry, mobile showroom, pharmacy, etc. Centrally managed, Multi Branch usable, Multi currency, Accounts, HR, Inventory, and all basic modules.

Using Webhook --- Need to pull data from clickfunnels in Azure

Hello We need someone to do a migration from essbase to ssas. Thanks

Znalost JavaSE/EE a relačních databází. Angular znát není třeba, stačí vůle se ho naučit. Min. 3 roky zkušenost s komerčním vývojem. Znalost automatických testů. Dovednost domluvit se s kolegy anglicky (min B1). Java, Spring, Maven, Hibernate, RabbitMQ, Angular 2, JSP + další webové technologie, Relační databáze + SQL, JavaScript, jQuery, REST, XML a XSLT, JUnit / TestNG, Mockito nebo PowerMock, GIT, základy linuxového skriptování (Bash), Google Analytics / Google Tag Manager, testování zabezpečení webu

Hi I am looking out for a candidate for My Company System Upgradations which is based on MY SQL Frame work

We are searching for a long term relationship with an experienced Umbraco developer.

We need MySQL DBA who are expert in Databade and Query Performance and Tuning

SQL Performance tuning SQL Performance tuning

Vennligst Registrer deg eller Logg inn for å se detaljer.

Se requiere una persona con amplio conocimiento en php ya que se debe corregir aplicativo con error de conexión a la base de datos ya que se realizo una migración de base de datos a oracle en la nube

Se requiere realizar actualizaciones a un aplicativo desarrollado en ASP y con conexión a base de datos oracle , actualmente presenta un error de conexión que indica qué hay un error con el listener

To train Basic of SQL Server Administration on following task. 1. SQL Server installation 2. Backup and restore 3. Security ( Logins & Roles ) 4. Jobs & Maintenance Plan - resolving the Job related error 5. SQL Admin related routine task 6. SQL Admin command & codes 7. Health Checks Alerts : Creation and Notifications DB Suspect Event Alerts (023) Important Performance Counters, Alerts Log Space, Memory, Tempdb Alerts DBCC CHECKDB : DB Health Checks Allocation Errors, Consistency Errors DBCC ShowContig, Fragmentation Trace Flags and EstimateOnly DBCC Page: GAM, SGAM and PFS Consistency Errors : Cause & Solutions Allocation Errors : Cause and Solutions Log Space Issues and Log Rebuilds Memory & TempDB Issues, Solutions DBCC ShrinkDB and Page Restor...

DotNet developers required for development work in thenafter Host on server. Lots of good opportunities and financial benefits for DotNet, Xamarin, Android, iOS, Flutter developers after Launch. Website address- User emailid- @gmail.c Password- kaspersky Explaining 'Basic functionalities' link is below- Explaining 'development work to be done' videos links are below-

I need a searchable screen for any items within this database, yes I know I can make all col, searchable but like a drop down screen so I can and send to another workbook sheet. Very short duration only interested in people interested in working to do this assignment Timing is critical short turn around required