March 24, 2025
In the previous post, I talked about check constraints. Another type of constraint in SQL Server is a unique constraint. What I want to specify is […]
March 23, 2025
This is a post in the SQL Interview series. These aren’t trick or gotcha questions, they’re just questions designed to scope out a candidate’s knowledge around […]
March 22, 2025
I previously described how column data types help define what you can put in a column. But sometimes I need to be more specific. For example, […]
March 21, 2025
This is a post in the SQL Interview series. These aren’t trick or gotcha questions, they’re just questions designed to scope out a candidate’s knowledge around […]
March 20, 2025
I showed how identity columns are a special type of constraint. They can be int or bigint. Both work just fine. What you might need to […]
March 19, 2025
This is a post in the SQL Interview series. These aren’t trick or gotcha questions, they’re just questions designed to scope out a candidate’s knowledge around […]
March 18, 2025
One of the most popular courses that we used to run in person was a SQL Server Administration course. Yesterday, I recently finished converting the course […]
March 18, 2025
In the previous post, I talked about how you could add default values for columns. One special type of default value is called an IDENTITY constraint. […]
March 17, 2025
This is a post in the SQL Interview series. These aren’t trick or gotcha questions, they’re just questions designed to scope out a candidate’s knowledge around […]
March 16, 2025
Default constraints allow us to automatically provide values for columns when: we don’t supply them ourselves they are marked as NOT NULL so they are required […]
March 15, 2025
This is a post in the SQL Interview series. These aren’t trick or gotcha questions, they’re just questions designed to scope out a candidate’s knowledge around […]
March 14, 2025
Prior to SQL Server 2008, we could only insert a single row at a time. SQL Server 2008 added the ability to have multiple rows of […]