Most T-SQL statements run fine without a semicolon, but a pasted CTE, THROW or MERGE will not. Here is how to read the error and fix the line above it.
What a Junior DBA Should Learn First
Build junior DBA skills around restores, permissions, blocking, and safe investigation, with a practical learning order and useful SQL checks.
Partitioned Views: Splitting a Table Without Table Partitioning
A view over yearly tables only skips the years it does not need while the CHECK constraints are trusted. Here is how to see it, break it and fix it.
Connecting to SQL Server From Linux
Connecting to SQL Server from Linux requires the right Microsoft ODBC packages, a Kerberos plan, and certificate trust that matches the server name.
SSIS Project and Package Deployment Explained
Understand SSIS deployment models, catalog environments, parameter bindings, and the checks that keep package execution predictable after deployment.
SQL SERVER – Effect of SET NOCOUNT on @@ROWCOUNT
Does SET NOCOUNT change @@ROWCOUNT? I ran a quick demo in a session and ten hands went up before I even hit execute. The script and what it shows.
Storing Email Addresses: Length, Case and Unique Keys
Two accounts for one customer usually means nobody wrote down the case rule. Build the table, break each rule, and see what the database can promise.
Handling the Row That Arrives Late
Handle late arriving data with explicit event dates, inferred dimension members, replay windows, and a clear policy for correcting published history.
Listing Server Logins Not Mapped to Any Database User
A login with no database user is not automatically unused. Build the report, compare by SID, and check server roles before you touch anything.










