Optimizing Update Queries

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

Surface Book

Steve Jones is looking for a new laptop. Perhaps. Read on to see what he wants in a machine.

The SQLite alternative to NoSQL

Phil factor argues that if you are within the SQL and relational mindset, there is no good technical reason to have to change, since SQLite takes care of all the small stuff and the new breed of NewSQL takes care of the jelly-masses of unstructured data.

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.

Happy New Year 2016

Let's look forward to the new year.

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

The End of 2015

Steve Jones looks back at 2015 and the year we had as data professionals.

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