A data professional portfolio should show a few complete projects, clear write-ups, and runnable code that explains decisions and tradeoffs.
Where T-SQL Differs From the ANSI Standard
See where T-SQL differs from the ANSI standard in row limits, concatenation, NULL behavior, and practical query portability.
Caching Query Results in the Application
Caching query results in the application can reduce repeated reads when ownership, expiry, invalidation, and memory cost are clear.
LocalDB: SQL Server on a Developer’s Laptop
LocalDB runs SQL Server Express engine features in a developer-friendly local process; learn how to start, connect, and recognize its limits.
Stop Blaming the User: Let Constraints Catch Bad Data
Blaming the user is the oldest joke in IT. Here’s why it fails, and how NOT NULL, CHECK, UNIQUE and foreign keys stop bad data before it lands.
A Learning Path for a New SQL Developer
A new SQL developer can build skill in a clear order: relational basics, T-SQL, data modeling, plans, testing, and safe deployment habits.
Connecting PHP to SQL Server
Connecting PHP to SQL Server means choosing SQLSRV or PDO_SQLSRV, binding parameters, validating TLS, and keeping web queries efficient.