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
 

Database Management & Programming News, Articles & Tutorials for Database Administrators

Featured Database Articles

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.

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.

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.

MySQL Union and Union All Operators Primer 05/11/2015

Unless you’re writing application code that can deal with multiple result sets, it’s usually preferable to merge several similar queries together so that their results may be viewed as one data set. This tutorial offers a brief overview on how to accomplish this task using both the UNION and UNION ALL operators and provides a few examples to get you started.

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.

Database News

IBM Opens Watson Analytics to Public Beta 12/04/2014

After an early beta of IBM's Watson Analytics pulled in 22,000 early testers, Big Blue is now opening the service to everybody.

Splice Machine Ships Version 1.0 of Hadoop RDBMS 11/19/2014

Splice Machine takes its Hadoop relational database management system (RDBMS) to general availability.

Amazon Claims New Aurora DB Engine Screams With Speed 11/12/2014

NEWS ANALYSIS: Aurora may become a formidable competitor for comparable database engines by MySQL, SAP, Oracle, Teradata and EMC.

OpenStack Juno Cloud Features Trove Database-as-a-Service Updates 10/12/2014

The upcoming open-source OpenStack Juno cloud platform will now support more databases and database features.

Couchbase Launches v3.0 of Its NoSQL Database 10/10/2014

Couchbase 3.0 introduces more than 200 new features and enhancements, including major extensions to its core architecture.

IBM Tweaks DB2 With BLU Acceleration for Big Data 10/03/2014

IBM has updated its DB2 with BLU Acceleration in-memory solution to handle transactional data as well as analytical workloads.

Microsoft to Cut Azure SQL Prices This Fall 08/27/2014

Microsoft is getting ready to slash prices by up to 50 percent after Azure SQL's new service tiers are made generally available next month.

Microsoft Entices Oracle Shops With SQL Server 2014 Migration Tool 07/25/2014

The company focuses on SQL Server 2014's in-memory capabilities in its bid to siphon enterprise database workloads from rival Oracle.

Oracle Big Data SQL Connects Various Data Sets for Analysis 07/16/2014

This can run a single SQL query on Oracle's own 12C database at the same time as in Hadoop and NoSQL data stores.

Couchbase Raises $60 Million to Fuel NoSQL Database Efforts 06/30/2014

 Investors continue to be confident in the prospects of NoSQL database technology.

More Database News...







Recent Headlines
Oracle
Bulk Exceptions in Oracle 05/14
Cartesian Joins in Oracle: The Nullable Column Problem 04/27
More Than Oracle Knows What To Do With 04/13
more...
MS SQL
Converting Comma Separated Value to Rows and Vice Versa in SQL Server 05/21
Automating Image-Based Deployment of SQL Server on Azure IaaS VMs - Preparing SQL Server 05/07
T-SQL Programming Part 14 - Using the TOP Clause with UPDATE, INSERT and DELETE Statements 05/04
more...
MS Access
more...
DB2
DBA Workloads Change as Big Data Solutions Mature 05/18
Disaster Recovery and Big Data 04/16
Exploding the Myths of Big Data 03/16
more...









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