SQLServerPedia.com/Wiki Launch Party at PASS
All, I have just been informed that there will be a Lanch Party for the SQLServerPedia.com/Wiki website at PASS on Wednesday the 19th. If you will be attending PASS be sure to swing by Booth 414 (Quest Software’s booth) and pick up your party invite. Details for the location are on the invite, so be […]
How to fix when you can’t copy data when RDPed into a server
So you are RDPed into your SQL Server, and you are trying to copy a script from your desktop to the server, or from the server to your desktop. But you can’t for some reason. All you get is what’s in the local buffer. One option is to log out of the machine and log […]
Very useful little query to monitor the health of service broker
While dealing with a SQL Server Service Broker issue I needed a quick easy way to see how backlogged the service broker was. So I came up with this little query which is surprisingly effective. select far_service, state_desc, count(*) messages from sys.conversation_endpoints group by state_desc, far_service ORDER BY far_service, state_desc Hopefuly you find this helpful. […]
Very useful little query to monitor the health of service broker
While dealing with a SQL Server Service Broker issue I needed a quick easy way to see how backlogged the service broker was. So I came up with this little query which is surprisingly effective. select far_service, state_desc, count(*) messages from sys.conversation_endpoints group by state_desc, far_service ORDER BY far_service, state_desc Hopefuly you find this helpful. […]