[Note: After I loaded up my server with hundreds of thousands of queued messages, I discovered an annoying default setting in Windows that you should know about. The blog post/article […]
With 260+ tables that I created in VB.NET code via SMO to delete, I did it by first creating a DROP TABLE statement using:
declare @SQL nvarchar(max)
SELECT @SQL = STUFF((SELECT ', ' + quotename(TABLE_SCHEMA) + '.' + quotename(TABLE_NAME)
FROM INFORMATION_SCHEMA.TABLES WHERE Table_Name LIKE 'c_%'
FOR XML PATH('')),1,2,'')
SET @SQL = 'DROP TABLE ' + @SQL
You create a tidy DROP […]
I went through a LOT of libraries and packages, each claiming to be the bee’s knees when it came to communicating via SSH. I eventually landed on Renci.SshNet because: 1. […]
This is one of 2 that I have. They are shallow and heavy, so they won’t tip over. Very common in banks & post offices in pre-WWII.