Category Archives: SQLServer

Monitor failed SQL jobs in Nagios

This script can be used to monitor for failed SQL agent jobs in Nagios. It requires python-argparse and python-pymssql which can be installed like this in debian Linux: sudo yum install pymssql Sudo yum install python-argparse Script is then run … Continue reading

Posted in Nagios, SQLServer | Tagged , , | Leave a comment

Replicate logins and jobs in #SQLServer #AlwaysOn environments

After working for a while with SQl 2012 and AlwaysOn it becomes clear that keeping logins, jobs and other uncontained objects in sync between different hosts is a problem. Maybe not if your running a small cluster with only 2 … Continue reading

Posted in SQLServer | Tagged | Leave a comment

Use SQL Server Central Management Server remotley through powershell

Ever wanted to run a scheduled powershell script that uses the CentralManagementServer to connect to all your SQL servers ? After trying out a bunch of diffrerent solutions I found this piece of code on a Microsoft blog. I have … Continue reading

Posted in SQLServer | Tagged , | Leave a comment