Sql server dba mediafirecomdela

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

Potrebujemo programerja za občasne dodelave v okolju Microsoft dynamics CRM, office 365 z bazo Microsoft SQL. Plačamo po urnih postavkah.

Izdelava aplikacija (za začetek working verzija - brez avtomatskih in EndToEnd testov) za prikaz: -Drevesnih struktur iz sql tabel -Logiranje -Shranjevanje aktivnosti na drevesnih strukturah -Poročila -Komunikacija med uporabniki Več v priloženem PDFju. Gre za osebni projekt - ne predstavljam podjetja.

We are migrating data from our current ERP system (that is stored in an SQL database) to Microsoft Dynamics Business Central Cloud. The source database structures is different than Business Central. We have been able to reverse engineer both the databases and create ERD models and DDL scripts. Also we know how to create Dynamics APIs and use AL to interact with Dynamics. We are looking some consulting advice on how best migrate the data into dynamics. For example looking for ideas how to best table and field match, what software tools to use, best proccess etc for this ETL project. Please describe any experience you have with ETL/migrating data between different systems. Please add the word DYMANICS123 to the start of your proposal so we can weed out automated responses. Thanks...

...created a custom Modpack on CurseForge and have a large map ready for it. I need an expert to set up a server using a paid hosting service. Key Requirements: - Set up of the server with the custom Modpack. - Loading of the downloaded map onto the server. - Implementation of daily automated backups. - Configuration of access levels for players (Limited access). - Allow all cheats in Minecraft server for players such as /gamerule - Allow players to customise the configs of mods used in the Modpack Ideal Skills: - Extensive experience with Minecraft server setup. - Familiarity with CurseForge Modpacks. - Knowledge of paid hosting services. - Competence in implementing automated server backups. - Ability to manage player access levels. Minec...

I'm seeking an experienced SQL professional to take an advanced Hackerrank SQL assessment on my behalf. The test evaluates various SQL skills and knowledge and is timed; with a duration of approximately 2 hours. Key Requirements: - Complete the assessment within the 2 hour time limit - Demonstrate expertise in the following topics: - Joins and Subqueries - Aggregations and Group by - Indexes and Optimization - Ability to write complex scripting queries Please note, specific SQL standards or databases are not focused on in the test as this question was skipped. However, a general understanding of various SQL databases would be beneficial. Ideal Skills: - Advanced SQL knowledge - Proficient in writing scripting queries - Ability to...

I'm looking for a skilled developer who can help me connect my Node.js server to a MySQL database in a Kubernetes environment. The connection should utilize a connection pool. - Connection Type: The connection between the Node.js server and MySQL should be established using a connection pool. This means that multiple connections can be reused, improving the efficiency of data handling. - MySQL Operations: The majority of operations will be writing data to the database. Therefore, experience in optimizing write operations in MySQL will be beneficial. - Kubernetes Service: The Node.js server will be exposed using the ClusterIP service. Familiarity with this service and its configuration is crucial. Ideal candidates for this project should have: - Proven experience...

I'm in need of a skilled web developer to assist with my site. The job will involve editing text, troubleshooting SQL database problems, and fixing various issues related to the website's functionality. Key responsibilities include: - Content updates: Primarily text alterations to refresh and improve website content. - Database troubleshooting: Identifying and resolving SQL problems that are affecting site performance. - Functionality improvements: Diagnosing and repairing various issues to enhance overall site usability. The ideal candidate will have experience in web development, database management, and content editing. A keen eye for detail and strong problem-solving skills are essential.

I am in need of a professional who can assist in registering my already established business and setting up a comprehensive database for global news distribution. Key Responsibilities: - Register my business with relevant authorities. - Create a database that caters for news distribution, bo...assist in registering my already established business and setting up a comprehensive database for global news distribution. Key Responsibilities: - Register my business with relevant authorities. - Create a database that caters for news distribution, both in the USA and globally. Ideal Skills: - Experience with business registration processes. - Proficiency in various types of databases, including SQL-based, NoSQL-based, and Cloud-based. - Prior involvement in setting up a news distributi...

More details: Is this project for business or personal use? This question was skipped by the user What information should successful freelancers include in their application? This question was skipped by the user How soon do you need your project completed? This question was skipped by the user

I need a web application built in ASP.NET or .NET, with Microsoft SQL storage, aimed at fostering spiritual growth among youth and young adults. This platform will primarily facilitate group discussions and training events. Key Features: - Group Discussions: Users need to be able to join different groups for discussions, based on their interest. - Multimedia Sharing: The platform should allow for the sharing of text-based posts and photos. - Azure Hosting: The code will be hosted in Azure. Future Phases: - Following the completion of the web application, a mobile application will be developed in Phase 2. Please Review: For project requirements and user stories please the attached documents Your Bid Should Address: - Your suggested database architecture/design for this appl...

Manuscript Index Website with Protected Login Project Overview We need a secure, user-friendly website to serve as an index for manuscripts. The plat...or files. Responsive Design The website should be fully responsive and optimized for both desktop and mobile devices. Scalability The system should handle a growing number of manuscripts and concurrent users. Optimized for fast loading and search performance. Security Encrypted storage of sensitive data (e.g., passwords, user information). Protection against common vulnerabilities such as SQL injection, XSS, and CSRF attacks. Regular backups to prevent data loss. Technical Stack Preferred framework/language for backend: [Node.js]. Database: [PostgreSQL, MySQL]. Frontend: [React.js, Angular, Vue.js]. File storage: cloud-based...

I'm looking to set up a GTA RP server on FiveM tailored for India. The server will focus on delivering a realistic role-play experience, with several key features integrated for immersive gameplay. Key Features to Implement: - A comprehensive Economy System - A detailed Law Enforcement System - A range of Custom Jobs Ideal Skills: - Proficiency in FiveM server scripting and management - Experience with creating immersive, realistic role-play environments - Knowledge in implementing intricate game systems such as economies and law enforcement If you have a passion for gaming and possess the required technical skills, let's collaborate to create an engaging and fun server for the GTA RP community in India.

...plan as per the agreed concept with timelines Technical Expertise: Strong experience with Microsoft Azure components, including Azure Data Factory, Azure Synapse, Azure SQL Database, Azure Key Vault, MS Fabric, Azure DevOps (ADO), and Virtual Networks (VNets). Expertise in Medallion Architecture for Lakehouses and data modeling in the Gold layer. Solid understanding of Data Warehouse design principles, including star schema, snowflake schema, and data partitioning. Rich Experience with MS SQL Database Packages, Stored procedure, Functions, procedures, Triggers and data transformation activities using SQL Good knowledge in SQL loader, Data pump and Import/Export utilities Knowledge on Performance Tuning Experience with any data visualization or BI tools such a...

I need a Windows Service that synchronizes my complete local SQL database with a remote SQL database in real-time. This should be a two-way synchronization, meaning changes in either database should be reflected in the other.

Those interested in the project must have experience with dolibarr modules, API connections, PHP, SQL. Those who meet the requirements are asked to contact me via chat. We are seeking experienced developers specializing in Dolibarr module creation and ERP system integration to build a custom module that connects Dolibarr with Nexus ERP via API. The goal is to synchronize critical data and streamline collaboration between the two platforms, focusing on efficient management of financial and operational documents. Functional Requirements: Types of Data to be Synchronized: Customer and Supplier Invoices: Retrieve issued and received invoices from Nexus ERP and store them in Dolibarr. Generate invoices in Dolibarr and send them to Nexus ERP. Consumption Vouchers: Import consumption vo...

I need a Laravel web application installed on my server. This is a fresh installation. The project involves: - Full configuration of the server environment to support the Laravel application - Domain pointing to the application Please note, the server is a shared hosting. Ideal skills for this job include: - Expertise in Laravel - Server configuration skills - Experience with shared hosting Looking forward to your bids.

I'm looking for a seasoned backend developer skilled in , PostgreSQL, MySQL and SQL to collaborate with my frontend developer on a application. Your main task will be working on custom backend services. Experience in building and managing databases is crucial, as is the ability to seamlessly integrate with third-party APIs. Ideal Skills: - Proficient in - Experienced with PostgreSQL, MySQL and SQL - Able to develop custom backend services - Familiar with integrating third-party APIs - Great team player for collaborating with frontend developer

...mobile-first enhancements, or any value-adding capabilities drawn from their experience with similar platforms. Our goal is to create a robust, user-friendly platform that can compete with established P2P exchange services." you can use the following site as example I have other project which we use the following relation between the data in Postgres SQL these projects should be harmonized with the same procedures and structure as following.

I'm seeking an experienced DevOps professional to set up a GPU server on Google Cloud. The server will primarily be used for running machine learning models, specifically in the field of Computer Vision. The preferred framework for these models is TensorFlow. Key Responsibilities: - Set up and configure the GPU server on Google Cloud. - Ensure the server is optimally tuned for TensorFlow and Computer Vision tasks. - Provide documentation and support for server usage. Ideal Skills: - Extensive experience with Google Cloud and vast.ai. - Strong background in DevOps, particularly in setting up GPU servers. - Proficiency in TensorFlow and Computer Vision. Please include examples of similar projects you've completed in your proposal.

...database data, specifically on SQL Server. - The primary goal is to reduce the execution time of this method. - You will be required to assess the load via concurrent requests. Additional Notes: - This is a remote job. No code sharing will occur. Therefore, you must be comfortable working via a remote connection and using any necessary tool. - The task is a quick fix and shouldn't take more than an hour. Please don't overquote, as I will pay per hour within the range of $10-15. - Only individual freelancers will be considered, agencies will not be entertained. Ideal Skills: - Extensive experience with C#, ASP.NET MVC, IIS, and Entity Framework - Strong knowledge of LINQ query generation - Proficient in assessing and handling concurrency - Familiar with SQL...

I need an expert with installing Vicibox11 on a freshly setup cloud server. Ideal Skills: - Proficient in Vicibox11 installation - Experience with cloud server - Knowledgeable in server configuration Please note, the server is currently empty, hence, the freelancer will need to install the OS and configure the server from scratch.

I'm looking for a programmer with high knowledge of SQL, Access, and ChatGPT to automate our document management processes using n8n. This involves organizing all of our company's documentation into folders automatically based on labels. Key Requirements: - Proficient in n8n for process automation - High level of expertise in SQL and Access - Familiarity with ChatGPT for potential integration - Experience in document management systems - Capable of creating a system for organizing documents by department (Sales and Marketing, HR and Administration, IT and Operations)

I've installed Seafile on my Apache server running Ubuntu 22.04. While I have access to the application, I'm unable to upload or download anything. I need a backend developer who can troubleshoot and rectify this issue. Logs indicate there's a problem, but they aren't clear. I made minor modifications to the default Seafile configuration, but it's mostly untouched. You can fully re install seafile. Please include your relevant experience in your application.

I have an existing ERP system utilizing MS SQL as the database engine and Microsoft Access as the frontend. We're looking to transition this to a web application built on ASP.NET. This will be a phased migration, implementing functionalities from the old frontend to the new one step by step. The first task in this migration is to rebuild the picking system, which is responsible for preparing orders from the warehouse. The current picking system includes: - Inventory Management: Keeping track of stock levels and warehouse layout. - Barcode Scanning: Utilizing barcodes for tracking items and improving efficiency. In terms of user authentication, we prefer a standard Username and Password system for the new application. As for user roles and permissions, we will require: - Cus...

...programs on Microsoft Azure data services, including Azure Data Factory, Azure Databricks, Azure SQL Database, and Azure Synapse Analytics. Develop course materials, hands-on labs, and tutorials tailored to various skill levels. Stay updated with the latest Azure data engineering developments to keep training content current. Assess learners' knowledge and provide constructive feedback to facilitate improvement. Offer individualized mentorship to address learners' specific needs. Prepare learners for certifications, such as Microsoft Azure Data Engineer Associate. Candidate Qualifications: Proven experience as an Azure Data Engineer or in a similar role. Proficiency in Azure data services like Azure SQL Data Warehouse, Data Factory, Data Lakes, HDInsight, and St...

I am looking for an expert in Elastic Search or TypeSense to improve the search functionality within my database. The primary goal of this project is to enhance the way we search through our dat...goal of this project is to enhance the way we search through our database records. Key Requirements: - Deep knowledge and experience with Elastic Search or TypeSense. - Proven track record of improving search functionality within databases. - Ability to understand and work with database records. - Strong problem-solving skills and attention to detail. Ideal Skills: - Elastic Search - TypeSense - SQL - Database Management - Search Functionality Improvement Your expertise will play a key role in making our database search more efficient and effective. Looking forward to your insightful ...

Hello, I am seeking a skilled freelancer to assist with the repair and import of a corrupted SQL Server file. Here's the situation: I accidentally deleted both the MDF and BAK files from our disk, and unfortunately, the file structure cannot be recreated. Using a hexadecimal editor, I managed to locate four MDF files, but I am uncertain which one contains the correct data. After some repairs, I believe one file might have the data I need. My primary interest is in recovering data from a specific period, which I couldn't retrieve using automated repair methods. Due to the size of the file, I require you to work directly on our system remotely.

...linked to the same DB, but with a new identity. - The design must be compatible with the Figma design and implemented using .NET framework 8, SQL server DB, JavaScript, and AJAX (in search). - Two language versions are required: Arabic and English. - All website functionalities need to remain unchanged, including user authentication, data reporting, real-time updates, and all existing links and data. Some links should be editable from the control panel to open external links ; So you need to use same control panel (I Well provide old source code). - Integration of social media into the new version. - You are responsible for publish website on our server (on Google cloud) - You can give guides to SEO Ideal Skills: - Strong UI/UX design capabilities. - Extensive web ...

I'm seeking a skilled SQL developer with a deep understanding of manufacturing business logic, specifically in production scheduling within the chip industry. Your role will involve: - Assisting in the creation of a production scheduling system aimed at optimizing resource usage, primarily raw materials and machinery. - Providing guidance based on your knowledge of the chip manufacturing business. Ideal candidates will have substantial experience in SQL development and a strong background in the manufacturing sector, particularly with chip production. Your expertise will be pivotal in enhancing the efficiency of our operations.

I'm in need of a Power BI dashboard designed specifically for monitoring operational efficiency, with a focus on resource utilization. The dashboard needs to connect to a SQL database for data retrieval and analysis. Key Requirements: - Design a Power BI dashboard tailored for operational efficiency monitoring - Focus on tracking resource utilization metrics - Connect and retrieve data from a SQL database Ideal Skills and Experience: - Proficient in Power BI - Experience in designing operational efficiency dashboards - Familiarity with SQL database Please provide examples of similar projects you've completed, along with your proposed timeline for delivering this dashboard.

We have a small Data Center network with about 15 servers as well as 2-...Following Systems: - PFSense Firewall Expert to configure and manage multiple locations via VPN - Network & Server Admin for Linux and Windows Servers - VMware ESXi VCenter Virtual Server Installs and Management - Website Server setup and management for various website platforms We also run and maintain the following Systems: - Poste Email System - FreePBX system - VEEAM Backup System - RocketChat System - Element Chat System - NextCloud System - Filemaker Database Server Experience in these system is a Big Plus! We can pay negotiable Flat Rate Per Server/System Install and configuration tasks as well as Hourly for Systems Maintenance. A Monthly Standby Tech Support for N...

I'm looking for a web-based SMS server that allows me, as the admin, to send out messages under my business name rather than a server number. Purpose: - The primary use of this server will be to recruit new food delivery drivers. Essential Functionality: - The server must have bulk messaging capabilities, allowing me to reach a large number of potential recruits at once. - It should also support personalized messaging, so I can tailor messages to specific recipients. - I need the ability to schedule messages ahead of time, to streamline my communication efforts. - Ultimately, this server should support all of the above functionalities. Ideal Skills and Experience: - Previous experience setting up and managing SMS servers. - Knowledge in web-based ...

I'm in need of a seasoned SQL DBA to help with my MySQL database. The primary focus will be on optimizing the database for efficient queries, ensuring top-notch security measures are in place, and overseeing data backup and restoration processes. Ideal Skills: - Extensive experience with MySQL - Strong understanding of database optimization techniques - Expertise in database security protocols - Proficiency in data backup and restoration procedures - Excellent skills in query optimization

I am looking for a professional to help me deploy Kobotoolbox 2019 on an Azure server. This deployment will include the activation of an SSL certificate to ensure secure connections. Key Requirements: - Installation and configuration of Kobotoolbox 2019 on ubuntu Azure server. - Activation of SSL certificate for secure connections. Traffic Expectation: - The application is intended for personal use, with an anticipated low traffic level of less than 1,000 users per month. Geographical Location: - There is no specific geographical location requirement for the Azure server. Ideal Skills and Experience: - Experienced with Azure server deployment. - Proficient in Kobotoolbox 2019 installation and configuration. - Prior experience in SSL certificate activation on...

I am looking for an experienced server administrator to troubleshoot and resolve issues with my Apache server and PHP configuration. My website, hosted on a cPanel-managed server, is encountering a persistent 404 Not Found error for specific URLs (e.g., /rest/oauth2-credential/callback). Despite setting up the necessary files and VirtualHost configurations, the issue remains unresolved. Scope of Work: Verify Apache VirtualHost Configuration: Ensure the DocumentRoot for the domain points to /var/www/html. Confirm that the correct VirtualHost block is properly set up in /etc/apache2/conf/httpd.conf. Fix PHP Execution Issues: Verify that PHP is correctly configured and executing for .php files in the /var/www/html directory. Add or fix the AddHandler directive for PH...

Write code to retreive data from SQL Server and other apps

...S3. • SQL databases for financial transactions. 3. Backups: • Daily and weekly data backups. Integration and Flexibility: 1. Integration with Platforms: • WooCommerce, Shopify, Magento. And all online stores • Connecting using API and Keys. 2. User Interface: • Comprehensive analytics interface to monitor sales. • Display data on web and mobile applications. • Dark Mode. Additional features: • Classification of transactions according to risk levels. 2. Alerts and notifications: • Instant mobile notifications. • Login alerts from new locations with display of connected devices. 3. Innovative features: • Payment using NFC. • Support for virtual currencies for payment. • OCR for document verification. Target groups...

I'm in need of a database. Specifics have not been finalized, and I'm open to suggestions. Your expertise in the field will be invaluable in determining the best approach. Skills and Experience Required: - Proficient in various database management systems (DBMS) - Strong understanding of both relational (SQL) and NoSQL databases - Experience in creating databases for diverse applications - Excellent problem-solving skills to determine optimal database structure - Able to communicate complex technical concepts in simple terms

I have a GO script that I need to run on a remote server, specifically using Azure. The purpose of the script is to serve as a web service. The ideal freelancer for this project should have: - Proficient knowledge in Go programming - Experience with setting up and managing services on Azure - Understanding of web services Your task will be to run this script successfully and ensure the web service is operational. Please let me know if you can assist with this.

I'm seeking a seasoned Power BI professional to craft a thorough sales performance report. Key Responsibilities: - Extract data from SQL databases to analyze sales performance - Create a variety of visual representations of the sales data - Compile detailed tables for in-depth data breakdowns Ideal Candidate: - Proficient in Power BI and SQL - Skilled in creating comprehensive and insightful reports - Strong background in data analysis and visualization, particularly in sales Please note, specific sales metrics and types of visualizations will be discussed in detail with the selected freelancer. The frequency of report updates will also be determined at that time.

I'm looking for a freelancer who can export my SQL database to an Excel file. The project involves exporting all tables from the database. Ideal Skills: - Proficient in SQL - Experienced in data export and manipulation - Skilled in Excel Please ensure that the data is accurately transferred and well-organized within the Excel file.

I am looking for an experienced Power BI professional to develop a comprehensive report for me. The report will primarily focus on analyzing sales performance. Key Requirements: - Proficient in Power BI - Experience with SQL databases - Ability to create detailed and insightful reports The report will source data from SQL databases and will include: - Various visualizations to represent sales data - Tables for detailed breakdowns of the data If you have a strong background in data analysis and visualization, particularly in relation to sales performance, I would love to hear from you.

I'm looking for a skilled developer to create a hybrid customer database on my website. This will include a secure login system, payment options, and a user-friendly interface. Key Requirements: - Design and implement a hybrid (SQL & NoSQL) customer database - Incorporate a secure 'Email and Password' login system - Implement payment options: Credit/Debit Card and PayPal - Ensure the system is user-friendly and secure Ideal skills for the job: - Proficiency in SQL and NoSQL databases - Experience in website security and payment integration - Strong understanding of user interface design - Ability to deliver a project on time and within budget I uploaded the photo underneath. look forward to your bids.

I need an expert in Digital Ocean and Webmin to set up and run my fully developed PHP website on my Ubuntu server. Ideal Skills: - Extensive experience with Digital Ocean - Proficiency in Ubuntu server management - Expertise in Webmin usage - PHP knowledge for server setup Looking forward to your bids.

I require assistance downloading all files from my Ubuntu server along with the complete MariaDB database. - Current Access: I currently connect to my Ubuntu server via Navicat. - FTP Setup: I need help setting up the FTP connection to facilitate this process. - Data Scope: The task involves downloading all server files and databases, not just specific directories or databases. The ideal freelancer for this project should have: - Extensive experience with Ubuntu servers. - Proficiency in working with MariaDB. - Skills in FTP connection setup. - Ability to handle comprehensive data downloads efficiently.

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

I'm looking for a talented full-stack developer to help with my website project. Ideal Skills: - Proficiency in both front-end (HTML, CSS, JavaScript) and back-end (Node.js, Ruby, Python, PHP) technologies. - Experience with responsive design and mobile-first approach. - Familiarity with database management (SQL, MongoDB). Experience: - Previous work on website development. - Proven track record of delivering quality work on time. Please note, the purpose and design style of the website have not been determined yet, so flexibility and creativity are key.

Customized Form in PHP with Secure SQL Database including online deployment We are seeking to develop a aesthetically pleasing, and secure web-based form integrated with a SQL database. This form will facilitate and receive applications for a monthly token draw for 10,000 lucky users, each winning 1,000 tokens(Max application per month 1 Million). Selection of winners will be taken care separately and is not part of the project. The project requirements are as follows: User Authentication and Entry Implement Telegram API integration for user login, ensuring unique entries. Display the current draw month prominently after login, e.g. Heading, " Draw for the month of January 2025." Prevent multiple entries: Check if the user has already submitted an entry for th...

I've recently set up a dedicated Ubuntu server with Plesk. This server is intended to host my Wordpress/Woocommerce shops and connect with my JTL-Connector software. However, I'm noticing slow loading times. I'm seeking an expert to review and optimize my server configuration, which includes Plesk, LiteSpeed, and Apache. The goal is to significantly enhance performance and loading speed. Ideally, the freelancer for this project would be an expert in server tuning and optimization with: - Extensive experience with Plesk, LiteSpeed, and Apache - Knowledge of performance-enhancing tools like Google PageSpeed, Redis, and Varnish Cache - Expertise in optimizing database performance, web server configuration, and content delivery and caching ...