Under a tight downtime window, a client got “The patch installer has failed to update the shared features”. Here is what the logs showed and how we fixed it.
How to Get Column Names From a Table in SQL Server
To get column names from a table in SQL Server, query sys.columns with OBJECT_ID, or read INFORMATION_SCHEMA.COLUMNS. This tutorial tests four methods on a demo table, shows the schema trap that returns too many columns, and builds a paste-ready column list. It also finds every table that has a given column.
How Default Value and Nullable Column Works? – Interview Question of the Week #129
How do a default value and a Nullable Column work together in one table? Two short scripts from an interview panel show exactly what SQL Server does.
MSDB Growth From queue_messages: How to Clear the Queue
MSDB growth from the queue_messages tables means a Service Broker queue holds messages that nobody reads. This post builds a queue with unread messages in a test database, finds it with a size query, ends only its conversations with the CLEANUP option, and watches the space come back. It also says why you should never end every conversation in msdb.
Log Shipping Alternative for Databases in Simple Recovery Model
A log shipping alternative for a database in the simple recovery model is a second copy that restores the newest full backup and the newest differential backup. This post finds those two files from the backup history in msdb, restores them with MOVE and RECOVERY, and repeats the cycle on a schedule. It also states what you lose compared with real log shipping.





