My Top 5 Articles of year 2008 from SQLAuthority.com and pinaldave.com, led by the most visited page: the SQL Server 2008 interview questions and answers list.
SQLAuthority News – Recap Year 2008 – Two Most Important Event of My Life
Recap year 2008: the two most important events of my life were my SQL Server MVP award and marrying Nupur on December 12. Happy New Year to all.
Is a Certification Worth It, and What to Study Instead
Decide whether a SQL Server certification supports your next role, then build practical study projects around recovery, security, and tuning.
SQL Server Express Limits: What the 10 GB Cap Really Means
Check SQL Server Express limits by version, separate data files from logs, and identify the memory, CPU, and scheduling limits that affect you.
What Breaks When You Upgrade, and How to Find It First
Prepare for a SQL Server upgrade by checking deprecated features, compatibility, collation, plans, and application behavior before moving.
SQL SERVER – Find Collation of Database and Table Column Using T-SQL
A quick tip to find the collation of database and table column in SQL Server with DATABASEPROPERTYEX and sys.columns, using AdventureWorks.
Designing a Database for Multiple Customers
A database for multiple customers can share tables, split schemas, or split databases; the choice balances isolation and operating cost.