Temp table versus table variable, part two: a transaction rollback undoes changes to a temp table, but a table variable keeps its values.
Which Features You Lose When You Drop an Edition
Review SQL Server edition features before moving down an edition, check persisted dependencies, and test maintenance and availability behavior.
SQLAuthority News – Meeting SQL Expert Imran at Hyderabad
I finally met SQL expert Imran Mohammed, one of the top helpers on this blog, over dinner in Hyderabad. He was much younger than I expected.
SQL SERVER – Comma Separated Values (CSV) from Table Column – Part 2
Comma Separated Values from a table column, part 2: SUBSTRING limits the XML length, so I rewrote the query with STUFF and FOR XML PATH to remove it.
SQLAuthority News – Featured on Channel 9
This blog was featured on Channel 9 in This Week on Channel 9, where Scott Hanselman and Jon Galloway talked about my CSV from table column post.
SQL SERVER – White Papers – Consolidation Guidance for SQL Server – Consolidation Using SQL Server 2008
Two white papers by Allan Hirt: Consolidation Guidance for SQL Server, which compares three consolidation options, and Consolidation Using SQL Server 2008.
TDE, Column Encryption and Always Encrypted Compared
Compare SQL Server encryption options by the threat they address, where keys live, what applications must change, and how recovery is tested.