Uncategorized

Introduction CompTIA, short for the Computing Technology Industry Association, is a global leader in IT certification and education, dedicated to advancing the IT profession at all career levels. Offering a spectrum of certification courses, CompTIA equips individuals with the necessary skills for careers in IT, including cybersecurity, cloud computing, network administration, and more, catering to a diverse range of technological fields. Its certifications, recognized across the industry, serve as standards for IT expertise. In this article, we will explore how CompTIA’s comprehensive 2024 strategy aims to broaden its IT certification…

Amazon Web Services (AWS) stands out as a top-tier cloud computing platform, providing an extensive array of services, including computing power, databases, storage, and enabling scalable and flexible solutions for businesses worldwide. AWS offers a range of certifications vital for IT professionals, enhancing skills, validating expertise, and boosting career opportunities. In 2024, Amazon Web Services (AWS) offers a range of certifications categorized by levels and roles. Obtaining AWS certification requires passing an exam that includes multiple-choice questions and hands-on scenarios. To navigate this process effectively, a crucial step is understanding…

New Microsoft Certifications Coming in 2024 Microsoft is a renowned IT vendor that has earned its reputation through decades of innovation and excellence. With a vast array of software solutions, including Windows, Office, Azure, and more, Microsoft has become an integral part of the global IT landscape. To excel in the IT industry and leverage Microsoft’s tools effectively, earning Microsoft certifications is essential. Microsoft certifications validate one’s expertise in various Microsoft technologies and demonstrate a commitment to staying updated in a rapidly evolving field. These certifications, thoughtfully categorized into proficiency…

25, 112, 114. configure security principals (MIs and VMs) Now in addition to database roles on the Mi and VM we’ve also got logins and server roles. So let’s just have a look at the fixed server roles that are there. So we have Sysadmin so that’s any activity so be very careful giving people sysadmin Server admin you can change server wide configuration options including shutting down the server security admin. This is another one you need to be aware of just like the DB security admin appear in…

24, 112. create users from Azure AD identities (MIs and VMs) In this video we’re going to look at how we can create users from Azure Active Directories from this perspective of the managed instance and the virtual machine. So first of all, we can create users using create user name of user from external provider. We’ve had a look at that in Azure SQL database. Now we can create a user not from Azure Active Directory identity as follows. You can say create login name of login with a…

17, 18. evaluate requirements and strategies for the upgrade Hello and in this section we’re going to be talking about an upgrade strategy for moving to Azure. So what do we mean by upgrade? Well, it’s possible that you’re on SQL Server 2012 and you want to go to a virtual machine with SQL Server 2019, so that would be an upgrade. Now, we’ve previously got this virtual machine that you can see here and this is running SQL Server Server 2019 and you can tell that from the server…

94. configure replication – Active Geo-replication In this video, we’re going to configure replication. And I’m going to go to my SQL database here. And on the left hand side we’ve got on the data management Replicas. Now, this keeps moving. It was in the settings, for instance, in 2020, and then it was called Geo replication early in 2021. Now. It’s called replicas. So you can see no Replicas found and indeed read. What we’re seeing here is quite different to what was there in 2020. So this bit…

84. recommend HADR strategy based on RPO/RTO requirements Hello. Now, we’ve had a look in the previous section about restoring and that’s part of disaster recovery. What happens if a major problem happens? Well, in this section we’re going to continue looking at high availability and disaster recovery. And in this video we’re going to have a look at how we can recommend a high availability disaster recovery. So ha d strategy. So let’s have a look at the SLA. So these are service level agreements. So this is what…

98. configure quorum options for a Windows Server Failover Cluster In this video we’re going to talk about quorum options. Now, always on availability groups and failover cluster instances, rely on the underlying Windows Server Failover Clustering Service. And you might see that with an acronym WSFC. It monitors the network connections and the health of the nodes. So we have got these nodes, these clustered servers, and I’ve got a two nod cluster. Now this will function quite happily. If both of these are up, fine. If one is…

100. Configure failover cluster instances on Azure VMs Now in this video we’re going to install Failover Clustering. So we need to install a Windows Failover Cluster role and we do that in Server Manager by going to manage Add Roles and features again. So just skip down to the Features section. And here we have failover clustering. So click Add Feature Features and Next and install. And we’re also going to do that on the SQL Server number Two. So exactly, same thing, manage Add roles and features next…