Using A Block Predicate to Restrict Row Updates and Inserts

If you are using row level security in SQL Server 2016 you might find users are updating or inserting rows of data that keep them from seeing the row after they have performed the update or insert statement. If you want to prevent this from occurring, you can use a blocking predicate.

Byte Me: Avoiding Detection

Introducing Minion CheckDB by MinionWare

Minion CheckDB completes the MinionWare maintenance and backups suite in style. Each solution is plug-and-play for the busy DBA, and deeply configurable for those shops with in-depth needs.

The Future is Now - An Internet of Things Infographic

A look at the positive and negative aspects of IoT in this infographic.

Planning for Successful Data Management

It is the data, in particular, that sets Database Lifecycle Management apart from the mainstream of application delivery. Data entities, and the way that organisations understand and deal with them, have their own lifespan. If we neglect the management of data, we risk disaster for the organisations that use it. If we take data management seriously, databases become a lot easier.

A Wide Variation in Skill

We all have different levels of skills, and it's not always because we don't try. Sometimes it's a question of timing.

Loading Non Duplicated Data Using SSIS

Learn how you can easily load data from a file that isn't duplicated, discarding those rows that are.

SQL Server v.Next : STRING_AGG Performance, Part 2

Aaron Bertrand starts digging deeper into the performance of string concatenation methods STRING_AGG and FOR XML PATH.

Azure SQL Data Warehouse with PowerShell

We will teach how to create a new SQL Azure Data Warehouse using Powershell

The vNext Bleeding Edge

Microsoft has a new early access program for SQL Server.