Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Dany Lepage discusses the architectural ...

With JSON now the default format for moving data between clients and servers, SQL Server adds JSON support to make it easier to get your data out of the database and down to the client. SQL Server ...

JSON has stolen some of XML's thunder with features such as human and machine readability, a lightweight, compact text structure and support for many software and hardware platforms. JSON (JavaScript ...

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?

Data has become the most valuable resource for modern enterprises. However, the people tasked with managing this valuable resource have one foot out the door. According to the recent State of Database ...

Arthur Fuller explores the value of identity columns and the usefulness of their arbitrary values and discusses ways to use SQL Server 2000's IDENTITY_INSERT setting. Despite your numerous ...

I am trying to create a view that contains 4 tables from 2 different databases on the same SQL server. My SQL statements can pull the results to the result pane with correct data.

The annual PASS Summit, the industry’s largest gathering of SQL Server professionals, hosted more than 4,000 attendees in Seattle recently recently. PASS (www.pass.org) has grown to more than 300 ...