Introduction This XML overview tutorial will provided a summary of XML and how it can be used as a data interchange between browsers and servers. JavaScript Object Notation and eXtensible Markup Language, most commonly referred to as JSON and XML, are both designed to solve the problem of maintaining computer-code structure while still keeping human … Continued

Introduction If you’d like to conserve server space and keep your data secure, you may want to consider encoding the data in your database. Using encoding and compression methods can help you safeguard data and save space on a server by streamlining redundant data. In this article, we’ll provide an overview of some common encoding … Continued

Introduction to XML and JSON When data needs to be exchanged between different languages, servers or computers, you need to use a standardized format. For the longest time, XML was the only real choice for data interchange; however, another player came onto the scene in the 2000s. This new competitor was JSON, and the format … Continued

Introduction The world of tech is an ever-changing one, and it moves at what often feels like lightning speed. If you’re a DBA, you know how frustrating it can be to keep up with the latest and greatest in database infrastructure, especially when senior executives view IT as a cost center and balk at the … Continued

Introduction Database Recovery involves the restoration of a database, and the data, to a stable state in the event of a system crash caused by a hack or accidental damage. This typically involves restoring the data from backup files to a point at or near the time of the crash. Because there are certain steps … Continued

Introduction Digital transformation is radically affecting how business systems work. Big trends in modern data are apparent in the areas of social, mobile, analytics, and cloud (SMAC). Scaling databases either vertically, horizontally, or a combination of both is what DBAs must do to propel their organizations forward and match right up with the trend of … Continued

Introduction Backing up a database is an essential task for a DBA. It positively affects data integrity and accessibility. An image copy backup can be incremental or full. Because database and application requirements vary, it’s important to know the difference between the two backup types, so that you can use the most appropriate method to … Continued

Introduction Disk storage is used for preserving data in a database management system (DBMS). Because the information is on the disk, the data must first be retrieved, and then modified or read on disk as well. The in memory databases DBAs must utilize enable them to speed up accessing data. Many DBMSs handle the staging … Continued

Introduction If you’re working as a DBA, you probably find that much of your time is spent tuning database performance. Many DBAs, however, fall into the trap of getting too focused on optimizing SQL statements and application code without considering the impact of the database design and structure itself. The truth is, all the SQL … Continued