News

Bleeping Computer

Microsoft pulls SQL Server 2019 update due to snapshot issues

Update: Microsoft released SQL Server 2019 CU8 with a fix for the reliability issue that impacted SQL Server 2019 CU7. Microsoft pulled the Cumulative Update package 7 (CU7) for SQL Server 2019 ...
MCPmag

Write .NET Code in SQL Server

Technology Toolbox: VB.NET, C#, SQL Server "Yukon" All versions of SQL Server prior to SQL Server "Yukon" provide two ways to write procedural code that executes inside the database. The usual way is ...
Ars Technica

MS SQL Server - way to query all of the tables in a database for a given column name?

I know in Oracle you can use DBA_TAB_COLUMNS (or ALL_TAB_COLUMNS). My SQL Server knowledge is very rusty, but can't you use the INFORMATION_SCHEMA.COLUMNS view?