I cannot teach everyone in person, so here are my 3 online SQL courses at Pluralsight, on Q and A, performance tuning and indexing, plus free learning resources.
SQL SERVER – Identify Most Resource Intensive Queries – SQL in Sixty Seconds #028 – Video
Which queries hurt your server most? This SQL in Sixty Seconds video shows how to identify the most resource intensive queries by reads, writes and CPU time.
SQL SERVER – Copy Column Headers from Resultset – SQL in Sixty Seconds #027 – Video
Copy column headers from resultset to Excel along with your data in SSMS, either once with Copy with Headers or always with one simple setting.
SQL SERVER – Effect of Collation on Resultset – SQL in Sixty Seconds #026 – Video
A sixty second video on the effect of collation on resultset: the same values in case insensitive and case sensitive columns give different results.
SQL SERVER – Get Date and Time From Current DateTime – SQL in Sixty Seconds #025 – Video
How do you get date and time separately from the current datetime? This sixty second video answers three common beginner questions with simple CONVERT scripts.
SQLAuthority News – A Quick Note on @Pluralsight Video – Call Me Maybe Developer Way
A good boss makes good employees. A fun Pluralsight video got me thinking about healthy work environments and why they matter for creative, happy teams.
SQL SERVER – Three Methods to Insert Multiple Rows into Single Table – SQL in Sixty Seconds #024 – Video
Tired of writing one INSERT per row? This SQL in Sixty Seconds video shows three methods to insert multiple rows into a single table.