JSON support in SQL Server 2016

At last, SQL Server has caught up with other RDBMSs by providing a useful measure of JSON-support. It is a useful start, even though it is nothing like as comprehensive as the existing XML support. For many applications, what is provided will be sufficient. Robert Sheldon describes what is there and what isn't.

Byte Me: Set in Stone

The good old days?

Exploration of SQL Server 2016 Always Encrypted – Part 2

It is important to only allow authorized individuals access to confidential data. Therefore when setting up an Always Encrypted table it is important to consider splitting configuration tasks between multiple individuals/groups to improve security. Follow Greg Larsen as he shows how to setup up SQL Server Always Encrypted tables where database administrators can’t see the clear text confidential data.

Optimizing Update Queries

Paul White spends some time optimizing update queries in order to explore some SQL Server internals.

The Boardgame of Office Politics

Sometimes the stress of interdepartmental friction within organisations can get on top of you, especially between the business and IT when the going gets tough. Simple-Talk's answer is a board game to put it all into perspective. Instead of getting carried away, play the board game instead and reach catharsis.

The PoSh DBA - Using the Basic PowerShell Paradigms

PowerShell is like any computer language: you must understand the paradigms, the constructs, and the way it is designed to work to get the most value from it. It is no good just translating 'sausage-string' procedural algorithms. To demonstrate how Powersahell should be used as its' creators intended, Laerte Junior shows the difference between PowerShell problem-solving with, and without, PowerShell paradigms.

Plan for failure in automated deployments

Failures happen with manual and automated releases, they are a fact of life. Make sure you know how and when to rollback failed deployments

Actual “Number of Rows Read” in SQL Server Execution Plans

Kendra Little takes a look at the upcoming SQL Server 2016 'Number of Rows Read' feature in action.

Byte Me: Three Wise Men

Best Practices For Deleting SQL Server Data

Inevitably there comes a time where some backend data cleanup needs to be done. Ben Snaidero shares some best practices to follow when deleting data.