Database Management System (DBMS) Architecture The three (3) significant features of the database approach are: (1) Insulation of programs as well as information program data in addition to program operation independence. (2) Assistance of multiple user views; and (3) Usage of a catalog to keep the database description (schema). In this part the architecture for database systems is described, known...
Standard Members
Helping a Local Business Become More Visible
What is your process for helping a local business become more visible? As a business consultant, I normally start off with a discovery session to clarify the client’s business goals. Each client’s process would be unique but generally covers the below steps. Research Phase · An initial discovery session to clarify client’s business goals · Market research and analysis that...
Tips for designing SQL Server 2017 tables (Part 1)
Tips for designing SQL Server 2017 tables (Part 1) Avoid using CLR user-defined data types. SQL Server 2017 supports the CLR user-defined data types. These data types allow implement database data types in any of the languages supported by the .NET Framework CLR. Because using these data types usually provides worse performance than internal SQL Server data types, and you...
Categories of Database and Database Users – Part 1
Database User Interface and Database End User There are four (4) unique kinds of database – framework clients, separated by the manner in which they hope to communicate with the framework. Various kinds of user interfaces have been intended for the distinctive kinds of clients. 1. Naive clients are unsophisticated clients who cooperate with the framework by invoking one of...
When to Conduct a Project ‘Lessons Learned’ Session
Does your evaluation need to be done after every successful or failed project to see if the methods used need to be changed? The short answer is “YES” Some people call them Lesson Learned Sessions. Some people call them Post Mortems. Whatever you call them – I recommend have mini-evaluations after each major milestones or iterations (versus waiting until the...
Tips for using SQL Server 2017 configuration options (Part 2)
Tips for using SQL Server 2017 configuration options (Part 2) Consider changing the ‘fill factor’ option to the appropriate value. The ‘fill factor’ option specifies how full SQL Server 2017 will make each index page. When there is no free space to insert new row on the index page, SQL Server will create new index page and transfer some rows...
Tips for using SQL Server 2017 configuration options (Part 1)
Tips for using SQL Server 2017 configuration options (Part 1) In this article, you can find the description of some useful SQL Server 2017 configuration options with the examples how to make it by using the sp_configure system stored procedure. Note. Because setting up some SQL Server 2017 configuration options can degrade performance you should change these options very carefully...
Database and Hashing Technique – Part 6
DATA DICTIONARY An individual can characterize data dictionary as Database Management System (DBMS) part that stores the meaning of data attributes and connections. An individual might review that such “data about data” were marked metadata. The Database Management System (DBMS) data dictionary gives Database Management System (DBMS) with its self-depicting characteristics. As a result, the data dictionary reference looks like...
How Leaders Communicate the Company’s Vision So That Others Will Share It
Could you give some examples of how leaders can communicate the company’s vision so that others will share it? This is an excellent question. One of the leader’s responsibility is to communicate the company vision, mission statements and goals. One-on-one meetings One of the most effective ways is to meet one-on-one with each employee. 1. Work with each individual to...
Some tips for using ASP.NET with SQL Server 2017
Some tips for using ASP.NET with SQL Server 2017 If you use ADO to access SQL Server data in your ASP.NET, always create a Connection object explicitly, not implicitly. This can reduce the server overhead and simplify the controlling of a connection. Set the MultipleActiveResultSets (MARS) option in the SQL Server connection string. This option makes it possible to execute...