Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
SQL Scripts & Samples
Tips
» Database Forum
» Slideshows
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

Feature Database Articles

MS SQL

Implementing Azure SQL Database Virtual Network Service Endpoints and Rules 12/07/2017

In previous articles, we’ve described the main characteristics of two new features known as Virtual Network service endpoints and Azure SQL Database virtual network rules. In this article, we focus on the details of implementing this functionality.

How to Turn on Instant File Initialization 12/04/2017

Not having instant file initialization turned on slows down the process of adding pages to your database, because prior to allocating the data pages to your database, SQL Server needs to zero out the newly allocated pages. Read on to learn more...

Quickly Restricting Database Access 12/04/2017

There may be times when you need to perform maintenance against a database that requires you to keep normal database users from connecting to your database while the maintenance is being performed.  You want to stop users from connecting right away, but you want the database to be in a state that you can perform maintenance.  Read on to learn how.

more...

Oracle

Oracle's Bulk Collect and Limit Can Be A Problem 12/14/2017

Using Bulk Collect with the Limit clause may not process all of the data in the result set.  Read on to see why and how the problem can be avoided.

Monitoring Oracle's Temp Usage 11/20/2017

It may be necessary to monitor the usage and storage of the TEMP tablespace.  Read on to see how to implement a monitoring strategy that makes sense.

Oracle Upgrades to 12.2.0.1 11/13/2017

Upgrades to the newest Oracle release can create problems depending upon the database configuration.  Read on to see what types of issues can arise and how to address them.

more...

MS Access

more...

DB2

IBM Db2 for z/OS: Version 12 New Features 11/16/2017

Version 12 of IBM's Db2 for z/OS (Db2 12 for z/OS) contains many new features and functions for DBAs and application developers. This latest Db2 version emphasizes performance enhancements across a wide variety of areas, including enhanced on-line transaction performance, improved efficiency for analytical query access paths, removal of some size limitations and exploitation of operating system and storage hardware characteristics.

Database as a Service: An IT Strategic Direction 10/16/2017

Is DBaaS a possible strategic direction for your company’s IT infrastructure? In order to determine this, there are several issues you must address. This article lists the most common risks that require mitigation before embarking upon delegating all or most of your database storage and management to an outside firm.

Database as a Service: Defining Quality 09/18/2017

Application and database definitions are now spread among multiple firms across multiple platforms. Business rules are implemented in (potentially) many places, and many support staff skills are not under your control. This raises the complexity of the application and increases the risks of failure during application changes, maintenance or upgrades. This article addresses how to measure and maintain the quality of your application when you take advantage of database as a service (DBaaS).

more...




Latest Forum Threads
DB2 Forum
Topic By Replies Updated
tables get lock during backup in db2 v9.5 Hamsoo 0 May 8th, 01:03 AM
Query to Pull Last 7 days records from a table vgoushik 0 March 20th, 06:05 PM
DB2 Visual studio addin: ANSI/Unicode problem 10Pints 0 October 5th, 02:08 AM
Things that are everbodys labor day ideas? Lipsett197 0 September 1st, 09:42 AM