A-schema-changes C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions) ...

With the current schema changer infrastructure, it's difficult to support alter column type in transactions. This is because the computed column swap doesn't actually occur until the transaction is ...

SQL Server 2012 introduced two innovations targeted for data warehousing workloads: column store indexes and batch (vectorized) processing mode. Together they greatly improve performance of typical ...

Microsoft is offering users on Windows Server 2008 and 2008 R2 and SQL Server 2008 and 2008 R2 a way to keep getting security updates for free after the official support period ends. Read also: Here's ...

Microsoft on Thursday announced new Extended Security Updates plans that add three years of patch support for organizations using SQL Server 2008/R2 and Windows Server 2008/R2 products. The Extended ...

Microsoft on Thursday released Service Pack 3 (SP3) for SQL Server 2008. The new service pack arrives about one year after the release of Service Pack 2. SP3 contains a lot of fixes to the earlier ...

I have taught several classes on the new features of SQL Server 2008, made a Web Seminar and written a Whitepaper on the subject. I have also attended the SQL PASS Summit in Seattle where there were ...