Amazingly enough I have just learned for a new very convenient way of investigating bad performance. Usually when someone says “My SQL is running very…
I’ve planned to write a series of post regarding different tools which you can use for performance analysis and troubleshooting but tonight I found that…
In this post I would like to share a simple query showing currently running statements (using sys.dm_exec_requsts DMV) along with the connection type, address and…
In this post I would like to share a simple way of extracting latest database backup including the user that has initiated it. Generally SQL…
Have you ever wondered how easily to extract non-default SQL Server instance settings? Well recently I had to perform such task so I can apply…
In this article I will describe in details (including some examples) how you can build your own SQL Server Management Studio reports that are loaded…
This is a very strange issue I came across last week. We have a consolidation server with several 2005 SP3 instances, including couple of…
In one of my previous posts I showed you how to register multiple instances in SQL Server Management Studio Registered Servers explorer. However registering them…
With the following script you can easily find all FTS catalogues and their state on the SQL Server instance. This could come handy when you…
Recently I came across a strange message in SQL Server Error Log: “SQL Server failed to set security information on the full-text FilterData directory in…