Have you read any of the great articles on SQLPerformance.com? The deep-dive technical info comes from the SQL Server industry’s top experts. Here are a few great articles from the early days of the website, January 2013: Generate a set or sequence without loopsAaron Bertrand (b|t) provides detailed performance information ...

From Red-Gate website you can download (for free) the ebook SQL Server Hardware written by Glenn Berry (@GlennAlanBerry). This ebook will provide the fundamental knowledge and resources you need to make intelligent decisions about choice, and optimal installation and configuration, of SQL Server hardware, operating system and the SQL Server ...

Me and Aaron Bertrand, SQL Sentry flagbearers.One of the things we've been working on at SQL Sentry is building up institutional knowledge for the SQL Server community. There are three main ways that we're doing that on-line:Hard-core tech articles on SQLPerformance.com, edited by long-time SQL Server MVP Aaron Bertrand ...

 Join me for a day ofReal World Database Configuration and Tuning for Microsoft SQL ServerSQL Saturday Silicon Valley 2014Friday, March 14, 2014 from 8:30 AM to 4:00 PM (PDT)Mountain View, CAClick HERE to register Now! Seating is very limited! This full-day training event combines a thorough overview of fundamental architectural concepts ...

Have you heard of the monthly print and web magazine Database Trends & Applications (DBTA)? Did you know I'm the regular columnist covering SQL Server?  For the past six months, I've been writing a series of articles about database benchmarking culminating in the latest article discussing my three favorite database ...

Storage has changed dramatically over the last three years driven by SSD developments. Most of the key components necessary for a powerful storage system are available and the cost is highly favorable for direct placement of data files. Some additional infrastructure elements could greatly enhance the flexibility of storage systems with ...

The PerfMon Counters That Just Won't DieOne of the things that's simultaneously great and horrible about the Internet is that once something gets posted out in the ether, it basically never goes away.  (Some day, politicians will realize this.  We can easily fact check their consistency).  Because of longevity of content posted to ...

Intel officially announced the Xeon E5 2600 series processor based on Sandy Bridge-EP variant with upto 8 cores and 20MB LLC per socket. Only one TPC benchmark accompanied product launch, summary below. ProcessorsCores perFrequencyMemorySQLVendorTPC-E 2 x Xeon E5-269082.9GHz512GB (16x32GB)2012IBM1,863.23 2 x Xeon ...

If you haven't started to read Shashank Pawar (blog), you're missing out. Shashank is part of Microsoft Australia and has been writing some very good content lately. Here's an example from the Reference Architecture for High Performance SQL Server:HP and Microsoft engineering teams have worked together to create a reference architecture to ...

The arrival of the Sandy Bridge EN and EP processors, expected in early 2012, will mark the completion of a significant shift in Intel server strategy. For the longest time 1995-2009, the strategy had been to focus on producing a premium processor designed for 4-way systems that might also be used in 8-way systems and higher. The objective ...