Database tuning advisor in sql server step by stepdela
- poslovna inteligenca na Microsoft tehnologij tako on-premise kot v Cloudu - Programski jeziki: DAX, MDX, C#, TSQL, SQL, python, spark
Prosimo, vpišite se ali se prijavite za več podrobnosti.
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.
Prosimo, vpišite se ali se prijavite za več podrobnosti.
I'm...tackle the coding aspect of a website project. This website is an online paid-to-play role-playing game, and you'll be instrumental in bringing it to life. Key Responsibilities: - Website Development: You'll be working on the PHP code that will form the backbone of the site. - Building from Scratch: The project is starting from ground zero, so you'll be involved in its creation every step of the way. Ideal Skills and Experience: - PHP Expertise: A strong foundation in PHP is essential for this role. - Web Development: Experience in website development will be a big advantage. - Game Development (preferred but not mandatory): While not a must, any experience in game development, particularly RPGs, would be highly benefici...
I'm in need of a proficient PowerBI analyst who can effectively connect to different data sources: Excel spreadsheets, SQL database, and CSV files. Your tasks involve creating detailed reports and conducting: - Sales performance analysis - Financial dashboards - Customer segmentation I have a preference for Bar and Pie charts in the visualization of these reports. Ideal applicants should have valuable experience in these fields and have an innate knack for making data comprehensible. Excellence in the mentioned chart formats is paramount. Having a solid background in Excel, SQL and CSV data manipulation will be a plus.
I'm hunting for a highly creative individual skilled in crafting unique and professional logos. Your design expertise should span both text-based and icon-based logos, inexorably breathing life into my brand image. Here are the specifics of what I'm looking for: - Ability to create a broad variety of logo designs - Familiarity with different design aesthetics - Phenomenal communication skills to understand and articulate my vision Please note that you may need to navigate the project without rigid style restrictions. This requires a good understanding of contemporary logo design trends and the prowess to adapt to various style demands. Showcase your adaptability through your portfolio and take the first step towards partnering on this exciting project.
I need a Gujarati dataset prepared for training the Llama 2 model, in order to later perform fine-tuning on it for language-specific tasks. Essential Requirements: - Curate a sizeable Gujarati dataset suitable for training NLP models, ideally around 5 GB - Utilize the Llama 2 model for the Gujarati fine-tuning, optimizing it for the specific task Key Skills: - Proficiency in NLP techniques and methodologies - Experience in curating or working with large datasets - Proficient in fine-tuning Llama 2 or similar models - Gujarati language proficiency is a plus Deadline: 2 days for the dataset curation and initial fine-tuning.
We are in the initial stages of launching an exciting e-commerce project aimed at enhance the online shopping experience. Technical Aspects of the Project: - Development of a browser plugin that interacts with various e-commerce platforms. - Integration of AI technology to extract data and analyze shopping cart contents. (Text extraction) - Implementation of APIs to collect and compare product data in real-time. - Creation of algorithms to identify and recommend similar products. (Might not be needed) - Development of a scalable backend to support real-time data tools and user analytics. Requested Technical Skills: - Experience creating sustainable Data modells - Experience in browser-extension development with JavaScript, HTML, CSS, and modern frameworks (React...
...Requirements: 1. Icon Color Modification and Background Removal Guide: Research and select a widely available tool suitable for icon color modification and background removal. Develop a step-by-step guide detailing the process of changing the color of icons to specific RGB codes and removing backgrounds using the chosen tool. Include screenshots or video demonstrations to illustrate each step of the process. Provide clear instructions on selecting and adjusting colors, as well as techniques for accurate background removal. Ensure the guide is easy to follow for users with varying levels of proficiency in graphic design software. 2. After Effects Design Template Creation: Collaborate with the project manager to discuss the desired overall theme and des...
I am looking for technical help to ad...help to address and solve a persistent connection error that occurs on my Android device - a smartphone. The primary issue lies in the fact that the phone fails to establish a successful connection to the server. The nature of the server is slightly ambiguous as I'm not quite sure. • Requirements: - Experience with Android systems - Deep understanding and expertise in server connection dynamics - Ability to accurately diagnose and resolve server connection issues • The immediate task is to: - Identify why my smartphone cannot connect to the server - Implement a foolproof solution that will ensure a smooth and reliable connection in the future. Skill in android de...
I am looking for technical help to ad...help to address and solve a persistent connection error that occurs on my Android device - a smartphone. The primary issue lies in the fact that the phone fails to establish a successful connection to the server. The nature of the server is slightly ambiguous as I'm not quite sure. • Requirements: - Experience with Android systems - Deep understanding and expertise in server connection dynamics - Ability to accurately diagnose and resolve server connection issues • The immediate task is to: - Identify why my smartphone cannot connect to the server - Implement a foolproof solution that will ensure a smooth and reliable connection in the future. Skill in android de...
I am seeking an expert who can integrate SSL 3.0 into an existing Laravel installation on my local Wamp server. I have installed Laravel already, but now I require enhanced security through SSL. The purpose for this task is strictly to increase the site's security. No other modifications or tasks need to be carried out. Comprehensive knowledge and prior experience with Laravel, Wamp server, and specifically SSL 3.0 integration are mandatory for this job. Key Requirements: - Proficiency in Laravel - Previous experience with Wamp server - Experience in SSL 3.0 integration - Able to execute task quickly and proficiently - Enhanced concern for site security
Design a 4 step infographic on Canva, with the information sent by the client.
I am working on React JS with Javascript Development Project. I need someone to Support me for this Project atleast 4 to 5 hours Per day. Project will Exist more than 2 years. I need support through Remotely(zoom). I am looking for Good Experienced(4+ years) Person as a Frontend Developer, Who can work on the tasks ...Experienced(4+ years) Person as a Frontend Developer, Who can work on the tasks Quickly. I am looking for Long term relationship. After this Project Completed means, we will give immediately another support project. I will Give you the Sample Task for 1 Hour, If you Completed ON TIME means we will give you the Project. Required Skills : React JS, HTML, CSS, Javascript, Cypress Test Cases(Mandatory), SQL Basics Language Speaking Person : English Note: I will pay on ho...
Hi, we are a nonprofit based in Brazil. I am seeking a freelancer with outstanding research and data management skills to compile a list of geographical location of (environment and social) projects supported by a set list of 300 UK foundations (attached). Key Responsibilities: - I am only interested Foundations that provided grants to Brazilian organizations in the past 3 years (so the final list will be considerably shorter) - For these, I would need to know what are the themes covered by the foundation (for those grants but also beyond) - For some of these (that we will select later), I would need the email of the grants manager in charge (process wise, if it is easier to get te email of this entire subset, that’s ok) If a list of themes ...
I've developed ...once I upload it to the server. The server in question is hosted on Hostinger. I'm unsure if any changes have been made to the server configuration file. Key Points: - Troubleshoot the server upload issue - Resolve discrepancies between local and online versions - Clarify if server configuration files have been altered - Ensure the webpage functions as intended on the server Ideal Freelancer: - Experienced in HTML, CSS, and JavaScript - Proficient in server hosting with Hostinger - Skilled in server configuration file troubleshooting - Capable of identifying and correcting server-side programming discrepancies I'm seeking a professional who can quickly pinpoint th...
...customers via CSV file in ASTPP version 6.0, both postpaid and prepaid customers balance always uploads 0. The task is to find the corresponding php file/path on the server and correct it, so that the balance uploads correctly when uploading the customers on the ASTPP both for prepaid and postpaid customers. Positive balance must upload as positive balance. Negative balance must upload correspondingly. 0 uploads 0. You need to make a detailed document how to do that on any ASTPP server, so that someone without technical knowledge takes the document, follows it and gets the same working on the other ASTPP server. Example of the document: Someone from our side will try to upload customers on the provided server to make sure it works,
...the booth is 21.3x16.4 ft, hence the design should be suitable for this scale. - We want to step up onto our stand. Have wooden / hard flooring (no carpet), low tables and chairs, a reception desk. A kitchenette area with a fridge, coffee machine and storage for coats and bags. We would like our logo to be large and visible across the top of our stand. Due to our location, we are unable to have anything high over our stand as it had a low ceiling above our space. Ideal Skills: - Prior experience in designing trade show booths, particularly modern designs. - Proficiency in design software to create detailed visual representations of the booth. - Good understanding of branding and how to reflect it in the booth design. Please provide examples of your prev...
...Python coder who can develop a program that effectively reads numerous reviews and generates a concise summary, encapsulating the main points in 300 words in multiple bullet points. Key Functions: - Extract data from a relational database via SQL queries. - The ability to process and analyze reviews from different platforms such as blogs, social media, and online stores. - Generate a coherent 300-word summary from a multitude of reviews. Required Skills and Experience: - Expert level understanding of Python programming. - Knowledge and experience in SQL querying is a necessity. - Experience with Natural Language Processing for summarization. - Familiarity in dealing with relational databases. - Prior experience with text summarization...
I'm in need of a professional who can review and optimize my .net Core 6 codebase, enhance the software architecture, and bolster the database security. Key Responsibilities: - Conduct a comprehensive code review to identify inefficiencies, bugs, and areas for improvement in the .net Core 6 code. - Improve software architecture to ensure scalability, maintainability, and performance of the application. - Implement robust measures to enhance the database security, in line with industry best practices. Ideal Skills and Experience: - Extensive experience in .net Core 6 and Entity Framework. - Proven track record of conducting code reviews and optimizing codebases. - Expertise in software architecture design and implementation. - Strong ...
I'm in need of a skilled professional to create a No-Code app on the Adilo platform or any other. It shall has three interface. 1. User Interface 2. Management Interface 3. Service Provider Interface App Idea: Chat based profile matching for Carpenters to work on hourly basis. User Interface Step 01 Signup Form with Phone, Email, Address Step 02 A chat box would open up with basic questions as; • Date for Booking • Time Period for Booking Step 03; Within the chat box the next question would be regarding the work profile Users can text to match profiles. Example: I want Bamboo Artisans Step 04: The Chat box will show all profiles for Bamboo Artisans as in the Directory or excel file Excel would be as simple as Skill ...
We have a software written in c++ and we will like it to be linked to our tuning software winols is this something you can help me with Basically i have developed a software to turn off certain functions in a engine control module. You cannot code the software to work with every ecu every software version. So lets say the user selects mercedes then selects edc17c66 ecu and want adblue dpf egr off the software will send the file they have uploaded to my winols and in my winols there will be a file for that sw version ecu and it will make all modifications taking the modifications from the modified file in my winols database and export the file back to the end user who is using the software And winols has a plugin called winols lua. Thats how you c...
I'm looking for a professional mobile app developer to create a driver app for both iOS and Android. Key Features: 1. Login with your Car number in the Chauffeur Login section 2. Enter the OTP Received to login 3. Accept / View the booking received for the next 4 hours 4. Click on “start ride” button 5. After reaching the pickup point click on “Report” button 6. Once customer is picked up, enter CRN number and upload a picture of odometer to start the journey 7. Once reached the drop point, click on “Drop” button, upload a picture of odometer to end the journey 8. Share your Trip Feedback. 9. Click on add Extra charges button for adding extra charges amount and upload a proof for each amount (receipt or transaction screenshot) 10. Extra ch...
I'm in need of an expert to set up SQL Server 2019 on a Windows-based virtual machine. The system will be used to support website and desktop applications. Key Responsibilities: - Configuration of SQL Server 2019 on a Windows virtual machine - Ensuring secure and optimal performance of the system - Testing the setup to confirm seamless connectivity with website and desktop apps Ideal Skills: - Extensive experience in managing SQL Server 2019 - Expertise in Windows OS and virtual machines - Should have strong troubleshooting skills on SQL server - Familiarity with website and desktop app integrations.
Excited to work with an experienced ASP.Net webforms developer, who will bring their skills to facilitate the Database integration aspect of our project. Key Responsibilities: - Integrate SQL Server with our existing ASP.Net project. - Create smooth and efficient functionality. - Ensure system robustness and efficiency. Skills and Experience: - Strong proficiency with ASP.Net Webforms. - Knowledge and hands-on experience working with SQL Server. - Excellent troubleshooting capabilities. It is not necessary for this project to migrate data from an existing database to SQL Server. However, the capability to do so may be beneficial in the future. If you are an experienced developer with the aforementioned skills, I would l...
As a Windows user with IIS 10, I am in need of a professional who can help me configure the server properly. My main goal is to host a website, and domain mapping is an essential part of that process. Key Responsibilities: - Map domain to the IIS server - Ensure website is accessible via the domain - Handle any other essential configurations for smooth website hosting Ideal Skills: - In-depth experience with IIS 10 - Proficiency in Windows server administration - Strong understanding of domain mapping - Good communication skills to ensure smooth interaction and understanding of the task. Project Detail as below, I have my own Windows Server and I am using IIS for website deployment. I have a total of 5 websites. Currently, I am using a ...
We are seeking a skilled developer to create a comprehensive time management website aimed at assisting users in optimizing their productivity and organizing their schedules effectively. The website will feature a user-friendly interface, leveraging HTML and CSS for frontend design, and backend functionality will be implemented using robust technologies to ensure seamless performance and scalability. MYSQL Database.
make reviews on website not go live automatically but ONLY after admin approval. to AVOID SPAM and false reviews (also create email alert for notice of "new review pending" status when created - to go to signsdelivered@gmail .com)
I'm seeking a proficient developer to build a comprehensive demo or starter code integrating Snowflake and Kafka using AWS cloud. The ideal candidate should have deep understanding of concepts such as: - Data ingestion - Data transformation - Data storage and retrieval The code should ensure: - Optimal performance - Scalability - Security The code can be written in Python or Java. In-depth knowledge of these languages, as well as experience with Snowflake and Kafka integration, is a necessity for a successful bid on this project.
I'm in search of a highly skilled server engineer who understands VPS and email servers. The current system I have in place with Contabo and Zimbra is unreliable and requires daily restarts, clearly, this is far from ideal. Your task will be to either create a stable setup with the current tools, or propose and implement a new, more reliable solution. Key Aspects: - High uptime: The system should rarely, if ever, require manual restarts. - Scalability: While the exact number of email accounts needed is not yet determined, the setup should be highly scalable to accommodate growth. Support: - Although no specific level of support was specified, basic troubleshooting is expected as part of your proposal. Higher level support options can be discussed based on yo...
I'm on the hunt for an experienced JavaScript developer. While the exact functionality isn't fully defined, the project will involve server-side JavaScript application development. Unfortunately, I do not have any specific JavaScript functionality or purpose to provide at the moment. Ideal Skills: - Strong experience in JavaScript, preferably in server-side environments - Capacity to discuss functionality possibilities and advise on solutions - Proactive, able to operate effectively with minimal project-specific guidance. Please use your proposal to demonstrate your JavaScript know-how and experience with server-side applications. Show me that you can figure out and build the functionality we need.
Typical Functions: Data Architecture: Leverage your 5+ years of experience in designing and optimizing database solutions. You’ll work closely with stakeholders to create a robust data architecture that seamlessly integrates various data sources. Programming Languages: Demonstrate proficiency in Java and C#. Your code is not just functional but elegant. Team Leadership: As a seasoned engineer, you’ll mentor junior team members, foster collaboration, and drive technical excellence. Cloud Solutions: Familiarity with Azure or AWS is essential. You’ll architect, deploy, and manage cloud-based solutions. Data Import Strategy: Devise a robust strategy for importing data efficiently, ensuring data quality, and maintaining performance. Collaboration: Work cl...
E-comerce hecha con React, Tailwind CSS , Framer Motion y cuenta con un chatbot con IA como asistente virtual En el Backend cuenta con una base de datos SQL y node Js y Javascript para la conexión a la BD Tiene una auténticacion de usuarios Y cuenta con integración a MercadoPago
I'm in need of an experienced SQL developer who can assist with writing stored procedures in SQL Server. The purpose of these stored procedures is for data loading. Key Responsibilities: - Writing stored procedures for data loading Ideal Skills & Experience: - Proficient in SQL and SQL Server - Prior experience with writing stored procedures - Experience with data loading processes The complexity of the stored procedures is expected to be at the basic CRUD operations level. As this is focused on data loading, it requires someone who is meticulous and well-versed in data manipulation within a SQL environment.
I'm seeking a skilled photo editor for some precise alterations on a wedding photo. Here's what I need: - Remove two people from the image: Specifically, it's an elderly man and woman who are blocking a blonde girl. - Insert the f...precise alterations on a wedding photo. Here's what I need: - Remove two people from the image: Specifically, it's an elderly man and woman who are blocking a blonde girl. - Insert the full body of a blonde girl: She should be placed exactly where she appears in the picture. The freelancer will need experience with photo retouching and Photoshop, particularly in adding and removing people. A keen sense of aesthetics to ensure the final image flows seamlessly would be highly advantageous. Please consider that the task mi...
I'm in need of a skilled professional to create a chatbot whatsapp business integrated with Mikrowisp The chatbot will serve as a tool for registered companies to interact with their customers. Key Features: - Options menu: The chatbot must provide the options menu, and a limit of queries to exit the chatbot and transfer the advisor. - Invoiced amount query: The chatbot must provide users with a simple way to find out the amount owed and due date. - Consultation of the user profile: The chatbot must respond to the contracted profile. - Spanish Support: The chatbot needs to be capable of interacting with users in spanish - Company Management: The ability to enable, disable, or delete companies from using the
I'm looking to create an ap...focus should be on ensuring user credentials are securely handled and stored. Experience with implementing this in a NoCode environment is a must. - Database Integration: The project will make use of an SQL Server. The freelancer should be able to efficiently integrate and manage an SQL Server database with the NoCode tools. Previous experience with SQL Server is required. - We need to integrate some process, after all, we need to implement the solution in Azure. In summary, I'm looking for a freelancer who is skilled with NoCode tools, specifically Bubble and FlutterFlow, has implemented email/password user authentication before, and has experience with SQL S...
...minimalist approach to develop a "Sold By Four Leaves" image using elements from my logo that I've supplied. My commercial property business is called Four Leaves, and I want an image I can put on properties I've sold which says "Sold by Four Leaves". You could include some imagery, or it could be a simple word image which says "Sold by Four Leaves". Key elements: - Color scheme: Mainly featuring light green (4fb420), dark green (006440), and white. - Design Style: Should radiate professionalism, akin to a modern and minimalist sensibility. - Imagery: I invite creative suggestions and ideas. While I didn't specify particular elements to be included, ensure it communicates the 'Sold By' concept in...
Prosimo, vpišite se ali se prijavite za več podrobnosti.
I'm seeking an expert data scraper to compile a comprehensive list of small to medium enterprises (SMEs) across Victoria, NSW, North Queensland, and South Aust...comprehensive list of small to medium enterprises (SMEs) across Victoria, NSW, North Queensland, and South Australia. The scope of businesses should focus on restaurants and retail stores. The information needed for each business is as follows: - Business Name - Address - Phone Number - Website - Email Ideal candidate should have robust experience in data collection and validation to ensure the information provided is current and accurate. Proficiency in navigating Australian business directories and databases will be a valuable asset. Your scrupulous attention to detail and commitment to data integrity are c...
...plugin should enable the user to create quizzes. Please advise on the best quiz type to use. - Embedding: The plugin should allow for easy embedding into website pages or blog posts. Being able to place the quiz in a sidebar widget would be a bonus. - Interaction: I am open to different ways for users to interact with the quiz, either by clicking on options, typing answers, or selecting from dropdown menus. Your insights on the most user-friendly option are welcome. - Management: The plugin should provide an interface to manage the quizzes. Ideal Skills and Experience: - Experience in creating interactive quizzes. - Strong UI/UX design skills for user-friendly interaction. - Excellent communication skills for explaining the best approach for quiz creation. Screen...
I need a database where we can store our sales transactions. The database will be manually updated by our staff. I would also like to have reports generated on our sales. Key Requirements: - Develop a database to store sales transactions - Enable manual data entry by staff - Implement a reporting system that can generate sales reports Ideal Skills: - Proficiency in database development - Experience with manual data input systems - Ability to create custom reporting features Please provide examples of previous similar projects you've worked on.
I am seeking a skilled designer to help overhaul the color scheme of an existing logo design. This requires fine tuning, specifically: - Re-coloration: The current logo needs to transition into a different color palette. Expertise in color psychology and branding is advantageous. - Color Selection: The ideal palette revolves around neutral colors : black, white, and gray. Prior work in creating professional, sleek designs using these colors would be greatly appreciated. Your portfolio showcasing similar past projects could be a great plus.
I'm in need of an experienced PowerShell script writer, specifically for Power BI associated data management tasks. As part of the project, code will be required to execute the following tasks: - Data extraction from Excel files, CSV files, and SQL databases - Transformation of data, including extraction and update of parameter values from Data Models in each Workspace Ideally, the freelancer would carry a strong understanding and hands-on experience with PowerShell scripting, Power BI, data transformation techniques, and working with database source files like Excel, CSV, and SQL formats.
...and it may have disrupted the normal operation of the server. I am currently dealing with an issue where my centOS mail server has just gone offline. It seems to be a connection issue as the error message I am receiving is that connection is timing out. This issue started occurring right after some changes were made to the server configuration. Specifically, some settings were modified which seems to be the root of the problem. I need an expert who can swiftly and accurately identify the problematic changes and rectify them. Key Qualifications: - Strong knowledge on centOS mail server configurations - Experienced in troubleshooting and resolving mailserver issues - Expertise in server and network configurations - Previous experience ...
For my current project, I require an expert who's proficient in DOMO Beast Mode and SQL. The tasks will primarily involve: - Producing calculated fields: You will need to execute both complex mathematical calculations, as well as intricate string manipulations. A good grasp of mathematical principles and string handling in SQL is a must. - Transforming data: This job will further entail the aggregation of data. Being adept in grouping and managing datasets of diverse sizes will be crucial. Your comfort in working with DOMO, SQL, and data manipulation will be the key to successfully accomplishing this task. If you routinely perform these tasks and understand the underlying processes, I would love to connect and discuss the project fur...
I am searching for a professional, capable of accessing and securing contact details of a policy advisor in the Prime Minister's Office. If you have extensive experience and sound connections within governmental institutions, your expertise would be of great value. Key responsibilities include: - Information gathering, particularly contact details - Networking within the Prime Minister's Office The ideal person for this job must have: - Proven experience in governmental networking and information gathering - Credible connections within the Prime Minister's Office - A track record that demonstrates discretion and professionalism Please note that this task requires strict confidentiality and adherence to all relevant laws and regulations.
