I am very glad to share that Microsoft has given me the Most Valuable Professional Award for SQL Server. Thank you to MVP Lead Abhishek and all my readers.
SQL SERVER – 2008 – High Availability – Hot Add Memory
Hot Add Memory in SQL Server 2008 needs capable hardware, Enterprise or Datacenter Windows, and 64-bit Enterprise Edition or 32-bit with AWE enabled.
Parameterized Queries From Application Code
Use parameterized queries from application code to prevent SQL injection, improve plan reuse, and avoid parameter length mistakes.
COLLATIONPROPERTY CodePage: Identify Text Encoding
COLLATIONPROPERTY CodePage reports varchar encoding metadata. Compare code pages 1252 and 65001 without confusing inspection with text conversion.
SQL SERVER – Difference Between DBMS and RDBMS
What is the difference between DBMS and RDBMS? An RDBMS adds tables with enforced relationships, plus the constraints and security a plain DBMS lacks.
DATEPART Quarter: Keep the Year Beside the Quarter
DATEPART quarter identifies a calendar component. I keep its year when reporting separate periods. A cross-year January case shows how quarter-only grouping combines events.
A One Page Reference for Everyday SQL Server Work
Build a practical SQL Server reference around everyday questions, with compact queries for context, objects, requests, space, and transactions.