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…
Following is a video of a step-by-step setup of SQL Server 11 AlwaysOn availability group feature from Gopal Ashoc (Product manager for SQL Server High…
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…
Have you ever tried to figure out what traces are currently active on your SQL Server? Well recently I had to do it and it…
In this article I will share with you a script extracting longest running and most CPU using query statements and their plans. As a starting…
The goal of automating administration across a large organization is aiming at simplifying the day-to-day job of the DBA and also ease some dataflow tasks…