How to create star schema in sql server jobs

...seeking an experienced Dynamics CRM 365 developer with Virtual Entity expirence. I have got few virtual entity tables link to Azure SQL database. One table has got 1:M relationship with another. In my form, I am trying to populate custom view in lookup field of this virtual entity lookup. I tried it in two different ways but it doesn't work. Method 1: I created fetchXML and link two tables, I get the result but issue is records don't filter in query. I tried this method with advance find as well, and again records don't filter according to criteria for virtual entity. in Advance find, if I try to select the columns from second table then I get error. Methos 2: I tried to create Fetch ...

...project written in Python, SQL Server, and MongoDB, I am currently facing a challenge. A logical error in the code is causing a bug, and I need an expert to fix it. High-level summary of the code- 1. Fetch records from SQL server ( total 680000 records) 2. Apply face recognition on each record 3. Insert the response from step 2 in MongoDB along with other data from the SQL server Issue- The existing code is currently doing steps 1 & 2 and performing step 3 at last when face recognition is applied on all records. Due to this it step 3 is waiting to complete the step 1 & 2. Expectation- After fetching each record from SQL server, the code should apply face recognition and then stor...

It’s Urgent! We need to write a shell script It’s too simple and not more than 2-3 hours job if candidate is good at shell script. It’s a small project but if we are satisfied we will give you more project in future . You thave to automate these task , Now i am doing this manually ---------------------------------------------------------------------------------------------------------- have to accept the subdomain as input and from backup Activate 2. change the name of to 3. add the alias domain 4. Add the prt for and cname record for @ cloudfare , now i do manually 5. create the ssl for and bdomain

Are you a Vesta Panel expert? Ok Then help me upload a simple 1-page WordPress site to my server & connect to the domain name Hosting is Digital Ocean with Vesta Panel

We need Oracle resource who are expert in below skills and having 8+ years of exp. Mandatory Skills: *• Need candidates with extensive experience in data migration across CRP, SIT, UAT, and GoLive phases in Oracle Fusion ERP implementation, utilizing ETL tools. * Experience in SQL Server, T-SQL, and SSIS Job Responsibilities: Data Extraction: * Extract data from various source systems, including flat files, spreadsheets, legacy databases, and external APIs. * Develop and optimize SQL queries and scripts for efficient data retrieval. Data Transformation: * Perform data cleansing, validation, and transformation to ensure data quality. * Convert data from source formats to Oracle-compatible formats. * Apply business...

I'm looking for an experienced cloud engineer who can resolve a server downtime issue I'm experiencing with my OVH Public Cloud. Key Responsibilities: - Analyze and troubleshoot the root cause downtime - Implement a robust solution to prevent future occurrences - Ensure that during downtime, website and database access functionality is restored promptly Ideal Skills and Experience: - Proven expertise in OVH Public Cloud management - Strong troubleshooting and problem-solving skills - Understanding of website and database access best practices - Excellent communication and teamwork abilities I'm open to suggestions on how we can best approach and solve this issue, so if you have ideas, I'd love to hear them.

I need a seasoned VBA and Macro expert to assist me with the creation of an interactive dashboard for a small project. The main tasks include: - Development of VBA code to automate repetitive tasks. - Creation of custom functions to enhance the dashboard's functionality. - Ensuring the dashboard can generate reports effectively. I'm specifically looking for someone with: - Proficiency in VBA and Macro. - Previous experience in creating interactive dashboards. - Ability to generate reports through coding. - Good communication skills and attention to detail. If you're confident in your VBA skills and have a good eye for visualizing data, I'd love to discuss this project with you.

I'm in need of a professional with expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Products, and Orders. - Write queries: I need you to write SQL queries that will allow me to seamlessly interact with the database. Specifically, I'm looking for someone who can: - Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficienc...

I'm in need of a professional with expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Products, and Orders. - Write queries: I need you to write SQL queries that will allow me to seamlessly interact with the database. Specifically, I'm looking for someone who can: - Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficienc...

...styled as a TikTok ad - The video should be highly visual and energetic, capturing the attention of viewers and highlighting the value and functionality of the extension - The main functionality of this extension is to extract leads from Google Maps related to businesses for cold-calling in SMMA (Social Media Marketing Agency) Ideal Candidate: - Prior experience creating TikTok ads or other social media marketing content - Strong understanding of video creation, especially for software products - Ability to creatively and effectively showcase key features of a Chrome extension in a short, engaging format - Familiarity with SMMA and lead generation would be a plus Please include samples of your previous work, especially if you've created videos f...

I'm looking to upgrade my current system, perhaps keeping the current Opencart (V1.52) system and working with it where possible... unless its deemed a rebuild is cost effective. The opencart system we use has been added and modified over time, hence it is not possible to simply upgrade to a newer opencart version. The business we operate in is parts for coal and wood fires, this is a business that is reducing overtime, due to environment issues, however, the stove market has recently had a mini boom due to gas prices being high with a record number of new stoves being sold over the last 3 years (we do not sell new stoves, just the parts for these stoves). We expect to see at least another 5 years from this business. We have been to...

Hello, We have a web project which consists of creating an online sales store (classic) with the possibility for certain products to personalize the textile in 2d The particularity is that we want sports clubs to be able to register as a club, and users, by activating options, identify themselves as being a member of a each user to propose their designs and make them available in the configurator with a dashboard to see their sales. We also want to allow users to become are exclusively made by the main store.

Create flutter application for send trade signal

Turkish Recording Project We have a project, that needs Native Turkish speakers, we will give you the text, and you need to record 110 short sentences. you just need to open the platform link, to read our text and record it, it's a very easy job. 1. You will need to record in a quiet place without loud background noise. and without an echo. 2. Each person Price is 4$ for 110 short sentences record. If you are interested please let me know sure. I will contact u. A Good Opportunity For New Freelancers For taking 5 Star Review after their completion of the project. Thanks :

...seasoned AWS developer experienced in setting up advanced server security. Key Responsibilities: - As I've got an EC2 server in place, I am seeking to fortify the security measures associated with it. - Although I've not finalized the specific measures, your expertise and suggestions in IAM, Security Groups, or Network Access Control Lists (NACLs) would be greatly appreciated. - Emphasis on ‘Advanced Security Setup’ – a step beyond basic security – to comprehensively protect server's integrity. Ideal Skills: - Proven experience in AWS server security, specifically EC2. - Proficiency with IAM, Security Groups, NACLs. - In-depth AWS server security acumen. I'm exci...

Need help with a simple task that involves writing simple SQL statements and completion of the relevant ER diagrams. This task is in the context of simple data analysis. To be completed within 2-3 days.

I have a running Python file, who parse data from xml and insert it into sql server. Currently it isnt working. need an expert in python, who can fix it and upgrade few things as well.

I'm in urgent need of skilled professionals with experience in MySQL and Digital Ocean recovery console. My MySQL server is locked and I require assistance in exporting a SQL file. The exact cause of the server lock is not currently known but it might be due to server resource overload or a potential security breach. Required Skills: - MySQL - Knowledge of Digital Ocean's recovery console - Server management The main objective of the task is: - Successfully export the locked SQL file for further analysis and resolution - Provide insights on the potential cause of the server lock for future prevention. Experience in server management, specifically in handling locked servers, will ...

I am seeking a skilled database developer to convert my .frm and .idb files into a SQL file. The original files are in MySQL format. Key tasks will include: - Conversion of .frm and .idb files to SQL format. - Exporting these converted files to mysql server. I did not specify any special properties or features of the .frm and .idb files that need to be preserved, but will appreciate a careful and diligent conversion to ensure no data loss. The ideal candidate for this job would have: - Extensive experience with MySQL 5.7. - Proficiency in SQL file conversion. - Strong knowledge of database export practices. - Keen attention to detail to ensure data integrity.

...have a better chance. Monthly salary will be considered to calculate the hourly rate and the time needed to complete different task documents, on an agreed fixed price. The best offers with the right experience will have the opportunity to work with us on a long-term basis. Also, Good prospects for the right developers, based on the performances evaluated over a period of time, once you established your skills. Need to provide the changed code details and sql queries if any at the end of each sub-task, with the changed code line numbers. Unlimited Revisions are needed. Any bugs created due to your own developments are to be fixed on free of Charge. Recruitment is for a long-term big project as such, all the developers are subject ...

I'm searching for an expert in Microsoft Power Automate to set up 3 automated workflows as an intitial test: Flow 1: If a new email is received use this as a trigger to check if a new email is in another outlook 365 folder, if there is, save the attached excel file as a csv and rename the csv file the date of the email in YYYYMMDD format and save to a folder in onedrive for business. On successful completion send an email confirming success. >If there is no new email in the other outlook 365 folder, email our info@ email address notifying that it is not present. Repeat the checking process 2 days later until successful Flow 2: If a new email is received use this as a trigger to check if a new email is in anot...

...need a focus-driven developer to build a web application for my travel agency. The purpose of the application is to implement a backoffice system for managing bookings. The functionalities I'm aiming are: - User needs to enter details like Agency name, pax name, mobile number, pick up location, pick up time, date of flight travel, flight departure time, drop off location - Every day 3 buses are departing to airport. Say morning 8am, 1pm and 8pm. We need to get auto emails based on this bus timings of scheduled pax list and they take manually report with date/time filter. Ideal Skills: - Strong background in web application development - Experience in booking system or related is a huge plus - Fluency in database manageme...

Job Description: I am looking for a freelance writer to create high-quality, original content. The ideal candidate should have excellent writing skills and the ability to produce engaging and informative content on a variety of topics. Responsibilities: Research and write original content as per the given topics. Ensure all content is free from plagiarism. Meet deadlines consistently. Requirements: Strong writing and research skills. Ability to write in clear, grammatically correct English. Experience in writing for blogs, articles, or similar platforms.

I am in need of a professional with experience in setting up Rocket Chat Servers. This project involves creating a cloud-based server with capacity for 10 users mainly focusing on real-time messaging capabilities of Rocket Chat. I am open to other chat messaging services. I want a private, cloud based instant messaging service with end to end encryption. This will include you setting up the cloud service on Building the services, and providing instructions on how to add users. I will provide accounts and give access. Key Responsibilities: - Building a cloud-based Rocket Chat server - Ensuring the server supports Real-time messaging feature Ideal Skills: - Familiarity with Rocket Chat or similar messaging platforms - Experie...

I'm currently in need of an experienced full stack developer who is proficient in both JavaScript and PHP. Key requirements: - Strong skills in front-end development, specifically using JavaScript. - Proven experience in handling backend development with PHP. - Knowledge of SQL is also important. - While not a strict requirement, familiarity with JavaScript frameworks such as React, Angular, or Vue and PHP frameworks like Laravel or CodeIgniter would be a big plus. - Experience with SSL implementation is a must, but there are no strict preferences as to the type of SSL to be used (Wildcard or EV SSL). Being able to pick the right SSL depending on the project’s needs will be part of your responsibility. If you're the...

i need someone who are good about create any projects with python especially checkers emails to use for marketing

create a telegram bot that analyzes new meme coins/shitcoins to identify whether the token itself is a scam or real, analyze the contract, the telegram group, and give a rating from 1-100 about the risk of investment, etc. AND the bot should also show Block 0 snips (Approval)for those who are ready to snipe! before the coin is launched

As an IT professional, I'm looking for an expert in Microsoft's Exchange Server 2019, as I need it set up for several organizations. The server setup must allow client access through Outlook on the web, Exchange ActiveSync, and Outlook Anywhere (RPC over HTTP). Ideal Skills and Experience: - Proficiency in Microsoft Exchange Server 2019 - Previous experience setting up servers for multiple organizations - Familiarity with various client access setups including Outlook on the web, Exchange ActiveSync, and Outlook Anywhere (RPC over HTTP) This task involves complex server configuration so only those with corresponding expertise should apply. This job would entail making sure that setup and client access is seamless for each organization.

...alert me via email whenever any changes have been made. Key features will include: - Targeting application settings in the registry. - The ability to detect any changes to said settings. - Sending an email alert every time a change is detected. Freelancers with experience in creating similar systems or possessing a deep understanding of the workings of Windows OS will be preferred. Additional Details: Monitor Regedit for the changes related to the policies applied through Service. Send notification to server, send mail to a group, in case of change not applied through Service. 7. Logs needs to be updated to SQL via a API POST call (this endpoint is developed you need to call this Only) and k...

...expert to plan, scale, and execute the setup of a Windows Terminal Server to accommodate 50-70 users. The task is expected to be completed within 1 - 3 months. Key Responsibilities: - Plan and execute the setup of a Windows Terminal Server for 50-70 users. - Ensure the server is scalable for potential future growth - Implement best practices to guarantee system performance and security - Provide guidance on user access and permission management Ideal Skills and Experience: - Prior experience in setting up Windows Terminal Servers for medium to large user bases - Strong understanding of Windows Server and Terminal Services - Proficiency in planning and executing Windows Server setups - Ability to...

Please Sign Up or Login to see details.

I am seeking a coder with advanced skills in working with Chrome Extensions and HTTPPUT method. The primary task for this project will be to modify the request payload of the HTTPPUT method. The chosen freelancer needs to: - Replicate the payload and send it to my local server. - Implement modifications to the payload, specifically updating existing values rather than adding or removing data. - Focus on personal details within the payload for these updates. Proficiency in JavaScript, Chrome Extension Development and HTTP methods is ideal. This task will require a keen eye for detail, as the modifications are sensitive due to the focus on personal detail fields. Ability to uphold confidentiality is also important.

I need a top-notch video editor to create a visually stunning, cinematic trailer for my Fivem Server game. The trailer should be between 1-2 minutes in length. The focus should be on highlighting the unique server features that distinguish the game. The ideal freelancer for this project would possess: - Skills in creating high-quality, cinematic trailers - Experience in promoting game server features effectively - Ability to tell a compelling story within limited time Your mastery of visual storytelling will help in capturing the unique aspects of the server, ensuring that every second of the trailer engages viewers.

Im seeking a skilled Full Stack Developer to join our team in building a local freelancer platform. The platform will connect job seekers and posters, facilitating the posting and bidding of jobs, as well as managing project progress and payments. The ideal candidate will have expertise in both front-end and back-end development, with experience in TypeScript frameworks for server-side rendering and React.js or Vue.js for web development, as well as React Native or Flutter for mobile app development. Responsibilities: - Develop user authentication and profiling features, including sign up, basic details collection, and user categorization. - Implement job posting functionalities, allowing users to create detailed job listings with prompt...

I'm currently in need of a freelancer who can assist me in switching my email server from its current service to Gmail on my FreePBX13. Key Responsibilities: - Change email server from current "other" service to Gmail - Ensure successful delivery and reception of emails on new server - Maintain FreePBX13 system integrity while making modifications Ideal Candidate: - Experienced with FreePBX13 and Gmail - Has past work examples related to changing email servers - Has superior troubleshooting skills in case of unexpected issues During your bid, please detail your relevant experience. Experience with FreePBX13 and Gmail is essential to carry out this task effectively.

...goal is to utilize the referenced link to develop an AWS CDK (Cloud Development Kit) application using TypeScript. This application will deploy a monitoring solution for ECS (Amazon Elastic Container Service) stopped tasks. Our main focus will be on capturing and querying exit codes in CloudWatch Logs, so this solution will provide comprehensive details about the task, including the 'exit code' and 'reason'. Deliverables: - TypeScript codebase for the AWS CDK application. - Deployment documentation with step-by-step instructions.(readmeFile) - Guidelines for querying CloudWatch Logs to retrieve ECS stopped task information. - Optional: Recommendations for future improvements or optimizations. Completion Criteria: -...

create logo for coffee company

I need to integrate Tableau with my SQL database, and I'm looking for a skilled freelancer to handle this. Key Responsibilities: - Setup Tableau integration with SQL database - Ensure seamless connection and data flow between the two - Deliver a functional, user-friendly interface for data visualization Ideal Skills: - Strong experience with Tableau and SQL - Excellent understanding of database management and integration - Ability to create interactive dashboards - Proficiency in optimizing data for Tableau visualization This project will require a keen eye for detail and a commitment to delivering a quality, tailored solution.

I'm currently facing some installation issues with Tableau Server. I'm looking for an experienced freelancer who can resolve these issues for me.

I need an IT engineer to install ThingsBoard Community Edition on my Windows server. Key Responsibilities: - Install ThingsBoard Community Edition on my Windows server. Ideal Skills and Experience: - Proven experience in server administration, especially Windows. - Familiarity with ThingsBoard platform or similar IoT platforms. - Ability to troubleshoot and resolve software installation issues. - Strong problem-solving skills and attention to detail. Please apply if you have the right skill set and availability for this project.

For your quote to be considered please start with "I am a Cisco Professional" I'm looking for a professional who can assist me in installing Windows Server OS on my Cisco UCS C220 server as soon as possible. We have the server and have configured the LSI Virtual Drives when we try to install the OS we get Driver IRQL error with "What Failed " For someone who is experiences this should be a quick one

Project: Development of a server and API for integration with an external distributor API and providing functionality to partners through a proprietary API. Objective: To create a reliable API gateway integrated with an external distributor's API, automating the processes of topping up gaming accounts, retrieving information about available games and pricing, and offering services to partners for their own use. Main Tasks and Requirements: Server Development: Setup and support of a server to handle API requests. Ensure continuous operation of the server and fast processing of requests. API Development and Implementation: Integration with the distributor's API to perform top-up operations, retrieve informati...

We´d like help with creating a nice powerpoint. We alreday have a draft of a powerpoint and we also have a word document containing the things we´d like presented. Based on that we´d like someone who´s able to create a nice selling powerpoint based on this.

Create a form in Excel following the pre-determined options. The results of the answers must be recorded in a second tab

I'm currently experiencing some problems with SQL Server 2019 regarding a synchronization error in my Snapshot Replication model. Present issue: - Synchronization process follows an error. Desired solution: - Ability to correct the synchronization errors to allow for smooth data replication. Ideal Skills: - SQL Server 2019 expertise - Solid understanding of Snapshot Replication model - Proven experience in troubleshooting synchronization errors. I'm seeking assistance from someone with these expertise, who can provide a quick and efficient resolution to this problem.

Hello, I host a game and I would like to send an email to all my old members. There are more than 1 million emails, some are very old from 2005 to 2024, so there will be many bounce emails in between, but I still want to reach out to my old players. I am looking for someone to set up a VPS with a mail server for me. Regards

I'm in need of an experienced Vue.js developer to assist with front-end development and implementing dynamic components. The project specifically involves working with Vue 2 and does not require integration with external APIs. Key Responsibilities: - Front-end Development: You'll be tasked with designing and developing the user-facing aspects of the application. - Dynamic Components: Implementing dynamic components to enhance user experience and application functionality. Ideal Skills and Experience: - Proficient in Vue.js: Extensive experience with Vue 2 is a must. - Front-end Expertise: Strong background in front-end development, with a focus on user interface design and development. - Dynamic Component Implementation: Proven experience i...

... The error states "SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'entity_id' in". Ideal Skills and Experience: - Proven experience with Magento 2 development - Strong understanding of cron jobs and how they work within Magento 2 - Familiarity with debugging and resolving SQL integrity constraint violations Please note that the specific table causing the error was not identified. Your expertise in this area will be crucial. I am using Magento 2.4.6-p4 CE and I get the following error after every order. The job indexer_update_all_views scheduled at 2024-04-15 10:31:03 failed with the following error message: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'entity_id' in where clause is ambiguo...

- XML Experience with Layout Creation in Schema St4 by Quanos

Norway Recording Project We have a project, that needs Native Norway speakers, we will give you the text, and you need to record 1191 short sentences. you just need to open the platform link, to read our text and record it, it's a very easy job. 1. You will need to record in a quiet place without loud background noise. and without an echo. 2. Each person Price is 50$ for 1191 short sentences record. If you are interested please let me know sure. I will contact u. A Good Opportunity For New Freelancers For taking 5 Star Review after their completion of the project. Thanks :