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.
Read More
Copy Tables
Learn how to copy any table, with or without data being transfered to the new table.
Read More
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.
Read More
What are Database Objects
SQL Server objects—like tables, views, and stored procedures—are the core building blocks of every database. This beginner-friendly guide explains what they are, why they matter, and how they work together to manage and organize your data efficiently.
Coming March 4th