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

Tech Posts

Change the restore mode of a secondary SQL Server database in Log shipping with SSMS
Extracting a SharePoint List with Power Query
Time For a Change (of Environmental Variables) — Steven Murawski
SQL Server Page Life Expectancy (PLE)
Choosing a Git Client
Identifying Transaction Log Backup Gaps
The SQL Server Job Management You Wish You Had
Troubleshooting Common SQL Server Bulk Insert Errors
Natively Query CSV Files using SQL Syntax in PowerShell
View of DevOps Inside Microsoft
Debugging Long-Running SQL Queries
SQL SERVER – WARNING – SQL Server Has Encountered N Occurrence(s) of I/O Requests Taking Longer Than 15 Seconds
Quick Installs with Chocolatey–Screen Capture
SQL Server 2014 Service Pack 1 is now available
Watch Brent Tune Servers [Video] #MSIgnite
#drunktufte : Twitter Photos Search
Should I use Backup Compression or NTFS Compression for Backups?
Testing SQL Server Backup Performance with Trace Flag 3042
How to run SSIS Project as a SQL Job
How To Remove the Identity Column in SQL Server
SQL Server 2012 T-SQL language enhancements

Upcoming Events

SQLSaturday #388 – Edinburgh – BI Edition 2015
SQLSaturday #418 – Manchester 2015
SQLSaturday #411 – Cambridge 2015
UK SQL Server User Groups
UK SharePoint User Groups
UK Azure User Group
PowerShell User Groups