SQL Server Solutions

How to Save License Costs by Checking Whether Enterprise Features are Used in Your SQL Server Databases

It is very common that many machines in your company might be using Enterprise editions of SQL Server while none of those enterprise features were ever used. This will heavily impact the license cost and should be fixed. Find servers If you are already maintaining an inventory of SQL servers, then it is an easy task to identify machines that are running Enterprise editions of SQL server. The next step is to identify if the applications hosted on these machines require an enterprise edition...

Read more »

How to Auto Check SQL Server Services or Essential Windows Services

You might have scheduled important jobs through SQL Server agent but they would have missed the schedule as the SQL Agent might have been turned off accidentally. You can be sure that this never happen again. If SQL Server services do not run properly then SQL Server database corruption might be a reason. Start with the configuration table Create a configuration table with columns "Servername", "ServiceName" and "DesiredStatus" and fill the table with respective values. For example if you...

Read more »

How to Auto Check SQL Server Configurations and Fix Non-compliances

You can complete a quick audit of SQL Server's configuration on all servers in your Company. The script will be helpful to auto fix configurations that are non-compliant Create three tables: We are going to create 3 tables. In the first table, we will be saving SQL Server Configuration name and its recommended value. This table will act as source table for comparison. If you are using SQL 2014, do not miss to take care of the configuration item namely "backup checksum default". By default the...

Read more »