Free Newsletters:
DatabaseDaily  
Database Journal
Search Database Journal:
 
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» DBA Jobs
» Sitemap
News Via RSS Feed


follow us on Twitter

Database Journal |DBA Support |SQLCourse |SQLCourse2

Database Management & Programming News, Articles & Tutorials for Database Administrators

Featured Database Articles

SQL Server 2012 Integration Services - Leveraging PowerShell in Package Deployment Model 06/20/2013

SQL Server 2012 Integration Services introduces an innovative approach to deploying SSIS projects, known as Project Deployment Model. Marcin Policht shows you how to leverage PowerShell capabilities when dealing with legacy Package Deployment Model scenarios.

Performance Tuning in the Age of Big Data 06/17/2013

Big Data is here, or will soon be here for the majority of IT enterprises. Database Administrators must now deal with large volumes of data and new forms of high-speed data analysis.  If your responsibility includes performance tuning, here are the areas to focus on that will become more and more important in the age of Big Data.

Using Oracle Enterprise Manager Command Line Interface Part 1 - Installing and Basic Configuration 06/13/2013

The Oracle Enterprise Manager 12c command line interface (Enterprise Manager Command Line Interface - EM CLI) can be used to configure several options that allow for monitoring and auditing the actions performed by users in the graphical interface. Karen Reliford shows you how to install and configure the EM CLI Client.

Oracle Hybrid Columnar Compression in Exadata 06/10/2013

Hybrid Columnar Compression is a compression option available only for tables residing on Exadata storage, which besides Exadata includes Axiom, the SPARC SuperCluster and the Sun ZFS Storage Appliance. Read on to learn more.

MySQL Cursors and Loops 06/06/2013

A loop is a programming construct that executes a block of code repeatedly based on a condition. Cursors, on the other hand, are utilized to process each row returned by a SELECT statement. Read on to learn about various loop types supported by MySQL as well as an introduction to cursors.

xp_cmdshell for Non-System Admin Individuals 06/03/2013

When SQL Server is first installed out of the box, the extended stored procedure “xp_cmdshell” is not enabled; once it's enabled the default behaviors is that it is only available to the logins that have System Admin permissions. Greg Larsen shows you how to setup xp_cmdshell so non-System Admins can use this extended stored procedure.

Database News

Oracle Advances Open Source MySQL Clustering 06/18/2013

The Oracle MySQL Cluster solution adds high-availability and scalability to the open source MySQL database.

PostgreSQL Maven Tom Lane Heads to Salesforce 05/24/2013

The cloud CRM upstart brings a top contributor into the fold as it embarks on a transition to open source.

Oracle Releases Open Source MySQL 5.6 with NoSQL Features 02/05/2013

New database release provides performance and scalability gains

Couchbase 2.0 Advances Open Source NoSQL Database 12/12/2012

It's not just about CouchDB and memcached anymore as new release goes beyond legacy roots.

Project Hekaton: Microsoft Bakes In-Memory Tech into SQL Server 11/09/2012

Microsoft is venturing deeper into in-memory database technology and challenging SAP and Oracle.

VMware Gemfire 7 Scales In-Memory Data Grid 10/31/2012

VMware adds native JSON and improved scale to Gemfire

Open Source Project Red Dwarf Brings Database as a Service to the OpenStack Cloud 10/16/2012

Joint HP Rackspace venture is pushing forward at OpenStack in effort to enable a new world cloud database services.

Oracle Pushes both MySQL 5.6 and Oracle Database 12c Forward 10/02/2012

Big week for Oracle as databases open and closed inch toward release.

More Database News...













Recent Headlines
Oracle
Using Oracle Enterprise Manager Command Line Interface Part 1 - Installing and Basic Configuration 06/13
Oracle Hybrid Columnar Compression in Exadata 06/10
Real Time SQL Monitoring in Oracle Database 11g 05/13
more...
MS SQL
SQL Server 2012 Integration Services - Leveraging PowerShell in Package Deployment Model 06/20
xp_cmdshell for Non-System Admin Individuals 06/03
Managing Slowly Changing Dimension with MERGE Statement in SQL Server 05/28
more...
MS Access
more...
DB2
Performance Tuning in the Age of Big Data 06/17
Managing the Transition to Big Data 05/16
Application Design: Where the DBA Fits In 04/18
more...