DatabaseJournal.com Staff

SQLSteps, a Microsoft SQL Server online training company, has three new courses. The first is SQL Query Writing and Fundamentals, a course designed to provide a better understanding of database systems and develop skills in SQL query writing; while the other two are training for Microsoft Certified Technology Specialist exams, Microsoft SQL Administrator Certification 70-432 […]

Fragmentation relates to index entries that are out of sequence, which for queries that access data sequentially, leads to additional work to retrieve the index’s data. This excerpt from the book SQL Server DMVs in Action discusses a script for identifying the most fragmented indexes. Fragmentation affects query performance and should be removed. SQL Server […]

PostgreSQL database and Memcached servers have gained monitoring support in ManageEngine’s Applications Manager version 9.2. By providing performance indicators such as availability, health and cache hit ratio, transaction, lock, buffer and disk usage statistics with in-depth reports, Applications Manager enables IT administrators keep their PostgreSQL and Memcached servers at top performance, as well as cloud-based […]

Newly released from Couchio is CouchDB SDK for Android. CouchDB for Android allows developers to build web or native applications as well as access their data, be it on other devices, desktops, or in the cloud from practically anywhere as it works with slow or intermittent Internet connection, or even offline. It also automatically synchronizes […]

Having found great success with SQLServerPedia, its free, community driven SQL Server online resource, Quest Software has now expanded to also cover Oracle and cloud databases. Called OraDBPedia and CloudDBPedia, both will contain helpful videos, podcasts, blogs, and community-run wikis. Each of these sites will have an expert in their particular domain as editor-in-chief with […]

“Learn to Build a Stable, Scalable, and Secure Database in the Cloud” on Thursday, August 12, 2010 at 10am PT through a live Webinar hosted by GoGrid and Sentrigo. Topics will include: An introduction to cloud infrastructure and management tools Best practices in deploying applications and databases in the cloud Technical challenges when protecting remote […]

“Sybase IQ has always been the smart choice for delivering analytics results. Now, together with HP servers optimized for data intensive workloads, Sybase IQ enables a new generation of analytics capability—such as predictive business analytics, ad-hoc queries capabilities and deep-dive data mining—that meets today’s business challenges,” says Sybase. HP and Sybase are doing this through […]

Newly released, and available as a feature in eXtremeDB Transaction Logging, is McObject’s Data Relay technology. Designed to quickly share data between real-time, eXtremeDB based applications and external systems like a DBMS, Data Relay: Simplifies the code that “looks inside” database transactions for changes that should be relayed Guarantees maximum efficiency by eliminating the CPU-intensive […]

A new release of SQL diagnostic manager has been announced by Idera. SQL diagnostic manager 6.2 uses wait statistic analysis to enable SQL Server DBAs to discover what is causing bottlenecks and who has to wait the longest for bottlenecked resources. “Users often see performance problems in their SQL Server environment that are difficult to […]

Veera, a business intelligence software product from Rapid Insight Inc, has been upgraded. Veera can take data from various formats such as Excel, Access, SQL Server, Oracle, MySQL, and text then quickly change it into reports and analytic datasets through merging, aggregating, and cleansing; all without the user having to worry about data corruption. The […]

N-compass 3.1 has just been released by N-able Technologies, and includes some new features to even better help IT departments and managed service providers create superb IT performance reports. First in the list of updates is support for Microsoft SQL Server 2008 databases and reporting platform along with Microsoft SQL Server 2005, providing a “comprehensive […]

Devart Team’s OraDeveloper Tools, an add-in that simplifies development of Oracle database applications, has been recently updated. Users will continue to have the functionality they’re used to, and also be able to reap the benefits of Visual Studio 2010 which OraDeveloper Tools now supports. Devart is offering a 30-day trial of OraDeveloper Tools, and also […]