Standard DBA reports can use T-SQL to show backup age, database sizes, job failures, login changes, and errors in one weekly review.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Fix Error 9803. Invalid data for type “numeric” – Data Type Mapping
My present article talks about an error that you will encounter when connecting to Oracle database using OPENQUERY. Let us learn about how to fix error 9803.
SQL SERVER – Maximum Columns per Primary Key – Fix : Error : Msg 1904, Level 16, The index on table has column names in index key list. The maximum limit for index or statistics key column list is 16
What are the maximum columns per primary key? It is 16, and going past it raises Msg 1904. The same limit applies to foreign keys and index keys.
Reading the SQL Server Support Lifecycle
Read the SQL Server support lifecycle for your exact release, distinguish mainstream and extended support, and plan before coverage ends.
LEFT Boundaries: Zero, Oversized Length and Missing Text
LEFT boundaries keep empty prefixes separate from missing values. Eight short Unicode cases expose zero, oversized and missing lengths. A separate invalid request shows why negative lengths need validation.
SQL SERVER – Logical Query Processing Phases – Order of Statement Execution
Logical Query Processing is the order in which SQL Server handles each clause of a statement, with FROM and ON first and SELECT near the end. Here are the phases.
DATEFROMPARTS: Build Dates With Explicit Components
DATEFROMPARTS avoids ambiguous text assembly. Preserve year, month and day inputs while separating missing components from invalid calendar dates.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.