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 Temporal Table in SQL Server 2016 – Part 2 04/25/2016

With the new temporal table feature, SQL Server 2016 internally manages two tables--a base table, which contains the latest data and a history table, which contains the history of changes. Read on to learn about this new feature, how it works, how to create a new table or enable the feature for an existing table.

Row Level Security with SQL Server 2016: Part 2 - Blocking Updates at the Row Level 04/18/2016

With the new security policy feature in SQL Server 2016 you can restrict write operations at the row level by defining a block predicate. Read on to learn why a block predicate is important when you implement row level security using SQL Server 2016.

Azure SQL Database Elastic Database Jobs 04/07/2016

One of more common concerns among database administrators who consider migrating their estate to Azure SQL Database is their ability to efficiently manage the migrated workloads. In particular, the absence of the SQL Server Agent introduces the challenge of identifying a means to perform ad-hoc and scheduled automated management tasks across multiple databases. Fortunately, recently introduced Elastic Database jobs provide a convenient and efficient way to address this concern.

more...

Oracle

Re-thinking SQL Queries Using Sets in Oracle 04/28/2016

Sometimes it's good to re-think how to write a query; set operations can provide performance benefits over 'straight SQL'.  Read on to see an example of this in action.

Deletes In Oracle: More 'Costly' Than You Think 04/21/2016

Deletes may be more 'expensive' than the Oracle optimizer reports; read on to see why.

Oracle 12c Table Point-in-time Recovery 03/28/2016

There may be times when you need to recover a single table and flashback isn't configured and the recycle bin is turned off. Using RMAN in Oracle 12c it's possible to restore and recover a single table. Read on to see how it's done.

more...

MS Access

more...

DB2

Big Data Architecture 04/14/2016

Business Intelligence (BI) has matured over the past two decades. The next few years will be critical for the information technology staff, as they attempt to integrate and manage multiple, diverse hardware and software platforms. This article addresses how to meet this need, as users demand greater ability to analyze ever-growing mountains of data, and IT attempts to keep costs down.

Analytics Yes; Big Data No! 03/24/2016

Some companies have been slow to acquire big data applications. They discovered that modern hardware platforms and database management systems were more than adequate for most of their business analytics needs. Such needs share several common attributes, including analytics run against operational systems, where the analytics logic and engine were close to the object data. This meant that companies could avoid complex and high-volume data movement and extract-transform-load (ETL) strategies while executing queries against already existing, well-tuned databases. In this article we introduce the concepts of strategic and tactical analytics, and how best to support these methods with your current IT infrastructure.

Big Data Quality Assurance 02/15/2016

With promises of incredibly fast queries, many IT shops implemented one or more big data applications in combination with high-performance hardware and software suites. However, few IT enterprises followed the appropriate data governance means and methods of ensuring data quality. What ensued was data of dubious quality being loaded into these applications, calling into question the results. In this article we review data quality methods and metrics for loading big data applications.

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