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

Adaptive Query Processing in SQL Server 05/21/2018

Adaptive query processing is the latest query processing feature introduced in the SQL Server database engine, available in SQL Server (starting with SQL Server 2017 (14.x)) and Azure SQL Database. Read on to learn more.

Introduction to Azure Cosmos DB Security 05/07/2018

Deployment of cloud-based technologies introduces a wide range of challenges; however, few of them are scrutinized to the same extent as security. When analyzing security-related challenges, it is important to note that they encompass several distinct but interrelated technologies, including authentication and authorization, network isolation, as well as data integrity and confidentiality. In this article, we will explore how these concepts apply to the Azure Cosmos DB offering.

Tables Without Clustered Indexes 05/03/2018

Do all of your tables contain clustered indexes? Some say every table should have a clustered index. Greg Larsen shares a simple script to identify those tables in your database that don’t have a clustered index.

more...

Oracle

Oracle's Conventional Export (exp) May Cause Problems 05/14/2018

There may be some still using conventional export (exp); with Oracle 12 that may not be a good idea.  Read on to see why.

Pseudonymization Of Personal Data With Oracle 04/30/2018

The GDPR offers pseudonymization as a protection technique for personal data.  Read on to see what pseudonymization is and why it can be difficult to implement.

Does Your Oracle Table Really Need 255 or More Columns? 04/16/2018

Tables with 255 or more columns are not uncommon but Oracle introduces some interesting performance changes when dealing with them.  Read on to see what can happen for such tables.

more...

MS Access

more...

DB2

5 More Features of IBM Db2 12 for z/OS 05/10/2018

IBM's Db2 Version 12 for z/OS has many new features that focus on performance and security measures, particularly for mobile and cloud applications. Advances in cryptographic hardware and query accelerator technologies facilitate rapid development of customer-facing applications and the embedding of big data queries in operational systems.

5 New Features for Db2 12 for z/OS 04/19/2018

IBM presents version 12 of its flagship database product Db2 as, "The ultimate enterprise database for business-critical transactions and analytics". What does this mean? In this slideshow we dive into the most critical changes in this version of Db2, including improvements for application enablement, DBA functions, on-line transaction performance and query performance.

Modern Database Disaster Planning 03/15/2018

What elements comprise current day disaster recovery planning, and how are large mainframe and big data applications recovered?

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