Automatic backup sql server 2005 jobs

...Predictive Analytics functionalities. Key Requirements: - Proven experience in implementing AI features in Power BI is a must. - Strong background in Natural Language Processing, Machine Learning Models, and Predictive Analytics. - Proficient in working with SQL databases and Online APIs for data integration. - Ability to deliver a dashboard with basic filtering and sorting capabilities. Your main tasks will include: - Integrating the AI functionalities into the Power BI project. - Ensuring seamless communication between Power BI and the SQL databases, Online APIs. - Implementing a user-friendly interface with basic filtering and sorting options. If you are confident in your Power BI and AI skills, and have the technical expertise to deliver such a project, I would love...

...VPN/Internet gateway solution. This project involves building server software capable of authenticating client connections and providing access to the internet. Requirements: Master's degree or PhD in Computer Science, Cybersecurity, or a related field Extensive experience in internet security, privacy, and VPN technologies Strong proficiency in server-side software development Familiarity with OpenWrt and router firmware development (preferred) Passion for internet security and privacy Responsibilities: Develop robust Wireguard exit nodes and VPN server software Ensure seamless integration with existing client software and VPN router firmware Implement secure authentication mechanisms for client connections Design scalable server architecture for hos...

I am looking for an expert in RFID technology and .NET programming to integrate the RFID into our current weighbridge system. Key Details: - 3rd Party System was developed using .NET and it does support API or external interface connections. - The task will involve programming to fully integrate the system with RFID technology. Skills and Experience: - Proficiency in .NET programming & SQL Database - Previous experience with RFID technology - Knowledge of API integration - Experience with weighbridge systems would be a huge advantage. Your role will be to ensure the smooth functioning of the weighbridge system post-integration and provide us with a user-friendly, effective RFID solution.

...*** I'm facing significant challenges with my WooCommerce website's performance. Here's what I'm experiencing: - Slow page loading - High server load - Database query delays Although I’m already employing caching plugins and techniques for performance optimization, the difficulties persist. My WooCommerce site is hosted on a VPS/Dedicated hosting package. I'm in need of a WooCommerce expert who has significant experience in performance optimization, handling high server loads, and reducing database query delays. The ideal candidate should have: - Proven experience in troubleshooting and improving WooCommerce site performance - Strong knowledge of server management, particularly VPS/Dedicated hosting - Expertise in database managem...

We need to redesign our website into a more modern and responsive version with increased conversion potential. The main sections should be: Home page: Search page: (you can view it by performing a search on the site) Individual hotel page: Individual offer page: https://www.ischiahotel.net/d...signshare&utm_medium=link&utm_source=editor I do not want templates from ThemeForest or other marketplaces. Before assigning the work, I want to see a design draft, and then I can entrust it to someone. I would prefer it to be made with Bootstrap 5 because I am familiar with the framework, but it is also fine without it Budget maximum: 70 USD Please reply only if interested I not reply to automatic message

• Experience with Testing tools Experienced using SQL Advanced experience developing test metrics and reports Experience with Automated Testing Five (5) • years of Testing experience in a Software Development Lifecycle environment Five (5) • SQL and PLSQL Programming in SQL Server ETL and Data warehouse process Informatica 10 • 20 Informatica Data Quality Profiles , Score Cards SQL Server RDBMS SQL Server Analytics Services SSAS SQL Server Reporting Services SSRS Tableau Reporting BMC Control M Scheduler Tool Data Analysis Data Profiling Application Life Cycle Management Complete Testing process SDLC, Agile Process, SAFE and Kanban methodologies, TFS Tool Good Communication Skills and Quick Learner Se...

...js application. These include improper error handling, server banner disclosure, and misconfigured CORS. Requirements: - Identify and rectify improper error handling, ensuring that user-friendly error messages are displayed and errors are logged for debugging purposes. - Address server banner disclosure, to enhance the security of the application. - Modify CORS configuration to prevent misconfigurations and enhance security measures. I am looking for an expert who is well-versed in AWS, particularly in working with applications. The ideal freelancer for this job should have: - A thorough understanding of AWS services and its integration with Next.js. - Proficiency in addressing security vulnerabilities, in particular server banner disclosure and CORS misconfig...

Sure, ...corporate website. Some new icons will be designed by you. Images and content will be provided by me. For all three websites, content will be provided by me, with no changes to the layout or page structure to expedite the design and development process. New icons will be created for Websites 2 and 3. All websites will be uploaded to our server using HostGator web hosting. Additionally, source files for each website will be sent separately for future use and backup purposes. Each website will include a WhatsApp contact plugin for easy communication. Furthermore, the websites must load quickly, and free plugins for security and SEO purposes will be installed. If you have any questions or need further clarification, please feel free to reach out. Looking forward to ...

...This website's primary purpose is to sell aftermarket vehicle accessories. Therefore, the platform must be designed to facilitate easy browsing, product selection, and checkout. - Select accessories based on Car Make, Model, Varient and Year filters needed. - Inventory Management: I plan to sync my product inventory with a supplier's database. This means the site must be capable of handling automatic updates and stock levels. - Payment Methods: I intend to offer Credit Card Payments, UPI, and Debit Card payment methods on the site. Ideal Skills and Experience: - Proficient in Woocommerce: You should have a strong background in working with the Woocommerce platform, with a focus on e-commerce design and development. - Inventory Management Expertise: Experience in integ...

I am in need of an experienced Vue.js developer who can quickly fix my Vue 2.6 application. When I click on a button to go to another page it works fine in development but when I deploy it gives a 404 error. I need this fixed as fast as possible. When you respond to this posting please put "I CAN DO IT" at the beginning of your bid. I don't want to waste time with automatic bids that nobody answers. And please bid honestly and not low ball then ask what's your budget. I will upload the project when I find a person

I need an experienced engineer to design a Python-based program for a two-axes programmable motion controller that can be integrated into our food processing machine. Key Responsibilities: - The program should support speed control and position control functions. - The system should also feature an automatic reset. Ideal Candidate Skills: - Proficiency in Python programming language - Previous experience in motion control programming - Familiarity with the dynamics of mixing and blending systems in food processing The controller will be used for a mixing and blending system. Please bring any experience that could be relevant to this task. Your expertise is very valuable to us.

My Wo...with AWS and WordPress, this could be a quick fix. - **Backup Restoration**: I have a recent backup of the site. However, I'm not confident about the database connection details in the configuration file. Restoring the backup and ensuring the database connection works correctly is crucial. - **AWS and WordPress Expertise**: Ideal candidates should have experience with both AWS and WordPress. Familiarity with accessing and modifying the WordPress configuration file on AWS servers is a major plus. - **Communication**: Clear and prompt communication is highly appreciated. It's an urgent matter, so I'm looking for someone who can respond quickly and efficiently. Please bid if you're confident in your ability to restore the site from a ba...

I am looking for an experienced developer that have worked on the signal messenger app to rebrand the app change icons and colours. We need installation on our amazon instance signal server and included all required backed services database etc. and publish application with custom icon colours and icons markets google and apple. you can look signal application

We are currently struggling with our WordPress site which is plagued by slow loading times, frequent server crashes and persistent error messages. Given the criticality of the platform, We need an expert who is adept in Internet Information Services (IIS) server management running WordPress environment and troubleshooting it at server level. To be successful in this role, you should demonstrate the following: - In-depth knowledge of IIS servers and WordPress operations - Proven experience in diagnosing and resolving server and website errors - Proficiency in optimizing WordPress sites for enhanced performance Please note, no recent changes or updates have been made to the website or server configuration that could be contributing to these issue. I...

I'm in need of an expert who can help in developing a relational database using SQL and Python. The project will primarily revolve around database management. Consequently, I would appreciate assistance in the following tasks: - Designing a new relational database, ensuring it's optimized for efficiency and performance. - Implementing data import and export capabilities for seamless data movement. - Developing queries to support the database's functionality and ease of use. The ideal candidate for this project should have a strong background in both SQL and Python, with a specific focus on database development. Experience with optimizing databases for performance and some knowledge of data import/export mechanisms would be advantageous. Moreover, an understan...

I'm in need of an expert developer with a keen understanding of PHP, Heroku, and Shopify. This project entails the deployment of a Heroku server where my API key will be secure and stored in an environment variable. You'll also need to utilize this Heroku-based API key on my Shopify platform to access and display user data through API calls. Ideal Skillset and Experience Required: - Proficiency in PHP - Expertise in deploying and managing Heroku servers - Understands how to secure API keys on Heroku - Experience with Shopify API integration and displaying data.

Productbrochure / Productcatalog Hello, we have technical Products here in Europe and search a solution for Productbrochure and Productcatalog as PDF output. I have worked before with Microsoft Publisher, but I search a solution for 2 Catalogs. First Catalog with small products and easy products with photos, details, part number, price for automatic publishing via a Excel File and the second Version is a Catalog which i must make with a software manuell/self, because very strong products, which are not possible to create via excel, only a catalog as information and .... have you a easy and good solution for us, that we can change weekly the products because we add every week 10-50 new products in our excel / erp / website and in the brochure than. But we need a easy software whic...

I require a skilled contractor to integrate an existing API from an unspecified shipping carrier into my Prestashop store. This integration would enable automatic interaction between the carrier and my store. The key functionality sought is for the automatic posting of customer orders to the carrier's system and the subsequent status update in the Prestashop system whenever the carrier adjusts this status. What I expect from freelancers: - Past work details should be included in the application to demonstrate experience and expertise. Required API Functions: - Customer orders made in Prestashop should automatically post to the carrier system via their API. - Any changes of status made by the carrier should reflect in the Prestashop orders panel. Anticipated Status Cha...

Need advanced SQL including stored procedures, functions, based on existing SQL code. Need c# coding with dojo -Ideal Skills/experience * c# with dojo * MS SQL Server proficient. * Expert in advanced SQL features like stored procedures, functions. * complex SQL queries. * generating SQL reports from tables.

I need add an automatic stock control to Amazon, currently the catalogue is contained on a CSV

...requirements for the project: Project Objectives: 1. Script Functionality: - Automatically fetch Arabic text from a specified Twitter account and insert it into Column B of a Google Sheet, starting from Row 2. - Retrieve and insert links for images and videos associated with the tweets into Columns C, D, E, and F respectively. 2. Automation and Updates: - The data retrieval process should be automatic and occur in real-time, ensuring the Google Sheets document is updated continuously, irrespective of whether it is currently open. - Include functionality to fetch tweets within a specific date range through an added menu in Google Sheets. 3. Data Integrity: - Ensure that existing data in Column B is not overwritten, preserving manually entered or previously fetche...

...experience in scraping product-related information from e-commerce sites is essential, with proficiency in Scrapy being crucial for accurate and efficient data extraction. Data Handling: Ability to ensure accuracy and consistency of extracted data. Familiarity with different data formats is advantageous. Dynamic Scraping: Navigation logic for all categories must be contained within the scraper and be automatic, ensuring dynamic updates. Deliverables: Both the spiders and a data sample should be delivered Benefits: Gain experience in scraping e-commerce data and working with Scrapy. Possibility of ongoing work for successful completion. Timeline: Expected completion timeframe. Less than 2 days. Communication: Feel free to ask any questions or seek clarification before submitting ...

...and service aspects of my heavy-duty truck fleet. The system should be able to accomplish the following: - Maintenance Scheduling: Implement a robust maintenance scheduling system to ensure timely servicing of trucks. Print report of due data - Inventory Management: Inventory control for trucks list, spare parts, ensuring they're available when needed. Warn when low count, - Service Reminders: Automatic reminders for upcoming services and maintenance checks. - Reporting and Analytics: Provide detailed reports and analytics for performance evaluation and decision-making. - User Roles: Multiple user roles - for fleet owners, store manager, service technicians, and drivers. - Parts Management: An efficient and effective spare parts management module. Ideal Skills and Experien...

More details: Is this project for business or personal use? Personal What information should successful freelancers include in their application? Past work How soon do you need your project completed? ASAP

...Current website is very slow and couldn't take a back up using updraftplus plugin I need all files and Database copying to new server and testing that it function OK I am in need of a specialist with broad experience in WordPress platform to move my website from its current location to a Virtual Private Server (VPS). Requirements: - Comprehensive knowledge of WordPress site architecture and components. - Extensive experience in website server migration, particularly to VPS hosting. - Ability to ensure that no data is lost during the migration process. - Skilled in backup creation and restoration. - Familiarity with DNS and IP configurations for the new server. The task must be completed with minimal downtime and no loss of data/functionality....

...bring Arthwise to life! This isn't your typical job post – it's more of a collaborative side hustle. We'll be building something together that has the potential to change the game in the finance world. What I'm Looking For: Someone who's passionate about building scalable applications. Experience with backend development, RESTful APIs, and microservices. Familiarity with database management (SQL/NOSQL) and cloud services. A creative problem solver with a knack for turning ideas into reality. What You'll Do: Set up the backend architecture. Implement core and advance functionalities. Database Management Monitoring and Performance Optimization and much more If you're up for the challenge and want to be part of something special, let&#...

...JavaScript, and PL-SQL, as well as familiar with Oracle Database, PL-SQL Developer, Oracle SQL Developer, Eclipse. The project involves writing comprehensive tests for a range of technologies including: - Java and JavaScript. - Spring Framework. - Oracle Database. - XML and JSON. - Junit. - Eclipse/Intellij. - PL-SQL Developer. - Utilizing Github and other version control tools. The ideal candidate must have a deep understanding and practical experience with these technologies. The project has an urgent timeline, so the selected candidate must be able to work under pressure and deliver high-quality results quickly. Ideal Skills: - Proficient in Java, Spring Framework, Oracle, XML, JSON, Junit, and JavaScript. - Experienced with Eclipse/Intellij, PL-SQL...

I need an experienced server administrator to assist me in setting up a domain remotely. he should have some experience with Digital Ocean and Linux server setups The ideal freelancer for this project should have experience in: - Setting up Linux servers, particularly on Digital Ocean - Proficiency in configuring and managing Ubuntu - Experience with Nginx web server software - Understanding of web hosting best practices and security measures - Strong troubleshooting skills in case of any issues. Please note that the server will be used for hosting a website, so it should be optimized for performance and security.

I want a Linux Ubuntu 24.02 expert who knows multiple domain handling on the server. I already created a .conf file but respective subdomain is redirecting to another website than required.

...verbal. - Proficiency in G Suite (Google Docs, Sheets, Slides, Gmail, Calendar) and Microsoft Office - Minimum 15 hours of work per week, with flexibility to adjust hours as needed to accommodate urgent requests. - Availability to work remotely and travel around Bali. - Availability to work during public holidays and weekends. When you are unavailable yourself, you will need to be able to organize a backup. - You will need a good laptop, and you will need to know how to use it. - You will need to be able to drive or ride a scooter. - Knowledge of Bali...

I'm urgently seeking a proficient Android app developer to create a one-of-a-kind dialer app. I need a custom dialer app. My requirements are: Access to device's contacts, browse and search through contacts list within the app, Automatic disablement of default phone dialer or any other dialer apps upon installation,Unique call duration calculation starting at 50 seconds, incrementing by second for each second of the call, and Visible display of call duration during an ongoing call Ideal skills for this job: • Solid background in Android app development • Experience in creating dialer apps or similar • App design proficiency • Excellent time management skills • Strong problem-solving capabilities • Ability to work to tight deadlines • St...

The site was created on WordPress ...at a certain time of day. It should be possible to enable/disable this newsletter from the admin panel * Create in the admin panel the ability to enable/disable automatic sending of invoices * Change the error text when entering incorrect login information on the site * Configure sending an email to the user after granting access to the site * Add a function for automatic publication of advertisements with a check for the presence of contact information in the advertisement. There should be an option to enable/disable this function in the admin panel. * Set a password on the accounts page in the admin panel and on the server on the database (folder) where the accounts are saved, so that no one except one admin (me) can view, de...

I need a word document translated from English to Russian as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the price and timeframe. Thanks!

...admin and user accounts. Ensure all pages of the site are fully functional and debug any issues. Integrate and test the payment gateway to ensure smooth transactions. Develop a robust chat system that allows users to communicate effectively within the site. Set up and troubleshoot an SMS notification system using the Twilio API. Create a feature for sending contact verifications via SMS, with automatic data storage in both admin panel and user dashboard upon login and verification. Enhance site security to protect user data and prevent unauthorized access. Embed video content from Vimeo in a way that conceals the source from users. Display text lessons clearly and ensure all content is accessible. Add a system for users to request access to all lessons, which sends notifications ...

I am in need of a well-versed Python expert to assist in managing a Linux server. This project is task oriented and requires specific skills including: • Working with server data analysis • Implementing web scraping techniques • Establishing automation processes The role also demands a comprehensive understanding of Linux operations and the ability to print headers. A background in server security, setting up database servers and performance optimization would be ideal, but the focus is primarily on Linux server management via Python. Proficiency in Python, Linux, server data analysis and web scraping are must-haves. Experience in automation and server management will highly be appreciated. Looking forward to your knowledgeable a...

Technical Report of automatic tyre inflation system. Need people who have worked in the same

I need messages I receive in a specific server channel to be forwarded to my own servers channel, I do not have admin role for the server channel I will need messages forwarded from, so I need a script or anything you can come up with, I am allowed to invite accounts to the server channel

I'm currently seeking a skilled backend developer who has proven expertise in Python, Java, and Ruby. I need someone who can guide me through whether to use the current source code or start from scratch, a decision that we can make together as the project evolves. As our project's main responsibility is to handle authentication and server configuration, the perfect candidate should be experienced in: - Setting up, managing, and sustaining server configurations - Handling various authentication tasks - Expertise in Python, Java, and Ruby - Decision-making skills concerning source code development This project will be rewarding for someone who enjoys tackling unique challenges and has a flair for problem-solving. If you're up to the task, please don’t ...

I am currently ...currently working on a project that requires the integration of Excel with a PostgreSQL database. As such, I am in need of a freelancer who is proficient in both Excel and PostgreSQL. The primary tasks to accomplish include: 1. Exporting data from Excel to SQL 2. Updating PostgreSQL data using Excel You will be working with various kinds of data as we aim to streamline our operations in a more efficient manner. Ideal skills and experience include: - Solid understanding of PostgreSQL - Expert skills in Excel - Previous experience with SQL data exporting and updating The success of this project highly relies on a flawless data transfer between Excel and PostgreSQL. Your expertise will be extremely valuable to our project's completion. I need this...

I'm currently in need of a proficient developer who can create an automated tool which can secure, efficiently execute, and dispatch BEP20 tokens to an extensive user base. Key Requirements: - Capable of dispersing BEP20 tokens to 15,000 users, each in isolated transactions. - Fitted with an automatic transaction feature. - Incorporates password-protected verification. The perfect candidate: - Proven experience creating similar tools. - In-depth knowledge of BEP20 token transactions. - Skill-set in automation and security measures. This high-volume transaction requirement necessitates a developer who can provide a robust, reliable solution. If you're a seasoned developer with the required skills for building this tool, please submit your bid.

... - Comprehensive functionalities to set up and manage tournaments, effectively track individual participants, and simulate races. - A mechanism to record and sort race times—ranging from fastest to slowest—post-race. This should seamlessly transition into forming divisions or groups. - An efficient system to perform random draw assignments for participants across different race categories. - Automatic placement population after the times are sorted and standings are finalized. - Accurate computation and allocation of prize winnings at the end of each race. Ideal freelancers for this project should be equipped with strong programming skills and experience with creating administratively focused software applications. Familiarity with horse racing and its unique parame...

I've got around 50 image folders with less then 1000 files in jpg format, each with GPS metadata. I need an expert to convert this metadata into Google Earth points. Key requirements: - **Automatic Generation:** The points should be created by extracting metadata from the images, not manually added. - **Output Format:** I need the final points to be saved in KML format, for easy integration into Google Earth. - **Quality Assurance:** Accuracy is key, the points should correctly represent the image positions. They will be broken into 3 colours depending on the date they were taken, the data is in the folder name and file name. Ideal Skills: - **GPS Data Handling:** Understanding of how to extract and work with GPS metadata from images. - **Google Earth Proficiency:** ...

I need a word document translated from English to Russian as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the price and timeframe. Thanks!

...for a proficient professional who can create a report in Microsoft Access from a MySQL database. The report should contain data from the MySQL database, calculations or summaries of data, visualizations or charts, and be structured as a paginated report, using SQL language. The report should be designed to be accessed as a printable PDF document. It is not required to be interactive, as a static report is sufficient for my needs. Key Requirements: - Proficiency in Microsoft Access, MySQL, VBA, PDF, Python, and Excel - Competency in SQL language for data manipulation - Experience in designing paginated reports The ideal candidate should have a proven track record of creating similar reports, with the skills and knowledge necessary to work with the specified technologies...

I need a word document translated from English to Simplified Chinese as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the price and timeframe. Thanks!

I'm looking to set up a Minecraft 1.16 server focused on mini-games. Initially, I'd need 4-6 mini-games to be developed. Key Responsibilities: - Configure and set up a Minecraft 1.16 server - Design and implement 4-6 engaging mini-games - Ensure the server's smooth running and performance Ideal Skills: - Proficiency in Minecraft server setup - Proven experience in mini-games development - Strong understanding of Minecraft 1.16 mechanics - Ability to manage and maintain server performance - Creative problem-solving skills to enhance player experience Looking for a dedicated and experienced Minecraft developer who can not only set up the server but also create fun and unique mini-games within it. The goal is to attract and retain a strong ...

I am in need of a competent data engineer for a small-scale data analysis task. - The project primarily revolves around performing data analysis. - The ideal candidate should be proficient in data analysis techniques. - Previous experience wi...The project primarily revolves around performing data analysis. - The ideal candidate should be proficient in data analysis techniques. - Previous experience with data engineering will be a significant advantage. Your role will mainly involve performing data analysis tasks, so a deep understanding of data engineering and analysis is essential for this project. A strong background in Python, R, or SQL is highly preferred, though not mandatory. Please note that the project timeline is quite flexible, so you will have ample time to complete ...

I'm seeking a highly skilled programmer proficient in Excel macros and ODBC data connections to automate critical processes in my business. Specifically, your tasks will involve: - Automating order tracking, inventory management, and vendor communication processes. - Connecting to Excel files, SQL databases, and CSV files using ODBC. - Developing an automated procurement system capable of: - Generating purchase requisitions, - Aiding in vendor selection and negotiation, - Creating and tracking purchase orders. Proficiency in utilizing Excel macros is a must, and experience with ODBC data connections and related platforms is highly desirable. Knowledge of procurement systems and order logistics would be beneficial. Successful completion of this project requires strong c...

I'm in need of a complex script that combines SMC schools, ICT schools, and commercial use elements into a single Tradi...script development - Understanding of SMC and ICT trading methodologies - Knowledge of classic trading indicators and strategies - Ability to create clear and user-friendly script documentation Experience with liquidity tables and Vortex editing would be an advantage. Please only apply if you are confident in your ability to meet these requirements. For clear information Smc and ict also automatic fibonacci +trend channel + trend lines with SR liens + stock and crypto and forex liquidity table+ dashboard table with major information from rsi and Vortex also macd and Ema 50 also Ema 200 + trend status with multiple frames all in one with control panel can...

I need a skilled professional to help me creating email servers to send bulk emails and managing. - **Email Marketing**: I have been using the server for bulk mailing and email marketing. I need an expert who can optimize these operations, ensuring that the emails are being delivered effectively and not marked as spam. - **Troubleshooting and Support**: Although I did not select this as a specific task, I might need help with troubleshooting and support in the future. It would be great if the individual could provide this assistance as needed. The ideal candidate for this project is someone with extensive experience in managing email servers, particularly with SMTP, bulk mailing, and email marketing. A deep understanding of email deliverability and anti-spam measures is crucial...