Step-By-Step: Installing MySQL on Nano Server via PowerShell

Recently, Pierre Roman was in town presenting 10 Things I like About Windows Server 2016 to the Toronto ITPRO Usergroup. While presenting, he white-boarded a couple of questions for Pierre and I to address on CANITPRO.NET later via a blog post. One such question was as follows: “Can you install SQL on a Nano Server?”…

0

Step-By-Step: Removing A Domain Controller Server Manually

The proper way to remove a DC server in an Active Directory infrastructure is to run DCPROMO and remove it. The following video provides an example of these steps: There are certain situations however, such as server crash or failure of DCPROMO option, that would require a manual removal of the DC from the system by cleaning up the servers metadata as…


Step-By-Step: Downgrading A Windows Server Domain and Forest Functional Level

Once upon a time, it was not possible to downgrade Windows Server forest and domain functional levels once upgraded. Enter Windows Server 2012 R2 and it's Active Directory enhancements, as detailed by the video below, backed by PowerShell automation capabilities. This enablement makes the forest and domain functional level downgrade even easier. Do keep in mind however that the lowest functional level…


What You Should Consider When Upgrading to SQL Server 2014

Support for SQL Server 2005 comes to an end April 12 2016. Organizations should now start planning to upgrade their databases to SQL Server 2014. While it is SQL 2005 that is retiring, the reality is, there are still SQL Server 2000 databases that are still operational even though they have not been supported by Microsoft since 2013. In fact,…


PowerShell Tips: Who has Access To This Directory?

Here's a question many IT Administrators get from time to time: "Can you tell me who has access to this directory?" This question is being asked more often as many more devices are trying to gain access to the data you secure. While it is easy to see all the groups that have access just by right-clicking…


Step-By-Step: Seizing the Operation Master Roles in Windows Server 2012 R2

A disaster recovery plan is something every organization, no matter how small, should have. It provides piece of mind to not only the business decision makers, but the IT administrators that support said organization as well.  Unfortunately, not all organizations feel the same way and sometimes the perceivable cost is harder to swallow for some…


Step-By-Step: Compacting the DHCP database

To ensure top performance and availability, the DHCP server database requires maintenance from time to time. DHCP database can grow fast, especially in larger organizations, and compacting the DHCP database should be a regular occurrence to adhere to that. A recommendation from Microsoft actually states to compact any database larger than 30mb.   During Windows NT…


Step-By-Step: Changing The UPN Suffix For An Entire Domain Via PowerShell

Some organizations require the use of multiple UPN suffixes for their operations. From time to time, these same organizations will have the requirement to do mass a UPN suffix change. I recently faced said challenge while changing the domain name suffix which ended with .local to a public domain name ending with .com. This needed…


Step-By-Step: Allowing or Preventing Domain Users From Joining Workstations to the Domain

By default, an Active Directory domain environment allows any authenticated domain user the ability to add workstations to said domain 10 times. With that being said, there may come a time and organization may require to increase or decrease this limit.  An example of this would be an authenticated user bringing their personal Surface Pro…


Step-By-Step: Further Detail In Setting Up DirectAccess

Now that you have successfully complete installation of DirectAccess Client services, lets go into further detail regarding the configuration process. Both Windows 7 and Windows Server 2008 R2 DirectAccess are enabled via a solution accelerator called a DCA ( DirectAccess Connectivity Assistant). The DCA is installed on direct access client computers and helps to troubleshoot…