MSSQL How long will data be in cache/buffer
admin How fast is data leving the cache, when it not access again. With this query, you can see how fast data will get expire, and overwritten by new data in…
Computer
MSSQL: Whitch database used most memory
With this query, you can see whitch database that is using most memory
MSSQL – See buffer hit ratio
Whit this code, you can see how much of query in percent at this moment is reading from the cache/buffer.
CAPI2 Error in event viewer when taking backup
When taking backup of a SQL server i got this error in my event viewer, every times the backup is running:Event Viewer Error: Cryptographic Services failed while processing the OnIdentity()…
Exchange and TLS problems
Today i have a problem that an exchange will not send mails though TLS, no matter what i do. I find out that, somehow this exchange servers where creating new…
Enabled RemoteFX locally on a non domain joined computer
For some reason RemoteFX USB Redirection is not enabled standard in Windows. So what to do with a non domain joined computer, you can change GPO from the Active Directory.…
Change RDWEB to not redirect sound to client
If you have Installed Skype for Business and have enabled RemoteFX. You might still find that Skype for Business is saying that it using Remote Audio, even if you have…
Enable Full Desktop in RemoteApp Collection
If you have a RemoteAPP collection, and you will like to have allow you user, to access a full Desktop. This can be changed by logging into yours Remote Desktop…
RemoteFX not working anymore
Today I have this problem, that no matter what I do. I could get RemoteFX to work.The strange things is it where working yesterday, and no one will admit that…
See if a database is using Enterprise features of an Microsoft SQL server.
Run this command to see if any database on the SQL Server is using enterprise features