Learn what the ROW_NUMBER function is, how to use it, and what are some use cases and limitations for DBAs who need to manipulate and analyze data with SQL queries.

# simple query customizations to select particular columns and numbers of rows. # There are a couple more standard SQL query chops that will aid you in your journey to becoming an SQL ninja. # Let's ...

In addition to StretchDB and AlwaysEncrypted, there are two more exciting features in the works for SQL Server 2016: dynamic data masking and row-level security. In the case of these two features, ...