database technology
SQL Server Triggers
Triggers are stored procedures which are fired when data is modified in an underlying table. They can evaluate data being added to a table for validation purposes, or can make changes in that or other fields depending on the value of that data. You can use them even to execute a separate stored procedure, or to roll back a data modification or an entire transaction.
MySQL and BLOBs
One of MySQL's strengths is its use of Binary Large Object (BLOB) columns. These columns store unprocessed binary data, typically files, that can be retrieved and manipulated like the other common datatypes. The difficulty comes in accessing the BLOB column in VB. Prior to ADO 2.5, the only way to move data in and out of a MySQL BLOB column using Visual Basic was to use the appendchunk and getchunk methods. With ADO 2.5, the stream object has been added, greatly simplifying the process of working with MySQL BLOBs. In this article, I will focus entirely on using the stream object.
Why SQL Server 2008 R2 Matters to Small Business
The long-awaited SQL Server 2008 update has arrived. Here's why your company should care.
SQL Server Fragmentation Demystified
What is SQL Server defragmentation? How does it happen? How can it be measured? How can it be minimized? How can it be fixed? Is it important?
The answers to these questions are no mystery. Depending on the version of SQL Server in use, the procedures to determine and correct defragmentation are not terribly complicated and in newer versions downright simple. In addition, they can be accomplished without unnecessary disruption of the system.
A High Level Comparison Between Oracle and SQL Server
Organisations often employ a number of database platforms in their information system architecture. It is not uncommon to see medium to large sized companies using three to four different RDBMS packages. Consequently the DBAs these companies look for often have to have a broad range of skills across a number of areas.
| Related News: |
