Developers, team leaders, or R&D managers have a lot to gain by making their DBAs more productive.
Database Section Index
Manoj Debnath provides an overview of how to parse XML documents using JAXB, SAX, and DOM.
Learn six of the most important features that a data validation service provider should offer.
Learn how to improve the performance of an application that uses the Java Persistence API, by modifying the second level cache mode settings.
Learn how to handle concurrent access to entity data, and the locking strategies available to JPA API.
Big data platforms and ecosystems emerged from the need to efficiently handle data volumes, velocities, and varieties that had not previously existed.
In today’s technology world, Big Data is a hot IT buzzword. To mitigate the complexity in processing large volumes of data, Apache developed Hadoop – a reliable, scalable and distributed computing framework. Read on to learn more.
Learn about new data persistence technologies including NOSQL and NewSQL databases as well as about CAP theorem, useful data access patterns, and good practices applicable to enterprise application programming with Big Data.
Learn about Big Data processing techniques addressing, but not limited to, various BI (business intelligence) requirements such as reporting, batch analytics, online analytical processing (OLAP), data mining, text mining, complex event processing (CEP), and predictive analytics.
Today, developers interested in Big Data can easily be lost in the jungle of numerous new technologies. Get a clear view on the Big Data technology landscape and learn to pick the most suited techniques for your Java software projects.
Learn how to improve your SQL query performance with these ten tips, including re-writing of queries and the creation and use of indexes.
Anoop Kumar shares his top 10 transformations to manage and change data in SSIS.
Anoop Kumar shows you how easily ETL performance can be controlled at any point of time by sharing 10 common ways to improve ETL performance.
Anoop Kumar discusses some common operators that are useful to interpret a graphical execution plan and troubleshoot any performance issue due to a badly written query.
Complete a big data proof of concept project in 60 days, leading to a full implementation afterward.
Taras Bachynskyy classifies database technologies in terms of their application and creates a single-view representation for all technology groups such as RDBMS, Key-Value stores, Graphs, etc.
Learn how SQL Server generates a query execution plan and the processes involved to achieve the task.
Ten Tips that lead to a functional environment for data integration.
Learn how to leverage the magic of Map/Reduce to make your NoSQL data in Couchbase searchable!
Scale your application to the sky with the high performance NoSQL Couchbase!
The buzz around NoSQL solutions has reached stratospheric heights. This buzz has led many Microsoft SQL Server development shops to start looking at how and where a NoSQL solution can fit into their business.
Mike Lamble examines the current big data landscape and focuses on the analytics needed to make these exabytes actionable. Today’s DBMS for big data analytics must meet specific requirements that are outlined in this article.
Developers targeting the SQL Azure platform should make sure their applications are secure. This article walks through the considerations developers need to keep in mind when designing SQL Azure applications.
Windows Azure offers a plethora of programming modes to harness the power of cloud computing. In this article, we explore how to create a WCF service running on Windows Azure.
Find out why using CASE tools to create MySQL databases can increase your development speed and productivity.