Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Select blah, blah, STUFF(( SELECT ' ' + CC.[First Name] + ' ' + CC.[Last Name] + '-' + B.Notes + CHAR(10)+ CHAR(10) FROM dbo.[Client Contact Events] AS B INNER JOIN dbo.[Client Contacts] CC ON B.[Contact ID] = CC.[Contact ID] WHERE [CVT].[Client ID] = B.[Client ID] AND B.EventType = 'Visit' AND B.[Contact Date] > [CVT].createdDate FOR XML PATH ('')),1,0,'') AS [Contact Notes] From myTable
|Add a step to a system backup job||6||20|
|Are triggers slow?||7||15|
|Reformat SQL - so SSRS can read the columns||25||14|
|SQL Select - change time values for one row based on value in matching row||7||29|