IT Issues Analysis - Assignment Example

The benefits that IPv6 offers surpass the limitations that IPv4 has. For instance, the new IPv6 makes it possible to have a plethora of IP addresses as opposed to IPv4. The burgeoning protocol has 128-bit addresses as compared to IPv4, which only has 32-bit addresses. The bit addresses that IPv6 uses to enable the availability of numerous IP addresses. In addition to this, IPv6 eradicates the need for network address translation (NAT) which is present in IPv4 resulting in better peer-peer network connectivity. Further, IPv4 presents security issues, which IPv6 eliminates as it promotes interoperability between myriad implementations (Venkata et al., 2012).

Data Definition Language (DDL) refers to statements that define the schema or database structure. For instance, CREATE – creates objects, ALTER – alters the database structure, DROP – deletes objects, COMMENT – adds comments to the dictionary of data, and RENAME – Renames database objects. DML refers to Data Manipulation Language, which is simply statements that manage data within schematic objects. For instance, SELECT – helps in retrieving data, UPDATE – updates data already present in a table, and CALL – Calls Java or PL/SQL. Data Control Language (DCL) includes commands such as GRANT. It mostly deals with permissions, rights, and additional controls of the database. SQL Server 2012 relies on the above SQL commands for interaction. Transact-SQL presents as central in sending and receiving communication with the SQL server (Microsoft, 2006).

Distributed File System (DFS) enables administrators to make a group of shared folders situated on various servers by connecting each server to one or multiple DFS namespaces. Requirements for DFS to work optimally include Domain Name System as well as Active Directory with proper replication, properly configured Active Directory sites, properly working domain controller emulator, domain controllers as well as root servers with active Distributed File System (DFS), computers running on Windows XP, Windows Server 2003, Windows 2000 Service Pack 4, or Windows NT 4.0. In addition to that, firewalls on the computers should not block remote procedure calls (RPC) needed by DFS and its root server (Microsoft, 2006).

When discussing DFS, people frequently ask about its advantages. DFS has various advantages including improved accessibility and management of resources, remote access to shared folders, fault tolerance due to the ability to replicate shares, and workload management as it allows administrators to distribute workloads and shared folders across various servers for more server resource utilization and efficient network. Although DFS presents many advantages, it also has limitations such as running out of capacity, a restriction that does not arise from physical storage limitations. Instead, the issue revolves around built-in restrictions with Windows and the DFS itself. One of the recurrent troublemakers, for instance, is the 260-character bound in pathnames enforced by Windows APIs. A poorly done DFS implementation can exceed that limit easily, leading to an error message instead of file retrieval (Shapiro, 2008).