Improve scalability with system page latch concurrency enhancements in SQL Server 2022 

13 min read

Over the past several SQL Server releases, Microsoft has improved the concurrency and performance of the tempdb database. In SQL Server 2022 we are addressing one of the last areas of contention by introducing concurrent global allocation map (GAM) and shared global allocation map (SGAM) updates which will give SQL Server 2022 a big improvement Read more

SQL Server 2014: A Closer Look 

4 min read

Microsoft SQL Server 2014 was announced by Quentin Clark during the Microsoft TechEd 2013 keynote. Designed and developed with our cloud-first principles in mind, SQL Server 2014 builds on the momentum of SQL Server 2012, released just 14 months ago. We are excited to share a closer look at some of the exciting capabilities included Read more

14 Comments

Disk and File Layout for SQL Server 

2 min read

Guest blog post by Paul Galjan, Microsoft Applications specialist, EMC Corporation. To learn more from Paul and other EMC experts, please join our Everything Microsoft Community. The RAID group is dead – long live the storage pool!   Pools fulfill the real promise of centralized storage – the elimination of storage silos.  Prior to pool technology, when Read more

11 Comments

PASS Summit 2012 Recap & the Milestones of SQL Server 2012 

2 min read

All the while, conference participants attended a wide variety of technical sessions presented by industry experts in addition to a host of other programs. From on-site certification testing, to hands-on-labs, attendees were able to boost their technical skills using these resources, as well as work through technical issues with top Microsoft Customer Service and Support Read more

2 Comments

CROSSMARK Uses SQL Server 2008 R2 Parallel Data Warehouse to Quickly Deliver Business Insights 

1 min read

With the growth of the consumer goods industry, sales and marketing campaigns have created large and complex databases that are hard to sift through without the right tools. As retailers approach the busy holiday shopping season, they need to have insights into the effectiveness of their campaigns. Retailers need to know what market trends are Read more

Countdown to PASS Summit Series: Make it Happen at The Summit 

7 min read

It’s closer and closer we get to the official start of PASS Summit 2012, and our celebratory countdown continues! Today, we have more advice for you on what you need to get out of PASS Summit from SQL Server community members Rob Farley and John Sansom.  FEATURED MVP ROB FARLEY Rob Farley runs LobsterPot Solutions, a Read more

Microsoft TechEd turns 20 with the SQL Server Team on hand to celebrate! 

2 min read

It has been 20 years since Microsoft started TechEd to provide hands on training from Microsoft experts across current and soon-to-release products, solutions and services. The event has grown to become Microsoft’s premier technology conference for IT Pros and Developers, and to mark our 20th year we are really excited to be presenting an awesome Read more

2 Comments