SQL Server (T-SQL) Keywords by Category
This blog post organizes DDL, DML, DCL, TCL, joins, operators, control-of-flow statements, and SQL Server-specific extensions into clearly defined sections. It also highlights which keywords follow the ANSI SQL standard and which are unique to SQL Server — a must-know distinction if you care about portability, performance, and clean database design.
Read More
T-SQL Coding Standards and Best Practices
One of the most important things you should learn as a DBA, or programmer of any coding language, is to adopt a standard coding practice. Establishing a consistent set of coding standards and best practices is crucial for any development team.
Read More
What Does a DBA Do All Day?
Daily Tasks and Responsibilities. In this article, we discuss exactly what an average DBA does in the course of a normal workday.
Coming February 11th 2026
Copy Tables
Learn how to copy any table, with or without data being transfered to the new table.
Coming February 18th 2026
DELETE vs. TRUNCATE Which One Should You Use
A simplified explanation of when to use DELETE as opposed to using TRUNCATE when clearing data from a table.
Coming February 25th 2026