Performance tuning in sql server 2014 step by step työt

Olen itsenäinen yrittäjä, joka toimii ilman välikäsiä ja mikä tarjoaakin lukuisia etuja, ja on etuus työskennellä omien intohimojen parissa. Saat nämä kaikki saman katon alta: Brändin nostot, google kampanjat eli : hakusana ,performance max sekä shopping verkkokaupat kampanjat, verkkosivut, SEO-optimointi sekä AI –kaverin hyöty sisällön luomisessa. Edulliseen Freelancer -hintaan! -Mika

Usealla isolla yrityksellä on käytössään Suomessa eräänlainen heidän alansa ERP-paketti, joka on koodattu Visual Basicillä. Tarvitsisimme VB-osaajaa ylläpitämään ohjelmistossa mahdollisesti tehtäviä muutostöitä. Tekniikka lyhyesti: • Visual Basic -koodia noin 280-290 000 riviä • Integraatio taloushallintoon ja palkan maksuun • raporttipuolella n. 50 000 riviä • Crystal Reports • Microsoftin SQL Server -kanta Työmäärät vaihtelee, mutta keskimäärin 1-2 päivää/viikko. Välillä hiljaista.

Meillä on kaksi yritystä järjestelmässä, joilla on omat varastokirjanpidot ja osto-&myyntitilauksensa. Lokaalina serverinä toimii Windows 7 ympäristössä, visma Nova pro 9 (Windows sql server). Mikäli työn suoritus vaatii jonkin tietyn ympäristön niin kysele. Haluaisimme ajoitettuina tehtävinä ajaa allamainitut skriptit jotka muodostavat CSV tiedostot jotka on tarkoitus lähettää sähköpostina eteenpäin. Skriptin asetusten muokkaus skriptin alussa. Muuttujat ja funktiot kommentoituna. Lisätyönä voi tarjota näiden tiedostojen automaattista lähettämistä (Tiedosto liitteenä + leipätekstissä luettavasti muotoltuna). -------...

Webservicen luominen sql tietokannalle. Perus toiminnot webservicelle ja kehitys ympäristön pystytys. Tarkempi speksi on saatavilla NDA:n kirjoituksen jälkeen. Kehitys mielellään Eclipse ympäristössä.

Hei, meiltä puuttuu useilta tuotteilta valokuvat ja olemme alkaneet miettimään tulisiko halvemmaksi renderöidä kuvat valokuvaamisen sijasta. Tässä linkki, josta näätte minkälaisia tuotteita meiltä löytyy: Useimmilta tuotteiltamme löytyy step -tiedostot, mutta joitakin tuotteita voi joutua mallintamaan.

Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies the Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is available and the Project needs to be done using Visual Studio. Azure SQL database management and required SQL queries are not in the scope of the Project.

Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies andthe Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is avaiable and the Project needs to be done using Visual Studio. Azure SQL database and required SQL queries are and database management is not in the scope of the Project.

Excel Add-In joka hakee ja tallentaa taulukkomuodossa olevaa dataa Azure SQL-kannasta/-taan. Lisäksi ohjelmallista Excel muokkausta ja hallintaa C#-koodilla. Osaan Excel muokkauksista valmis VBA-script, joka muutettava C#-kielelle. Visual Studio 2015 alkukoodi, SQL Azure tietokanta ja kyselyt valmiina.

Java, J2EE, JDBC, SQL, java Threading,GWT,Html,CSS

server optimisation

Moro, Mulla olisi sulle työtarjous! Jos voisit tehdä mulle simppelin tietokannan ~5 taululla, ja kerrot vähän perusjuttuja sql serverin toiminnoista jne, niin ota yhteyttä ja jutellaan tarkemmin. Arvioisin, että tässä ei montaa tuntia menisi. Riippuen toki kuinka hyvin nuo sql perusjutut osaat ;)

Moi! Osaatko kuinka hyvin sql:n perusasiat? Onnistuuko asentaa tietokannan hallintajärjestelmä, luoda ja hallinnoida tietokantoja sekä käyttäjätilejä ŠŠ ,seurata ja optimoida tietokannan toimintaa. Jos perusasiat hoidossa niin ota yhteyttä :)

Moro, Mulla olisi sulle työtarjous! Jos voisit tehdä mulle simppelin tietokannan ~5 taululla, ja kerrot vähän perusjuttuja sql serverin toiminnoista jne, niin ota yhteyttä ja jutellaan tarkemmin. Arvioisin, että tässä ei montaa tuntia menisi. Riippuen toki kuinka hyvin nuo sql perusjutut osaat ;)

Need seo optimiside

Webbisivusto kaipaa varaustyökalua. Työkalun tulisi tehdä seuraavaa: - Näyttää varauskalenteri kahdelle tilalle sekä tilojen varaustilanne. Yhdessä tilassa ei saa olla kahta päällekkäistä varausta. - Tiloja pitää voida varata jos ne ovat vapaana. Varaus voi olla esim 4 tuntia tai 2 päivää pitkä. Käyttäjä voi valita keston muutamasta vaihtoehdosta. - Mahdollista...tulevasta varauksesta. - Varaus pitää pystyä tekemään yleisimillä selaimilla sekä ainakin joistakin matkapuhelimista/tableteista esim iphone. - Palvelu tehdään osaksi olemassa olevaa sivustoa. - Admin tunnuksella pitää päästä näkemään kuk...

I'm on the lookout for a diligent freelancer to help in testing the gameplay balance of our latest PC game. The core focus of your responsibilities will be: - **Gameplay Testing:** Deep dive into the gameplay, ensuring the mechanics are engaging and balanced. - **Balance Issues Identification:** Critically analyze and report on gameplay balance. This involves playing through the levels, understanding the game mechanics, and identifying areas that feel too easy or too challenging. - **Feedback & Suggestions:** Provide constructive feedback on how to improve gameplay balance. Your insights will be invaluable in tuning game mechanics to enhance the player experience. **Ideal Skills and Experience:** - Proven experience in PC game testing, particularly ga...

I need a professional who can analyze the logs of my Apache PHP-FPM server and help me troubleshoot errors. The main focus of this task is to identify and resolve any issues that might be impacting the performance of the server. Key Requirements: - The ideal candidate should have a solid understanding of Apache PHP-FPM logs and their structure. - Good troubleshooting skills are necessary to pinpoint the root causes of the errors. - Ability to present the analysis results in a detailed report is crucial. The main goal is to ensure the server is running smoothly and efficiently. The server use Centos 7, Apache and PHP 5.6

**Job Posting: AI Music Lyrics Generator** **Position:** AI Music Lyrics Generator Developer **Location:** Remote **Type:** Full-time/Contract **About Us:** We are a cutting-edge tech company dedicated to revolutionizing the music industry through innovative AI solutions. We aim to empower musicians, artists, and producers by providing them with advanced tools to enhance their creativity and productivity. **Job Description:** We are seeking a talented and experienced AI Developer to create an advanced AI Music Lyrics Generator. This bot will be capable of analyzing uploaded instrumentals and generating both the lyrical flow and content to match the music. The lyrics produced must be clean and suitable for audiences aged 18 and above. **Key Responsibilities:** - Develop and imp...

I'm looking for an innovative designer who can create a multi-step order form for my Food Delivery service. The form should include essential fields such as customer information, payment details, and order customisation options. Key responsibilities: - Designing a user-friendly multi-step order form - Including customer information, payment details, and order customisation options - Presenting order customisation options using dropdown menus and checkboxes Ideal skills for this project include: - Proficiency in UI/UX design - Experience with form design - Strong attention to detail - Ability to create a seamless user experience

I'm in need of a skilled beta tester who can work on my Steam project immediately. Your primary focus will be on the user interface, performance and optimization. Key Responsibilities: - Thoroughly test the user interface of the project, providing feedback on usability and design. - Conduct performance and optimization testing to ensure the project runs smoothly on various devices. - Document bugs and issues for troubleshooting and resolution. This project has a tight deadline and I need someone who can start immediately. Please only bid if you have experience with Steam projects and beta testing. Being familiar with game development and design will be an added advantage.

...data visualizations. The selected expert will be expected to work with data from both Excel spreadsheets and SQL databases, so experience with these sources is crucial. I will be looking for an advanced level of expertise, as the job will involve complex data modeling and designing sophisticated, interactive visual reports. A strong understanding of data analysis and visualization techniques is essential. Key responsibilities and qualifications include: - Creating interactive dashboards - Generating data visualizations - Working with data from Excel spreadsheets and SQL databases - Demonstrable advanced level of Power BI experience - Advanced knowledge of data modeling - Proficient in designing sophisticated, interactive visual reports - Strong understanding of d...

I'm in need of a skilled beta tester who can work on my Steam project immediately. Your primary focus will be on the user interface, performance and optimization. Key Responsibilities: - Thoroughly test the user interface of the project, providing feedback on usability and design. - Conduct performance and optimization testing to ensure the project runs smoothly on various devices. - Document bugs and issues for troubleshooting and resolution. This project has a tight deadline and I need someone who can start immediately. Please only bid if you have experience with Steam projects and beta testing. Being familiar with game development and design will be an added advantage.

I'm on the lookout for a diligent freelancer to help in testing the gameplay balance of our latest PC game. The core focus of your responsibilities will be: - **Gameplay Testing:** Deep dive into the gameplay, ensuring the mechanics are engaging and balanced. - **Balance Issues Identification:** Critically analyze and report on gameplay balance. This involves playing through the levels, understanding the game mechanics, and identifying areas that feel too easy or too challenging. - **Feedback & Suggestions:** Provide constructive feedback on how to improve gameplay balance. Your insights will be invaluable in tuning game mechanics to enhance the player experience. **Ideal Skills and Experience:** - Proven experience in PC game testing, particularly ga...

I'm on the lookout for a diligent freelancer to help in testing the gameplay balance of our latest PC game. The core focus of your responsibilities will be: - **Gameplay Testing:** Deep dive into the gameplay, ensuring the mechanics are engaging and balanced. - **Balance Issues Identification:** Critically analyze and report on gameplay balance. This involves playing through the levels, understanding the game mechanics, and identifying areas that feel too easy or too challenging. - **Feedback & Suggestions:** Provide constructive feedback on how to improve gameplay balance. Your insights will be invaluable in tuning game mechanics to enhance the player experience. **Ideal Skills and Experience:** - Proven experience in PC game testing, particularly ga...

I am in need of an experienced Amazon PPC Campaign Manager to help me reach my business objectives. The ideal candidate will have familiarity with: 1. **Tasks**: You will be primarily focused on optimizing my PPC advertising management. 2. **Past strategies**: I've previously used manual bid adjustments, automated bid algorithms and keyword optimization. Therefore, a candidate proficient in these strategies will be preferred. 3. **Target Audience**: My products are designed to appeal to all age groups so a broad understanding of the Amazon market will be most beneficial. Your role will ultimately increase product visibility, optimize sales, and efficiently manage our advertising budget. Your strategies should be adaptable to ensure consistent growth and maximum ROI. ...

I'm seeking a talented saxophonist proficient in playing Smooth Jazz for a solo performance in New Orleans. The saxophone player must: * Be familiar with and able to play various smooth jazz tunes * Have excellent solo performance skills Ideal candidates should have prior experience in similar performances and be able to adapt smoothly to changes that may occur during the live performance. The project requires a dedicated, enthusiastic and professional saxophonist comfortable with performing solo, without any band or other musicians. Experience in live performance and a passion for smooth jazz are essential for this role.

...items from discussions. -> take instructions and act fast 3. Propose options from research as requested -> more googling 4. Be able to advise proactively on details including step by step documents where needed -> simple ppt stuff 5. Maintain and update the status of various tasks with regular updates 6. Be able to present information clearly in English, not getting too bogged down by confusing details (clear communication) Expectations: 1. Self-driven and motivated to quickly achieve OUTCOMES. 2. Must be available from 6am MST to 11:30pm MST (mountain standard time) for calls - calls to connect will vary day by day. Must be very responsive via messages. 3. You will manage the workload on your own time, set your own hours ou...

I'm experiencing an issue where my website isn't loading. Thi...where my website isn't loading. This problem has emerged recently, without me making any recent changes to the website or server configurations. I need a skilled professional to help me quickly troubleshoot this issue and get my website back online. Your role will involve: - Investigating and identifying the root cause of the website's failure to load - Resolving the issue effectively and efficiently - Ensuring the website operates smoothly post-fix Ideal candidates should have extensive experience in troubleshooting websites that run on Apache servers. Strong familiarity with PHP-FPM and Webmin will be a significant advantage. Your ability to identify and remedy server issues swiftl...

I'm in need of an experienced developer to provide long-term maintenance for my e-commerce website. The ecommerce is up and running and fully operational and we need a FULL STACK developer that can code in ALL AREAS of the webapp. - Frontend: React (JavaScript) - Backend: Node.js - Services: Python - Database: MySQL RESPONSIBILITIES: - Integration of new B2B APIs - New payment gateway integration - - Implementation of bug fixes and performance improvements. - Regular software updates and security patches. - Feature additions and enhancements. Skills and Experience: - Proven experience in maintaining e-commerce solutions. - Proficiency in React, Node.js, Python, and MySQL. - Strong problem-solving skills. - Excellent understanding of software best...

We are a dynamic startup aiming to establish a new certification company Our goal is to provide top-notch certification services to businesses and professionals worldwide, ensuring compliance with international standards and best practices. We are in search of an individual who will assume responsibility for the design and implementation of all operational processes and structures essential for the application for ANAB Accreditation under ISO/IEC 17024:2012 Key Responsibilities: Develop Operational Processes: Design comprehensive operational processes covering all aspects of certification, including application procedures, assessment methodologies, documentation requirements, and quality assurance measures. Establish Organizational Structure: Define the organizational structure...

I'm looking for an Affiliate Marketing professional who can aid in boosting sales conversions through my content marketing blog site. This will involve promoting a variety of digital products such as eBooks and courses. Key Responsibilities: - Manage all aspects of the affiliate marketing program - Identify and implement strategies to increase sales conversions - Monitor blog content's performance and make necessary adjustments Ideal Candidate: - Proven experience in affiliate marketing, particularly in content marketing and conversion optimization - Strong understanding of the Digital Products sector - Demonstrated ability to achieve sales targets - Ability to analyze performance data and implement improvements - Strong communication and coll...

We're a dynamic agency specializing in helping businesses stand out on YouTube. We're currently on the lookout for a YouTube SEO specialist to boost the visibility and ranking of our high-quality content on the platform. Key Responsibilities: - Implement advanced SEO techniques to improve the ranking of our videos in search results. - Conduct comprehensive keyword research and optimize video content accordingly. - Enhance the appeal and engagement of our videos through creative thumbnail and title optimization. - Dive into analytics and user engagement data to constantly refine and improve our strategies. Ideal Candidate: - Proven experience in YouTube SEO, with a track record of improving video ranking and visibility. - In-depth knowledge of keyword...

I'm in need of a skilled developer to create a mobile application that's functional on both iOS and Android platforms. The primary function of this app is to serve as a communication platform with a focus on file sharing capabilities. Features Required: - Cross-platform (iOS & Android) - Smooth and user-friendly interface - Secure and efficient file sharing options Ideal Skills and Experiences: - Proven expertise in iOS and Android application development - Experience with communication platforms and file sharing capabilities - Demonstrable understanding of data security standards and protocols - Excellent UI/UX design skills - Ability to debug and optimize for performance across platforms An ideal candidate will have a portfolio showcasing previous ...

As a business owner, I need someone who can create new product listings on eBay for me. This project will involve the creation of between 50-200 product listings. I am looking for someone with: - Experience listing products on eBay. - Knowledge in product description and optimization. - Willing to be paid commission only. This project will be a crucial stepping-stone as we expand our online presence. Good performance will lead to more work in the future. If you have a proven track record of listing products on eBay, I look forward to your bids.

...developer to create a custom API for the Quotex trading broker using Python. Specifically, I am looking for someone who has expertise in API development. The API should have the following features: - Real-time market data streaming - Trade execution - Account balance retrieval - Comprehensive error handling with detailed error messages - High-performance optimization for fast execution - API calls should be fast Ideal skills for this project include: - Deep understanding of Python - Experience in designing and developing APIs - Background in trading platforms or financial services - Strong problem-solving skills - Ability to optimize for high performance Your primary goal will be to produce a reliable, error-free, and fast API that can efficiently...

I am seeking a highly skilled developer with expertise in AI neural networks, particularly in Python, for a challenging project. Key Tasks: - Develop a sophisticated AI neural network - Create an intelligent program using open-source AI - Analyze tennis data for the program The primary goal of the program is to enhance player performance analysis through the use of AI. Ideal candidate: - Proficient in Python - Experienced in developing AI neural networks - Skilled in analyzing and interpreting data - Knowledgeable about tennis and sports analytics would be a plus

I'm searching for an expert with suitable knowledge and experience in drafting music performance contracts. This contract will not only cover domestic performances but must extensively cater to international ones too. Key Responsibilities: - Thorough understanding of performance contract laws, both domestic and international. - Providing in-depth detailing about live performances. - Drafting a comprehensive music contract that protects the rights and interests of the artist. Ideal skills for the job: - Contract law experience, especially in the music industry. - Specific experience in drafting contracts for live performances. - Solid understanding of international law related to performance contracts. - Strong communication skills ...

I'm in need of a skilled developer who can work with Apache Superset, particularly in relation to MSSQL data. The project involves creating a range of data visualizations including charts, graphs, interactive dashboards and geospatial maps. Though the data is of moderate size and complexity, it's essential that the visualizations are effective and easy to understand. The ideal candidate will be responsible for designing, developing interactive dashboards and reports using Apache Superset. You will work closely with data analysts, data engineers, and business stakeholders to understand data requirements and translate them into visually compelling and actionable insights. Key Requirements: - Proficient in working with MSSQL databases - Solid experience with A...

I'm seeking a Minecraft expert to help me set up a survival mode Minecraft server. Key Project Details: - **Survival Mode Setup**: The primary focus of this project is to create a distinctive survival mode suitable for a smaller player base. - **Unique Items**: I will need engaging, custom, and unique items for players to discover and utilize in the game. - **Crate Rankups Integration**: I also want to include a crate rankups system to add a layer of progression and reward for players. Ideal Skills and Experience: - **Minecraft Server Administration**: Experience in setting up and maintaining Minecraft servers is a must. - **Plugin Development**: Proficiency in developing Minecraft plugins is highly desired, specifically for creating custo...

...traffic to my website and ultimately boost product sales. Key Responsibilities: - Develop and implement a comprehensive social media strategy, with a focus on Facebook, Instagram, Twitter, Tik Tok, and Snapchat. - Create engaging and enticing content across all platforms. - Monitor and analyze the performance of each campaign. - Use data-driven insights to optimize the campaign for increased website traffic. Ideal Skills and Experience: - Proven experience in social media marketing, particularly in promoting health or wellness products. - Strong understanding of the target audience's preferences and habits on various social media platforms. - Knowledge of SEO and analytics tools to track and measure the success of the campaign. - Excellent written and verb...

Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.

I have a pressing need for a Facebook ad manager. My company would greatly benefit from someone who can consult on the best methods and strategies when it comes t...specifically focusing on ad placement and ad creative. Key responsibilities will include: - Set-up, targeting, creation, and design of Facebook Ads related to my business. - Performance tracking and optimization to guarantee the best results from our advertising efforts. The ideal freelancer would have extensive experience in managing Facebook Ads and a proven track record in driving web traffic and generating leads. Your ability to provide expert advice on targeting audiences will be pivotal for our success. In a nutshell - I need someone who can take ownership of managing my Facebook Ad manager ...

I am in need of an experienced Bubble developer to create a customized CRM system specifically tailored for financial services and their freelancers. This system should be able to: - Track leads: The application should have a robust lead tracking system in place, allowing us to monitor and manage leads effectively. - Manage deals: Deal management is a crucial part of our business. The CRM system needs to support this feature to ensure smooth deal handling. - Provide performance metrics: It's important for us to evaluate the performance of our team. This CRM system should include tools to generate and present performance metrics. Additional features requested for this CRM system include: - Email integration: Seamless integration with email servic...

I'm looking for a social media marketing exp... Key Responsibilities: - Create and manage Facebook ad campaigns to target young adults (18-24) in an engaging and effective manner. - Regularly monitor, analyze and report on the performance of these campaigns. Ideal candidate: - Proven experience in social media marketing with a focus on increasing brand awareness. - Specific expertise in Facebook advertising. - Understanding of the preferences and behavior of young adults. - Strong analytical skills to measure and improve campaign effectiveness. Knows how to run facebook ads knows how to run political ads is a plus but not a must Please provide examples of successful campaigns you've managed in the past. Your work will be crucial in...

...assistance in two primary areas to rectify an unexpected issue with a stolen phone and compromised Gmail account. - Bypass Google's second verification: My Gmail account is currently secure with two-step SMS verification. However, the difficulty is that I don't possess access to the phone where the verification code is sent via SMS. Thus, I need assistance in circumventing this verification to recover my Gmail account. - Remote data wipe: Since my phone has been stolen, I wish to delete all data stored on it remotely. I'm looking for a professional with understanding in Google’s verification systems and proficient knowledge in remotely wiping data from an Android device. Privacy and accuracy are paramount in this task alon...

I have an existing Java code that I need to be revised to enhance functionalities. Key Points: - The main objective of revising this code is to enhance the current functionalities and potentially add new ones. - Current performance issues include slow response times, high memory usage, and occasional crashes. Ideal Skills and Experience: - Proficient in Java programming - Experience in code refactoring and enhancement - Strong understanding of input validation, database integration, and error handling - Prior experience in dealing with performance issues in Java applications Your job will be to review the existing code, identify the areas that need improvement, and implement the necessary changes to enhance the overall functionality.

I'm in need of a skilled SEO professional to help me improve my website's visibility and search engine rankings. Your main goals will be to increase organic traffic and ultimately increase leads/sales. Key Tasks: - Conduct an SEO audit to identify current gaps in the website's SEO - Implement on-page and off-page SEO strategies - Monitor and report on performance and any improvements Ideal Skills: - Proven experience in SEO optimization with tangible results - Knowledge of the latest SEO trends and best practices - Familiarity with tools like Google Analytics, SEMrush, and Moz - Great analytical skills to interpret data and adjust strategies accordingly Feel free to reach out if you have any questions or need more details.

I'm currently in search of a seasoned Django developer to assist me in integrating our project with Stripe's API. This is a crucial element of our application, and I'm looking for someone with a proven track record in this specific area. Key Responsibilities: - Develop a seamless, secure and efficient integration with Stripe's API - Ensure the integration is scalable and can handle a growing user base - Regularly test and monitor the integration to ensure its reliability and performance Skills and Experience: - Extensive experience working with Django, particularly on API integrations - Proven expertise in integrating applications with third-party APIs, with a particular focus on Stripe being highly desirable - Strong understanding ...

As the owner of a WordPress powered website, I find myself beset by an issue related to the appearance of my homepage on mobile devices. First, it appears the layout of the mobile version differs significantly from the desktop version. I'm looking for someone who can troubleshoot this and ensure consistency across both versions. Your first task will involve ensuring the same layout for both desktop and mobile versions, mirroring the successful desktop version's layout. Next, there's a glitch with the content display on my mobile homepage. It seems to be displaying content incorrectly, and I need you to rectify this. Essentially, your role here will be to fix any errors that cause incorrect content display on mobile, making sure all elements appear as they should. L...

We are in the middle of migrating Django to a new server. - Both servers run Ubuntu 20.04, postgres 12, python2.7 - The Django Project is already transferred over - Nginx has been configured - Postgresql has been setup Our struggle is to get the actual application up and running again. Your job will be to: - help to perform a clean export of the postgres database on old server - help to import the postgres database on the new server - ensure the Django application is coming back up smoothly The work will be done using shared tmate ssh sessions.