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
Stuart Ainsworth discusses NOLOCK, dirty reads and safer alternatives. A two-session example shows why uncommitted results can be misleading.
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 – SSIS – Get Started with the For Loop Container – Notes from the Field #113
In Notes from the Field #113, Tim Mitchell shows how to get started with the SSIS For Loop Container to control how many times your ETL logic runs.