Stories by Sean McCown

SQL Server 2014 pushes the pedal to the metal

SQL Server 2014 is a significant release with two overarching themes: cloud and speed -- or, to be specific, Azure integrations and in-memory OLTP (online transaction processing). Truth be told, I'm more excited about the speed features than the cloud stuff, but I also understand there is a growing portion of the customer base that is heading to cloud-based operations, and these shops will find the cloud features useful.

Test Centre preview: Windows Server 2008 R2

The noisiest new feature in Windows Server 2008 R2 promises to be live virtual machine migration, as Microsoft seizes the chance to show that Hyper-V is closing the gap with VMware Infrastructure. But there are many reasons beyond server virtualization to take a close look at Windows Server 2008 R2. Important enhancements are spread across the board, ranging from IIS to networking to Terminal Services. There's even a story to be told about R2 and the upcoming Windows 7, which gains better virtual desktop integration and even secure remote access without requiring a VPN -- though the latter feature, called DirectAccess, requires the use of IPv6.

Deep dive into SQL Server 2008

SQL Server 2008, aka "Katmai," gives SQL Server shops plenty of reasons to get excited. The best SQL Server release to date, it sports more nice new features than you can count, and the improvements extend to both performance and manageability. In a few cases, such as the Resource Governor, you'll wish Microsoft had taken the functionality a little further. But whether you manage an OLTP environment, or an OLAP environment, or both, you will most likely find Katmai compelling. It easily passes my own five-point test for upgrades.