SQL Expert Jorge Segarra (@SQLChicken) tagged me with one question: how did I get started with SQL? Here is the story of my SQL journey.
SQL SERVER – List All the Tables for All Databases Using System Tables
A one line script with sp_msforeachdb and sys.tables to list all the tables for all databases on a server, updated with ideas from reader comments.
SQLAuthority News – Interview of Author on 60 Seconds with Pinal Dave
Vijaya Kadiyala interviewed me for his quick series 60 Seconds with Pinal Dave, about my MVP journey and summit experience. Read the interview on his blog.
SQL SERVER – Leading Zero to Number
Readers keep asking how to add a leading zero to a number. Here are my two earlier articles that pad a number with zeros for a fixed width display.
SQL SERVER – Introduction to SQL Server 2008 Profiler – Summary
An introduction to SQL Server 2008 Profiler: how to create, watch, store and replay a trace to see what runs under the SQL Server engine’s hood.
SQLAuthority News – Gandhinagar SQL Server User Group Meeting April 24, 2009
The next Gandhinagar SQL Server User Group Meeting is on Friday, April 24, 2009 at 6:30 PM, with fellow MVP Jacob Sebastian as our guest speaker.
SQL SERVER – FIX : Error: 18486 Login failed for user ‘sa’ because the account is currently locked out. The system administrator can unlock it. – Unlock SA Login
Error 18486 means the sa account is locked out, often after brute force attempts by hackers. Here is why it happens and how to unlock SA login.