Category Archives: Edgenet

Edgenet Exec Q&A

Edgenet provides optimized product data for suppliers, retailers and search engines. Used online and in stores, Edgenet solutions ensure that businesses and consumers can make purchasing and inventory decisions based on accurate product information. Last year, it implemented an In-Memory OLTP solution built on SQL Server 2014, which has helped it continue to innovate and lead in its business

We caught up with Michael Steineke, Vice President of IT at Edgenet, to discuss the benefits he has seen since Edgenet implemented SQL Server 2014.

Q: Can you give us a quick overview of what Edgenet does?

A: We develop software that helps retailers sell products in the home building and automotive industries. We work with both large and small dealers and provide software that helps determine and compare which products are in a local store.

We provide the specs, pictures, manuals, diagrams, and all the rest of the information that a customer would need to make an informed decision. We take all of this data, standardize it, and provide it to retailers and search engines.

With the major shift to online sales over the past handful of years, retailers need to have relevant and timely product information available so the customer can compare products and buy the best one for their needs.

In a single store, inventory is easy. In a chain where you have 1,000 or 5,000 stores, that gets very complicated. Our company is built on product data, and we need a powerful solution to manage it.

Q: What is your technology solution?

A: We are using In-Memory OLTP based on SQL Server 2014 to power our inventory search. This is where SQL Server 2014 comes in. Our applications make sure we have the right product listed, pricing and availability, and we couldn’t do it without In-Memory OLTP.

Q: What types of benefits have you seen since deployment?

A: SQL Server 2014 and OLTP have helped change our business. Our clients are happy as well. No matter what our customers need, we can do it with our solution. If a retailer wants to supply the data to us every 10 minutes, we can update every 10 minutes. It’s the way we like to do our business.

Q: Why did you choose to deploy SQL 2014 in your organization?

A: Working with Microsoft was a natural choice since we often are early adopters with new technologies. Our goal is to utilize new feature sets of new software as much as possible so we stay innovators in the field. That was the main reason we were so excited to deploy the In-Memory OLTP features with SQL Server 2014.

Q: What type of data are you managing?

A: Our inventory data isn’t extremely large, but there is a lot of volatility with it. We are talking about managing thousands of products across thousands of stores, with different pricing and availability for each store. There could be hundreds of millions of rows for just one retailer. Our big data implementation is around managing this volatility in the market, and we need a powerful back-end solution to help us handle all sorts of information.

Q: What are the advantages of In-Memory OLTP?

A: The biggest advantage we are getting is the ability to continually keep data up-to-date, so we always have real-time inventory and pricing. While we are updating we can continue to use the same tables, with little or no impact on performance. We were also able to consolidate a database used for the application to read that was refreshed daily and a database that consumed the updates from our customers, to one In-Memory database.

 

For more information about SQL Server 2014, check out the website and start a free trial today.

Customers Gain Roadmap for the Future with Microsoft, SQL Server 2014 and In-Memory OLTP

There’s a lot of excitement around the In-Memory OLTP database engine in SQL Server 2014—and for good reason. Many companies are already realizing impressive performance gains by using it. Here are just a few examples:

Edgenet manages data for Fortune 500 firms, and its success depends on updating clients’ databases so that they accurately reflect transactions, especially for databases supporting online shopping carts. By upgrading to SQL Server 2014, Edgenet boosted throughput sevenfold with In-Memory OLTP. Read the case study here.

SBI Liquidity Market  manages more than US$1 trillion each month in foreign currency exchange trading. To increase scalability and speed, it upgraded its trading system to SQL Server 2014. With In-Memory OLTP, SBI Liquidity Markets improved throughput by 10x, processing up to 200,000 transactions per second. Read more about this story here.

TPP manages about half of the United Kingdom’s 60 million medical records through its hosted clinician service. Fast access to medical records is critical.  In the most extreme scenarios, if a doctor can’t access the system fast enough, patient’s lives could be at stake.  When TPP started testing In-Memory OLTP by upgrading its databases to SQL Server 2014 managed to get the solution up and running in only half a day.  Although the databases were running on existing servers, TPP observed 7 times performance improvements.  Further details on their story are here.

While In-Memory OLTP is transforming performance, it’s just one feature in the broader Microsoft platform that’s supporting modern applications’ demand for intense scale and ease of access.

This end-to-end platform is what sets Microsoft apart, and that’s why I’d like to echo some points recently made by Satya Nadella, Microsoft’s Executive Vice President of Cloud and Enterprise. In 10 years, I believe Microsoft will still be at the core of computing because the company is continuing to shape the industry with innovations such as the hybrid cloud based on its Cloud OS. Microsoft also offers fast data insights with BI tools that “led the pack” according to Forrester Research. Ongoing adoption of Microsoft’s platform by the world’s top companies is also testament to the company’s vision.

For more information about In-Memory OLTP including its no locking/no latching concurrency controls, read this article.  SQL Server 2014 CTP2 is now available for download here.

What’s Your Favorite Feature of SQL Server 2012?

PASS Summit in November was a perfect opportunity to catch up with SQL Server community members to ask them about their favorite features of SQL Server 2012. We caught up with many of them at a local restaurant and captured their responses in this video to kick off Quentin Clark’s keynote.

Perhaps not surprisingly, the favorite features named were exceedingly diverse, but there were some commonalities in the outcomes people were looking for.  These benefits included:

  • Reductions in application downtime
  • Improvements in database and application performance
  • Improvements in productivity
  • Costs savings
  • Empowering end-users with BI tools to improve decision making

So if any of these outcomes are critical to your next project, watch the full video above and see what features of SQL Server 2012 can help you achieve these aims.  And for those that are interested in the Business Intelligence benefits for your next project, you may want to hear more by attending the PASS Business Analytics Conference on April 10-12 in Chicago.  That would be a great opportunity to catch up and hear more about your favorite feature of SQL Server 2012!

Many of the customers featured in the video have already worked on published SQL Server 2012 customer stories.  You can find a complete list of these case studies at www.microsoft.com/sqlcustomers

David Hobbs-Mallyon, Senior Product Marketing Manager