SQLPASS Presentations

I make contributions to community because I also use cloud source to learn from other experts, for human society makes progress. My videos are on youtube.com for free space.

SQL Saturday #514, Houston, May 14, 2016, San Jacinto College South Campus		User Rating: 20 reviews above 54 top rating, 4 more at 44 ratings speaks overwhelming volume, User Feedback wrote on the back of survey ticket, (4 statistic outlier) 3 have no clues why they were there or personally not happy not becoming expert after 1 hour free lecture? (people could be unhappy about anything) Maybe I should not have marked the session for "beginner". Again I packed too much stuff because SQLPASS Summit session is 75 minutes, the stuff that have been explained before in my past presentations only advanced users can understand.	A Choice Performance Tuning Slides	Abstract Demo Video
WISSUG Nov. 10, 2015		The best way to trouble-shoot SQL Server performance problems is, not Extended-Event, as I have pointed out 2012 at SQL Server User Group, a pair of powerful queries that can be viewed real-time and/or recorded into history. The result sets give you insights of any particular performance issues directly.	Ah ha moment of Trouble-shooting SQL Server Slides	Abstract Demo Video
Idera Geek Sync Oct. 13, 2015		The best way to trouble-shoot SQL Server performance problems is, not Extended-Event, as I have pointed out 2012 at SQL Server User Group, a pair of powerful queries that can be viewed real-time and/or recorded into history. The result sets give you insights of any particular performance issues directly.	Ah ha moment of Trouble-shooting SQL Server Slides	Abstract Demo Video
SQL Saturday #408, Houston, June 13, 2015, San Jacinto College South Campus		The best trouble-shooting data capture query (is not Xevent), in fact, is my Active Session history together with Running Differential wait stats time-based capture, presented since HASSUG Dec. 2012.	A DBA's pick of 5 major differences between SQL Server and Oracle Slides	Abstract Demo Video
SQLPASS Houston User Group, Houston, June 9, 2015, Microsoft Campus		The general feedback at user group is good(er). Some says they cannot see the screen sitting at back-row. (Why are they sitting in the back?)	A DBA's pick of 5 major differences between SQL Server and Oracle Slides	Abstract Demo Video
SQL Saturday #308, Houston, May 10, 2014, San Jacinto College South Campus		Thank you for attending and great evaluations Evaluation Grade 4.57, 4.71 (1-5)	Ah, ha, How do you automate Database Administration? (Slides)	Abstract Demo Video

Houston, Texas, Microsoft Building Dec. 11, 2012, Troubleshooting SQL Server with Active Session History (and DIY Performance Data Warehouse) (using Powershell and T-SQL scripts to trouble-shoot SQL Server performance issues)

Schedule, Slides, Demo, Video

Apr. 21, 2012, SQL Saturday#107 - A Comparison of SQL Server and Oracle Houston (About similarity and difference on database administration features between SQL Server and Oracle)	Jan. 29, 2011, SQL Saturday#57 - Ask Why My Query So Slow ? Houston sa  review: .. rollicking good time with his dry wit and dead-pan delivery. SpeakerRate.com - top rated 4.56 event
Schedule, Abstract, Slides Feedback from audience after presentation: "Presentation looks very informative, maybe you need reduce slides and talk bit more. I am geeky guy so it looks good to me...." "Not as animated as last year. Your PowerPoint presentation really covered the material, delivery is not as lively as last year .... " "You are an amazing person. I visited your web site..."	Download ( all materials in a .rar ), Download on-screen recording video (32 MB) Schedule, Abstract ,   Slides, real-world code examples in slides Ask Why My Query So Slow? Feedback  sa review:  "....rollicking good time with his dry wit and dead-pan delivery ...."

Jun, 8, 2010, SQLPASS - Top 10 SQL Server Defaults to Modify Microsoft Building Houston <	Nov. 11, 2008, SQLPASS, Monitoring Database Blocking (with C# made web monitoring tool software  Microsoft Building Houston
Top 10 SQL Server Defaults to Modify Schedule(.jpg), Abstract (.html) PDF slides, .wmv (Windows media),	Monitoring DatabaseBlocking (with C#) Abstract (.html ), PPSslides