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...
Standard Members
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...
Tips for using Merge Replication in SQL Server 2017 (Part 2)
Tips for using Merge Replication in SQL Server 2017 (Part 2) If you do not need continuous replication, do not configure the Merge Agent to run continuously. Try to schedule the Merge Agent to run at regular intervals instead of running continuously. Try to schedule it during CPU idle time and slow production periods. By using it, you can decrease...
How to Stress Less During the Day
This question came from a busy professional. How to stress less throughout the day What are some tips for busy woman regarding how to stress less throughout the day? What are some ways in the morning, afternoon, and night that you can relax a little more — physically, mentally, emotionally? Easy ways and easy to remember! There are a few...
Tips for using Merge Replication in SQL Server 2017 (Part 1)
Tips for using Merge Replication in SQL Server 2017 (Part 1) Avoid using join filters with five or more tables. Because join filters with five or more tables can significantly degrade merge replication performance, you should avoid join filter for the small lookup tables, or denormalize the database design instead of using join filters with five or more tables. Use...