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.
Stretch Database in SQL Server 2016: 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 hot data stays on premises. Microsoft has since discontinued it.
SQL SERVER – System Objects Not Visible in SQL Server Management Studio
Why were system objects not visible in SSMS 2016 when SSMS 2014 showed them on the same instance? A client asked me, and here is the answer.
SQL SERVER – How Much Free Space I Have in My Database?
Free Space inside data files differs from unused space on the Windows volume. I check both when planning growth.
SQL SERVER – Vertical Select Mode feature in SQL Server Management Studio
Balmukund showed me the Vertical Select Mode in SSMS: hold ALT, select a block, then type on every row at once. It works in SQL Server 2012 and later.