Blog Posts of the Week 2015-09-04 Here’s a collection of blog posts, videos and links that i found useful this week…

Tech Posts

Status of DBCC CheckDB
SQL SERVER – What’s the Difference between ROW_NUMBER, RANK, and DENSE_RANK? – Notes from the Field #096
Announcing SQL Server Management Studio – August 2015 Release
Introducing: SQL Server 2016 Community Technology Preview 2.3
CONGRATULATIONS @JSnover – A Well-Earned Honor
SQL Server 2016 CTP 2.3 Custom Logging Levels
I am Data Science, and you can too! (or, Buck is Back)
How to create cascading drop downs in Excel – video
Join Me for Free #PowerPivot Training w/ @ExcelBIPASS Sept 10 – 12p CDT
The default instance has a name
Power BI Desktop & Excel
Avoid Frequent use of TVPs With Wide Rows
SQL 2014 queries under a strobe light
Live Query Statistics in SQL 2014, not just SQL 2016
Build models & dashboards faster with Watch Window
Understanding Rebinds and Rewinds
Introduction to PowerShell 5 Classes
CONTEXT_INFO and efficient mass update on a large table with a trigger
Full disks and databases
The default instance has a name
What does #DevOps mean to the roles of Change & Release managers?
Understand the Limitations of SQL Server Dynamic Data Masking

Other Interesting Posts

The average
Contempt is contagious
Failing, again
How to Think Visually
10 Tiny Ways to Boost Your Productivity Today

Upcoming Events

SQLSaturday #411 – Cambridge 2015
SQLSaturday #467 – Southampton 2015
UK SQL Server User Groups
UK SharePoint User Groups UK Azure User Group
PowerShell User Groups