Jaa


isilefe

how to collect data for troubleshooting SQL Servers via sqldiag

Nowadays, I am reviewing the tools for troubleshooting SQL Servers since I will deliver a training...

Date: 05/14/2014

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...

Date: 03/02/2014

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...

Date: 03/01/2014

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,...

Date: 03/01/2014

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...

Date: 03/01/2014

differences between quorum models in windows 2003, 2008, 2008R2, 2012 and 2012 R2

In this blog post, the differences between the quorum models for Windows Server Clusters 2003, 2008,...

Date: 02/26/2014

how to find long-running queries and send as an email

Long running queries for SQL Server can cause many problems and it is deadly important to find them...

Date: 02/24/2014

checking the status of SQL services and databases on multiserver environment

If you have only one SQL Server to check, it is quite straightforward to check the status of...

Date: 01/21/2014

collecting performance data for SQL Server via Powershell

Performance Monitor is a Windowds-based tool which has also very effective counters for SQL Server....

Date: 11/05/2013

how to manage your SQL Servers with Central Mangement Server and Powershell

One of the features I like most with 2008 is Central Management Server. CMS introduces us with multi...

Date: 07/23/2012