| Get information about database administrator (DBA) | | | | "ideal" and any new data needs to be compared to |
| job outlook, description, salary, certifications for SQL, | | | | the data that was previously acquired. This information |
| Oracle and Microsoft. | | | | can be stored indefinitely and new snapshots can be |
| SQL Servers have been growing in business | | | | created at any point to continue tracking specific data. |
| exponentially since they were created in the 1970's. | | | | When saving the user should simply take the name of |
| First created by IBM in San Jose, California, SQL did | | | | the data and add a time stamp to it. This will ensure |
| not become a standard computer language until the | | | | that there is no confusion when accessing the |
| mid-1980s. Since that time, during its growth, there have | | | | information as to what its purpose is. |
| been many upgrades and changes to the SQL | | | | When a SQL server snapshot is dropped, the new |
| relational database management systems, one such | | | | information and the previous information join to form a |
| upgrade is the SQL server snapshot. | | | | completely new set of information. The information |
| A SQL server snapshot is essentially what it sounds | | | | from the snapshot is no longer available and cannot be |
| like, it is a snapshot of the system that is stored and | | | | referenced for projects or projections. When the |
| used as a primary system. When a snapshot occurs, | | | | decision is made to drop it, it is vital that the project |
| the information is stored in the main drive and then | | | | manager or user understands that it will become |
| further information created after the snapshot occurs | | | | irretrievable. |
| is stored in a new data is stored in what is called a | | | | While some business may never drop a SQL server |
| sparse file. A snapshot creates a backup of the | | | | snapshot, others may find that they simply want to |
| system at that time, and uses 90% less drive space | | | | test their data against studies that may have been |
| than backing up the system does. This information is | | | | conducted or to simply experiment with different ways |
| stored for as long as the user requires it, and can be | | | | of looking at their data. Once the information is |
| dropped when no longer needed. | | | | retrieved the SQL snapshot is dropped in favor of |
| The purposes of a SQL server snapshot vary | | | | new testing, or they return to their regular data |
| depending on the needs of the user. In some cases, it | | | | consumption. Companies that track long-term data |
| is used simply to back up the system without having to | | | | may never drop a snapshot, and the SQL servers are |
| use so much drive space during the working day. In | | | | designed to function either way. |
| other situations, it is created when data is perceived as | | | | |