Day 1 of my unforgettable experience at TechEd 2011 Bangalore began before 5 AM after three hours of sleep, and I met Vinod Kumar at the venue.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQLAuthority News – TechED 2011 – Bangalore – An Unforgettable Experience – Day 0
TechEd 2011 in Bangalore was my third TechEd. This first part of my series looks back at my earlier TechEd sessions and how the event began.
Rows That Look Identical but Are Not: Finding Hidden Characters
Expose hidden characters with DATALENGTH and UNICODE, clean known whitespace safely, and add a constraint to prevent recurrence.
SQL SERVER – ‘Denali’ – A Simple Example of Contained Databases
What is new for security in SQL Server Denali? Contained databases keep their own settings, metadata and users, so moving them to a new server is easy.
hierarchyid GetDescendant: Insert Between Siblings
hierarchyid GetDescendant can generate a sibling location before, after or between existing bounds. This read-only example computes paths without inserting records or guaranteeing allocation.
SQL SERVER – Fix : Error : The request failed or the service did not respond in a timely fashion
The request failed or the service did not respond in a timely fashion: SQL Server would not start after TechEd. The event log and our password policy explained it.
VAR and VARP: Choose the Variance Denominator
VAR and VARP describe sample and population variation. Keep observation count and missingness visible when reporting their results.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.