Maintenance

Ivan Stankovic

SQL Server Policy Based Management – The On Change evaluation mode

April 25, 2014 by
The Policy Based Management feature we described in the series of articles (see below) provides an efficient method to declare and enforce policies related to SQL Server instances and their objects. The main purpose of the feature is to facilitate maintenance of a single and, what’s more important, multiple SQL Server instances across the enterprise. Policies can be created on one SQL Server instance, and applied to other SQL Server instances afterwards, as explained in details in the SQL Server Policy Based Management – evaluating policies on multiple SQL Server instances article. Read more »
Ivan Stankovic

SQL Server security and Policy Based Management – Alerting

March 24, 2014 by
In the previous article related to the SQL Server Policy Based Management feature, we discussed and provided steps and tips to create conditions and policies that help maintaining SQL Server security in large enterprises with a number of SQL Server instances. Now, we are going to go further as once set policies are not much of a use if their violations are left unnoticed. Read more »
Ivan Stankovic

What is a SQL Server failover clustering

March 14, 2014 by

What is a failover cluster?

SQL Server failover clusters are made of group of servers that run cluster enabled applications in a special way to minimize downtime. A failover is a process that happens if one node crashes, or becomes unavailable and the other one takes over and restarts the application automatically without human intervention Read more »
Ivan Stankovic

A database back up task via SQL Server Maintenance Plans

March 14, 2014 by
It is essential to create and maintain backups in any database management system. There is a range of scenarios that confirm this statement. Hardware failures, software or user errors, malicious attacks, or system issues can lead to a corrupted database. Even if your database management systems have never experienced such scenarios, you have to be prepared Read more »
Page 3 of 3123