REDUNDANT ARRAY of INDEPENDENT DISKS (RAID) RAID is short for Redundant Array of Independent (or Inexpensive) Disks. It is a classification of disk drives that utilize at least two (2) drives in blend for adaptation to non-critical failure and execution. Redundant Array of Independent (or Inexpensive) Disks (RAID) disk circle drives are utilized habitually on servers yet aren’t for the...
SQL Server
How to Get an Interview When You’re Under-Qualified
How Can We Get an Interview When We’re Under-Qualified? for the job because they don’t meet all the qualifications or have the specified experience. Why should they apply anyway?The mistake that many make is to assume that the employer is looking for that 1 perfect candidate that meets all their wishes. Therefore, if you wait until your 100% qualified, you...
Tips for using indexed views in SQL Server 2017
Tips for using indexed views in SQL Server 2017 Keep the indexes on the views as narrow as possible. Because each index takes up disk space try to minimize the index key’s size to avoid using superfluous disk space. This reduces the number of reads required to read the index and boost overall index performance. Try to create indexes on...
Database and File System Organization – Part 4
HIERARCHY OF DATA Information are the important assets of any organization. Information stored in computer system shape a hierarchy extending from a single bit to a database, the real record keeping element of a firm. Each higher rung of this hierarchy is sorted out from the segments beneath it. Information are coherently sorted out into: 1. Bits (characters) – A...
5 Biggest Mistakes People Make in Presentations
This question came from a busy professional. I’m searching for career experts who can tell me the biggest mistakes people make when making a presentation at work. Most everyone has heard of the more common mistakes of not making eye contact with the audience and relying too heavily on note cards. But here are some of the bigger mistakes that...
Tips to work with SQL Server 2017 clustering
Tips to work with SQL Server 2017 clustering You should proper configure the SQL Server 2017 service accounts. Ensure that each SQL Server 2017 service account is a domain account and a member of the Local Administrators group of each cluster node and a member of the Domain Users group. Set the SQL Server 2017 service accounts passwords to be...
Database and File System Organization – Part 3
Tape file systems A tape file system is a file system and tape format intended to store records on tape in a self-depicting structure. Magnetic tapes are sequential storage media with considerably longer random data access times than disks, posturing difficulties to the creation and proficient administration of a universally useful file system. In a disk file system, there is...
How to Stay Connected as a Remote Worker
This question came from a busy professional. How do you stay connected as a remote worker? As a remote worker, how do you fight feelings of isolation? Especially looking for advice that newcomers to remote work can use. Thank you! In these technological times, it’s even simpler to stay connected. With the advent of video conferencing, online chatting and texting,...
Tips for using User-Defined Functions in SQL Server 2017
Tips for using User-Defined Functions in SQL Server 2017 Consider using user-defined table type as a parameter for user-defined function. SQL Server 2017 supports a user-defined table type that supports representing table structures for use as parameters in user-defined function. Using UDF type can simplify user-defined function’s programming and may increase UDF performance. Use TRY-CATCH logic to trap and handle...
Database and File System Organization – Part 2
The Database Management System (DBMS) modifies entered information to fit in with required data structures. The Database Management System (DBMS) mitigates an individual of the errand of influencing a distinction between the logical information format and the physical information format. That is, the Database Management System (DBMS) organizes the physically recovered information to influence it to comply with the end...