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.
SQL SERVER to Oracle Numeric Datatype Mapping
An app moved from Oracle to SQL Server slowed down under load. Here is what I learned about Oracle numeric datatype mapping while tracking it down.
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.
SQL SERVER 2016 – How to Use SQL Server 2016 – Stretch Database – Notes from the Field #127
Kenneth Urena shows how to use Stretch Database, the SQL Server 2016 feature that moves cold table data to Azure while your queries keep working.