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
 

Featured Database Articles

Feature Database Articles

MS SQL

Getting Started with Azure SQL Data Warehouse - Part 6 06/19/2017

Azure SQL Data Warehouse is Microsoft’s new enterprise-class, elastic petabyte-scale, data warehouse service that can scale according to organizational demands in just few minutes. Read on to learn the different ways to load data into SQL Data Warehouse.

Introduction to Azure SQL Data Sync 06/05/2017

The majority of Azure SQL Database related features reach their General Availability (GA) stage relatively quickly. There are however, some exceptions. The most prominent example in this category is likely Azure SQL Data Sync, which has remained in Preview since its introduction 7 years ago. Fortunately, there are signs that this service might be finally reaching production-ready state. In our article, we will introduce its main characteristics.

How to Read the Transaction Log File 06/01/2017

Have you ever wanted to be able to see the actual transactions that are contained in the transaction log file? Greg Larsen shows you how to browse the transaction log using an undocumented function.

more...

Oracle

Indexing In Oracle 12c When Extended String Length is Configured 06/12/2017

Extended string lengths can be very beneficial but they can also be an impediment to index and constraint creation. Read on to see what the problems are and how to get around them.

Oracle's Histograms: Bane or Boon? 05/30/2017

Histograms have improved greatly over the years, yet there are still those who won't use them.  Read on to learn what they do and why they may not be as bad as some say.

Oracle B-Tree Index On A BLOB 05/11/2017

Interestingly, you can create a B-tree index on a BLOB column; read on to see how to do it and just how useful, or not, it might be.

more...

MS Access

more...

DB2

Database as a Service: Your First Application 06/15/2017

For the new entrepreneur who wants to implement a significant digitally-based service or sell products to customers on-line, the need to get their application written and implemented quickly is a strong one. Luckily, there are several services available to the business that wants to get its new application up and running in minimal time. In this article, we will concentrate on why you would consider having someone else host your database data, and what are the risks in doing so.

Database as a Service: Outlook Cloudy 05/15/2017

For most companies, IT-related hardware and software maintenance is costly, time-consuming and requires hiring and retaining a support staff of operating system and database management system specialists. Delegating these responsibilities to an outside firm allows a new application to be developed and implemented more quickly. However, there are issues with delegating database support to an outside service. In this article, we will concentrate on how these environments scale with application growth, especially if the data and services are stored in the cloud.

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.

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