SQL Server 2016 is almost here, while many still run 2014. In Notes from the Field #120, Mike Lawell shares SQL Server 2016 – Early Thoughts and Observations.
“I Don’t Know” – DBAs Should Learn to Use This Phrase – Notes from the Field #119
In Notes from the Field #119, Mike Walsh explains one of the most important things DBAs should learn: how and when to say ‘I don’t know’.
SQL SERVER 2016 – STRING_SPLIT Function Performance Comparison – Notes from the Field #118
Splitting strings once meant temp tables or CROSS APPLY. In Notes from the Field #118, Kathi Kellenberger compares STRING_SPLIT performance in SQL Server 2016.
SQL SERVER – The NOLOCK Question – Notes from the Field #117
NOLOCK is one of the most abused hints I see. In Notes from the Field #117, Stuart Ainsworth explains when Nolock makes sense and why overusing it is risky.
SQL SERVER – Boosting User Experience with Analysis Services Perspectives – Notes from the Field #116
Analysis Services Perspectives let a designer show users only the parts of a data model they need. Notes from the Field #116 explains how they help users.
SQL SERVER – Attaching and Restoring Database in Clustering Generates An Error – Notes from the Field #115
Attaching or restoring a database on a cluster and getting an error? In Notes from the Field #115, Eduardo Castro explains what goes wrong with Clustering.
SQL SERVER – JSON Support for Transmitting Data for SQL Server 2016 – Notes from the Field #114
In Notes from the Field #114, Kathi Kellenberger explores the new SQL SERVER – JSON support in the 2016 release and how it helps you transmit data from queries.