What Resets @@ROWCOUNT?

Checking the Check Constraint

Handling the Duplication of Records

Learn how to easily identify and remove duplicate records when you discover them.

UTF8 and varchar lengths

NoSqlOnSql

Introduction NoSqlOnSql is a strict syntactical superset of SQL; it adds NoSQL document-oriented capabilities to the SQL language. For this, it uses uses JSON-like documents, integrating them into the normal flow of SQL statements. NoSqlOnSql is based on augmenting a SQL database to support NoSQL features without any kernel changes. In this sense it is […]

The Best Query

Funny code

Setting Rows to Odd and Even Values

A ran into a problem where I needed to set certain...

A Strange Comparison

Dynamic Data Unmasking

The SQL Server 2016 dynamic data masking feature may seem like a great way to obfuscate data for downstream systems like dev and QA. Joe Obbish shows us that the data can be “unmasked” with T-SQL statements, so it’s not secure against anyone who can write their own queries.