|
Featured Database Articles
MS SQL
10/14/2013
Learn how to migrate existing SQL Server databases to Windows Azure, starting with identifying obstacles associated with such migrations.
10/03/2013
One of the more exciting new features available with SQL Server 2014 is the new Memory-Optimized tables. Greg Larsen explores how to create Memory-Optimized tables, and what he's found during his initial exploration of using this new type of table.
09/30/2013
SQL Server 2014 enhances columnstore index and overcomes several of the limitations in earlier versions. Read on to learn how you can get started using this enhanced columnstore index feature in SQL Server 2014.
more...
Oracle
10/10/2013
Occasionally a developer believes he or she is better at enforcing referential integrity than the database. Unfortunately referential integrity isn't transactional, so these attempts fail. Read on to see how the situation can be improved by using the built-in features of Oracle.
09/23/2013
With the much-anticipated release of the 12c Database, Oracle has added many new features. Of particular interest in the user security realm are the new features around database privilege management. Read on to learn more.
09/09/2013
Since its introduction in September, 2008, Exadata has fast become both a familiar term and a familiar sight in the IT/database realm. The system has undergone several changes in its short history, from storage solution to complete database appliance.
more...
MS Access more...
DB2
09/19/2013
Big data is the latest craze. Hardware and software vendors have overwhelmed IT departments with high-speed analytical software, proprietary high performance hardware, and columnar-based data stores promising quick access, promising lightning-fast answers to ad hoc analytical queries. Forgotten in this blast of technology are the database administrators' most important responsibilities: backup and recovery.
08/19/2013
To meet the upcoming 'Peak Season' demands on IT systems, database administrators (DBAs) need to prepare the database and its supporting infrastructure for increased resource demands. Being proactive now can pay big dividends by maintaining service level agreements (SLAs), avoiding outages and resource shortages, and ensuring a positive overall customer experience.
07/18/2013
Many IT enterprises are starting pilot projects to implement big data solutions. As a DBA, are you ready to support these efforts, and integrate them into your current architecture, processes, and standards?
more...
|