A SQL Server tale of two cities 

4 min read

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

SQL Server 2017 achieves top TPC benchmarks for OLTP and DW on Linux and Windows 

2 min read

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

WideWorldImporters: The new SQL Server sample database 

3 min read

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

1 Comment

Speeding up Transactions with In-Memory OLTP in SQL Server 2016 and Azure SQL Database 

5 min read

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

4 Comments

Are you harnessing all that in-memory can do for your business? 

1 min read

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

3 Comments

New Optimized OLTP and Data Warehousing SQL Server Images on Azure 

1 min read

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

2 Comments

Announcing the PASS 24 HOP Challenge 

7 min read

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

2 Comments

New: ASP.NET Session State Provider for SQL Server In-Memory OLTP 

3 min read

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

20 Comments

Edgenet Exec Q&A 

2 min read

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

Dell Doubles Application Speeds, Processes Transactions 9X Faster with In-Memory OLTP 

2 min read

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

2 Comments

In-Memory OLTP Sample for SQL Server 2014 RTM 

1 min read

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

1 Comment

SQL Server 2014 and the DBA: Building Bridges 

3 min read

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

1 Comment