Msg 7411 says the server is not configured for RPC. A Jr. DBA I am training found the fix on his own: turn the RPC option from False to True.
What RESTORE VERIFYONLY Checks and What It Misses
RESTORE VERIFYONLY checks backup readability and checksums, but it cannot prove a full restore or healthy data; pair it with restore tests.
SQL SERVER – Three T-SQL Script to Create Primary Keys on Table
Three T-SQL scripts to create primary keys: two while creating the table and one with ALTER TABLE later, where the column must first be NOT NULL.
STConvexHull: Enclose a Shape Without Its Indentations
STConvexHull encloses a geometry with its smallest convex hull. Compare a concave polygon, a collinear line and a point using area and membership.
Describe a Result Set Without Executing Its Query
Describe a result set without running the query. Check column names, data types, nullability and declared parameters.
SQL SERVER – Pre-Code Review Tips – Tips For Enforcing Coding Standards
Pre-code review tips for DBAs: why I check stored procedures on our development server every day for coding standards, with a link to my full article.
SQL SERVER – T-SQL Script to Add Clustered Primary Key
A Jr. DBA asked me three times in one day how to create a clustered primary key, so I gave him this ALTER TABLE example. He never asked again.