Best Practices of Running Microsoft SQL Server

November 17, 2020

The performance of Microsoft SQL servers has vastly improved in the last few years to emerge as one of the leading contenders for database administration activities. SQL servers act as the core fundamentals for almost all online applications. And with the occurrence of numerous cyber-attacks, organizations must follow best industry practices in running their Microsoft SQL servers.

Default configurations add more value to the usability, functionality, and communications while security aspects are often ignored. And these loops can hamper the system's stability to sustain long-term effectiveness.

At E2E Networks, we held an online webinar for understanding the best practices of running the Microsoft SQL Server. The host was Mr. Jasmeet Bajaj, a Cloud expert from Mieux technologies,who gave the presentation and answered queries along with Mr. Nikhil as the speaker.

Here are the main insights from this webinar for running Microsoft SQL servers that you should follow in fetching higher performance and productivity.

Hardware Considerations

Although there are no specific hardware requirements, they are likely to vary from client to client. Here are the factors that should help you to choose the hardware considerations accordingly:

  • CPU and Memory Setup (Use of Ram Cache pages)
  • Use of 64-bit hardware for both OS as well as SQL Server
  • Memory and Log pages separately
  • Dynamic memory should be more than 2008
  • The number of users in the present system; after 50 users, you should add 1 or 2 GB RAM for every 5 users for better practicing.
  • Execution packages – doubling the RAM can reduce the execution time from 4 hours to 2 hours.
  • Rate of Growth
  • Size of Databases
  • OS Requirements – reserve 2GB Ram for OS default
  • One additional for the number of users at the concurrent level

Storage

It is recommended to have dedicated drivers, for instance,

  • Drive 1 to have database files,
  • Drive 2 to have tempDB files, and
  • Drive 3 to include the OS, program files, and other basic programs.

Network

On the Network aspect, these are recommendations:

  • I/O subsystem
  • Planning requirements
  • Designing for redundancy
  • Partition alignment

Installation and Configurations

Set up storage with database performance, proper allocation, tests, and then enable Instant File Initialization. SQL servers should have a default instance or named instance only for the effective use of SQL server feature selection.

Domain accounts should be part of the SQL service installation and not the default account. There are two authentication modes - Window authentication mode and mixed-mode - that offer enhanced login options for the users.

Treat data files and log files separately for storing as well. Do not go for the same drive as it is considered a bad practice. TempDB's precise location is also a crucial factor.

Security

Although SQL servers are built on several security practices, still, using default settings can lead to a lot of loopholes in the system. There is an essential need for strengthening the Windows server. Some tips include:

  • Securing the operating system.
  • Installing critical fixes and service packs.
  • Configuring the firewall.
  • Lowering the number of employees with access to the Windows Administrator on the SQL server.
  • Securing and encrypting remote access.
  • Implementing activity logging.
  • Restricting all unnecessary services.

You also need to know all the required SQL database components and install these only. System admins must follow the principle of least privileges for the service accounts.

SQL Browser Service

The default purpose of the SQL Browser Service is to offer instance and port information for all the incoming connection requests. Here are some tips for effective implementation of SQL Browser service:

  • Effective usage of SQL server instances.
  • May be stopped in case the default instance is installed.
  • Running securing configuration.
  • Administration and management must consider the positive and negative for using browser service for respective use in the premises.

Database Administrators

Database Administrators must use highly strong and effective passwords to avoid any misuse and thwart attacks. SQL servers need to be updated regularly and have the latest critical patches to avoid any online attacks.

Implement the use of multiple authentication options for logging into the Windows SQL server options. Never use the same account and disable it immediately as it is the first place for attackers via the brute-force attack.

Have a strong database backup strategy and follow the industry standards with -

  • Online transaction processing
  • Frequency of schema changes
  • Data loading patterns
  • Nature of the Data
  • Restoring and more
  • Have protection against all the SQL injection attacks

Use the precise encryption on a specific location with Transparent Data Encryption (TDE), Always Encryption, and Column-Level Encryption.

Documentation

Maintaining documentation can have several benefits. System admins must have thorough documentation for newbie and even expert professionals to board the system effectively.

Essentials steps for documentation include:

  • Parameters for installation and configuration.
  • Current Application Configuration.
  • Troubleshooting tasks.
  • Database Recovery plans.
  • All changes made to the current database.

Also, admins need to make sure that documentation is easily available within an organization for users who need it the most.

Conclusion

These practices define the way organizations must run Microsoft SQL servers on their premises. Here, consistency is the key to following these practices regularly and applying all of them step-by-step. Admins need to make sure that each step has its importance, and following them with the best industry standards will make the data secure for their organization.

Signup here for a free trial: https://bit.ly/3mFerJn

Latest Blogs
This is a decorative image for Project Management for AI-ML-DL Projects
June 29, 2022

Project Management for AI-ML-DL Projects

Managing a project properly is one of the factors behind its completion and subsequent success. The same can be said for any artificial intelligence (AI)/machine learning (ML)/deep learning (DL) project. Moreover, efficient management in this segment holds even more prominence as it requires continuous testing before delivering the final product.

An efficient project manager will ensure that there is ample time from the concept to the final product so that a client’s requirements are met without any delays and issues.

How is Project Management Done For AI, ML or DL Projects?

As already established, efficient project management is of great importance in AI/ML/DL projects. So, if you are planning to move into this field as a professional, here are some tips –

  • Identifying the problem-

The first step toward managing an AI project is the identification of the problem. What are we trying to solve or what outcome do we desire? AI is a means to receive the outcome that we desire. Multiple solutions are chosen on which AI solutions are built.

  • Testing whether the solution matches the problem-

After the problem has been identified, then testing the solution is done. We try to find out whether we have chosen the right solution for the problem. At this stage, we can ideally understand how to begin with an artificial intelligence or machine learning or deep learning project. We also need to understand whether customers will pay for this solution to the problem.

AI and ML engineers test this problem-solution fit through various techniques such as the traditional lean approach or the product design sprint. These techniques help us by analysing the solution within the deadline easily.

  • Preparing the data and managing it-

If you have a stable customer base for your AI, ML or DL solutions, then begin the project by collecting data and managing it. We begin by segregating the available data into unstructured and structured forms. It is easy to do the division of data in small and medium companies. It is because the amount of data is less. However, other players who own big businesses have large amounts of data to work on. Data engineers use all the tools and techniques to organise and clean up the data.

  • Choosing the algorithm for the problem-

To keep the blog simple, we will try not to mention the technical side of AI algorithms in the content here. There are different types of algorithms which depend on the type of machine learning technique we employ. If it is the supervised learning model, then the classification helps us in labelling the project and the regression helps us predict the quantity. A data engineer can choose from any of the popular algorithms like the Naïve Bayes classification or the random forest algorithm. If the unsupervised learning model is used, then clustering algorithms are used.

  • Training the algorithm-

For training algorithms, one needs to use various AI techniques, which are done through software developed by programmers. While most of the job is done in Python, nowadays, JavaScript, Java, C++ and Julia are also used. So, a developmental team is set up at this stage. These developers make a minimum threshold that is able to generate the necessary statistics to train the algorithm.  

  • Deployment of the project-

After the project is completed, then we come to its deployment. It can either be deployed on a local server or the Cloud. So, data engineers see if the local GPU or the Cloud GPU are in order. And, then they deploy the code along with the required dashboard to view the analytics.

Final Words-

To sum it up, this is a generic overview of how a project management system should work for AI/ML/DL projects. However, a point to keep in mind here is that this is not a universal process. The particulars will alter according to a specific project. 

Reference Links:

https://www.datacamp.com/blog/how-to-manage-ai-projects-effectively

https://appinventiv.com/blog/ai-project-management/#:~:text=There%20are%20six%20steps%20that,product%20on%20the%20right%20platform.

https://www.datascience-pm.com/manage-ai-projects/

https://community.pmi.org/blog-post/70065/how-can-i-manage-complex-ai-projects-#_=_

This is a decorative image for Top 7 AI & ML start-ups in Telecom Industry in India
June 29, 2022

Top 7 AI & ML start-ups in Telecom Industry in India

With the multiple technological advancements witnessed by India as a country in the last few years, deep learning, machine learning and artificial intelligence have come across as futuristic technologies that will lead to the improved management of data hungry workloads.

 

The availability of artificial intelligence and machine learning in almost all industries today, including the telecom industry in India, has helped change the way of operational management for many existing businesses and startups that are the exclusive service providers in India.

 

In addition to that, the awareness and popularity of cloud GPU servers or other GPU cloud computing mediums have encouraged AI and ML startups in the telecom industry in India to take up their efficiency a notch higher by combining these technologies with cloud computing GPU. Let us look into the 7 AI and ML startups in the telecom industry in India 2022 below.

 

Top AI and ML Startups in Telecom Industry 

With 5G being the top priority for the majority of companies in the telecom industry in India, the importance of providing network affordability for everyone around the country has become the sole mission. Technologies like artificial intelligence and machine learning are the key digital transformation techniques that can change the way networks rotates in the country. The top startups include the following:

Wiom

Founded in 2021, Wiom is a telecom startup using various technologies like deep learning and artificial intelligence to create a blockchain-based working model for internet delivery. It is an affordable scalable model that might incorporate GPU cloud servers in the future when data flow increases. 

TechVantage

As one of the companies that are strongly driven by data and unique state-of-the-art solutions for revenue generation and cost optimization, TechVantage is a startup in the telecom industry that betters the user experiences for leading telecom heroes with improved media generation and reach, using GPU cloud online

Manthan

As one of the strongest performers is the customer analytics solutions, Manthan is a supporting startup in India in the telecom industry. It is an almost business assistant that can help with leveraging deep analytics for improved efficiency. For denser database management, NVIDIA A100 80 GB is one of their top choices. 

NetraDyne

Just as NVIDIA is known as a top GPU cloud provider, NetraDyne can be named as a telecom startup, even if not directly. It aims to use artificial intelligence and machine learning to increase road safety which is also a key concern for the telecom providers, for their field team. It assists with fleet management. 

KeyPoint Tech

This AI- and ML-driven startup is all set to combine various technologies to provide improved technology solutions for all devices and platforms. At present, they do not use any available cloud GPU servers but expect to experiment with GPU cloud computing in the future when data inflow increases.

 

Helpshift

Actively known to resolve customer communication, it is also considered to be a startup in the telecom industry as it facilitates better communication among customers for increased engagement and satisfaction. 

Facilio

An AI startup in Chennai, Facilio is a facility operation and maintenance solution that aims to improve the machine efficiency needed for network tower management, buildings, machines, etc.

 

In conclusion, the telecom industry in India is actively looking to improve the services provided to customers to ensure maximum customer satisfaction. From top-class networking solutions to better management of increasing databases using GPU cloud or other GPU online services to manage data hungry workloads efficiently, AI and MI-enabled solutions have taken the telecom industry by storm. Moreover, with the introduction of artificial intelligence and machine learning in this industry, the scope of innovation and improvement is higher than ever before.

 

 

References

https://www.inventiva.co.in/trends/telecom-startup-funding-inr-30-crore/

https://www.mygreatlearning.com/blog/top-ai-startups-in-india/

This is a decorative image for Top 7 AI Startups in Education Industry
June 29, 2022

Top 7 AI Startups in Education Industry

The evolution of the global education system is an interesting thing to watch. The way this whole sector has transformed in the past decade can make a great case study on how modern technology like artificial intelligence (AI) makes a tangible difference in human life. 

In this evolution, edtech startups have played a pivotal role. And, in this write-up, you will get a chance to learn about some of them. So, read on to explore more.

Top AI Startups in the Education Industry-

Following is a list of education startups that are making a difference in the way this sector is transforming –

  1. Miko

Miko started its operations in 2015 in Mumbai, Maharashtra. Miko has made a companion for children. This companion is a bot which is powered by AI technology. The bot is able to perform an array of functions like talking, responding, educating, providing entertainment, and also understanding a child’s requirements. Additionally, the bot can answer what the child asks. It can also carry out a guided discussion for clarifying any topic to the child. Miko bots are integrated with a companion app which allows parents to control them through their Android and iOS devices. 

  1. iNurture

iNurture was founded in 2005 in Bengaluru, Karnataka. It provides universities assistance with job-oriented UG and PG courses. It offers courses in IT, innovation, marketing leadership, business analytics, financial services, design and new media, and design. One of its popular products is KRACKiN. It is an AI-powered platform which engages students and provides employment with career guidance. 

  1. Verzeo

Verzeo started its operations in 2018 in Bengaluru, Karnataka. It is a platform based on AI and ML. It provides academic programmes involving multi-disciplinary learning that can later culminate in getting an internship. These programmes are in subjects like artificial intelligence, machine learning, digital marketing and robotics.

  1. EnglishEdge 

EnglishEdge was founded in Noida in 2012. EnglishEdge provides courses driven by AI for getting skilled in English. There are several programmes to polish your English skills through courses provided online like professional edge, conversation edge, grammar edge and professional edge. There is also a portable lab for schools using smart classes for teaching the language. 

  1. CollPoll

CollPoll was founded in 2013 in Bengaluru, Karnataka. The platform is mobile- and web-based. CollPoll helps in managing educational institutions. It helps in the management of admission, curriculum, timetable, placement, fees and other features. College or university administrators, faculty and students can share opinions, ideas and information on a central server from their Android and iOS phones.

  1. Thinkster

Thinkster was founded in 2010 in Bengaluru, Karnataka. Thinkster is a program for learning mathematics and it is based on AI. The program is specifically focused on teaching mathematics to K-12 students. Students get a personalised experience as classes are conducted in a one-on-one session with the tutors of mathematics. Teachers can give scores for daily worksheets along with personalised comments for the improvement of students. The platform uses AI to analyse students’ performance. You can access the app through Android and iOS devices.

  1. ByteLearn 

ByteLearn was founded in Noida in 2020. ByteLean is an assistant driven by artificial intelligence which helps mathematics teachers and other coaches to tutor students on its platform. It provides students attention in one-on-one sessions. ByteLearn also helps students with personalised practice sessions.

Key Highlights

  • High demand for AI-powered personalised education, adaptive learning and task automation is steering the market.
  • Several AI segments such as speech and image recognition, machine learning algorithms and natural language processing can radically enhance the learning system with automatic performance assessment, 24x7 tutoring and support and personalised lessons.
  • As per the market reports of P&S Intelligence, the worldwide AI in the education industry has a valuation of $1.1 billion as of 2019.
  • In 2030, it is projected to attain $25.7 billion, indicating a 32.9% CAGR from 2020 to 2030.

Bottom Line

Rising reliability on smart devices, huge spending on AI technologies and edtech and highly developed learning infrastructure are the primary contributors to the growth education sector has witnessed recently. Notably, artificial intelligence in the education sector will expand drastically. However, certain unmapped areas require innovations.

With experienced well-coordinated teams and engaging ideas, AI education startups can achieve great success.

Reference Links:

https://belitsoft.com/custom-elearning-development/ai-in-education/ai-in-edtech

https://www.emergenresearch.com/blog/top-10-leading-companies-in-the-artificial-intelligence-in-education-sector-market

https://xenoss.io/blog/ai-edtech-startups

https://riiid.com/en/about

Build on the most powerful infrastructure cloud

A vector illustration of a tech city using latest cloud technologies & infrastructure