SQL Server 2012 Service Pack 1 is available!

Microsoft has released Service Pack 1 for SQL Server 2012. Though so far it is only being made available for the x64 platform. You can download here: http://www.microsoft.com/en-us/download/details.aspx?id=35575 And read about the fixes in the following KB article: http://support.microsoft.com/kb/2674319 And new features are detailed here: http://msdn.microsoft.com/en-us/library/bb500435 The build # appears […]

Two bugs you should be aware of

In the past 24 hours I have come across two bugs that can be quite problematic in certain environments. LPIM issue with SetFileIoOverlappedRange Last night the CSS team posted a blog entry detailing a potential issue with Lock Pages in Memory and Windows' SetFileIoOverlappedRange API. I tweeted about it at […]

SQL Server 2008 Cumulative Updates are available!

SQL Server 2008 Service Pack 2 Cumulative Update #9 KB article : http://support.microsoft.com/kb/2673382 Build number is 10.00.4330 7 fixes (5 in database engine, 2 in SSAS) Relevant for : Builds of SQL Server between 10.00.4000 and 10.00.4329 SQL Server 2008 Service Pack 3 Cumulative Update #4 KB article : http://support.microsoft.com/kb/2673383 […]

Connect Digest : 2012-03-06

This time around, I've got five wish list items for T-SQL / DDL, and then one bonus – a parallelism bug. My thinking on the former is that, since we are either about to start (or are just finishing) locking down the code for SQL Server 2012, this is the […]

Installing Windows Server 8 & SQL Server 2012

Microsoft recently released Windows Server "8" Beta for download. When you launch setup you'll be asked if you want to install Server Core or Server with a GUI:   While I will definitely be leaning toward Server Core for production, I chose the GUI installation for now just to feel […]