The default ORDER BY

Ordering with NULL

Check Windows Services Status with T-SQL

In this article we look at creating a SQL Server stored procedure that displays a list of all Windows services based on running or stopped state.

Using Triggers to Replace Scalar UDFs on Computed Columns

Using Triggers to Replace Scalar UDFs with Brent Ozar.

Storing the Timezone

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 […]