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
» 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

Converting Comma Separated Value to Rows and Vice Versa in SQL Server 05/21/2015

Often while reporting you will encounter a situation where you will have comma separated values in a single column but you want to report them in rows. In other cases you might have values in multiple rows and want them to be a single value separated by comma or some other character. Arshad Ali demonstrates how to write queries in SQL Server to handle these scenarios quickly.

Automating Image-Based Deployment of SQL Server on Azure IaaS VMs - Preparing SQL Server 05/07/2015

In one our articles recently published on this forum, we described the process of deploying a Windows Server 2012 R2 into an Azure Infrastructure as a Service (IaaS) virtual machine using the latest gallery image. This was meant to constitute the first step of the process involving prestaging a setup of SQL Server 2014. Now we are ready to initiate the SQL Server setup.

T-SQL Programming Part 14 - Using the TOP Clause with UPDATE, INSERT and DELETE Statements 05/04/2015

Learn how to use the TOP clause in conjunction with the UPDATE, INSERT and DELETE statements.

more...

Oracle

Stoptimizing Oracle 05/25/2015

According to Jonathan Lewis: "Stoptimisation - the art of optimization by not doing the things you don't need to do."  Read on to see what things you may be doing that you shouldn't be doing.

Bulk Exceptions in Oracle 05/14/2015

When using BULK COLLECT it's possible to see all of the exceptions thrown for the bulk collection by coding the exception handler properly.  Read on to see how to implement such an exception handler.

Cartesian Joins in Oracle: The Nullable Column Problem 04/27/2015

NULL values in a table can cause Oracle to decide to use a Cartesian join with large data sets.  Read on to see one way this can be addressed.

more...

MS Access

more...

DB2

DBA Workloads Change as Big Data Solutions Mature 05/18/2015

Today, everyone realizes that in order to reach their full performance potential, Big Data applications require some tuning. The tuning isn't easy, it's not free, and responsibility for understanding requirements and implementing the appropriate tuning methodology falls squarely on the shoulders of the database administrator. Read on to learn more.

Disaster Recovery and Big Data 04/16/2015

Big data applications are not usually considered mission-critical: while they support sales and marketing decisions, they do not significantly affect core operations such as customer accounts, orders, inventory, and shipping. Why, then, are major IT organizations moving quickly to incorporating big data in their disaster recovery plans?

Exploding the Myths of Big Data 03/16/2015

As big data application success stories (and failures) have appeared in the news and technical publications, several myths have emerged about big data. This article explores a few of the more significant myths, and how they may negatively affect your own big data implementation.

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













Thanks for your registration, follow us on our social networks to keep up-to-date