Intel Xeon E5-2600 v2 Series Processors (Ivy Bridge-EP) in Q3 2013

More details about the upcoming 22nm Intel Xeon E5-2600 series processors (aka Ivy Bridge-EP) are starting to leak out. Initially, we will see the single-socket Xeon E5-1600 v2 series and the two-socket Xeon E5-2600 v2 series processors, that share the 22nm Ivy Bridge microarchitecture. They use the same LGA2011 socket as the current 32nm E5-1600 […]

Hardware 201: Selecting and Sizing Database Hardware

I had the opportunity to present Hardware 201 in Boulder on June 18 and then do it again in Denver on June 20. It was fun presenting to both user’s groups nearly back to back. Here is the abstract: Hardware 201: Selecting and Sizing Database Hardware for OLTP Performance The foundation of database performance is […]

New AMD-based TPC-E Benchmark Result

HP recently submitted a TPC-E benchmark result for a two-socket HP ProLiant DL385p Gen 8 system that is using two 2.8GHz AMD Opteron 6386SE, 16-core processors. This system had a score of 1416.37 TpsE, which does not sound too bad until you compare it to a very similar two-socket HP ProLiant DL380p Gen 8 system […]

Speaking at Boulder SQL Server User’s Group on June 18

I will be speaking at the Boulder SQL Server User’s Group on June 18, 2013. I will be presenting an updated version of  Hardware 201. Here is the abstract: Hardware 201: Selecting and Sizing Database Hardware for OLTP Performance The foundation of database performance is the underlying server hardware and storage subsystem. Even the best […]

The Accidental DBA (Day 17 of 30): Configuring Alerts for High Severity Problems

This month the SQLskills team is presenting a series of blog posts aimed at helping Accidental/Junior DBAs ‘keep the SQL Server lights on’. It’s a little taster to let you know what we cover in our Immersion Event for The Accidental/Junior DBA, which we present several times each year. If you know someone who would benefit from […]

First Intel Haswell Desktop Build

Last Sunday, I was in line at 11AM at the Denver Micro Center (along with a number of other computer geeks) to buy the parts for a new Intel 4th generation Core (aka Haswell) desktop system. This system was destined for my fiancé, Veronica Thomas, as a replacement for a system I built for her […]

SQL Server 2012 Service Pack 1 Cumulative Update 4

On May 31, Microsoft finally posted SQL Server 2012 Service Pack 1 Cumulative Update 4, which is Build 11.0.3368. This release was about two weeks later than expected, which is a little unusual for Cumulative Updates. I count 38 fixes in the public fix list. These are probably the two most interesting fixes for the […]

The Accidental DBA (Day 4 of 30): SQL Server Installation and Configuration Best Practices

This month the SQLskills team is presenting a series of blog posts aimed at helping Accidental/Junior DBAs ‘keep the SQL Server lights on’. It’s a little taster to let you know what we cover in our Immersion Event for The Accidental/Junior DBA, which we present several times each year. If you know someone who would benefit from […]

The Accidental DBA (Day 3 of 30): Hardware Selection: Solid State Drives and Usage

This month the SQLskills team is presenting a series of blog posts aimed at helping Accidental/Junior DBAs ‘keep the SQL Server lights on’. It’s a little taster to let you know what we cover in our Immersion Event for The Accidental/Junior DBA, which we present several times each year. If you know someone who would benefit from […]

SQL Server 2014 Announced

Microsoft has finally released some information during the TechEd North America 2013 Day 1 Keynote about the next major version of SQL Server, which will be called SQL Server 2014. According to Mary Jo Foley, it is due to be released in early 2014, shortly after the release of Windows Server 2012 R2 (aka Windows […]

The Accidental DBA (Day 2 of 30): Hardware Selection: Disk Configurations and RAID -> Performance not Capacity

This month the SQLskills team is presenting a series of blog posts aimed at helping Accidental/Junior DBAs ‘keep the SQL Server lights on’. It’s a little taster to let you know what we cover in our Immersion Event for The Accidental/Junior DBA, which we present several times each year. If you know someone who would benefit from […]

The Accidental DBA (Day 1 of 30): Hardware Selection: CPU and Memory Considerations

This month the SQLskills team is presenting a series of blog posts aimed at helping Accidental/Junior DBAs ‘keep the SQL Server lights on’. It’s a little taster to let you know what we cover in our Immersion Event for The Accidental/Junior DBA, which we present several times each year. If you know someone who would benefit […]