Microsoft

Announcing SQL Server 2022 preview: Azure-enabled with continued performance and security ...

Today we are announcing the preview of SQL Server 2022, the most Azure-enabled release of SQL Server yet, with continued innovation in performance, security, and availability. The rise of data ...
Redmond Magazine

Microsoft Adds SQL Server Disaster Recovery Use Rights with Software Assurance

Microsoft announced on Oct. 30 that it expanded SQL Server passive use rights for organizations licensing SQL Server with Software Assurance (SA) coverage. Organizations with SA coverage on SQL Server ...
GitHub

PACS DB Comparison using ISNULL, CASE, JOIN SELECT, AGGREGATION.sql

,RTRIM(case when NUM_SERIES_PACS2 is NULL then 0 else NUM_SERIES_PACS2 end) as NUM_SERIES_PACS2 ,RTRIM(ISNULL(num_series,0)) as num_series_PACS1 ,RTRIM(case when ...
Microsoft

Content type: Best Practices

We have released our second major update for mssql-cli since our public preview announcement in December. You can view the public preview announcement here. mssql-cli is a new and interactive command ...
GitHub

ExpressionList.isNull and SoftDelete is missing the "deleted = false" predicate in the ...

rbygrave changed the title ExpressionList.isNull and SoftDelete ExpressionList.isNull and SoftDelete is missing the and deleted = false predicate in the exists subquery Nov 1, 2017 rbygrave changed ...
Ars Technica

Settle an argument: SQL update with left join + isnull() vs inner join

I've been in an argument with one of our devs that took an update statement with an inner join and made it a left join (because inner was missing some records somehow in the left table - tableB in ...
51CTO

SQL Server里简单参数化的痛苦

在今天的文章里，我想谈下对于即席SQL语句（ad-hoc SQL statements），SQL Server使用的简单参数化（Simple Parameterization）的一些特性和副作用。首先，如果你的SQL语句包含这些，简单参数化不会发生： 在今天的文章里，我想谈下对于即席SQL语句（ad-hoc SQL statements），SQL ...