Blogs Tech

SQL Server 2019 Review

09:10 16/02/2022
The Big Tech Microsoft has released SQL Server 2019 edition with unique features. SQL Server 2019 is considered a suitable tool for database experts and a prominent tool for users to keep up with advanced technology. Microsoft built SQL Server 2019 on top of the intelligent query processing features implemented in earlier versions of SQL Server. Microsoft also extended SQL Server to the new components of the database engine with more remarkable edges. 1. Introduction to SQL Server 2019 SQL Server 2019 is a database management engine built on the concept of artificial intelligence to facilitate, improve database services, secure, and reduce problems encountered when developing applications and housing data. SQL Server 2019 integrated with the Cloud that offers organizations the benefits of high security and data synchronization across multiple computers and other modern devices. SQL Server 2019 creates a unified data platform that comes with Apache Spark and Hadoop Distributed File System (HDFS) to get smarter with all data. 2. What is distinctive about SQL Server 2019? SQL Server 2019 delivers innovative and industry-leading performance, security and compliance, mission-critical availability. The product also provides advanced analytics to all data workloads and supports big data capabilities built-in, which saves users a lot of time when commencing a project. 2.1. Big Data Clusters and PolyBase Microsoft implements Big Data Clusters into SQL Server 2019 to bring flexibility and scalability to enterprise data platforms. SQL Server 2019 big data cluster is deployed as a container on Kubernetes, connecting the SQL Server database engine directly to Apache Spark. As a result, users can get insights from all data via query relational data to obtain an overview. This feature set is considered an improvement for PolyBase (an optional component in SQL Server) as about connecting SQL Server 2019 with Oracle, Teradata, and MongoDB while providing connectivity to other data sources. Microsoft calls this “data virtualization”. Data virtualization with PolyBase lets you use SQL Server 2019 as a data center, querying multiple sources. PolyBase is included in the SQL Server Standard Edition, making it accessible for many users. Additionally, users can install PolyBase as a scale-out group to improve the performance and scalability of SQL Server 2019. [caption id="" align="aligncenter" width="979"] Component diagram of a SQL Server big data cluster | Source: Microsoft[/caption] 2.2. Intelligent query processing The Query Store is an excellent feature introduced in SQL Server 2016. This feature gives users the ability to obtain information about runtime and execution plans for queries. Therefore, the database administrator can quickly identify the root of the performance issue. In SQL Server 2019, Microsoft gives the default Query Store features extra improvements by adding automatic tuning for performance regression. [caption id="" align="aligncenter" width="640"] Evaluate the performance using Query Store | Source: Microsoft[/caption] 2.3. Smart monitoring To limit the resource contention that Query Store causes on some systems, SQL Server 2019 introduces an option to customize data collection. In addition, SQL Server 2019 also updates some improvements around the collection of execution plans. With these updates, users can capture actual execution plans, check the number of rows used by the query, compare them with the estimates given by the optimizer, and identify performance issues quickly. 2.4. Faster Database Recovery Microsoft has improved the database recovery process of SQL Server 2019 by implementing the version list to allow transactions to be updated much faster after a server restoration or update, with sample recovery taking only 1 second. [caption id="" align="alignnone" width="733"] Fast data recovery time down from 90 seconds to 1 second | Source: Microsoft[/caption] 2.5. Performance Optimization SQL Server often crashes when the system tries inserting sequential records into a very high volume table. This issue occurs due to memory contention since only one thread can access one data page at a given time. The in-memory OLTP feature is set up to handle it. However, its weakness is that it is not 100% compatible with all data types, so it is not available everywhere. In addition, SQL Server 2019 introduced two additional features: “Optimize_for_sequential_key” and TempDB. While “Optimize_for_sequential_key” reduces the impact of issues, increasing performance by up to 40%, TempDB eliminates bottlenecks at the data layer by leveraging the in-memory OLTP feature. 2.6. Other features Besides the above outstanding features, SQL Server 2019 allows users to create indexes in the maintenance window or re-build after a server crash. Enhanced encryption also allows the database engine to operate on data encrypted in T-SQL unseen by administrators. SQL Server 2019 versions are now available at FPT Smart Cloud at good offers: – SQL Server 2019 – 1 User CAL – SQL Server 2019 – 1 Device CAL – SQL Server 2019 Enterprise Core – 2 Core License Pack – SQL Server 2019 Standard Edition – SQL Server 2019 Standard Core – 2 Core License Pack As the Gold Partner and Business Partner for cloud computing solutions of Microsoft in Vietnam, FPT Smart Cloud is honored to accompany businesses in accessing advanced technology solutions to customers from Microsoft. For further information about FPT Smart Cloud services, please contact us. Fanpage: https://www.facebook.com/microsoft.fptsmartcloud/ Email: [email protected] Hotline: 1900 638 399 FPT Smart Cloud – The leading consulting and solution provider on Cloud Computing and Artificial Intelligence in Vietnam.

Google workspace engineer

17:30 10/02/2022
1. Job Description Consulting on the process for the project to ensure the quality of the whole project.Control the execution of the project process.Receive and monitor the feedback of the parties.Perform measurement and data analysis to evaluate product quality.Prepare reports on project quality and complianceCreate process improvement proposals..  2. Job Requirement 1-5 years of experience in a similar position.Bachelor degrees in IT, Computer Science or related field. Have at least one of the requirements: Understanding of software development processKnowledge of project managementKnowledge of quality management and compliance control 3. Top Benefits  Income package Income package: negotation.Working in a creative environment at the leading Technology Group in Vietnam.Opportunities for advancement: recruited personnel can follow the promotion route to become a Technology Specialist at the FPT Corporation level.FPT premium care package Activities and culture with FCI and FPT Corporation.Study support package for children of FCI union. ---------------------------------------------------------------------------------------------------------------------------------Ngo Viet Anh (Mr.) – Talent Acquisition Team Lead Email: [email protected] |   P: 0989613311Skype: AnhNV (Anthony Ngo) FPT Smart Cloud (FCI) Co., LTD Address:Hanoi: 7th Floor, FPT Tower, no. 10 Pham Van Bach Street, Dich Vong ward, Cau Giay district, Hanoi.  HCMC: 3rd floor, PJICO Tower, no. 186 Dien Bien Phu, Ward 6, District 3, HCMC. Websites: FPT Cloud | FPT AI

Digital Marketing Lead

15:07 10/02/2022
1. Job Description Responsible for tasks related to AI products, target customers B2BDirectly participate in building performance marketing campaignsParticipate in the design and construction of the company's Performance marketing systemParticipating in planning the company's digital space resourcesParticipate in building, directly working with the company's marketing measurement systemsPerform other professional marketing tasks as required by direct management. 2. Job Requirement Graduated with degrees related to Communication, Journalism, or Marketing.At least 3 years of working experience in a similar position. Advantages: Knowledge of CRM & Automation systemGood English speaking & writing skills.Able to work independently, teamwork, meet deadlines. hardworking, responsible, committed, and ability to work under high pressure. 3. Top Benefits Attractive income package, detailed agreement according to capacity.Full benefits according to current labor law.Welfare policies according to the Company's regulations are diverse: Annual health check; FPT health insurance for employees (Financial support with medical examination and treatment costs at all hospitals); Gratitude activities, taking care of employees’ mental health and their family…Friendly, open, respectful working environment.Vacation: participate in large-scale cultural activities of the company and corporation as a whole.Details to be discussed during the interview. ---------------------------------------------------------------------------------------------------------------------Ngo Viet Anh (Mr.) – Talent Acquisition Team Lead Email: [email protected] |   P: 0989613311Skype: AnhNV (Anthony Ngo) FPT Smart Cloud (FCI) Co., LTD Address:Hanoi: 7th Floor, FPT Tower, no. 10 Pham Van Bach Street, Dich Vong ward, Cau Giay district, Hanoi.  HCMC: 3rd floor, PJICO Tower, no. 186 Dien Bien Phu, Ward 6, District 3, HCMC. Websites: FPT Cloud | FPT AI

Marketing Team Leader

14:48 10/02/2022
1. Job Description Head point for campaign implementation, representative working with channels, partners across 2 brands FPT Cloud and FPT AIImplement multi-channel marketing activities to promote demand and brand recognition, including client workshops, industry events,Develop suitble sales documents for each customer segment.Develop detailed content and materials to deliver the product's value for each target customer.Develop and conduct market research to outline how the brand's products and services correlate with competitors.Other tasks as assigned by managers.Build & develop Marketing team in HCMC, support other marketing and internal communication activity in HCMC office 2. Job Requirement Bachelor's degree in Marketing or related fields.At least 3 years of experience in product marketing, content creation.Skilled in data management and analysis.Fluency in English.Proficient in using Microsoft Office, Excel.Experience and knowledge of software/IT is an advantage. 3. Top Benefits Salary: up to 330 million/yearFull benefits according to current labor law.Welfare policies according to the Company's regulations are diverse: Annual health check; FPT health insurance for employees (Financial support with medical examination and treatment costs at all hospitals); Gratitude activities, taking care of employees’ mental health.Friendly, open, respectful working environment.Vacation: participate in large-scale cultural activities of the company and corporation as a whole.Details to be discussed during the interview. ---------------------------------------------------------------------------------------------------------------------------------Ngo Viet Anh (Mr.) – Talent Acquisition Team Lead Email: [email protected] |   P: 0989613311Skype: AnhNV (Anthony Ngo) FPT Smart Cloud (FCI) Co., LTD Address:Hanoi: 7th Floor, FPT Tower, no. 10 Pham Van Bach Street, Dich Vong ward, Cau Giay district, Hanoi.  HCMC: 3rd floor, PJICO Tower, no. 186 Dien Bien Phu, Ward 6, District 3, HCMC. Websites: FPT Cloud | FPT AI

Database Specialist/ Engineer

17:03 25/01/2022
1. Job Description Participate in the development of FPT Smart Cloud's FPT Database Engine platformParticipate in the development of PaaS modules according to the company's strategyParticipating in Cloud Migration projects, strategic projects of FPTParticipate in the design and development of the FPT Database Engine platformParticipating in Cloud Migration projects, FPT's strategic projects 2. Job Requirement Have at least one of the requirements: Graduated from the Faculty of IT/ Mathematics/ Computer Science/ ... Universities of Technology, Engineering (Bach Khoa, National, ...)Good English listening, speaking, reading and writing skillsHave knowledge in the areas is an advantage:  + Linux operating system, Opensource software + Container Platform (Docker, Kubernetes, ...) + Database (SQL & no-SQL), Data Analytics (Spark, Kafka, Hadoop, ...) + API Management + Java/Python/Node.js/Go,… + DevOps 3. Top Benefits Expected salary: Negotiable, open agreement FPT Premium care Activities and culture with FCI and FPT Corporation Study support package for children of FCI union Sponsor related courses and certifications (recommended)   ------------------------------------------------------------------------------------------Ngo Viet Anh (Mr.) – Talent Acquisition Team Lead Email: [email protected] |   P: 0989613311Skype: AnhNV (Anthony Ngo) FPT Smart Cloud (FCI) Co., LTD Address:Hanoi: 7th Floor, FPT Tower, no. 10 Pham Van Bach Street, Dich Vong ward, Cau Giay district, Hanoi.  HCMC: 3rd floor, PJICO Tower, no. 186 Dien Bien Phu, Ward 6, District 3, HCMC. Websites: FPT Cloud | FPT AI

Fullstack Developer – PAAS

16:08 25/01/2022
1. Job Description Platform as a Service Platform Development:Participate in the development of Container Engine platform (Docker, Kubernetes)Participating in the development of subsystems + Application Server, Database as a Service + API Management + Application Performance Monitoring Participating in Cloud Migration project, FPT's strategic projects 2. Job Requirement Graduated from Faculty of IT / Mathematics / Computer Science / ... Universities of Technology, Engineering (HUST, VNU, ...)Full stack developerExperience in developing microservices, APIsLanguages: Python, Golang, NodeJS, JavaKnowledge in the following fields is an advantage: + Container Platform (Docker, Kubernetes, ...) + API Management + Database (SQL & no-SQL) Good English listening, speaking, reading and writing skills  Good English listening, speaking, reading and writing skills 3. Top Benefits Expected salary: Negotiable, open agreement FPT Premium care Activities and culture with FCI and FPT Corporation Study support package for children of FCI union Sponsor related courses and certifications (recommended)   ---------------------------------------------------------------------------------------------------------------------------------Ngo Viet Anh (Mr.) – Talent Acquisition Team Lead Email: [email protected] |   P: 0989613311Skype: AnhNV (Anthony Ngo) FPT Smart Cloud (FCI) Co., LTD Address:Hanoi: 7th Floor, FPT Tower, no. 10 Pham Van Bach Street, Dich Vong ward, Cau Giay district, Hanoi.  HCMC: 3rd floor, PJICO Tower, no. 186 Dien Bien Phu, Ward 6, District 3, HCMC. Websites: FPT Cloud | FPT AI

IAM Engineer (Identity Security Management)

13:12 25/01/2022
1. Job Description Design and develop Identity and Access Management / Single Sign-on features and deploy Active Directory, PAM and MFA systems for infrastructure and on-prem and cloud-based solutions provided by FPT Cloud. Work with Product Owner to discuss business requirements. Work with developers in other departments to integrate the system. Work with the infrastructure team to maintain the production running system. Work with other members of the development team (and partnered teams) to develop new features (including writing code, writing unit tests, integration tests, end-to-end testing, code review by other members, deploy code to environments). Work according to Scrum guidelines. Work with other members of the development team (and partnered teams) to maintain the current system, verify and fix bugs if they arise. Regularly monitor system health to ensure SLA/SLO. Plan to improve technical indicators. Work with team lead/architect to contribute to system architecture design Regularly update architecture and design documents to ensure that they reflect the current system state. Regularly discuss with other members about the architecture and how to develop the system to solve the problem. Actively exchange work status with team and manager.   2. Job Requirement Proficient in administration and use of Linux kernel operating systems (Ubuntu/CentOS...) Deep understanding and experience working with IAM Protocols (SAML, OAuth, OpenID Connect) Proficient in MySQL or PostgreSQL Knowledge of Git, build system, CI/CD Knowledge of system security Strive towards writing clean, easy-to-understand code, according to project standards. Ability/experience in code refactoring and code review.  Advantages (optional):  Have GCP, AWS, Azure certifications Experience working with open-source software Keycloak, FreeIPA Application monitoring (Elasticsearch) & DevOps: Kubernetes / Docker Golang / Python / Java  3. Top Benefits Up to 600-700 million/year income FPT Premium Care   Activities and culture with FCI and FPT Corporation Study support package for children of FCI union Sponsor related courses and certifications (recommended) 

Cloud Engineer (Open Stack)

13:07 25/01/2022
1. Job Description Participate in FPT Smart Cloud's cloud service and platform development team (IaaS, PaaS, SaaS)  Work closely with our SysOps/DevOps/Development teams to manage, develop and maintain our cloud platform (based on Openstack, VMware)  Research and Design products on cloud systems for business requirements (IaaS, PaaS).   Debug complex issues and performance problems of system (Cloud) Openstack deep-dive.  2. Job Requirement Experienced in Openstack, Cloud platform development for cloud service providers (Public cloud) Experience in Python, Ansible... microservices, Openstack, Kubernetes, Docker structures Having knowledge and experience in operating Cloud, Storage, Compute, Network, Security Passionate about developing services that serve a large number of users Bonus point: Understanding of Cloud services in the world: Azure, AWS, GCP  3. Top Benefits Flexible income according to ability, open agreement FPT Premium Care   Activities and culture with FCI and FPT Corporation Study support package for children of FCI union Sponsor related courses and certifications (as recommended) ---------------------------------------------------------------------------------------------------------------------------------Ngo Viet Anh (Mr.) – Talent Acquisition Team Lead Email: [email protected] |   P: 0989613311Skype: AnhNV (Anthony Ngo) FPT Smart Cloud (FCI) Co., LTD Address:Hanoi: 7th Floor, FPT Tower, no. 10 Pham Van Bach Street, Dich Vong ward, Cau Giay district, Hanoi.  HCMC: 3rd floor, PJICO Tower, no. 186 Dien Bien Phu, Ward 6, District 3, HCMC. Websites: FPT Cloud | FPT AI