No one disputes that data is critical to the lifeblood of business, applications, and the computer industry. SQL Server sits at the forefront of any discussion about data these days. So it’s no coincidence that SQL Server is seen, heard, and felt at major industry events. As a leader in the Azure Data SQL Server Read more
Once again, SQL Server 2017 has led the pack with three new TPC benchmarks published in April 2019, ranking SQL Server 2017 as the fastest database for online transaction processing (OLTP) and data warehouse (DW) workloads on Windows and Linux. Together with our partners, SQL Server continues to innovate with high-performing, enterprise-ready solutions that deliver Read more
This post was authored by Jos de Bruijn, Senior Program Manager, SQL Server. A release the magnitude of SQL Server 2016 deserves a new sample. AdventureWorks, which has been around since the SQL Server 2005 days, has had a good run, but it is time for an upgrade. Wide World Importers is the new sample Read more
In-Memory OLTP, a performance feature in SQL Server since 2014, allows you to speed up transactional workloads up to 30X. SQL Server 2016 and Azure SQL DB have In-Memory OLTP in public preview, and contain many improvements to In-Memory OLTP, making it drastically easier to adopt in an existing application, and allowing many other applications Read more
Faster transactions, faster queries and faster analytics. Sounds like nirvana right? Just imagine it… your customers can find what they want from your large product catalog more quickly and purchase without huge lags. Your business divisions can perform timely analytics highlighting product, web site, and data trends. It’s all possible with in-memory technologies, and Microsoft Read more
Microsoft Azure continues to offer customers more reasons why Azure Virtual Machines are an ideal place to develop, test and run your SQL Server applications. This promise is further enhanced with the release of new workload optimized images for SQL Server that provide greater performance and simplified setup when it comes to running data warehousing Read more
Calling all data junkies! How smart are you? Want to get smarter? Play along with #pass24hop Challenge on Twitter starting at 5:00 AM PT Tuesday, September 9, 2014 to win a free Microsoft Exam Voucher! Simply watch 24 Hours of PASS and be the first to answer the question correctly. At the beginning of each 24 Read more
Microsoft SQL Server 2014 brings new performance and scalability gains by introducing In-Memory OLTP. In-Memory OLTP contains tables and indexes optimized for in memory. Transactions execute under lock-free algorithms to provide linear scalability and Transact-SQL stored procedures can be compiled in native machine code for maximum efficiency in processing. Working with SQL Server customers on Read more
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 Read more
As a global IT leader, Dell manufactures some of the world’s most innovative hardware and software solutions. It also manages one of the most successful e-commerce sites. In 2013, the company facilitated billions in online sales. On a typical day, 10,000 people are browsing Dell.com at the same time. During peak online shopping periods, the Read more
SQL Server 2014 introduces the new In-Memory OLTP feature to boost performance of OLTP workloads. In an earlier blog post, Quentin Clark described how In-Memory OLTP has helped customers achieve performance gains up to 30X. To help you get started with the new In-Memory OLTP feature in SQL Server 2014 we created a sample around Read more
Guest blog post by: SQL Server MVP Denise McInerney – Vice President of Marketing for PASS and a Data Engineer at Intuit – began her career as a SQL Server DBA in 1998 and now applies her deep understanding of data to enable analytic solutions to business problems. She is founder of the PASS Women in Read more
