Monthly Archive: March 2012

SQL Server 2012 Service Pack 1 is available!

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...

Two bugs you should be aware of

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...

SQL Server 2008 Cumulative Updates are available!

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...

T-SQL Bad Habits to Kick : NESQL 3/8

T-SQL Bad Habits to Kick : NESQL 3/8

Last Thursday I presented my "Bad Habits to Kick" presentation at the New England SQL User Group. Attached is the deck. File Attachment: NESQL_AB_BadHabits.pptx.zip

Connect Digest : 2012-03-06

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...

Installing Windows Server 8 & SQL Server 2012

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...