Day 1 of MVP Summit began with the summit welcome and keynotes at a big gala event. Before that, a few Indian MVPs had fun at the Seattle Space Needle.
SQLAuthority News – MVP Summit 2009 – Day 0 – About Pinal Dave
Day 0 of MVP Summit 2009 in Seattle. People keep asking where I am from, so here is a little about Pinal Dave, a SQL expert from Ahmedabad, India.
SQLAuthority News – MVP Summit 2009 – Database Industry Discussion – Live From London Airport and Sheraton Seattle
On the way to MVP Summit 2009 I met fellow MVP Suprotim Agarwal, and our trip became a database industry discussion. Here are our top five points.
SQLAuthority News – MVP Summit 2009 – Journey Begins
My MVP Summit 2009 journey begins: I leave for Mumbai today and will be at the airport from 10 PM to 2 AM. If you are around, come say hello.
SQL SERVER – 2008 – Find Relationship of Foreign Key and Primary Key using T-SQL – Find Tables With Foreign Key Constraint in Database
A T-SQL script that finds every table with a foreign key constraint and shows how each foreign key relates to its primary key, now with schema names.
XPath First Items: Parentheses Change the Selected Nodes
XPath first items can mean one per parent or one overall. Compare step-local [1] with a parenthesized path, including full XML and empty selections.
SQLAuthority News – Author Visit – MVP Global Summit 2009 – Seattle and Redmond
I am all set for my first MVP Global Summit 2009 in Seattle and Redmond, March 1 to 4, to meet other MVPs and the Microsoft product teams.
SQL SERVER – Disable Windows Authentication – Remove Windows Authentication Login Account
A reader asked how to disable Windows Authentication in SQL Server. The short answer: it can not be disabled, and it is the most secure way to log in.
SQLAuthority News – Ahmedabad User Group Meeting February 21 2009 – Meeting Report
My review of our Ahmedabad user group meeting February 21, 2009: a growing crowd, two sessions on index usage and IDENTITY, and great feedback.
When SSMS and Your Application Return Different Results
Investigate SSMS different results by comparing connections, parameters, session options, transactions, and plans against the application.