Computers and Technology Articles
What can be used as a key in Python - ... variable x is holding the number 3, and you assign 4 to x, you've changed the value in x, but you haven't changed the number 3; 3 is still 3. Strings...
How to create a basic program in Python - ...input and output. If you're from a Windows or Mac background, these things may be new to you, and you may be more inclined to question their value. It...
How to use the Python file system - ...to simplify cross-platform filesystem interaction- but I wouldn't recommend it. Instead, read at least the first part of this article. This will give ...
How to ensure data quality - ...our tongue in a lamp socket, but I guarantee you it's a bad idea unless you want to say hi to your cat that your mother told you was "sent off to live...
How to use a foreign key constraint - ...don't take the time to add the foreign key constraint, then the value for order- Number in the orderItem table isn't bound to any domain of values. It...
Triggers in SQL Server programming - ... fill gaps left by constraints by allowing you to handle problems that constraints are incapable of and have the solution automatically occur without ...
How to model the sales order - ...g a simple and recognizable example enables you to check my questions and the answers provided by the fictitious domain expert, and to see for yoursel...
A few lines about database development - ...is no longer just a simple SQL database system; it has become an application platform, a vehicle for the creation of complex and multifaceted data sol...
Iterative code and set based iteration - ...ecord until the end of the file has been reached. SQL Server has cursors as a built-in mechanism for this iteration, hence the term cursor-based code ...
XML definition and basics - ...hat consists of textual annotations, or markup tags, that control the structure or display of textual data. XML allows you to create your own custom m...
What is the prolog of an XML document - ...ier. The version number indicates the version of the W3C XML recommendation that your XML document conforms to. The prolog can also include an encodin...
Explanations to the XML data type - ...converts it to an internal binary representation based on the XQuery/XPath Data Model (XDM) recommendation. The XDM recommendation defines a hierarchi...
How to understand full text search - ...as containers to organize our indexes. Each word in a full-text index also includes a unique key for that record. You should note that in order to ful...
A few words on the simil algorithm - ... In one example, a company had a table with organic chemistry compounds, and their names were sometimes spelled differently. The application presents ...
What is a deadlock error in SQL server - ...n exactly what happened to cause a deadlock and, with that information, in most cases it's possible to fix the root cause and prevent the error comple...
Linux and its memory management system - ...cessor that performs this translation is the memory management unit (MMU). When a process requests memory, the CPU looks up the address in a table p...