Reader Feedback
Mark – Set NOCOUNT ON
I believe it faster because it avoids extra trips to the client and back for each row count message since I believe that data is sent separately from the results for each and every row count.
Prabhu – Continuous Integration
I am a Program Director specializing in large scale implementation of ERP software. The concept of continuous build & Integration is new to me. I see value in embracing this methodology, however the updates need to be pushed by the vendors, and customers may have to minimize or completely eliminate major customizations in order to facilitate this new concept. Large Fortune-500 firms also have internal testing and approval processes that may forbid frequent updates due to compliance and risk management policies. To summarize, I think this is an economically attractive option.
High Performance Distributed SQL Database
A lot of the Buzz around NoSQL data storage is the ability to distribute the data through sharding resulting in high performance due to available parallel processing. NewSQL is a hybrid where the features we value in SQL relational engines are combined with the high performance and scalability of NoSQL.
VMWare has released a product providing the same kind of performance and scalability as NoSQL with the familiar SQL interface. It is called VMware vFabric™ SQLFire. What makes this engine different?
- Data is stored in Memory
- Data is stored and accessed inside a cloud of Virtual Servers for redundancy and horizontal scalability
- It is access through standard SQL tools such as SQL, JDBC and ADO.Net. This enables data access frameworks such as Spring JDBC, NHibernate, Hibernate, and others to interact much like other existing SQL Engines
- It supports standard SQL syntax
- It maintains the familiar ACID transactional capability of a relational database
- Parallel, data-aware stored procedures allow your stored procedures to execute close to where the data physically resides on a single node, or multiple nodes concurrently as a group
- Optionally writes to disk
- Dynamically grows or decreases the cluster size
- Replication built in
You can find more information at vmware.com. They have a datasheet in pdf form at https://www.vmware.com/files/pdf/vfabric/VMware-vFabric-SQLFire-Datasheet.pdf. There is also an on-demand webcast at https://event.on24.com/eventRegistration/EventLobbyServlet?target=registration.jsp&eventid=462103&sessionid=1&key=4C2D607D236A2082E083F9C8F0DF2A9A&partnerref=WWW_PROD_SQLF&sourcepage=register
This is not an endorsement for the SQLFire product. I haven’t even taken it for a test spin yet. But, this is what a cloud based NewSQL engine should be in my opinion.
Why not share your thoughts on this kind of new technology by sending an Email to btaylor@sswug.org.
Cheers,
Ben
Featured Article(s)
Troubleshooting problems with SQL Server 2008 R2 jobs
This article describes the problems you can have with SQL Server 2008 R2 jobs.
Featured White Paper(s)
All-At-Once Operations
Written by Itzik Ben-Gan with SolidQ
SQL supports a concept called all-at-onc… (read more)