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
» Slideshows
» Sitemap
Free Newsletters:
DatabaseDaily  
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

Getting Started with Azure SQL Data Warehouse - Part 4 04/20/2017

Azure SQL Data Warehouse is a new enterprise-class, elastic petabyte-scale, data warehouse service. Join Arshad Ali as he discusses round-robin and distributed tables, and how to create them. He also discusses how partitioning works in SQL Data Warehouse and looks at the impact of choosing the right distribution key. As a bonus Arshad shows you how to leverage PolyBase to quickly and easily import or export data from SQL Data Warehouse.

Does NOLOGGING In Oracle Really Save Time? 04/17/2017

Using NOLOGGING is a time-saver, some say, but is it really?  Read on to see why it may not be and how it can get you into trouble.

Database as a Service: A Practicum 04/13/2017

Vendors now offer Database as a Service (DBaaS) as part of a bundled solution of managed IT services. Delegating database management services to an external provider may have many benefits, but delegating database administration services has many hidden dangers. In this article, we focus on how delegating data modeling to an outside service can cause problems when making application updates, changing business rules or doing performance tuning.

Working with WordPress Result Sets 04/10/2017

Whether you’re fetching a single row or an entire result set, WordPress offers plenty of array types to work with. Read on to learn how to employ WordPress’ $wpdb’s get_row() and get_results() methods.

Backing Up SQL Server Databases Hosted on Azure VMs 04/06/2017

Join Marcin Policht as he provides a comprehensive overview of the different backup options applicable to Azure SQL Server VMs with database files stored on VM disks.

How to Move a Table to a Different File Group 04/03/2017

There may be a time when you want to move a table from one file group to another. It's easy if it contains a clustered index. Read on to learn more.







Recent Headlines
Oracle
Does NOLOGGING In Oracle Really Save Time? 04/17
Setting A Logon Security Message In Oracle 03/27
Unified Audit Trail in Oracle 12c 03/13
more...
MS SQL
Getting Started with Azure SQL Data Warehouse - Part 4 04/20
Backing Up SQL Server Databases Hosted on Azure VMs 04/06
Displaying Backup or Restore Progress 04/03
more...
MS Access
more...
DB2
Database as a Service: A Practicum 04/13
Big Data DBA Support Strategies 03/16
DB2 V12 Features Supporting Large Databases 02/16
more...