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

Tech Posts

Filter as you type [Quick VBA tutorial]
Getting maximum consecutive years in T-SQL using Common Table Expressions (CTE)
What is a Page Split
Cross database dependencies and automated builds
Excel – Visualize statistics with Histogram, Pareto and Box and Whisker charts
I don’t use the Visual Studio SSDT Publish
SQL Server 2016 – Introduction to Stretch Database
Connect to Salesforce Data as a Linked Server
SQL SERVER – How to Identify Locked Table in SQL Server?
How to manage SQL Server security with SQL Source Control
Using Power Bi with my DBA Database
What are the hot IT certs these days, from your perspective?
24 Hours of PASS (September 2015): Summit Preview Edition
SSIS Catalog Logging and Reporting in the Enterprise
Minimal permissions needed to run sp_WhoIsActive
Basic SQL Server Performance Troubleshooting For Developers

Other Interesting Posts

Agreeing on the problem
Developer Turned Manager
How To Lie With Statistics
Grit and hard work

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