Subscribe to Methods & Tools
if you are not afraid to read more than one page to be a smarter software developer, software tester or project manager!
Subscribe to Methods & Tools
if you are not afraid to read more than one page to be a smarter software developer, software tester or project manager!
The ultimate database test data generation tool for PostgreSQL is better than ever.
Version 5 of Datanamic Data Generator for PostgreSQL has been redesigned. The tool has a complete new user interface. The new version generates test data faster and generates better sample data, has a new "test run" option and has new generator settings such as the "synchronized selection" option for generators which get data from external sources. Test data generation for MS SQL Server 2012 and SQLite (version 3) databases is supported now also.
This is not all. There is more. A complete list of changes can be found at on our website at:
SQL Maestro Group announces the release of AnySQL Maestro 13.2, a powerful tool for managing any database engine accessible via ODBC driver or OLE DB provider (PostgreSQL, MySQL, SQL Server, Oracle, Access, etc).
The new version is immediately available at
AnySQL Maestro comes in both Freeware and Professional editions.Top 10 new features:
There are also some other useful things. Full press release is available at the SQL Maestro Group website.
What does parallel processing bring to the table? Obviously the possibility, but not the guarantee, of reduced execution time. What does it cost? That depends on the system but for OLTP systems it usually creates more work than it accomplishes. Read on to learn more.
As a company that for many years has been committed to delivering end-to-end data platform technologies to our customers, weâ€™re excited about all the attention big data is receiving from press, analysts and the industry. While all the pundits are in general agreement that big data is the next greatest IT trend, the definition of big data varies depending on the source.
What do we mean when we say big data? We mean data that is so large, so complex or collected at such a fast pace that it challenges the capabilities of traditional data management systems. Any organization looking at their current data infrastructure and seeing a significant shift the volume, variety or velocity of data is experiencing big data.
The real promise of big data is to enable every type of organization to harness all their data and discover insights that help them do whatever they do â€“ better. Weâ€™re here to help with tools and solutions to help make sense of all that big data â€“ helping our customers make faster, better decisions.
Weâ€™ll have more to share on big data trends and solutions over the next few weeks and months â€“ stay tuned!
Today, the Precog team has released a free implementation of Precog for PostgreSQL. Precog for PostgreSQL empowers users to easily perform data science on PostgreSQL.
This release bundles the core Precog analysis technology into a completely free package that anyone can download and deploy on their existing PostgreSQL database. Precog for PostgreSQL gives you the ability to analyze all the data in your PostgreSQL database, without forcing you to export data into another tool or write any custom code.
Precog for PostgreSQL comes bundled with Labcoat, a high-level analysis tool that lets users analyze data using Quirrel, the statistically-oriented query language. To get started, visit this page to download the zipped file (includes JAR, scripts and config file).
To get startedâ€¦.
See the read me for the complete installation and configuration instructions. We provide full support for this release so if you run into any trouble, please contact the Precog team at firstname.lastname@example.org.
2ndQuadrant is proud to announce the release of version 1.2.0 of Barman, Backup and Recovery Manager for PostgreSQL.
This major release introduces automated support for retention policies based on redundancy of periodical backups or recovery window.
Retention policies are integrated by a safety mechanism that allows administrators to specify a minimum number of periodical backups that must exist at any time for a server.
For a complete list of changes, see the "Release Notes" section below.Backup retention policies
A backup retention policy is an user-defined policy that determines how long backups and related archive logs (Write Ahead Log segments in PostgreSQL) need to be retained for recovery procedures.
Through the 'retention_policy' configuration option, Barman retains the periodical backups required to satisfy the current retention policy, and any archived WAL files required for the complete recovery of those backups.
Barman users can define a retention policy in terms of backup redundancy (how many periodical backups, e.g. 5) or a recovery window (how long, e.g. 3 months).
Minimum redundancy safety --
Through the 'minimum_redundancy' configuration option, Barman controls the minimum number of backups available at any time in the catalogue for a specific server. This feature will protect users from accidental delete operations.
The open-source development of retention policies under GPL has been sponsored by a large European company that opted to remain anonymous.
Release Notes --
About Barman --
Barman (Backup and Recovery Manager) is an open-source administration tool for disaster recovery of PostgreSQL servers written in Python. It allows your organisation to perform remote backups of multiple servers in business critical environments and help DBAs during the recovery phase. Barman most wanted features include backup catalogues, retention policies, remote recovery, archiving and compression of WAL files and backups.
Built on top of PostgreSQL's robust and reliable Point-In-Time-Recovery technology, Barman allows database administrators to manage the backup and recovery phases of several PostgreSQL database servers from a centralised location, using an intuitive command interface. Barman is distributed under GNU GPL 3.
Some good news for MySQL users; version 5.6 includes native full-text support. If you’re not using MySQL, maybe this will be just the impetus you need to make the switch. In today’s article, Rob Gravelle shows you how to take advantage of MySQL 5.6’s Full-text search capabilities.
The PostgreSQL Global Development Group has released a security update to all current versions of the PostgreSQL database system, including versions 9.2.3, 9.1.8, 9.0.12, 8.4.16, and 8.3.23. This update fixes a denial-of-service (DOS) vulnerability. All users should update their PostgreSQL installations as soon as possible.
The security issue fixed in this release, CVE-2013-0255, allows a previously authenticated user to crash the server by calling an internal function with invalid arguments. This issue was discovered by independent security researcher Sumit Soni this week and reported via Secunia SVCRP, and we are grateful for their efforts in making PostgreSQL more secure.
Today's update also fixes a performance regression which caused a decrease in throughput when using dynamic queries in stored procedures in version 9.2. Applications which use PL/pgSQL's EXECUTE are strongly affected by this regression and should be updated. Additionally, we have fixed intermittent crashes caused by CREATE/DROP INDEX CONCURRENTLY, and multiple minor issues with replication.
This release is expected to be the final update for version 8.3, which is now End-of-Life (EOL). Users of version 8.3 should plan to upgrade to a later version of PostgreSQL immediately. For more information, see our Versioning Policy.
This update release also contains fixes for many minor issues discovered and patched by the PostgreSQL community in the last two months, including:
As with other minor releases, users are not required to dump and reload their database or use pg_upgrade in order to apply this update release; you may simply shut down PostgreSQL and update its binaries. Users who have skipped multiple update releases may need to perform additional, post-update steps; see the Release Notes for details.
Hello SQL Server community! My name is Eron Kelly and I recently took the role of General Manager of Product Marketing for the Data Platform at Microsoft. Iâ€™ve been at Microsoft for over 12 years in various product marketing roles on BizTalk, Exchange, Office 365 and Windows Azure. Iâ€™m excited that my first blog post in my new role is to announce Microsoftâ€™s positioning as a Leader the Magic Quadrant for Data Warehouse Database Management Systems that was published on January 31, 2013.
First off, thank you to all the customers who spoke to Gartner on our behalf for this Magic Quadrant. Your engagement with us on SQL Server has made it a better product for data warehousing, and we believe that our position in the Leaders Quadrant in this report reflects the core values of our platform: ease of use, high scale, high availability and market leading TCO. This placement recognizes our strategy to provide customers with data warehouses of all sizes â€“ from the mid-market to the largest mission critical, tier one deployments â€“ that have the best price for performance in market.
This is different from the approach of other vendors in the data warehousing space, who can deliver similar performance at a much higher price. Customers, like Hy-Vee who saw a 100X query performance improvement, or AMD who adds a terabyte of data to their data warehouse each week, are seeing great performance with the SQL Server Parallel Data Warehouse Appliance.
We are pleased that Gartner has recognized us as a leader in Data Warehouse Database Management Systems and that customers are affirming our approach. In the coming year, we will continue to focus on delivering the highest value to our customers through innovations in mission critical scale, performance, and high availability while continuing to deliver on lowering the total cost of ownership of the data platform. Thank you for your continued support and I look forward to talking with you more in the future.
* Disclaimer: Gartner does not endorse any vendor, product or service depicted in its research publications, and does not advise technology users to select only those vendors with the highest ratings. Gartner research publications consist of the opinions of Gartner's research organization and should not be construed as statements of fact. Gartner disclaims all warranties, expressed or implied, with respect to this research, including any warranties of merchantability or fitness for a particular purpose.
London, UK, 4th February 2013 - Actian Corp. (“Actian”), a leader in next generation big data management, today announced that Differentia Consulting has signed a reseller agreement with the company to offer enterprises the benefits of Actian Vectorwise, the innovative, record-breaking analytic database for big data.
Active since 2002, Differentia Consulting provides consulting, solutions, resourcing, support and training services to its clients and is a leading QlikView Solution Provider in Europe. Differentia Consulting has chosen to offer Actian Vectorwise to reply to the demand from its QlikView clients who want to go beyond the confines of the technology and now analyze and report on bigger, more complex data sets.
With Actian Vectorwise, Differentia Consulting can now offer its customers a joint solution of QlikView and Vectorwise that allows its clients to broaden their analytics and benefit from better performance and simplicity.
Previously, in very high data volume scenarios, users had to build and manage numerous linked QlikView documents supported by QVD files. These QVD files are a local QlikView data storage mechanism and in order to achieve the required performance with very large data sets it was necessary to create a hierarchy of aggregation. This approach is less than ideal as it introduces constraints in the flexibility of the analysis possible.
QlikView now incorporates Direct Discovery functionality which permits it to leverage the very high performance of the Vectorwise database for calculating aggregates on-the-fly over very large datasets. This approach removes the requirement to build pre-calculated aggregates within QVDs and permits the highly flexible analysis approach which has made QlikView so popular.
Differentia Consulting believes that Vectorwise offers a superior level of manageability, simplicity as well as analytic performance when compared to other database solutions. Furthermore, thanks to the QlikView Direct Discovery functionality, users can extend their use of QlikView applications by implementing Actian Vectorwise as the underlying analytic database in high volume usage cases that demand; speed, agility and system governance.
“I see Vectorwise as the enabler of Big Data access from our clients’ perspective. We needed an analytic database that we could offer our clients where large data volumes were making deploying QlikView non viable. For us, Vectorwise was the logical solution; being agile and rapid is key,” commented Adrian Parker, vice-president strategy and marketing at Differentia Consulting.
“Differentia Consulting is a key solution provider in the European BI marketplace and has been successful in helping businesses benefit from QlikView technology,” commented Sean Jackson, marketing director EMEA at Actian. “By offering Vectorwise, Differentia Consulting is now extending their reach and helping more enterprises benefit from faster and simpler big data analytics and reporting. No longer do QlikView users need to be constrained by the amount of data they can analyze; with Vectorwise, the amount of data can grow exponentially, which means that users can analyze and report on more data than ever before. We look forward to working with Differentia Consulting to take this proposition to the QlikView installed base.”
About Actian: Take Action on Big Data
Actian Corporation enables organizations to transform big data into business value with data management solutions to transact, analyze, and take automated action across their business operations. Actian helps 10,000 customers worldwide take action on their big data with Action Apps, Vectorwise, the analytical database, and Ingres, an independent mission-critical OLTP database. Actian is headquartered in California with offices in New York, London, Paris, Frankfurt, Amsterdam and Melbourne. Stay connected with Actian Corporation on Facebook, Twitter and LinkedIn.
Actian, Cloud Action Platform, Action Apps, Ingres and Vectorwise are trademarks of Actian Corporation. All other trademarks, trade names, service marks, and logos referenced herein belong to their respective companies.
About Differentia Consulting
Differentia Consulting has provided consulting, solutions, resourcing, support and training services to many different clients since 2002. The company is a long-standing partner of IBM and Oracle with JD Edwards, and a QlikView Elite Solution Provider with QlikView customers from all sectors and core technologies (JD Edwards, Oracle, SAP, Infor, IFS, Microsoft, SAGE, Siebel, SalesForce, SugarCRM etc). Differentia Consulting has an ERP heritage; however, the company has expanded into the agile analytics space both from a software resale and value-add consulting perspective. For more information, go to www.differentia.co
New database release provides performance and scalability gains
Curious about the differences in approaching performance and scalability in SQL Server vs. Windows Azure SQL Database (formerly SQL Azure)? Check out this new paper that brings together insights from the Microsoft SQL Engineering and Customer Advisory Teams (CAT) to detail the differences between on-premises SQL Server and Azure SQL Database tuning and monitoring techniques and best practices for database performance testing. If youâ€™re an on-premises SQL Server whiz and currently integrating the cloud or considering a move to Platform as a Service, this paper is a must read!
While SQL Server and Windows Azure SQL Databases have large and important similarities, they are not identical, and while the differences are relatively small, they affect the way that applications perform on SQL Database compared to SQL Server. As a result, the application architecture and performance evaluation techniques for each platform also differ.
This document explains these performance differences and their causes and includes real-world customer wisdom from experience troubleshooting performance on production customer SQL Databases. This document also examines common SQL Server performance evaluation techniques that do not work on SQL Database.
Read the full paper.
Greg Larsen explores the new SQL Server 2012 date and time functions and shows you how to exploit these functions in new application code.