Fix the maintenance plan error in SSMS, could not load type IDTSPackageSigning100, when existing plans run fine but you cannot modify them.
SQL SERVER – Unable to See Tables (Objects) in SSMS
A client could query a table but was unable to see tables in SSMS Object Explorer. A DENY permission was the cause. Here is how I tracked it down.
How to Query Multiple SQL Server with a Single Query? – Interview Question of the Week #106
A senior DBA needed to check SQL Server 2016 SP1 on every server. Here is the neat way he used to query multiple SQL Server instances with a single query.
SQL SERVER – SSMS Tip – Using Drag and Drop Capability
A lesser known SSMS trick: drag and drop from Object Explorer into the query window to get table and column names typed for you. Handy for documentation.
SQL SERVER – SSMS – Script Out Multiple Objects
Do you script objects one at a time in SSMS out of habit? There is a quicker way to script out multiple objects in one go, and here is how.
dbForge Studio for SQL Server – Ultimate SQL Server Manager Tool from Devart
dbForge Studio for SQL Server from Devart is a powerful IDE for managing, configuring and developing SQL Server, with coding help and SQL formatting.
Special Icon on System-Versioned Table in SQL Server 2016 – Interview Question of the Week #101
Expanding tables in WideWorldImporters in SSMS 2016, you see an icon like a watch. It marks a System-Versioned table, also known as a temporal table.