Featured Database Articles
Encryption brings data into a state which cannot be interpreted by anyone who does not have access to the decryption key, password, or certificates. Hashing brings a string of characters of arbitrary size into a usually shorter fixed-length value or key. Read on to learn about hashing in SQL Server and how it is different from encryption.
Marcin Policht provides a comprehensive overview of Windows PowerShell’s capabilities in regard to managing SQL Databases (or, in general, cloud-resident resources).
A good DBA needs to have good technical skills but he also has to have good personal skills. In this article, Greg Larsen discusses the personal skills a DBA should have.
Large Oracle instances running on Linux can benefit from using hugepages. Read on to see what hugepages are and how they help Oracle run better.
Exadata is known far and wide for Smart Scans, but sometimes Oracle can do better without one. Read on to see how to know when Oracle decided to not continue with a Smart Scan.
The next big thing after Exadata is the new Oracle 12c Database In-memory feature, which will dramatically improve database performance for analytical queries and OLTP without application re-coding.
Technical support teams usually support familiar hardware and software configurations. Specialization in particular combinations of operating systems and database management software is common, and this allows some team members to gain in-depth experience that is extremely valuable in an enterprise IT setting. How has big data changed this paradigm?
Big data applications are here to stay. The promise of this technology is the ability to quickly and easily analyze large amounts of data and derive from that analysis changes to customer-facing systems. Management believes that the analysis and subsequent changes will drive up customer satisfaction, market share and profits, hopefully at a reasonable cost.
Many big data application implementations seem to begin with an existing data warehouse, one or more new high-volume data streams, and some specialized hardware and software. The data storage issue is often accommodated by installing a proprietary hardware appliance that can store huge amounts of data while providing extremely fast data access. In these cases, do we really need to worry about database design?