Subscribe to this blog
SQLSailor.com
Archives: February 2013
Get Database information in mail using PowerShell !
Would you love to get a weekly status report of all the databases hosted on your mission critical servers? ,Would you love to get a report which will help you maintain and manage your large shared SQLServer environments neat and clean?
If your answer is Yes, then powershell is your… Read more
2 comments, 250 reads
Posted in SQLSailor.com on 26 February 2013
Check the version of Windows Installer !
This post is a quick tip to find the version of Windows Installer installed on your box.
You might wonder why I ever need to check this version, so here is my small story -
Today I was installing SQLServer 2008 Upgrade advisor for a Windows Server 2003(SP2) box(Pretty old… Read more
0 comments, 207 reads
Posted in SQLSailor.com on 9 February 2013
Quick alert on servers which are not compliant for policies set using PBM
Last month I wrote about leveraging policy based management for regular DBA compliance checks. You can read that post here.
Policy based management(PBM) is indeed one of my favorite features. I normally like to play around exploring more and more about it, and eventually end up learning something new(Yay!). Read more
0 comments, 165 reads
Posted in SQLSailor.com on 6 February 2013