Managing SQL Servers in multi-server environment via Central Management Server, Policy Management, Power Shell and Reporting Services – 4

And now, our last blog post on these series. I will continue with another series on this topic. This time with my custom scripts and custom reports. Just keep in touch J We are going to visualize our results now. How? We are going to use Reporting Services. If you are not familiar please don’t…


Managing SQL Servers in multi-server environment via Central Management Server, Policy Management, Power Shell and Reporting Services – 3

Time is automating data collection now. It is nothing but just a SQL Server agent job. After going through the usual steps while defining a SQL Agent job, the important thing is choosing “PowerShell” as type on “New Job Step” dialog. And as a command you should type the same command as you configured before…

2

Managing SQL Servers in multi-server environment via Central Management Server, Policy Management, Power Shell and Reporting Services – 2

Collection of Evaluated Policies: To collect results, firstly of course we need a database. But, don’t worry about that actually it is the easiest part since we have a ready script for that. The only thing you need to do is downloading EPMFramework from the link http://epmframework.codeplex.com/releases/view/28621 I haven’t changed the default download path and…


Managing SQL Servers in multi-server environment via Central Management Server, Policy Management, Power Shell and Reporting Services – 1

Nowadays, one of my trendy topics @my customers is multi server management. I will make a few blog posts regarding on this topic. Firstly, even though it is very basic I will start with Central Management Server and Policy Based Management, and then merge them with Reporting Services. I will mainly refer http://epmframework.codeplex.com/ during these…

1