Sqlserver Developer [better] Info

The daily duties of a SQL Server Developer often bridge the gap between back-end application development and raw data management. Key tasks include: Securing Your SQL Server - CODE Magazine

(deadlock-prone):

-- Split: Get all orders for given list of IDs DECLARE @Ids VARCHAR(MAX) = '101,205,389,476'; SELECT o.* FROM Orders o INNER JOIN STRING_SPLIT(@Ids, ',') AS s ON o.OrderId = CAST(s.value AS INT); sqlserver developer

– SQL Server now rivals NoSQL for document storage. The daily duties of a SQL Server Developer