SQL Agent would not start in a cluster and SQLAgent.OUT said SQL Server Agent terminated (normally). Here is what the log showed and how I fixed it.
Oracle Number Data Types: The SQL Server Mapping Table
Oracle number data types need the right SQL Server match during a migration. Here is the full mapping as a table, and the implicit converts a safe bet of Int or BigInt caused for one product team.
SQL SERVER – Maintenance Plan Folder Missing Under Management in SQL Server Management Studio
A reader wanted scheduled backups on SQL Server 2016 but found the Maintenance Plan Folder Missing under Management in SSMS. Here is my answer.
SQL SERVER – FIX – Agent XPs Component is Turned Off as Part of the Security Configuration for this Server
New Maintenance Plan Wizard fails with ‘Agent XPs component is turned off as part of the security configuration’? Here is how to turn Agent XPs back on.
Can We Have NULL Value in Primary Key? – Interview Question of the Week #075
Can we have a NULL value in primary key columns? No. The primary key has to uniquely identify each row, and NULL cannot do that. Here is why.
SQL SERVER – FIX – Linked Server Error 7399 Invalid authorization specification
Creating a linked server with just a server name can fail with Error 7399, Invalid authorization specification. Why the Linked Server test fails and the fix.
Changing a User-Defined Table Type That Procedures Use
You need one more column in a table type, but procedures depend on it. Here is the order of moves that works, with the errors along the way.