A sixty second video on resolving SQL Server connection errors, the kind first time IT pros often hit after a fresh install and cannot figure out.
SQLAuthority News – A Conversation with an Old Friend – Sri Sridharan
My GTalk chat with old friend Sri Sridharan on why he is running for the PASS Board of Directors again after coming so close last year.
When One Number Has Three Different Answers
Diagnose reporting inconsistency by matching filters, refresh cutoffs, and row grain before comparing totals from different reports.
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.
How to Evaluate a New Database Without Fooling Yourself
Use realistic data and workload tests to evaluate a database, checking correctness, latency, recovery, compatibility, and the full operating cost.
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.
What to Collect When SQL Server Is Slow
Collect SQL Server diagnostic data in a useful order: waits, active requests, blockers, execution plans, and file IO during the slow period.