SharePoint Lists Clearly Explained

SharePoint is an excellent product for collaboration and content management; however, it is also a great database front end. In this post, I will explain how a list is really nothing more than a data entry and data reporting interface for a back end database.

When you create a list in SharePoint, you are actually creating a set of database table in the back end SQL Server. Because SharePoint allows you to create your own custom lists, the back end database tables are not as simple as traditional tables one might create in a database-driven application, but they are tables nonetheless.

In order to support the list, SharePoint will store two important sets of information. The first is the description of the SharePoint lists and the second is the data stored in the lists. The description of the lists will contain the columns included and the requirements of those columns as well as the lists properties, such as the name and description. The data stored in the SharePoint lists will be in a different table. This table contains all of the column values for all of your lists with list IDs used to map them to the appropriate visible list in the SharePoint interface.

You can verify all of this by directly querying the back end SQL Server database. I don't recommend that you play around in this back end database very much as your actions could quickly lead to disaster (accidentally deleting or improperly modifying data), but you can see the structure SharePoint uses to store the list.

The next time you need a simple tracking table, consider using a SharePoint list. The SharePoint lists will have automatically generated forms. The data will be backed up automatically with your, hopefully, already scheduled SharePoint backups. And the interface will be familiar to your users.

Custom lists provide yet another way that SharePoint shows its power. I'll provide a demonstration video soon showing you just how to create such a custom list. Until then, happy computing!

877-670-5577 – Overcharged Mortgage Loan Fraud

As you know, I try to keep people informed anytime I receive a mailing that is either fraudulent or intentionally misleading. The letter comes with absolutely no name on the letter. Only a phone number is given, which is 877-670-5577. You are informed that "Through government studies it has been brought to our attention that your loan as well as many other loans may have been overcharged or miscalculated several thousands dollars." Notice the manipulative language, "may have been." This phrase is intentionally used to relieve them of responsibility and to suck you in. When you receive such mailings, always interpret "may have been" to mean "99.9999% of the time it was not!" That's the safest practice.

The truth is that loans are rarely overcharged and, in most cases, companies offering mortgage audits charge you to inform you that everything was done correctly. Don't fall for the scam and don't call the number. If you call 877-670-5577, you can be certain you will be harassed for months to come. Let your family members know to avoid this organization and to ignore any messages or phone calls from them.