With SQL Saturday Cambridge last week and home duties taking over this weekend heres a couple bill to make up for it.

Tech Posts

PowerTip: Display Current Time with PowerShell
SQL Server 2016 Temporal Tables and Type II Data Warehouse Dimensions
Using @@ROWCOUNT can be a bit tricky
Understanding Non-Terminating Errors in PowerShell
Updated DSC Resource Kit available in the PowerShell Gallery
Seek and You Shall Scan Part I: When the Optimizer Doesn’t Optimize
Stop Using INFORMATION_SCHEMA and SysObjects for Exists Checks
Looking forward to Containers
The Myth About Estimated Execution Plans
Install SQL Server Management Studio with Web Installer without Internet Access
SQL Server’s statistics
Watch the Power Pivot 101 Webinar Recording
SQL Server Reporting Services Unknown but Useful Functions
Parallel Execution Plans
Using PowerShell to create Excel Spreadsheets without having Excel installed
What the heck is a SQL Server HOBT, anyway?
Temporal table behind the scenes – part 1
Step by Step SSIS learning What Data Conversion use in SSIS ? TIP#116
SQL Server Real-time Monitoring using WMI classes: Part -1
Weekend Scripter: Introduction to PowerShell 5 classes—The Video
I am Data Science, and You can Too!
Who blew up my TempDB?
Streamline Log Shipping Failovers: DR Made Just For You…
What is the Difference Between Full Load and Incremental Load
Machine Learning
One Easy Strategy for the Database Enterprise
Learning Extended Events in 60 Days
Why The Query Store is Awesome and You Should Immediately Use It
Constant and Read-Only PowerShell Variables for Admins Who Fear Change
Automated Metadata Report for SSAS Tabular
Yes, Foreign Keys Help Performance
When to Quote in PowerShell
How to Confuse the SQL Server Query Optimizer
HammerDB Performance Collection with SQL Server – Updated
Outlier Detection with SQL Server, part 8: A T-SQL Hack for Mahalanobis Distance
Work of art – the intra query parallelism deadlock graphs
Finding the worst running query in a stored procedure
The #TSQL2sday #70 roundup
Why is my tSQLt test not running?

Other Interesting Posts

The hacker culture is winning
Top 10 Ways to Improve Your Communication Skills
24 Signs You’re An Introvert- Not Shy
How I demo user stories
10 Reasons Why Candidates Miss Out on a Job Offer

Upcoming Events

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